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