(IQueryBuilder $sql, $options)
| 320 | } |
| 321 | |
| 322 | private function applyFilterOptions(IQueryBuilder $sql, $options): void |
| 323 | { |
| 324 | if (!isset($options['filter']) || !is_array($options['filter'])) { |
| 325 | return; |
| 326 | } |
| 327 | |
| 328 | foreach ($this->groupFiltersByDimension($options['filter']) as $dimension => $filters) { |
| 329 | $column = $this->getAllowedFilterColumn($dimension); |
| 330 | if ($column === null) { |
| 331 | continue; |
| 332 | } |
| 333 | |
| 334 | $expressions = []; |
| 335 | foreach ($filters as $filter) { |
| 336 | $expression = $this->buildFilterExpression($sql, $column, $filter['option'], $filter['value']); |
| 337 | if ($expression !== null) { |
| 338 | if ($filter['option'] === 'NOTIN') { |
| 339 | $sql->andWhere($expression); |
| 340 | } else { |
| 341 | $expressions[] = $expression; |
| 342 | } |
| 343 | } |
| 344 | } |
| 345 | |
| 346 | if (count($expressions) === 1) { |
| 347 | $sql->andWhere($expressions[0]); |
| 348 | } elseif (count($expressions) > 1) { |
| 349 | $sql->andWhere($sql->expr()->orX(...$expressions)); |
| 350 | } |
| 351 | } |
| 352 | } |
| 353 | |
| 354 | private function groupFiltersByDimension(array $filters): array |
| 355 | { |
no test coverage detected