| 342 | } |
| 343 | |
| 344 | private function filterExpression(IQueryBuilder $sql, string $field, string $operator, mixed $value): mixed { |
| 345 | if ($operator === 'EQ' && $value === null) { |
| 346 | return $sql->expr()->isNull($field); |
| 347 | } |
| 348 | if ($operator === 'IN' || $operator === 'NOTIN') { |
| 349 | $name = 'flexIn' . (++$this->parameterCounter); |
| 350 | $sql->setParameter($name, $value, IQueryBuilder::PARAM_STR_ARRAY); |
| 351 | return $operator === 'NOTIN' |
| 352 | ? $sql->expr()->notIn($field, $sql->createParameter($name)) |
| 353 | : $sql->expr()->in($field, $sql->createParameter($name)); |
| 354 | } |
| 355 | if ($operator === 'BETWEEN') { |
| 356 | return $sql->expr()->andX( |
| 357 | $sql->expr()->gte($field, $sql->createNamedParameter($value[0])), |
| 358 | $sql->expr()->lte($field, $sql->createNamedParameter($value[1])) |
| 359 | ); |
| 360 | } |
| 361 | if ($operator === 'LIKE' || $operator === 'NOTLIKE') { |
| 362 | $pattern = $this->db->escapeLikeParameter((string)$value); |
| 363 | $pattern = strpbrk((string)$value, '*?') === false |
| 364 | ? '%' . $pattern . '%' |
| 365 | : str_replace(['*', '?'], ['%', '_'], $pattern); |
| 366 | $expression = $sql->expr()->like($field, $sql->createNamedParameter($pattern)); |
| 367 | return $operator === 'NOTLIKE' ? 'NOT (' . $expression . ')' : $expression; |
| 368 | } |
| 369 | return match ($operator) { |
| 370 | 'EQ' => $sql->expr()->eq($field, $sql->createNamedParameter($value)), |
| 371 | 'GT' => $sql->expr()->gt($field, $sql->createNamedParameter($value)), |
| 372 | 'LT' => $sql->expr()->lt($field, $sql->createNamedParameter($value)), |
| 373 | default => throw new \InvalidArgumentException('Unsupported filter operator'), |
| 374 | }; |
| 375 | } |
| 376 | |
| 377 | private function valueAlias(array $column): string { |
| 378 | return 'v' . (int)$column['id']; |