/**
* Prepare single criteria condition with field, operator and value
*
* @param string $field the backend field name
* @param string $operator the operator used to filter
* @param string|array $value the value(s) to filter
*
* @throws ProductQueryException
* @throws \InvalidArgumentException
*
* @return string
*/
protected function prepareSingleCriteriaCondition($field, $operator, $value)
{
$operators = [Operators::EQUALS => 'eq', Operators::NOT_EQUAL => 'neq', Operators::LOWER_THAN => 'lt', Operators::LOWER_OR_EQUAL_THAN => 'lte', Operators::GREATER_THAN => 'gt', Operators::GREATER_OR_EQUAL_THAN => 'gte', Operators::IS_LIKE => 'like', Operators::NOT_LIKE => 'notLike'];
if (array_key_exists($operator, $operators)) {
if (!is_scalar($value)) {
throw new \InvalidArgumentException(sprintf('Only scalar values are allowed for operators %s.', implode(', ', $operators)));
}
$method = $operators[$operator];
$condition = $this->qb->expr()->{$method}($field, $this->qb->expr()->literal($value));
return is_object($condition) ? $condition->__toString() : $condition;
}
$operators = [Operators::IS_NULL => 'isNull', Operators::IS_NOT_NULL => 'isNotNull', Operators::IS_EMPTY => 'isNull', Operators::IS_NOT_EMPTY => 'isNotNull'];
if (array_key_exists($operator, $operators)) {
$method = $operators[$operator];
return $this->qb->expr()->{$method}($field);
}
$operators = [Operators::IN_LIST => 'in', Operators::NOT_IN_LIST => 'notIn'];
if (array_key_exists($operator, $operators)) {
if (!is_array($value)) {
throw new \InvalidArgumentException(sprintf('Only array values are allowed for operators %s.', implode(', ', $operators)));
}
if (0 === count($value)) {
throw InvalidArgumentException::emptyArray($field);
}
$method = $operators[$operator];
return $this->qb->expr()->{$method}($field, $value)->__toString();
}
if (Operators::BETWEEN === $operator) {
if (!is_array($value)) {
throw new \InvalidArgumentException(sprintf('Only array values are allowed for operator BETWEEN'));
}
return sprintf('%s BETWEEN %s AND %s', $field, $this->qb->expr()->literal($value[0]), $this->qb->expr()->literal($value[1]));
}
throw new ProductQueryException('operator ' . $operator . ' is not supported');
}
