<?php

/**
 * Kunena Component
 *
 * @package         Kunena.Site
 * @subpackage      Models
 *
 * @copyright       Copyright (C) 2008 - 2025 Kunena Team. All rights reserved.
 * @license         https://www.gnu.org/copyleft/gpl.html GNU/GPL
 * @link            https://www.kunena.org
 **/

namespace Kunena\Forum\Site\Model;

\defined('_JEXEC') or die();

use DateInterval;
use DateTime;
use Exception;
use Joomla\CMS\Factory;
use Joomla\CMS\Language\Text;
use Joomla\String\StringHelper;
use Joomla\Utilities\ArrayHelper;
use Kunena\Forum\Libraries\Factory\KunenaFactory;
use Kunena\Forum\Libraries\Forum\Message\KunenaMessageHelper;
use Kunena\Forum\Libraries\Forum\Topic\KunenaTopicHelper;
use Kunena\Forum\Libraries\Model\KunenaModel;
use Kunena\Forum\Libraries\Route\KunenaRoute;
use Kunena\Forum\Libraries\User\KunenaUserHelper;

/**
 * Search Model for Kunena
 *
 * @since   Kunena 2.0
 */
class SearchModel extends KunenaModel
{
    /**
     * @var     null
     * @since   Kunena 6.0
     */
    protected $error = null;

    /**
     * @var     boolean
     * @since   Kunena 6.0
     */
    protected $total = false;

    /**
     * @var     boolean
     * @since   Kunena 6.0
     */
    protected $messages = false;

    /**
     * @return  boolean|integer
     *
     * @since   Kunena 6.0
     *
     * @throws  null
     * @throws  Exception
     */
    public function getTotal()
    {
        $text = $this->getState('searchwords');
        $q    = \strlen($text);

        if ($q < 3 && !$this->getState('query.searchuser') && $this->app->input->getString('childforums')) {
            $this->app->enqueueMessage(Text::_('COM_KUNENA_SEARCH_ERR_SHORTKEYWORD'), 'error');

            return 0;
        }

        if ($this->total === false) {
            $this->getResults();
        } else {
            $this->app->enqueueMessage(Text::_('COM_KUNENA_SEARCH_ERR_NOPOSTS'), 'notice');

            return 0;
        }

        return $this->total;
    }

    /**
     * @return  array|boolean
     *
     * @since   Kunena 6.0
     *
     * @throws  null
     * @throws  Exception
     */
    public function getResults()
    {
        if ($this->messages !== false) {
            return $this->messages;
        }

        $text = $this->getState('searchwords');
        $q    = \strlen($text);

        if (!$this->getState('query.searchuser')) {
            if ($q < 3) {
                return false;
            }
        }

        // Get results

        $hold = $this->getState('query.show');

        if ($hold == 1) {
            $mode = 'unapproved';
        } elseif ($hold >= 2) {
            $mode = 'deleted';
        } else {
            $mode = 'recent';
        }

        $params     = [
            'mode'        => $mode,
            'childforums' => $this->getState('query.childforums'),
            'where'       => $this->buildWhere(),
            'orderby'     => $this->buildOrderBy(),
            'starttime'   => -1,
        ];
        $limitstart = $this->getState('list.start');
        $limit      = $this->getState('list.limit');
        list($this->total, $this->messages) = KunenaMessageHelper::getLatestMessages($this->getState('query.catids'), $limitstart, $limit, $params);

        if ($this->total < $limitstart) {
            $this->setState('list.start', \intval($this->total / $limit) * $limit);
        }

        $topicids = [];
        $userids  = [];

        foreach ($this->messages as $message) {
            $topicids[$message->thread] = $message->thread;
            $userids[$message->userid]  = $message->userid;
        }

        if ($topicids) {
            $topics = KunenaTopicHelper::getTopics($topicids);

            foreach ($topics as $topic) {
                $userids[$topic->first_post_userid] = $topic->first_post_userid;
            }
        }

        KunenaUserHelper::loadUsers($userids);
        KunenaMessageHelper::loadLocation($this->messages);

        if (empty($this->messages)) {
            $this->app->enqueueMessage(Text::sprintf('COM_KUNENA_SEARCH_NORESULTS_FOUND', '<strong>' . $text . '</strong>'), 'notice');
        }

        return $this->messages;
    }

    /**
     * @return  string
     *
     * @since   Kunena 6.0
     *
     * @throws  Exception
     */
    protected function buildWhere()
    {
        $db           = $this->getDatabase();
        $querystrings = [];

        foreach ($this->getSearchWords() as $searchword) {
            $searchword = $db->escape(StringHelper::trim($searchword));

            if (empty($searchword)) {
                continue;
            }

            $not      = '';
            $operator = ' OR ';

            if (substr($searchword, 0, 1) == '-' && \strlen($searchword) > 1) {
                $not        = 'NOT';
                $operator   = 'AND';
                $searchword = StringHelper::substr($searchword, 1);
            }

            if (!$this->getState('query.titleonly')) {
                $querystrings [] = "(t.message {$not} LIKE '%{$searchword}%' {$operator} m.subject {$not} LIKE '%{$searchword}%')";
            } else {
                $querystrings [] = "(m.subject {$not} LIKE '%{$searchword}%')";
            }
        }

        if (!$this->config->pubProfile && !Factory::getApplication()->getIdentity()->guest || $this->config->pubProfile) {
            // User searching
            $username = $this->getState('query.searchuser');

            if ($username) {
                if ($this->getState('query.exactname') == '1') {
                    $querystrings [] = "m.name LIKE '" . $db->escape($username) . "'";
                } else {
                    $querystrings [] = "m.name LIKE '%" . $db->escape($username) . "%'";
                }
            }
        }

        $time         = 0;
        $searchatdate = $this->getState('query.searchatdate');

        if (empty($searchatdate) || $searchatdate == Factory::getDate()->format('m/d/Y')) {
            switch ($this->getState('query.searchdate')) {
                case 'lastvisit':
                    $time = KunenaFactory::GetSession()->lasttime;
                    break;
                case 'all':
                    break;
                case '1':
                case '7':
                case '14':
                case '30':
                case '90':
                case '180':
                case '365':
                    $time = time() - 86400 * \intval($this->getState('query.searchdate'));
                    break;
                default:
                    $time = time() - 86400 * 365;
            }

            if ($time) {
                if ($this->getState('query.beforeafter') == 'after') {
                    $querystrings [] = "m.time > '{$time}'";
                } else {
                    $querystrings [] = "m.time <= '{$time}'";
                }
            }
        } else {
            $time_start_day = Factory::getDate($this->getState('query.searchatdate'))->toUnix();
            $time_end_day   = new DateTime($this->getState('query.searchatdate'));
            $time_end_day->add(new DateInterval("PT23H59M59S"));

            $querystrings[] = " m.time > {$time_start_day} AND m.time < {$time_end_day->getTimestamp()}";
        }

        $topic_id = $this->getState('query.topic_id');

        if ($topic_id) {
            $querystrings [] = "m.id = '{$topic_id}'";
        }

        return implode(' AND ', $querystrings);
    }

    /**
     * @return  array
     *
     * @since   Kunena 6.0
     */
    public function getSearchWords()
    {
        // Accept individual words and quoted strings
        $splitPattern = '/[\s,]*\'([^\']+)\'[\s,]*|[\s,]*"([^"]+)"[\s,]*|[\s,]+/u';
        $searchwords  = preg_split($splitPattern, $this->getState('searchwords'), 0, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);

        $result = [];

        foreach ($searchwords as $word) {
            // Do not accept one letter strings
            if (StringHelper::strlen($word) > 1) {
                $result [] = $word;
            }
        }

        return $result;
    }

    /**
     * @return  string
     *
     * @since   Kunena 6.0
     */
    protected function buildOrderBy()
    {
        if ($this->getState('query.order') == 'dec') {
            $order1 = 'DESC';
        } else {
            $order1 = 'ASC';
        }

        switch ($this->getState('query.sortby')) {
            case 'title':
                $orderby = "m.subject {$order1}, m.time {$order1}";
                break;
            case 'views':
                $orderby = "m.hits {$order1}, m.time {$order1}";
                break;
            case 'forum':
                $orderby = "m.catid {$order1}, m.time {$order1}";
                break;
            case 'lastpost':
            default:
                $orderby = "m.time {$order1}";
        }

        return $orderby;
    }

    /**
     * @return  string
     *
     * @since   Kunena 6.0
     */
    public function getUrlParams()
    {
        // Turn internal state into URL, but ignore default values
        $defaults = ['titleonly' => 0, 'searchuser' => '', 'exactname' => 0, 'childforums' => 0, 'starteronly' => 0,
                     'replyless' => 0, 'replylimit' => 0, 'searchdate' => '365', 'beforeafter' => 'after', 'sortby' => 'lastpost',
                     'order'     => 'dec', 'catids' => '0', 'show' => '0', 'topic_id' => 0, 'ids' => 0, 'searchatdate' => '', ];

        $url_params = '';
        $state      = $this->getState();

        foreach ($state as $param => $value) {
            $paramparts = explode('.', $param);

            if ($paramparts[0] != 'query') {
                continue;
            }

            $param = $paramparts[1];

            if ($param == 'catids' || $param == 'ids') {
                $value = implode(' ', $value);
            }

            if ($value != $defaults [$param]) {
                $url_params .= "&$param=" . urlencode($value);
            }
        }

        return $url_params;
    }

    /**
     * @param   string  $view        view
     * @param   string  $searchword  searchword
     * @param   int     $limitstart  limitstart
     * @param   int     $limit       limit
     * @param   string  $params      params
     * @param   bool    $xhtml       xhtml
     *
     * @return  boolean
     *
     * @since   Kunena 6.0
     *
     * @throws  Exception
     * @throws  null
     */
    public function getSearchURL($view, $searchword = '', $limitstart = 0, $limit = 0, $params = '', $xhtml = true)
    {
        $config   = KunenaFactory::getConfig();
        $limitstr = "";

        if ($limitstart > 0) {
            $limitstr .= "&limitstart=$limitstart";
        }

        if ($limit > 0 && $limit != $config->messagesPerPageSearch) {
            $limitstr .= "&limit=$limit";
        }

        if ($searchword) {
            $searchword = '&query=' . urlencode($searchword);
        }

        return KunenaRoute::_("index.php?option=com_kunena&view={$view}{$searchword}{$params}{$limitstr}", $xhtml);
    }

    /**
     * Method to auto-populate the model state.
     *
     * Note. Calling getState in this method will result in recursion.
     *
     * @param   null  $ordering
     * @param   null  $direction
     *
     * @return  void
     *
     * @since   Kunena 6.0
     *
     * @throws Exception
     */
    protected function populateState($ordering = null, $direction = null): void
    {
        // Get search word list
        $value = StringHelper::trim($this->app->input->get('query', '', 'string'));

        if ($value == Text::_('COM_KUNENA_GEN_SEARCH_BOX')) {
            $value = '';
        }

        $this->setState('searchwords', $value);

        $value = Factory::getApplication()->input->getInt('titleonly', 0);
        $this->setState('query.titleonly', $value);

        $value = Factory::getApplication()->input->getString('searchuser', '');
        $this->setState('query.searchuser', rtrim($value));

        $value = Factory::getApplication()->input->getInt('starteronly', 0);
        $this->setState('query.starteronly', $value);

        if (!$this->config->pubProfile && !Factory::getApplication()->getIdentity()->guest || $this->config->pubProfile) {
            $value = Factory::getApplication()->input->getInt('exactname', 0);
            $this->setState('query.exactname', $value);
        }

        $value = Factory::getApplication()->input->getInt('replyless', 0);
        $this->setState('query.replyless', $value);

        $value = Factory::getApplication()->input->getInt('replylimit', 0);
        $this->setState('query.replylimit', $value);

        $value = Factory::getApplication()->input->getString('searchdate', $this->config->searchTime);
        $this->setState('query.searchdate', $value);

        $value = Factory::getApplication()->input->getString('searchatdate', null);
        $this->setState('query.searchatdate', $value);

        $value = Factory::getApplication()->input->getWord('beforeafter', 'after');
        $this->setState('query.beforeafter', $value);

        $value = Factory::getApplication()->input->getWord('sortby', 'lastpost');
        $this->setState('query.sortby', $value);

        $value = Factory::getApplication()->input->getWord('order', 'dec');
        $this->setState('query.order', $value);

        $value = Factory::getApplication()->input->getInt('childforums', 1);
        $this->setState('query.childforums', $value);

        $value = Factory::getApplication()->input->getInt('topic_id', 0);
        $this->setState('query.topic_id', $value);

        if (isset($_POST ['query']) || isset($_POST ['searchword'])) {
            $value = Factory::getApplication()->input->get('catids', [0], 'post', 'array');
            $value = ArrayHelper::toInteger($value);
        } else {
            $value = Factory::getApplication()->input->getString('catids', '0', 'get');
            $value = explode(' ', $value);
            $value = ArrayHelper::toInteger($value);
        }

        $this->setState('query.catids', $value);

        if (isset($_POST ['searchword'])) {
            $value = Factory::getApplication()->input->get('ids', [0], 'post', 'array');
            $value = ArrayHelper::toInteger($value);

            if ($value[0] > 0) {
                $this->setState('query.ids', $value);
            }
        } else {
            $value = Factory::getApplication()->input->getString('ids', '0', 'get');
            $value = explode(' ', (int) $value);
            $value = ArrayHelper::toInteger($value);

            if ($value[0] > 0) {
                $this->setState('query.ids', $value);
            }
        }

        $value = Factory::getApplication()->input->getInt('show', 0);
        $this->setState('query.show', $value);

        $value = $this->getInt('limitstart', 0);

        if ($value < 0) {
            $value = 0;
        }

        $this->setState('list.start', $value);

        $value = $this->getInt('limit', 0);

        if ($value < 1 || $value > 100) {
            $value = $this->config->messagesPerPageSearch;
        }

        $this->setState('list.limit', $value);
    }
}