function module_event()
{
$option = JRequest::getVar('option');
$mainframe = JFactory::getApplication();
$db = JFactory::getDBO();
$cal = JRequest::getVar('cal', 0);
$cal = JRequest::getVar('cal', 0);
if ($cal == '') {
$cal = 0;
}
$filter_order = $mainframe->getUserStateFromRequest($option . 'filter_order_note', 'filter_order_note', 'id', 'cmd');
$filter_order_Dir = $mainframe->getUserStateFromRequest($option . 'filter_order_Dir_note', 'filter_order_Dir_note', '', 'word');
$filter_state = $mainframe->getUserStateFromRequest($option . 'filter_state_note', 'filter_state_note', '', 'word');
$search_note = $mainframe->getUserStateFromRequest($option . 'search_note', 'search_note', '', 'string');
$search_note = JString::strtolower($search_note);
$limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
$limitstart = $mainframe->getUserStateFromRequest($option . '.limitstart', 'limitstart', 0, 'int');
$lists = array();
$where = array();
$lists['search_note'] = $mainframe->getUserStateFromRequest($option . 'search_note', 'search_note', '', 'string');
$lists['search_note'] = JString::strtolower($lists['search_note']);
$lists['startdate'] = JRequest::getVar('startdate', "");
$lists['enddate'] = JRequest::getVar('enddate', "");
if ($lists['search_note']) {
$where[] = ' se.title LIKE "%' . $db->escape($search_note) . '%" AND se.calendar="' . $cal . '" AND se.published="1"';
}
if ($lists['search_note']) {
if ($lists['startdate'] != '') {
$where[] = " `date`>='" . $db->escape($lists['startdate']) . "' ";
}
if ($lists['enddate'] != '') {
$where[] = " `date`<='" . $db->escape($lists['enddate']) . "' ";
}
} else {
if ($lists['startdate'] != '') {
$where[] = " `event_day`>='" . $db->escape($lists['startdate']) . "' AND calendar='" . $cal . "' ";
}
if ($lists['enddate'] != '') {
$where[] = " `event_day`<='" . $db->escape($lists['enddate']) . "' AND calendar='" . $cal . "' ";
}
}
$filter = '';
$filter = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
if (count($where) == 0) {
$filter .= ' WHERE calendar=' . $cal . ' AND published="1"';
}
if ($filter_order == 'id') {
$orderby = ' ORDER BY id ' . $filter_order_Dir;
} else {
$orderby = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir . ', id';
}
// get the total number of records
$query = 'SELECT COUNT(*)' . ' FROM #__spidercalendar_event ' . $filter;
$db->setQuery($query);
$total = $db->loadResult();
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
$query = "SELECT * FROM #__spidercalendar_event " . $filter . $orderby;
$db->setQuery($query, $pageNav->limitstart, $pageNav->limit);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
// search filter
$lists['search_note'] = $search_note;
// display function
if ($cal != 0) {
HTML_contact::module_event($rows, $pageNav, $lists);
} else {
echo '<div style="text-align:center;"><p style="font-size:25px">Please select calendar</p><div>';
}
}
