Ejemplos de CbodbItem::itemList en PHP

Ejemplo n.º 1

Archivo: cbodb.functions.php Proyecto: reeleis/ohiocitycycles

function showBicycles($option, $filter = FALSE)
{
    global $mainframe;
    $saleFilter = JRequest::getVar('saleFilter');
    $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
    $limitstart = $mainframe->getUserStateFromRequest($option . 'limitstart', 'limitstart', 0, 'int');
    if ($saleFilter != null && $saleFilter != '') {
        if ($saleFilter == 'true') {
            $saleFilter = ' AND isSold = 1';
            $b = 'true';
        } else {
            if ($saleFilter == 'false') {
                $saleFilter = ' AND isSold = 0';
                $b = 'false';
            }
        }
    } else {
        $saleFilter = '';
        $b = 'none';
    }
    $rows = null;
    $numRows = null;
    if ($filter) {
        $filter = JRequest::getVar('filter');
        $rows = CbodbItem::itemList("WHERE isBike = 1" . $saleFilter . " ORDER BY " . $filter, $limitstart, $limit);
        $numRows = CbodbItem::itemCount("WHERE isBike = 1" . $saleFilter . " ORDER BY " . $filter);
    } else {
        $rows = CbodbItem::itemList("WHERE isBike = 1" . $saleFilter . " ORDER BY tag DESC", $limitstart, $limit);
        $numRows = CbodbItem::itemCount("WHERE isBike = 1" . $saleFilter . " ORDER BY tag DESC");
    }
    jimport('joomla.html.pagination');
    $pageNav = new JPagination($numRows, $limitstart, $limit);
    HTML_cbodb::showBicycles($option, $rows, $pageNav, $b);
}