function Combine::opContainsWord

Filters by one or more words.

By default opContainsWord uses add_where, that doesn't support complex expressions.

Parameters

string $expression: The expression to add to the query.

Overrides StringFilter::opContainsWord

File

core/modules/views/src/Plugin/views/filter/Combine.php, line 156

Class

Combine

Filter handler which allows to search on multiple fields.

Namespace

Code

protected function opContainsWord($expression) {
    $placeholder = $this->placeholder();
    // Don't filter on empty strings.
    if (empty($this->value)) {
        return;
    }
    // Match all words separated by spaces or sentences encapsulated by double
    // quotes.
    preg_match_all(static::WORDS_PATTERN, ' ' . $this->value, $matches, PREG_SET_ORDER);
    // Switch between the 'word' and 'allwords' operator.
    $type = $this->operator == 'word' ? 'OR' : 'AND';
    $group = $this->query
        ->setWhereGroup($type);
    $operator = $this->getConditionOperator('LIKE');
    foreach ($matches as $match_key => $match) {
        $temp_placeholder = $placeholder . '_' . $match_key;
        // Clean up the user input and remove the sentence delimiters.
        $word = trim($match[2], ',?!();:-"');
        $this->query
            ->addWhereExpression($group, "{$expression} {$operator} {$temp_placeholder}", [
            $temp_placeholder => '%' . $this->connection
                ->escapeLike($word) . '%',
        ]);
    }
}