function showGroups($option) { $database = JFactory::getDBO(); $search = trim(strtolower(JRequest::getString('search', '', 'post'))); $limit = intval(JRequest::getInt('limit', 10, 'post')); $limitstart = intval(JRequest::getInt('limitstart', 0, 'post')); $where = array(); if ($search) { $where[] = "LOWER(groups_name) LIKE '%{$search}%'"; } // get the total number of records $database->setQuery("SELECT count(*) FROM #__docman_groups" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "")); $total = $database->loadResult(); echo $database->getErrorMsg(); if ($limit > $total) { $limitstart = 0; } $pageNav = new DOCMAN_Pagination($total, $limitstart, $limit); $query = "SELECT *" . "\n FROM #__docman_groups" . (count($where) ? "\n WHERE " . implode(' AND ', $where) : "") . "\n ORDER BY groups_name"; $database->setQuery($query, $pageNav->limitstart, $pageNav->limit); $rows = $database->loadObjectList(); if ($database->getErrorNum()) { echo $database->stderr(); return false; } HTML_DMGroups::showGroups($option, $rows, $search, $pageNav); }
function showGroups($option) { global $database; $search = trim(strtolower(mosGetParam($_POST, 'search', ''))); $limit = intval(mosGetParam($_POST, 'limit', 10)); $limitstart = intval(mosGetParam($_POST, 'limitstart', 0)); $where = array(); if ($search) { $where[] = "LOWER(groups_name) LIKE '%{$search}%'"; } // get the total number of records $database->setQuery("SELECT count(*) FROM #__docman_groups" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "")); $total = $database->loadResult(); echo $database->getErrorMsg(); if ($limit > $total) { $limitstart = 0; } $query = "SELECT *" . "\n FROM #__docman_groups" . (count($where) ? "\n WHERE " . implode(' AND ', $where) : "") . "\n ORDER BY groups_name"; $database->setQuery($query, $limitstart, $limit); $rows = $database->loadObjectList(); if ($database->getErrorNum()) { echo $database->stderr(); return false; } require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php'; $pageNav = new mosPageNav($total, $limitstart, $limit); HTML_DMGroups::showGroups($option, $rows, $search, $pageNav); }