public function editAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->getRequest()->getParam('id');
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$appraisalinitform = new Default_Form_Appraisalinit();
$appraisalinitform->submit->setLabel('Update');
try {
if ($id) {
if (is_numeric($id) && $id > 0) {
$appraisalinitmodel = new Default_Model_Appraisalinit();
$data = $appraisalinitmodel->getConfigData($id);
if (!empty($data)) {
$empSummaryModel = new Default_Model_Employee();
$empData = $empSummaryModel->getEmp_from_summary($loginUserId);
$appraisalinitform->businessunit_name->setValue($empData['businessunit_name']);
$appraisalinitform->department_name->setValue($empData['department_name']);
$employmentstatusModel = new Default_Model_Employmentstatus();
$employmentStatusData = $employmentstatusModel->getempstatusActivelist();
if (!empty($employmentStatusData)) {
foreach ($employmentStatusData as $employmentStatusres) {
$appraisalinitform->eligibility->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
$data = $data[0];
$appraisalinitform->populate($data);
$appraisalinitform->setAttrib('action', DOMAIN . 'appraisalinit/edit/id/' . $id);
$this->view->data = $data;
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = '';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
$this->view->eligibility_value = $data['eligibility'];
$this->view->form = $appraisalinitform;
if ($this->getRequest()->getPost()) {
$result = $this->save($appraisalinitform);
$this->view->msgarray = $result;
}
$this->render('form');
}
public function getappraisalcategoryAction()
{
$this->_helper->layout->disableLayout();
$appraisalCategoryModel = new Default_Model_Appraisalcategory();
$appraisalinitmodel = new Default_Model_Appraisalinit();
$result['result'] = 'success';
$result['data'] = "<option value=''>Select Parameter</option>";
$categoryids = '';
$appraisalid = $this->_request->getParam('appraisalid');
$data = $appraisalinitmodel->getConfigData($appraisalid);
if (!empty($data)) {
$categoryids = $data[0]['category_id'];
}
if ($categoryids) {
$appraisalCategoriesData = $appraisalCategoryModel->getCategoryNameByIds($categoryids);
if (!empty($appraisalCategoriesData)) {
foreach ($appraisalCategoriesData as $data) {
$result['data'] .= "<option value='" . $data['id'] . "'>" . utf8_encode($data['category_name']) . "</option>";
}
} else {
$result['result'] = 'error';
$result['data'] = "Category names are not configured yet.";
}
} else {
$result['result'] = 'error';
$result['data'] = "Category names are not configured yet.";
}
$this->_helper->json($result);
}
/**
* This action is used to create new group by manager.It will serve as ajax call.
*/
public function createnewgroupAction()
{
$appraisal_id = $this->_getParam('appraisal_id', null);
$manager_id = $this->_getParam('manager_id', null);
$flag = $this->_getParam('flag', null);
$group_id = $this->_getParam('group_id', null);
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
try {
if ($appraisal_id != '' && $manager_id != '') {
$appraisal_id = sapp_Global::_decrypt($appraisal_id);
$manager_id = sapp_Global::_decrypt($manager_id);
if ($flag == 'edit') {
$group_id = sapp_Global::_decrypt($group_id);
}
$app_manager_model = new Default_Model_Appraisalmanager();
$appraisal_init_model = new Default_Model_Appraisalinit();
$appraisal_qs_model = new Default_Model_Appraisalquestions();
$check_array = array();
$tablename = 'main_pa_questions_privileges';
$manager_emp = $app_manager_model->getmanager_emp($appraisal_id, $manager_id, '');
if (empty($manager_emp) && $flag == 'add') {
$this->view->ermsg = 'No employees to add.';
}
$appraisaldata = $appraisal_init_model->getConfigData($appraisal_id);
$appraisaldata = $appraisaldata[0];
$questionPrivileges = $appraisal_qs_model->gethrquestionprivileges($appraisal_id, $tablename, '');
$questionsArr = $appraisal_qs_model->getQuestionsByCategory($appraisaldata['category_id'], '');
if (!empty($questionPrivileges)) {
if (isset($questionPrivileges['manager_qs']) && isset($questionPrivileges['manager_qs_privileges'])) {
if ($questionPrivileges['manager_qs'] != '' && $questionPrivileges['manager_qs_privileges'] != '') {
$hr_qs_Arr = explode(',', $questionPrivileges['manager_qs']);
$hr_qs_privileges = json_decode($questionPrivileges['manager_qs_privileges'], true);
foreach ($hr_qs_privileges as $key => $val) {
//$val = explode(',',substr($val, 1, -1));
$check_array[$key] = $val;
}
}
}
}
if (sapp_Global::_checkprivileges(APPRAISALQUESTIONS, $loginuserGroup, $loginuserRole, 'edit') == 'Yes') {
$appraisaldata['poppermission'] = 'yes';
}
$appraisaldata['poppermission'] = 'yes';
$manager_emp_selected = array();
$group_name = "";
if ($flag == 'edit') {
$app_group_model = new Default_Model_Appraisalgroups();
$group_details = $app_group_model->getAppraisalGroupsDatabyID($group_id);
if (!empty($group_details)) {
$group_details = $group_details[0];
$group_name = $group_details['group_name'];
$manager_emp_selected = $app_manager_model->getmanager_emp($appraisal_id, $manager_id, $group_id);
$manager_qs_privileges = json_decode($manager_emp_selected[0]['manager_qs_privileges'], true);
foreach ($manager_qs_privileges as $key => $val) {
$check_array[$key] = $val;
}
} else {
$this->view->ermsg = 'No data found.';
}
}
$view = $this->view;
$view->appraisal_id = $appraisal_id;
$view->manager_id = $manager_id;
$view->manager_emp = $manager_emp;
$view->questionsArr = $questionsArr;
$view->checkArr = $check_array;
$view->appraisaldata = $appraisaldata;
$view->checkArr = $check_array;
$view->flag = $flag;
$view->group_name = $group_name;
$view->group_id = $group_id;
$view->selected_emp = $manager_emp_selected;
} else {
$this->view->ermsg = 'No data found.';
}
} catch (Exception $ex) {
$this->view->ermsg = 'No data found.';
}
}
public function saveAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$loginuserFullName = $auth->getStorage()->read()->userfullname;
$loginuserProfileImg = $auth->getStorage()->read()->profileimg;
}
try {
$appEmpRatingsModel = new Default_Model_Appraisalemployeeratings();
$app_init_model = new Default_Model_Appraisalinit();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$id = $this->_request->getParam('id');
$employee_id = $this->_request->getParam('employee_id');
$initialization_id = $this->_request->getParam('initialization_id');
$config_id = $this->_request->getParam('config_id');
$flag = $this->_request->getParam('flag');
$app_status = $this->_request->getParam('app_status');
$mgr_levels = $this->_request->getParam('mgr_levels');
$ratingsData = $appEmpRatingsModel->getAppRatingsDataByConfgId($config_id, $initialization_id);
$ratingValues = array();
foreach ($ratingsData as $rd) {
$ratingValues[$rd['id']] = $rd['rating_value'];
}
$appData = array('modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$emp_rating_arr = $this->_request->getParam('emp_rating');
$emp_comment_arr = $this->_request->getParam('emp_comment');
$emp_response = array();
if (sizeof($emp_rating_arr) > 0 || sizeof($emp_comment_arr) > 0) {
foreach ($emp_rating_arr as $qid => $val) {
if (isset($emp_rating_arr[$qid])) {
$rating_id = array_search($emp_rating_arr[$qid], $ratingValues);
} else {
$rating_id = '';
}
$emp_response[$qid] = array('comment' => $emp_comment_arr[$qid], 'rating_id' => $rating_id);
}
}
$appData['employee_response'] = json_encode($emp_response, true);
$curent_level = array_search($app_status, $this->app_status_array);
if ($flag == 'submit') {
$appData['appraisal_status'] = $curent_level + 1;
$history_desc = $this->app_history_disc_array[$curent_level];
$appHistoryData = array('employee_id' => $employee_id, 'pa_initialization_id' => $initialization_id, 'description' => $history_desc, 'desc_emp_id' => $loginUserId, 'desc_emp_name' => $loginuserFullName, 'desc_emp_profileimg' => $loginuserProfileImg, 'createdby' => $loginUserId, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$appHistoryModel = new Default_Model_Appraisalhistory();
$result2 = $appHistoryModel->SaveorUpdateAppraisalHistoryData($appHistoryData);
/* Update employee response column */
$appraisaldata = $app_init_model->getConfigData($initialization_id);
if ($appraisaldata[0]['employee_response'] == 1) {
$initdata = array('employee_response' => 2, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$initwhere = array('id=?' => $initialization_id);
$app_init_model->SaveorUpdateAppraisalInitData($initdata, $initwhere);
}
}
$menuidArr = $menumodel->getMenuObjID('/appraisalconfig');
$menuID = $menuidArr[0]['id'];
//$result = sapp_Global::logManager($menuID,$actionflag,$loginUserId,$tableid);
$appWhere = array('id=?' => $id);
$result1 = $appEmpRatingsModel->SaveorUpdateAppraisalSkillsData($appData, $appWhere);
if ($result1) {
$msg = 'saved';
} else {
$msg = 'err';
}
} catch (Exception $e) {
// echo $e->getMessage();
//echo $e->getTrace();
//echo $e->getTraceAsString();
$msg = "Something went wrong, please try again.";
}
$this->_helper->json(array('msg' => $msg));
}
/**
*
* Edit function to prepopulate the data.
*
*/
public function editAction($id = '')
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$businessUnit = $auth->getStorage()->read()->businessunit_id;
$department = $auth->getStorage()->read()->department_id;
}
$appInitModel = new Default_Model_Appraisalinit();
$msgarray = array();
$buOptions = '';
$deptOptions = '';
if ($id == '') {
$id = $this->getRequest()->getParam('id');
}
if ($loginuserRole != SUPERADMINROLE && $loginuserGroup != MANAGEMENT_GROUP) {
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$appraisalratingsform = new Default_Form_Appraisalratings();
$appraisalratingsmodel = new Default_Model_Appraisalratings();
$performanceappflag = '';
$appraisalratingsform->submit->setLabel('Update');
$res = $appraisalratingsmodel->checkAccessAddratings($businessUnit, $department);
foreach ($res as $result) {
$appraisal_rating = $result['appraisal_ratings'];
}
$appraisal_rating = $appraisal_rating == 1 ? 5 : 10;
try {
if ($id) {
if (is_numeric($id) && $id > 0) {
$data = $appraisalratingsmodel->getAppraisalRatingsbyInitId($id);
if (!empty($data)) {
//$data = $data[0];
//echo "<pre>"; print_r($data);echo "</pre>";
// $appraisal_rating = 1;
$appInitdata = $appInitModel->getConfigData($data[0]['pa_initialization_id']);
$appraisalratingsform->setAttrib('action', DOMAIN . 'appraisalratings/edit/id/' . $id);
/* Fetch business unit and department name*/
$appImpleData = sapp_PerformanceHelper::check_per_implmentation($businessUnit, $department);
$performanceappflag = $appImpleData['performance_app_flag'];
$optionsArray = $this->buildoptions($businessUnit, $department, $performanceappflag);
$buOptions = $optionsArray['buoptions'];
$deptOptions = isset($optionsArray['deptoptions']) ? $optionsArray['deptoptions'] : '';
/* End */
$this->view->performanceappflag = $performanceappflag;
$this->view->buOptions = $buOptions;
$this->view->deptOptions = $deptOptions;
$this->view->data = $data;
$this->view->checkActiveApp = $appInitdata[0];
$this->view->appraisal_rating = $appraisal_rating;
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'norecord';
}
} else {
$this->view->ermsg = 'nodata';
}
} catch (Exception $e) {
$this->view->ermsg = 'nodata';
}
$this->view->form = $appraisalratingsform;
if ($this->getRequest()->getPost()) {
$result = $this->save($appraisalratingsform);
$this->view->msgarray = $result;
}
$this->render('form');
} else {
$buOptions = '';
$deptOptions = '';
$businessUnitId = '';
$department = '';
$deptArr = array();
$flag = 2;
$appraisaldataArr = $appInitModel->getAppDataById($id);
if (!empty($appraisaldataArr)) {
$businessUnitId = $appraisaldataArr['businessunit_id'];
$departmentId = $appraisaldataArr['department_id'] != 'null' ? $appraisaldataArr['department_id'] : '';
$appImpleData = sapp_PerformanceHelper::check_per_implmentation($businessUnitId, $departmentId);
$performanceappflag = $appImpleData['performance_app_flag'];
$optionsArray = $this->buildoptions($businessUnitId, $departmentId, $performanceappflag);
$buOptions = $optionsArray['buoptions'];
$deptOptions = isset($optionsArray['deptoptions']) ? $optionsArray['deptoptions'] : '';
}
if ($this->getRequest()->getPost()) {
$result = $this->save($appraisalratingsform);
$this->view->msgarray = $result;
}
$this->view->appraislaid = $id;
$this->view->performanceappflag = $performanceappflag;
$this->view->businessUnitId = $businessUnitId;
$this->view->departmentId = $departmentId;
$this->view->buOptions = $buOptions;
$this->view->deptOptions = $deptOptions;
$this->view->flag = $flag;
$this->render('managementform');
}
}
public function displaymanagersAction()
{
$ajaxContext = $this->_helper->getHelper('AjaxContext');
$ajaxContext->addActionContext('displaymanagers', 'html')->initContext();
$line1_data = array();
$line_managers = array();
$type = $this->_getParam('type', null);
$levels = $this->_getParam('levels', null);
$init_id = $this->_getParam('init_id', null);
$line1_id = $this->_getParam('line1_id', null);
$context = $this->_getParam('context', 'add');
$employeeid = $this->_getParam('employeeid');
$app_levels = 1;
$app_init_model = new Default_Model_Appraisalinit();
$appEmpRatingsModel = new Default_Model_Appraisalemployeeratings();
$init_data = $app_init_model->getConfigData($init_id);
if (count($init_data) > 0) {
$init_data = $init_data[0];
}
$managers = $app_init_model->getRepManagers_new($type, $init_id, $init_data);
if ($context == 'edit') {
$emp_model = new Default_Model_Employee();
$line1_data = $emp_model->getEmp_from_summary($line1_id);
$line_managers = $app_init_model->getLineManagers_new($init_id, $employeeid);
$line_managers = array_filter($line_managers);
}
$appEmpRatingsData = $appEmpRatingsModel->getSelectedAppraisalData_notused($init_id, $employeeid);
if (!empty($appEmpRatingsData)) {
if ($appEmpRatingsData['appstatus'] != 1) {
$app_levels = $appEmpRatingsData['appstatus'] - 1;
}
}
$this->view->levels = $levels;
$this->view->managers = $managers;
$this->view->init_id = $init_id;
$this->view->context = $context;
$this->view->line1_data = $line1_data;
$this->view->line_managers = $line_managers;
$this->view->line1_id = $line1_id;
$this->view->app_levels = $app_levels;
$this->render('displaymanagers');
}
public function saveAction()
{
$auth = Zend_Auth::getInstance();
$loginuserFullName = '';
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$loginuserProfileImg = $auth->getStorage()->read()->profileimg;
$loginuserEmail = $auth->getStorage()->read()->emailaddress;
$loginuserFullName = $auth->getStorage()->read()->userfullname;
$loginUserEmpId = $auth->getStorage()->read()->employeeId;
}
try {
$appEmpRatingsModel = new Default_Model_Appraisalemployeeratings();
$app_init_model = new Default_Model_Appraisalinit();
$id = $this->_request->getParam('id');
$employee_id = $this->_request->getParam('employee_id');
$initialization_id = $this->_request->getParam('initialization_id');
$config_id = $this->_request->getParam('config_id');
$flag = $this->_request->getParam('flag');
$app_status = $this->_request->getParam('app_status');
$mgr_levels = $this->_request->getParam('mgr_levels');
$ratingsData = $appEmpRatingsModel->getAppRatingsDataByConfgId($config_id, $initialization_id);
$ratingValues = array();
foreach ($ratingsData as $rd) {
$ratingValues[$rd['id']] = $rd['rating_value'];
}
$appData = array('modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$emp_rating_arr = $this->_request->getParam('emp_rating');
$emp_comment_arr = $this->_request->getParam('emp_comment');
$emp_response = array();
if (sizeof($emp_rating_arr) > 0 || sizeof($emp_comment_arr) > 0) {
foreach ($emp_rating_arr as $qid => $val) {
if (isset($emp_rating_arr[$qid])) {
$rating_id = array_search($emp_rating_arr[$qid], $ratingValues);
} else {
$rating_id = '';
}
$emp_response[$qid] = array('comment' => $emp_comment_arr[$qid], 'rating_id' => $rating_id);
}
}
$appData['employee_response'] = json_encode($emp_response, true);
$curent_level = array_search($app_status, $this->app_status_array);
if ($flag == 'submit') {
$appData['appraisal_status'] = $curent_level + 1;
$history_desc = $this->app_history_disc_array[$curent_level];
$appHistoryData = array('employee_id' => $employee_id, 'pa_initialization_id' => $initialization_id, 'description' => $history_desc, 'desc_emp_id' => $loginUserId, 'desc_emp_name' => $loginuserFullName, 'desc_emp_profileimg' => $loginuserProfileImg, 'createdby' => $loginUserId, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$appHistoryModel = new Default_Model_Appraisalhistory();
$result2 = $appHistoryModel->SaveorUpdateAppraisalHistoryData($appHistoryData);
/* Update employee response column */
$appraisaldata = $app_init_model->getConfigData($initialization_id);
if ($appraisaldata[0]['employee_response'] == 1) {
$initdata = array('employee_response' => 2, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$initwhere = array('id=?' => $initialization_id);
$app_init_model->SaveorUpdateAppraisalInitData($initdata, $initwhere);
}
/*
* Logs Storing
*/
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$actionflag = 1;
$menuidArr = $menumodel->getMenuObjID('/appraisalself');
$menuID = $menuidArr[0]['id'];
sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
/*
* Logs storing ends
*/
/** Start
* Sending Mails to employees
*/
//to get initialization details using appraisal Id for Business Unit,Department,To Year
$appraisalratingsmodel = new Default_Model_Appraisalratings();
$appraisal_details = $appraisalratingsmodel->getappdata($initialization_id);
if (!empty($appraisal_details)) {
$bunit = $appraisal_details['unitname'];
$dept = $appraisal_details['deptname'];
$to_year = $appraisal_details['to_year'];
}
$dept_str = $dept == '' ? " " : "and <b>{$dept}</b> department";
$emp_id_str = $loginuserRole == SUPERADMINROLE ? " " : "({$loginUserEmpId})";
$app_manager_model = new Default_Model_Appraisalmanager();
$getLineManager = $app_manager_model->getLineMgr($initialization_id, $loginUserId);
if (!empty($getLineManager)) {
$line_mgr = $getLineManager['line_manager_1'];
$employeeDetailsArr = $app_manager_model->getUserDetailsByEmpID($line_mgr);
$employeeDetailsArr = $employeeDetailsArr[0];
// Sending mail to Manager
if (!empty($employeeDetailsArr)) {
$options['subject'] = APPLICATION_NAME . ': Self Appraisal Submitted';
$options['header'] = "Performance Appraisal : {$to_year}";
$options['toEmail'] = $employeeDetailsArr['emailaddress'];
$options['toName'] = $employeeDetailsArr['userfullname'];
$options['message'] = "<div style='padding: 0; text-align: left; font-size:14px; font-family:Arial, Helvetica, sans-serif;'>\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style='color:#3b3b3b;'>Dear " . $employeeDetailsArr['userfullname'] . ",</span><br />\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div style='padding:20px 0 0 0;color:#3b3b3b;'> " . $loginuserFullName . $emp_id_str . " has submitted appraisal form.</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div style='padding:20px 0 10px 0;'>Please <a href=" . BASE_URL . " target='_blank' style='color:#b3512f;'>click here</a> to login to <b>" . APPLICATION_NAME . "</b> and check the appraisal ratings and comments.</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> ";
$mail_id = sapp_Global::_sendEmail($options);
}
}
//Sending mail to Employee
$options['subject'] = APPLICATION_NAME . ': Performance Appraisal Submitted to Line1 manager';
$options['header'] = "Performance Appraisal : {$to_year}";
$options['toEmail'] = $loginuserEmail;
$options['toName'] = $loginuserFullName;
$options['message'] = "<div style='padding: 0; text-align: left; font-size:14px; font-family:Arial, Helvetica, sans-serif;'>\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style='color:#3b3b3b;'>Dear {$loginuserFullName},</span><br />\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div style='padding:20px 0 0 0;color:#3b3b3b;'>Your appraisal form is submitted successfully to your Line1 Manager," . $employeeDetailsArr['userfullname'] . "(" . $employeeDetailsArr['employeeId'] . ") </div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div style='padding:20px 0 10px 0;'>Please <a href=" . BASE_URL . " target='_blank' style='color:#b3512f;'>click here</a> to login to your <b>" . APPLICATION_NAME . "</b> account.</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> ";
$mail_id = sapp_Global::_sendEmail($options);
}
/**
* End
*/
$appWhere = array('id=?' => $id);
$result1 = $appEmpRatingsModel->SaveorUpdateAppraisalSkillsData($appData, $appWhere);
if ($result1) {
$msg = 'saved';
} else {
$msg = 'err';
}
} catch (Exception $e) {
//echo $e->getMessage();
//echo $e->getTrace();
//echo $e->getTraceAsString();
$msg = "Something went wrong, please try again.";
}
$this->_helper->json(array('msg' => $msg));
}
public function validateconfigAction($from_year = 0, $to_year = 0, $bunit = 0, $dept_id = 0, $dept_flag = 0, $mode = 0, $call_flag = 0, $is_edit = 0, $appraisal_id = 0, $existing_period = '')
{
//if ajax call(to year on change)
if ($call_flag == 0) {
$from_year = $this->_getParam('from_year', null);
$to_year = $this->_getParam('to_year', null);
$bunit = $this->_getParam('bunit', null);
$dept_id = $this->_getParam('dept_id', null);
$dept_flag = $this->_getParam('flag', null);
$mode = $this->_getParam('mode', null);
$is_edit = $this->_getParam('is_edit', null);
$appraisal_id = $this->_getParam('appraisal_id', null);
$existing_period = $this->_getParam('existing_period', null);
}
$dept = isset($dept_flag) && $dept_flag == 0 ? $dept_id : 0;
$app_init_model = new Default_Model_Appraisalinit();
$exist_appraisal = $app_init_model->checkappadmin($bunit, $dept_id);
$json_status = 'fail';
$json_msg_str = '';
$json_app_mode = '';
$json_app_period = 0;
$json_app_disp_period = '';
$json_is_exist = 0;
$json_rating_type = '';
$existing_app_flag = $app_init_model->getexistingperformanceappflag($bunit, $from_year, $to_year);
$app_flag_diff = 0;
if (isset($existing_app_flag) && $existing_app_flag != $dept_flag) {
$app_flag_diff++;
}
if ($is_edit == 1) {
//get the data for the appraisal based on id to compare from year, to year and period
$appraisal_data = $app_init_model->getConfigData($appraisal_id);
$appr_from_year = isset($appraisal_data[0]['from_year']) ? $appraisal_data[0]['from_year'] : 0;
$appr_to_year = isset($appraisal_data[0]['to_year']) ? $appraisal_data[0]['to_year'] : 0;
$appr_mode = isset($appraisal_data[0]['appraisal_mode']) ? $appraisal_data[0]['appraisal_mode'] : '';
$appr_period = isset($appraisal_data[0]['appraisal_period']) ? $appraisal_data[0]['appraisal_period'] : 0;
$appraisal_ratings = isset($appraisal_data[0]['appraisal_ratings']) ? $appraisal_data[0]['appraisal_ratings'] : 0;
$actual_appr_period = $this->period_helper($appr_mode, $appr_period);
if ($from_year == $appr_from_year && $to_year == $appr_to_year && $existing_period == $actual_appr_period) {
if ($call_flag == 0) {
$this->_helper->json(array('status' => 'success', 'msg_str' => $json_msg_str, 'app_mode' => $appr_mode, 'app_period' => $appr_period, 'app_disp_period' => $actual_appr_period, 'is_exist' => 1, 'rating_type' => $appraisal_ratings));
return;
} else {
return 'success';
}
}
}
if ((!$exist_appraisal || $is_edit == 1) && $app_flag_diff == 0) {
//get the existing appraisal data using business unit
$appraisal_data = array();
$json_status = 'success';
// $json_mode = '';
$appraisal_data = $app_init_model->getAppraisalPeriodOnBuDept($bunit, $dept, $from_year, $to_year, 'AND');
$year_diff_exist = 0;
if (empty($appraisal_data)) {
$appraisal_data_diff = array();
//calculate the difference between toyear and from year
// if(is_numeric($from_year) && is_numeric($to_year))
// {
$year_diff = $to_year - $from_year;
// }
//if year difference is 0
if ($year_diff == 0) {
//check with from year or to year
$appraisal_data_diff = $app_init_model->getAppraisalPeriodOnBuDept($bunit, $dept, $from_year, $to_year, 'OR');
if (!empty($appraisal_data_diff)) {
$year_diff_exist++;
}
} else {
if ($year_diff == 1) {
//check with from year or (to year - 1)
$to_in_year = $to_year - 1;
$appraisal_data_diff = $app_init_model->getAppraisalPeriodOnBuDept($bunit, $dept, $from_year, $to_in_year, 'AND');
if (!empty($appraisal_data_diff)) {
$year_diff_exist++;
}
}
}
// if($year_diff_exist == 0 && $dept_flag == 0)
// {
// $appraisal_data = $app_init_model->getAppraisalPeriodOnBuDept($bunit,$dept,$from_year,$to_year,'AND',1);
// }
}
$exist_flag = 0;
$exist_str = '';
if (!$year_diff_exist) {
if (!empty($appraisal_data)) {
foreach ($appraisal_data as $app_data) {
$appraisal_mode = !empty($app_data['appraisal_mode']) ? $app_data['appraisal_mode'] : '';
$appraisal_period = !empty($app_data['appraisal_period']) ? $app_data['appraisal_period'] : 0;
// $appraisal_id = !empty($app_data['id'])?$app_data['id']:0;
switch ($appraisal_mode) {
case 'Quarterly':
if ($appraisal_period <= 4) {
$exist_flag++;
// $exist_str .= $appraisal_id.',';
}
break;
case 'Half-yearly':
if ($appraisal_period <= 2) {
$exist_flag++;
// $exist_str .= $appraisal_id.',';
}
break;
case 'Yearly':
if ($appraisal_period <= 1) {
$exist_flag++;
// $exist_str .= $appraisal_id.',';
}
break;
}
}
if ($exist_flag > 0) {
// $json_status = 'fail';
$exist_dept_flag = isset($appraisal_data[0]['performance_app_flag']) ? $appraisal_data[0]['performance_app_flag'] : '';
//if existing
// $json_app_mode = '';
// $json_app_period = 0;
if ($dept_flag == $exist_dept_flag) {
$appraisal_mode = isset($appraisal_data[0]['appraisal_mode']) ? $appraisal_data[0]['appraisal_mode'] : '';
$appraisal_period = isset($appraisal_data[0]['appraisal_period']) ? $appraisal_data[0]['appraisal_period'] : 0;
$appraisal_rating_type = isset($appraisal_data[0]['appraisal_ratings']) ? $appraisal_data[0]['appraisal_ratings'] : '';
$json_status = 'success';
switch ($appraisal_mode) {
case 'Quarterly':
if ($appraisal_period <= 4) {
$appraisal_period++;
if ($appraisal_period > 4) {
$json_status = 'fail';
}
}
break;
case 'Half-yearly':
if ($appraisal_period <= 2) {
$appraisal_period++;
if ($appraisal_period > 2) {
$json_status = 'fail';
}
}
break;
case 'Yearly':
if ($appraisal_period <= 1) {
$appraisal_period++;
if ($appraisal_period > 1) {
$json_status = 'fail';
}
}
break;
}
if ($json_status == 'fail') {
$json_msg_str = 'Appraisal is completed for the selected years.';
} else {
$json_app_period = $appraisal_period;
$json_app_mode = $appraisal_mode;
$json_app_disp_period = $this->period_helper($json_app_mode, $json_app_period);
$json_rating_type = $appraisal_rating_type;
}
$json_is_exist = 1;
} else {
$json_status = 'fail';
$json_msg_str = 'Appraisal is already configured ' . ($exist_dept_flag == 1 ? 'business unit' : 'department') . ' wise.';
$json_app_mode = '';
$json_app_period = 1;
}
} else {
$json_status = 'success';
$json_msg_str = '';
$json_app_mode = '';
$json_app_period = 1;
}
} else {
$json_status = 'success';
$json_msg_str = '';
$json_app_mode = '';
$json_app_period = 1;
}
} else {
$json_status = 'fail';
$json_msg_str = 'Please select valid year range.';
$json_app_mode = '';
$json_app_period = 0;
}
} else {
$json_msg_str = 'Appraisal already exist.';
}
// echo 'status '.$json_status.' msg_str '.$json_msg_str.' app_mode '.$json_app_mode.' app_period '.$json_app_period.' is_exist '.$json_is_exist;
// die();
if ($call_flag == 0) {
$this->_helper->json(array('status' => $json_status, 'msg_str' => $json_msg_str, 'app_mode' => $json_app_mode, 'app_period' => $json_app_period, 'app_disp_period' => $json_app_disp_period, 'is_exist' => $json_is_exist, 'rating_type' => $json_rating_type));
} else {
return $json_status;
}
}
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 initialize($appraisalid, $initflag)
{
$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();
$appraisalQsTmpModel = new Default_Model_Appraisalqstemp();
$app_init_model = new Default_Model_Appraisalinit();
$appraisalPrivTempModel = new Default_Model_Appraisalqstemp();
$appraisalPrivMainModel = new Default_Model_Appraisalqsmain();
$appraisalempratingsmodel = new Default_Model_Appraisalemployeeratings();
$usersmodel = new Default_Model_Users();
$departmentsmodel = new Default_Model_Departments();
$announcementsModel = new Default_Model_Announcements();
$deptids = '';
$questions = '';
$title = 'Performance Appraisal';
$description = 'Performance appraisal initialized';
$trDb = Zend_Db_Table::getDefaultAdapter();
$trDb->beginTransaction();
try {
$data = $app_init_model->getConfigData($appraisalid);
$appraisaldata = $data[0];
$qsdataArr = $appraisalPrivTempModel->getAppraisalQuestions($appraisalid);
if (!empty($qsdataArr)) {
foreach ($qsdataArr as $qs) {
$questions .= $qs['hr_qs'] . ',';
}
$questions = rtrim($questions, ',');
}
$questions = implode(',', array_keys(array_flip(explode(',', $questions))));
$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);
if ($initflag == 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 . ': Appraisal process initiated';
$options['header'] = 'Performance Appraisal';
$options['toEmail'] = $val['emailaddress'];
$options['toName'] = $val['userfullname'];
$options['message'] = 'Dear ' . $val['userfullname'] . ', Appraisal process 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 . ': Appraisal process initiated to managers.';
$options['header'] = 'Performance Appraisal';
$options['toEmail'] = constant('PER_APPRAISAL_' . $appraisaldata['businessunit_id']);
$options['toName'] = 'Performance Appraisal';
$options['message'] = 'Appraisal process 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 . ': Appraisal process initiated';
$options['header'] = 'Performance Appraisal';
$options['toEmail'] = $employeeDetailsArr[0]['emailaddress'];
$options['toName'] = $employeeDetailsArr[0]['userfullname'];
$options['message'] = 'Dear ' . $employeeDetailsArr[0]['userfullname'] . ', Appraisal process initiated';
$options['cron'] = 'yes';
// sapp_Global::_sendEmail($options);
}
/**
* End
*/
}
}
/**
* Mail to performance appraisal group
*/
if (defined('PER_APPRAISAL_' . $appraisaldata['businessunit_id']) && $appraisaldata['businessunit_id'] != '') {
$options['subject'] = APPLICATION_NAME . ': Appraisal process initiated to employees.';
$options['header'] = 'Performance Appraisal';
$options['toEmail'] = constant('PER_APPRAISAL_' . $appraisaldata['businessunit_id']);
$options['toName'] = 'Performance Appraisal';
$options['message'] = 'Appraisal process initiated to employees.';
$options['cron'] = 'yes';
// sapp_Global::_sendEmail($options);
}
/**
* End
*/
}
/**
* End Sending Mails and updating emp ratings table
*/
if ($appraisaldata['enable_step'] == 2) {
$appImpleData = sapp_PerformanceHelper::check_per_implmentation($appraisaldata['businessunit_id'], $appraisaldata['department_id']);
/** Start
* Announecements
*/
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 = $appraisaldata['department_id'];
}
/* $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 ($initflag == 1) {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => 'Appraisal initialized successfully'));
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => 'Appraisal configurations are saved to be initialized later'));
}
return 'success';
} catch (Exception $e) {
$trDb->rollBack();
return 'error';
}
}
