public function indexAction()
{
$requi_model = new Default_Model_Requisition();
$appr_model = new Default_Model_Approvedrequisitions();
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$dashboardcall = $this->_getParam('dashboardcall');
$statusidstring = $this->_request->getParam('status');
$unitId = '';
if (!isset($statusidstring) || $statusidstring == '') {
$unitId = $this->_request->getParam('unitId');
$statusidstring = $unitId;
}
$formgrid = 'true';
if (isset($unitId) && $unitId != '') {
$formgrid = 'true';
}
$statusid = sapp_Global::_decrypt($statusidstring);
$queryflag = 'Approved';
$refresh = $this->_getParam('refresh');
$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'r.modifiedon';
$pageNo = 1;
$searchData = '';
$searchQuery = '';
$searchQuery = '';
$searchArray = '';
$searchArray = array();
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'r.modifiedon';
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$pageNo = $this->_getParam('page', 1);
/** search from grid - START **/
$searchData = $this->_getParam('searchData');
/** search from grid - END **/
}
$dataTmp = $appr_model->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $statusid, $a1 = '', $a2 = '', $a3 = '');
array_push($data, $dataTmp);
$this->view->dataArray = $dataTmp;
$this->view->call = $call;
$this->view->statusidstring = $statusidstring;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
/**
* This function gives all content for grid view.
* @param string $sort = ascending or descending
* @param string $by = name of field which to be sort
* @param integer $pageNo = page number
* @param integer $perPage = no.of records per page
* @param array $searchData = search string
* @param string $call = type of call like ajax.
* @return array Array of data.
*/
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $grid_type, $status_value, $p4, $p5)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$status_value_arr = array(1 => 'Open', 2 => 'Closed', 3 => 'Cancelled', 4 => 'Overdue', 5 => 'Duetoday', 6 => 'To approve', 7 => 'Approved', 8 => 'Rec_pending', 9 => 'Rec_wapproval', 10 => 'Rec_toapprove', 11 => 'To approve', 12 => 'App_approved', 13 => 'To manager approve', 14 => 'Rept_approved', 15 => 'Req_pending', 16 => 'Rejected', 17 => 'Raiser_open', 18 => 'Manager approved', 19 => 'Manager rejected', 20 => 'Rec_app_approved', 21 => 'Rec_app_rejected', 22 => 'Rec_app_closed', 23 => 'To management approve', 24 => 'Management approved', 25 => 'Management rejected');
$status_search_arr = array(6 => " (status = 'To management approve' or status = 'To manager approve') ", 9 => " (status = 'To management approve' or status = 'To manager approve') ", 7 => " (status = 'Manager approved' or status = 'Management Approved' or status = 'Manager rejected' or status = 'Management Rejected') ", 8 => " (status = 'Manager approved' or status = 'Management Approved' or status = 'Manager rejected' or status = 'Management Rejected') ", 10 => " (reporting_manager_id = '" . $loginUserId . "' and status ='To manager approve') ", 12 => " (status = 'Approved' or status = 'Rejected') ", 14 => " (status = 'Manager approved' or status = 'Manager rejected') ", 15 => " (status != 'Cancelled' and status != 'Closed') ", 5 => " date_add(date(r.createddate),interval 10 day) = date(now()) ", 4 => " date_add(date(r.createddate),interval 10 day) < date(now())", 17 => " ( status not in ('Closed','Cancelled','Rejected')) ", 20 => " (status = 'Manager approved' or status = 'Management Approved') ", 21 => " (status = 'Manager rejected' or status = 'Management Rejected')", 22 => " (status = 'Closed' or status = 'Rejected')");
$grid_type_arr = $this->getGridtypearr();
$grid_type = sapp_Global::_decrypt($grid_type);
$status_value = sapp_Global::_decrypt($status_value);
$searchQuery = '';
$searchArray = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
if (count($searchValues) > 0) {
foreach ($searchValues as $key => $val) {
if ($key == 'createddate') {
$searchQuery .= " date(" . $key . ") = '" . sapp_Global::change_date($val, 'database') . "' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
}
if (is_numeric($status_value) && $status_value > 0 && array_key_exists($status_value, $status_value_arr)) {
if (!array_key_exists($status_value, $status_search_arr)) {
$newsearchQuery = " status = '" . $status_value_arr[$status_value] . "'";
} else {
$newsearchQuery = $status_search_arr[$status_value];
}
if ($searchQuery != '') {
$searchQuery .= " and " . $newsearchQuery;
} else {
$searchQuery .= $newsearchQuery;
}
}
$objName = 'servicerequests';
$tableFields = array('action' => 'Action', 'ticket_number' => 'Ticket#', 'service_desk_name' => 'Category', 'service_request_name' => 'Request Type', 'priority' => 'Priority', 'description' => 'Description', 'raised_by_name' => 'Raised By', 'createddate' => 'Raised On', 'status' => 'Status');
if ($status_value != '') {
unset($tableFields['status']);
}
$bool_arr = array('' => 'All', 1 => 'Low', 2 => 'Medium', 3 => 'High');
$tablecontent = $this->getRequestData($sort, $by, $pageNo, $perPage, $searchQuery, $grid_type, $status_value);
$menu_name_arr = $this->getServicemenunames();
$menuName = $menu_name_arr[$grid_type];
$dataTmp = array('sort' => $sort, 'by' => $by, 'menuName' => $menuName, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent['table_content'], 'row_count' => $tablecontent['count'], 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'call' => $call, 'grid_type' => $grid_type, 'status_value' => $status_value, 'view_link' => BASE_URL . 'servicerequests/view/id/{{id}}/t/' . sapp_Global::_encrypt($grid_type) . ($status_value != '' ? "/v/" . sapp_Global::_encrypt($status_value) : ""), 'add_link' => BASE_URL . 'servicerequests/add/t/' . sapp_Global::_encrypt($grid_type) . ($status_value != '' ? "/v/" . sapp_Global::_encrypt($status_value) : ""), 'dashboardcall' => $dashboardcall, 'search_filters' => array('priority' => array('type' => 'select', 'filter_data' => $bool_arr), 'createddate' => array('type' => 'datepicker')));
if ($grid_type_arr[$grid_type] == 'request') {
$dataTmp['add'] = 'add';
}
return $dataTmp;
}
public function confmanagersAction()
{
$init_param = $this->_getParam('i', null);
$init_id = sapp_Global::_decrypt($init_param);
$this->render('configuremanagers');
}
public function recentlyviewed()
{
$request = Zend_Controller_Front::getInstance();
$params = $request->getRequest()->getParams();
$moduleName = $request->getRequest()->getModuleName();
$controllerName = $request->getRequest()->getControllerName();
$actionName = $request->getRequest()->getActionName();
$mparams['module'] = $params['module'];
$mparams['controller'] = $params['controller'];
$mparams['action'] = $params['action'];
$actionurl = '';
$id_name = 'yes';
$burl = $controllerName . "/" . $actionName;
if ($actionName != '') {
$actionurl = strstr($_SERVER['REQUEST_URI'], $actionName);
$actionurl = str_replace($actionName, '', $actionurl);
} else {
if ($controllerName != '') {
$actionurl = strstr($_SERVER['REQUEST_URI'], $controllerName);
$actionurl = str_replace($actionName, '', $actionurl);
} else {
$actionurl = strstr($_SERVER['REQUEST_URI'], $moduleName);
$actionurl = str_replace($actionName, '', $actionurl);
}
}
$burl = $burl . $actionurl;
$tmpPageLink = explode("/", $_SERVER['REQUEST_URI']);
$pageName = $controllerName;
$pageLink = $burl;
$reportsArr = array('leavesreport' => '-' . TAB_EMP_LEAVES, 'leavemanagementreport' => '-Leave Management', 'holidaygroupreports' => '-' . TAB_EMP_HOLIDAYS, 'activeuser' => '-Active Users', 'employeereport' => '-Employees', 'rolesgroup' => '-Roles', 'emprolesgroup' => '-Employee Roles', 'userlogreport' => '-User Logs', 'activitylogreport' => '-Activity Logs', 'requisitionstatusreport' => '-Requisition', 'candidatesreport' => '-Candidates', 'interviewrounds' => '-Interview Rounds', 'agencylistreport' => '-Agency List', 'empscreening' => '-Employee Screening', 'businessunits' => '-Business Units', 'departments' => '-Departments');
$emptabarr = array('dependencydetails' => TAB_EMP_DEPENDENCY, 'creditcarddetails' => TAB_EMP_CORPORATE_CARD, 'visaandimmigrationdetails' => TAB_EMP_VISA_EMIGRATION, 'workeligibilitydetails' => TAB_EMP_WORK_ELIGIBILITY, 'disabilitydetails' => TAB_EMP_DISABILITY, 'empcommunicationdetails' => TAB_EMP_CONTACT, 'empskills' => TAB_EMP_SKILLS, 'empleaves' => TAB_EMP_LEAVES, 'empholidays' => TAB_EMP_HOLIDAYS, 'medicalclaims' => TAB_EMP_MEDICAL_CLAIMS, 'educationdetails' => TAB_EMP_EDUCATION, 'experiencedetails' => TAB_EMP_EXPERIENCE, 'trainingandcertificationdetails' => TAB_EMP_TRAINING_CERTIFY, 'emppersonaldetails' => TAB_EMP_PERSONAL, 'empperformanceappraisal' => TAB_EMP_PERFORMANCE_APPRAISAL, 'emppayslips' => TAB_EMP_PAY_SLIPS, 'empbenefits' => TAB_EMP_BENEFITS, 'emprenumerationdetails' => TAB_EMP_REMUNERATION, 'empadditionaldetails' => TAB_EMP_ADDITIONAL, 'empsecuritycredentials' => TAB_EMP_SECURITY_CREDENTIALS, 'empsalarydetails' => TAB_EMP_SALARY, 'empjobhistory' => TAB_EMP_JOB_HISTORY, 'mydetails' => "", "myemployees" => "My Team", "userloginlog" => "User Log", "logmanager" => "Activity Log", "empconfiguration" => "Employee Tabs");
$myemployees_arr = array('view' => '-View', 'trainingview' => '-' . TAB_EMP_TRAINING_CERTIFY, 'comview' => '-' . TAB_EMP_CONTACT, 'skillsview' => '-' . TAB_EMP_SKILLS, 'eduview' => '-' . TAB_EMP_EDUCATION, 'expview' => '-' . TAB_EMP_EXPERIENCE, 'perview' => '-' . TAB_EMP_PERSONAL, 'additionaldetailsview' => '-' . TAB_EMP_ADDITIONAL, 'jobhistoryview' => '-' . TAB_EMP_JOB_HISTORY);
$myemployeesedit_arr = array('edit' => '-Edit', 'trainingedit' => '-' . TAB_EMP_TRAINING_CERTIFY, 'comedit' => '-' . TAB_EMP_CONTACT, 'skillsedit' => '-' . TAB_EMP_SKILLS, 'eduedit' => '-' . TAB_EMP_EDUCATION, 'expedit' => '-' . TAB_EMP_EXPERIENCE, 'peredit' => '-' . TAB_EMP_PERSONAL, 'additionaldetailsedit' => '-' . TAB_EMP_ADDITIONAL, 'jobhistoryedit' => '-' . TAB_EMP_JOB_HISTORY);
$myDetailsEmployeesarr = array('mydetails', 'myemployees');
$mydetails_arr = array('communicationdetailsview' => TAB_EMP_CONTACT . '-View', 'communication' => TAB_EMP_CONTACT . '-Edit', 'disabilitydetailsview' => TAB_EMP_DISABILITY . '-View', 'disability' => TAB_EMP_DISABILITY . '-Edit', 'workeligibilitydetailsview' => TAB_EMP_WORK_ELIGIBILITY . '-View', 'workeligibility' => TAB_EMP_WORK_ELIGIBILITY . '-Edit', 'visadetailsview' => TAB_EMP_VISA_EMIGRATION . '-View', 'visa' => TAB_EMP_VISA_EMIGRATION . '-Edit', 'creditcarddetailsview' => TAB_EMP_CORPORATE_CARD . '-View', 'creditcard' => TAB_EMP_CORPORATE_CARD . "-Edit", "additionaldetails" => TAB_EMP_ADDITIONAL . "-Edit", "additionaldetailsview" => TAB_EMP_ADDITIONAL . "-View", "salarydetails" => TAB_EMP_SALARY . "-Edit", "salarydetailsview" => TAB_EMP_SALARY . "-View", "personaldetailsview" => TAB_EMP_PERSONAL . "-View", "personal" => TAB_EMP_PERSONAL . "-Edit", "jobhistory" => TAB_EMP_JOB_HISTORY, "certification" => TAB_EMP_TRAINING_CERTIFY, "experience" => TAB_EMP_EXPERIENCE, "education" => TAB_EMP_EDUCATION, "medicalclaims" => TAB_EMP_MEDICAL_CLAIMS, "leaves" => TAB_EMP_LEAVES, "skills" => TAB_EMP_SKILLS, "dependency" => TAB_EMP_DEPENDENCY, "index" => TAB_EMP_OFFICIAL . "-View", "edit" => TAB_EMP_OFFICIAL . "-Edit");
//The Logic used behind this functionality is we are using the object of zend session to store the action
$recentlyViewed = new Zend_Session_Namespace('recentlyViewed');
// Creating a new session with namespace
if (!empty($recentlyViewed->recentlyViewedObject)) {
echo '<div class="recentviewd"><label id="recentviewtext">Recently viewed</label><ul>';
$rvSize = 0;
if (sizeof($recentlyViewed->recentlyViewedObject) > 3) {
$rvSize = 3;
$recentlyViewed->recentlyViewedObject = array_slice($recentlyViewed->recentlyViewedObject, 1);
} else {
$rvSize = sizeof($recentlyViewed->recentlyViewedObject);
}
$menuName = '';
$pagesplitName = '';
for ($i = 0; $i < $rvSize; $i++) {
$pagesplit = $recentlyViewed->recentlyViewedObject[$i];
$pagesplitName = isset($pagesplit['controller_name']) ? $pagesplit['controller_name'] : "";
$pagesplitLink = isset($pagesplit['url']) ? $pagesplit['url'] : "";
$pagesplit_action = isset($pagesplit['action_name']) ? $pagesplit['action_name'] : "";
$pagesplit_idname = isset($pagesplit['id_name']) ? $pagesplit['id_name'] : "";
// Instead of url - display menu name for each list item
if ($pagesplitName != 'dashboard' && $pagesplitName != 'welcome' && $pagesplitName != 'viewsettings') {
if (array_key_exists($pagesplitName, $emptabarr) !== false) {
$menuName = $emptabarr[$pagesplitName];
} else {
$selectQuery1 = "select m.menuName from main_menu m where m.url = '/" . $pagesplitName . "'";
$db = Zend_Db_Table::getDefaultAdapter();
$sql = $db->query($selectQuery1);
$resultarray = $sql->fetchAll();
if (!empty($resultarray)) {
$menuName = ucfirst($resultarray[0]['menuName']);
} else {
$menuName = ucfirst($pagesplitName);
if ($menuName == 'Appraisalstatus') {
$menuName = '';
}
}
}
} else {
if ($pagesplitName == 'viewsettings') {
$flagnumber = substr($pagesplitLink, -1);
if ($flagnumber != '') {
if ($flagnumber == 1) {
$menuName = "Settings-Widgets";
} else {
if ($flagnumber == 2) {
$menuName = "Settings-Shortcuts";
}
}
} else {
$menuName = "Settings";
}
} else {
$menuName = ucfirst($pagesplitName);
}
}
// Display of add, edit or view in each list item
// Checking condition for my employee and my details static controllers
if ($pagesplitName != '' && in_array($pagesplitName, $myDetailsEmployeesarr)) {
if ($pagesplit_action != '') {
if ($pagesplitName == 'myemployees') {
if (array_key_exists($pagesplit_action, $myemployees_arr) !== false) {
$menuName .= $myemployees_arr[$pagesplit_action];
} else {
if (array_key_exists($pagesplit_action, $myemployeesedit_arr) !== false) {
$menuName .= $myemployeesedit_arr[$pagesplit_action];
} else {
if ($actionName == 'add') {
$menuName .= '-Add';
}
}
}
} else {
if (array_key_exists($pagesplit_action, $mydetails_arr) !== false) {
$menuName .= $mydetails_arr[$pagesplit_action];
}
}
} else {
if ($pagesplit_action == '') {
if ($pagesplitName == 'mydetails') {
$menuName .= TAB_EMP_OFFICIAL . "-View";
}
} else {
$menuName .= '';
}
}
} else {
if ($pagesplitName != '' && $pagesplitName == 'reports') {
if ($pagesplit_action != '') {
if (array_key_exists($pagesplit_action, $reportsArr) !== false) {
$menuName .= $reportsArr[$pagesplit_action];
}
}
} else {
if ($pagesplitName != '' && $pagesplitName == 'servicerequests') {
if ($pagesplit_action != '') {
$param_t = isset($pagesplit['t']) ? sapp_Global::_decrypt($pagesplit['t']) : "";
$param_v = isset($pagesplit['v']) ? sapp_Global::_decrypt($pagesplit['v']) : "";
$service_menu = sapp_Helper::sd_menu_names();
$service_action_arr = sapp_Helper::sd_action_names();
if ($param_t != '' && isset($service_menu[$param_t])) {
$menuName .= " - " . $service_menu[$param_t];
}
if ($param_v != '' && isset($service_action_arr[$param_v])) {
$menuName .= " - " . $service_action_arr[$param_v];
}
}
} else {
if ($pagesplitName != '' && $pagesplitName == 'appraisalinit') {
if ($pagesplit_action != '') {
if ($pagesplit_action == 'edit') {
$menuName .= '-Edit';
}
if ($pagesplit_action == 'view') {
$menuName .= '-View';
}
if ($pagesplit_action == 'add') {
$menuName .= '-Add';
}
if ($pagesplit_action == 'assigngroups') {
$menuName .= '-Edit Questions';
}
if ($pagesplit_action == 'confmanagers') {
$menuName .= '-Edit Managers';
}
if ($pagesplit_action == 'viewassigngroups') {
$menuName .= '-View Questions';
}
if ($pagesplit_action == 'viewconfmanagers') {
$menuName .= '-View Managers';
}
}
} else {
if ($pagesplitName != '' && $pagesplitName == 'appraisalstatus') {
if ($pagesplit_action != '') {
if ($pagesplit_action == 'employee') {
$menuName .= 'Employee Status';
}
if ($pagesplit_action == 'manager') {
$menuName .= 'Manager Status';
}
}
} else {
if ($pagesplit_action != '' && $pagesplitName != 'reports') {
if ($pagesplit_action == 'add') {
$menuName .= '-Add';
} else {
if ($pagesplit_action == 'edit' && $pagesplit_idname == 'yes') {
$menuName .= '-Edit';
} else {
if ($pagesplit_action == 'edit') {
$menuName .= '-Add';
} else {
if ($pagesplit_action == 'view') {
$menuName .= '-View';
} else {
if ($pagesplit_action == 'viewsettings') {
$menuName = 'Settings';
} else {
if ($pagesplit_action == 'viewprofile') {
$menuName = 'Profile';
} else {
if ($pagesplit_action == 'changepassword') {
$menuName = 'Change password';
} else {
if ($pagesplit_action == 'emailsettings') {
$menuName = 'Email Settings';
} else {
if ($pagesplit_action == 'upgradeapplication') {
$menuName = 'Upgrade Application';
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
if ($menuName) {
echo '<li><span id="redirectlink" title = "' . $menuName . '" onclick ="redirecttolink(\'' . $pagesplitLink . '\');">' . $menuName . '</span><a href="javascript:void(0);" onClick="closetab(this,\'' . $pagesplitName . '\',\'' . $pagesplitLink . '\')"></a></li>';
}
}
}
//end of display
if (isset($recentlyViewed->recentlyViewedObject)) {
if (sizeof($recentlyViewed->recentlyViewedObject) > 3 && $pageLink != DOMAIN && !in_array($pageName . "!@#" . $pageLink, $recentlyViewed->recentlyViewedObject)) {
array_shift($recentlyViewed->recentlyViewedObject);
}
if ($pageName != 'public' && $pageName != 'welcome' && $controllerName != 'error') {
if (!in_array('PIE.htc', $tmpPageLink)) {
if ($pageLink != DOMAIN && $controllerName != 'index' && $actionName != 'welcome') {
if ($this->recentlyviewed_helper($pageLink, $recentlyViewed->recentlyViewedObject) === true) {
if ($controllerName == 'servicerequests') {
array_push($recentlyViewed->recentlyViewedObject, array('url' => $burl, 'controller_name' => $controllerName, 'action_name' => $actionName, 'id_name' => $id_name, 't' => isset($params['t']) ? $params['t'] : "", 'v' => isset($params['v']) ? $params['v'] : ""));
} else {
array_push($recentlyViewed->recentlyViewedObject, array('url' => $burl, 'controller_name' => $controllerName, 'action_name' => $actionName, 'id_name' => $id_name));
}
}
}
}
}
} else {
$recentlyViewed->recentlyViewedObject = array();
if ($pageLink != DOMAIN && $controllerName != 'index' && $actionName != 'welcome' && $controllerName != 'error' && !in_array('PIE.htc', $tmpPageLink)) {
if ($this->recentlyviewed_helper($pageLink, $recentlyViewed->recentlyViewedObject) === true) {
if ($controllerName == 'servicerequests') {
array_push($recentlyViewed->recentlyViewedObject, array('url' => $burl, 'controller_name' => $controllerName, 'action_name' => $actionName, 'id_name' => $id_name, 't' => isset($params['t']) ? $params['t'] : "", 'v' => isset($params['v']) ? $params['v'] : ""));
} else {
array_push($recentlyViewed->recentlyViewedObject, array('url' => $burl, 'controller_name' => $controllerName, 'action_name' => $actionName, 'id_name' => $id_name));
}
}
}
}
echo '</ul></div>';
}
<li class="third_li">
<h4>Application Settings</h4>
<div class="third_icon icon"></div>
<span>Configure application name and super admin credentials</span>
</li>
<li class="fourth_li">
<h4>Mail Server Settings</h4>
<div class="fourth_icon icon"></div>
<span>Configure your mail server to get automated mails</span>
</li>
<li class="fifth_li">
<h4>Final Check</h4>
<div class="fifth_icon icon"></div>
<span>Confirm and complete the installation process</span>
</li>
</ul>
</div>
<div class="content_wrapper">
<?php
if (isset($_GET['s']) && $_GET['s'] != '') {
$redirectUrl = sapp_Global::_decrypt($_GET['s']);
require_once 'step' . $redirectUrl . '.php';
} else {
require_once 'step1.php';
}
?>
</div>
</div>
</body>
</html>
public function breadcrumbs($baseUrlString = '')
{
$request = Zend_Controller_Front::getInstance();
$params = $request->getRequest()->getParams();
$controllerName = $request->getRequest()->getControllerName();
$action_Name = $request->getRequest()->getActionName();
$tName = '';
$vName = '';
$tUrl = '';
$serviceUrl = '';
$burl = $controllerName . "/" . $action_Name;
/**
*
* For service request modifying the breadcrum based on t and v params
* @var t and @var v
*/
$param_t = isset($params['t']) ? sapp_Global::_decrypt($params['t']) : "";
$param_v = isset($params['v']) ? sapp_Global::_decrypt($params['v']) : "";
$service_menu = sapp_Helper::sd_menu_names();
$service_action_arr = sapp_Helper::sd_action_names();
if ($param_t != '' && isset($service_menu[$param_t])) {
$tName = $service_menu[$param_t] . ' Summary';
$tUrl = $baseUrlString . '/' . $controllerName . '/index/t/' . sapp_Global::_encrypt($param_t);
}
if ($param_v != '' && isset($service_action_arr[$param_v])) {
$vName = $service_action_arr[$param_v];
} else {
$vName = $action_Name != 'index' ? $action_Name : '';
}
if ($vName != '') {
if ($tName != '') {
$serviceUrl = '<a href=' . $tUrl . '>' . $tName . '</a><span class="arrows">›</span>';
}
$serviceUrl .= '<span>' . ucfirst($vName) . '</span>';
} else {
$serviceUrl = '<span>' . $tName . '</span>';
}
/**
* End modifying breadcrum for servicerequest.
*/
unset($params['module'], $params['controller'], $params['action']);
if (isset($params['error_handler'])) {
unset($params['error_handler']);
}
$id_name = '';
if (is_array($params) && !empty($params)) {
foreach ($params as $key => $value) {
if (!is_array($value)) {
$burl .= "/" . $key . "/" . $value;
}
}
$id_name = "yes";
}
$pageUrl = explode("/", $_SERVER['REQUEST_URI']);
$serverUrl = $_SERVER['HTTP_HOST'];
$reportsArr = array('leavesreport' => 'Leaves', 'holidaygroupreports' => 'Holidays', 'activeuser' => 'Active Users', 'employeereport' => 'Employees', 'rolesgroup' => 'Roles', 'emprolesgroup' => 'Employee Roles', 'userlogreport' => 'User Logs', 'activitylogreport' => 'Activity Logs', 'requisitionstatusreport' => 'Requisition');
$pageName = $controllerName;
$actionName = $action_Name;
$breadCrumbsData = '';
$mydetails_arr = array('jobhistory' => 'Employee Job History', 'certification' => 'Training & Certification Details', 'experience' => 'Experience Details', 'education' => 'Education Details', 'medicalclaims' => 'Medical Claims', 'leaves' => 'Employee Leaves', 'skills' => 'Employee Skills', 'communication' => 'Contact Details', 'communicationdetailsview' => 'Contact Details', 'disability' => 'Disability Details', 'disabilitydetailsview' => 'Disability Details', 'workeligibility' => 'Work Eligibility Details', 'workeligibilitydetailsview' => 'Work Eligibility Details', 'visa' => 'Visa and Immigration Details', 'visadetailsview' => 'Visa and Immigration Details', 'additionaldetails' => 'Additional Details', 'additionaldetailsview' => 'Additional Details', 'salarydetails' => 'Salary Details', 'salarydetailsview' => 'Salary Details', 'personal' => 'Personal Details', 'personaldetailsview' => 'Personal Details', 'creditcard' => 'Corporate Card Details', 'creditcarddetailsview' => 'Corporate Card Details', 'dependency' => 'Dependency Details', 'edit' => 'Edit');
$myemployees_arr = array('additionaldetailsview' => 'Additional Details', 'jobhistoryview' => 'Job History', 'perview' => 'Personal Details', 'expview' => 'Experience Details', 'eduview' => 'Education Details', 'skillsview' => 'Employee Skills', 'comview' => 'Contact Details', 'trainingview' => 'Training & Certification Details', 'view' => 'View');
if ($pageName == '' || $pageName == 'welcome') {
$breadCrumbsData .= '';
} else {
if ($pageName == 'dashboard') {
$breadCrumbsData = '<div class="breadcrumbs">';
if ($actionName == 'viewsettings') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Settings';
} else {
if ($actionName == 'viewprofile') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Profile';
} else {
if ($actionName == 'changepassword') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Change Password';
} else {
if ($actionName == 'emailsettings') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Email Settings';
} else {
if ($actionName == 'upgradeapplication') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Upgrade Application ';
}
}
}
}
}
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'configuresite') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Configure Site';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'managemenus') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Manage Modules';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'logmanager') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Activity Log';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'userloginlog') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> User Log';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'servicerequests') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Service Request Management<span class="arrows">›</span>' . $serviceUrl . '';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'reports') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span>';
if (isset($actionName) && $actionName != '') {
$breadCrumbsData .= '<span><a href="' . $baseUrlString . '/reports">Analytics</a></span>';
if ($actionName == 'userlogreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Audit Logs<span class="arrows">›</span><span>User log Report</span>';
} else {
if ($actionName == 'activitylogreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Audit Logs<span class="arrows">›</span><span>Activity log Report</span>';
} else {
if ($actionName == 'businessunits') {
$breadCrumbsData .= '<span class="arrows">›</span>Organization<span class="arrows">›</span><span>Business Units Report</span>';
} else {
if ($actionName == 'departments') {
$breadCrumbsData .= '<span class="arrows">›</span>Organization<span class="arrows">›</span><span>Departments Report</span>';
} else {
if ($actionName == 'leavesreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Leave Management<span class="arrows">›</span><span>Employee Leaves Summary Report</span>';
} else {
if ($actionName == 'leavemanagementreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Leave Management<span class="arrows">›</span><span>Leave Management Summary Report</span>';
} else {
if ($actionName == 'holidaygroupreports') {
$breadCrumbsData .= '<span class="arrows">›</span>Holiday Management<span class="arrows">›</span><span>Holiday Groups & Holidays Report</span>';
} else {
if ($actionName == 'employeereport') {
$breadCrumbsData .= '<span class="arrows">›</span><span>Employees Report</span> ';
} else {
if ($actionName == 'rolesgroup') {
$breadCrumbsData .= '<span class="arrows">›</span>User Management<span class="arrows">›</span><span>Groups & Roles Report</span>';
} else {
if ($actionName == 'emprolesgroup') {
$breadCrumbsData .= '<span class="arrows">›</span>User Management<span class="arrows">›</span><span>Groups, Roles & Employees Report</span>';
} else {
if ($actionName == 'activeuser') {
$breadCrumbsData .= '<span class="arrows">›</span>User Management<span class="arrows">›</span><span>Users & Employees Report</span>';
} else {
if ($actionName == 'requisitionstatusreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Resource Requisition<span class="arrows">›</span><span>Requisitions Report</span>';
} else {
if ($actionName == 'candidatesreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Resource Requisition<span class="arrows">›</span><span>Candidate Details Report</span>';
} else {
if ($actionName == 'interviewrounds') {
$breadCrumbsData .= '<span class="arrows">›</span>Resource Requisition<span class="arrows">›</span><span>Scheduled Interviews Report</span>';
} else {
if ($actionName == 'empscreening') {
$breadCrumbsData .= '<span class="arrows">›</span>Background Checks<span class="arrows">›</span><span>Employee / Candidate Screening Report</span>';
} else {
if ($actionName == 'agencylistreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Background Checks<span class="arrows">›</span><span>Background Checks Agencies Report</span>';
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
} else {
$breadCrumbsData .= '<span>Analytics</span>';
}
$breadCrumbsData .= '</div>';
} else {
$breadCrumbsData = '<div class="breadcrumbs">';
$url = "/" . $pageName;
$breadCrumIds = $this->getBreadCrumDetails($url);
$breadCrumNames = array();
if (!empty($breadCrumIds)) {
$menu_model = new Default_Model_Menu();
$breadcrumstring = trim($breadCrumIds[0]['nav_ids'], ',');
$breadcrumArr = explode(",", $breadcrumstring);
$breadCrumNames = $breadCrumIds;
$breadCrumbsData .= '<span class="firstbreadcrumb" onclick="window.location=\'' . $baseUrlString . '\'">Home</span> <span class="arrows">›</span> ';
for ($b = 0; $b < sizeof($breadCrumNames); $b++) {
$breadCrumNames[$b]['menuName'] = $menu_model->getMenuText($breadCrumNames[$b]['menuName']);
if ($b == 0) {
if ($breadCrumNames[$b]['url'] == '/sitepreference') {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span>';
} else {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span> <span class="arrows">›</span> ';
}
} else {
if ($b == sizeof($breadCrumNames) - 1) {
if ($actionName == '') {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span>';
} else {
$breadCrumbsData .= '<a href="' . $baseUrlString . $breadCrumNames[$b]['url'] . '" >' . $breadCrumNames[$b]['menuName'] . '</a>';
}
} else {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span> <span class="arrows">›</span> ';
}
}
}
if ($actionName == 'add' || $actionName == 'edit' && $id_name == '' || $actionName != '' && $actionName != 'view') {
if ($actionName == 'edit' || $actionName != '') {
$idvalindex = '';
if (in_array('id', $pageUrl)) {
$idindex = array_search('id', $pageUrl);
$idvalindex = $idindex + 1;
} else {
if (in_array('userid', $pageUrl)) {
$idindex = array_search('userid', $pageUrl);
$idvalindex = $idindex + 1;
}
}
if ((in_array('id', $pageUrl) || in_array('userid', $pageUrl)) && $pageName != 'myemployees') {
$idval = intval($pageUrl[$idvalindex]);
if ($idval != 0) {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
if ($pageName == 'mydetails') {
if (isset($actionName) && $actionName != '') {
if (array_key_exists($actionName, $mydetails_arr) !== false) {
$breadCrumbsData .= '<span class="arrows">›</span> <span>' . $mydetails_arr[$actionName] . '</span>';
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
}
} else {
if ($pageName == 'myemployees') {
if (isset($actionName) && $actionName != '') {
if (array_key_exists($actionName, $myemployees_arr) !== false) {
$breadCrumbsData .= '<span class="arrows">›</span> <span>' . $myemployees_arr[$actionName] . '</span>';
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>View</span>';
}
} else {
if ($actionName == 'multipleresume') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add multiple CVs</span>';
}
if ($actionName == 'edit' && $pageName == 'heirarchy') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
} else {
if ($actionName == 'edit' || $actionName == 'add') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
} else {
$breadCrumbsData .= '';
}
}
}
}
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
if ($actionName == 'edit') {
$idvalindex = '';
if (in_array('id', $pageUrl)) {
$idindex = array_search('id', $pageUrl);
$idvalindex = $idindex + 1;
} else {
if (in_array('userid', $pageUrl)) {
$idindex = array_search('userid', $pageUrl);
$idvalindex = $idindex + 1;
}
}
if (in_array('id', $pageUrl) || in_array('userid', $pageUrl)) {
$idval = intval($pageUrl[$idvalindex]);
if ($idval != '') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
if ($actionName == 'view') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>View</span>';
}
}
}
$breadCrumbsData .= '</div>';
} else {
$breadCrumbsData = '';
}
}
}
}
}
}
}
}
}
echo $breadCrumbsData;
}
/**
* This action is used to create new group by manager.It will serve as ajax call.
*/
public function createnewgroupAction()
{
$appraisal_id = $this->_getParam('appraisal_id', null);
$manager_id = $this->_getParam('manager_id', null);
$flag = $this->_getParam('flag', null);
$group_id = $this->_getParam('group_id', null);
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
try {
if ($appraisal_id != '' && $manager_id != '') {
$appraisal_id = sapp_Global::_decrypt($appraisal_id);
$manager_id = sapp_Global::_decrypt($manager_id);
if ($flag == 'edit') {
$group_id = sapp_Global::_decrypt($group_id);
}
$app_manager_model = new Default_Model_Appraisalmanager();
$appraisal_init_model = new Default_Model_Appraisalinit();
$appraisal_qs_model = new Default_Model_Appraisalquestions();
$check_array = array();
$tablename = 'main_pa_questions_privileges';
$manager_emp = $app_manager_model->getmanager_emp($appraisal_id, $manager_id, '');
if (empty($manager_emp) && $flag == 'add') {
$this->view->ermsg = 'No employees to add.';
}
$appraisaldata = $appraisal_init_model->getConfigData($appraisal_id);
$appraisaldata = $appraisaldata[0];
$questionPrivileges = $appraisal_qs_model->gethrquestionprivileges($appraisal_id, $tablename, '');
$questionsArr = $appraisal_qs_model->getQuestionsByCategory($appraisaldata['category_id'], '');
if (!empty($questionPrivileges)) {
if (isset($questionPrivileges['manager_qs']) && isset($questionPrivileges['manager_qs_privileges'])) {
if ($questionPrivileges['manager_qs'] != '' && $questionPrivileges['manager_qs_privileges'] != '') {
$hr_qs_Arr = explode(',', $questionPrivileges['manager_qs']);
$hr_qs_privileges = json_decode($questionPrivileges['manager_qs_privileges'], true);
foreach ($hr_qs_privileges as $key => $val) {
//$val = explode(',',substr($val, 1, -1));
$check_array[$key] = $val;
}
}
}
}
if (sapp_Global::_checkprivileges(APPRAISALQUESTIONS, $loginuserGroup, $loginuserRole, 'edit') == 'Yes') {
$appraisaldata['poppermission'] = 'yes';
}
$appraisaldata['poppermission'] = 'yes';
$manager_emp_selected = array();
$group_name = "";
if ($flag == 'edit') {
$app_group_model = new Default_Model_Appraisalgroups();
$group_details = $app_group_model->getAppraisalGroupsDatabyID($group_id);
if (!empty($group_details)) {
$group_details = $group_details[0];
$group_name = $group_details['group_name'];
$manager_emp_selected = $app_manager_model->getmanager_emp($appraisal_id, $manager_id, $group_id);
$manager_qs_privileges = json_decode($manager_emp_selected[0]['manager_qs_privileges'], true);
foreach ($manager_qs_privileges as $key => $val) {
$check_array[$key] = $val;
}
} else {
$this->view->ermsg = 'No data found.';
}
}
$view = $this->view;
$view->appraisal_id = $appraisal_id;
$view->manager_id = $manager_id;
$view->manager_emp = $manager_emp;
$view->questionsArr = $questionsArr;
$view->checkArr = $check_array;
$view->appraisaldata = $appraisaldata;
$view->checkArr = $check_array;
$view->flag = $flag;
$view->group_name = $group_name;
$view->group_id = $group_id;
$view->selected_emp = $manager_emp_selected;
} else {
$this->view->ermsg = 'No data found.';
}
} catch (Exception $ex) {
$this->view->ermsg = 'No data found.';
}
}
public function indexAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
if (isset($_SESSION['emp_leaves'])) {
unset($_SESSION['emp_leaves']);
}
$leaverequestmodel = new Default_Model_Leaverequest();
$queryflag = '';
$errorstring = '';
$statusidarr = array('1', '2', '3', '4');
$call = $this->_getParam('call');
$statusidstring = $this->_request->getParam('status');
$unitId = '';
if (!isset($statusidstring) || $statusidstring == '') {
$unitId = $this->_request->getParam('unitId');
$statusidstring = $unitId;
}
$statusid = sapp_Global::_decrypt($statusidstring);
if (isset($statusid) && $statusid != '' && $statusidstring != 'ASC') {
if (!in_array($statusid, $statusidarr)) {
$errorstring = "error";
}
$_SESSION['emp_leaves'] = $statusidstring;
}
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$dashboardcall = $this->_getParam('dashboardcall');
$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'modifieddate';
$pageNo = 1;
$searchData = '';
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'modifieddate';
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$pageNo = $this->_getParam('page', 1);
// search from grid - START
$searchData = $this->_getParam('searchData');
$searchData = rtrim($searchData, ',');
// search from grid - END
}
$objName = 'empleavesummary';
$dataTmp = $leaverequestmodel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $objName, $statusid);
array_push($data, $dataTmp);
$this->view->dataArray = $data;
$this->view->call = $call;
$this->view->controllername = $objName;
$this->view->statusidstring = $statusidstring;
$this->view->errorstring = $errorstring;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
/**
* This function gives all content for grid view.
* @param string $sort = ascending or descending
* @param string $by = name of field which to be sort
* @param integer $pageNo = page number
* @param integer $perPage = no.of records per page
* @param array $searchData = search string
* @param string $call = type of call like ajax.
* @return array Array of data.
*/
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $grid_type, $status_value, $p4, $p5)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$status_value_arr = array(1 => 'Open', 2 => 'Closed', 3 => 'Cancelled', 4 => 'Overdue', 5 => 'Duetoday', 6 => 'To approve', 7 => 'Approved', 8 => 'Rec_pending', 9 => 'Rec_wapproval', 10 => 'Rec_toapprove', 11 => 'To approve', 12 => 'App_approved', 13 => 'To manager approve', 14 => 'Rept_approved', 15 => 'Req_pending', 16 => 'Rejected', 17 => 'Raiser_open', 18 => 'Manager approved', 19 => 'Manager rejected', 20 => 'Rec_app_approved', 21 => 'Rec_app_rejected', 22 => 'Rec_app_closed', 23 => 'To management approve', 24 => 'Management approved', 25 => 'Management rejected', 26 => 'In Progress', 27 => 'Duplicate', 28 => 'Need more Info', 29 => 'Team Tickets');
$status_search_arr = array(4 => " date_add(date(r.createddate),interval 10 day) < date(now())", 5 => " date_add(date(r.createddate),interval 10 day) = date(now()) ", 6 => " (r.status = 'To management approve' or r.status = 'To manager approve') ", 7 => " (r.status = 'Manager approved' or r.status = 'Management Approved' or r.status = 'Manager rejected' or r.status = 'Management Rejected') ", 8 => " (r.status = 'Manager approved' or r.status = 'Management Approved' or r.status = 'Manager rejected' or r.status = 'Management Rejected') ", 9 => " (r.status = 'To management approve' or r.status = 'To manager approve') ", 10 => " (r.reporting_manager_id = '" . $loginUserId . "' and r.status ='To manager approve') ", 12 => " (r.status = 'Approved' or r.status = 'Rejected') ", 14 => " (r.status = 'Manager approved' or r.status = 'Manager rejected') ", 15 => " (r.status != 'Cancelled' and r.status != 'Closed') ", 17 => " (r.status not in ('Closed','Cancelled','Rejected')) ", 20 => " (r.status = 'Manager approved' or r.status = 'Management Approved') ", 21 => " (r.status = 'Manager rejected' or r.status = 'Management Rejected')", 22 => " (r.status = 'Closed' or r.status = 'Rejected')", 26 => " (r.status = 'In Progress')", 27 => " (r.status = 'Duplicate')", 28 => " (r.status = 'Need more Info')", 29 => " (usr.reporting_manager = " . $loginUserId . ")");
$grid_type_arr = $this->getGridtypearr();
$grid_type = sapp_Global::_decrypt($grid_type);
$status_value = sapp_Global::_decrypt($status_value);
$searchQuery = '';
$searchArray = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
if (count($searchValues) > 0) {
foreach ($searchValues as $key => $val) {
if ($key == 'createddate') {
$searchQuery .= " date(" . $key . ") = '" . sapp_Global::change_date($val, 'database') . "' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
}
if (is_numeric($status_value) && $status_value > 0 && array_key_exists($status_value, $status_value_arr)) {
if (!array_key_exists($status_value, $status_search_arr)) {
$newsearchQuery = " r.status = '" . $status_value_arr[$status_value] . "'";
} else {
$newsearchQuery = $status_search_arr[$status_value];
}
if ($searchQuery != '') {
$searchQuery .= " and " . $newsearchQuery;
} else {
$searchQuery .= $newsearchQuery;
}
}
//My Action Summary menu item grid types
if ($grid_type == 2 || $grid_type == 4 || $grid_type == 5 || $grid_type == 6 || $grid_type == 8) {
//if (strpos($searchQuery, 'Open') !== false) {
// is Current Login user is Admin for 1 or more business units
$currentuserIsAdmin = $this->getAdminServiceDeskIds($loginUserId);
if ($currentuserIsAdmin != "0") {
if ($searchQuery != '') {
if (strpos($searchQuery, 'Open') !== false) {
$searchQuery .= " AND (r.service_desk_id in (" . $currentuserIsAdmin . "))";
} else {
$searchQuery .= " OR (r.service_desk_id in (" . $currentuserIsAdmin . "))";
}
} else {
$searchQuery .= "(r.service_desk_id in (" . $currentuserIsAdmin . "))";
}
}
//else {
// is Current Login user is Executor for 1 or more service tickets
$currentuserIsExecutor = $this->IsExecutorForActiveTickets($loginUserId);
if ($currentuserIsExecutor != "0") {
if ($searchQuery != '') {
$searchQuery .= " and (find_in_set(" . $loginUserId . ",r.executor_id)) " . "and (r.status not in ('Closed','Rejected'))";
} else {
$searchQuery .= " (find_in_set(" . $loginUserId . ",r.executor_id)) " . "and (r.status not in ('Closed','Rejected'))";
}
}
//}
//}
}
$objName = 'servicerequests';
$tableFields = array('action' => 'Action', 'ticket_number' => 'Ticket#', 'service_desk_name' => 'Category', 'service_request_name' => 'Request Type', 'priority' => 'Priority', 'status' => 'Status', 'description' => 'Description', 'raised_by_name' => 'Raised By', 'createddate' => 'Raised On', 'executor_id' => 'Allocate', 'executor_name' => 'Executor');
if ($status_value != '') {
unset($tableFields['status']);
}
$bool_arr = array('' => 'All', 1 => 'Low', 2 => 'Medium', 3 => 'High');
$tablecontent = $this->getRequestData($sort, $by, $pageNo, $perPage, $searchQuery, $grid_type, $status_value);
$menu_name_arr = $this->getServicemenunames();
$menuName = $menu_name_arr[$grid_type];
$dataTmp = array('sort' => $sort, 'by' => $by, 'menuName' => $menuName, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent['table_content'], 'row_count' => $tablecontent['count'], 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'call' => $call, 'grid_type' => $grid_type, 'status_value' => $status_value, 'view_link' => DOMAIN . 'servicerequests/view/id/{{id}}/t/' . sapp_Global::_encrypt($grid_type) . ($status_value != '' ? "/v/" . sapp_Global::_encrypt($status_value) : ""), 'add_link' => DOMAIN . 'servicerequests/add/t/' . sapp_Global::_encrypt($grid_type) . ($status_value != '' ? "/v/" . sapp_Global::_encrypt($status_value) : ""), 'dashboardcall' => $dashboardcall, 'search_filters' => array('priority' => array('type' => 'select', 'filter_data' => $bool_arr), 'createddate' => array('type' => 'datepicker')));
if ($grid_type_arr[$grid_type] == 'request') {
$dataTmp['add'] = 'add';
}
return $dataTmp;
}
public function indexAction()
{
$empscreeningModel = new Default_Model_Empscreening();
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
$dashboardcall = $this->_getParam('dashboardcall');
$statusidstring = $this->_request->getParam('status');
$unitId = '';
if (!isset($statusidstring) || $statusidstring == '') {
$unitId = $this->_request->getParam('unitId');
$statusidstring = $unitId;
}
$formgrid = 'true';
if (isset($unitId) && $unitId != '') {
$formgrid = 'true';
}
$statusid = sapp_Global::_decrypt($statusidstring);
if ($statusid != '1' && $statusid != '2') {
$statusidstring = sapp_Global::_encrypt(1);
}
$queryflag = '';
unset($_SESSION['emp_status']);
if ($statusid != '') {
$_SESSION['emp_status'] = $statusidstring;
if ($statusid == '1') {
$queryflag = '1';
$this->view->ermsg = '';
} else {
if ($statusid == '2') {
$queryflag = '2';
$this->view->ermsg = '';
} else {
$this->view->ermsg = 'nodata';
$queryflag = '1';
}
}
} else {
$queryflag = '1';
}
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'me.modifieddate';
$pageNo = 1;
$searchData = '';
$searchQuery = '';
$searchArray = '';
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'me.modifieddate';
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$pageNo = $this->_getParam('page', 1);
$searchData = $this->_getParam('searchData');
$searchData = rtrim($searchData, ',');
$searchData = $this->_getParam('searchData');
}
$dataTmp = $empscreeningModel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $queryflag, $statusidstring, $formgrid, $unitId);
array_push($data, $dataTmp);
$this->view->dataArray = $data;
$this->view->call = $call;
$this->view->statusidstring = $statusidstring;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
/**
*
*/
public function viewAction()
{
$request_form = new Default_Form_Servicerequest();
$id = $this->_getParam('id', null);
$grid_type = $this->_getParam('t', null);
$status_value = $this->_getParam('v', null);
$req_msg = "";
try {
if ($id != '' && $grid_type != '') {
$grid_type = sapp_Global::_decrypt($grid_type);
$sd_req_model = new Default_Model_Servicerequests();
$grid_type_arr = $sd_req_model->getGridtypearr();
if (is_numeric($id) && $id > 0 && is_numeric($grid_type) && $grid_type > 0 && array_key_exists($grid_type, $grid_type_arr)) {
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$login_bu = $auth->getStorage()->read()->businessunit_id;
$login_dept = $auth->getStorage()->read()->department_id;
}
$data = $sd_req_model->getRequestById($id);
if (!empty($data)) {
$approver_level = "view";
if (($grid_type_arr[$grid_type] == 'rept_app' || $grid_type_arr[$grid_type] == 'approver') && $data['status'] == 'To management approve') {
$approver_level = $sd_req_model->getApproverLevel($loginUserId, $id);
}
$canTicketEscalate = $sd_req_model->canTicketEscalate($loginUserId, $id);
$ticketFeedbackRating = $sd_req_model->isFeedbackProvided($id);
$request_Admins = $sd_req_model->getRequestAdmins($id);
$request_history = $sd_req_model->getRequestHistory($id);
$requester_length = 5;
$requester_history = $sd_req_model->getLastRequests($id, $data['raised_by'], $requester_length);
$emp_model = new Default_Model_Employee();
$service_conf_model = new Default_Model_Servicedeskconf();
$raised_by_details = $emp_model->getEmp_from_summary($data['raised_by']);
$other_approvers = $emp_model->get_Other_Approvers();
$app_data = $sd_req_model->getApprovers($data['service_desk_conf_id'], "config");
$app_details = $emp_model->getEmployeeDetails(implode(',', $app_data));
foreach ($app_data as $key => $value) {
$app_names[$key] = $app_details[$value];
}
$conf_data = $service_conf_model->getServiceDeskConfbyID($data['service_desk_conf_id']);
$exec_data = $emp_model->getEmployeeDetails($conf_data[0]['request_recievers']);
$this->view->id = $id;
$this->view->data = $data;
$this->view->grid_type = $grid_type_arr[$grid_type];
$this->view->grid_type_arr = $sd_req_model->getGridtypearr_rev();
$this->view->status_value = $status_value;
$this->view->approver_level = $approver_level;
$this->view->canTicketEscalate = $canTicketEscalate;
$this->view->ticketFeedbackRating = $ticketFeedbackRating;
$this->view->loginUserId = $loginUserId;
$this->view->request_Admins = $request_Admins;
$this->view->request_history = $request_history;
$this->view->requester_history = $requester_history;
$this->view->requester_length = $requester_length;
$this->view->raised_by_details = $raised_by_details;
$this->view->other_approvers = $other_approvers;
$this->view->app_names = $app_names;
$this->view->exec_data = $exec_data;
if ($this->getRequest()->getPost()) {
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
$req_id = $this->_getParam('hid_reqid', null);
$hid_status = $this->_getParam('hid_status', null);
$request_action = $this->_getParam('request_action', null);
$request_comments = trim($this->_getParam('request_comments', null));
//email stuff ------------Start
$sEmailData = $sd_req_model->getRequestDataForEmail($id);
$summary_data = $sd_req_model->getDataSummary($id);
$stoEmailAddress2 = $sd_req_model->getEmailAddress($sEmailData['raised_by']);
//mail for requester
$stoEmailAddress4 = $sd_req_model->getEmailAddress($sEmailData['executor_id']);
//mail for executor
$stoEmailAddress3 = constant('ITSUPPORT_0');
//$stoEmailAddress3 = $this->getSupportTeamEmailID($sEmailData['service_desk_conf_id']); //mail for support group
$sMailSubject = sprintf("%s - %s - %s - %s", $sEmailData['ticket_number'], $sEmailData['service_desk_name'], $sEmailData['service_request_name'], $hid_status);
$smessage = "The below service request status has been changed to " . $hid_status;
$this->mail_helper_action($sMailSubject, $smessage, $summary_data, $stoEmailAddress2);
$this->mail_helper_action($sMailSubject, $smessage, $summary_data, $stoEmailAddress3);
$this->mail_helper_action($sMailSubject, $smessage, $summary_data, $stoEmailAddress4);
//email stuff ------------End
switch ($hid_status) {
case "Cancelled":
$save_data = array('status' => 'Cancelled', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$req_msg['success'] = "Request cancelled successfully.";
//mailto: Requester, Supportgroup
break;
case "Duplicate":
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => 'Duplicate', 'executor_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
}
$req_msg['success'] = "Request marked as duplicate.";
break;
case "Need more Info":
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => 'Need more Info', 'executor_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
}
$req_msg['success'] = "Request need more information from requester.";
break;
case "Other Approval":
$otherapproverid = trim($this->_getParam('idothermanagerapprover_action', null));
$save_data = array('status' => 'To manager approve', 'executor_comments' => trim($request_comments), 'reporting_manager_id' => $otherapproverid, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$req_msg['success'] = "Request is waiting for approval.";
$stoEmailAddress1 = $sd_req_model->getEmailAddress($otherapproverid);
$this->mail_helper_action($sMailSubject, $smessage, $summary_data, $stoEmailAddress1);
break;
case "In progress":
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => 'In progress', 'executor_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
}
$req_msg['success'] = "Request is in progress.";
break;
case "Closed":
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => 'Closed', 'executor_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
}
$req_msg['success'] = "Request closed successfully.";
break;
case "Request Rejected":
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => 'Rejected', 'executor_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
}
$req_msg['success'] = "Request is rejected.";
break;
case "Approved":
$save_data = array('status' => 'Manager approved', 'reporting_manager_status' => 'Approve', 'reporting_manager_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$req_msg['success'] = "Request is approved.";
break;
case "Rejected":
$save_data = array('status' => 'Manager rejected', 'reporting_manager_status' => 'Reject', 'reporting_manager_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$req_msg['success'] = "Request is rejected.";
break;
case "escalate":
$save_data = array('modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$req_msg['success'] = "Request escalated sucessfully.";
break;
case "submitfeedback":
$save_data = array('feedback_comments' => trim($request_comments), 'feedback_rating' => trim($request_action), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$req_msg['success'] = "Feedback sucessfully submitted.";
break;
default:
//echo "do nothing";
$req_msg['success'] = "Request status " . $hid_status;
}
$sd_result = "";
if ($hid_status == "submitfeedback") {
$sd_result = $sd_req_model->SaveorUpdateRequestData($save_data, 'id = ' . $id);
} else {
if ($data['status'] != 'Closed' && $data['status'] != 'Rejected') {
$sd_result = $sd_req_model->SaveorUpdateRequestData($save_data, 'id = ' . $id);
}
}
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($req_msg['success']), 'emp_id' => $loginUserId, 'emp_name' => ucfirst($auth->getStorage()->read()->userfullname), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'comments' => trim($request_comments), 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($sd_result == 'update') {
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
//$this->send_req_mails($id);
//$req_msg['success'] = "Request " . ($request_action == 'Approve' ? "closed" : "rejected") . " successfully.";
} else {
$req_msg['error'] = "Some thing went wrong, please try again.";
}
$result = sapp_Global::logManager(SERVICEDESK, 2, $loginUserId, $id);
$trDb->commit();
$this->_helper->getHelper("FlashMessenger")->addMessage(array($req_msg));
$this->_redirect('servicerequests/index/t/' . sapp_Global::_encrypt($grid_type) . ($status_value != '' ? "/v/" . $status_value : ""));
} catch (Exception $ex) {
$trDb->rollBack();
$msgarray['executor_comments'] = "Something went wrong, please try again.";
}
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
$this->view->action_name = $this->getRequest()->getActionName();
}
public function viewAction()
{
$request_form = new Default_Form_Servicerequest();
$id = $this->_getParam('id', null);
$grid_type = $this->_getParam('t', null);
$status_value = $this->_getParam('v', null);
$req_msg = "";
try {
if ($id != '' && $grid_type != '') {
$grid_type = sapp_Global::_decrypt($grid_type);
$sd_req_model = new Default_Model_Servicerequests();
$grid_type_arr = $sd_req_model->getGridtypearr();
if (is_numeric($id) && $id > 0 && is_numeric($grid_type) && $grid_type > 0 && array_key_exists($grid_type, $grid_type_arr)) {
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$login_bu = $auth->getStorage()->read()->businessunit_id;
$login_dept = $auth->getStorage()->read()->department_id;
}
$data = $sd_req_model->getRequestById($id);
if (!empty($data)) {
$approver_level = "view";
if (($grid_type_arr[$grid_type] == 'rept_app' || $grid_type_arr[$grid_type] == 'approver') && $data['status'] == 'To management approve') {
$approver_level = $sd_req_model->getApproverLevel($loginUserId, $id);
}
$request_history = $sd_req_model->getRequestHistory($id);
$emp_model = new Default_Model_Employee();
$service_conf_model = new Default_Model_Servicedeskconf();
$raised_by_details = $emp_model->getEmp_from_summary($data['raised_by']);
$app_data = $sd_req_model->getApprovers($data['service_desk_conf_id'], "config");
$app_details = $emp_model->getEmployeeDetails(implode(',', $app_data));
foreach ($app_data as $key => $value) {
$app_names[$key] = $app_details[$value];
}
$conf_data = $service_conf_model->getServiceDeskConfbyID($data['service_desk_conf_id']);
$exec_data = $emp_model->getEmployeeDetails($conf_data[0]['request_recievers']);
$this->view->id = $id;
$this->view->data = $data;
$this->view->grid_type = $grid_type_arr[$grid_type];
$this->view->grid_type_arr = $sd_req_model->getGridtypearr_rev();
$this->view->status_value = $status_value;
$this->view->approver_level = $approver_level;
$this->view->loginUserId = $loginUserId;
$this->view->request_history = $request_history;
$this->view->raised_by_details = $raised_by_details;
$this->view->app_names = $app_names;
$this->view->exec_data = $exec_data;
if ($this->getRequest()->getPost()) {
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
$req_id = $this->_getParam('hid_reqid', null);
$hid_status = $this->_getParam('hid_status', null);
if ($hid_status != '' && $hid_status == 'Cancelled') {
$save_data = array('status' => $hid_status, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$sd_req_model->SaveorUpdateRequestData($save_data, 'id = ' . $id);
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($data['service_desk_name']) . " Request has been cancelled by ", 'emp_id' => $loginUserId, 'emp_name' => ucfirst($data['raised_by_name']), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
$req_msg['success'] = "Request cancelled successfully.";
} else {
if ($hid_status != '' && $hid_status == 'To management approve') {
$hid_app_pos = $this->_getParam('hid_app_pos', null);
$hid_max_app = $this->_getParam('hid_max_app', null);
if ($hid_app_pos == '' && $hid_max_app == '') {
$request_comments = trim($this->_getParam('request_comments', null));
if ($request_comments != '') {
$save_data = array('status' => "To management approve", 'to_mgmt_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$save_data = $save_data + $app_data;
$sd_result = "";
if ($data['status'] == 'Open') {
$sd_result = $sd_req_model->SaveorUpdateRequestData($save_data, 'status = "Open" and id = ' . $id);
}
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($data['service_desk_name']) . " Request has been sent for management approval by ", 'emp_id' => $loginUserId, 'emp_name' => ucfirst($auth->getStorage()->read()->userfullname), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'comments' => trim($request_comments), 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($sd_result == 'update') {
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
$this->send_req_mails($id);
$req_msg['success'] = "Request sent for management approval successfully.";
} else {
$req_msg['error'] = "Some thing went wrong, please try again.";
}
}
} else {
$request_comments = trim($this->_getParam('request_comments', null));
$request_action = $this->_getParam('request_action', null);
if ($request_comments != '' && $request_action != '') {
$save_data = array('approver_status_' . $approver_level['app_pos'] => $request_action, 'modifiedby' => $loginUserId, 'approver_' . $approver_level['app_pos'] . '_comments' => trim($request_comments), 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($request_action == 'Reject') {
$save_data['status'] = 'Management rejected';
}
if ($approver_level['app_pos'] == $approver_level['max_app']) {
$save_data['status'] = $request_action == 'Approve' ? "Management approved" : "Management rejected";
}
$sd_req_model->SaveorUpdateRequestData($save_data, 'id = ' . $id);
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($data['service_desk_name']) . " Request has been " . ($request_action == 'Approve' ? "approved" : "rejected") . " by ", 'emp_id' => $loginUserId, 'emp_name' => ucfirst($auth->getStorage()->read()->userfullname), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'comments' => trim($request_comments), 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
$this->send_req_mails($id);
$req_msg['success'] = "Request " . ($request_action == 'Approve' ? "approved" : "rejected") . " successfully.";
}
}
} else {
if ($hid_status != '' && $hid_status == 'To manager approve') {
if ($loginUserId == $data['reporting_manager_id']) {
$request_action = $this->_getParam('request_action', null);
$request_comments = trim($this->_getParam('request_comments', null));
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => $request_action == 'Approve' ? "Manager approved" : "Manager rejected", 'reporting_manager_status' => $request_action, 'reporting_manager_comments' => trim($request_comments), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$sd_req_model->SaveorUpdateRequestData($save_data, 'id = ' . $id);
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($data['service_desk_name']) . " Request has been " . ($request_action == 'Approve' ? "approved" : "rejected") . " by reporting manager ", 'emp_id' => $loginUserId, 'emp_name' => ucfirst($auth->getStorage()->read()->userfullname), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'isactive' => 1, 'comments' => trim($request_comments), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
$this->send_req_mails($id);
$req_msg['success'] = "Request " . ($request_action == 'Approve' ? "approved" : "rejected") . " successfully.";
}
} else {
$request_comments = trim($this->_getParam('request_comments', null));
if ($request_comments != '') {
$save_data = array('status' => "To manager approve", 'to_manager_comments' => trim($request_comments), 'reporting_manager_id' => $raised_by_details['reporting_manager'], 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$sd_result = "";
if ($data['status'] == 'Open') {
$sd_result = $sd_req_model->SaveorUpdateRequestData($save_data, 'status = "Open" and id = ' . $id);
}
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($data['service_desk_name']) . " Request has been sent for manager approval by ", 'emp_id' => $loginUserId, 'emp_name' => ucfirst($auth->getStorage()->read()->userfullname), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'comments' => trim($request_comments), 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($sd_result == 'update') {
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
$this->send_req_mails($id);
$req_msg['success'] = "Request sent for manager approval successfully.";
} else {
$req_msg['error'] = "Some thing went wrong, please try again.";
}
}
}
} else {
if ($hid_status != '' && $hid_status == 'Closed') {
$request_action = $this->_getParam('request_action', null);
$request_comments = trim($this->_getParam('request_comments', null));
if ($request_action != '' && $request_comments != '') {
$save_data = array('status' => $request_action == 'Approve' ? "Closed" : "Rejected", 'executor_comments' => trim($request_comments), 'executor_id' => $loginUserId, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$sd_result = "";
if ($data['status'] != 'Closed' && $data['status'] != 'Rejected') {
$sd_result = $sd_req_model->SaveorUpdateRequestData($save_data, 'id = ' . $id);
}
//start of saving history
$reqh_model = new Default_Model_Requesthistory();
$reqh_data = array('request_id' => $id, 'description' => ucfirst($data['service_desk_name']) . " Request has been " . ($request_action == 'Approve' ? "closed" : "rejected") . " by ", 'emp_id' => $loginUserId, 'emp_name' => ucfirst($auth->getStorage()->read()->userfullname), 'emp_profileimg' => $auth->getStorage()->read()->profileimg, 'createdby' => $loginUserId, 'modifiedby' => $loginUserId, 'comments' => trim($request_comments), 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($sd_result == 'update') {
$reqh_model->SaveorUpdateRhistory($reqh_data, '');
//end of saving history
$this->send_req_mails($id);
$req_msg['success'] = "Request " . ($request_action == 'Approve' ? "closed" : "rejected") . " successfully.";
} else {
$req_msg['error'] = "Some thing went wrong, please try again.";
}
}
}
}
}
}
$result = sapp_Global::logManager(SERVICEDESK, 2, $loginUserId, $id);
$trDb->commit();
$this->_helper->getHelper("FlashMessenger")->addMessage(array($req_msg));
$this->_redirect('servicerequests/index/t/' . sapp_Global::_encrypt($grid_type) . ($status_value != '' ? "/v/" . $status_value : ""));
} catch (Exception $ex) {
$trDb->rollBack();
$msgarray['executor_comments'] = "Something went wrong, please try again.";
}
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
$this->view->action_name = $this->getRequest()->getActionName();
}
public function savemngrorghierarchyAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$app_init_model = new Default_Model_Appraisalinit();
$ques_temp_model = new Default_Model_Appraisalqstemp();
$ques_org_model = new Default_Model_Appraisalqsmain();
$app_rating_model = new Default_Model_Appraisalratings();
// $init_id = $this->_getParam('init_id',null);
$init_param = $this->_getParam('i', null);
$init_id = sapp_Global::_decrypt($init_param);
$init_data = $app_init_model->getConfigData($init_id);
if (count($init_data) > 0) {
$init_data = $init_data[0];
}
$this->view->init_id = $init_id;
$this->view->init_data = $init_data;
$this->view->msg_arr = array();
$ratingsflag = 'false';
$checkRatingsExists = $app_rating_model->getAppraisalRatingsbyInitId($init_id);
if (!empty($checkRatingsExists)) {
$ratingsflag = 'true';
}
$red_result = "";
$type_arr = array('line' => 1, 'report' => 2);
$trDb = Zend_Db_Table::getDefaultAdapter();
//get manager ids as comma seperated string
$manager_ids = $this->_getParam('mid', null);
//break the manager ids into array
$mngr_ids_array = explode(',', $manager_ids);
$get_managers_data = array();
$get_managers_data = $app_init_model->getManagers_report($init_id);
$final_managers_data = array();
//get the managers data and build an array with manager id as key
if (isset($get_managers_data) && count($get_managers_data) > 0) {
foreach ($get_managers_data as $data) {
$mngr_id = isset($data['user_id']) ? $data['user_id'] : 0;
$final_managers_data[$mngr_id] = $data;
}
}
if (isset($mngr_ids_array) && count($mngr_ids_array) > 0) {
$choose_option = 'report';
foreach ($mngr_ids_array as $mngr) {
$tot_ids = array();
$context = 'add';
$content = array();
$content = $app_init_model->getdisplayacontentreportacc($init_id, $mngr);
if ($context == 'add') {
$init_sdata = array('manager_level_type' => $type_arr[$choose_option]);
$app_result = array();
$app_result = $app_init_model->SaveorUpdateAppraisalInitData($init_sdata, " id = " . $init_id);
$qresult = '';
if ($app_result === 'update') {
if (count($content) > 0) {
foreach ($content as $cont) {
if (is_numeric($cont['user_id'])) {
array_push($tot_ids, $cont['user_id']);
}
}
}
$line_str_arr = array();
$line_str_arr['line_manager_1'] = $mngr;
if (count($tot_ids) > 0) {
foreach ($tot_ids as $emp_id) {
$qdata = array('pa_initialization_id' => $init_id, 'manager_levels' => 1, 'employee_id' => $emp_id, 'module_flag' => 1, 'createdby' => $loginUserId, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"), 'isactive' => 1);
$qdata = array_merge($qdata, $line_str_arr);
if ($init_data['initialize_status'] == 1) {
$qresult = $ques_org_model->SaveorUpdatePrivilegeData($qdata, '');
} else {
$qresult = $ques_temp_model->SaveorUpdateData($qdata, '');
}
}
}
}
if ($qresult !== '' && $app_result !== '') {
$red_result = 'saved';
}
$message = "Appraisal process updated successfully";
}
}
if ($red_result === 'saved') {
$message = "Appraisal process updated successfully";
$this->_helper->FlashMessenger()->setNamespace('conf_success')->addMessage($message);
$this->_redirect('appraisalinit/confmanagers/i/' . sapp_Global::_encrypt($init_id));
}
}
$this->view->ratingsflag = $ratingsflag;
$this->render('configuremanagers');
}
public function pendingAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$leaverequestmodel = new Default_Model_Leaverequest();
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$dashboardcall = $this->_getParam('dashboardcall');
$statusidstring = $this->_request->getParam('status');
if (!isset($statusidstring) || $statusidstring == '') {
$unitId = $this->_request->getParam('unitId');
$statusidstring = $unitId;
}
$statusid = sapp_Global::_decrypt($statusidstring);
$queryflag = 'Pending';
$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'createddate';
$pageNo = 1;
$searchData = '';
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'createddate';
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$pageNo = $this->_getParam('page', 1);
/** search from grid - START * */
$searchData = $this->_getParam('searchData');
$searchData = rtrim($searchData, ',');
/** search from grid - END * */
}
$objName = 'manageremployeevacations';
$queryflag = "1";
$dataTmp = $leaverequestmodel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $objName, $queryflag);
array_push($data, $dataTmp);
$this->view->dataArray = $data;
$this->view->call = $call;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function indexAction()
{
$candidatesmodel = new Default_Model_Shortlistedcandidates();
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$dashboardcall = $this->_getParam('dashboardcall');
$queryflag = '';
$refresh = $this->_getParam('refresh');
$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$view = Zend_Layout::getMvcInstance()->getView();
$statusidstring = $this->_request->getParam('status');
$unitId = '';
if (!isset($statusidstring) || $statusidstring == '') {
$unitId = $this->_request->getParam('unitId');
$statusidstring = $unitId;
}
$formgrid = 'false';
if (isset($unitId) && $unitId != '') {
$formgrid = 'true';
}
$statusid = sapp_Global::_decrypt($statusidstring);
$queryflag = '';
unset($_SESSION['short_status']);
if ($statusid != '' && is_numeric($statusid)) {
$_SESSION['short_status'] = $statusidstring;
if ($statusid == 0) {
$queryflag = 'All';
} else {
if ($statusid == 2) {
$queryflag = 'Selected';
} else {
if ($statusid == 3) {
$queryflag = 'Rejected';
} else {
if ($statusid == 4) {
$queryflag = 'Offered';
} else {
if ($statusid == 5) {
$queryflag = 'Offer Accepted';
} else {
if ($statusid == 6) {
$queryflag = 'Joined';
} else {
if ($statusid == 7) {
$queryflag = 'On Hold';
} else {
if ($statusid == 8) {
$queryflag = 'Yet to offer';
} else {
if ($statusid == 9) {
$queryflag = 'Offer Declined';
}
}
}
}
}
}
}
}
}
// else if ($statusid == 1)
// $queryflag = 'Shortlisted';
} else {
$queryflag = 'All';
$statusid = 0;
$statusidstring = sapp_Global::_encrypt('0');
}
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'c.modifieddate';
$pageNo = 1;
$searchData = '';
$searchQuery = '';
$searchArray = array();
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'c.modifieddate';
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$pageNo = $this->_getParam('page', 1);
$searchData = $this->_getParam('searchData');
}
$dataTmp = $candidatesmodel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $queryflag, $statusidstring, $formgrid);
array_push($data, $dataTmp);
$this->view->dataArray = $dataTmp;
$this->view->call = $call;
$this->view->statusidstring = $statusidstring;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
<div class="header"> <div class="logo"></div></div>
<div class="content_wrapper" style="min-height:91px;">
<?php
if (sapp_Global::_decrypt($_GET['param']) == 'error') {
?>
<div class="error_mess">Installation failed,please re-install again.</div>
<?php
} else {
if (sapp_Global::_decrypt($_GET['param']) == 'db') {
?>
<div class="error_mess">Datbase error occurred.Please reinstall the sytem to proceed.</div>
<?php
} else {
if (sapp_Global::_decrypt($_GET['param']) == 'tbl') {
?>
<div class="error_mess">Please install database first to proceed.</div>
<?php
}
}
}
?>
</div>
</div>
</body>
</html>
<?php
} else {
header("Location: index.php");
}
public function getempcontentAction()
{
$post_values = $this->getRequest()->getPost();
if (count($post_values) > 0) {
$appraisal_id = sapp_Global::_decrypt($post_values['appraisal_id']);
$manager_id = sapp_Global::_decrypt($post_values['manager_id']);
$user_id = sapp_Global::_decrypt($post_values['user_id']);
$flag = sapp_Global::_decrypt($post_values['flag']);
$app_config_id = sapp_Global::_decrypt($post_values['app_config_id']);
$app_ratings = sapp_Global::_decrypt($post_values['app_rating']);
$emp_status = sapp_Global::_decrypt($post_values['emp_status']);
$key = $post_values['key'];
$appEmpRatingsModel = new Default_Model_Appraisalemployeeratings();
$data = array();
if ($appraisal_id != '' && $manager_id != '' && $user_id != '' && $flag != '') {
$model = new Default_Model_Appraisalmanager();
$data = $model->getempcontent($appraisal_id, $manager_id, $user_id, $flag, $app_config_id);
}
$appEmpQuesPrivData = $appEmpRatingsModel->getAppEmpQuesPrivData($appraisal_id, $user_id);
$hr_ques_previs = array();
$mgr_ques_previs = array();
$ratingType = array();
if ($appEmpQuesPrivData[0]['hr_group_qs_privileges']) {
$hr_ques_previs = json_decode($appEmpQuesPrivData[0]['hr_group_qs_privileges'], true);
}
if ($appEmpQuesPrivData[0]['manager_qs_privileges']) {
$mgr_ques_previs = json_decode($appEmpQuesPrivData[0]['manager_qs_privileges'], true);
}
$question_previs = $hr_ques_previs + $mgr_ques_previs;
// Get 'My Team Appraisal - Employee' skills
$emp_skills = $appEmpRatingsModel->getAppEmpSkills($appraisal_id, $user_id);
$this->view->data = $data;
$this->view->key = $key;
$this->view->flag = $flag;
$this->view->user_id = $user_id;
$this->view->emp_skills = $emp_skills;
$this->view->appraisal_id = $appraisal_id;
$this->view->emp_status = $emp_status;
$this->view->app_ratings = $app_ratings;
$this->view->question_previs = $question_previs;
}
}
public function assigngroupsAction()
{
$appraisalinitmodel = new Default_Model_Appraisalinit();
$appraisalGroupsModel = new Default_Model_Appraisalgroups();
$appraisalQsModel = new Default_Model_Appraisalquestions();
$app_rating_model = new Default_Model_Appraisalratings();
$init_param = $this->_getParam('i', null);
$init_id = sapp_Global::_decrypt($init_param);
$id = $init_id;
$employeeIds = '';
$groupIds = '';
$options = '';
$appraisalgroupName = '';
$data['empcount'] = '';
$groupflag = 'notassigned';
$msgarray = array();
$check_array = array();
$questionsArr = array();
$ratingsflag = 'false';
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
try {
if ($id) {
if (is_numeric($id) && $id > 0) {
$checkRatingsExists = $app_rating_model->getAppraisalRatingsbyInitId($id);
if (!empty($checkRatingsExists)) {
$ratingsflag = 'true';
}
$data = $appraisalinitmodel->getConfigData($id);
//echo '<pre>';print_r($data);exit;
if (!empty($data) && $data[0]['status'] == 1) {
$data = $data[0];
if ($data['initialize_status'] == 1) {
$tablename = 'main_pa_questions_privileges';
} else {
$tablename = 'main_pa_questions_privileges_temp';
}
if ($data['group_settings'] != 0) {
if ($data['group_settings'] == 1) {
$questionPrivileges = $appraisalQsModel->gethrquestionprivileges($id, $tablename, '');
if ($data['category_id'] != '' && $data['category_id'] != 'null') {
/*if($data['initialize_status'] == 1)
$questionsArr = $appraisalQsModel->getQuestionsByCategory($data['category_id'],$questionPrivileges['hr_qs']);
else*/
$questionsArr = $appraisalQsModel->getQuestionsByCategory($data['category_id'], '');
}
//echo '<pre>';print_r($questionPrivileges);exit;
if (!empty($questionPrivileges)) {
if (isset($questionPrivileges['hr_qs']) && isset($questionPrivileges['hr_group_qs_privileges'])) {
if ($questionPrivileges['hr_qs'] != '' && $questionPrivileges['hr_group_qs_privileges'] != '') {
$hr_qs_Arr = explode(',', $questionPrivileges['hr_qs']);
$hr_qs_privileges = json_decode($questionPrivileges['hr_group_qs_privileges'], true);
foreach ($hr_qs_privileges as $key => $val) {
//$val = explode(',',substr($val, 1, -1));
$check_array[$key] = $val;
}
}
}
}
$this->view->questionsArr = $questionsArr;
$this->view->checkArr = $check_array;
} else {
$groupEmployeeCountArr = $appraisalQsModel->getGroupEmployeeCount($id, $tablename);
$EmpCountArr = $appraisalQsModel->getGroupCountDetails($id, $tablename);
if (!empty($EmpCountArr)) {
$data['empcount'] = $EmpCountArr[0]['empcount'];
}
//echo '<pre>';print_r($groupEmployeeCountArr);exit;
$this->view->groupEmployeeCountArr = $groupEmployeeCountArr;
}
$this->view->msgarray = $msgarray;
}
if (sapp_Global::_checkprivileges(APPRAISALQUESTIONS, $loginuserGroup, $loginuserRole, 'edit') == 'Yes') {
$data['poppermission'] = 'yes';
}
$this->view->appraisalid = $id;
$this->view->encryptapprslid = $init_param;
$this->view->initializationdata = $data;
$this->view->ratingsflag = $ratingsflag;
if ($this->getRequest()->getPost()) {
$result = $this->savequestionPrivilegs($data);
$this->view->msgarray = $result;
}
$this->view->messages = $this->_helper->flashMessenger->getMessages();
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
}
