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