public function saveskillspopupAction()
 {
     $ajaxContext = $this->_helper->getHelper('AjaxContext');
     $ajaxContext->addActionContext('saveskillspopup', 'json')->initContext();
     $this->_helper->layout->disableLayout();
     $auth = Zend_Auth::getInstance();
     if ($auth->hasIdentity()) {
         $loginUserId = $auth->getStorage()->read()->id;
         $loginuserRole = $auth->getStorage()->read()->emprole;
         $loginuserGroup = $auth->getStorage()->read()->group_id;
     }
     $appraisalskillsmodel = new Default_Model_Appraisalskills();
     $result['result'] = '';
     $result['id'] = '';
     $result['skills'] = '';
     $duplicateSkillName = 0;
     try {
         $skillsval = rawurldecode($this->_request->getParam('skillsval'));
         $description = rawurldecode(trim($this->_request->getParam('description')));
         $menumodel = new Default_Model_Menu();
         $actionflag = '';
         $tableid = '';
         if ($skillsval) {
             $CheckDuplicateSkillName = $appraisalskillsmodel->getDuplicateSkillsName($skillsval);
         }
         if (!empty($CheckDuplicateSkillName)) {
             $duplicateSkillName = $CheckDuplicateSkillName[0]['grpcnt'];
         }
         if ($duplicateSkillName > 0) {
             $result['msg'] = 'Skill name already exists.';
         } else {
             $data = array('skill_name' => $skillsval, 'description' => $description != '' ? $description : NULL, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'createdby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
             $where = '';
             $actionflag = 1;
             if ($skillsval != '') {
                 $Id = $appraisalskillsmodel->SaveorUpdateAppraisalSkillsData($data, $where);
                 $menuidArr = $menumodel->getMenuObjID('/appraisalskills');
                 $menuID = $menuidArr[0]['id'];
                 $logresult = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
                 $result['msg'] = 'success';
                 $result['id'] = $Id;
                 $result['skills'] = $skillsval;
             } else {
                 $result['msg'] = 'error';
                 $result['id'] = '';
                 $result['skills'] = '';
             }
         }
     } catch (Exception $e) {
         $result['msg'] = $e->getMessage();
         $result['id'] = '';
         $result['skills'] = '';
     }
     $this->_helper->json($result);
 }
 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) {
         $appraisalSkillsModel = new Default_Model_Appraisalskills();
         $menumodel = new Default_Model_Menu();
         $appSkillsdata = $appraisalSkillsModel->getAppraisalSkillsDatabyID($id);
         if ($appSkillsdata[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 = $appraisalSkillsModel->SaveorUpdateAppraisalSkillsData($data, $where);
             if ($Id == 'update') {
                 $menuidArr = $menumodel->getMenuObjID('/appraisalskills');
                 $menuID = $menuidArr[0]['id'];
                 $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
                 $configmail = sapp_Global::send_configuration_mail('Skill', $appSkillsdata[0]['skill_name']);
                 $messages['message'] = 'Skill deleted successfully.';
                 $messages['msgtype'] = 'success';
             } else {
                 $messages['message'] = 'Skill cannot be deleted.';
                 $messages['msgtype'] = 'error';
             }
         } else {
             $messages['message'] = 'Skill cannot be deleted as its using in appraisal process.';
             $messages['msgtype'] = 'error';
         }
     } else {
         $messages['message'] = 'Skill cannot be deleted.';
         $messages['msgtype'] = 'error';
     }
     $this->_helper->json($messages);
 }