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