/**
* Display the list of banners
*/
function display()
{
global $mainframe;
$db =& JFactory::getDBO();
$context = 'com_banners.banner.list.';
$filter_order = $mainframe->getUserStateFromRequest($context . 'filter_order', 'filter_order', 'cc.title', 'cmd');
$filter_order_Dir = $mainframe->getUserStateFromRequest($context . 'filter_order_Dir', 'filter_order_Dir', '', 'word');
$filter_catid = $mainframe->getUserStateFromRequest($context . 'filter_catid', 'filter_catid', '', 'int');
$filter_state = $mainframe->getUserStateFromRequest($context . 'filter_state', 'filter_state', '', 'word');
$search = $mainframe->getUserStateFromRequest($context . 'search', 'search', '', 'string');
$limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
$limitstart = $mainframe->getUserStateFromRequest($context . 'limitstart', 'limitstart', 0, 'int');
$where = array();
if ($filter_state) {
if ($filter_state == 'P') {
$where[] = 'b.showBanner = 1';
} else {
if ($filter_state == 'U') {
$where[] = 'b.showBanner = 0';
}
}
}
if ($filter_catid) {
$where[] = 'cc.id = ' . (int) $filter_catid;
}
if ($search) {
$where[] = 'LOWER(b.name) LIKE ' . $db->Quote('%' . $db->getEscaped($search, true) . '%', false);
}
$where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
$orderby = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir . ', b.ordering';
// get the total number of records
$query = 'SELECT COUNT(*)' . ' FROM #__banner AS b' . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid' . $where;
$db->setQuery($query);
$total = $db->loadResult();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
$query = 'SELECT b.*, c.name AS client_name, cc.title AS category_name, u.name AS editor' . ' FROM #__banner AS b' . ' INNER JOIN #__bannerclient AS c ON c.cid = b.cid' . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid' . ' LEFT JOIN #__users AS u ON u.id = b.checked_out' . $where . $orderby;
$db->setQuery($query, $pageNav->limitstart, $pageNav->limit);
$rows = $db->loadObjectList();
// build list of categories
$javascript = 'onchange="document.adminForm.submit();"';
$lists['catid'] = JHTML::_('list.category', 'filter_catid', 'com_banner', (int) $filter_catid, $javascript);
// state filter
$lists['state'] = JHTML::_('grid.state', $filter_state);
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
// search filter
$lists['search'] = $search;
require_once JPATH_COMPONENT . DS . 'views' . DS . 'banner.php';
BannersViewBanner::banners($rows, $pageNav, $lists);
}
