SortByFunctionAndField.php
2.31 KB
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
<?php
/*
"Contact Form to Database" Copyright (C) 2011-2012 Michael Simpson (email : michael.d.simpson@gmail.com)
This file is part of Contact Form to Database.
Contact Form to Database is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
Contact Form to Database is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Contact Form to Database.
If not, see <http://www.gnu.org/licenses/>.
*/
require_once('SortTransform.php');
require_once('CFDBPermittedFunctions.php');
class SortByFunctionAndField extends SortTransform {
var $functionName;
var $fieldName;
var $reverse;
var $functionPermitted;
/**
* @param $functionName string name of sort function such as strcmp, strcasecmp, strnatcmp
* @param $fieldName
* @param $ascDesc string 'ASC' or 'DESC'
*/
function __construct($functionName, $fieldName, $ascDesc = 'ASC') {
$this->functionName = $functionName;
$this->fieldName = $fieldName;
$this->reverse = strtoupper($ascDesc) == 'DESC';
$this->functionPermitted = CFDBPermittedFunctions::getInstance()->isFunctionPermitted($functionName);
}
/**
* @param $a array associative containing $this->field_name
* @param $b array associative containing $this->field_name
* @return int -1 if $a>$b, 0 if equal, 1 if $a<$b
*/
public function sort($a, $b) {
if (!$this->functionPermitted) {
trigger_error('Function not permitted by CFDB: ' . $this->functionName, E_USER_NOTICE);
return 0;
}
if (!isset($a[$this->fieldName]) || !isset($b[$this->fieldName])) {
return 0; // ambiguous due to field missing
}
$result = call_user_func_array($this->functionName, array($a[$this->fieldName], $b[$this->fieldName]));
if ($this->reverse) {
$result *= -1;
}
return $result;
}
}