1 | <?php |
||
20 | class ModelFilter extends Filter |
||
21 | { |
||
22 | /** |
||
23 | * {@inheritdoc} |
||
24 | */ |
||
25 | public function filter(ProxyQueryInterface $queryBuilder, $alias, $field, $data) |
||
41 | |||
42 | /** |
||
43 | * {@inheritdoc} |
||
44 | */ |
||
45 | public function getDefaultOptions() |
||
60 | |||
61 | /** |
||
62 | * {@inheritdoc} |
||
63 | */ |
||
64 | public function getRenderSettings() |
||
79 | |||
80 | /** |
||
81 | * For the record, the $alias value is provided by the association method (and the entity join method) |
||
82 | * so the field value is not used here. |
||
83 | * |
||
84 | * @param ProxyQueryInterface|QueryBuilder $queryBuilder |
||
85 | * @param string $alias |
||
86 | * @param mixed $data |
||
87 | * |
||
88 | * @return mixed |
||
89 | */ |
||
90 | protected function handleMultiple(ProxyQueryInterface $queryBuilder, $alias, $data) |
||
91 | { |
||
92 | if (count($data['value']) == 0) { |
||
93 | return; |
||
94 | } |
||
95 | |||
96 | $parameterName = $this->getNewParameterName($queryBuilder); |
||
97 | |||
98 | if (isset($data['type']) && $data['type'] == EqualType::TYPE_IS_NOT_EQUAL) { |
||
99 | $or = $queryBuilder->expr()->orX(); |
||
100 | |||
101 | $or->add($queryBuilder->expr()->notIn($alias, ':'.$parameterName)); |
||
102 | |||
103 | $allAliases = $queryBuilder->getAllAliases(); |
||
104 | $or->add($queryBuilder->expr()->isNull(sprintf('IDENTITY(%s.%s)', $allAliases[0], $this->getFieldName()))); |
||
105 | |||
106 | $this->applyWhere($queryBuilder, $or); |
||
107 | } else { |
||
108 | $this->applyWhere($queryBuilder, $queryBuilder->expr()->in($alias, ':'.$parameterName)); |
||
109 | } |
||
110 | |||
111 | $queryBuilder->setParameter($parameterName, $data['value']); |
||
112 | } |
||
113 | |||
114 | /** |
||
115 | * @param ProxyQueryInterface|QueryBuilder $queryBuilder |
||
116 | * @param string $alias |
||
117 | * @param mixed $data |
||
118 | * |
||
119 | * @return mixed |
||
120 | */ |
||
121 | protected function handleModel(ProxyQueryInterface $queryBuilder, $alias, $data) |
||
122 | { |
||
123 | if (empty($data['value'])) { |
||
124 | return; |
||
125 | } |
||
126 | |||
127 | $parameterName = $this->getNewParameterName($queryBuilder); |
||
128 | |||
129 | if (isset($data['type']) && $data['type'] == EqualType::TYPE_IS_NOT_EQUAL) { |
||
130 | $or = $queryBuilder->expr()->orX(); |
||
131 | |||
132 | $or->add($queryBuilder->expr()->neq($alias, ':'.$parameterName)); |
||
133 | |||
134 | $allAliases = $queryBuilder->getAllAliases(); |
||
135 | $or->add($queryBuilder->expr()->isNull(sprintf('IDENTITY(%s.%s)', $allAliases[0], $this->getFieldName()))); |
||
136 | |||
137 | $this->applyWhere($queryBuilder, $or); |
||
138 | } else { |
||
139 | $this->applyWhere($queryBuilder, sprintf('%s = :%s', $alias, $parameterName)); |
||
140 | } |
||
141 | |||
142 | $queryBuilder->setParameter($parameterName, $data['value']); |
||
143 | } |
||
144 | |||
145 | /** |
||
146 | * {@inheritdoc} |
||
147 | */ |
||
148 | protected function association(ProxyQueryInterface $queryBuilder, $data) |
||
167 | } |
||
168 |