ElkArte\Search\API\Standard::getResults()

Complexity

Conditions	41
Paths	> 20000

Size

Total Lines	209
Code Lines	114

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	61
CRAP Score	105.3364

Importance

Changes

0

<?php
	public function getResults($id_search)
	{
		global $modSettings;

		$num_results = 0;

		$main_query = [
			'select' => [
				'id_search' => $id_search,
				'relevance' => '0',
			],
			'from' => '{db_prefix}topics AS t',
			'inner_join' => [
				'{db_prefix}messages AS m ON (m.id_topic = t.id_topic)'
			],
			'left_join' => [],
			'where' => [],
			'group_by' => [],
			'parameters' => [
				'min_msg' => $this->_searchParams->_minMsg,
				'recent_message' => $this->_searchParams->_recentMsg,
				'huge_topic_posts' => $this->config->humungousTopicPosts,

The property humungousTopicPosts does not exist on ElkArte\Helper\ValuesContainer. Since you implemented __get, consider adding a @property annotation.

				'short_topic_posts' => $this->config->shortTopicPosts,

The property shortTopicPosts does not exist on ElkArte\Helper\ValuesContainer. Since you implemented __get, consider adding a @property annotation.

				'is_approved' => 1,
				'limit' => $modSettings['search_max_results'],
			],
		];

		if (empty($this->_searchParams['topic']) && empty($this->_searchParams['show_complete']))
		{
			$main_query['select']['id_topic'] = 't.id_topic';
			$main_query['select']['id_msg'] = 'MIN(m.id_msg) AS id_msg';
			$main_query['select']['num_matches'] = 'COUNT(*) AS num_matches';
			$main_query['weights'] = $this->_weight_factors;
			$main_query['group_by'][] = 't.id_topic';
		}
		else
		{
			// This is outrageous!
			$main_query['select']['id_topic'] = 'm.id_msg AS id_topic';
			$main_query['select']['id_msg'] = 'm.id_msg';
			$main_query['select']['num_matches'] = '1 AS num_matches';

			$main_query['weights'] = [
				'age' => [
					'search' => '((m.id_msg - t.id_first_msg) / CASE WHEN t.id_last_msg = t.id_first_msg THEN 1 ELSE t.id_last_msg - t.id_first_msg END)',
				],
				'first_message' => [
					'search' => 'CASE WHEN m.id_msg = t.id_first_msg THEN 1 ELSE 0 END',
				],
				// experimental, give longer messages more weight
				'length' => [
					'search' => '(CASE WHEN LENGTH(m.body) - LENGTH(REPLACE(m.body, " ", "")) > 500 THEN 1 ELSE (LENGTH(m.body) - LENGTH(REPLACE(m.body, " ", "")) / 500) END)',
				],
			];

			if (!empty($this->_searchParams['topic']))
			{
				$main_query['where'][] = 't.id_topic = {int:topic}';
				$main_query['parameters']['topic'] = $this->_searchParams->topic;
			}

			if (!empty($this->_searchParams['show_complete']))
			{
				$main_query['group_by'][] = 'm.id_msg, t.id_first_msg, t.id_last_msg';
			}
		}

		// *** Get the subject results.
		$numSubjectResults = $this->_log_search_subjects($id_search);

		if ($numSubjectResults !== 0)
		{
			$main_query['weights']['subject']['search'] = 'CASE WHEN MAX(lst.id_topic) IS NULL THEN 0 ELSE 1 END';
			$main_query['left_join'][] = '{db_prefix}' . ($this->_createTemporary ? 'tmp_' : '') . 'log_search_topics AS lst ON (' . ($this->_createTemporary ? '' : 'lst.id_search = {int:id_search} AND ') . 'lst.id_topic = t.id_topic)';
			if (!$this->_createTemporary)
			{
				$main_query['parameters']['id_search'] = $id_search;
			}
		}

		// Are we building an index?
		if ($this->useWordIndex())
		{
			$indexedResults = $this->_prepare_word_index($id_search);

			if (empty($indexedResults) && empty($numSubjectResults) && !empty($modSettings['search_force_index']))
			{
				return false;
			}

			if (!empty($indexedResults))
			{
				$main_query['inner_join'][] = '{db_prefix}' . ($this->_createTemporary ? 'tmp_' : '') . 'log_search_messages AS lsm ON (lsm.id_msg = m.id_msg)';

				if (!$this->_createTemporary)
				{
					$main_query['where'][] = 'lsm.id_search = {int:id_search}';
					$main_query['parameters']['id_search'] = $id_search;
				}
			}
		}
		// Not using an index? All conditions have to be carried over.
		else
		{
			$orWhere = [];
			$count = 0;
			$excludedWords = $this->_searchArray->getExcludedWords();
			foreach ($this->_searchWords as $words)
			{
				$where = [];
				foreach ($words['all_words'] as $regularWord)
				{
					$where[] = 'm.body' . (in_array($regularWord, $excludedWords, true) ? ' {not_' : '{') . (empty($modSettings['search_match_words']) || $this->noRegexp() ? 'ilike} ' : 'rlike} ') . '{string:all_word_body_' . $count . '}';
					if (in_array($regularWord, $excludedWords, true))
					{
						$where[] = 'm.subject ' . (empty($modSettings['search_match_words']) || $this->noRegexp() ? ' {not_ilike} ' : ' {not_rlike} ') . '{string:all_word_body_' . $count . '}';
					}

					$main_query['parameters']['all_word_body_' . ($count++)] = $this->prepareWord($regularWord, $this->noRegexp());
				}

				if (!empty($where))
				{
					$orWhere[] = count($where) > 1 ? '(' . implode(' AND ', $where) . ')' : $where[0];
				}
			}

			if (!empty($orWhere))
			{
				$main_query['where'][] = count($orWhere) > 1 ? '(' . implode(' OR ', $orWhere) . ')' : $orWhere[0];
			}

			if (!empty($this->_searchParams->_userQuery))
			{
				$main_query['where'][] = '{raw:user_query}';
				$main_query['parameters']['user_query'] = $this->_searchParams->_userQuery;
			}

			if (!empty($this->_searchParams['topic']))
			{
				$main_query['where'][] = 'm.id_topic = {int:topic}';
				$main_query['parameters']['topic'] = $this->_searchParams->topic;

The property topic does not exist on ElkArte\Search\SearchParams. Since you implemented __get, consider adding a @property annotation.

			}

			if (!empty($this->_searchParams->_minMsgID))
			{
				$main_query['where'][] = 'm.id_msg >= {int:min_msg_id}';
				$main_query['parameters']['min_msg_id'] = $this->_searchParams->_minMsgID;
			}

			if (!empty($this->_searchParams->_maxMsgID))
			{
				$main_query['where'][] = 'm.id_msg <= {int:max_msg_id}';
				$main_query['parameters']['max_msg_id'] = $this->_searchParams->_maxMsgID;
			}

			if (!empty($this->_searchParams->_boardQuery))
			{
				$main_query['where'][] = 'm.id_board {raw:board_query}';
				$main_query['parameters']['board_query'] = $this->_searchParams->_boardQuery;
			}
		}

		call_integration_hook('integrate_main_search_query', [&$main_query]);

		// Did we either get some indexed results or otherwise did not do an indexed query?
		if (!empty($indexedResults) || !$this->useWordIndex())
		{
			$main_query['select']['relevance'] = $this->_build_relevance($main_query['weights']);
			$num_results += $this->_build_search_results_log($main_query);
		}

		// Insert subject-only matches.
		if ($num_results < $modSettings['search_max_results'] && $numSubjectResults !== 0)
		{
			$subject_query = [
				'select' => [
					'id_search' => '{int:id_search}',
					'id_topic' => 't.id_topic',
					'relevance' => $this->_build_relevance(),
					'id_msg' => 't.id_first_msg',
					'num_matches' => 1,
				],
				'from' => '{db_prefix}topics AS t',
				'inner_join' => [
					'{db_prefix}' . ($this->_createTemporary ? 'tmp_' : '') . 'log_search_topics AS lst ON (lst.id_topic = t.id_topic)'
				],
				'where' => [
					$this->_createTemporary ? '1=1' : 'lst.id_search = {int:id_search}',
				],
				'parameters' => [
					'id_search' => $id_search,
					'min_msg' => $this->_searchParams->_minMsg,
					'recent_message' => $this->_searchParams->_recentMsg,
					'huge_topic_posts' => $this->config->humungousTopicPosts,
					'short_topic_posts' => $this->config->shortTopicPosts,
					'limit' => empty($modSettings['search_max_results']) ? 0 : $modSettings['search_max_results'] - $num_results,
				],
			];

			$num_results += $this->_build_search_results_log($subject_query, 'insert_log_search_results_sub_only', true);
		}
		elseif ($num_results === -1)
		{
			$num_results = 0;
		}

		return $num_results;
	}