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