public function requestReceivedAction()
{
$usersNs = new Zend_Session_Namespace("members");
$userId = $usersNs->userId;
/*--search---*/
$search = trim($this->_getParam('search'));
$where = "d.department_head_id='{$userId}' and d.type='operations'";
$this->view->linkArray = array();
$this->view->search = "Search...";
if ($search != "" && $search != "Search...") {
$where = "d.department_head_id='{$userId}' and d.type='operations' and (request like '%{$search}%' or d.title like '%{$search}%' or u.email like '%{$search}%' or u.last_name like '%{$search}%' or u.first_name like '%{$search}%' or r.status like '%{$search}%') ";
$this->view->linkArray = array('search' => $search);
$this->view->search = $search;
}
$this->view->page_size = $page_size = $this->_getParam('page_size', 25);
$page = $this->_getParam('page', 1);
$model = new Application_Model_Request();
$table = $model->getMapper()->getDbTable();
//print_r($table->info());
//$select = $table->select()->order('addedon DESC')->where($where);
$select = $table->select()->setIntegrityCheck(false)->from(array("r" => 'request'))->join(array("d" => 'department'), 'r.department_id=d.id', array('department_name' => 'title'))->join(array("u" => 'user'), 'r.requested_by=u.id', array('first_name', 'last_name', 'email', 'employee_code'))->order('status asc')->order('addedon DESC')->where($where);
//->join('department', 'department.id=request.department_id')
//echo $select->_toString();
//echo $sql = $select->__toString();
$paginator = Base_Paginator::factory($select);
$paginator->setItemCountPerPage($page_size);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
}
