public static Condition::translateCondition(&$condition, SelectInterface $sql_query, $case_sensitive)
Translates the string operators to SQL equivalents.
Parameters
array $condition: The condition array.
\Drupal\Core\Database\Query\SelectInterface $sql_query: Select query instance.
bool|null $case_sensitive: If the condition should be case sensitive or not, NULL if the field does not define it.
Overrides Condition::translateCondition
See also
\Drupal\Core\Database\Query\ConditionInterface::condition()
File
- core/lib/Drupal/Core/Entity/Query/Sql/pgsql/Condition.php, line 16
Class
- Condition
- Implements entity query conditions for PostgreSQL databases.
Namespace
Drupal\Core\Entity\Query\Sql\pgsql
Code
public static function translateCondition(&$condition, SelectInterface $sql_query, $case_sensitive) {
if (is_array($condition['value']) && $case_sensitive === FALSE) {
$condition['where'] = 'LOWER(' . $sql_query->escapeField($condition['real_field']) . ') ' . $condition['operator'] . ' (';
$condition['where_args'] = [];
$n = 1;
// Only use the array values in case an associative array is passed as an
// argument following similar pattern in
// \Drupal\Core\Database\Connection::expandArguments().
foreach ($condition['value'] as $value) {
$condition['where'] .= 'LOWER(:value' . $n . '),';
$condition['where_args'][':value' . $n] = $value;
$n++;
}
$condition['where'] = trim($condition['where'], ',');
$condition['where'] .= ')';
return;
}
parent::translateCondition($condition, $sql_query, $case_sensitive);
}
Please login to continue.