(IQueryBuilder $sql, string $column, string $option, $value)
| 362 | } |
| 363 | |
| 364 | private function buildFilterExpression(IQueryBuilder $sql, string $column, string $option, $value) |
| 365 | { |
| 366 | if (is_array($value)) { |
| 367 | $valueNoQuotes = array_map(function($v) { |
| 368 | return trim($v, "'"); |
| 369 | }, $value); |
| 370 | } else { |
| 371 | $valueNoQuotes = trim($value, "'"); |
| 372 | } |
| 373 | |
| 374 | if ($option === 'EQ') { |
| 375 | return $sql->expr()->eq($column, $sql->createNamedParameter($valueNoQuotes)); |
| 376 | } elseif ($option === 'GT') { |
| 377 | return $sql->expr()->gt($column, $sql->createNamedParameter($valueNoQuotes)); |
| 378 | } elseif ($option === 'LT') { |
| 379 | return $sql->expr()->lt($column, $sql->createNamedParameter($valueNoQuotes)); |
| 380 | } elseif ($option === 'IN' || $option === 'NOTIN') { |
| 381 | preg_match_all("/\\s*'(?:[^'\\\\]|\\\\.)*'|[^,;]+/", $value, $matches); |
| 382 | $valuesArray = array_map(function($v) { |
| 383 | return trim($v, " '"); |
| 384 | }, $matches[0]); |
| 385 | |
| 386 | $parameter = 'inValues' . (++$this->filterParameterCounter); |
| 387 | $sql->setParameter($parameter, $valuesArray, IQueryBuilder::PARAM_STR_ARRAY); |
| 388 | return $option === 'NOTIN' |
| 389 | ? $sql->expr()->notIn($column, $sql->createParameter($parameter)) |
| 390 | : $sql->expr()->in($column, $sql->createParameter($parameter)); |
| 391 | } elseif ($option === 'LIKE') { |
| 392 | return $sql->expr()->like($column, $sql->createNamedParameter($this->buildLikePattern($valueNoQuotes))); |
| 393 | } elseif ($option === 'NOTLIKE') { |
| 394 | return 'NOT (' . $sql->expr()->like($column, $sql->createNamedParameter($this->buildLikePattern($valueNoQuotes))) . ')'; |
| 395 | } elseif ($option === 'BETWEEN') { |
| 396 | if (is_array($value)) { |
| 397 | $start = $value[0]; |
| 398 | $end = $value[1]; |
| 399 | } else { |
| 400 | list($start, $end) = explode(',', $valueNoQuotes, 2); |
| 401 | $start = trim($start); |
| 402 | $end = trim($end); |
| 403 | } |
| 404 | return $sql->expr()->andX( |
| 405 | $sql->expr()->gte($column, $sql->createNamedParameter($start)), |
| 406 | $sql->expr()->lte($column, $sql->createNamedParameter($end)) |
| 407 | ); |
| 408 | } |
| 409 | |
| 410 | return null; |
| 411 | } |
| 412 | |
| 413 | private function buildLikePattern(string $value): string |
| 414 | { |
no test coverage detected