MCPcopy Create free account
hub / github.com/Rello/analytics / filterExpression

Method filterExpression

lib/Db/FlexibleStorageMapper.php:344–375  ·  view source on GitHub ↗
(IQueryBuilder $sql, string $field, string $operator, mixed $value)

Source from the content-addressed store, hash-verified

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'];

Callers 1

applyFiltersMethod · 0.95

Calls 1

eqMethod · 0.80

Tested by

no test coverage detected