1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?php
/**
* Piwik - Open source web analytics
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html Gpl v3 or later
* @version $Id$
*
* @package Piwik_DataTable
*/
/**
* Sort the DataTable based on the value of column $columnToSort ordered by $order.
* Possible to specify a natural sorting (see php.net/natsort for details)
* @package Piwik_DataTable
* @subpackage Piwik_DataTable_Filter
*/
class Piwik_DataTable_Filter_Sort extends Piwik_DataTable_Filter
{
protected $columnToSort;
protected $order;
public function __construct( $table, $columnToSort, $order = 'desc', $naturalSort = false )
{
parent::__construct($table);
// hack... But I can't see how to do properly
if($columnToSort == '0')
{
$columnToSort = 'label';
}
$this->columnToSort = $columnToSort;
$this->naturalSort = $naturalSort;
$this->setOrder($order);
$this->filter();
}
function setOrder($order)
{
if($order == 'asc')
{
$this->order = 'asc';
$this->sign = 1;
}
else
{
$this->order = 'desc';
$this->sign = -1;
}
}
function sort($a, $b)
{
return $this->sign *
($a->c[Piwik_DataTable_Row::COLUMNS][$this->columnToSort]
< $b->c[Piwik_DataTable_Row::COLUMNS][$this->columnToSort]
? -1
: 1
);
}
function naturalSort($a, $b)
{
return $this->sign * strnatcasecmp(
$a->c[Piwik_DataTable_Row::COLUMNS][$this->columnToSort],
$b->c[Piwik_DataTable_Row::COLUMNS][$this->columnToSort]
);
}
function sortString($a, $b)
{
return $this->sign *
strcasecmp($a->c[Piwik_DataTable_Row::COLUMNS][$this->columnToSort],
$b->c[Piwik_DataTable_Row::COLUMNS][$this->columnToSort]
);
}
protected function filter()
{
if($this->table instanceof Piwik_DataTable_Simple)
{
return;
}
$rows = $this->table->getRows();
if(count($rows) == 0)
{
return;
}
$row = current($rows);
$value = $row->getColumn($this->columnToSort);
if($value === false)
{
// we don't throw the exception because we sometimes export a DataTable without a column labelled '2'
// and when the generic filters tries to sort by default using this column 2, this shouldnt raise an exception...
//throw new Exception("The column to sort by '".$this->columnToSort."' is unknown in the row ". implode(array_keys($row->getColumns()), ','));
return;
}
if( Piwik::isNumeric($value))
{
$methodToUse = "sort";
}
else
{
if($this->naturalSort)
{
$methodToUse = "naturalSort";
}
else
{
$methodToUse = "sortString";
}
}
$this->table->sort( array($this,$methodToUse) );
}
}
|