/**
* Process the filters for the query string
*
* @param vB_Legacy_Current_User $user user requesting the search
* @param vB_Search_Criteria $criteria search criteria to process
*/
protected function process_keywords_filters(vB_Search_Criteria &$criteria)
{
$keywords = $criteria->get_keywords();
// nothing to process
if (empty($keywords)) {
return;
}
$words = array();
// get the map table names for the keywords. these tables will be joined into the search query
$has_or_joiner = false;
foreach ($keywords as $word_details) {
$suffix = vBDBSearch_Core::get_table_name($word_details['word']);
//$words[$suffix][$clean_word] = array('wordid'=>false,'joiner'=>$word['joiner']);
$words[$word_details['word']] = array('suffix' => $suffix, 'word' => $word_details['word'], 'joiner' => $word_details['joiner']);
if ($word_details['joiner'] == "OR") {
$has_or_joiner = true;
}
}
// nothing to process
if (empty($words)) {
return;
}
$set = $this->db->query_read_slave($query = "\n\t\t\t\t\tSELECT *\n\t\t\t\t\tFROM " . TABLE_PREFIX . "words as words\n\t\t\t\t\tWHERE " . self::make_equals_filter('words', 'word', array_keys($words)));
$config = vB::getConfig();
if (!empty($config['Misc']['debug_sql']) or self::DEBUG) {
echo "{$query};\n";
}
$wordids = array();
while ($word_details = $this->db->fetch_array($set)) {
$wordids[$word_details['word']] = $word_details['wordid'];
}
$this->db->free_result($set);
$word_details = array();
foreach ($words as $word => $details) {
// if the word was not found
if (!isset($wordids[$word])) {
// and it's not with a NOT or OR operator
if (!$has_or_joiner and $details['joiner'] != 'NOT') {
// this word is not indexed so there is nothing to return
$this->where[] = "0 /** word is not indexed **/";
$this->sort = array('node.created' => 'ASC');
return;
}
// still need to add this word to the mix (either as a NOT operator or maybe as an OR). we use the word itself as a key to make it unique
$key = $word;
$details['wordid'] = 0;
} else {
$key = $details['wordid'] = $wordids[$word];
}
$word_details[$key] = $details;
}
unset($wordids);
unset($words);
if (count($word_details) == 1) {
$this->process_one_word_rank(array_pop($word_details), $criteria->is_title_only());
} elseif ($has_or_joiner or isset($this->sort['rank'])) {
$this->process_existing_words_or($word_details, $criteria->is_title_only());
} else {
$this->process_existing_words_and($word_details, $criteria->is_title_only());
}
}
