This repository has been archived by the owner on Jul 22, 2022. It is now read-only.
-
-
Notifications
You must be signed in to change notification settings - Fork 93
/
ChoiceFilter.php
84 lines (71 loc) · 2.28 KB
/
ChoiceFilter.php
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
<?php
declare(strict_types=1);
/*
* This file is part of the Sonata Project package.
*
* (c) Thomas Rabaix <thomas.rabaix@sonata-project.org>
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
namespace Sonata\DoctrinePHPCRAdminBundle\Filter;
use Sonata\AdminBundle\Datagrid\ProxyQueryInterface;
use Sonata\AdminBundle\Form\Type\Filter\ChoiceType;
class ChoiceFilter extends Filter
{
/**
* {@inheritdoc}
*/
public function filter(ProxyQueryInterface $proxyQuery, $alias, $field, $data)
{
if (!$data || !\is_array($data) || !\array_key_exists('type', $data) || !\array_key_exists('value', $data)) {
return;
}
$values = (array) $data['value'];
$type = $data['type'];
// clean values
foreach ($values as $key => $value) {
$value = trim((string) $value);
if (!$value) {
unset($values[$key]);
} else {
$values[$key] = $value;
}
}
// if values not set or "all" specified, do not do this filter
if (!$values || \in_array('all', $values, true)) {
return;
}
$andX = $this->getWhere($proxyQuery)->andX();
foreach ($values as $value) {
if (ChoiceType::TYPE_NOT_CONTAINS === $type) {
$andX->not()->like()->field('a.'.$field)->literal('%'.$value.'%');
} elseif (ChoiceType::TYPE_CONTAINS === $type) {
$andX->like()->field('a.'.$field)->literal('%'.$value.'%');
} elseif (ChoiceType::TYPE_EQUAL === $type) {
$andX->like()->field('a.'.$field)->literal($value);
}
}
// filter is active as we have now modified the query
$this->active = true;
}
/**
* {@inheritdoc}
*/
public function getDefaultOptions()
{
return [];
}
/**
* {@inheritdoc}
*/
public function getRenderSettings()
{
return ['sonata_type_filter_default', [
'operator_type' => 'sonata_type_equal',
'field_type' => $this->getFieldType(),
'field_options' => $this->getFieldOptions(),
'label' => $this->getLabel(),
]];
}
}