public function indexAction() { if ($this->request->isPost()) { $coordinations = Coordinations::find(array('conditions' => 'deleted = 0 AND hidden =0 AND usergroup = ?1', 'bind' => array(1 => $this->request->getPost('usergroup')), 'order' => 'tstamp DESC,pid ASC')); $usergroup = Usergroups::findFirstByUid($this->request->getPost('usergroup')); $this->view->setVar('usergroup', $usergroup); $this->view->setVar('coordinations', $coordinations); $this->view->setVar('customerselect', false); } else { $usergroups = Usergroups::find(array('conditions' => 'deleted = 0 AND hidden = 0', 'order' => 'title ASC')); $this->view->setVar('customerselect', true); $this->view->setVar('usergroups', $usergroups); } }
public function indexAction() { $currentyear = $this->littlehelpers->getCurrentYear(); $coordinations = Coordinations::find(array("conditions" => "deleted=0 AND hidden=0 AND usergroup = ?1 AND tstamp >= ?2 AND tstamp <= ?3", "bind" => array(1 => $this->session->get('auth')['usergroup'], 2 => $currentyear[0], 3 => $currentyear[1]), "order" => "tstamp DESC")); $this->view->setVar('coordinations', $coordinations); }