@param list ,operator:string,value:mixed}> $filters */
(IQueryBuilder $sql, array $filters)
| 315 | |
| 316 | /** @param list<array{column:array<string,mixed>,operator:string,value:mixed}> $filters */ |
| 317 | private function applyFilters(IQueryBuilder $sql, array $filters): void { |
| 318 | $groups = []; |
| 319 | foreach ($filters as $filter) { |
| 320 | $groups[(int)$filter['column']['id']][] = $filter; |
| 321 | } |
| 322 | foreach ($groups as $columnFilters) { |
| 323 | $positive = []; |
| 324 | $negative = []; |
| 325 | foreach ($columnFilters as $filter) { |
| 326 | $column = $filter['column']; |
| 327 | $field = $this->valueAlias($column) . '.' . FlexibleColumnResolver::valueField($column); |
| 328 | $expression = $this->filterExpression($sql, $field, $filter['operator'], $filter['value']); |
| 329 | if (in_array($filter['operator'], ['NOTLIKE', 'NOTIN'], true)) { |
| 330 | $negative[] = $expression; |
| 331 | } else { |
| 332 | $positive[] = $expression; |
| 333 | } |
| 334 | } |
| 335 | if ($positive !== []) { |
| 336 | $sql->andWhere(count($positive) === 1 ? $positive[0] : $sql->expr()->orX(...$positive)); |
| 337 | } |
| 338 | foreach ($negative as $expression) { |
| 339 | $sql->andWhere($expression); |
| 340 | } |
| 341 | } |
| 342 | } |
| 343 | |
| 344 | private function filterExpression(IQueryBuilder $sql, string $field, string $operator, mixed $value): mixed { |
| 345 | if ($operator === 'EQ' && $value === null) { |
no test coverage detected