public function requestReceivedAction() { $usersNs = new Zend_Session_Namespace("members"); $userId = $usersNs->userId; /*--search---*/ $search = trim($this->_getParam('search')); $where = "d.department_head_id='{$userId}' and d.type='operations'"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "d.department_head_id='{$userId}' and d.type='operations' and (request like '%{$search}%' or d.title like '%{$search}%' or u.email like '%{$search}%' or u.last_name like '%{$search}%' or u.first_name like '%{$search}%' or r.status like '%{$search}%') "; $this->view->linkArray = array('search' => $search); $this->view->search = $search; } $this->view->page_size = $page_size = $this->_getParam('page_size', 25); $page = $this->_getParam('page', 1); $model = new Application_Model_Request(); $table = $model->getMapper()->getDbTable(); //print_r($table->info()); //$select = $table->select()->order('addedon DESC')->where($where); $select = $table->select()->setIntegrityCheck(false)->from(array("r" => 'request'))->join(array("d" => 'department'), 'r.department_id=d.id', array('department_name' => 'title'))->join(array("u" => 'user'), 'r.requested_by=u.id', array('first_name', 'last_name', 'email', 'employee_code'))->order('status asc')->order('addedon DESC')->where($where); //->join('department', 'department.id=request.department_id') //echo $select->_toString(); //echo $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->paginator = $paginator; }