include/search.inc.php ➔ xoopsfaq_search()

Complexity

Conditions	11
Paths	33

Size

Total Lines

77

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
 *
 * @see \XoopsModules\Xoopsfaq\Helper
 */
function xoopsfaq_search($queryarray, $andor, $limit, $offset, $userid)
{
    $ret = [];
    if (0 != $userid) {
        return $ret;
    }

    /** @var Xoopsfaq\CategoryHandler $categoryHandler */ /** @var Xoopsfaq\ContentsHandler $contentsHandler */
    /** @var Xoopsfaq\Helper $helper */

    $helper = \XoopsModules\Xoopsfaq\Helper::getInstance();

    // Find the search term in the Category
    // Find the search term in the FAQ
    $contentsHandler = $helper->getHandler('Category');
    $contentFields   = ['category_id', 'category_title'];
    $criteria        = new \CriteriaCompo();
    $criteria->setSort('category_title');
    $criteria->order = 'ASC';
    $criteria->setLimit((int)$limit);
    $criteria->setStart((int)$offset);

    $queryarrayHold = $queryarray;
    if ((is_array($queryarray)) && !empty($queryarray)) {
        $criteria->add(new \Criteria('category_title', '%' . $queryarray[0] . '%', 'LIKE'));
        array_shift($queryarray); //get rid of first element
        foreach ($queryarray as $query) {
            $criteria->add(new \Criteria('category_title', '%' . $query . '%', 'LIKE'), $andor);
        }
    }
    $catArray   = $contentsHandler->getAll($criteria, $contentFields, false);
    $catCount   = !empty($catArray) ? count($catArray) : 0;
    $totalLimit = (int)$limit - $catCount;
    foreach ($catArray as $cId => $cat) {
        $ret[] = [
            'image' => 'assets/images/folder.png',
            'link'  => $helper->url('index.php?cat_id=' . $cId),
            'title' => $cat['category_title'],
        ];
    }
    unset($catArray);

    // Find the search term in the FAQ
    $queryarray      = $queryarrayHold;
    $contentsHandler = $helper->getHandler('Contents');
    $contentFields   = ['contents_id', 'contents_cid', 'contents_title', 'contents_contents', 'contents_publish'];
    $criteria        = new \CriteriaCompo();
    $criteria->add(new \Criteria('contents_active', Xoopsfaq\Constants::ACTIVE, '='));
    $criteria->setSort('contents_id');
    $criteria->order = 'DESC';
    $criteria->setLimit((int)$totalLimit);
    $criteria->setStart((int)$offset);

    if ((is_array($queryarray)) && !empty($queryarray)) {
        $criteria->add(new \Criteria('contents_title', '%' . $queryarray[0] . '%', 'LIKE'));
        $criteria->add(new \Criteria('contents_contents', '%' . $queryarray[0] . '%', 'LIKE'), 'OR');
        array_shift($queryarray); //get rid of first element

        foreach ($queryarray as $query) {
            $criteria->add(new \Criteria('contents_title', '%' . $query . '%', 'LIKE'), $andor);
            $criteria->add(new \Criteria('contents_contents', '%' . $query . '%', 'LIKE'), 'OR');
        }
    }
    $contentArray = $contentsHandler->getAll($criteria, $contentFields, false);
    foreach ($contentArray as $content) {
        $ret[] = [
            'image' => 'assets/images/question2.gif',
            'link'  => $helper->url('index.php?cat_id=' . $content['contents_cid'] . '#q' . $content['contents_id']),
            'title' => $content['contents_title'],
            'time'  => $content['contents_publish'],
        ];
    }
    unset($contentArray);
    return $ret;
}