components/com_finder/src/Model/SuggestionsModel.php - 5.4-dev - githubmirror/joomla-cms

components/com_finder/src/Model/SuggestionsModel.php
182 строки6 KB
Nicola Galgano
[5.2]postgres and finder suggestions (#44384)
27 ноя 2024, 17:07
27 ноя 2024, 17:07d685790
<?php

/**
 * @package     Joomla.Site
 * @subpackage  com_finder
 *
 * @copyright   (C) 2011 Open Source Matters, Inc. <https://www.joomla.org>
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 */

namespace Joomla\Component\Finder\Site\Model;

use Joomla\CMS\Component\ComponentHelper;
use Joomla\CMS\Factory;
use Joomla\CMS\Language\Multilanguage;
use Joomla\CMS\MVC\Model\ListModel;
use Joomla\Component\Finder\Administrator\Indexer\Helper;
use Joomla\Database\QueryInterface;
use Joomla\String\StringHelper;
use Joomla\Utilities\ArrayHelper;

// phpcs:disable PSR1.Files.SideEffects
\defined('_JEXEC') or die;
// phpcs:enable PSR1.Files.SideEffects

/**
 * Suggestions model class for the Finder package.
 *
 * @since  2.5
 */
class SuggestionsModel extends ListModel
{
    /**
     * Context string for the model type.
     *
     * @var    string
     * @since  2.5
     */
    protected $context = 'com_finder.suggestions';

    /**
     * Method to get an array of data items.
     *
     * @return  array  An array of data items.
     *
     * @since   2.5
     */
    public function getItems()
    {
        // Get the items.
        $items = parent::getItems();

        // Convert them to a simple array.
        foreach ($items as $k => $v) {
            $items[$k] = $v->term;
        }

        return $items;
    }

    /**
     * Method to build a database query to load the list data.
     *
     * @return  QueryInterface  A database query
     *
     * @since   2.5
     */
    protected function getListQuery()
    {
        $user   = $this->getCurrentUser();
        $groups = ArrayHelper::toInteger($user->getAuthorisedViewLevels());
        $lang   = Helper::getPrimaryLanguage($this->getState('language'));

        // Create a new query object.
        $db          = $this->getDatabase();
        $termIdQuery = $db->getQuery(true);
        $termQuery   = $db->getQuery(true);
        $aQuery      = $db->getQuery(true);

        // Limit term count to a reasonable number of results to reduce main query join size
        $termIdQuery->select('ti.term_id')
            ->from($db->quoteName('#__finder_terms', 'ti'))
            ->where('ti.term LIKE ' . $db->quote($db->escape(StringHelper::strtolower($this->getState('input')), true) . '%', false))
            ->where('ti.common = 0')
            ->where('ti.language IN (' . $db->quote($lang) . ', ' . $db->quote('*') . ')')
            ->order('ti.links DESC')
            ->order('ti.weight DESC');

        $termIds = $db->setQuery($termIdQuery, 0, 100)->loadColumn();

        // Early return on term mismatch
        if (!\count($termIds)) {
            return $termIdQuery;
        }

        // Select required fields
        $termQuery->select('t.term, t.links, t.weight')
            ->from($db->quoteName('#__finder_terms', 't'))
            ->where('t.term_id in (' . implode(',', $termIds) . ')')
            ->order('t.links DESC')
            ->order('t.weight DESC');

        // Join mapping table for term <-> link relation
        $mappingTable = $db->quoteName('#__finder_links_terms', 'tm');
        $termQuery->join('INNER', $mappingTable . ' ON tm.term_id = t.term_id');

        // Join links table
        $termQuery->join('INNER', $db->quoteName('#__finder_links', 'l') . ' ON (tm.link_id = l.link_id)')
            ->where('l.access IN (' . implode(',', $groups) . ')')
            ->where('l.state = 1')
            ->where('l.published = 1');
        $aQuery->select('DISTINCT o.term')->from('(' . $termQuery . ') AS o');
        return $aQuery;
    }

    /**
     * Method to get a store id based on model the configuration state.
     *
     * This is necessary because the model is used by the component and
     * different modules that might need different sets of data or different
     * ordering requirements.
     *
     * @param   string  $id  An identifier string to generate the store id. [optional]
     *
     * @return  string  A store id.
     *
     * @since   2.5
     */
    protected function getStoreId($id = '')
    {
        // Add the search query state.
        $id .= ':' . $this->getState('input');
        $id .= ':' . $this->getState('language');

        // Add the list state.
        $id .= ':' . $this->getState('list.start');
        $id .= ':' . $this->getState('list.limit');

        return parent::getStoreId($id);
    }

    /**
     * Method to auto-populate the model state.  Calling getState in this method will result in recursion.
     *
     * @param   string  $ordering   An optional ordering field.
     * @param   string  $direction  An optional direction (asc|desc).
     *
     * @return  void
     *
     * @since   2.5
     */
    protected function populateState($ordering = null, $direction = null)
    {
        // Get the configuration options.
        $app    = Factory::getApplication();
        $input  = $app->getInput();
        $params = ComponentHelper::getParams('com_finder');
        $user   = $this->getCurrentUser();

        // Get the query input.
        $this->setState('input', $input->request->get('q', '', 'string'));

        // Set the query language
        if (Multilanguage::isEnabled()) {
            $lang = Factory::getLanguage()->getTag();
        } else {
            $lang = Helper::getDefaultLanguage();
        }

        $this->setState('language', $lang);

        // Load the list state.
        $this->setState('list.start', 0);
        $this->setState('list.limit', 10);

        // Load the parameters.
        $this->setState('params', $params);

        // Load the user state.
        $this->setState('user.id', (int) $user->id);
    }
}