xoopsfaq_search()

Complexity

Conditions	11
Paths	33

Size

Total Lines	75
Code Lines	51

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php declare(strict_types=1);

function xoopsfaq_search($queryarray, $andor, $limit, $offset, $userid): array

{

    $ret = [];

    if (0 != $userid) {

        return $ret;

    }


    /** @var Helper $helper */

    $helper = Helper::getInstance();


    // Find the search term in the Category

    // Find the search term in the FAQ

    /** @var CategoryHandler $categoryHandler */

    $categoryHandler = $helper->getHandler('Category');

    /** @var ContentsHandler $contentsHandler */

    $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   = $categoryHandler->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;

    $contentFields = ['contents_id', 'contents_cid', 'contents_title', 'contents_contents', 'contents_publish'];

    $criteria      = new \CriteriaCompo();

    $criteria->add(new \Criteria('contents_active', Constants::ACTIVE, '='));

    $criteria->setSort('contents_id');

    $criteria->order = 'DESC';

    $criteria->setLimit($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;

}