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 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));
}
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 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 closeappraisal($appraisalid, $status, $enablestepflag, $buid, $perfflag, $deptid)
{
$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);
}
$appraisalinitmodel = new Default_Model_Appraisalinit();
$appraisalqsmodel = 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 = '';
$title = 'Performance Appraisal';
$description = 'Performance appraisal initialized';
$result = array();
$employeeidArr = array();
if ($status == 2) {
$statustext = 'Closed';
} else {
$statustext = 'Forcefully Closed';
}
if ($appraisalid) {
$trDb = Zend_Db_Table::getDefaultAdapter();
$trDb->beginTransaction();
try {
/** Start
* Updating initialization table
*/
$init_Arr = array('status' => $status, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $appraisalid);
$Id = $appraisalinitmodel->SaveorUpdateAppraisalInitData($init_Arr, $where);
/**
End
*/
/** Start
* Sending Mails to employees
*/
if ($enablestepflag == 1) {
$employeeidArr = $appraisalqsmodel->getemployeeIDs($appraisalid);
} else {
$employeeidArr = $appraisalempratingsmodel->getEmployeeIds($appraisalid);
}
if (!empty($employeeidArr)) {
foreach ($employeeidArr as $emp) {
$employeeDetailsArr = $usersmodel->getUserDetailsByID($emp['employee_id'], '');
if (!empty($employeeDetailsArr)) {
$options['subject'] = APPLICATION_NAME . ': Performance Appraisal ' . $statustext;
$options['header'] = 'Performance Appraisal ' . $statustext;
$options['toEmail'] = $employeeDetailsArr[0]['emailaddress'];
$options['toName'] = $employeeDetailsArr[0]['userfullname'];
$options['message'] = 'Dear ' . $employeeDetailsArr[0]['userfullname'] . ', performance appraisal ' . $statustext;
$options['cron'] = 'yes';
// sapp_Global::_sendEmail($options);
}
}
}
/**
* End
*/
/**
* Mail to performance Appraisal Group
*/
if (defined('PER_APPRAISAL_' . $buid) && $buid != '') {
$options['subject'] = APPLICATION_NAME . ': Performance Appraisal ' . $statustext;
$options['header'] = 'Performance Appraisal';
$options['toEmail'] = constant('PER_APPRAISAL_' . $buid);
$options['toName'] = 'Performance Appraisal';
$options['message'] = 'Performance appraisal initiated ' . $statustext;
$options['cron'] = 'yes';
// sapp_Global::_sendEmail($options);
}
/**
* End
*/
/** Start
* Announecements
*/
if ($perfflag == 1) {
$deptArr = $departmentsmodel->getAllDeptsForUnit($buid);
if (!empty($deptArr)) {
foreach ($deptArr as $dept) {
$deptids .= $dept['id'] . ',';
}
$deptids = rtrim($deptids, ',');
}
} else {
$deptids = $deptid;
}
/* $announcement_arr = array(
'businessunit_id' => $buid!=''?$buid: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
*/
$trDb->commit();
$result['msg'] = 'Performance Appraisal ' . $statustext;
$result['result'] = 'success';
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Performance Appraisal " . $statustext));
} catch (Exception $e) {
$trDb->rollBack();
$result['msg'] = $e->getMessage();
$result['result'] = 'error';
}
}
return $result;
}
