function index() { $mainframe =& JFactory::getApplication(); $database =& JFactory::getDBO(); //prepare the pagination $option = 'com_chronoforms'; $limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int'); $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int'); // count entries $database->setQuery("SELECT count(*) FROM #__chronoforms"); $total = $database->loadResult(); jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); //load forms data $val = __getValStatus(); $database->setQuery("SELECT * FROM #__chronoforms ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}"); $forms = $database->loadObjectList(); if (!empty($forms)) { foreach ($forms as $k => $form) { //load actions $query = "SELECT * FROM `#__chronoform_actions` WHERE `chronoform_id` = '" . $form->id . "' AND `enabled` = '1' ORDER BY `order`"; $database->setQuery($query); $forms[$k]->form_actions = $database->loadObjectList(); } } HTML_Admin_ChronoForms::index($forms, $pageNav, $val); }
function index() { $mainframe =& JFactory::getApplication(); $database =& JFactory::getDBO(); //prepare the pagination $option = 'com_chronoforms'; $limit = $mainframe->getUserStateFromRequest($option . '.limit', 'limit', $mainframe->getCfg('list_limit'), 'int'); $limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int'); //get apps $app = $mainframe->getUserStateFromRequest($option . '.app', 'select_app', '', 'string'); $apps = array('' => 'Default'); $database->setQuery("SELECT DISTINCT app FROM #__chronoforms"); $all = $database->loadObjectList(); foreach ($all as $one) { if (!in_array($one->app, array_keys($apps))) { $apps[$one->app] = $one->app; } } // count entries $database->setQuery("SELECT count(*) FROM #__chronoforms WHERE `app` = '" . $app . "'"); //$database->setQuery("SELECT count(*) FROM #__chronoforms"); $total = $database->loadResult(); jimport('joomla.html.pagination'); $pageNav = new JPagination($total, $limitstart, $limit); //load forms data $val = ChronoFormsAdminVersion::__getValStatus(); $database->setQuery("SELECT * FROM #__chronoforms WHERE `app` = '" . $app . "' ORDER BY id LIMIT {$pageNav->limitstart},{$pageNav->limit}"); //$database->setQuery("SELECT * FROM #__chronoforms ORDER BY id LIMIT $pageNav->limitstart,$pageNav->limit"); $forms = $database->loadObjectList(); if (!empty($forms)) { foreach ($forms as $k => $form) { //load actions $query = "SELECT * FROM `#__chronoform_actions` WHERE `chronoform_id` = '" . $form->id . "' AND `enabled` = '1' ORDER BY `order`"; $database->setQuery($query); $forms[$k]->form_actions = $database->loadObjectList(); } } HTML_Admin_ChronoForms::index($forms, $pageNav, $apps, $val); }