/**
* Display the list of cron jobs
*/
function display()
{
$app =& JFactory::getApplication();
$db =& JFactory::getDBO();
//check if the cron plugin is installed
$version = new JVersion();
if ($version->RELEASE == '1.6') {
$db->setQuery("SELECT count(extension_id) AS id FROM #__extensions WHERE folder = 'system' AND element = 'fabrikcron'");
} else {
$db->setQuery("SELECT count(id) FROM #__plugins WHERE folder = 'system' AND element = 'fabrikcron'");
}
$res = $db->loadResult();
if ($res === 0) {
return JError::raiseWarning(500, 'You must have the fabrik cron system plugin installed for this to work');
}
$user =& JFactory::getUser();
$context = 'com_fabrik.cron.list.';
$limit = $app->getUserStateFromRequest($context . 'limit', 'limit', $app->getCfg('list_limit'), 'int');
$limitstart = $app->getUserStateFromRequest($context . 'limitstart', 'limitstart', 0, 'int');
$filter_order = $app->getUserStateFromRequest($context . 'filter_order', 'filter_order', 'label', 'cmd');
$filter_order_Dir = $app->getUserStateFromRequest($context . 'filter_order_Dir', 'filter_order_Dir', '', 'word');
$lists = array();
$where = array();
$where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
$orderby = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir;
// get the total number of records
$db->setQuery("SELECT COUNT(id) FROM #__fabrik_cron " . $where);
$total = $db->loadResult();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
$sql = "SELECT *, u.name AS editor, c.id AS id FROM #__fabrik_cron AS c " . "\n LEFT JOIN #__users AS u ON u.id = c.checked_out" . "\n {$where} {$orderby}";
$db->setQuery($sql, $pageNav->limitstart, $pageNav->limit);
$rows = $db->loadObjectList();
$arElcount = array();
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
require_once JPATH_COMPONENT . DS . 'views' . DS . 'cron.php';
FabrikViewCron::show($rows, $pageNav, $lists);
}
