cardealer_search()

Complexity

Conditions	6
Paths	8

Size

Total Lines	30
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
function cardealer_search($queryarray, $andor, $limit, $offset, $userid)
{
    $sql = 'SELECT custnum, custname FROM ' . $GLOBALS['xoopsDB']->prefix('cardealer_customer') . ' WHERE _online = 1';

    if (0 !== $userid) {
        $sql .= ' AND _submitter=' . (int)$userid;
    }

    if (is_array($queryarray) && $count = count($queryarray)) {
        $sql .= ' AND (()';

        for ($i = 1; $i < $count; ++$i) {
            $sql .= " $andor ";
            $sql .= '()';
        }
        $sql .= ')';
    }

    $sql    .= ' ORDER BY custnum DESC';
    $result = $GLOBALS['xoopsDB']->query($sql, $limit, $offset);
    $ret    = [];
    $i      = 0;
    while (false !== ($myrow = $GLOBALS['xoopsDB']->fetchArray($result))) {
        $ret[$i]['image'] = 'assets/images/icons/32/_search.png';
        $ret[$i]['link']  = 'customer.php?custnum=' . $myrow['custnum'];
        $ret[$i]['title'] = $myrow['custname'];
        ++$i;
    }

    return $ret;
}