public function messagesAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "user_message like '%{$search}%' || sys_message like '%{$search}%' "; $this->view->linkArray = array('search' => $search); $this->view->search = $search; } $this->view->page_size = $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Application_Model_Message(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from('message')->order('message_id ASC')->where($where); $select = $table->select()->setIntegrityCheck(false)->from(array("m" => 'message'))->join(array("mc" => 'message_category'), 'm.category_id=mc.message_category_id', array('category_name' => 'message_category_name'))->join(array("ms" => 'message_sevirity'), 'm.severity_id =ms.message_sevirity_id', array("sevirity_name" => "message_sevirity_name"))->join(array("mt" => 'message_type'), 'm.type_id=mt.message_type_id', array("type_name" => "message_type_name"))->order('message_id ASC')->where($where); //echo $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }