function views_handler_filter_search::query in Views (for Drupal 7) 6.3

Same name and namespace in other branches

1. 6.2 modules/search/views_handler_filter_search.inc \views_handler_filter_search::query()
2. 7.3 modules/search/views_handler_filter_search.inc \views_handler_filter_search::query()

Add this filter to the query.

Due to the nature of fapi, the value and the operator have an unintended level of indirection. You will find them in $this->operator and $this->value respectively.

Overrides views_handler_filter::query

File

modules/search/views_handler_filter_search.inc, line 78

Class

views_handler_filter_search

Field handler to provide simple renderer that allows linking to a node.

Code

function query() {
  if (!isset($this->search_query) || empty($this->search_query[3])) {
    if ($this->operator == 'required') {
      $this->query
        ->add_where($this->options['group'], 'FALSE');
    }
  }
  else {
    $search_index = $this
      ->ensure_my_table();
    $this->search_query[2] = str_replace('i.', "{$search_index}.", $this->search_query[2]);

    // Create a new join to relate the 'serach_total' table to our current 'search_index' table.
    $join = new views_join();
    $join
      ->construct('search_total', $search_index, 'word', 'word');
    $search_total = $this->query
      ->add_relationship('search_total', $join, $search_index);
    $this->search_score = $this->query
      ->add_field('', "SUM({$search_index}.score * {$search_total}.count)", 'score', array(
      'aggregate' => TRUE,
    ));
    $this->query
      ->add_where($this->options['group'], $this->search_query[2], $this->search_query[3]);
    if (empty($this->query->relationships[$this->relationship])) {
      $base_table = $this->query->base_table;
    }
    else {
      $base_table = $this->query->relationships[$this->relationship]['base'];
    }
    $this->query
      ->add_where($this->options['group'], "{$search_index}.type = '%s'", $base_table);
    if (!$this->search_query[5]) {
      $search_dataset = $this->query
        ->add_table('search_dataset');
      $this->search_query[0] = str_replace('d.', "{$search_dataset}.", $this->search_query[0]);
      $this->query
        ->add_where($this->options['group'], $this->search_query[0], $this->search_query[1]);
    }
    $this->query
      ->add_groupby("{$search_index}.sid");
    $this->query
      ->add_having($this->options['group'], 'COUNT(*) >= %d', $this->search_query[4]);
  }
}