public function messagesAction()
{
/*--search---*/
$categoryName = trim($this->_getParam('categoryName'));
$severityName = trim($this->_getParam('severityName'));
$typeName = trim($this->_getParam('typeName'));
/*---sorting ----*/
$order = trim($this->_getParam('order', ""));
$col = trim($this->_getParam('col', ""));
if ($order != "" && $col != "") {
if ($col == "category") {
$strOrderBy = "c.master_value {$order}";
} else {
if ($col == "severity") {
$strOrderBy = "s.master_value {$order}";
} else {
if ($col == "type") {
$strOrderBy = "t.master_value {$order}";
}
}
}
} else {
$strOrderBy = "m.message_id desc";
}
$this->view->sortOptions = array();
/*-----sorting----------*/
$where = "m.message_id<>'-2147483648'";
$this->view->linkArray = array();
$this->view->categoryName = "";
if ($categoryName != "") {
$where .= " and c.master_value like '%{$categoryName}%' ";
$this->view->linkArray['categoryName'] = $categoryName;
$this->view->categoryName = $categoryName;
$this->view->sortOptions['categoryName'] = $categoryName;
}
$this->view->severityName = "";
if ($severityName != "") {
$where .= " and s.master_value like '%{$severityName}%' ";
$this->view->linkArray['severityName'] = $severityName;
$this->view->severityName = $severityName;
$this->view->sortOptions['severityName'] = $severityName;
}
$this->view->typeName = "";
if ($typeName != "") {
$where .= " and t.master_value like '%{$typeName}%' ";
$this->view->linkArray['typeName'] = $typeName;
$this->view->typeName = $typeName;
$this->view->sortOptions['typeName'] = $typeName;
}
$this->view->page_size = $page_size = Zend_Registry::get('page_size');
$page = $this->_getParam('page', 1);
$model = new Security_Model_SysMessage();
$table = $model->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("m" => 'sys_message'))->join(array("c" => "system_master"), "m.category_id=c.master_id and c.master_code='fdSysMessageCategory'", array("category_name" => 'master_value'))->join(array("s" => "system_master"), "m.severity_id=s.master_id and s.master_code='fdSysMessageSeverity'", array("severity_name" => 'master_value'))->join(array("t" => "system_master"), "m.type_id=t.master_id and t.master_code='fdSysMessageType'", array("type_name" => 'master_value'))->order($strOrderBy)->where($where);
//echo $sql = $select->__toString();
$paginator = Base_Paginator::factory($select);
$paginator->setItemCountPerPage($page_size);
$paginator->setCurrentPageNumber($page);
$this->view->totalItems = $paginator->getTotalItemCount();
$this->view->paginator = $paginator;
}
