/**
  * This action is used to save/edit group details created by manager.
  * @return json Array of status and message.
  */
 public function savemanagergroupAction()
 {
     $post_values = $this->getRequest()->getPost();
     //echo "<pre>";print_r($post_values);echo "</pre>";exit;
     $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);
     }
     $finalarray = $deleted_emp_arr = $result = array();
     $mgrIndex = 'MC';
     $mgrratIndex = 'MR';
     $empIndex = 'EC';
     $empratIndex = 'ER';
     $questionArr = $post_values['check'];
     $managercmntsArr = isset($post_values['mgrcmnt']) ? $post_values['mgrcmnt'] : array();
     $managerratingsArr = isset($post_values['mgrrating']) ? $post_values['mgrrating'] : array();
     $empratingsArr = isset($post_values['empratings']) ? $post_values['empratings'] : array();
     $empcmntsArr = isset($post_values['empcmnt']) ? $post_values['empcmnt'] : array();
     $empids = $post_values['existetd_mem_str'];
     $groupid = $post_values['groupid'];
     $group_name = $post_values['group_name'];
     $appraisal_id = $post_values['appraisal_id'];
     $manager_id = $post_values['manager_id'];
     $original_mem_str = $post_values['original_mem_str'];
     $action_flag = $post_values['action_flag'];
     $selected_emp_arr = explode(',', $empids);
     $result['flag'] = 'appraisalmanager';
     $trDb = Zend_Db_Table::getDefaultAdapter();
     $trDb->beginTransaction();
     try {
         if ($group_name != '' && !empty($questionArr) && $empids != '') {
             $appraisalGroupModel = new Default_Model_Appraisalgroups();
             $appraisalPrivMainModel = new Default_Model_Appraisalqsmain();
             $CheckDuplicateName = $appraisalGroupModel->getDuplicateGroupName($appraisal_id, $group_name, $groupid != '' ? $groupid : '');
             if (!empty($CheckDuplicateName)) {
                 $duplicateGroupName = $CheckDuplicateName[0]['grpcnt'];
             }
             if ($duplicateGroupName > 0) {
                 $result['result'] = 'error';
                 $result['msg'] = 'Group name already exists.';
             } else {
                 if (!empty($original_mem_str)) {
                     $privilegesdata = array('manager_group_id' => null, 'manager_qs' => null, 'manager_qs_privileges' => null, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
                     $privielgeswhere = " pa_initialization_id = '" . $appraisal_id . "' and line_manager_1 = '" . $manager_id . "' and employee_id IN ({$original_mem_str}) and module_flag=1 and isactive= 1 ";
                     $updateprivileges = $appraisalPrivMainModel->SaveorUpdatePrivilegeData($privilegesdata, $privielgeswhere);
                 }
                 if (!empty($questionArr)) {
                     for ($i = 0; $i < sizeof($questionArr); $i++) {
                         $managercomments = isset($managercmntsArr[$questionArr[$i]]) ? 1 : 0;
                         $managerratings = isset($managerratingsArr[$questionArr[$i]]) ? 1 : 0;
                         $empratings = isset($empratingsArr[$questionArr[$i]]) ? 1 : 0;
                         $empcomments = isset($empcmntsArr[$questionArr[$i]]) ? 1 : 0;
                         $commntsarry = array($mgrratIndex => $managerratings, $mgrIndex => $managercomments, $empratIndex => $empratings, $empIndex => $empcomments);
                         $finalarray[$questionArr[$i]] = $commntsarry;
                     }
                     $questions = implode(',', $questionArr);
                     $qsprivileges = json_encode($finalarray, true);
                     $groupdata = array('pa_initialization_id' => $appraisal_id, 'group_name' => trim($group_name), 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
                     if ($groupid != '') {
                         $where = array('id=?' => $groupid);
                         $actionflag = 2;
                     } else {
                         $groupdata['createdby_role'] = $loginuserRole;
                         $groupdata['createdby_group'] = $loginuserGroup;
                         $groupdata['createdby'] = $loginUserId;
                         $groupdata['createddate'] = gmdate("Y-m-d H:i:s");
                         $groupdata['isactive'] = 1;
                         $where = '';
                         $actionflag = 1;
                     }
                     $Id = $appraisalGroupModel->SaveorUpdateAppraisalGroupsData($groupdata, $where);
                     if ($Id != 'update') {
                         $groupid = $Id;
                     }
                     $privilegesdata = array('manager_group_id' => $groupid, 'manager_qs' => $questions, 'manager_qs_privileges' => $qsprivileges, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
                     $privielgeswhere = " pa_initialization_id = '" . $appraisal_id . "' and line_manager_1 = '" . $manager_id . "' and employee_id IN ({$empids}) and module_flag=1 and isactive= 1 ";
                     $updateprivileges = $appraisalPrivMainModel->SaveorUpdatePrivilegeData($privilegesdata, $privielgeswhere);
                     //echo '<pre>';print_r($finalarray);echo "</pre>";
                     $trDb->commit();
                     $result['result'] = 'success';
                     $result['msg'] = "Group " . ($action_flag == 'edit' ? "updated" : "created") . " successfully";
                 } else {
                     $result['result'] = 'error';
                     $result['msg'] = 'No questions to add';
                 }
             }
         } else {
             $result['result'] = 'error';
             $result['msg'] = 'Something went wrong.';
         }
     } catch (Exception $e) {
         $trDb->rollBack();
         $result['result'] = 'error';
         $result['msg'] = $e->getMessage();
     }
     $this->_helper->json($result);
 }
 public function updatelinemanagerAction()
 {
     $this->_helper->layout->disableLayout();
     $ajaxContext = $this->_helper->getHelper('AjaxContext');
     $ajaxContext->addActionContext('updatelinemanager', 'json')->initContext();
     $auth = Zend_Auth::getInstance();
     if ($auth->hasIdentity()) {
         $loginUserId = $auth->getStorage()->read()->id;
         $loginuserRole = $auth->getStorage()->read()->emprole;
         $loginuserGroup = $auth->getStorage()->read()->group_id;
     }
     $appraisalPrivMainModel = new Default_Model_Appraisalqsmain();
     $appraisalempratingsmodel = new Default_Model_Appraisalemployeeratings();
     $result['result'] = 'success';
     $result['msg'] = '';
     $appraisalid = $this->_request->getParam('appraisalid');
     $employeeid = $this->_request->getParam('employeeid');
     $line_1_mgr = $this->_request->getParam('line_1_mgr');
     $line_2_mgr = $this->_request->getParam('line_2_mgr');
     $line_3_mgr = $this->_request->getParam('line_3_mgr');
     $line_4_mgr = $this->_request->getParam('line_4_mgr');
     $line_5_mgr = $this->_request->getParam('line_5_mgr');
     $levels = $this->_request->getParam('levels');
     if ($appraisalid && $employeeid) {
         $trDb = Zend_Db_Table::getDefaultAdapter();
         $trDb->beginTransaction();
         try {
             $data = array('line_manager_1' => $line_1_mgr != '' ? $line_1_mgr : NULL, 'line_manager_2' => $line_2_mgr != '' ? $line_2_mgr : NULL, 'line_manager_3' => $line_3_mgr != '' ? $line_3_mgr : NULL, 'line_manager_4' => $line_4_mgr != '' ? $line_4_mgr : NULL, 'line_manager_5' => $line_5_mgr != '' ? $line_5_mgr : NULL, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
             $privilegeswhere = " employee_id = '" . $employeeid . "' and pa_initialization_id='" . $appraisalid . "' and module_flag=1 and isactive=1 ";
             $empratingswhere = " employee_id = '" . $employeeid . "' and pa_initialization_id='" . $appraisalid . "' and isactive=1 ";
             $appraisalPrivMainModel->SaveorUpdatePrivilegeData($data, $privilegeswhere);
             $appraisalempratingsmodel->SaveorUpdateAppraisalSkillsData($data, $empratingswhere);
             $trDb->commit();
         } catch (Exception $e) {
             $trDb->rollBack();
             $result['result'] = 'error';
             $result['msg'] = $e->getMessage();
         }
     }
     $this->_helper->json($result);
 }
 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 updatelinemanagerAction()
 {
     $this->_helper->layout->disableLayout();
     $ajaxContext = $this->_helper->getHelper('AjaxContext');
     $ajaxContext->addActionContext('updatelinemanager', 'json')->initContext();
     $auth = Zend_Auth::getInstance();
     if ($auth->hasIdentity()) {
         $loginUserId = $auth->getStorage()->read()->id;
         $loginuserRole = $auth->getStorage()->read()->emprole;
         $loginuserGroup = $auth->getStorage()->read()->group_id;
         $loginUserEmpId = $auth->getStorage()->read()->employeeId;
         $loginUserEmail = $auth->getStorage()->read()->emailaddress;
         $loginUsername = $auth->getStorage()->read()->userfullname;
         $loginUserprofileimg = $auth->getStorage()->read()->profileimg;
     }
     $appraisalPrivMainModel = new Default_Model_Appraisalqsmain();
     $appraisalempratingsmodel = new Default_Model_Appraisalemployeeratings();
     $result['result'] = 'success';
     $result['msg'] = '';
     $send_mails = false;
     $appraisalid = $this->_request->getParam('appraisalid');
     $employeeid = $this->_request->getParam('employeeid');
     $line_1_mgr = $this->_request->getParam('line_1_mgr');
     $line_2_mgr = $this->_request->getParam('line_2_mgr');
     $line_3_mgr = $this->_request->getParam('line_3_mgr');
     $line_4_mgr = $this->_request->getParam('line_4_mgr');
     $line_5_mgr = $this->_request->getParam('line_5_mgr');
     $levels = $this->_request->getParam('levels');
     //checking equality of manager levels for sending mails
     if ($appraisalid && $employeeid) {
         $appraisal_level_arr = $appraisalPrivMainModel->getAllManagerIds($appraisalid, $employeeid);
         $appraisal_level_arr = $appraisal_level_arr[0];
         $levels_pre = $appraisal_level_arr['manager_levels'];
         if ($levels_pre == $levels) {
             $preLine_1_mgr = $appraisal_level_arr['line_manager_1'];
             $preLine_2_mgr = $appraisal_level_arr['line_manager_2'];
             $preLine_3_mgr = $appraisal_level_arr['line_manager_3'];
             $preLine_4_mgr = $appraisal_level_arr['line_manager_4'];
             $preLine_5_mgr = $appraisal_level_arr['line_manager_5'];
             for ($i = 1; $i <= $levels_pre; $i++) {
                 $preLine_mgr = "preLine_" . $i . "_mgr";
                 $line_mgr = "line_" . $i . "_mgr";
                 if (${$line_mgr} != ${$preLine_mgr}) {
                     $send_mails = true;
                 }
             }
         } else {
             $send_mails = true;
         }
     }
     //end checking send mails to employees
     if ($appraisalid && $employeeid) {
         $trDb = Zend_Db_Table::getDefaultAdapter();
         $trDb->beginTransaction();
         try {
             $data = array('line_manager_1' => $line_1_mgr != '' ? $line_1_mgr : NULL, 'line_manager_2' => $line_2_mgr != '' ? $line_2_mgr : NULL, 'line_manager_3' => $line_3_mgr != '' ? $line_3_mgr : NULL, 'line_manager_4' => $line_4_mgr != '' ? $line_4_mgr : NULL, 'line_manager_5' => $line_5_mgr != '' ? $line_5_mgr : NULL, 'manager_levels' => is_numeric($levels) ? $levels : 1, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
             $privilegeswhere = " employee_id = '" . $employeeid . "' and pa_initialization_id='" . $appraisalid . "' and module_flag=1 and isactive=1 ";
             $empratingswhere = " employee_id = '" . $employeeid . "' and pa_initialization_id='" . $appraisalid . "' and isactive=1 ";
             $appraisalPrivMainModel->SaveorUpdatePrivilegeData($data, $privilegeswhere);
             //remove the manager_levels as this column is not there in main_pa_employee_ratings table
             unset($data['manager_levels']);
             $appraisalempratingsmodel->SaveorUpdateAppraisalSkillsData($data, $empratingswhere);
             if ($send_mails == true) {
                 /** Start
                  * Sending Mails to employees
                  */
                 $emp_id_str = $loginuserRole == SUPERADMINROLE ? " " : "({$loginUserEmpId})";
                 //Preparing string with line manager ids
                 $mgrStr = '';
                 for ($i = 1; $i <= $levels; $i++) {
                     $mgr_str = 'line_' . $i . '_mgr';
                     //$line_1_mgr
                     if (is_numeric(${$mgr_str})) {
                         $mgrStr .= ${$mgr_str} . ',';
                     }
                 }
                 $mgrStr = rtrim($mgrStr, ",");
                 $appraisalratingsmodel = new Default_Model_Appraisalratings();
                 $appraisal_details = $appraisalratingsmodel->getappdata($appraisalid);
                 if (!empty($appraisal_details)) {
                     $to_year = $appraisal_details['to_year'];
                 }
                 $employeeDetailsArr = $appraisalPrivMainModel->getManagerDetailsByIds($employeeid, $mgrStr);
                 $mgr_array = array();
                 $mgr_array = explode(",", $mgrStr);
                 //Preparing Employee array for Bcc
                 $empArr = array();
                 if (!empty($employeeDetailsArr)) {
                     $empArrList = '';
                     $empUserIdArr = array();
                     $toEmailId = '';
                     $toEmailName = '';
                     foreach ($employeeDetailsArr as $emp) {
                         array_push($empArr, $emp['emailaddress']);
                         //preparing Bcc array
                         array_push($empUserIdArr, $emp['user_id']);
                         if ($emp['user_id'] == $employeeid) {
                             $toEmailId = $emp['emailaddress'];
                             $toEmailName = $emp['userfullname'];
                             $toEmpId = $emp['employeeId'];
                             array_pop($empArr);
                         }
                     }
                     $index = array_search($employeeid, $empUserIdArr);
                     unset($employeeDetailsArr[$index]);
                     $mail_str = '';
                     for ($j = 0; $j < sizeof($mgr_array); $j++) {
                         foreach ($employeeDetailsArr as $employee) {
                             if ($mgr_array[$j] == $employee['user_id']) {
                                 $profile_pic = $employee['profileimg'];
                                 $cnt = $j + 1;
                                 if ($profile_pic != '') {
                                     $src = DOMAIN . "public/uploads/profile/" . $profile_pic;
                                 } else {
                                     $src = MEDIA_PATH . "images/default-profile-pic.jpg";
                                 }
                                 $mail_str .= "<div style='padding:20px 0 0 0;color:#3b3b3b;'>Line {$cnt} Manager : " . $employee['userfullname'] . " <img src=" . $src . " onError=this.src=" . MEDIA_PATH . "images/default-profile-pic.jpg width='30px' height='30px' /></div>";
                             }
                         }
                     }
                 }
                 //pushing loginUserEmail to Bcc array
                 array_push($empArr, $loginUserEmail);
                 $options['subject'] = APPLICATION_NAME . ': Change in Line Managers';
                 $options['header'] = 'Performance Appraisal : ' . $to_year;
                 $options['bcc'] = $empArr;
                 $options['toEmail'] = $toEmailId;
                 $options['toName'] = $toEmailName;
                 $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;'>Hi,</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;'>Line Managers for " . $toEmailName . "(" . $toEmpId . ") have been modified by " . $loginUsername . $emp_id_str . "</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$mail_str}\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 and check the details.</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div> ";
                 $mail_id = sapp_Global::_sendEmail($options);
                 /**
                  * End mails sending
                  */
             }
             $trDb->commit();
         } catch (Exception $e) {
             $trDb->rollBack();
             $result['result'] = 'error';
             $result['msg'] = $e->getMessage();
         }
     }
     $this->_helper->json($result);
 }
 public function updateprivafeterinitforallemployees($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();
     $appraisalQsTmpModel = new Default_Model_Appraisalqstemp();
     $app_init_model = new Default_Model_Appraisalinit();
     $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 = '';
     $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 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 = $appraisalPrivMainModel->SaveorUpdatePrivilegeData($privilegesdata, $privielgeswhere);
             /* End */
             /**
              * 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
                          */
                     }
                 }
                 /** 
                  * Mail to performance Appraisal Group
                  */
                 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
                  */
             }
             /**
              * End Sending Mails and updating emp ratings table
              */
             if ($appraisaldata['enable_step'] == 1) {
                 $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'];
                 }
                 //announcements insertion commented after Appraisal initiation
                 /*$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']);
             $trDb->commit();
             $msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => 'Appraisal initialized successfully'));
             $this->_redirect('appraisalinit');
         }
     } catch (Exception $e) {
         $trDb->rollBack();
         $msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => $e->getMessage()));
     }
     return $msgarray;
 }