public function managerAction()
{
$appraisalSkillsModel = new Default_Model_Appraisalskills();
$call = $this->_getParam('call');
if ($call == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$view = Zend_Layout::getMvcInstance()->getView();
$objname = $this->_getParam('objname');
$refresh = $this->_getParam('refresh');
$dashboardcall = $this->_getParam('dashboardcall');
$data = array();
$searchQuery = '';
$searchArray = array();
$tablecontent = '';
if ($refresh == 'refresh') {
if ($dashboardcall == 'Yes') {
$perPage = DASHBOARD_PERPAGE;
} else {
$perPage = PERPAGE;
}
$sort = 'DESC';
$by = 'aer.modifieddate';
$pageNo = 1;
$searchData = '';
$searchQuery = '';
$searchArray = '';
} else {
$sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC';
$by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'aer.modifieddate';
if ($dashboardcall == 'Yes') {
$perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE);
} else {
$perPage = $this->_getParam('per_page', PERPAGE);
}
$pageNo = $this->_getParam('page', 1);
/** search from grid - START * */
$searchData = $this->_getParam('searchData');
$searchData = rtrim($searchData, ',');
/** search from grid - END * */
}
$dataTmp = $appraisalSkillsModel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall);
array_push($data, $dataTmp);
$this->view->dataArray = $data;
$this->view->call = $call;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->render('commongrid/index', null, true);
}
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);
}
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);
}
/**
** get individual
**/
public function getselectedappraisaldataAction()
{
try {
$appId = $this->_request->getParam('appId');
$empId = $this->_request->getParam('empId');
$period = $this->_request->getParam('period');
$empAppraisalData = "";
$questionsData = "";
$categoriesData = "";
$empData = "";
$ratingsData = "";
$empAppraisals = array();
$ratingType = "";
$ratingText = array();
$ratingTextDisplay = array();
$ratingValues = array();
if ($appId && $empId && $period) {
$empAppraisalModel = new Default_Model_Appraisalemployeeratings();
$empAppraisals = $empAppraisalModel->getSelectedAppraisalData($appId, $empId, $period);
$configId = isset($empAppraisals[0]['pa_configured_id']) ? $empAppraisals[0]['pa_configured_id'] : 0;
// get rating details using configuration id
$appEmpRatingsModel = new Default_Model_Appraisalemployeeratings();
$ratingsData = $appEmpRatingsModel->getAppRatingsDataByConfgId($configId, $appId);
if (!empty($ratingsData)) {
$ratingType = $ratingsData[0]['rating_type'];
}
foreach ($ratingsData as $rd) {
$ratingText[] = $rd['rating_text'];
$ratingTextDisplay[$rd['id']] = $rd['rating_text'];
$ratingValues[$rd['id']] = $rd['rating_value'];
}
if (!empty($empAppraisals)) {
if (!empty($empAppraisals[0]['employee_response'])) {
$empResponse = json_decode($empAppraisals[0]['employee_response']);
$empResponseArray = get_object_vars($empResponse);
$strQuestionIds = implode(",", array_keys($empResponseArray));
$questionsData = $empAppraisalModel->getQuestionsData($strQuestionIds);
$tmpRatingIdsObject = array_values($empResponseArray);
$tmpRatingIdsArr = array();
foreach ($tmpRatingIdsObject as $ratingArr) {
$tmpRatings = get_object_vars($ratingArr);
$tmpRatingIdsArr[] = $tmpRatings['rating_id'];
}
if (!empty($empAppraisals[0]['manager_response'])) {
$managerResponse = json_decode($empAppraisals[0]['manager_response']);
$managerResponseArray = get_object_vars($managerResponse);
$managerRatingIdsObject = array_values($managerResponseArray);
foreach ($managerRatingIdsObject as $ratingArr) {
$tmpRatings = get_object_vars($ratingArr);
$tmpRatingIdsArr[] = $tmpRatings['rating'];
}
}
$tmpRatingIdsStr = !empty($tmpRatingIdsArr) ? implode(",", $tmpRatingIdsArr) : "";
if (!empty($tmpRatingIdsStr)) {
$ratingsData = $empAppraisalModel->getRatingsData($tmpRatingIdsStr);
}
if (!empty($ratingsData)) {
$r = 0;
foreach ($ratingsData as $rdata) {
$ratingsData[$rdata['id']] = $rdata;
unset($ratingsData[$r]);
$r++;
}
}
}
$strCategories = $empAppraisals[0]['category_id'];
$categoriesData = $empAppraisalModel->getCategories($strCategories);
}
}
$appSkillsModel = new Default_Model_Appraisalskills();
$skills = array();
$skills = $appSkillsModel->getAppraisalSkillsData();
$skills_arr = array();
foreach ($skills as $skill) {
$skills_arr[$skill['id']] = $skill;
}
$this->view->skills_arr = $skills_arr;
$this->view->selectedAppraisals = $empAppraisals;
$this->view->categoriesData = $categoriesData;
$this->view->empData = $empData;
$this->view->questionsData = $questionsData;
$this->view->ratingsData = $ratingsData;
$this->view->ratingType = $ratingType;
$this->view->ratingTextDisplay = $ratingTextDisplay;
$this->view->ratingText = json_encode($ratingText);
$this->view->ratingValues = $ratingValues;
$this->view->appraisalId = $appId;
} catch (Exception $e) {
print_r($e);
}
}
