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();
}
