protected function getSqlOperator($value, $operator)
{
if ($operator === ConditionParserHelper::OPERATOR_EQUAL) {
if (is_array($value)) {
$operator = ' IN ';
return $operator;
} elseif ($value === null) {
$operator = ' IS ';
return $operator;
} else {
$operator = ' = ';
return $operator;
}
} elseif ($operator === ConditionParserHelper::OPERATOR_NOT_EQUAL) {
if (is_array($value)) {
$operator = ' NOT IN ';
return $operator;
} elseif ($value === null) {
$operator = ' IS NOT ';
return $operator;
} else {
$operator = ' != ';
return $operator;
}
} else {
$operator = " {$operator} ";
return $operator;
}
}