<input type = 'hidden' value='<?php echo $codeversion; ?> ' name='codeversion' id='codeversion'> <input type = 'hidden' value='<?php echo $dbversion; ?> ' name='dbversion' id='dbversion'> <input type = 'hidden' value='<?php echo $dbid; ?> ' name='dbid' id='dbid'> <input type = 'hidden' value='<?php echo $codeid; ?> ' name='codeid' id='codeid'> </form> <script> document.getElementById('upgrade').submit(); </script> <?php } } else { header("Location: error.php?param=" . sapp_Global::_encrypt('db') . ""); exit; } } catch (Exception $e) { header("Location: error.php?param=" . sapp_Global::_encrypt('error') . ""); exit; } //}
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 to delete a group which created by manager. * @return json Array of status and message. */ public function deletemanagergroupAction() { $post_values = $this->getRequest()->getPost(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $result = array('status' => 'fail', 'msg' => 'Something went wrong, please try again.', 'empcount' => '', 'appraisalid' => '', 'managerid' => ''); if (count($post_values) > 0) { $appraisal_id = $post_values['appraisal_id']; $manager_id = $post_values['manager_id']; $group_id = $post_values['group_id']; if ($appraisal_id != '' && $manager_id != '' && $group_id != '') { $trDb = Zend_Db_Table::getDefaultAdapter(); $trDb->beginTransaction(); try { $app_manager_model = new Default_Model_Appraisalmanager(); $delete_manager_group = $app_manager_model->deletemanagergroup($appraisal_id, $manager_id, $group_id); $EmpCountArr = $app_manager_model->getManagerGroupCount($appraisal_id, $loginUserId); if (!empty($EmpCountArr)) { $result['empcount'] = $EmpCountArr[0]['empcount']; } $trDb->commit(); $result['status'] = 'success'; $result['msg'] = "Group deleted successfully"; $result['appraisalid'] = sapp_Global::_encrypt($appraisal_id); $result['managerid'] = sapp_Global::_encrypt($manager_id); } catch (Exception $e) { $trDb->rollBack(); $result['status'] = 'error'; $result['msg'] = $e->getMessage(); } } } $this->_helper->json($result); }
/** * Function that Parses Extra Column info * * Regex looks for {{field_name}} * * @param string $column * @param array $p * @return string */ public function _parseExtra($column, $p) { if (isset($this->extra[$column])) { $val = ''; $characterlimit = 15; if (isset($this->extra[$column]['characterlimit'])) { $characterlimit = $this->extra[$column]['characterlimit']; } preg_match_all('/\\{\\{(.*?)\\}\\}/', $this->extra[$column]['value'], $matches); if (count($matches[1]) > 0) { $matches[1] = array_unique($matches[1]); $a = $this->extra[$column]['value']; foreach ($matches[1] as $match) { $p = (array) $p; $replaced_str = $p[$match]; if ($this->encrypt_status == 'yes') { $replaced_str = sapp_Global::_encrypt($p[$match]); } $a = str_replace('{{' . $match . '}}', $replaced_str, $a); preg_match_all('/\\[\\[(.*?)\\]\\]/', $a, $newMaches); if (count($newMaches[1]) > 0) { foreach ($newMaches[1] as $matchNew) { $valToInclude = strlen($p[$matchNew]) > $characterlimit ? substr($p[$matchNew], 0, $characterlimit) . ".." : $p[$matchNew]; $a = str_replace('[[' . $matchNew . ']]', $valToInclude, $a); } } } $val = $a; } return $val; } return ''; }
/** * 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 performancesteps($perfArray) { $request = Zend_Controller_Front::getInstance(); $controllerName = $request->getRequest()->getControllerName(); $actionName = $request->getRequest()->getActionName(); $step1_link = ""; $step2_link = ''; $step3_link = ''; if ($perfArray['appraisalid'] != '') { if ($perfArray['context'] == 'edit') { $step1_link = BASE_URL . "appraisalinit/edit/id/" . $perfArray['appraisalid']; $step2_link = BASE_URL . "appraisalinit/confmanagers/i/" . sapp_Global::_encrypt($perfArray['appraisalid']); if ($perfArray['step2status'] == 'Completed') { $step3_link = BASE_URL . "appraisalinit/assigngroups/i/" . sapp_Global::_encrypt($perfArray['appraisalid']); } } else { $step1_link = BASE_URL . "appraisalinit/view/id/" . $perfArray['appraisalid']; $step2_link = BASE_URL . "appraisalinit/viewconfmanagers/i/" . sapp_Global::_encrypt($perfArray['appraisalid']); if ($perfArray['step2status'] == 'Completed') { $step3_link = BASE_URL . "appraisalinit/viewassigngroups/i/" . sapp_Global::_encrypt($perfArray['appraisalid']); } } } ?> <script type="text/javascript" src="<?php echo MEDIA_PATH; ?> js/pa.js"></script> <div class="per_steps"> <ul class="toggle_ul"> <li id="initstep_1" class="step_1 incomplete" ><div class="step_round">Step<span class="num_txt">1</span></div> <div class="left_tab_content"> <div class="completed_icon"></div> <h3 class="tab_title">Initialization</h3> <span class="tab_txt">Initialize appraisal for a department or a business unit and enable to managers or employees</span> <?php if ($perfArray['step1status'] == 'Completed') { ?> <div class="status_txt complete_status"><?php echo $perfArray['step1status']; ?> </div> <?php } else { ?> <div class="status_txt in_progress"><?php echo $perfArray['step1status']; ?> </div> <?php } ?> </div> </li> <li id="initstep_2" class="step_2 incomplete"><div class="step_round">Step<span class="num_txt">2</span></div> <div class="left_tab_content"> <div class="completed_icon"></div> <h3 class="tab_title">Configure Line Managers</h3> <span class="tab_txt">Configure line managers by using the existing organization hierarchy or by assigning line managers to employees manually </span> <?php if ($perfArray['step2status'] == 'Completed') { ?> <div class="status_txt complete_status"><?php echo $perfArray['step2status']; ?> </div> <?php } else { ?> <div class="status_txt in_progress"><?php echo $perfArray['step2status']; ?> </div> <?php } ?> </div> </li> <li id="initstep_3" class="step_3 incomplete"><div class="step_round">Step<span class="num_txt">3</span></div> <div class="left_tab_content"> <div class="completed_icon"></div> <h3 class="tab_title">Configure Appraisal Parameters</h3> <span class="tab_txt">Set the appraisal parameters for all the employees or for an employee group for a department or a business unit</span> <?php if ($perfArray['step3status'] == 'Completed') { ?> <div class="status_txt complete_status"><?php echo $perfArray['step3status']; ?> </div> <?php } else { ?> <div class="status_txt in_progress"><?php echo $perfArray['step3status']; ?> </div> <?php } ?> </div> </li> </ul> <input type="hidden" id="ratingsflag" value="<?php echo $perfArray['ratingsflag'] == 'false' ? 2 : 1; ?> " > <?php if (isset($perfArray['appraisalid']) && $perfArray['appraisalid'] != '') { if ($actionName != 'view' && $actionName != 'edit') { ?> <div class="appdetails"> <?php sapp_PerformanceHelper::displayappdetails($perfArray['appraisalid']); ?> </div> <?php } } ?> <?php if (isset($perfArray['ratingsflag']) && $perfArray['ratingsflag'] == 'false') { ?> <div class='ml-alert-1-error' style="clear: both;position: relative;top: 17px;width: 92%;"> <div class='style-1-icon error'></div> Ratings not added for the appraisal. <a target ="_blank" href="<?php echo BASE_URL . 'appraisalratings/add'; ?> " style="color:#A31414;text-decoration: none;font-weight: bold;">Click here</a> to configure ratings. </div> <?php } ?> <script type="text/javascript" > $(document).ready(function(){ <?php if ($step1_link != '') { ?> $('#initstep_1').click(function(){ $.blockUI({ width:'50px',message: $("#spinner").html() }); window.location = '<?php echo $step1_link; ?> '; }); <?php } ?> <?php if ($step2_link != '') { ?> $('#initstep_2').click(function(){ $.blockUI({ width:'50px',message: $("#spinner").html() }); window.location = '<?php echo $step2_link; ?> '; }); <?php } if ($step3_link != '') { ?> $('#initstep_3').click(function(){ $.blockUI({ width:'50px',message: $("#spinner").html() }); window.location = '<?php echo $step3_link; ?> '; }); <?php } ?> <?php if ($perfArray['step1status'] == 'Completed') { ?> $("#initstep_1").removeClass('incomplete').addClass('complete'); <?php } ?> <?php if ($perfArray['step2status'] == 'Completed') { ?> $("#initstep_2").removeClass('incomplete').addClass('complete'); <?php } ?> <?php if ($perfArray['step3status'] == 'Completed') { ?> $("#initstep_3").removeClass('incomplete').addClass('complete'); <?php } ?> var currentpage = '<?php echo $perfArray['currentpage']; ?> '; $("#"+currentpage).addClass('active'); <?php if ($perfArray['currentpage'] != 'initstep_1') { ?> <?php if ($perfArray['context'] == 'edit') { ?> $(".breadcrumbs").append('<span class="arrows">›</span> <span>Edit</span>'); <?php } else { ?> $(".breadcrumbs").append('<span class="arrows">›</span> <span>View</span>'); <?php } ?> <?php } ?> <?php if ($perfArray['appraisalid'] == '') { ?> // $('#initstep_1').click(function(){ // jAlert("Configure appraisal details."); // }); $('#initstep_2').click(function(){ jAlert("Complete step 1 to configure step 2."); }); $('#initstep_3').click(function(){ jAlert("Complete step 2 to configure step 3."); }); <?php } ?> }); </script> <?php }
/** * * @param string $name * @param array $fields * @param Zend_Paginator_Instance $paginator * @param array $extracolumn * @param Bool $sorting * * @return string */ public function generateGrid($dataArray, $paginator, $extracolumn = array(), $sorting = false, $formgrid = 'false', $addaction = '', $menuName = '', $addpermission, $sortStr = '', $actnArr) { $view_link = isset($dataArray['view_link']) ? $dataArray['view_link'] : ""; $name = isset($dataArray['objectname']) ? $dataArray['objectname'] : ""; $by = isset($dataArray['by']) ? $dataArray['by'] : ""; $search_filters = isset($dataArray['search_filters']) ? $dataArray['search_filters'] : array(); $fields = isset($dataArray['tableheader']) ? $dataArray['tableheader'] : array(); $searchArray = isset($dataArray['searchArray']) ? $dataArray['searchArray'] : array(); $jsGridFnname = isset($dataArray['jsGridFnName']) ? $dataArray['jsGridFnName'] : ""; $perPage = isset($dataArray['perPage']) ? $dataArray['perPage'] : "20"; $page = isset($dataArray['pageNo']) ? $dataArray['pageNo'] : "1"; $call = isset($dataArray['call']) ? $dataArray['call'] : ""; $dashboardCall = isset($dataArray['dashboardcall']) ? $dataArray['dashboardcall'] : "No"; $sortname = isset($dataArray['sort']) ? $dataArray['sort'] : ""; $grid_type = isset($dataArray['grid_type']) ? $dataArray['grid_type'] : ""; $status_value = isset($dataArray['status_value']) ? $dataArray['status_value'] : ""; $add_link = isset($dataArray['add_link']) ? $dataArray['add_link'] : ""; $sd_req_model = new Default_Model_Servicerequests(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $request = Zend_Controller_Front::getInstance(); $params = $request->getRequest()->getParams(); $dataclass = ''; // Store Extra Columns $this->extra = $extracolumn; $sortIconStr = ""; $sort = Zend_Controller_Front::getInstance()->getRequest()->getParam('sort', 'DESC'); // checking and handling sorting. if ($sort == "") { $sortIconStr = "<span class='s-ico'>\r\n\t\t\t<span class='ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-n'></span>\r\n\t\t\t<span class='ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-s'></span></span>"; } else { if ($sort == 'ASC') { $sort = 'DESC'; //For Sort Icons.... $sortIconStr = "<span class='s-ico'>\r\n\t\t\t<span class='ui-icon-desc ui-icon ui-icon-triangle-1-n'></span>\r\n\t\t\t</span>"; } else { $sort = 'ASC'; //For Sort Icons.... $sortIconStr = "<span class='s-ico'>\r\n\t\t\t<span class='ui-icon-asc ui-icon ui-icon-triangle-1-s'></span></span>"; } } if ($call != "ajaxcall") { $sortIconStr = ""; } if ($addaction != '') { $action = $addaction; } $con = ''; $output = "<div class='table-header'><span>" . $menuName . "</span>"; if ($addaction != '') { $output .= "<div class='add-btn-div'>"; if ($add_link != '') { $output .= "<input type='button' title = 'Raise a Request' onclick='window.location.href=\"" . $add_link . "\"' value='Raise a Request' class='sprite addrequest' />"; } else { $output .= "<input type='button' title = 'Raise a Request' onclick='window.location.href=\"" . DOMAIN . $name . '/' . $action . "\"' value='Raise a Request' class='sprite addrequest' />"; } $output .= "</div>"; } $output .= "</div>"; if ($addpermission == 'false') { $output = "<div class='table-header'><span>" . $menuName . "</span></div>"; } $output .= "<div id='" . $name . "' class='details_data_display_block newtablegrid'>"; $output .= "<table class='grid' align='center' width='100%' cellspacing='0' cellpadding='4' border='0'><thead><tr>"; // this foreach loop display the column header in �th� tag. $colinr = 0; if (!empty($fields)) { $tabindx = 0; if (empty($actnArr)) { unset($fields['action']); } foreach ($fields as $key => $value) { if (isset($value['align'])) { $align = $value['align'] != '' ? 'align="' . $value['align'] . '" ' : ''; } if (isset($value['sortkey'])) { $sortkey = $value['sortkey'] != '' ? 'align="' . $value['sortkey'] . '" ' : ''; } if (isset($value['style'])) { $style = $value['style'] != '' ? 'style="' . $value['style'] . '" ' : ''; } $value = is_array($value) && !isset($value['sortkey']) ? $value['value'] : $value; if ($value == 'Action') { $width = 'width=90'; } else { $width = ''; } $output .= "<th " . $width . ">"; // Check if Sorting is set to True if ($sorting) { // Disable Sorting if Key is in Extra Columns if (@$this->extra[$key]['name'] != '' && !is_array($value)) { if ($value == "Action") { $output .= "<span class='action-text'>Action</span>"; } else { $output .= $value; } } else { if (is_array($value)) { $key = $value['sortkey']; $value = $value['value']; } $welcome = 'false'; $urlString = $_SERVER['REQUEST_URI']; if (strpos($urlString, 'welcome') !== false) { $welcome = 'true'; } if ($formgrid == 'true') { $output .= "<a href='javascript:void(0);' onclick=javascript:paginationndsorting('" . DOMAIN . $name . "/index/sort/" . $sort . "/by/" . $key . "/objname/" . $name . "/page/" . $page . "/per_page/" . $perPage . "/call/ajaxcall/{$con}/');>" . $value . "</a>"; //For Sort Icons.... if ($key == $sortStr) { $output .= $sortIconStr; } } else { if ($welcome == 'true') { $output .= "<a href='javascript:void(0);' onclick=javascript:paginationndsorting('" . DOMAIN . $name . "/index/sort/" . $sort . "/by/" . $key . "/objname/" . $name . "/page/" . $page . "/per_page/" . $perPage . "/call/ajaxcall/{$con}/');>" . $value . "</a>"; //For Sort Icons.... if ($key == $sortStr) { $output .= $sortIconStr; } } else { $output .= "<a href='javascript:void(0);' onclick=javascript:paginationndsorting('" . $this->view->url(array('sort' => $sort, 'by' => $key, 'objname' => $name, 'page' => $page, 'per_page' => $perPage)) . "');>" . $value . "</a>"; //For Sort Icons.... if ($key == $sortStr) { $output .= $sortIconStr; } } } } } else { //For Sort Icons.... if ($key == $sortStr) { $output .= $sortIconStr; } $output .= $value; } $output .= "</th>"; $colinr++; $tabindx++; } //end of for each loop $output .= "</tr><tr id='search_tr_{$name}'>"; $tabindx = 0; foreach ($fields as $key => $value) { if (isset($value['align'])) { $align = @$value['align'] != '' ? 'align="' . $value['align'] . '" ' : ''; } if (isset($value['sortkey'])) { $sortkey = @$value['sortkey'] != '' ? 'align="' . $value['sortkey'] . '" ' : ''; } if (isset($value['style'])) { $style = @$value['style'] != '' ? 'style="' . $value['style'] . '" ' : ''; } $value = is_array($value) && !isset($value['sortkey']) ? $value['value'] : $value; if ($value == 'Action') { $width = 'width=90'; } else { $width = ''; } $output .= "<th " . $width . ">"; // Check if Sorting is set to True if ($sorting) { // Disable Sorting if Key is in Extra Columns if (@$this->extra[$key]['name'] != '' && !is_array($value)) { if ($value == "Action") { $output .= "<span class='action-text'></span>"; } else { $output .= $value; } } else { if (is_array($value)) { $key = $value['sortkey']; $value = $value['value']; } $welcome = 'false'; $urlString = $_SERVER['REQUEST_URI']; if ($key != 'id') { $sText = ''; if (!empty($searchArray)) { $display = 'display: block;'; } else { $display = 'display: none;'; } if (is_array($searchArray)) { if (array_key_exists($key, $searchArray)) { $sText = $searchArray[$key]; } else { $sText = ''; } } if (isset($search_filters[$key])) { $search_function = 'getsearchdata("' . $name . '","",this.id,event'; $output .= sapp_Global::grid_data($search_filters, $key, $name, $display, $sText, $tabindx, $search_function); } else { $output .= "<input tabIndex={$tabindx} type='text' name='{$name}' id='{$key}' style='{$display}' class='searchtxtbox_{$name} table_inputs grid_search_inputs' value='{$sText}' onkeydown='getsearchdata(\"{$name}\",\"\",this.id,event,\"text\")' />"; } } } } else { //For Sort Icons.... if ($key == $sortStr) { $output .= $sortIconStr; } $output .= $value; } $output .= "</th>"; $colinr++; $tabindx++; } //end of for each loop } if ($grid_type != '') { $output .= "<input type='hidden' id='service_grid' value='" . sapp_Global::_encrypt($grid_type) . "' />"; } if ($status_value != '') { $output .= "<input type='hidden' id='service_grid_status' value='" . sapp_Global::_encrypt($status_value) . "' />"; } $output .= "</tr></thead>"; $output .= "<tbody>"; // Start Looping Data $ii = 0; foreach ($paginator as $p) { $cell_color = $ii % 2 == 0 ? "row1" : "row2"; $ii++; $bodyCount = 0; //$output.="<tr onclick='window.location=\"" . $this->_parseString($view_link, $p) . "\"' class='$cell_color cursor'>"; $output .= "<tr class='{$cell_color} '>"; // Reset Fields Array to Top if (!empty($fields)) { reset($fields); foreach ($fields as $k => $v) { $tdclass = ''; // Look for additional attributes $characterlimit = 40; if (is_array($v)) { $class = @$v['class'] != '' ? 'class="' . $v['class'] . '" ' : ''; $align = @$v['align'] != '' ? 'align="' . $v['align'] . '" ' : ''; $valign = @$v['valign'] != '' ? 'valign="' . $v['valign'] . '" ' : ''; if (isset($v['characterlimit'])) { $characterlimit = $v['characterlimit']; } $output .= "<td {$tdclass}{$align}{$valign}>"; } else { if ($k == 'description' && $menuName == 'Screening Types') { $characterlimit = 80; } $output .= "<td {$tdclass}>"; } // Check to see if this Field is in Extra Columns if (isset($this->extra[$k]['value'])) { $output .= $this->_parseExtra($k, $p); } else { $valToInclude = strlen(trim($p[$k])) > $characterlimit ? substr(trim($p[$k]), 0, $characterlimit) . ".." : trim($p[$k]); if ($k == 'executor_id') { if (!empty($valToInclude)) { #$output .= "<span " . $dataclass . " title='" . htmlentities(trim($p[$k]), ENT_QUOTES, "UTF-8") . "' ><a onclick='displaydeptform(\'' . DOMAIN . $name . '/assignservicerequestpopup/id/{{id}}') name='{{id}}'>Allocate Executor</a></span>"; $isAdmin = $sd_req_model->IsAdminForServiceTicket($loginUserId, $p["ticket_number"]); if ($isAdmin == "1") { $output .= "<span " . $dataclass . " title='" . htmlentities(trim($p[$k]), ENT_QUOTES, "UTF-8") . "' ><a href='" . DOMAIN . $name . '/assignservicerequestpopup/id/' . $p["id"] . "' target='_blank'>" . ($valToInclude == -1 ? "Allocate" : "Reallocate") . " Executor</a></span>"; } } } else { if ($k == 'ticket_number') { if (!empty($valToInclude)) { $temp_ticketnumber = "<span " . $dataclass . " title='" . htmlentities(trim($p[$k]), ENT_QUOTES, "UTF-8") . "' >" . htmlentities($valToInclude, ENT_QUOTES, "UTF-8") . "</span>"; $output .= "<span " . $dataclass . " title='" . htmlentities(trim($p[$k]), ENT_QUOTES, "UTF-8") . "' ><a href='" . $this->_parseString($view_link, $p) . "'>" . $temp_ticketnumber . "</a></span>"; } } else { $p = (array) $p; if (isset($p[$k])) { $output .= "<span " . $dataclass . " title='" . htmlentities(trim($p[$k]), ENT_QUOTES, "UTF-8") . "' >" . htmlentities($valToInclude, ENT_QUOTES, "UTF-8") . "</span>"; } // Customize grid fields data - END } } } $dataclass = ''; $output .= "</td>"; $bodyCount++; } } // Close the Table Row $output .= "</tr>"; } if ($ii == 0) { $output .= "<tr><td colspan='{$colinr}' class='no-data-td'><p class='no-data'>No data found</p></td></tr>"; } $output .= "</tbody>"; $output .= "</table>\r\n <script type='text/javascript' language='javascript'>\r\n \$(document).ready(function(){ \r\n if(\$('.searchtxtbox_" . $name . "').is(':visible'))\r\n { \r\n \$('#search_tr_" . $name . "').show();\t\r\n }\r\n else \r\n \$('#search_tr_" . $name . "').hide();\t\r\n });\r\n </script> \r\n </div>"; // Attach Pagination if ($paginator) { $params = array(); $params['jsGridFnName'] = $jsGridFnname; $params['perPage'] = $perPage; $params['objname'] = $name; $params['searchArray'] = $searchArray; $params['formgrid'] = $formgrid; $params['con'] = $con; $params['dashboardcall'] = $dashboardCall; $params['sortname'] = $sortname; $params['by'] = $by; $output .= $this->view->paginationControl($paginator, 'Sliding', 'partials/pagination.phtml', $params); } $output .= "<script type='text/javascript' language='javascript'>\$('#{$name}').slimScrollHorizontal({\r\n\t\t\t\t\t\t\t\t\t alwaysVisible: false,\r\n\t\t\t\t\t\t\t\t\t start: 'left',\r\n\t\t\t\t\t\t\t\t\t position: 'bottom',\r\n\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t}).css({ background: '#ccc', paddingBottom: '10px' }); </script>"; $output .= "<script type='text/javascript' language='javascript'>\r\n\t\t\t\t\t\tvar id = \$('#columnId').val();\r\n\t\t\t\t\t\tvar coldata = \$('#'+id).val();\r\n\t\t\t\t\t\tvar focusID = \$('#columnId').val();\r\n var fval = \$('#'+focusID).attr('data-focus');\r\n if(fval == '' || fval == null)\r\n\t\t\t\t\t\t\$('#'+focusID).focus().val('').val(coldata);\r\n \r\n\t\t\t\t\t</script>"; return $output; }
<li><div class="folderstructure"><?php echo $path; ?> </div><div class="status_no"></div><div class="clear"></div></li> <?php } } ?> </ul> </div> <?php if ($cnt == 0) { ?> <button name="next" id="next" type="button" onclick="window.location='index.php?s=<?php echo sapp_Global::_encrypt(2); ?> ';">Next</button> <?php } ?> </form> <script type="text/javascript"> $(document).ready(function(){ <?php if ($cnt == 0) { ?>
/** * * @param type $sort * @param type $by * @param type $perPage * @param type $pageNo * @param type $searchData * @param type $call * @param type $dashboardcall * @param type $statusid * @param type $a1 * @param type $a2 * @param type $a3 * @return type */ public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $statusid, $a1, $a2, $a3) { $searchQuery = ''; $searchArray = array(); $data = array(); $requi_model = new Default_Model_Requisition(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserGroup = $auth->getStorage()->read()->group_id; } if ($searchData != '' && $searchData != 'undefined') { $searchValues = json_decode($searchData); if (count($searchValues) > 0) { foreach ($searchValues as $key => $val) { if ($key == 'onboard_date' || $key == 'r.createdon') { $searchQuery .= " date(" . $key . ") = '" . sapp_Global::change_date($val, 'database') . "' AND "; } else { $searchQuery .= " " . $key . " like '%" . $val . "%' AND "; } $searchArray[$key] = $val; } $searchQuery = rtrim($searchQuery, " AND"); } } $sarray = array('Approved' => 2, 'Rejected' => 3, 'Closed' => 4, 'On hold' => 5, 'In process' => 7); if ($statusid != '' && is_numeric($statusid)) { if ($statusid == 1) { $queryflag = 'Approved'; } else { if ($statusid == 2) { $queryflag = 'Approved'; } else { if ($statusid == 3) { $queryflag = 'Rejected'; } else { if ($statusid == 4) { $queryflag = 'Closed'; } else { if ($statusid == 5) { $queryflag = 'On hold'; } else { if ($statusid == 7) { $queryflag = 'In process'; } } } } } } $statusidstring = sapp_Global::_encrypt($statusid); } else { $statusid = 2; $queryflag = 'Approved'; $statusidstring = sapp_Global::_encrypt('2'); } $objName = 'approvedrequisitions'; $tableFields = array('action' => 'Action', 'requisition_code' => 'Requisition Code', 'jobtitle_name' => 'Job Title', 'createdby_name' => 'Raised By', 'reporting_manager_name' => 'Reporting Manager', 'r.createdon' => 'Raised On', 'onboard_date' => 'Due Date', 'hrexecutive_name' => 'Recruit Panel'); $search_filters = array('r.createdon' => array('type' => 'datepicker'), 'onboard_date' => array('type' => 'datepicker')); if ($dashboardcall == 'Yes') { $tableFields['req_status'] = "Status"; $search_filters['req_status'] = array('type' => 'select', 'filter_data' => array('Approved' => 'Approved', 'Closed' => 'Closed', 'On hold' => 'On hold', 'In process' => 'In process')); $statusid = 2; $queryflag = 'Approved'; $statusidstring = sapp_Global::_encrypt('2'); if (isset($searchArray['req_status'])) { $queryflag = $searchArray['req_status']; $statusidstring = sapp_Global::_encrypt($sarray[$queryflag]); $statusid = $sarray[$queryflag]; } } $tablecontent = $requi_model->getRequisitionData($sort, $by, $pageNo, $perPage, $searchQuery, $loginUserId, $loginuserGroup, 2, $queryflag); $dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'add' => 'add', 'searchArray' => $searchArray, 'menuName' => 'Approved Requisitions', 'formgrid' => 'true', 'unitId' => $statusidstring, 'call' => $call, 'dashboardcall' => $dashboardcall, 'search_filters' => $search_filters); if (($statusid == 4 || $statusid == 6) && ($loginuserGroup == HR_GROUP || $loginuserGroup == '')) { $dataTmp = $dataTmp + array('defined_actions' => array('view')); } return $dataTmp; }
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $objName, $queryflag, $unitId = '', $statusidstring = '') { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $searchQuery = ''; $searchArray = array(); $data = array(); if ($objName == 'manageremployeevacations') { if ($searchData != '' && $searchData != 'undefined') { $searchValues = json_decode($searchData); foreach ($searchValues as $key => $val) { if ($key == 'applieddate') { $searchQuery .= " l.createddate like '%" . sapp_Global::change_date($val, 'database') . "%' AND "; } else { if ($key == 'from_date' || $key == 'to_date') { $searchQuery .= " " . $key . " like '%" . sapp_Global::change_date($val, 'database') . "%' AND "; } else { $searchQuery .= " " . $key . " like '%" . $val . "%' AND "; } } $searchArray[$key] = $val; } $searchQuery = rtrim($searchQuery, " AND"); } $tableFields = array('action' => 'Action', 'userfullname' => 'Employee name', 'leavetype' => 'Leave type', 'leaveday' => 'Leave duration', 'from_date' => 'From date', 'to_date' => 'To date', 'reason' => 'Reason', 'leavestatus' => 'Status', 'appliedleavescount' => 'Leave count', 'applieddate' => 'Applied On'); $leave_arr = array('' => 'All', 1 => 'Full Day', 2 => 'Half Day'); $tablecontent = $this->getEmployeeLeaveRequest($sort, $by, $pageNo, $perPage, $searchQuery, $loginUserId); $dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'add' => 'add', 'call' => $call, 'dashboardcall' => $dashboardcall, 'search_filters' => array('from_date' => array('type' => 'datepicker'), 'to_date' => array('type' => 'datepicker'), 'applieddate' => array('type' => 'datepicker'), 'leaveday' => array('type' => 'select', 'filter_data' => $leave_arr))); } else { if ($objName == 'empleavesummary') { $managerstring = "true"; if ($searchData != '' && $searchData != 'undefined') { $searchValues = json_decode($searchData); foreach ($searchValues as $key => $val) { if ($key != 'leavestatus') { if ($key == 'reportingmanagername') { $searchQuery .= " u.userfullname like '%" . $val . "%' AND "; } else { if ($key == 'employeename') { $searchQuery .= " mu.userfullname like '%" . $val . "%' AND "; } else { if ($key == 'applieddate') { $searchQuery .= " l.createddate like '%" . sapp_Global::change_date($val, 'database') . "%' AND "; } else { if ($key == 'from_date' || $key == 'to_date') { $searchQuery .= " " . $key . " like '%" . sapp_Global::change_date($val, 'database') . "%' AND "; } else { $searchQuery .= " " . $key . " like '%" . $val . "%' AND "; } } } } } $searchArray[$key] = $val; } $searchQuery = rtrim($searchQuery, " AND"); } $statusid = ''; if ($queryflag != '') { $statusid = $queryflag; if ($statusid == 1) { $queryflag = 'pending'; } else { if ($statusid == 2) { $queryflag = 'approved'; } else { if ($statusid == 3) { $queryflag = 'rejected'; } else { if ($statusid == 4) { $queryflag = 'cancel'; } } } } } else { $queryflag = 'approved'; } $tableFields = array('action' => 'Action', 'employeename' => 'Leave applied by', 'leavetype' => 'Leave type', 'leaveday' => 'Leave duration', 'from_date' => 'From date', 'to_date' => 'To date', 'reason' => 'Reason', 'reportingmanagername' => 'Reporting Manager', 'appliedleavescount' => 'Leave count', 'applieddate' => 'Applied On'); $leave_arr = array('' => 'All', 1 => 'Full Day', 2 => 'Half Day'); $search_filters = array('from_date' => array('type' => 'datepicker'), 'to_date' => array('type' => 'datepicker'), 'applieddate' => array('type' => 'datepicker'), 'leaveday' => array('type' => 'select', 'filter_data' => $leave_arr)); /* This is for dashboard call. Here one additional column Status is build by passing it to table fields */ if ($dashboardcall == 'Yes') { $tableFields['leavestatus'] = "Status"; $search_filters['leavestatus'] = array('type' => 'select', 'filter_data' => array('pending' => 'Pending for approval', 'approved' => 'Approved', 'rejected' => 'Rejected', 'cancel' => 'Cancelled')); if (isset($searchArray['leavestatus'])) { $queryflag = $searchArray['leavestatus']; if ($queryflag == '') { $queryflag = 'pending'; } } } $tablecontent = $this->getLeaveStatusHistory($sort, $by, $pageNo, $perPage, $searchQuery, $queryflag, $loginUserId, $managerstring); if (isset($queryflag) && $queryflag != '') { $formgrid = 'true'; } else { $formgrid = ''; } $dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'add' => 'add', 'formgrid' => $formgrid, 'unitId' => sapp_Global::_encrypt($statusid), 'call' => $call, 'dashboardcall' => $dashboardcall, 'search_filters' => $search_filters); } else { if ($searchData != '' && $searchData != 'undefined') { $searchValues = json_decode($searchData); foreach ($searchValues as $key => $val) { if ($key == 'reportingmanagername') { $searchQuery .= " u.userfullname like '%" . $val . "%' AND "; } else { if ($key == 'applieddate') { $searchQuery .= " l.createddate like '%" . sapp_Global::change_date($val, 'database') . "%' AND "; } else { if ($key == 'from_date' || $key == 'to_date') { $searchQuery .= " " . $key . " like '%" . sapp_Global::change_date($val, 'database') . "%' AND "; } else { $searchQuery .= " " . $key . " like '%" . $val . "%' AND "; } } } $searchArray[$key] = $val; } $searchQuery = rtrim($searchQuery, " AND"); } $tableFields = array('action' => 'Action', 'leavetype' => 'Leave type', 'leaveday' => 'Leave duration', 'from_date' => 'From date', 'to_date' => 'To date', 'reason' => 'Reason', "reportingmanagername" => "Reporting Manager", 'appliedleavescount' => 'Leave count', 'applieddate' => 'Applied On'); $leave_arr = array('' => 'All', 1 => 'Full Day', 2 => 'Half Day'); $tablecontent = $this->getLeaveStatusHistory($sort, $by, $pageNo, $perPage, $searchQuery, $queryflag, $loginUserId); $dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'add' => 'add', 'call' => $call, 'dashboardcall' => $dashboardcall, 'search_filters' => array('from_date' => array('type' => 'datepicker'), 'to_date' => array('type' => 'datepicker'), 'applieddate' => array('type' => 'datepicker'), 'leaveday' => array('type' => 'select', 'filter_data' => $leave_arr))); } } return $dataTmp; }
/** * */ public function changestatusAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('objid'); $status = $this->_getParam('status', null); $grid_type = $this->_getParam('grid_type', null); $messages['message'] = ''; $messages['msgtype'] = ''; $actionflag = 3; if ($id != '') { $sd_req_model = new Default_Model_Servicerequests(); $grid_type_arr = $sd_req_model->getGridtypearr_rev(); $display_status = array('Cancelled' => 'cancelled', 'To manager approve' => ' sent for manager approve ', 'To management approve' => ' sent for approve', 'Closed' => 'closed'); $data = array('status' => $status, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId); if ($status != 'Cancelled') { $data['executor_id'] = $loginUserId; } if ($status == 'To manager approve') { $reporting_manager = $sd_req_model->getReptId($id); if ($reporting_manager != '') { $data['reporting_manager_id'] = $reporting_manager; } if ($reporting_manager != "" && $reporting_manager == $loginUserId) { $messages['message'] = 'Service desk request cannot be sent for manager approve.'; $messages['msgtype'] = 'error'; $messages['flagtype'] = 'dont_redirect'; $messages['grid_type'] = sapp_Global::_encrypt($grid_type_arr[$grid_type]); $this->_helper->json($messages); } } else { if ($status == 'To management approve') { $approver_arr = $sd_req_model->getApprovers($id, 'request'); $data = $data + $approver_arr; } } $where = array('id=?' => $id); $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $Id = $sd_req_model->SaveorUpdateRequestData($data, $where); if ($Id == 'update') { $result = sapp_Global::logManager(SERVICEDESKREQUEST, $actionflag, $loginUserId, $id); if ($status != 'Cancelled') { $this->send_req_mails($id); } $messages['message'] = 'Service desk request ' . $display_status[$status] . ' successfully.'; $messages['msgtype'] = 'success'; $messages['flagtype'] = 'sd_request'; $messages['grid_type'] = sapp_Global::_encrypt($grid_type_arr[$grid_type]); } else { $messages['message'] = 'Service desk request cannot be ' . $display_status[$status] . '.'; $messages['msgtype'] = 'error'; $messages['flagtype'] = 'sd_request'; $messages['grid_type'] = sapp_Global::_encrypt($grid_type_arr[$grid_type]); } $trDb->commit(); } catch (Exception $e) { $trDb->rollBack(); $messages['message'] = 'Service desk request cannot be ' . $display_status[$status] . '.'; $messages['msgtype'] = 'error'; $messages['flagtype'] = 'sd_request'; $messages['grid_type'] = sapp_Global::_encrypt($grid_type_arr[$grid_type]); } } else { $messages['message'] = 'Service desk request cannot be ' . $display_status[$status] . '.'; $messages['msgtype'] = 'error'; $messages['flagtype'] = 'sd_request'; $messages['grid_type'] = sapp_Global::_encrypt($grid_type_arr[$grid_type]); } $this->_helper->json($messages); }
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 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(); }
/** * This function helps to build URL to service desk. * @param int $grid_type = type of grid * @param int $status = status of service desk. * @return string Formatted URL. */ public static function sd_url_builder($grid_type, $status) { if ($status == '') { return BASE_URL . "/servicerequests/index/t/" . sapp_Global::_encrypt($grid_type); } else { return BASE_URL . "/servicerequests/index/t/" . sapp_Global::_encrypt($grid_type) . "/v/" . sapp_Global::_encrypt($status); } }
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 save($appraisalInitForm) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $appraisalInitModel = new Default_Model_Appraisalinit(); $msgarray = array(); $enable_step = $this->_request->getParam('enable_step'); if ($appraisalInitForm->isValid($this->_request->getPost()) && count($msgarray) == 0) { try { $id = $this->_request->getParam('id'); $businessunit_id = $this->_request->getParam('businessunit_id'); $pa_configured_id = $this->_request->getParam('configuration_id'); $department_id = $this->_request->getParam('department_id'); $appraisal_mode = $this->_request->getParam('appraisal_mode'); $appraisal_period = $this->_request->getParam('appraisal_period'); $from_year = $this->_request->getParam('from_year'); $to_year = $this->_request->getParam('to_year'); $eligibility = $this->_request->getParam('eligibility'); $status = $this->_request->getParam('status'); if (count($eligibility) > 0) { $eligibility = implode(',', $eligibility); } else { $eligibility = ''; } $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $data = array('businessunit_id' => $businessunit_id, 'pa_configured_id' => $pa_configured_id, 'department_id' => $department_id, 'enable_step' => $enable_step, 'appraisal_mode' => $appraisal_mode, 'appraisal_period' => $appraisal_period, 'from_year' => $from_year, 'to_year' => $to_year, 'eligibility' => $eligibility, 'status' => $status, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; } else { $data['createdby_role'] = $loginuserRole; $data['createdby_group'] = $loginuserGroup; $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $where = ''; $actionflag = 1; } $Id = $appraisalInitModel->SaveorUpdateAppraisalInitData($data, $where); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Initialization updated successfully.")); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Initialization added successfully.")); } $menuidArr = $menumodel->getMenuObjID('/appraisalinit'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $this->_redirect('appraisalinit/confmanagers/i/' . sapp_Global::_encrypt($tableid)); } catch (Exception $e) { $msgarray['businessunit_name'] = "Something went wrong, please try again."; return $msgarray; } } else { $messages = $appraisalInitForm->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } return $msgarray; } }
/** * */ public function leavecardreportAction() { $repModel = new Default_Model_Servicerequests(); $grid_type = $this->_getParam('t', sapp_Global::_encrypt('1')); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } if ($this->getRequest()->getPost()) { $hid_status = $this->_getParam('hid_status', null); $currmonth = $this->_getParam('monyy', null); } if ($currmonth == null) { $currmonth = "All"; } $leavesTable = $SDcountStr = $SDClosedcountStr = $daysStr = ''; if ($currmonth == "All") { $leavesTable = $this->ConvertArrayToGrid("Leave Card Details", $repModel->getLeaves(null, $loginUserId)); } else { $leavesTable = $this->ConvertArrayToGrid("Leave Card Details", $repModel->getLeaves($currmonth, $loginUserId)); } $this->view->SDOpenCloseGrid = $leavesTable; $this->view->SDMonthYear = $repModel->getLeavesMonthYear($loginUserId); $this->view->currentMonthYear = $currmonth; /* $this->view->SDcountStr = $SDcountStr; $this->view->SDClosedcountStr = $SDClosedcountStr; $this->view->daysStr = $daysStr; */ $this->view->grid_type = $grid_type; $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 updateprivilegesforallemployees($initializestep, $appraisaldata) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; $loginuserArr = array('loginuserid' => $loginUserId, 'loginuserrole' => $loginuserRole, 'loginusergroup' => $loginuserGroup); } $appraisalQsModel = new Default_Model_Appraisalquestions(); $app_init_model = new Default_Model_Appraisalinit(); $appraisalPrivMainModel = new Default_Model_Appraisalqsmain(); $appraisalPrivTempModel = new Default_Model_Appraisalqstemp(); $appraisalempratingsmodel = new Default_Model_Appraisalemployeeratings(); $usersmodel = new Default_Model_Users(); $departmentsmodel = new Default_Model_Departments(); $announcementsModel = new Default_Model_Announcements(); $deptids = ''; $title = 'Performance Appraisal'; $description = 'Performance appraisal initialized'; //echo '<pre>';print_r($this->getRequest()->getPost());exit; $questionArr = $this->_request->getParam('check'); $managercmntsArr = $this->_request->getParam('mgrcmnt'); $managerratingsArr = $this->_request->getParam('mgrrating'); $empratingsArr = $this->_request->getParam('empratings'); $empcmntsArr = $this->_request->getParam('empcmnt'); $appraisalid = $this->_request->getParam('appraisalid'); $initializeflag = $this->_request->getParam('initializeflag'); $initializestep = $this->_request->getParam('initializestep'); $group_settings = $this->_request->getParam('group_settings'); $finalarray = array(); $msgarray = array(); $mgrIndex = 'MC'; $mgrratIndex = 'MR'; $empIndex = 'EC'; $empratIndex = 'ER'; $questions = ''; $qsprivileges = ''; $trDb = Zend_Db_Table::getDefaultAdapter(); $trDb->beginTransaction(); try { if (!empty($questionArr)) { for ($i = 0; $i < sizeof($questionArr); $i++) { if (isset($managercmntsArr[$questionArr[$i]])) { $managercomments = 1; } else { $managercomments = 0; } if (isset($managerratingsArr[$questionArr[$i]])) { $managerratings = 1; } else { $managerratings = 0; } if (isset($empratingsArr[$questionArr[$i]])) { $empratings = 1; } else { $empratings = 0; } if (isset($empcmntsArr[$questionArr[$i]])) { $empcomments = 1; } else { $empcomments = 0; } /*$finalstring = '{'."$mgrratIndex:1,$mgrIndex:$managercomments,$empratIndex:$empratings,$empIndex:$empcomments".'}'; $finalarray[$questionArr[$i]] = $finalstring; $finalstring = '';*/ $commntsarry = array($mgrratIndex => $managerratings, $mgrIndex => $managercomments, $empratIndex => $empratings, $empIndex => $empcomments); $finalarray[$questionArr[$i]] = $commntsarry; } $questions = implode(',', $questionArr); $qsprivileges = json_encode($finalarray, true); $tablename = 'main_pa_questions_privileges_temp'; /* Updating Group settings if it is 0 */ if ($group_settings == 0) { $updatestatus = $app_init_model->updategroupsettings(1, $appraisalid); } /* End */ /* Updating privileges tables with questions */ $privilegesdata = array('hr_qs' => $questions, 'hr_group_qs_privileges' => $qsprivileges, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); $privielgeswhere = " pa_initialization_id = '" . $appraisalid . "' and module_flag=1 and isactive= 1 "; $updateprivileges = $appraisalPrivTempModel->SaveorUpdateData($privilegesdata, $privielgeswhere); //$updateprivileges = $appraisalQsModel->updatequestionprivileges($tablename,$questions, $qsprivileges,$appraisalid,$loginuserArr); /* End */ $initdata = array('initialize_status' => 2, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); $initwhere = array('id=?' => $appraisalid); /** Initialization * If initialize * Inserting to main table from temp table * Updating temp table to isactive 0 * Updating initialization status in initialization table * Sending mails to managers * Else * Updating initialization status in initialization table */ if ($initializestep == 1) { $initdata['initialize_status'] = 1; $insertQstable = $appraisalQsModel->insertQsData($appraisalid, $loginuserArr); $updateTmptable = $appraisalPrivTempModel->updateQsTempData($appraisalid, $loginuserArr); $app_init_model->SaveorUpdateAppraisalInitData($initdata, $initwhere); /** * Sending mails to managers OR employees based on enable step. */ if ($appraisaldata['enable_step'] == 1) { /** * Start * Sending Mails to Managers if enabled to managers */ $getLine1ManagerId = $appraisalPrivMainModel->getLine1ManagerIdMain($appraisalid); if (!empty($getLine1ManagerId)) { foreach ($getLine1ManagerId as $val) { $options['subject'] = APPLICATION_NAME . ': Performance Appraisal Initiated.'; $options['header'] = 'Performance Appraisal'; $options['toEmail'] = $val['emailaddress']; $options['toName'] = $val['userfullname']; $options['message'] = 'Dear ' . $val['userfullname'] . ', performance appraisal initiated.'; $options['cron'] = 'yes'; // sapp_Global::_sendEmail($options); } } /** * Mail to performance appraisal group */ if (defined('PER_APPRAISAL_' . $appraisaldata['businessunit_id']) && $appraisaldata['businessunit_id'] != '') { $options['subject'] = APPLICATION_NAME . ': Performance Appraisal Initiated To managers.'; $options['header'] = 'Performance Appraisal'; $options['toEmail'] = constant('PER_APPRAISAL_' . $appraisaldata['businessunit_id']); $options['toName'] = 'Performance Appraisal'; $options['message'] = 'Performance appraisal initiated to managers.'; $options['cron'] = 'yes'; //sapp_Global::_sendEmail($options); } /** * End */ } else { /** * Start * Inserting or Updating employee ratings table when enabled to employees * If record exists then updating else inserting */ $employeeidArr = $appraisalPrivMainModel->getemployeeIDs($appraisalid); if (!empty($employeeidArr)) { foreach ($employeeidArr as $emp) { $emprating_Arr = array('pa_initialization_id' => $appraisalid, 'employee_id' => $emp['employee_id'], 'line_manager_1' => $emp['line_manager_1'] != '' ? $emp['line_manager_1'] : NULL, 'line_manager_2' => $emp['line_manager_2'] != '' ? $emp['line_manager_2'] : NULL, 'line_manager_3' => $emp['line_manager_3'] != '' ? $emp['line_manager_3'] : NULL, 'line_manager_4' => $emp['line_manager_4'] != '' ? $emp['line_manager_4'] : NULL, 'line_manager_5' => $emp['line_manager_5'] != '' ? $emp['line_manager_5'] : NULL, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); $employeeexistArr = $appraisalempratingsmodel->checkEmployeeExists($appraisalid, $emp['employee_id']); if ($employeeexistArr[0]['empcount'] > 0) { $qwhere = " employee_id = '" . $emp['employee_id'] . "' and pa_initialization_id='" . $appraisalid . "' and isactive=1"; } else { $emprating_Arr['createdby'] = $loginUserId; $emprating_Arr['createdby_role'] = $loginuserRole; $emprating_Arr['createdby_group'] = $loginuserGroup; $emprating_Arr['createddate'] = gmdate("Y-m-d H:i:s"); $qwhere = ''; } $appraisalempratingsmodel->SaveorUpdateAppraisalSkillsData($emprating_Arr, $qwhere); /** * End */ /** Start * Sending Mails to employees */ $employeeDetailsArr = $usersmodel->getUserDetailsByID($emp['employee_id'], ''); if (!empty($employeeDetailsArr)) { $options['subject'] = APPLICATION_NAME . ': Performance Appraisal Initiated.'; $options['header'] = 'Performance Appraisal'; $options['toEmail'] = $employeeDetailsArr[0]['emailaddress']; $options['toName'] = $employeeDetailsArr[0]['userfullname']; $options['message'] = 'Dear ' . $employeeDetailsArr[0]['userfullname'] . ', performance appraisal initiated.'; $options['cron'] = 'yes'; // sapp_Global::_sendEmail($options); } /** * End */ } } if (defined('PER_APPRAISAL_' . $appraisaldata['businessunit_id']) && $appraisaldata['businessunit_id'] != '') { $options['subject'] = APPLICATION_NAME . ': Performance Appraisal Initiated To Employees.'; $options['header'] = 'Performance Appraisal'; $options['toEmail'] = constant('PER_APPRAISAL_' . $appraisaldata['businessunit_id']); $options['toName'] = 'Performance Appraisal'; $options['message'] = 'Performance appraisal initiated to employees.'; $options['cron'] = 'yes'; // sapp_Global::_sendEmail($options); } } /** * End Sending Mails and updating emp ratings table */ /** Start * Announecements */ if ($appraisaldata['enable_step'] == 2) { $appImpleData = sapp_PerformanceHelper::check_per_implmentation($appraisaldata['businessunit_id'], $appraisaldata['department_id']); if ($appImpleData['performance_app_flag'] == 1) { $deptArr = $departmentsmodel->getAllDeptsForUnit($appraisaldata['businessunit_id']); if (!empty($deptArr)) { foreach ($deptArr as $dept) { $deptids .= $dept['id'] . ','; } $deptids = rtrim($deptids, ','); } } else { $deptids = $initialize_Arr['deptid']; } /* $announcement_arr = array( 'businessunit_id' => $appraisaldata['businessunit_id']!=''?$appraisaldata['businessunit_id']:NULL, 'department_id' => $deptids!=''?$deptids:NULL, 'title' => $title, 'description' => $description, 'attachments' => NULL, 'status' => 2, 'isactive' => 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") ); $Id = $announcementsModel->SaveorUpdateAnnouncementsData($announcement_arr, ''); */ } /** * End */ sapp_PerformanceHelper::update_QsParmas_Allemps($questions, $appraisaldata['category_id']); } else { $app_init_model->SaveorUpdateAppraisalInitData($initdata, $initwhere); } $trDb->commit(); if ($initializestep == 1) { $msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => 'Appraisal initialized successfully')); $this->_redirect('appraisalinit'); } else { $msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => 'Appraisal configurations are saved to be initialized later.')); $this->_redirect('appraisalinit/assigngroups/i/' . sapp_Global::_encrypt($appraisalid)); } } } catch (Exception $e) { $trDb->rollBack(); $msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => $e->getMessage())); } return $msgarray; }