function showNote($calendar) { $option = JRequest::getVar('option'); $mainframe = JFactory::getApplication(); $db = JFactory::getDBO(); $query = 'SELECT title' . ' FROM #__spidercalendar_calendar WHERE id=' . $db->escape($calendar); $db->setQuery($query); $calendar_name = $db->loadResult(); // get calendar id ↑ $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[] = ' #__spidercalendar_event.title LIKE "%' . $db->escape($search_note) . '%"'; } if ($lists['startdate'] != '') { $where[] = " `date`>='" . $db->escape($lists['startdate']) . "' "; } if ($lists['enddate'] != '') { $where[] = " `date`<='" . $db->escape($lists['enddate']) . "' "; } $filter = ''; $filter = count($where) ? 'WHERE' . implode(' AND ', $where) : ''; if (count($where) == 0) { $filter .= ' WHERE calendar=' . $db->escape($calendar); } 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 #__spidercalendar_event.*, #__spidercalendar_event_category.title as cattitle FROM #__spidercalendar_event LEFT JOIN #__spidercalendar_event_category ON #__spidercalendar_event.category=#__spidercalendar_event_category.id {$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; $lists['calendar'] = $calendar; $lists['calendar_name'] = $calendar_name; // display function HTML_contact::showNote($rows, $pageNav, $lists, $option); }