public function indexAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; /*if($search<>"" && $search<>"Search...") { $where="(first_name like '%{$search}%' or last_name like '%{$search}%' or email like '%{$search}%' or d.title like '%{$search}%' or username like '%{$search}%' ) and status!='deleted'"; $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_UserPrivilege(); $table = $model->getMapper()->getDbTable(); // $select = $table->select()->setIntegrityCheck(false)->from('user_privilege',array('user_id', 'screen_id', 'action_id','menu_id'))->order('user_id ASC')->where($where); $select = $table->select()->setIntegrityCheck(false)->from(array("up" => 'user_privilege'))->join(array("u" => 'user'), 'up.user_id=u.id', array('first_name' => 'first_name', 'last_nae' => 'last_name'))->order('user_id ASC')->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); // echo '<pre>'; print_r($paginator); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }
private function setModel($row) { $model = new Application_Model_UserPrivilege(); $model->setId($row->id)->setTitle($row->user_id)->setMenuId($row->menu_id)->setScreenId($row->screen_id)->setActionId($row->action_id)->setAddedon($row->addedon)->setUpdatedon($row->updatedon)->setRowGuid($row->row_guid)->setCreatedBy($row->created_by)->setUpdatedBy($row->updated_by); return $model; }