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

Method buildFilterExpression

lib/Db/StorageMapper.php:364–411  ·  view source on GitHub ↗
(IQueryBuilder $sql, string $column, string $option, $value)

Source from the content-addressed store, hash-verified

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 {

Callers 1

applyFilterOptionsMethod · 0.95

Calls 2

buildLikePatternMethod · 0.95
eqMethod · 0.80

Tested by

no test coverage detected