SearchQuery::prepareAndNormalize

public SearchQuery::prepareAndNormalize()

public function prepareAndNormalize() {
  $this->parseSearchExpression();
  $this->executedPrepare = TRUE;

  if (count($this->words) == 0) {
    // Although the query could proceed, there is no point in joining
    // with other tables and attempting to normalize if there are no
    // keywords present.
    $this->status |= SearchQuery::NO_POSITIVE_KEYWORDS;
    return FALSE;
  }

  // Build the basic search query: match the entered keywords.
  $or = db_or();
  foreach ($this->words as $word) {
    $or->condition('i.word', $word);
  }
  $this->condition($or);

  // Add keyword normalization information to the query.
  $this->join('search_total', 't', 'i.word = t.word');
  $this
  ->condition('i.type', $this->type)
    ->groupBy('i.type')
    ->groupBy('i.sid');

  // If the query is simple, we should have calculated the number of
  // matching words we need to find, so impose that criterion. For non-
  // simple queries, this condition could lead to incorrectly deciding not
  // to continue with the full query.
  if ($this->simple) {
    $this->having('COUNT(*) >= :matches', array(':matches' => $this->matches));
  }

  // Clone the query object to calculate normalization.
  $normalize_query = clone $this->query;

  // For complex search queries, add the LIKE conditions; if the query is
  // simple, we do not need them for normalization.
  if (!$this->simple) {
    $normalize_query->join('search_dataset', 'd', 'i.sid = d.sid AND i.type = d.type AND i.langcode = d.langcode');
    if (count($this->conditions)) {
      $normalize_query->condition($this->conditions);
    }
  }

  // Calculate normalization, which is the max of all the search scores for
  // positive keywords in the query. And note that the query could have other
  // fields added to it by the user of this extension.
  $normalize_query->addExpression('SUM(i.score * t.count)', 'calculated_score');
  $result = $normalize_query
  ->range(0, 1)
    ->orderBy('calculated_score', 'DESC')
    ->execute()
    ->fetchObject();
  if (isset($result->calculated_score)) {
    $this->normalize = (float) $result->calculated_score;
  }

  if ($this->normalize) {
    return TRUE;
  }

  // If the normalization value was zero, that indicates there were no
  // matches to the supplied positive keywords.
  $this->status |= SearchQuery::NO_KEYWORD_MATCHES;
  return FALSE;
}