public function handle(SelectQuery $query, Criterion $criterion, $column)
{
$column = $this->dbHandler->quoteColumn($column);
switch ($criterion->operator) {
case Criterion\Operator::IN:
$filter = $query->expr->in($column, array_map(array($this, 'lowercase'), $criterion->value));
break;
case Criterion\Operator::BETWEEN:
$filter = $query->expr->between($column, $query->bindValue($this->lowercase($criterion->value[0])), $query->bindValue($this->lowercase($criterion->value[1])));
break;
case Criterion\Operator::EQ:
case Criterion\Operator::GT:
case Criterion\Operator::GTE:
case Criterion\Operator::LT:
case Criterion\Operator::LTE:
case Criterion\Operator::LIKE:
$operatorFunction = $this->comparatorMap[$criterion->operator];
$filter = $query->expr->{$operatorFunction}($column, $query->bindValue($this->lowercase($criterion->value)));
break;
case Criterion\Operator::CONTAINS:
$filter = $query->expr->like($column, $query->bindValue('%' . $this->lowercase($criterion->value) . '%'));
break;
default:
throw new RuntimeException("Unknown operator '{$criterion->operator}' for Field criterion handler.");
}
return $filter;
}