public function leaveTypesAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "") { $where = "code like '%{$search}%' or title 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_LeaveType(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->order('addedon DESC')->where($where); $paginator = Base_Paginator::factory($select); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }