|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* Order and search component handling generation of ordering and |
|
5
|
|
|
* searching conditions in loading data tables. |
|
6
|
|
|
* |
|
7
|
|
|
* phpMyAdmin Error reporting server |
|
8
|
|
|
* Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/) |
|
9
|
|
|
* |
|
10
|
|
|
* Licensed under The MIT License |
|
11
|
|
|
* For full copyright and license information, please see the LICENSE.txt |
|
12
|
|
|
* Redistributions of files must retain the above copyright notice. |
|
13
|
|
|
* |
|
14
|
|
|
* @copyright Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/) |
|
15
|
|
|
* @license https://opensource.org/licenses/mit-license.php MIT License |
|
16
|
|
|
* |
|
17
|
|
|
* @see https://www.phpmyadmin.net/ |
|
18
|
|
|
*/ |
|
19
|
|
|
|
|
20
|
|
|
namespace App\Controller\Component; |
|
21
|
|
|
|
|
22
|
|
|
use Cake\Controller\Component; |
|
23
|
|
|
use function array_keys; |
|
24
|
|
|
use function count; |
|
25
|
|
|
use function intval; |
|
26
|
|
|
|
|
27
|
|
|
/** |
|
28
|
|
|
* Github api component handling comunication with github. |
|
29
|
|
|
*/ |
|
30
|
|
|
class OrderSearchComponent extends Component |
|
31
|
|
|
{ |
|
32
|
|
|
/** |
|
33
|
|
|
* Indexes are +1'ed because first column is of checkboxes |
|
34
|
|
|
* and hence it should be ingnored. |
|
35
|
|
|
* |
|
36
|
|
|
* @param string[] $aColumns The columns |
|
37
|
|
|
* |
|
38
|
|
|
* @return array |
|
39
|
|
|
*/ |
|
40
|
8 |
|
public function getSearchConditions(array $aColumns): array |
|
41
|
|
|
{ |
|
42
|
8 |
|
$searchConditions = ['OR' => []]; |
|
43
|
8 |
|
$keys = array_keys($aColumns); |
|
44
|
8 |
|
$columnsCount = count($aColumns); |
|
45
|
|
|
|
|
46
|
8 |
|
$sSearch = $this->request->query('sSearch'); |
|
|
|
|
|
|
47
|
8 |
|
if ($sSearch !== '' && $sSearch !== null) { |
|
48
|
4 |
|
for ($i = 0; $i < $columnsCount; ++$i) { |
|
49
|
4 |
|
if ($this->request->query('bSearchable_' . ($i + 1)) !== 'true') { |
|
|
|
|
|
|
50
|
4 |
|
continue; |
|
51
|
|
|
} |
|
52
|
|
|
|
|
53
|
4 |
|
$searchConditions['OR'][] = [$aColumns[$keys[$i]] . ' LIKE' => '%' . $sSearch . '%']; |
|
|
|
|
|
|
54
|
|
|
} |
|
55
|
|
|
} |
|
56
|
|
|
|
|
57
|
|
|
/* Individual column filtering */ |
|
58
|
8 |
|
for ($i = 0; $i < $columnsCount; ++$i) { |
|
59
|
8 |
|
$searchTerm = $this->request->query('sSearch_' . ($i + 1)); |
|
|
|
|
|
|
60
|
8 |
|
if ($searchTerm === '' || $searchTerm === null) { |
|
61
|
8 |
|
continue; |
|
62
|
|
|
} |
|
63
|
|
|
|
|
64
|
4 |
|
$searchConditions[] = [$aColumns[$keys[$i]] . ' LIKE' => $searchTerm]; |
|
65
|
|
|
} |
|
66
|
|
|
|
|
67
|
8 |
|
return $searchConditions; |
|
68
|
|
|
} |
|
69
|
|
|
|
|
70
|
|
|
/** |
|
71
|
|
|
* @param string[] $aColumns The columns |
|
72
|
|
|
* |
|
73
|
|
|
* @return array|null |
|
74
|
|
|
*/ |
|
75
|
8 |
|
public function getOrder(array $aColumns): ?array |
|
76
|
|
|
{ |
|
77
|
8 |
|
if ($this->request->query('iSortCol_0') !== null) { |
|
|
|
|
|
|
78
|
4 |
|
$order = []; |
|
79
|
|
|
//Seems like we need to sort with only one column each time, so no need to loop |
|
80
|
4 |
|
$sort_column_index = intval($this->request->query('iSortCol_0')); |
|
|
|
|
|
|
81
|
|
|
|
|
82
|
4 |
|
$keys = array_keys($aColumns); |
|
83
|
|
|
|
|
84
|
4 |
|
if ($sort_column_index > 0 |
|
85
|
4 |
|
&& $this->request->query('bSortable_' . $sort_column_index) === 'true' |
|
|
|
|
|
|
86
|
|
|
) { |
|
87
|
|
|
$order[$aColumns[$keys[$sort_column_index - 1]]] = $this->request->query('sSortDir_0'); |
|
|
|
|
|
|
88
|
|
|
} |
|
89
|
|
|
|
|
90
|
4 |
|
return $order; |
|
91
|
|
|
} |
|
92
|
|
|
|
|
93
|
8 |
|
return null; |
|
94
|
|
|
} |
|
95
|
|
|
} |
|
96
|
|
|
|
phpmyadmin /
error-reporting-server
Loading history...
This function has been deprecated. The supplier of the function has supplied an explanatory message.
The explanatory message should give you some clue as to whether and when the function will be removed and what other function to use instead.