1 | <?php |
||
17 | class NumberFilter extends Filter |
||
18 | { |
||
19 | /** |
||
20 | * {@inheritdoc} |
||
21 | */ |
||
22 | public function filter(ProxyQueryInterface $queryBuilder, $alias, $field, $data) |
||
23 | { |
||
24 | if (!$data || !is_array($data) || !array_key_exists('value', $data) || !is_numeric($data['value'])) { |
||
25 | return; |
||
26 | } |
||
27 | |||
28 | $type = isset($data['type']) ? $data['type'] : false; |
||
29 | |||
30 | $operator = $this->getOperator($type); |
||
31 | |||
32 | if (!$operator) { |
||
|
|||
33 | $operator = '='; |
||
34 | } |
||
35 | |||
36 | // c.name > '1' => c.name OPERATOR :FIELDNAME |
||
37 | $parameterName = $this->getNewParameterName($queryBuilder); |
||
38 | $this->applyWhere($queryBuilder, sprintf('%s.%s %s :%s', $alias, $field, $operator, $parameterName)); |
||
39 | $queryBuilder->setParameter($parameterName, $data['value']); |
||
40 | } |
||
41 | |||
42 | /** |
||
43 | * {@inheritdoc} |
||
44 | */ |
||
45 | public function getDefaultOptions() |
||
49 | |||
50 | /** |
||
51 | * {@inheritdoc} |
||
52 | */ |
||
53 | public function getRenderSettings() |
||
61 | |||
62 | /** |
||
63 | * @param string $type |
||
64 | * |
||
65 | * @return bool |
||
66 | */ |
||
67 | private function getOperator($type) |
||
79 | } |
||
80 |
In PHP, under loose comparison (like
==
, or!=
, orswitch
conditions), values of different types might be equal.For
string
values, the empty string''
is a special case, in particular the following results might be unexpected: