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

Method applyFilterOptions

lib/Db/StorageMapper.php:322–352  ·  view source on GitHub ↗
(IQueryBuilder $sql, $options)

Source from the content-addressed store, hash-verified

320 }
321
322 private function applyFilterOptions(IQueryBuilder $sql, $options): void
323 {
324 if (!isset($options['filter']) || !is_array($options['filter'])) {
325 return;
326 }
327
328 foreach ($this->groupFiltersByDimension($options['filter']) as $dimension => $filters) {
329 $column = $this->getAllowedFilterColumn($dimension);
330 if ($column === null) {
331 continue;
332 }
333
334 $expressions = [];
335 foreach ($filters as $filter) {
336 $expression = $this->buildFilterExpression($sql, $column, $filter['option'], $filter['value']);
337 if ($expression !== null) {
338 if ($filter['option'] === 'NOTIN') {
339 $sql->andWhere($expression);
340 } else {
341 $expressions[] = $expression;
342 }
343 }
344 }
345
346 if (count($expressions) === 1) {
347 $sql->andWhere($expressions[0]);
348 } elseif (count($expressions) > 1) {
349 $sql->andWhere($sql->expr()->orX(...$expressions));
350 }
351 }
352 }
353
354 private function groupFiltersByDimension(array $filters): array
355 {

Callers 4

readMethod · 0.95
readRawMethod · 0.95
deleteWithFilterMethod · 0.95

Calls 4

buildFilterExpressionMethod · 0.95
countFunction · 0.50

Tested by

no test coverage detected