sb_search()

Complexity

Conditions	18
Paths	56

Size

Total Lines	83
Code Lines	61

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function sb_search($queryarray, $andor, $limit, $offset, $userid)
{
    global $xoopsUser;
    $ret = [];
    if (!is_object($xoopsUser) || 0 === $xoopsUser->getVar('uid')) {
        return $ret;
    }
    $count = count($queryarray);
    if (0 === $userid) {
        if (!is_array($queryarray) || empty($queryarray) || 0 === $count) {
            return $ret;
        }
    }
    //-------------------------------------
    /** @var \XoopsModules\Soapbox\EntrygetHandler $entrydataHandler */
    $entrydataHandler = new \XoopsModules\Soapbox\EntrygetHandler();
    //-------------------------------------
    $canread_columnIDs        = [];
    $canread_columnnames      = [];
    $_userinfo_authors_column = [];
    $_column_authors_uid      = [];
    //get category object
    $categoryobArray = $entrydataHandler->getColumnsAllPermcheck(0, 0, true, null, null, null, null, false);
    foreach ($categoryobArray as $k => $_categoryob) {
        $canread_columnIDs[]                                   = $_categoryob->getVar('columnID');
        $canread_columnnames[$_categoryob->getVar('columnID')] = $_categoryob->getVar('name');
        $_column_authors_uid[$_categoryob->getVar('columnID')] = $_categoryob->getVar('author');
        if (0 !== $userid && $userid === $_categoryob->getVar('author')) {
            $_userinfo_authors_column[] = $_categoryob->getVar('columnID');
        }
    }

    if (empty($canread_columnIDs)) {
        return $ret;
    }
    $criteria     = new \CriteriaCompo();
    $crit_canread = new \CriteriaCompo();
    $crit_canread->add(new \Criteria('columnID', '(' . implode(',', array_unique($canread_columnIDs)) . ')', 'IN'));
    $criteria->add($crit_canread, 'AND');
    unset($crit_canread);
    //for userinfo
    if (0 !== $userid && !empty($_userinfo_authors_column) && count($_userinfo_authors_column) > 0) {
        $criteria_userinfo = new \CriteriaCompo();
        $criteria_userinfo->add(new \Criteria('columnID', '(' . implode(',', array_unique($_userinfo_authors_column)) . ')', 'IN'));
        $criteria->add($criteria_userinfo, 'AND');
        unset($criteria_userinfo);
    }
    //for serch form
    if (is_array($queryarray) && $count > 0) {
        $crit_query = new \CriteriaCompo();
        foreach ($queryarray as $query_v) {
            $crit_query_one = new \CriteriaCompo();
            $crit_query_one->add(new \Criteria('columnID', '(' . implode(',', array_unique($_userinfo_authors_column)) . ')', 'IN'));
            $crit_query_one->add(new \Criteria('headline', '%' . $query_v . '%', 'like'));
            $crit_query_one->add(new \Criteria('headline', '.*(' . preg_quote($query_v) . ').*', 'regexp'), 'OR');
            $crit_query_one->add(new \Criteria('lead', '%' . $query_v . '%', 'like'), 'OR');
            $crit_query_one->add(new \Criteria('lead', '.*(' . preg_quote($query_v) . ').*', 'regexp'), 'OR');
            $crit_query_one->add(new \Criteria('bodytext', '%' . $query_v . '%', 'like'), 'OR');
            $crit_query_one->add(new \Criteria('bodytext', '.*(' . preg_quote($query_v) . ').*', 'regexp'), 'OR');
            $crit_query->add($crit_query_one, $andor);
            unset($crit_query_one);
        }
        $criteria->add($crit_query, 'AND');
    }

    $criteria->setStart($offset);
    $criteria->setLimit($limit);
    $criteria->setSort('datesub');
    $criteria->setOrder('DESC');
    $sbarticles_arr = $entrydataHandler->getArticles($criteria);
    unset($criteria);

    $i = 0;
    foreach ($sbarticles_arr as $sbarticles) {
        $ret[$i]['image'] = 'assets/images/sb.png';
        $ret[$i]['link']  = 'article.php?articleID=' . $sbarticles->getVar('articleID');
        $ret[$i]['title'] = $sbarticles->getVar('headline');
        $ret[$i]['time']  = $sbarticles->getVar('datesub');
        $ret[$i]['uid']   = $_column_authors_uid[$sbarticles->getVar('columnID')];
        ++$i;
    }

    return $ret;
}