public function deleteAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $count = 0; $actionflag = 3; if ($id) { $appraisalGroupsModel = new Default_Model_Appraisalgroups(); $menumodel = new Default_Model_Menu(); $appGroupsdata = $appraisalGroupsModel->getAppraisalGroupsDatabyID($id); if ($appGroupsdata[0]['isused'] == 0) { $data = array('isactive' => 0, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('id=?' => $id); $Id = $appraisalGroupsModel->SaveorUpdateAppraisalGroupsData($data, $where); if ($Id == 'update') { $menuidArr = $menumodel->getMenuObjID('/appraisalgroups'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); /*** ** commented on 29-04-2015 by sapplica ** need to integrate mail template $configmail = sapp_Global::send_configuration_mail('Group',$appGroupsdata[0]['group_name']); ***/ $messages['message'] = 'Group deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Group cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Group cannot be deleted as its using in appraisal process.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Group cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
/** * 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 deletegroupedemployeesAction() { $this->_helper->layout->disableLayout(); $result['result'] = ''; $result['msg'] = ''; $result['empcount'] = ''; $appraisalinitmodel = new Default_Model_Appraisalinit(); $appraisalQsModel = new Default_Model_Appraisalquestions(); $appraisalgroupModel = new Default_Model_Appraisalgroups(); $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); } $groupid = $this->_request->getParam('groupid'); $appraisalid = $this->_request->getParam('appraisalid'); $trDb = Zend_Db_Table::getDefaultAdapter(); $trDb->beginTransaction(); try { if ($groupid && $appraisalid) { $appraisaldata = $appraisalinitmodel->getConfigData($appraisalid); if ($appraisaldata[0]['initialize_status'] == 1) { $tablename = ''; } else { $tablename = 'main_pa_questions_privileges_temp'; } $updatestatus = $appraisalQsModel->deletegroupqsprivileges($tablename, $appraisalid, $groupid, $loginuserArr); $groupdata = array('isactive' => 0, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s")); $groupwhere = array('id=?' => $groupid); $appraisalgroupModel->SaveorUpdateAppraisalGroupsData($groupdata, $groupwhere); $EmpCountArr = $appraisalQsModel->getGroupCountDetails($appraisalid, $tablename); if (!empty($EmpCountArr)) { $result['empcount'] = $EmpCountArr[0]['empcount']; } $trDb->commit(); $result['result'] = 'success'; $result['msg'] = 'Group deleted succesfully.'; } } catch (Exception $e) { $trDb->rollBack(); $result['result'] = 'error'; $result['msg'] = $e->getMessage(); } $this->_helper->json($result); }