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

Method applyFilters

lib/Db/FlexibleStorageMapper.php:317–342  ·  view source on GitHub ↗

@param list ,operator:string,value:mixed}> $filters */

(IQueryBuilder $sql, array $filters)

Source from the content-addressed store, hash-verified

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) {

Callers 1

queryMethod · 0.95

Calls 4

valueAliasMethod · 0.95
filterExpressionMethod · 0.95
valueFieldMethod · 0.80
countFunction · 0.50

Tested by

no test coverage detected