Method buildFilterExpression

lib/Db/StorageMapper.php:347–392

(IQueryBuilder $sql, string $column, string $option, $value)

	}

	private function buildFilterExpression(IQueryBuilder $sql, string $column, string $option, $value)
	{
		if (is_array($value)) {
			$valueNoQuotes = array_map(function($v) {
				return trim($v, "'");
			}, $value);
		} else {
			$valueNoQuotes = trim($value, "'");
		}

		if ($option === 'EQ') {
			return $sql->expr()->eq($column, $sql->createNamedParameter($valueNoQuotes));
		} elseif ($option === 'GT') {
			return $sql->expr()->gt($column, $sql->createNamedParameter($valueNoQuotes));
		} elseif ($option === 'LT') {
			return $sql->expr()->lt($column, $sql->createNamedParameter($valueNoQuotes));
		} elseif ($option === 'IN') {
			preg_match_all("/'(?:[^'\\\\]|\\\\.)*'|[^,;]+/", $value, $matches);
			$valuesArray = array_map(function($v) {
				return trim($v, " '");
			}, $matches[0]);

			$parameter = 'inValues' . (++$this->filterParameterCounter);
			$sql->setParameter($parameter, $valuesArray, IQueryBuilder::PARAM_STR_ARRAY);
			return $sql->expr()->in($column, $sql->createParameter($parameter));
		} elseif ($option === 'LIKE') {
			return $sql->expr()->like($column, $sql->createNamedParameter($this->buildLikePattern($valueNoQuotes)));
		} elseif ($option === 'NOTLIKE') {
			return 'NOT (' . $sql->expr()->like($column, $sql->createNamedParameter($this->buildLikePattern($valueNoQuotes))) . ')';
		} elseif ($option === 'BETWEEN') {
			if (is_array($value)) {
				$start = $value[0];
				$end = $value[1];
			} else {
				list($start, $end) = explode(',', $valueNoQuotes, 2);
				$start = trim($start);
				$end = trim($end);
			}
			return $sql->expr()->andX(
				$sql->expr()->gte($column, $sql->createNamedParameter($start)),
				$sql->expr()->lte($column, $sql->createNamedParameter($end))
			);
		}

		return null;
	}

	private function buildLikePattern(string $value): string
	{