public function indexAction() { $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $userId = Zend_Filter::filterStatic($this->_getParam('userId'), 'int'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('message'); $form = new Chat_Form_Message(); $classroomUser = new Tri_Db_Table('classroom_user'); $select = $table->select(true)->setIntegrityCheck(false)->join('user', 'message.sender = user.id', array('name', 'image'))->order('id DESC'); if (!$userId) { $userId = Zend_Auth::getInstance()->getIdentity()->id; } $form->populate(array('receiver' => $userId)); $select->where('receiver = ?', $userId); if ($id) { $table = new Tri_Db_Table('message'); $row = $table->find($id)->current(); if ($row) { $form->populate($row->toArray()); } } $tableUser = new Tri_Db_Table('user'); $user = $tableUser->find($userId)->current(); $selectUser = $classroomUser->select(true)->setIntegrityCheck(false)->join('user', 'classroom_user.user_id = user.id')->where('classroom_user.classroom_id = ?', $session->classroom_id)->order('name'); $this->view->users = $classroomUser->fetchAll($selectUser); $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->form = $form; $this->view->userId = $userId; $this->view->userName = $user->name; $this->view->userImage = $user->image; }
public function indexAction() { $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = Zend_Filter::filterStatic($this->_getParam('query'), 'alnum'); $table = new Zend_Db_Table('course'); $select = $table->select()->order('status'); if ($query) { $select->where('name LIKE (?)', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); }
public function indexAction() { $table = new Tri_Db_Table('content_template'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = $this->_getParam("q"); $select = $table->select(); if ($query) { $select->where('UPPER(name) LIKE UPPER(?)', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->q = $query; }
public function indexAction() { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('page'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $select = $table->select()->order('position'); $query = $this->_getParam("q"); if ($query) { $select->where('UPPER(title) LIKE UPPER(?)', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->q = $query; }
public function indexAction() { $identity = Zend_Auth::getInstance()->getIdentity(); $session = new Zend_Session_Namespace('data'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $select = Exercise_Model_Question::available($session->classroom_id); $session->exercise_id = null; if ($id) { $session->exercise_id = $id; } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); }
public function indexAction() { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('faq'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = Zend_Filter::filterStatic($this->_getParam("q"), 'stripTags'); $select = $table->select(); $select->where('classroom_id = ?', $session->classroom_id); if ($query) { $select->where('UPPER(question) LIKE UPPER(?)', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->q = $query; }
public function indexAction() { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('chat_room'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = Zend_Filter::filterStatic($this->_getParam("q"), 'stripTags'); $select = $table->select(true)->columns("(SELECT COUNT(DISTINCT user_id) FROM chat_room_message\r\n WHERE chat_room_id = chat_room.id\r\n AND `status` = 'logged'\r\n AND created > SYSDATE() - INTERVAL 5 MINUTE) as total")->order(array('status DESC', 'id DESC')); $select->where('classroom_id = ?', $session->classroom_id); if ($query) { $select->where('UPPER(title) LIKE UPPER(?)', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->q = $query; }
public function indexAction() { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('activity'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = Zend_Filter::filterStatic($this->_getParam("q"), 'stripTags'); $select = $table->select(); $select->where('classroom_id = ?', $session->classroom_id)->where('status = ?', 'active')->where('begin <= ?', date('Y-m-d'))->where('end IS NULL OR end > ?', date('Y-m-d')); if ($query) { $select->where('UPPER(title) LIKE UPPER(?)', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->q = $query; }
/** * Action index. * * @return void */ public function indexAction() { $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = $this->_getParam('query'); $table = new Zend_Db_Table('user'); $select = $table->select()->order('name'); if ($query) { $parts = explode(' ', $query); foreach ($parts as $part) { $select->where('name LIKE ?', "%{$part}%"); } $select->orWhere('email LIKE ?', "%{$query}%"); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); }
/** * Action index. * * @return void */ public function indexAction() { $course = new Tri_Db_Table('course'); $calendar = new Tri_Db_Table('calendar'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $form = new Application_Form_Login(); $select = $course->select()->where('status = ?', 'active')->order(array('name', 'category')); $where = array('classroom_id IS NULL', 'end IS NULL OR end > ?' => date('Y-m-d')); $this->view->calendar = $calendar->fetchAll($where, 'begin', 10); $this->view->form = $form; $this->view->user = Zend_Auth::getInstance()->getIdentity(); $paginator = new Tri_Paginator($select, $page); $this->view->courses = $paginator->getResult(); $this->view->newUserToGuest = Tri_Config::get('tri_new_user_to_guest'); $this->_helper->layout->setLayout('layout'); }
public function indexAction() { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('forum_reply'); $forum = new Tri_Db_Table('forum'); $page = Zend_Filter::filterStatic($this->_getParam('page', 9999), 'int'); $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $form = new Forum_Form_Reply(); $select = $table->select(true)->setIntegrityCheck(false)->join('user', 'user.id = user_id', array('user.id as uid', 'user.name', 'user.image', 'user.role'))->where('forum_id = ?', $id)->order('id'); $form->populate(array('forum_id' => $id)); $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->parent = $forum->find($id)->current(); $this->view->form = $form; $this->view->page = $page; }
public function indexAction() { $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('glossary'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $select = $table->select(); $select->where('classroom_id = ?', $session->classroom_id); $query = base64_decode($this->_getParam("q")); if ($this->_hasParam("text")) { $query = $this->_getParam("text"); } if ($query) { $where = strlen($query) == 1 ? "{$query}%" : "%{$query}%"; $select->where('UPPER(word) LIKE UPPER(?)', $where); } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->q = $query; }
public function indexAction() { $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $session = new Zend_Session_Namespace('data'); $table = new Tri_Db_Table('notepad'); $form = new Notepad_Form_Notepad(); $select = $table->select(); $select->where('classroom_id = ?', $session->classroom_id); if ($id) { $table = new Tri_Db_Table('notepad'); $row = $table->find($id)->current(); if ($row) { $form->populate($row->toArray()); } } $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); $this->view->form = $form; }
/** * Action list students * * @return void */ public function listPreRegistrationAction() { $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); $page = Zend_Filter::filterStatic($this->_getParam('page'), 'int'); $query = Zend_Filter::filterStatic($this->_getParam('query'), 'alnum'); $course = Zend_Filter::filterStatic($this->_getParam('course'), 'int'); $select = SelectionProcess_Model_SelectionProcess::listPreRegistration($id, $course); if ($query) { $select->where('u.name LIKE (?)', "%{$query}%"); } $table = new Tri_Db_Table('selection_process'); $this->view->selection_process = $table->find($id)->current(); $this->view->courses = $this->toSelect(SelectionProcess_Model_SelectionProcess::getCourses($id)->toArray()); $this->view->course_id = $course; $paginator = new Tri_Paginator($select, $page); $this->view->data = $paginator->getResult(); }