public function errorLogsAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "1=1"; $this->view->linkArray = array(); $this->view->search = "Search..."; if ($search != "" && $search != "Search...") { $where = "(machine_name like '%{$search}%' or app_name like '%{$search}%' or process_name like '%{$search}%' or module_name like '%{$search}%' or method_name 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_ErrorLog(); $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('error_log')->order('log_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_ErrorLog(); $model->setLogId($row->log_id)->setMsgId($row->msg_id)->setMachineName($row->machine_name)->setAppName($row->app_name)->setProcessName($row->process_name)->setModuleName($row->module_name)->setMethodName($row->method_name)->setLogMessage($row->log_message)->setCreatedOn($row->created_on)->setUpdatedon($row->updated_on)->setRowGuid($row->row_guid)->setCreatedBy($row->created_by)->setUpdatedBy($row->updated_by); return $model; }