public function indexAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$empscreeningModel = new Default_Model_Processes();
$empModel = new Default_Model_Empscreening();
$call = $this->_getParam('call');
$popup = $this->getRequest()->getParam('popup');
if ($call == 'ajaxcall' || $popup == 1) {
$this->_helper->layout->disableLayout();
}
$dashboardcall = $this->_getParam('dashboardcall');
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$unitId = $this->_getParam('unitId');
if (!isset($unitId)) {
$unitId = '';
}
$data = array();
$searchArray = array();
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'b.modifieddate';
$pageNo = 1;
$searchData = '';
$searchQuery = '';
$searchArray = '';
} else {
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'b.modifieddate';
$pageNo = $this->_getParam('page', 1);
$searchData = $this->_getParam('searchData');
$searchData = rtrim($searchData, ',');
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'isactive') {
$searchQuery .= " b." . $key . " like '%" . $val . "%' AND ";
} else {
if ($key == 'startdate') {
$searchQuery .= " b.createddate like '%" . sapp_Global::change_date(urldecode($val), 'database') . "%' AND ";
} else {
if ($key == 'enddate') {
$searchQuery .= " b.modifieddate like '%" . sapp_Global::change_date(urldecode($val), 'database') . "%' AND b.process_status != 'In process' AND ";
} else {
if ($key == 'recentlycommenteddate') {
$searchQuery .= " b.recentlycommenteddate like '%" . sapp_Global::change_date(urldecode($val), 'database') . "%' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
}
}
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
}
$idArr = array();
$idArr = explode('-', $unitId);
if (sizeof($idArr) > 1) {
$specimenId = intVal($idArr[0]);
$flag = intVal($idArr[1]);
} else {
$specimenId = '';
$flag = '';
}
$personalData = $empModel->getEmpPersonalData($specimenId, $flag);
$objName = 'processes';
$tableFields = array('action' => 'Action', 'type' => 'Check Type', 'agencyname' => 'Agency Name', 'email' => 'POC Email', 'process_status' => 'Process Status', 'explanation' => 'Explanation', 'isactive' => 'Active Status', 'startdate' => 'Started On', 'enddate' => 'Ended On', 'recentlycommenteddate' => 'Recently Commented On');
$tablecontent = $empscreeningModel->getProcessesData($sort, $by, $pageNo, $perPage, $searchQuery, $unitId, $loginUserId, $loginuserGroup);
if (isset($unitId) && $unitId != '') {
$formgrid = 'true';
} else {
$formgrid = '';
}
$dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'menuName' => 'Background check Process', 'formgrid' => $formgrid, 'unitId' => $unitId, 'empstatus' => $personalData[0]['ustatus'], 'add' => 'add', 'search_filters' => array('isactive' => array('type' => 'select', 'filter_data' => array('' => 'All', 1 => 'Active', '2' => 'Agency deleted', '3' => 'Agency User deleted', '4' => 'POC deleted', 0 => 'Process deleted')), 'startdate' => array('type' => 'datepicker'), 'enddate' => array('type' => 'datepicker'), 'recentlycommenteddate' => array('type' => 'datepicker')), 'dashboardcall' => $dashboardcall, 'call' => $call);
array_push($data, $dataTmp);
$this->view->dataArray = $data;
$this->view->call = $call;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function processesGrid($id, $empstatus = '')
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$dashboardcall = $this->_getParam('dashboardcall');
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$empscreeningModel = new Default_Model_Processes();
$sort = 'DESC';
$by = 'b.modifieddate';
$pageNo = 1;
$searchData = '';
$searchArray = array();
$objName = 'processes';
$tableFields = array('action' => 'Action', 'type' => 'Check Type', 'agencyname' => 'Agency Name', 'email' => 'POC Email', 'process_status' => 'Process Status', 'explanation' => 'Explanation', 'isactive' => 'Active Status', 'startdate' => 'Started On', 'enddate' => 'Ended On', 'recentlycommenteddate' => 'Recently Commented On');
$tablecontent = $empscreeningModel->getProcessesData($sort, $by, $pageNo, $perPage, '', $id, $loginUserId, $loginuserGroup);
$data = array();
$dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'formgrid' => 'true', 'menuName' => 'Background check Process', 'add' => 'add', 'dashboardcall' => $dashboardcall, 'unitId' => $id, 'empstatus' => $empstatus, 'search_filters' => array('isactive' => array('type' => 'select', 'filter_data' => array('' => 'All', 1 => 'Active', '2' => 'Agency deleted', '3' => 'Agency User deleted', '4' => 'POC deleted', 0 => 'Process deleted')), 'startdate' => array('type' => 'datepicker'), 'enddate' => array('type' => 'datepicker'), 'recentlycommenteddate' => array('type' => 'datepicker')));
array_push($data, $dataTmp);
return $data;
}
