Example #1
0
 /**
  * Display a list of entries
  *
  * @return     void
  */
 public function displayTask()
 {
     // Incoming
     $this->view->filters = array();
     $this->view->filters['limit'] = Request::getState($this->_option . '.' . $this->_controller . '.limit', 'limit', Config::get('list_limit'), 'int');
     $this->view->filters['start'] = Request::getState($this->_option . '.' . $this->_controller . '.limitstart', 'limitstart', 0, 'int');
     $this->view->filters['search'] = urldecode(Request::getState($this->_option . '.' . $this->_controller . '.search', 'search', ''));
     $this->view->filters['catid'] = Request::getVar('catid', 0, '', 'int');
     $this->view->filters['scope_id'] = Request::getVar('group_id', 0, '', 'int');
     $ee = new Event($this->database);
     // Get a record count
     $this->view->total = $ee->getCount($this->view->filters);
     // Get records
     $this->view->rows = $ee->getRecords($this->view->filters);
     // Get list of categories
     $categories[] = \Html::select('option', '0', '- ' . Lang::txt('COM_EVENTS_CAL_LANG_EVENT_ALLCAT'), 'value', 'text');
     $this->database->setQuery("SELECT id AS value, title AS text FROM `#__categories` WHERE extension='{$this->_option}'");
     $categories = array_merge($categories, $this->database->loadObjectList());
     $this->view->clist = \Html::select('genericlist', $categories, 'catid', 'class="inputbox"', 'value', 'text', $this->view->filters['catid'], false, false);
     //get list of groups
     $groups[] = \Html::select('option', '0', '- ' . Lang::txt('COM_EVENTS_ALL_GROUPS'), 'value', 'text');
     $sql = "SELECT DISTINCT(g.gidNumber) AS value, g.description AS text\n\t\t\t\tFROM `#__events` AS e, `#__xgroups` AS g\n\t\t\t\tWHERE e.scope='group'\n\t\t\t\tAND e.scope_id=g.gidNumber";
     $this->database->setQuery($sql);
     $groups = array_merge($groups, $this->database->loadObjectList());
     $this->view->glist = \Html::select('genericlist', $groups, 'group_id', 'class="inputbox"', 'value', 'text', $this->view->filters['scope_id'], false, false);
     // Set any errors
     foreach ($this->getErrors() as $error) {
         $this->view->setError($error);
     }
     // Output the HTML
     $this->view->display();
 }