public function getVAllEmployees() { $db = Zend_Db_Table::getDefaultAdapter(); $empmodel = new Default_Model_Employee(); $acceptedrolesArr = $empmodel->getUserRole(); $roles = $acceptedrolesArr[0]['roles']; $where = "u.isactive = 1 AND u.userstatus = 'old' "; if ($roles != '') { $where .= " AND emprole IN(" . $roles . ")"; } $empData = $db->query("SELECT u.id,u.profileimg,\n\t\t\t\t\t\t\t concat(u.userfullname,if(j.jobtitlename is null,'',concat(' , ',j.jobtitlename))) as name\n\t\t\t\t\t\t\t FROM main_users u\n\t\t\t\t\t\t\t left JOIN main_jobtitles j on j.id = u.jobtitle_id\n\t\t\t\t\t\t\t WHERE " . $where . " ORDER BY name ASC"); $result = $empData->fetchAll(); return $result; }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('emp_performanceappraisal', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $userid = $this->getRequest()->getParam('userid'); $employeeModal = new Default_Model_Employee(); $isrowexist = $employeeModal->getsingleEmployeeData($userid); if ($isrowexist == 'norows') { $this->view->rowexist = "norows"; } else { $this->view->rowexist = "rows"; } $empdata = $employeeModal->getActiveEmployeeData($userid); if (!empty($empdata)) { $empperformanceApprModel = new Default_Model_Empperformanceappraisal(); if ($userid) { //To display Employee Profile information...... $usersModel = new Default_Model_Users(); $employeeData = $usersModel->getUserDetailsByIDandFlag($userid); } $this->view->id = $userid; $this->view->employeedata = $employeeData[0]; if ($this->getRequest()->getPost()) { } } $this->view->empdata = $empdata; } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('emp_additional', $empOrganizationTabs)) { $userID = ""; $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->getRequest()->getParam('userid'); $conText = ''; $call = $this->_getParam('call'); if ($call == 'ajaxcall') { $this->_helper->layout->disableLayout(); $userID = $this->_getParam('unitId') != '' ? $this->_getParam('unitId') : $this->_getParam('userid'); $conText = $this->_getParam('context') != '' ? $this->_getParam('context') : $this->getRequest()->getParam('context'); } if ($id == '') { $id = $userID; } $Uid = $id ? $id : $userID; $employeeModal = new Default_Model_Employee(); try { if ($Uid && is_numeric($Uid) && $Uid > 0) { $usersModel = new Default_Model_Users(); $empdata = $employeeModal->getActiveEmployeeData($Uid); $employeeData = $usersModel->getUserDetailsByIDandFlag($Uid); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $empadditionaldetailsModal = new Default_Model_Empadditionaldetails(); $view = Zend_Layout::getMvcInstance()->getView(); $objname = $this->_getParam('objname'); $refresh = $this->_getParam('refresh'); $dashboardcall = $this->_getParam('dashboardcall', null); $data = array(); $searchQuery = ''; $searchArray = array(); $tablecontent = ''; if ($refresh == 'refresh') { if ($dashboardcall == 'Yes') { $perPage = DASHBOARD_PERPAGE; } else { $perPage = PERPAGE; } $sort = 'DESC'; $by = 'e.modifieddate'; $pageNo = 1; $searchData = ''; $searchQuery = ''; $searchArray = ''; } else { $sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC'; $by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'e.modifieddate'; if ($dashboardcall == 'Yes') { $perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE); } else { $perPage = $this->_getParam('per_page', PERPAGE); } $pageNo = $this->_getParam('page', 1); $searchData = $this->_getParam('searchData'); $searchData = rtrim($searchData, ','); } $dataTmp = $empadditionaldetailsModal->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $Uid, $conText); array_push($data, $dataTmp); $this->view->dataArray = $data; $this->view->call = $call; $this->view->employeedata = $employeeData[0]; $this->view->id = $id; $this->view->messages = $this->_helper->flashMessenger->getMessages(); } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function sendmailstoemployees($oldRM, $newRM) { $baseUrl = BASE_URL; $employeeModal = new Default_Model_Employee(); $employessunderEmpId = $employeeModal->getEmployeesUnderRM($oldRM); /* Send Mails to the employees whose reporting manager is changed */ $oldRMData = $employeeModal->getsingleEmployeeData($oldRM); $newRMData = $employeeModal->getsingleEmployeeData($newRM); if (!empty($newRMData)) { foreach ($employessunderEmpId as $employee) { $options['subject'] = APPLICATION_NAME . ' : Change of reporting manager'; $options['header'] = 'Change of reporting manager'; $options['toEmail'] = $employee['emailaddress']; $options['toName'] = $employee['userfullname']; $options['message'] = '<div>Hello ' . ucfirst($employee['userfullname']) . ', <div>' . ucfirst($newRMData[0]['userfullname']) . ' is your new reporting manager.</div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login </div> </div>'; $result = sapp_Global::_sendEmail($options); } } }
public function updateempdetails($employeeform) { $emproleStr = ''; $roleArr = array(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $usersModel = new Default_Model_Usermanagement(); $employeeModal = new Default_Model_Employee(); $businessunit_id = $this->_request->getParam('businessunit_id', null); $department_id = $this->_request->getParam('department_id', null); $reporting_manager = $this->_request->getParam('reporting_manager', null); $jobtitle_id = $this->_request->getParam('jobtitle_id', null); $position_id = $this->_request->getParam('position_id', null); $user_id = $this->_getParam('user_id', null); $prefix_id = $this->_getParam('prefix_id', null); $extension_number = $this->_getParam('extension_number', null); if ($employeeform->isValid($this->_request->getPost())) { $id = $this->_request->getParam('id'); $emp_status_id = $this->_request->getParam('emp_status_id', null); $date_of_joining = $this->_request->getParam('date_of_joining', null); $date_of_joining = sapp_Global::change_date($date_of_joining, 'database'); $date_of_leaving = $this->_request->getParam('date_of_leaving', null); $date_of_leaving = sapp_Global::change_date($date_of_leaving, 'database'); $years_exp = $this->_request->getParam('years_exp'); //FOR USER table $employeeId = $this->_getParam('employeeId', null); $modeofentry = $this->_getParam('modeofentry', null); $hid_modeofentry = $this->_getParam('hid_modeofentry', null); $other_modeofentry = $this->_getParam('other_modeofentry', null); $userfullname = $this->_getParam('userfullname', null); $candidatereferredby = $this->_getParam('candidatereferredby', null); $rccandidatename = $this->_getParam('rccandidatename', null); $emprole = $this->_getParam('emprole', null); //roleid_group_id if ($emprole != "") { $roleArr = explode('_', $emprole); if (!empty($roleArr)) { $emproleStr = $roleArr[0]; } } $emailaddress = $this->_getParam('emailaddress', null); $tmp_name = $this->_request->getParam('tmp_emp_name', null); $act_inact = $this->_request->getParam("act_inact", null); //end of user table $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $empstatusarray = array(8, 9, 10); $actionflag = ''; $tableid = ''; if ($modeofentry == 'Direct' || $hid_modeofentry == 'Direct') { $candidate_key = 'userfullname'; $candidate_value = $userfullname; $emp_name = $userfullname; $candidate_flag = 'no'; } else { $candidate_key = 'rccandidatename'; $candidate_value = $rccandidatename; $emp_name = $tmp_name; $candidate_flag = 'yes'; } $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { $emppassword = sapp_Global::generatePassword(); $user_data = array('emprole' => $emproleStr, $candidate_key => $candidate_value, 'emailaddress' => $emailaddress, 'modifiedby' => $loginUserId, 'modifieddate' => Zend_Registry::get('currentdate'), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'modeofentry' => $id == '' ? $modeofentry : "", 'selecteddate' => $date_of_joining, 'candidatereferredby' => $candidatereferredby, 'userstatus' => 'old', 'other_modeofentry' => $other_modeofentry); if ($id != '') { $where = array('user_id=?' => $user_id); $actionflag = 2; $user_where = "id = " . $user_id; unset($user_data['candidatereferredby']); unset($user_data['userstatus']); unset($user_data['emppassword']); unset($user_data['employeeId']); unset($user_data['modeofentry']); unset($user_data['other_modeofentry']); } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $user_data['createdby'] = $loginUserId; $user_data['createddate'] = gmdate("Y-m-d H:i:s"); $user_data['isactive'] = 1; if ($modeofentry != 'Direct') { $user_data['userfullname'] = $emp_name; } $where = ''; $actionflag = 1; $user_where = ''; } $user_status = $usersModel->SaveorUpdateUserData($user_data, $user_where); if ($id == '') { $user_id = $user_status; } $data = array('user_id' => $user_id, 'reporting_manager' => $reporting_manager, 'emp_status_id' => $emp_status_id, 'businessunit_id' => $businessunit_id, 'department_id' => $department_id, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'extension_number' => $extension_number, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'years_exp' => $years_exp == '' ? null : $years_exp, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $Id = $employeeModal->SaveorUpdateEmployeeData($data, $where); $statuswhere = array('id=?' => $user_id); if (in_array($emp_status_id, $empstatusarray)) { $isactivestatus = ''; if ($emp_status_id == 8) { $isactivestatus = 2; } else { if ($emp_status_id == 9) { $isactivestatus = 3; } else { if ($emp_status_id == 10) { $isactivestatus = 4; } } } $statusdata = array('isactive' => $isactivestatus); $empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere); } else { $statusdata = array('isactive' => 1); $empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere); } if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details updated successfully.")); } else { //start of mailing $base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $view = $this->getHelper('ViewRenderer')->view; $this->view->emp_name = $emp_name; $this->view->password = $emppassword; $this->view->emp_id = $employeeId; $this->view->base_url = $base_url; $text = $view->render('mailtemplates/newpassword.phtml'); $options['subject'] = APPLICATION_NAME . ' login credentials'; $options['header'] = 'Greetings from Sentrifugo'; $options['toEmail'] = $emailaddress; $options['toName'] = $this->view->emp_name; $options['message'] = $text; $result = sapp_Global::_sendEmail($options); //end of mailing $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details added successfully.")); } $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $menuidArr = $menumodel->getMenuObjID('/usermanagement'); $menuID_user = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id); if ($act_inact == 1) { if ($user_data['isactive'] == 1) { $act_str = array("Activated" => Zend_Registry::get('currentdate')); } else { $act_str = array("Inactivated" => Zend_Registry::get('currentdate')); } $result = sapp_Global::logManager($menuID_user, 4, $loginUserId, $user_id, '', $act_str); } $trDb->commit(); $this->_redirect('employee/edit/id/' . $user_id); } catch (Exception $e) { $trDb->rollBack(); $msgarray['employeeId'] = "Something went wrong,please try again later."; return $msgarray; } } else { $messages = $employeeform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } $usersModel = new Default_Model_Users(); if (isset($businessunit_id) && $businessunit_id != 0 && $businessunit_id != '') { $departmentsmodel = new Default_Model_Departments(); $departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id); $employeeform->department_id->clearMultiOptions(); $employeeform->reporting_manager->clearMultiOptions(); $employeeform->department_id->addMultiOption('', 'Select Department'); foreach ($departmentlistArr as $departmentlistresult) { $employeeform->department_id->addMultiOption($departmentlistresult['id'], utf8_encode($departmentlistresult['deptname'])); } if (isset($department_id) && $department_id != 0 && $department_id != '') { $employeeform->setDefault('department_id', $department_id); } } if (isset($department_id) && $department_id != 0 && $department_id != '') { $reportingManagerArr = $usersModel->getReportingManagerList($department_id, $user_id); $employeeform->reporting_manager->addMultiOption('', 'Select Reporting Manager'); foreach ($reportingManagerArr as $reportingManagerresult) { $employeeform->reporting_manager->addMultiOption($reportingManagerresult['id'], utf8_encode($reportingManagerresult['userfullname'])); } if (isset($reporting_manager) && $reporting_manager != 0 && $reporting_manager != '') { $employeeform->setDefault('reporting_manager', $reporting_manager); } } if (isset($jobtitle_id) && $jobtitle_id != 0 && $jobtitle_id != '') { $positionsmodel = new Default_Model_Positions(); $positionlistArr = $positionsmodel->getPositionList($jobtitle_id); $employeeform->position_id->clearMultiOptions(); $employeeform->position_id->addMultiOption('', 'Select Position'); foreach ($positionlistArr as $positionlistRes) { $employeeform->position_id->addMultiOption($positionlistRes['id'], utf8_encode($positionlistRes['positionname'])); } if (isset($position_id) && $position_id != 0 && $position_id != '') { $employeeform->setDefault('position_id', $position_id); } } return $msgarray; } }
public function editAction() { if (defined('EMPTABCONFIGS')) { $popConfigPermission = array(); $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('empcommunicationdetails', $empOrganizationTabs)) { $empDeptdata = array(); $employeeData = array(); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; $loginuserGroup = $auth->getStorage()->read()->group_id; } if (sapp_Global::_checkprivileges(COUNTRIES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'country'); } if (sapp_Global::_checkprivileges(STATES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'state'); } if (sapp_Global::_checkprivileges(CITIES, $loginuserGroup, $loginuserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'city'); } $id = $this->getRequest()->getParam('userid'); if ($id == '') { $id = $loginUserId; } $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $employeeModal = new Default_Model_Employee(); $empdata = $employeeModal->getsingleEmployeeData($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $empDept = $empdata[0]['department_id']; $empcommdetailsform = new Default_Form_empcommunicationdetails(); $empcommdetailsModal = new Default_Model_Empcommunicationdetails(); $usersModel = new Default_Model_Users(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $orgInfoModel = new Default_Model_Organisationinfo(); $msgarray = array(); $orgid = 1; $countryId = ''; $stateId = ''; $cityId = ''; $deptModel = new Default_Model_Departments(); if ($empDept != '' && $empDept != 'NULL') { $empDeptdata = $deptModel->getEmpdepartmentdetails($empDept); if (!empty($empDeptdata)) { $countryId = $empDeptdata[0]['country']; $stateId = $empDeptdata[0]['state']; $cityId = $empDeptdata[0]['city']; } } else { $empDeptdata = $orgInfoModel->getOrganisationDetails($orgid); if (!empty($empDeptdata)) { $countryId = $empDeptdata[0]['country']; $stateId = $empDeptdata[0]['state']; $cityId = $empDeptdata[0]['city']; } } if ($countryId != '') { $countryData = $countriesModel->getActiveCountryName($countryId); } if (!empty($countryData)) { $empDeptdata[0]['country'] = $countryData[0]['country']; } else { $empDeptdata[0]['country'] = ''; } if ($stateId != '') { $stateData = $statesmodel->getStateNameData($stateId); } if (!empty($stateData)) { $empDeptdata[0]['state'] = $stateData[0]['state']; } else { $empDeptdata[0]['state'] = ''; } if ($cityId != '') { $citiesData = $citiesmodel->getCitiesNameData($cityId); } if (!empty($citiesData)) { $empDeptdata[0]['city'] = $citiesData[0]['city']; } else { $empDeptdata[0]['city'] = ''; } $countrieslistArr = $countriesModel->getTotalCountriesList(); if (sizeof($countrieslistArr) > 0) { $empcommdetailsform->perm_country->addMultiOption('', 'Select Country'); $empcommdetailsform->current_country->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $empcommdetailsform->perm_country->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); $empcommdetailsform->current_country->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); } } else { $msgarray['perm_country'] = 'Countries are not configured yet.'; $msgarray['current_country'] = 'Countries are not configured yet.'; } $data = $empcommdetailsModal->getsingleEmpCommDetailsData($id); if (!empty($data)) { $perm_country = $data[0]['perm_country']; if (isset($_POST['perm_country'])) { $perm_country = $_POST['perm_country']; } $perm_state = $data[0]['perm_state']; if (isset($_POST['perm_state'])) { $perm_state = $_POST['perm_state']; } $perm_city = $data[0]['perm_city']; if (isset($_POST['perm_city'])) { $perm_city = $_POST['perm_city']; } if ($perm_country != '') { $statePermlistArr = $statesmodel->getStatesList($perm_country); if (sizeof($statePermlistArr) > 0) { $empcommdetailsform->perm_state->addMultiOption('', 'Select State'); foreach ($statePermlistArr as $statelistres) { $empcommdetailsform->perm_state->addMultiOption($statelistres['id'], $statelistres['state_name']); } } } if ($perm_state != '') { $cityPermlistArr = $citiesmodel->getCitiesList($perm_state); if (sizeof($cityPermlistArr) > 0) { $empcommdetailsform->perm_city->addMultiOption('', 'Select City'); foreach ($cityPermlistArr as $cityPermlistres) { $empcommdetailsform->perm_city->addMultiOption($cityPermlistres['id'], $cityPermlistres['city_name']); } } } $current_country = $data[0]['current_country']; if (isset($_POST['current_country'])) { $current_country = $_POST['current_country']; } $current_state = $data[0]['current_state']; if (isset($_POST['current_state'])) { $current_state = $_POST['current_state']; } $current_city = $data[0]['current_city']; if (isset($_POST['current_city'])) { $current_city = $_POST['current_city']; } if ($current_country != '') { $statecurrlistArr = $statesmodel->getStatesList($current_country); if (sizeof($statecurrlistArr) > 0) { $empcommdetailsform->current_state->addMultiOption('', 'Select State'); foreach ($statecurrlistArr as $statecurrlistres) { $empcommdetailsform->current_state->addMultiOption($statecurrlistres['id'], $statecurrlistres['state_name']); } } } if ($current_state != '') { $cityCurrlistArr = $citiesmodel->getCitiesList($current_state); if (sizeof($cityCurrlistArr) > 0) { $empcommdetailsform->current_city->addMultiOption('', 'Select City'); foreach ($cityCurrlistArr as $cityCurrlistres) { $empcommdetailsform->current_city->addMultiOption($cityCurrlistres['id'], $cityCurrlistres['city_name']); } } } $empcommdetailsform->populate($data[0]); $empcommdetailsform->setDefault('perm_country', $perm_country); $empcommdetailsform->setDefault('perm_state', $perm_state); $empcommdetailsform->setDefault('perm_city', $perm_city); if ($data[0]['current_country'] != '') { $empcommdetailsform->setDefault('current_country', $current_country); } if ($data[0]['current_state'] != '') { $empcommdetailsform->setDefault('current_state', $current_state); } if ($data[0]['current_city'] != '') { $empcommdetailsform->setDefault('current_city', $current_city); } } $empcommdetailsform->setAttrib('action', DOMAIN . 'empcommunicationdetails/edit/userid/' . $id); $empcommdetailsform->user_id->setValue($id); if (!empty($empdata)) { $this->view->employeedata = $empdata[0]; } else { $this->view->employeedata = $empdata; } if (!empty($empDeptdata)) { $this->view->dataArray = $empDeptdata[0]; } else { $this->view->dataArray = $empDeptdata; } $this->view->form = $empcommdetailsform; $this->view->data = $data; $this->view->id = $id; $this->view->msgarray = $msgarray; $this->view->popConfigPermission = $popConfigPermission; $this->view->messages = $this->_helper->flashMessenger->getMessages(); } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } if ($this->getRequest()->getPost()) { $result = $this->save($empcommdetailsform, $id); $this->view->msgarray = $result; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('visadetails', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); $objName = 'visaandimmigrationdetails'; $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $employeeModal = new Default_Model_Employee(); $visaandimmigrationDetailsform = new Default_Form_Visaandimmigrationdetails(); $visaandimmigrationdetailsModel = new Default_Model_Visaandimmigrationdetails(); try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $empdata = $employeeModal->getsingleEmployeeData($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $visaandimmigrationDetailsform->removeElement("submit"); $elements = $visaandimmigrationDetailsform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } $data = $visaandimmigrationdetailsModel->getvisadetailsRecord($id); if (!empty($data)) { $visaandimmigrationDetailsform->setDefault("id", $data[0]["id"]); $visaandimmigrationDetailsform->setDefault("user_id", $data[0]["user_id"]); $visaandimmigrationDetailsform->setDefault("passport_number", $data[0]["passport_number"]); $pp_issue_date = sapp_Global::change_date($data[0]["passport_issue_date"], 'view'); $visaandimmigrationDetailsform->setDefault('passport_issue_date', $pp_issue_date); $pp_expiry_date = sapp_Global::change_date($data[0]["passport_expiry_date"], 'view'); $visaandimmigrationDetailsform->setDefault("passport_expiry_date", $pp_expiry_date); $visaandimmigrationDetailsform->setDefault("visa_number", $data[0]["visa_number"]); $visaandimmigrationDetailsform->setDefault("visa_type", $data[0]["visa_type"]); $v_issue_date = sapp_Global::change_date($data[0]["visa_issue_date"], 'view'); $visaandimmigrationDetailsform->setDefault('visa_issue_date', $v_issue_date); $v_expiry_date = sapp_Global::change_date($data[0]["visa_expiry_date"], 'view'); $visaandimmigrationDetailsform->setDefault("visa_expiry_date", $v_expiry_date); $visaandimmigrationDetailsform->setDefault("inine_status", $data[0]["inine_status"]); $inine_review = sapp_Global::change_date($data[0]["inine_review_date"], 'view'); $visaandimmigrationDetailsform->setDefault("inine_review_date", $inine_review); $visaandimmigrationDetailsform->setDefault("issuing_authority", $data[0]["issuing_authority"]); $visaandimmigrationDetailsform->setDefault("ininetyfour_status", $data[0]["ininetyfour_status"]); $ininetyfour_expiry = sapp_Global::change_date($data[0]["ininetyfour_expiry_date"], 'view'); $visaandimmigrationDetailsform->setDefault("ininetyfour_expiry_date", $ininetyfour_expiry); } $this->view->controllername = $objName; $this->view->id = $id; $this->view->data = $data; $this->view->employeedata = $empdata[0]; $this->view->form = $visaandimmigrationDetailsform; } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('creditcarddetails', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'creditcarddetails'; $creditcardDetailsform = new Default_Form_Creditcarddetails(); $creditcardDetailsModel = new Default_Model_Creditcarddetails(); $creditcardDetailsform->removeElement("submit"); $elements = $creditcardDetailsform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } $data = $creditcardDetailsModel->getcreditcarddetailsRecord($id); $employeeModal = new Default_Model_Employee(); try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $empdata = $employeeModal->getsingleEmployeeData($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { if (!empty($data)) { $creditcardDetailsform->setDefault("id", $data[0]['id']); $creditcardDetailsform->setDefault('user_id', $data[0]['user_id']); $creditcardDetailsform->setDefault("card_type", $data[0]["card_type"]); $creditcardDetailsform->setDefault("card_number", $data[0]["card_number"]); $creditcardDetailsform->setDefault("nameoncard", $data[0]["nameoncard"]); $expiry_date = sapp_Global::change_date($data[0]["card_expiration"], 'view'); $creditcardDetailsform->setDefault('card_expiration', $expiry_date); $creditcardDetailsform->setDefault("card_issuedby", $data[0]["card_issued_comp"]); $creditcardDetailsform->setDefault("card_code", $data[0]["card_code"]); } $this->view->controllername = $objName; $this->view->id = $id; if (!empty($empdata)) { $this->view->employeedata = $empdata[0]; } else { $this->view->employeedata = $empdata; } $this->view->form = $creditcardDetailsform; $this->view->data = $data; } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function employeedetails($emparr, $conText, $userId) { $session = new Zend_Auth_Storage_Session(); $data = $session->read(); $loggedinuser = $data['id']; $group_id = $data['group_id']; $empdata = ''; $employeetabsStr = ''; $empdata = '<div class="ml-alert-1-success" id="empdetailsmsgdiv" style="display:none;">'; $empdata .= '<div class="style-1-icon success" style="display:block;"></div>'; $empdata .= '<div id="successtext"></div>'; $empdata .= '</div>'; $empdata .= '<div class="all-bg-ctrl">'; $employeeModal = new Default_Model_Employee(); $employessunderEmpId = $employeeModal->getEmployeesUnderRM($userId); if (!empty($employessunderEmpId)) { $empdata .= '<input type="hidden" value="true" id="hasteam" name="hasteam" />'; } else { $empdata .= '<input type="hidden" value="false" id="hasteam" name="hasteam" />'; } if ($conText == 'edit' || $conText == 'view') { //If the user has BG status as "Yet to start" then we should enable the link.... $usersModel = new Default_Model_Users(); $bgstatusArr = $usersModel->getBGstatus($userId); if (!empty($bgstatusArr) && isset($bgstatusArr) && $bgstatusArr[0]['group_id'] != MANAGEMENT_GROUP) { if ($bgstatusArr[0]['isactive'] == 1) { $empdata .= '<div id="hrbgchecklink" style="display:none;" class="action-to-page"><a href="' . BASE_URL . '/empscreening/checkscreeningstatus/empid/' . $userId . '">Send for background checks</a></div>'; } } } if ($conText != 'mydetails') { $empdata .= '<div class="back-to-page"><input type="button" value="Back" name="Back" onclick="gobacktocontroller(\'' . $conText . '\');"></div>'; } $empdata .= '<div class="emp-screen-view">'; $empdata .= '<div class="display-img-div" id="displayimg" >'; $empdata .= '<div class="employee-pic-emp">'; if ($emparr['profileimg'] != '') { $empdata .= '<img id="userImage" src="' . BASE_URL . "/public/uploads/profile/" . $emparr['profileimg'] . '" onerror="this.src=\'' . BASE_URL . '/public/media/images/default-profile-pic.jpg\'"/>'; } else { $empdata .= '<img id="userImage" src="' . BASE_URL . '/public/media/images/employee-deafult-pic.jpg" />'; } if ($conText != 'mydetails') { if ($group_id == HR_GROUP || $loggedinuser == SUPERADMIN || $group_id == MANAGEMENT_GROUP) { $sel_act = $sel_dact = ""; if ($emparr['isactive'] < 2 && $emparr['emptemplock'] == 0) { if ($emparr['isactive'] == 1) { $sel_act = "selected"; } else { if ($emparr['isactive'] == 0) { $sel_dact = "selected"; } } $empdata .= '<p class="field switch"><label class="cb-enable ' . $sel_act . '"><span>Active</span></label><label class="cb-disable ' . $sel_dact . '"><span>Inactive</span></label> </p>'; if ($sel_act == "selected") { $empdata .= "\n\t\t\t\t\t\t\t\t\t<script type='text/javascript' language='javascript'>\n\t\t\t\t\t\t\t\t\t\t\$('.cb-disable').click(function(){ \n\t\t\t\t\t\t\t\t\t\t\tmakeActiveInactive('inactive','" . $emparr['id'] . "');\n\t\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t</script> "; } else { if ($sel_dact == "selected") { $empdata .= "\n\t\t\t\t\t\t\t\t\t<script type='text/javascript' language='javascript'>\n\t\t\t\t\t\t\t\t\t\t\$('.cb-enable').click(function(){ \n\t\t\t\t\t\t\t\t\t\t\tmakeActiveInactive('active','" . $emparr['id'] . "');\n\t\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t</script> "; } } } else { if ($emparr['isactive'] < 2 && $emparr['emptemplock'] == 1) { $sel_dact = "selected"; $sel_act = ""; $empdata .= '<p class="field switch"><label class="cb-enable ' . $sel_act . '"><span>Active</span></label><label class="cb-disable ' . $sel_dact . '"><span>Inactive</span></label> </p>'; $empdata .= "\n\t\t\t\t\t\t\t\t<script type='text/javascript' language='javascript'>\n\t\t\t\t\t\t\t\t\t\$('.cb-enable').click(function(){ \n\t\t\t\t\t\t\t\t\t\tmakeActiveInactive('active','" . $emparr['id'] . "');\n\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t</script> \n\t\t\t\t\t\t\t\t"; } else { $sel_dact = "selected"; $sel_act = ""; $empdata .= '<p class="field switch"><label class="cb-enable ' . $sel_act . '"><span>Active</span></label><label class="cb-disable ' . $sel_dact . '"><span>Inactive</span></label> </p>'; $empdata .= "\n\t\t\t\t\t\t\t\t<script type='text/javascript' language='javascript'>\n\t\t\t\t\t\t\t\t\t\$('.cb-enable,.cb-disable').click(function(){ \n\t\t\t\t\t\t\t\t\t\tmakeActiveInactive('other','" . $emparr['isactive'] . "');\n\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t</script> \n\t\t\t\t\t\t\t\t"; } } } } $empdata .= '</div>'; $empdata .= '<div id="loaderimg" style="display:none; clear:both; margin:0 auto; text-align: center; width:100%;"><img src="' . BASE_URL . "/public/media/images/loaderwhite_21X21.gif" . '" style="width:21px; height: 21px; float: none; "/>'; $empdata .= '</div>'; $empdata .= '</div>'; $empdata .= '<div id="personalDetailsDiv">'; if ($emparr['is_orghead'] == '1') { $headicon = '<img src="' . BASE_URL . "/public/media/images/org-head.png" . '" class="org-head-icon" />'; } else { $headicon = ''; } if (isset($emparr['active_prefix']) && isset($emparr['prefix']) && $emparr['active_prefix'] == 1 && $emparr['prefix'] != '') { $empdata .= '<p><b>Employee Name <i>:</i></b><span class="emp-name-span bold-text">' . $emparr['prefix'] . '. ' . $emparr['userfullname'] . '</span>' . $headicon . '</p>'; } else { $empdata .= '<p><b>Employee Name <i>:</i></b><span class="emp-name-span bold-text">' . $emparr['userfullname'] . '</span>' . $headicon . '</p>'; } $empdata .= '<p><b>Employee Id <i>:</i></b><span class="emp-name-span" id ="spanempid">' . $emparr['employeeId'] . '</span></p>'; $empdata .= '<p><b>Email Id <i>:</i></b><span><a href="javascript:void(0)">' . $emparr['emailaddress'] . '</a></span></p>'; if ($emparr['contactnumber'] != '') { $empdata .= '<p><b>Contact Number <i>:</i></b>'; $empdata .= '<span id="contactnospan" >' . $emparr['contactnumber'] . '</span>'; if ($group_id == HR_GROUP || $loggedinuser == SUPERADMIN || $loggedinuser == $userId || $group_id == MANAGER_GROUP) { $empdata .= '<span class="number-edit"><input type="button" value="Update" id="editcontactnumber" name="Edit Number" onclick="opencontactnumberpopup(\'' . $emparr['id'] . '\',\'edit\',\'' . $emparr['contactnumber'] . '\');">'; $empdata .= '</span>'; } $empdata .= '</p>'; } else { $empdata .= '<p><b>Contact Number <i>:</i></b>'; $empdata .= '<span id="contactnospan" ></span>'; if ($group_id == HR_GROUP || $loggedinuser == SUPERADMIN || $loggedinuser == $userId || $group_id == MANAGER_GROUP) { $empdata .= '<span class="number-add"><input type="button" value="Add" id="addcontactnumber" name="Add Number" onclick="opencontactnumberpopup(\'' . $emparr['id'] . '\',\'add\',\'\');">'; $empdata .= '</span>'; } $empdata .= '</p>'; } $empdata .= '</div>'; $empdata .= '</div>'; $empdata .= '<div id="employeeContainer" style="display: none; overflow: auto;"> <div class="heading"> <a href="javascript:void(0)"> <img src="' . BASE_URL . '/public/media/images/close.png" name="" align="right" border="0" hspace="3" vspace="5" class="closeAttachPopup" style="margin: -24px 8px 0 0;"> </a> </div> <iframe id="employeeCont" name="employeeCont" class="business_units_iframe" frameborder="0"></iframe> </div>'; $empdata .= '</div>'; echo $empdata; $employeetabsStr = $this->employeetabs($conText, $userId); echo $employeetabsStr; }
public function editAction() { $genderaddpermission = ''; $msaddpermission = ''; $ethnicaddpermission = ''; $racecodepermission = ''; $languagepermission = ''; $nationalityaddpermission = ''; $identityDocumentArr = array(); $documentsArr = array(); if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('emppersonaldetails', $empOrganizationTabs)) { $loginUserId = ''; $loginUserGroup = ''; $loginUserRole = ''; $auth = Zend_Auth::getInstance(); $emptyFlag = 0; if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginUserGroup = $auth->getStorage()->read()->group_id; $loginUserRole = $auth->getStorage()->read()->emprole; } $genderaddpermission = sapp_Global::_checkprivileges(GENDER, $loginUserGroup, $loginUserRole, 'add'); $msaddpermission = sapp_Global::_checkprivileges(MARITALSTATUS, $loginUserGroup, $loginUserRole, 'add'); $ethnicaddpermission = sapp_Global::_checkprivileges(ETHNICCODE, $loginUserGroup, $loginUserRole, 'add'); $racecodepermission = sapp_Global::_checkprivileges(RACECODE, $loginUserGroup, $loginUserRole, 'add'); $languagepermission = sapp_Global::_checkprivileges(LANGUAGE, $loginUserGroup, $loginUserRole, 'add'); $nationalityaddpermission = sapp_Global::_checkprivileges(NATIONALITY, $loginUserGroup, $loginUserRole, 'add'); $id = $this->getRequest()->getParam('userid'); if ($id == '') { $id = $loginUserId; } $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $employeeModal = new Default_Model_Employee(); $empdata = $employeeModal->getsingleEmployeeData($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $empperdetailsModal = new Default_Model_Emppersonaldetails(); $usersModel = new Default_Model_Users(); $empprobationreviewform = new Default_Form_empprobationreview(); $emppersonaldetailsform = new Default_Form_emppersonaldetails(); if ($loginUserGroup == MANAGEMENT_GROUP || $loginUserGroup == HR_GROUP || $loginUserRole == SUPERADMINROLE) { $identitydocumentsModel = new Default_Model_Identitydocuments(); $identityDocumentArr = $identitydocumentsModel->getIdentitydocumnetsrecord(); } $genderModel = new Default_Model_Gender(); $maritalstatusmodel = new Default_Model_Maritalstatus(); $nationalitymodel = new Default_Model_Nationality(); $ethniccodemodel = new Default_Model_Ethniccode(); $racecodemodel = new Default_Model_Racecode(); $languagemodel = new Default_Model_Language(); $msgarray = array(); $genderlistArr = $genderModel->getGenderList(); if (!empty($genderlistArr)) { foreach ($genderlistArr as $genderlistres) { $emppersonaldetailsform->genderid->addMultiOption($genderlistres['id'], $genderlistres['gendername']); } } else { $msgarray['genderid'] = 'Gender is not configured yet.'; $emptyFlag++; } $maritalstatuslistArr = $maritalstatusmodel->getMaritalStatusList(); if (!empty($maritalstatuslistArr)) { foreach ($maritalstatuslistArr as $maritalstatuslistres) { $emppersonaldetailsform->maritalstatusid->addMultiOption($maritalstatuslistres['id'], $maritalstatuslistres['maritalstatusname']); } } else { $msgarray['maritalstatusid'] = 'Marital status is not configured yet.'; $emptyFlag++; } $nationalitylistArr = $nationalitymodel->getNationalityList(); if (!empty($nationalitylistArr)) { foreach ($nationalitylistArr as $nationalitylistres) { $emppersonaldetailsform->nationalityid->addMultiOption($nationalitylistres['id'], $nationalitylistres['nationalitycode']); } } else { $msgarray['nationalityid'] = 'Nationality is not configured yet.'; $emptyFlag++; } $ethniccodeArr = $ethniccodemodel->gettotalEthnicCodeData(); if (!empty($ethniccodeArr)) { foreach ($ethniccodeArr as $ethniccoderes) { $emppersonaldetailsform->ethniccodeid->addMultiOption($ethniccoderes['id'], $ethniccoderes['ethnicname']); } } else { $msgarray['ethniccodeid'] = 'Ethnic codes are not configured yet.'; $emptyFlag++; } $racecodeArr = $racecodemodel->gettotalRaceCodeData(); if (!empty($racecodeArr)) { foreach ($racecodeArr as $racecoderes) { $emppersonaldetailsform->racecodeid->addMultiOption($racecoderes['id'], $racecoderes['racename']); } } else { $msgarray['racecodeid'] = 'Race codes are not configured yet.'; $emptyFlag++; } $languageArr = $languagemodel->gettotalLanguageData(); if (!empty($languageArr)) { foreach ($languageArr as $languageres) { $emppersonaldetailsform->languageid->addMultiOption($languageres['id'], $languageres['languagename']); } } else { $msgarray['languageid'] = 'Languages are not configured yet.'; $emptyFlag++; } if (!empty($identityDocumentArr)) { $this->view->identitydocument = $identityDocumentArr; } $data = $empperdetailsModal->getsingleEmpPerDetailsData($id); if (!empty($data)) { $emppersonaldetailsform->populate($data[0]); $dob = sapp_Global::change_date($data[0]["dob"], 'view'); $emppersonaldetailsform->dob->setValue($dob); if ($data[0]['celebrated_dob'] != '') { $celebrated_dob = sapp_Global::change_date($data[0]["celebrated_dob"], 'view'); $emppersonaldetailsform->celebrated_dob->setValue($celebrated_dob); } if ($data[0]['identity_documents'] != '') { $documentsArr = get_object_vars(json_decode($data[0]['identity_documents'])); } $emppersonaldetailsform->setDefault('genderid', $data[0]['genderid']); $emppersonaldetailsform->setDefault('maritalstatusid', $data[0]['maritalstatusid']); $emppersonaldetailsform->setDefault('nationalityid', $data[0]['nationalityid']); $emppersonaldetailsform->setDefault('ethniccodeid', $data[0]['ethniccodeid']); $emppersonaldetailsform->setDefault('racecodeid', $data[0]['racecodeid']); $emppersonaldetailsform->setDefault('languageid', $data[0]['languageid']); } $emppersonaldetailsform->user_id->setValue($id); $emppersonaldetailsform->setAttrib('action', DOMAIN . 'emppersonaldetails/edit/userid/' . $id); $this->view->form = $empprobationreviewform; $this->view->data = $data; $this->view->documentsArr = $documentsArr; $this->view->id = $id; $this->view->msgarray = $msgarray; $this->view->employeedata = $empdata[0]; $this->view->emptyFlag = $emptyFlag; $this->view->messages = $this->_helper->flashMessenger->getMessages(); } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } if ($this->getRequest()->getPost()) { $result = $this->save($empprobationreviewform, $id, $identityDocumentArr); $this->view->msgarray = $result; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } $empprobationreviewModal = new Default_Model_Empprobationreview(); $this->view->probationreviewhistory = $this->ConvertArrayToGrid("Probation Review History", $empprobationreviewModal->getProbationReviewHistory($id)); $this->view->genderaddpermission = $genderaddpermission; $this->view->msaddpermission = $msaddpermission; $this->view->ethnicaddpermission = $ethnicaddpermission; $this->view->racecodepermission = $racecodepermission; $this->view->languagepermission = $languagepermission; $this->view->nationalityaddpermission = $nationalityaddpermission; }
public function addemppopupAction() { $flag = 'true'; $controllername = 'employee'; $msgarray = array(); $emptyFlag = 0; Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $deptidforhead = $this->_getParam('deptidforhead', null); $report_opt = array(); $emp_form = new Default_Form_employee(); $user_model = new Default_Model_Usermanagement(); $role_model = new Default_Model_Roles(); $prefixModel = new Default_Model_Prefix(); $identity_code_model = new Default_Model_Identitycodes(); $jobtitlesModel = new Default_Model_Jobtitles(); $deptModel = new Default_Model_Departments(); $positionsmodel = new Default_Model_Positions(); $employeeModal = new Default_Model_Employee(); $usersModel2 = new Default_Model_Users(); $employmentstatusModel = new Default_Model_Employmentstatus(); $emp_form->setAction(DOMAIN . 'employee/addemppopup/deptidforhead/' . $deptidforhead); $emp_form->removeElement('department_id'); $emp_form->removeElement('modeofentry'); $identity_codes = $identity_code_model->getIdentitycodesRecord(); $emp_identity_code = isset($identity_codes[0]) ? $identity_codes[0]['employee_code'] : ""; if ($emp_identity_code != '') { $emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT); } else { $emp_id = ''; $msgarray['employeeId'] = 'Identity codes are not configured yet.'; $flag = 'false'; } $emp_form->employeeId->setValue($emp_id); $role_data = $role_model->getRolesList_Dept(); $emp_form->emprole->addMultiOptions(array('' => 'Select Role') + $role_data); if (empty($role_data)) { $msgarray['emprole'] = 'Roles are not configured yet.'; $flag = 'false'; } $prefixData = $prefixModel->getPrefixList(); $emp_form->prefix_id->addMultiOption('', 'Select Prefix'); if (!empty($prefixData)) { foreach ($prefixData as $prefixres) { $emp_form->prefix_id->addMultiOption($prefixres['id'], $prefixres['prefix']); } } else { $msgarray['prefix_id'] = 'Prefixes are not configured yet.'; $flag = 'false'; } $jobtitleData = $jobtitlesModel->getJobTitleList(); if (!empty($jobtitleData)) { foreach ($jobtitleData as $jobtitleres) { $emp_form->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']); } } else { $msgarray['jobtitle_id'] = 'Job titles are not configured yet.'; $msgarray['position_id'] = 'Positions are not configured yet.'; $flag = 'false'; } if (isset($_POST['jobtitle_id']) && $_POST['jobtitle_id'] != '') { $positionlistArr = $positionsmodel->getPositionList($_POST['jobtitle_id']); if (sizeof($positionlistArr) > 0) { $emp_form->position_id->addMultiOption('', 'Select Position'); foreach ($positionlistArr as $positionlistres) { $emp_form->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']); } } } $employmentStatusData = $employmentstatusModel->getempstatusActivelist(); $emp_form->emp_status_id->addMultiOption('', 'Select Employment Status'); if (!empty($employmentStatusData)) { foreach ($employmentStatusData as $employmentStatusres) { $emp_form->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']); } } else { $msgarray['emp_status_id'] = 'Employment status is not configured yet.'; $emptyFlag++; } $reportingManagerData = $usersModel2->getReportingManagerList_employees('', '', MANAGEMENT_GROUP); if (!empty($reportingManagerData)) { $report_opt = $reportingManagerData; if (isset($_POST['reporting_manager']) && $_POST['reporting_manager'] != '') { $emp_form->setDefault('reporting_manager', $_POST['reporting_manager']); } } else { $msgarray['reporting_manager'] = 'Reporting managers are not added yet.'; $flag = 'false'; } if ($this->getRequest()->getPost()) { if ($emp_form->isValid($this->_request->getPost()) && $flag == 'true') { $jobtitle_id = $this->_request->getParam('jobtitle_id', null); $position_id = $this->_request->getParam('position_id', null); $date_of_joining = sapp_Global::change_date($this->_request->getParam('date_of_joining', null), 'database'); $date_of_leaving = $this->_request->getParam('date_of_leaving', null); $date_of_leaving = sapp_Global::change_date($date_of_leaving, 'database'); $employeeId = $this->_getParam('employeeId', null); $emprole = $this->_getParam('emprole', null); $reporting_manager = $this->_getParam('reporting_manager', null); $emailaddress = $this->_getParam('emailaddress', null); $emppassword = sapp_Global::generatePassword(); $userfullname = trim($this->_request->getParam('userfullname', null)); $prefix_id = $this->_getParam('prefix_id', null); $user_id = $this->_getParam('user_id', null); $emp_status_id = $this->_getParam('emp_status_id', null); $user_data = array('emprole' => $emprole, 'userfullname' => $userfullname, 'emailaddress' => $emailaddress, 'jobtitle_id' => $jobtitle_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'modeofentry' => 'Direct', 'selecteddate' => $date_of_joining, 'userstatus' => 'old'); $emp_data = array('user_id' => $user_id, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'department_id' => $deptidforhead, 'reporting_manager' => $reporting_manager, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'emp_status_id' => $emp_status_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $user_data['createdby'] = $loginUserId; $user_data['createddate'] = gmdate("Y-m-d H:i:s"); $user_data['isactive'] = 1; if ($emp_identity_code != '') { $emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT); } else { $emp_id = ''; } $user_data['employeeId'] = $emp_id; $user_id = $user_model->SaveorUpdateUserData($user_data, ''); $emp_data['user_id'] = $user_id; $emp_data['createdby'] = $loginUserId; $emp_data['createddate'] = gmdate("Y-m-d H:i:s"); $emp_data['isactive'] = 1; $employeeModal->SaveorUpdateEmployeeData($emp_data, ''); //end of saving into employee table. $tableid = $user_id; $actionflag = 1; $menuID = ORGANISATIONINFO; try { $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); } catch (Exception $e) { echo $e->getMessage(); } $managementUsersData = $deptModel->getDeptHeads(); $opt = ''; foreach ($managementUsersData as $record) { $opt .= sapp_Global::selectOptionBuilder($record['id'], $record['userfullname']); } $this->view->managementUsersData = $opt; /* Send Mail to the user */ $base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $view = $this->getHelper('ViewRenderer')->view; $this->view->emp_name = $userfullname; $this->view->password = $emppassword; $this->view->emp_id = $employeeId; $this->view->base_url = $base_url; $text = $view->render('mailtemplates/newpassword.phtml'); $options['subject'] = APPLICATION_NAME . ' login Credentials'; $options['header'] = 'Greetings from Sentrifugo'; $options['toEmail'] = $emailaddress; $options['toName'] = $this->view->emp_name; $options['message'] = $text; $result = sapp_Global::_sendEmail($options); /* END */ $this->view->eventact = 'added'; $close = 'close'; $this->view->popup = $close; } else { $messages = $emp_form->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } $this->view->msgarray = $msgarray; } } $this->view->msgarray = $msgarray; $this->view->report_opt = $report_opt; $this->view->controllername = $controllername; $this->view->emp_form = $emp_form; }
public function empautoAction() { $term = $this->_getParam('term', null); $output = array(array('id' => '', 'value' => 'No records', 'label' => 'No records')); $emp_model = new Default_Model_Employee(); if ($term != '') { $emp_arr = $emp_model->getAutoReportEmp($term); if (count($emp_arr) > 0) { $output = array(); foreach ($emp_arr as $emp) { $output[] = array('id' => $emp['user_id'], 'value' => $emp['emp_name'], 'label' => $emp['emp_name'], 'profile_img' => $emp['profileimg']); } } } $this->_helper->json($output); }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('disabilitydetails', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); $emptyFlag = 0; if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginUserGroup = $auth->getStorage()->read()->group_id; $loginUserRole = $auth->getStorage()->read()->emprole; } $id = $this->getRequest()->getParam('userid'); $employeeModal = new Default_Model_Employee(); try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $isrowexist = $employeeModal->getsingleEmployeeData($id); if ($isrowexist == 'norows') { $this->view->rowexist = "norows"; } else { $this->view->rowexist = "rows"; } $empdata = $employeeModal->getActiveEmployeeData($id); if (!empty($empdata)) { $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'disabilitydetails'; $employeeData = array(); $empDisabilitydetailsform = new Default_Form_Disabilitydetails(); $empDisabilitydetailsModel = new Default_Model_Disabilitydetails(); $empDisabilitydetailsform->removeElement("submit"); $elements = $empDisabilitydetailsform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } $data = $empDisabilitydetailsModel->getempDisabilitydetails($id); $usersModel = new Default_Model_Users(); $employeeData = $usersModel->getUserDetailsByIDandFlag($id); if (!empty($data)) { $empDisabilitydetailsform->setDefault('user_id', $data[0]['user_id']); $empDisabilitydetailsform->setDefault('disability_name', $data[0]['disability_name']); $empDisabilitydetailsform->setDefault('disability_type', $data[0]['disability_type']); $empDisabilitydetailsform->setDefault('other_disability_type', $data[0]['other_disability_type']); $empDisabilitydetailsform->setDefault('disability_description', $data[0]['disability_description']); } $this->view->controllername = $objName; $this->view->id = $id; $this->view->data = $data; $this->view->employeedata = $employeeData[0]; $this->view->form = $empDisabilitydetailsform; } $this->view->empdata = $empdata; } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('emp_holidays', $empOrganizationTabs)) { $conText = ""; $userID = ''; $msgarray = array(); $empGroupId = ''; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); $call = $this->_getParam('call'); if ($call == 'ajaxcall') { $this->_helper->layout->disableLayout(); $userID = $this->_getParam('unitId') != '' ? $this->_getParam('unitId') : $this->_getParam('userid'); $conText = $this->_getParam('context') != '' ? $this->_getParam('context') : $this->getRequest()->getParam('context'); } if ($id == '') { $id = $userID; } $Uid = $id ? $id : $userID; if ($Uid != "") { //TO dispaly EMployee Profile information..... $usersModel = new Default_Model_Users(); $employeeData = $usersModel->getUserDetailsByIDandFlag($Uid); } $employeesModel = new Default_Model_Employees(); $holidaydatesmodel = new Default_Model_Holidaydates(); $employeeModal = new Default_Model_Employee(); try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $isrowexist = $employeeModal->getsingleEmployeeData($id); if ($isrowexist == 'norows') { $this->view->rowexist = "norows"; } else { $this->view->rowexist = "rows"; } $empdata = $employeeModal->getActiveEmployeeData($id); if (!empty($empdata)) { if ($id) { $empholidaysform = new Default_Form_empholidays(); $holidaygroupModel = new Default_Model_Holidaygroups(); $holidaygroupArr = $holidaygroupModel->getAllGroupData(); if (sizeof($holidaygroupArr) > 0) { $empGroupId = $holidaygroupArr[0]['id']; foreach ($holidaygroupArr as $holidaygroupres) { $empholidaysform->holiday_group->addMultiOption($holidaygroupres['id'], $holidaygroupres['groupname']); } } else { $msgarray['empholidaysform'] = 'Holiday groups not configured yet'; } $data = $employeesModel->getHolidayGroupForEmployee($id); if ($data[0]['holiday_group'] != '') { $singleholidaygroupArr = $holidaygroupModel->getsingleGroupData($data[0]['holiday_group']); $empholidaysform->populate($data[0]); $empholidaysform->setDefault('holiday_group', $data[0]['holiday_group']); $empGroupId = $data[0]['holiday_group']; $this->view->data = $data; } $empholidaysform->setAttrib('action', BASE_URL . 'empholidays/edit/userid/' . $id); $this->view->form = $empholidaysform; } if ($this->getRequest()->getPost()) { $result = $this->save($empholidaysform, $id); $this->view->msgarray = $result; } $objname = $this->_getParam('objname'); $refresh = $this->_getParam('refresh'); $dashboardcall = $this->_getParam('dashboardcall', null); $data = array(); $searchQuery = ''; $searchArray = array(); $tablecontent = ''; if ($refresh == 'refresh') { if ($dashboardcall == 'Yes') { $perPage = DASHBOARD_PERPAGE; } else { $perPage = PERPAGE; } $sort = 'DESC'; $by = 'h.modifieddate'; $pageNo = 1; $searchData = ''; $searchQuery = ''; $searchArray = array(); } else { $sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC'; $by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'h.modifieddate'; if ($dashboardcall == 'Yes') { $perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE); } else { $perPage = $this->_getParam('per_page', PERPAGE); } $pageNo = $this->_getParam('page', 1); $searchData = $this->_getParam('searchData'); $searchData = rtrim($searchData, ','); } $objName = 'empholidays'; $dataTmp = $holidaydatesmodel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $objName, $empGroupId, $Uid, $conText); array_push($data, $dataTmp); $this->view->dataArray = $data; $this->view->call = $call; $this->view->id = $id; $this->view->messages = $this->_helper->flashMessenger->getMessages(); if (!empty($employeeData)) { $this->view->employeedata = $employeeData[0]; } } $this->view->empdata = $empdata; } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function displaymanagersAction() { $ajaxContext = $this->_helper->getHelper('AjaxContext'); $ajaxContext->addActionContext('displaymanagers', 'html')->initContext(); $line1_data = array(); $line_managers = array(); $type = $this->_getParam('type', null); $levels = $this->_getParam('levels', null); $init_id = $this->_getParam('init_id', null); $line1_id = $this->_getParam('line1_id', null); $context = $this->_getParam('context', 'add'); $employeeid = $this->_getParam('employeeid'); $app_levels = 1; $app_init_model = new Default_Model_Appraisalinit(); $appEmpRatingsModel = new Default_Model_Appraisalemployeeratings(); $init_data = $app_init_model->getConfigData($init_id); if (count($init_data) > 0) { $init_data = $init_data[0]; } $managers = $app_init_model->getRepManagers_new($type, $init_id, $init_data); if ($context == 'edit') { $emp_model = new Default_Model_Employee(); $line1_data = $emp_model->getEmp_from_summary($line1_id); $line_managers = $app_init_model->getLineManagers_new($init_id, $employeeid); $line_managers = array_filter($line_managers); } $appEmpRatingsData = $appEmpRatingsModel->getSelectedAppraisalData_notused($init_id, $employeeid); if (!empty($appEmpRatingsData)) { if ($appEmpRatingsData['appstatus'] != 1) { $app_levels = $appEmpRatingsData['appstatus'] - 1; } } $this->view->levels = $levels; $this->view->managers = $managers; $this->view->init_id = $init_id; $this->view->context = $context; $this->view->line1_data = $line1_data; $this->view->line_managers = $line_managers; $this->view->line1_id = $line1_id; $this->view->app_levels = $app_levels; $this->render('displaymanagers'); }
public function getapproverAction() { $ajaxContext = $this->_helper->getHelper('AjaxContext'); $ajaxContext->addActionContext('getapprover', 'html')->initContext(); $employeemodel = new Default_Model_Employee(); $elementid = $this->_request->getParam('elementid'); $bunitid = $this->_request->getParam('bunitid'); $deptid = $this->_request->getParam('deptid'); $approver_1 = $this->_request->getParam('approver_1'); $approver_2 = $this->_request->getParam('approver_2'); $employeeData = array(); $approvercount = ''; $empstring = ''; if ($elementid == 'approvingauthority') { $approvercount = 1; } else { if ($elementid == 'approver_1') { $approvercount = 2; } else { $approvercount = 3; } } if ($approver_1 != '') { $empstring = $approver_1; } if ($approver_2 != '') { $empstring .= ',' . $approver_2; } $employeeData = $employeemodel->getApproverForServiceDesk($bunitid, $deptid, $empstring); $this->view->employeedata = $employeeData; $this->view->approvercount = $approvercount; }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('workeligibilitydetails', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $employeeData = array(); $id = $this->getRequest()->getParam('userid'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'workeligibilitydetails'; $issuingauthority = ''; $employeeModal = new Default_Model_Employee(); $workeligibilityform = new Default_Form_Workeligibilitydetails(); $workeligibilityform->removeElement("submit"); $elements = $workeligibilityform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $usersModel = new Default_Model_Users(); $empdata = $employeeModal->getActiveEmployeeData($id); $employeeData = $usersModel->getUserDetailsByIDandFlag($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $workeligibilityModel = new Default_Model_Workeligibilitydetails(); if ($id) { $usersModel = new Default_Model_Users(); $workeligibilityDoctypesModal = new Default_Model_Workeligibilitydoctypes(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $countrieslistArr = $countriesModel->getTotalCountriesList(); if (sizeof($countrieslistArr) > 0) { $workeligibilityform->issuingauth_country->addMultiOption('', 'Select Country'); foreach ($countrieslistArr as $countrieslistres) { $workeligibilityform->issuingauth_country->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name'])); } } else { $msgarray['issuingauth_country'] = 'Countries are not configured yet.'; } $data = $workeligibilityModel->getWorkEligibilityRecord($id); if (!empty($data) && isset($data)) { $countryId = $data[0]['issuingauth_country']; $stateId = $data[0]['issuingauth_state']; $cityId = $data[0]['issuingauth_city']; $documenttype_id = $data[0]['documenttype_id']; if ($countryId != '') { $statelistArr = $statesmodel->getStatesList($countryId); if (sizeof($statelistArr) > 0) { $workeligibilityform->issuingauth_state->addMultiOption('', 'Select State'); foreach ($statelistArr as $statelistres) { $workeligibilityform->issuingauth_state->addMultiOption($statelistres['id'] . '!@#' . $statelistres['state_name'], $statelistres['state_name']); } } } if ($stateId != '') { $citylistArr = $citiesmodel->getCitiesList($stateId); if (sizeof($citylistArr) > 0) { $workeligibilityform->issuingauth_city->addMultiOption('', 'Select City'); foreach ($citylistArr as $cityPermlistres) { $workeligibilityform->issuingauth_city->addMultiOption($cityPermlistres['id'] . '!@#' . $cityPermlistres['city_name'], $cityPermlistres['city_name']); } } $stateNameArr = $statesmodel->getStateName($stateId); } if ($cityId != '') { $cityNameArr = $citiesmodel->getCityName($cityId); } if ($documenttype_id != '') { $issuingauthorityArr = $workeligibilityDoctypesModal->getIssuingAuthority($documenttype_id); } if (!empty($issuingauthorityArr)) { $issuingauthority = $issuingauthorityArr[0]['issuingauthority']; $workeligibilityform->issuingauthflag->setValue($issuingauthority); $workeligibilityform->documenttype_id->addMultiOption($issuingauthorityArr[0]['id'], $issuingauthorityArr[0]['documenttype']); } $workeligibilityform->setDefault("id", $data[0]["id"]); $workeligibilityform->setDefault("user_id", $data[0]["user_id"]); $workeligibilityform->setDefault('issuingauth_country', $data[0]['issuingauth_country']); if (!empty($stateNameArr)) { $workeligibilityform->setDefault('issuingauth_state', $stateNameArr[0]['id'] . '!@#' . $stateNameArr[0]['statename']); } if (!empty($cityNameArr)) { $workeligibilityform->setDefault('issuingauth_city', $cityNameArr[0]['id'] . '!@#' . $cityNameArr[0]['cityname']); } $workeligibilityform->setDefault("documenttype_id", $data[0]["documenttype_id"]); $workeligibilityform->setDefault("issuingauth_name", $data[0]["issuingauth_name"]); $workeligibilityform->setDefault("issuingauth_postalcode", $data[0]["issuingauth_postalcode"]); $issue_date = date(DATEFORMAT_PHP, strtotime($data[0]["doc_issue_date"])); $workeligibilityform->setDefault('doc_issue_date', $issue_date); $expiry_date = date(DATEFORMAT_PHP, strtotime($data[0]["doc_expiry_date"])); $workeligibilityform->setDefault('doc_expiry_date', $expiry_date); } $this->view->controllername = $objName; $this->view->id = $id; $this->view->data = $data; $this->view->employeedata = $employeeData[0]; $this->view->form = $workeligibilityform; $this->view->issuingauthority = $issuingauthority; } } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('dependency_details', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginUserRole = $auth->getStorage()->read()->emprole; $loginUserGroup = $auth->getStorage()->read()->group_id; } $userid = $this->getRequest()->getParam('userid'); $employeeData = array(); $empdata = array(); $userID = ''; $conText = ""; $call = $this->_getParam('call'); if ($call == 'ajaxcall') { $this->_helper->layout->disableLayout(); $userID = $this->_getParam('unitId') != '' ? $this->_getParam('unitId') : $this->_getParam('userid'); $conText = $this->_getParam('context') != '' ? $this->_getParam('context') : $this->getRequest()->getParam('context'); } if ($userid == '') { $userid = $userID; } $dependencydetailsModel = new Default_Model_Dependencydetails(); $employeeModal = new Default_Model_Employee(); try { if ($userid && is_numeric($userid) && $userid > 0 && $userid != $loginUserId) { $isrowexist = $employeeModal->getsingleEmployeeData($userid); if ($isrowexist == 'norows') { $this->view->rowexist = "norows"; } else { $this->view->rowexist = "rows"; } $empdata = $employeeModal->getActiveEmployeeData($userid); if (!empty($empdata)) { $view = Zend_Layout::getMvcInstance()->getView(); $objname = $this->_getParam('objname'); $refresh = $this->_getParam('refresh'); $data = array(); $searchQuery = ''; $searchArray = array(); $tablecontent = ''; if ($refresh == 'refresh') { $sort = 'DESC'; $by = 'modifieddate'; $perPage = 10; $pageNo = 1; $searchData = ''; } else { $sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC'; $by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'modifieddate'; $perPage = $this->_getParam('per_page', 10); $pageNo = $this->_getParam('page', 1); $searchData = $this->_getParam('searchData'); $searchData = rtrim($searchData, ','); /** search from grid - START **/ $searchData = $this->_getParam('searchData'); if ($searchData != '' && $searchData != 'undefined') { $searchValues = json_decode($searchData); foreach ($searchValues as $key => $val) { $searchQuery .= " " . $key . " like '%" . $val . "%' AND "; $searchArray[$key] = $val; } $searchQuery = rtrim($searchQuery, " AND"); } /** search from grid - END **/ } $objName = 'dependencydetails'; $Uid = $userid ? $userid : $userID; $tableFields = array('action' => 'Action', 'dependent_name' => 'Dependent Name', 'dependent_relation' => 'Dependent Relation', 'dependent_dob' => 'Dependent DOB'); $tablecontent = $dependencydetailsModel->getdependencydetailsData($sort, $by, $pageNo, $perPage, $searchQuery, $Uid); if ($Uid != "") { $usersModel = new Default_Model_Users(); $employeeData = $usersModel->getUserDetailsByIDandFlag($Uid); } $dataTmp = array('userid' => $Uid, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getEmployeeAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'add' => 'add', 'menuName' => 'Dependency', 'formgrid' => 'true', 'unitId' => $Uid, 'call' => $call, 'context' => $conText); array_push($data, $dataTmp); $this->view->id = $userid; $this->view->controllername = $objName; $this->view->dataArray = $data; $this->view->call = $call; $this->view->employeedata = $employeeData[0]; $this->view->messages = $this->_helper->flashMessenger->getMessages(); } $this->view->empdata = $empdata; } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('emp_salary', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); if ($id == '') { $id = $loginUserId; } $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'empsalarydetails'; $empsalarydetailsform = new Default_Form_empsalarydetails(); $empsalarydetailsform->removeElement("submit"); $elements = $empsalarydetailsform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $employeeModal = new Default_Model_Employee(); $empdata = $employeeModal->getsingleEmployeeData($id); if ($empdata == 'norows') { $this->view->rowexist = "norows"; $this->view->empdata = ""; } else { $this->view->rowexist = "rows"; if (!empty($empdata)) { $empsalarydetailsModal = new Default_Model_Empsalarydetails(); $usersModel = new Default_Model_Users(); $currencymodel = new Default_Model_Currency(); $accountclasstypemodel = new Default_Model_Accountclasstype(); $bankaccounttypemodel = new Default_Model_Bankaccounttype(); $data = $empsalarydetailsModal->getsingleEmpSalaryDetailsData($id); if (!empty($data)) { if (isset($data[0]['currencyid']) && $data[0]['currencyid'] != '') { $currencyArr = $currencymodel->getCurrencyDataByID($data[0]['currencyid']); if (sizeof($currencyArr) > 0) { $empsalarydetailsform->currencyid->addMultiOption($currencyArr[0]['id'], $currencyArr[0]['currencyname'] . ' ' . $currencyArr[0]['currencycode']); } } if (isset($data[0]['accountclasstypeid']) && $data[0]['accountclasstypeid'] != '') { $accountclasstypeArr = $accountclasstypemodel->getsingleAccountClassTypeData($data[0]['accountclasstypeid']); if (sizeof($accountclasstypeArr) > 0) { $empsalarydetailsform->accountclasstypeid->addMultiOption($accountclasstypeArr[0]['id'], $accountclasstypeArr[0]['accountclasstype']); } } if (isset($data[0]['bankaccountid']) && $data[0]['bankaccountid'] != '') { $bankaccounttypeArr = $bankaccounttypemodel->getsingleBankAccountData($data[0]['bankaccountid']); if ($bankaccounttypeArr != 'norows') { $empsalarydetailsform->bankaccountid->addMultiOption($bankaccounttypeArr[0]['id'], $bankaccounttypeArr[0]['bankaccounttype']); } } $empsalarydetailsform->populate($data[0]); if ($data[0]['accountholding'] != '') { $accountholding = sapp_Global::change_date($data[0]["accountholding"], 'view'); $empsalarydetailsform->accountholding->setValue($accountholding); } } $this->view->controllername = $objName; $this->view->data = $data; $this->view->id = $id; $this->view->form = $empsalarydetailsform; $this->view->employeedata = $empdata[0]; } $this->view->empdata = $empdata; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function getindividualempdetailsAction() { $employeeModel = new Default_Model_Employee(); $userid = $this->_request->getParam('userid', null); $userdetails = $employeeModel->getEmp_from_summary($userid); $this->view->userdetails = $userdetails; }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('emp_leaves', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); $conText = ""; $call = $this->_getParam('call'); if ($call == 'ajaxcall') { $this->_helper->layout->disableLayout(); $userID = $this->_getParam('unitId') != '' ? $this->_getParam('unitId') : $this->_getParam('userid'); $conText = $this->_getParam('context') != '' ? $this->_getParam('context') : $this->getRequest()->getParam('context'); } $usersModel = new Default_Model_Users(); if ($id == '') { $id = $userID; } $Uid = $id ? $id : $userID; if ($Uid != "") { $employeeData = $usersModel->getUserDetailsByIDandFlag($Uid); } $employeeleavesModel = new Default_Model_Employeeleaves(); $employeeModal = new Default_Model_Employee(); try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $isrowexist = $employeeModal->getsingleEmployeeData($id); if ($isrowexist == 'norows') { $this->view->rowexist = "norows"; } else { $this->view->rowexist = "rows"; } $empdata = $employeeModal->getActiveEmployeeData($id); if (!empty($empdata)) { $usersModel = new Default_Model_Users(); if ($id) { $empleavesform = new Default_Form_empleaves(); $employeeleavesModal = new Default_Model_Employeeleaves(); $data = $employeeleavesModal->getsingleEmployeeleaveData($id); $used_leaves = 0; $date = date('Y'); if (!empty($data)) { $empleavesform->populate($data[0]); $used_leaves = $data[0]['used_leaves']; } $empleavesform->alloted_year->setValue($date); $empleavesform->setAttrib('action', BASE_URL . 'empleaves/edit/userid/' . $id); $this->view->form = $empleavesform; $this->view->data = $data; $this->view->id = $id; } $objname = $this->_getParam('objname'); $refresh = $this->_getParam('refresh'); $dashboardcall = $this->_getParam('dashboardcall', null); $data = array(); $searchQuery = ''; $searchArray = array(); $tablecontent = ''; if ($refresh == 'refresh') { if ($dashboardcall == 'Yes') { $perPage = DASHBOARD_PERPAGE; } else { $perPage = PERPAGE; } $sort = 'DESC'; $by = 'e.modifieddate'; $pageNo = 1; $searchData = ''; $searchQuery = ''; $searchArray = array(); } else { $sort = $this->_getParam('sort') != '' ? $this->_getParam('sort') : 'DESC'; $by = $this->_getParam('by') != '' ? $this->_getParam('by') : 'e.modifieddate'; if ($dashboardcall == 'Yes') { $perPage = $this->_getParam('per_page', DASHBOARD_PERPAGE); } else { $perPage = $this->_getParam('per_page', PERPAGE); } $pageNo = $this->_getParam('page', 1); $searchData = $this->_getParam('searchData'); $searchData = rtrim($searchData, ','); } $dataTmp = $employeeleavesModel->getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $Uid, $conText); array_push($data, $dataTmp); $this->view->dataArray = $data; $this->view->call = $call; $this->view->id = $id; $this->view->messages = $this->_helper->flashMessenger->getMessages(); if (!empty($employeeData)) { $this->view->employeedata = $employeeData[0]; } } $this->view->empdata = $empdata; } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function editAction() { $orgInfoModel = new Default_Model_Organisationinfo(); $getorgData = $orgInfoModel->getorgrecords(); $sitepreferencemodel = new Default_Model_Sitepreference(); $activerecordArr = $sitepreferencemodel->getActiveRecord(); $timezoneid = !empty($activerecordArr[0]['timezoneid']) ? $activerecordArr[0]['timezoneid'] : ''; $popConfigPermission = array(); $organisationHead = array(); if (!empty($getorgData)) { $orgdata = ''; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginUserRole = $auth->getStorage()->read()->emprole; $loginUserGroup = $auth->getStorage()->read()->group_id; } if (sapp_Global::_checkprivileges(TIMEZONE, $loginUserGroup, $loginUserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'timezone'); } if (sapp_Global::_checkprivileges(COUNTRIES, $loginUserGroup, $loginUserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'country'); } if (sapp_Global::_checkprivileges(STATES, $loginUserGroup, $loginUserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'state'); } if (sapp_Global::_checkprivileges(CITIES, $loginUserGroup, $loginUserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'city'); } if (sapp_Global::_checkprivileges(EMPLOYEE, $loginUserGroup, $loginUserRole, 'add') == 'Yes') { array_push($popConfigPermission, 'employee'); } $msgarray = array(); $flag = 'true'; $id = $this->getRequest()->getParam('id'); $callval = $this->getRequest()->getParam('call'); $deptModel = new Default_Model_Departments(); $deptform = new Default_Form_departments(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $countriesModel = new Default_Model_Countries(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $timezonemodel = new Default_Model_Timezone(); $businessunitsmodel = new Default_Model_Businessunits(); $orgInfoModel = new Default_Model_Organisationinfo(); $employeeModal = new Default_Model_Employee(); $allTimezoneData = $timezonemodel->fetchAll('isactive=1', 'timezone')->toArray(); $allCountriesData = $countriesModel->fetchAll('isactive=1', 'country')->toArray(); $allStatesData = $statesmodel->fetchAll('isactive=1', 'state')->toArray(); $allCitiesData = $citiesmodel->fetchAll('isactive=1', 'city')->toArray(); $allBusinessunitsData = $businessunitsmodel->fetchAll('isactive=1', 'unitname')->toArray(); $deptData = array(); $deptform->setAttrib('action', BASE_URL . 'departments/edit'); $country = $getorgData[0]['country']; if (isset($_POST['country'])) { $country = $_POST['country']; } $state = $getorgData[0]['state']; if (isset($_POST['state'])) { $state = $_POST['state']; } $city = $getorgData[0]['city']; if (isset($_POST['city'])) { $city = $_POST['city']; } $deptform->setDefault('timezone', $timezoneid); $address = $getorgData[0]['address1']; $organisationHead = $employeeModal->getCurrentOrgHead(); if (isset($country) && $country != 0 && $country != '') { $deptform->setDefault('country', $country); $statesData = $statesmodel->getBasicStatesList($country); foreach ($statesData as $res) { $deptform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state'])); } if (isset($state) && $state != 0 && $state != '') { $deptform->setDefault('state', $state); } } if (isset($state) && $state != 0 && $state != '') { $citiesData = $citiesmodel->getBasicCitiesList($state); foreach ($citiesData as $res) { $deptform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city'])); } if (isset($city) && $city != 0 && $city != '') { $deptform->setDefault('city', $city); } } if (isset($address) && $address != '') { $deptform->address1->setValue($address); } if (is_numeric($id) && $id > 0) { $data = $deptModel->getSingleDepartmentData($id); if (!empty($data)) { $deptform->setAttrib('action', BASE_URL . 'departments/edit/id/' . $id); $managementUsersData = $deptModel->getDepartmenttHead($data['depthead']); foreach ($managementUsersData as $mgmtdata) { $deptform->depthead->addMultiOption($mgmtdata['user_id'], $mgmtdata['userfullname']); } $deptform->populate($data); $deptform->setDefault('depthead', $data['depthead']); $deptform->submit->setLabel('Update'); $deptform->state->clearMultiOptions(); $deptform->city->clearMultiOptions(); $deptform->state->addMultiOption('', utf8_encode("Select State")); $deptform->city->addMultiOption('', utf8_encode("Select City")); $countryId = $data['country']; if (isset($_POST['country'])) { $countryId = $_POST['country']; } $stateId = $data['state']; if (isset($_POST['state'])) { $stateId = $_POST['state']; } $cityId = $data['city']; if (isset($_POST['city'])) { $cityId = $_POST['city']; } if ($countryId != '') { $statesData = $statesmodel->getBasicStatesList($countryId); foreach ($statesData as $res) { $deptform->state->addMultiOption($res['state_id_org'], utf8_encode($res['state'])); } $deptform->setDefault('country', $countryId); $deptform->setDefault('state', $stateId); } if ($stateId != '') { $citiesData = $citiesmodel->getBasicCitiesList($stateId); foreach ($citiesData as $res) { $deptform->city->addMultiOption($res['city_org_id'], utf8_encode($res['city'])); } $deptform->setDefault('city', $cityId); } if ($data["startdate"] != '') { $st_date = sapp_Global::change_date($data["startdate"], 'view'); $deptform->setDefault('start_date', $st_date); } $this->view->ermsg = ''; $this->view->datarr = $data; } else { $this->view->ermsg = 'nodata'; } } else { if ($id != '') { $this->view->ermsg = 'nodata'; } else { $managementUsersData = $deptModel->getDepartmenttHead(''); foreach ($managementUsersData as $mgmtdata) { $deptform->depthead->addMultiOption($mgmtdata['user_id'], $mgmtdata['userfullname']); } } } $this->view->deptData = sizeof($deptData); $this->view->form = $deptform; if (!empty($allBusinessunitsData) && !empty($allCountriesData) && !empty($allStatesData) && !empty($allCitiesData) && !empty($allTimezoneData)) { $this->view->configuremsg = ''; } else { $this->view->configuremsg = 'notconfigurable'; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; $flag = 'false'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; $flag = 'false'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; $flag = 'false'; } if (empty($allBusinessunitsData)) { $msgarray['unitid'] = 'Business units are not added yet.'; $flag = 'false'; } if (empty($allTimezoneData)) { $msgarray['timezone'] = 'Time zones are not configured yet.'; $flag = 'false'; } $this->view->msgarray = $msgarray; if ($this->getRequest()->getPost()) { $deptname = trim($this->_request->getParam('deptname')); $unitid = $this->_request->getParam('unitid'); if ($deptname != '' && $unitid != '') { if (!preg_match('/^[a-zA-Z.\\- ?]+$/', $deptname)) { $msgarray['deptname'] = "Please enter valid department name."; $flag = 'false'; } else { $checkExists = $deptModel->checkExistance($deptname, $unitid, $id); if ($checkExists != 0) { $msgarray['deptname'] = "Department name already exists."; $flag = 'false'; } } } else { $flag = 'false'; } $start_date = $this->_request->getParam('start_date', null); $start_date = sapp_Global::change_date($start_date, 'database'); if ($deptform->isValid($this->_request->getPost()) && $flag == 'true') { $deptname = $this->_request->getParam('deptname'); $deptcode = $this->_request->getParam('deptcode'); $description = $this->_request->getParam('description'); $country = $this->_request->getParam('country'); $state = intval($this->_request->getParam('state')); $city = $this->_request->getParam('city'); $address1 = $this->_request->getParam('address1'); $address2 = $this->_request->getParam('address2'); $address3 = $this->_request->getParam('address3'); $unitid = $this->_request->getParam('unitid'); $timezone = $this->_request->getParam('timezone'); $depthead = $this->_request->getParam('depthead'); $deptcodeExistance = $deptModel->checkCodeDuplicates($deptcode, $id); if (!$deptcodeExistance) { $date = new Zend_Date(); $actionflag = ''; $tableid = ''; $data = array('deptname' => trim($deptname), 'deptcode' => trim($deptcode), 'description' => trim($description), 'startdate' => $start_date != '' ? $start_date : NULL, 'country' => trim($country), 'state' => trim($state), 'city' => trim($city), 'address1' => trim($address1), 'address2' => trim($address2), 'address3' => trim($address3), 'timezone' => trim($timezone), 'unitid' => $unitid, 'depthead' => trim($depthead), 'modifiedby' => $loginUserId, 'modifieddate' => $date->get('yyyy-MM-dd HH:mm:ss')); if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = $date->get('yyyy-MM-dd HH:mm:ss'); $data['isactive'] = 1; $where = ''; $actionflag = 1; } $Id = $deptModel->SaveorUpdateDepartmentsUnits($data, $where); /* Updating business unit and department for org head*/ $emp_data = array('businessunit_id' => $unitid, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $emp_where = array('user_id=?' => $depthead); if ($Id == 'update') { $tableid = $id; $emp_data['department_id'] = $id; $this->_helper->getHelper("FlashMessenger")->addMessage("Department updated successfully."); } else { $tableid = $Id; $emp_data['department_id'] = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage("Department added successfully."); } $employeeModal->SaveorUpdateEmployeeData($emp_data, $emp_where); $menuID = DEPARTMENTS; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); $this->_redirect('departments'); } else { $msgarray['message'] = 'A Department, with the given code, already exists.'; $msgarray['msgtype'] = 'error'; $this->view->messages = $msgarray; } } else { $messages = $deptform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } if (empty($allCountriesData)) { $msgarray['country'] = 'Countries are not configured yet.'; } if (empty($allStatesData)) { $msgarray['state'] = 'States are not configured yet.'; } if (empty($allCitiesData)) { $msgarray['city'] = 'Cities are not configured yet.'; } if (empty($allBusinessunitsData)) { $msgarray['unitid'] = 'Business units are not added yet.'; } if (empty($allTimezoneData)) { $msgarray['timezone'] = 'Time zones are not configured yet.'; } } $this->view->msgarray = $msgarray; } } } else { $orgdata = 'noorgdata'; $this->view->orgdata = $orgdata; } $this->view->popConfigPermission = $popConfigPermission; $this->view->organisationHead = $organisationHead; }
public function getdisplayacontentreportacc($init_id, $manager_id) { $data = array(); if ($init_id !== '' && $manager_id !== '') { /*** *** edited on 12-03-2015 , soujanya *** for filtering employees based on business unit id in Initialize appraisal > step -2 ***/ //echo $init_id.">>".$manager_id;die; $appInitializationData = $this->getConfigData($init_id); if (!empty($appInitializationData)) { $businessUnitId = $appInitializationData[0]['businessunit_id']; $departmentId = $appInitializationData[0]['department_id']; $eligibility = $appInitializationData[0]['eligibility']; $emp_model = new Default_Model_Employee(); $data = $emp_model->getEmployeesUnderRM($manager_id, $businessUnitId, $departmentId, $eligibility); } } return $data; }
/** * Export analytics of employees reporting to manager to excel. */ public function exportemployeereportAction() { $this->_helper->layout->disableLayout(); $param_arr = $this->_getAllParams(); $cols_param_arr = $this->_getParam('cols_arr', array()); if (isset($param_arr['cols_arr'])) { unset($param_arr['cols_arr']); } $page_no = isset($param_arr['page_no']) ? $param_arr['page_no'] : 1; $per_page = isset($param_arr['per_page']) ? $param_arr['per_page'] : PERPAGE; $sort_name = $param_arr['sort_name']; $sort_type = $param_arr['sort_type']; if (isset($param_arr['page_no'])) { unset($param_arr['page_no']); } if (isset($param_arr['sort_name'])) { unset($param_arr['sort_name']); } if (isset($param_arr['sort_type'])) { unset($param_arr['sort_type']); } if (isset($param_arr['per_page'])) { unset($param_arr['per_page']); } unset($param_arr['module']); unset($param_arr['controller']); unset($param_arr['action']); // Get employees data reporting to manager $myEmployees_model = new Default_Model_Myemployees(); $param_arr['reporting_manager'] = $myEmployees_model->getLoginUserId(); if (count($cols_param_arr) == 0) { $cols_param_arr = $this->empreport_heplper1('mandatory'); } $employee_model = new Default_Model_Employee(); $emp_data_org = $employee_model->getdata_emp_report($param_arr, $per_page, $page_no, $sort_name, $sort_type); $emp_arr = $emp_data_org['rows']; require_once 'Classes/PHPExcel.php'; require_once 'Classes/PHPExcel/IOFactory.php'; $objPHPExcel = new PHPExcel(); $letters = range('A', 'Z'); $count = 0; $filename = "EmployeeReport.xlsx"; $cell_name = ""; // Show count of employees reporting to manager // Get employees data reporting to manager $myEmployees_model = new Default_Model_Myemployees(); $employee_model = new Default_Model_Employee(); $count_emp_reporting = $employee_model->getCountEmpReporting($myEmployees_model->getLoginUserId()); $objPHPExcel->getActiveSheet()->SetCellValue($letters[$count] . "1", "My Team Count : " . $count_emp_reporting); // Make first row Headings bold and highlighted in Excel. foreach ($cols_param_arr as $names) { $i = 2; $cell_name = $letters[$count] . $i; $names = html_entity_decode($names, ENT_QUOTES, 'UTF-8'); $objPHPExcel->getActiveSheet()->SetCellValue($cell_name, $names); // Make bold cells $objPHPExcel->getActiveSheet()->getStyle($cell_name)->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle($cell_name)->applyFromArray(array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => '82CAFF')))); $objPHPExcel->getActiveSheet()->getColumnDimension($letters[$count])->setAutoSize(true); $i++; $count++; } // Display field/column values in Excel. $i = 3; foreach ($emp_arr as $emp_data) { $count1 = 0; foreach ($cols_param_arr as $column_key => $column_name) { // display field/column values $cell_name = $letters[$count1] . $i; if ($column_key == 'userfullname') { $value = isset($emp_data['prefix_name']) ? $emp_data['prefix_name'] . ". " . $emp_data['userfullname'] : $emp_data['userfullname']; } elseif ($column_key == 'date_of_joining') { $value = isset($emp_data['date_of_joining']) ? sapp_Global::change_date($emp_data['date_of_joining'], "view") : ""; } else { $value = isset($emp_data[$column_key]) ? $emp_data[$column_key] : ""; } $value = html_entity_decode($value, ENT_QUOTES, 'UTF-8'); $objPHPExcel->getActiveSheet()->SetCellValue($cell_name, $value); $count1++; } $i++; } sapp_Global::clean_output_buffer(); header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header("Content-Disposition: attachment; filename=\"{$filename}\""); header('Cache-Control: max-age=0'); sapp_Global::clean_output_buffer(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output'); exit; }
public function changeOrgHead($oldhead, $newhead, $oldheadRM = '') { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $db = Zend_Db_Table::getDefaultAdapter(); $empmodel = new Default_Model_Employee(); $oldRMData = $empmodel->getsingleEmployeeData($oldhead); try { $empQuery1 = "UPDATE main_employees SET reporting_manager = " . $newhead . ", modifieddate = '" . gmdate("Y-m-d H:i:s") . "', modifiedby = " . $loginUserId . " WHERE reporting_manager=" . $oldhead . " and isactive = 1 AND user_id <> " . $newhead . ";"; if ($oldheadRM != '') { $orgQuery1 = "UPDATE main_employees SET is_orghead = 0, reporting_manager= " . $oldheadRM . ", modifieddate = '" . gmdate("Y-m-d H:i:s") . "', modifiedby = " . $loginUserId . " WHERE user_id=" . $oldhead . " ;"; $db->query($orgQuery1); } $orgQuery2 = "UPDATE main_employees SET is_orghead = 1,reporting_manager= 0, modifieddate = '" . gmdate("Y-m-d H:i:s") . "', modifiedby = " . $loginUserId . " WHERE user_id=" . $newhead . " ;"; $db->query($orgQuery2); $db->query($empQuery1); return 'success'; } catch (Exception $e) { return 'failed'; } }
public function editpopupAction() { Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('id'); $userid = $this->getRequest()->getParam('unitId'); if ($id == '') { $id = $loginUserId; } // For open the form in popup... $empjobhistoryform = new Default_Form_empjobhistory(); $empjobhistoryModel = new Default_Model_Empjobhistory(); $employeeModel = new Default_Model_Employee(); $positionModel = new Default_Model_Positions(); $departmentModel = new Default_Model_Departments(); $jobtitleModel = new Default_Model_Jobtitles(); $clientsModel = new Timemanagement_Model_Clients(); if ($id) { $employeeArr = $employeeModel->getActiveEmployeeData($userid); if (!empty($employeeArr)) { if (isset($employeeArr[0]['businessunit_id']) && $employeeArr[0]['businessunit_id'] != '') { $departmentArr = $departmentModel->getDepartmentList($employeeArr[0]['businessunit_id']); if (!empty($departmentArr)) { $empjobhistoryform->department->addMultiOption('', 'Select Department'); foreach ($departmentArr as $departmentres) { $empjobhistoryform->department->addMultiOption($departmentres['id'], $departmentres['deptname']); } } } else { $departmentArr = $departmentModel->getTotalDepartmentList(); if (!empty($departmentArr)) { $empjobhistoryform->department->addMultiOption('', 'Select Department'); foreach ($departmentArr as $departmentres) { $empjobhistoryform->department->addMultiOption($departmentres['id'], $departmentres['deptname']); } } } } $positionArr = $positionModel->getTotalPositionList(); if (!empty($positionArr)) { $empjobhistoryform->positionheld->addMultiOption('', 'Select Position'); foreach ($positionArr as $positionres) { $empjobhistoryform->positionheld->addMultiOption($positionres['id'], $positionres['positionname']); } } $jobtitleArr = $jobtitleModel->getJobTitleList(); if (!empty($jobtitleArr)) { $empjobhistoryform->jobtitleid->addMultiOption('', 'Select Job Title'); foreach ($jobtitleArr as $jobtitleres) { $empjobhistoryform->jobtitleid->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']); } } $clientsArr = $clientsModel->getActiveClientsData(); if (!empty($clientsArr)) { $empjobhistoryform->client->addMultiOption('', 'Select a Client'); foreach ($clientsArr as $clientsres) { $empjobhistoryform->client->addMultiOption($clientsres['id'], $clientsres['client_name']); } } $data = $empjobhistoryModel->getsingleEmpJobHistoryData($id); if (!empty($data)) { $empjobhistoryform->populate($data[0]); $empjobhistoryform->setDefault('department', $data[0]['department']); $empjobhistoryform->setDefault('positionheld', $data[0]['positionheld']); $empjobhistoryform->setDefault('jobtitleid', $data[0]['jobtitleid']); $empjobhistoryform->setDefault('client', $data[0]['client_id']); if (isset($data[0]['start_date']) && $data[0]['start_date'] != '') { $start_date = sapp_Global::change_date($data[0]['start_date'], 'view'); $empjobhistoryform->start_date->setValue($start_date); } if (isset($data[0]['end_date']) && $data[0]['end_date'] != '') { $end_date = sapp_Global::change_date($data[0]['end_date'], 'view'); $empjobhistoryform->end_date->setValue($end_date); } } } $empjobhistoryform->setAttrib('action', BASE_URL . 'empjobhistory/editpopup/unitId/' . $userid); $this->view->form = $empjobhistoryform; $this->view->controllername = 'empjobhistory'; if ($this->getRequest()->getPost()) { $result = $this->save($empjobhistoryform, $userid); $this->view->msgarray = $result; } }
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $exParam1 = '', $exParam2 = '', $exParam3 = '', $exParam4 = '') { $searchQuery = ''; $tablecontent = ''; $searchArray = array(); $data = array(); $id = ''; $dataTmp = array(); if ($searchData != '' && $searchData != 'undefined') { $searchValues = json_decode($searchData); foreach ($searchValues as $key => $val) { if ($key == "userfullname") { $searchQuery .= " e." . $key . " like '%" . $val . "%' AND "; } else { if ($key == "rm") { $searchQuery .= " e.userfullname like '%" . $val . "%' AND "; } else { if ($key == "jobtitle_name") { $searchQuery .= " e.jobtitle_name like '%" . $val . "%' AND "; } else { if ($key == 'extn') { $searchQuery .= " concat(e.office_number,' (ext ',e.extension_number,')') like '%" . $val . "%' AND "; } else { if ($key == 'astatus') { $searchQuery .= " e.isactive like '%" . $val . "%' AND "; } else { $searchQuery .= " e." . $key . " like '%" . $val . "%' AND "; } } } } } $searchArray[$key] = $val; } $searchQuery = rtrim($searchQuery, " AND"); } $objName = 'myemployees'; $emptyroles = 0; $tableFields = array('action' => 'Action', 'firstname' => 'First Name', 'lastname' => 'Last Name', 'emailaddress' => 'E-mail', 'employeeId' => 'Employee ID', 'astatus' => 'User Status', 'extn' => ' Work Phone', 'jobtitle_name' => 'Job Title', 'contactnumber' => 'Contact Number'); $employeeModel = new Default_Model_Employee(); $tablecontent = $employeeModel->getEmployeesData($sort, $by, $pageNo, $perPage, $searchQuery, $exParam1, $exParam1); if ($tablecontent == "emptyroles") { $emptyroles = 1; } else { $emptyroles = 0; } $dataTmp = array('dashboardcall' => $dashboardcall, 'emptyroles' => $emptyroles, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'menuName' => 'My Team', 'add' => 'add', 'call' => $call, 'sortStr' => $by, 'context' => 'myteam', 'search_filters' => array('astatus' => array('type' => 'select', 'filter_data' => array('' => 'All', 1 => 'Active', 0 => 'Inactive', 2 => 'Resigned', 3 => 'Left', 4 => 'Suspended')))); return $dataTmp; }
public static function process_emp_excel($file_name) { require_once 'Classes/PHPExcel.php'; require_once 'Classes/PHPExcel/IOFactory.php'; $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $emp_model = new Default_Model_Employee(); $usersModel = new Default_Model_Usermanagement(); $identity_code_model = new Default_Model_Identitycodes(); $objReader = PHPExcel_IOFactory::createReaderForFile($file_name); $objPHPExcel = $objReader->load($file_name); //Read first sheet $sheet = $objPHPExcel->getSheet(0); // Get worksheet dimensions $sizeOfWorksheet = $sheet->getHighestDataRow(); $highestColumn = $sheet->getHighestDataColumn(); if ($sizeOfWorksheet > 1) { $arrReqHeaders = array('Prefix', 'First name', 'Last name', 'Role Type', 'Email', 'Business Unit', 'Department', 'Reporting manager', 'Job Title', 'Position', 'Employment Status', 'Date of joining', 'Date of leaving', 'Experience', 'Extension', 'Work telephone number', 'Fax'); //Get first/header from excel $firstRow = $sheet->rangeToArray('A' . 1 . ':' . $highestColumn . 1, NULL, TRUE, TRUE); $arrGivenHeaders = $firstRow[0]; $diffArray = array_diff_assoc($arrReqHeaders, $arrGivenHeaders); $prefix_arr = $emp_model->getPrefix_emp_excel(); $roles_arr = $emp_model->getRoles_emp_excel(); $bu_arr = $emp_model->getBU_emp_excel(); $dep_arr = $emp_model->getDep_emp_excel(); $job_arr = $emp_model->getJobs_emp_excel(); $positions_arr = $emp_model->getPositions_emp_excel(); $users_arr = $emp_model->getUsers_emp_excel(); $emp_stat_arr = $emp_model->getEstat_emp_excel(); $dol_emp_stat_arr = $emp_model->getDOLEstat_emp_excel(); $mng_roles_arr = $emp_model->getMngRoles_emp_excel(); $emps_arr = $emp_model->getEmps_emp_excel(); $emails_arr = $emps_arr['email']; $emp_ids_arr = $emps_arr['ids']; $emp_depts_arr = $emp_model->getEmpsDeptWise(); $dept_bu_arr = $emp_model->getDeptBUWise(); $pos_jt_arr = $emp_model->getPosJTWise(); $identity_codes = $identity_code_model->getIdentitycodesRecord(); $emp_identity_code = isset($identity_codes[0]) ? $identity_codes[0]['employee_code'] : ""; $trDb = Zend_Db_Table::getDefaultAdapter(); // starting transaction $trDb->beginTransaction(); try { //start of validations $ex_prefix_arr = array(); //$ex_fullname_arr = array(); $ex_firstname_arr = array(); $ex_lastname_arr = array(); $ex_role_arr = array(); $ex_email_arr = array(); $ex_bu_arr = array(); $ex_dep_arr = array(); $ex_rm_arr = array(); $ex_jt_arr = array(); $ex_pos_arr = array(); $ex_es_arr = array(); $ex_doj_arr = array(); $ex_dol_arr = array(); $ex_exp_arr = array(); $ex_ext_arr = array(); $ex_wn_arr = array(); $ex_fax_arr = array(); $tot_rec_cnt = 0; $err_msg = ""; for ($i = 2; $i <= $sizeOfWorksheet; $i++) { $rowData_org = $sheet->rangeToArray('A' . $i . ':' . $highestColumn . $i, NULL, TRUE, TRUE); $rowData = $rowData_org[0]; $rowData_cpy = $rowData; foreach ($rowData_cpy as $rkey => $rvalue) { $rowData[$rkey] = trim($rvalue); } //start of mandatory checking if (empty($rowData[0])) { $err_msg = "Prefix cannot be empty at row " . $i . "."; break; } /* if(empty($rowData[1])) { $err_msg = "Full Name cannot be empty at row ".$i."."; break; }*/ if (empty($rowData[1])) { $err_msg = "First name cannot be empty at row " . $i . "."; break; } if (empty($rowData[2])) { $err_msg = "Last name cannot be empty at row " . $i . "."; break; } if (empty($rowData[3])) { $err_msg = "Role type cannot be empty at row " . $i . "."; break; } if (empty($rowData[4])) { $err_msg = "Email cannot be empty at row " . $i . "."; break; } if (empty($rowData[7])) { $err_msg = "Reporting manager cannot be empty at row " . $i . "."; break; } if (empty($rowData[8])) { $err_msg = "Job title cannot be empty at row " . $i . "."; break; } if (empty($rowData[9])) { $err_msg = "Position cannot be empty at row " . $i . "."; break; } if (empty($rowData[10])) { $err_msg = "Employment status cannot be empty at row " . $i . "."; break; } if (empty($rowData[11])) { $err_msg = "Date of joining cannot be empty at row " . $i . "."; break; } if (!in_array($rowData[3], $mng_roles_arr) && empty($rowData[6])) { $err_msg = "Department cannot be empty at row " . $i . "."; break; } if (in_array($rowData[10], $dol_emp_stat_arr) && empty($rowData[12])) { $err_msg = "Date of leaving cannot be empty at row " . $i . "."; break; } if (!in_array($rowData[10], $dol_emp_stat_arr) && !empty($rowData[12]) && in_array($rowData[10], $emp_stat_arr)) { $err_msg = "Date of leaving must be empty for '" . $rowData[10] . "' at row " . $i . "."; break; } // end of mandatory checking // start of pattern checking if (!preg_match("/^(?=.*[a-zA-Z])([^ ][a-zA-Z0-9 ]*)\$/", trim($rowData[0])) && !empty($rowData[0])) { $err_msg = "Prefix is not a valid format at row " . $i . "."; break; } /* if (!preg_match("/^([a-zA-Z.]+ ?)+$/", $rowData[1]) && !empty($rowData[1])) { $err_msg = "Full Name is not a valid format at row ".$i."."; break; }*/ if (!preg_match("/^([a-zA-Z.]+ ?)+\$/", $rowData[1]) && !empty($rowData[1])) { $err_msg = "First name is not a valid format at row " . $i . "."; break; } if (!preg_match("/^([a-zA-Z.]+ ?)+\$/", $rowData[2]) && !empty($rowData[2])) { $err_msg = "Last name is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[a-zA-Z]+?\$/", $rowData[3]) && !empty($rowData[3])) { $err_msg = "Role type is not a valid format at row " . $i . "."; break; } if (!preg_match("/^(?!.*\\.{2})[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\\.[a-zA-Z0-9-.]+\$/", $rowData[4]) && !empty($rowData[4])) { $err_msg = "Email is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[a-zA-Z0-9\\&\\'\\.\\s]+\$/", $rowData[5]) && !empty($rowData[5])) { $err_msg = "Business unit is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[a-zA-Z0-9\\&\\'\\.\\s]+\$/", $rowData[6]) && !empty($rowData[6])) { $err_msg = "Department is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[a-zA-Z0-9\\&\\'\\.\\s]+\$/", $rowData[7]) && !empty($rowData[7])) { $err_msg = "Reporting manager is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[a-zA-Z][a-zA-Z0-9\\s]*\$/", $rowData[8]) && !empty($rowData[8])) { $err_msg = "Job title is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[a-zA-Z][a-zA-Z0-9\\-\\s]*\$/i", $rowData[9]) && !empty($rowData[9])) { $err_msg = "Position is not a valid format at row " . $i . "."; break; } if (!preg_match("/^(?=.*[a-zA-Z])([^ ][a-zA-Z0-9 ]*)\$/", $rowData[10]) && !empty($rowData[10])) { $err_msg = "Employment status is not a valid format at row " . $i . "."; break; } if (!empty($rowData[11])) { try { $test_doj = new DateTime($rowData[11]); } catch (Exception $ex) { return array('status' => 'error', 'msg' => "Date of joining is not a valid format at row " . $i . "."); } } if (!empty($rowData[12])) { try { $test_dol = new DateTime($rowData[12]); } catch (Exception $ex) { return array('status' => 'error', 'msg' => "Date of leaving is not a valid format at row " . $i . "."); } } if (!empty($rowData[12]) && $rowData[12] < $rowData[11]) { $err_msg = "Date of leaving must be greater than date of joining at row " . $i . "."; break; } if (!preg_match("/^[0-9]\\d{0,1}(\\.\\d*)?\$/", $rowData[13]) && !empty($rowData[13])) { $err_msg = "Experience is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[0-9]+\$/", $rowData[14]) && !empty($rowData[14])) { $err_msg = "Extension is not a valid format at row " . $i . "."; break; } if (!preg_match("/^(?!0{10})[0-9\\+\\-\\)\\(]+\$/", $rowData[15]) && !empty($rowData[15])) { $err_msg = "Work telephone number is not a valid format at row " . $i . "."; break; } if (!preg_match("/^[0-9\\+\\-\\)\\(]+\$/", $rowData[16]) && !empty($rowData[16])) { $err_msg = "Fax is not a valid format at row " . $i . "."; break; } // end of pattern checking // start of checking existence in the system. if (!array_key_exists(strtolower($rowData[0]), $prefix_arr) && !empty($rowData[0])) { $err_msg = "Unknown prefix at row " . $i . "."; break; } if (!array_key_exists(strtolower($rowData[3]), $roles_arr) && !empty($rowData[3])) { $err_msg = "Unknown role type at row " . $i . "."; break; } if (!array_key_exists(strtolower($rowData[5]), $bu_arr) && !empty($rowData[5])) { $err_msg = "Unknown business unit at row " . $i . "."; break; } if (!array_key_exists(strtolower($rowData[6]), $dep_arr) && !empty($rowData[6])) { $err_msg = "Unknown department at row " . $i . "."; break; } if (in_array(strtolower($rowData[4]), $emails_arr) && !empty($rowData[4])) { $err_msg = "Email already exists at row " . $i . "."; break; } if (!in_array(strtolower($rowData[7]), $emp_ids_arr) && !empty($rowData[7])) { $err_msg = "Unknown reporting manager at row " . $i . "."; break; } if (!array_key_exists(strtolower($rowData[8]), $job_arr) && !empty($rowData[8])) { $err_msg = "Unknown job title at row " . $i . "."; break; } if (!array_key_exists(strtolower($rowData[9]), $positions_arr) && !empty($rowData[9])) { $err_msg = "Unknown position at row " . $i . "."; break; } if (!array_key_exists(strtolower($rowData[10]), $emp_stat_arr) && !empty($rowData[10])) { $err_msg = "Unknown employment status at row " . $i . "."; break; } // end of checking existence in the system. if (!empty($rowData[6])) { if (isset($emp_depts_arr[$dep_arr[strtolower($rowData[6])]]) && !in_array(strtolower($rowData[7]), $emp_depts_arr[$dep_arr[strtolower($rowData[6])]])) { if (isset($emp_depts_arr[0]) && is_array($emp_depts_arr[0])) { if (!in_array(strtolower($rowData[7]), $emp_depts_arr[0])) { $err_msg = "Reporting manager is not belongs to '" . $rowData[6] . "' department at row " . $i . "."; break; } } } } else { if (isset($emp_depts_arr[0]) && is_array($emp_depts_arr[0])) { if (!in_array(strtolower($rowData[7]), $emp_depts_arr[0])) { $err_msg = "Reporting manager is not belongs to management group at row " . $i . "."; break; } } } if (!empty($rowData[6])) { if (isset($dept_bu_arr[0]) && is_array($dept_bu_arr[0])) { if (in_array(strtolower($rowData[6]), $dept_bu_arr[0]) && !empty($rowData[5])) { $err_msg = "Business unit not needed for this department '" . $rowData[6] . "' at row " . $i . "."; break; } if (!in_array(strtolower($rowData[6]), $dept_bu_arr[0]) && empty($rowData[5])) { $err_msg = "Business unit cannot be empty at row " . $i . "."; break; } } if (!empty($rowData[5])) { if (isset($dept_bu_arr[$bu_arr[strtolower($rowData[5])]]) && !in_array(strtolower($rowData[6]), $dept_bu_arr[$bu_arr[strtolower($rowData[5])]]) && !empty($rowData[5])) { $err_msg = "Department is not belongs to '" . $rowData[5] . "' business unit at row " . $i . "."; break; } } } if (!empty($rowData[8]) && !empty($rowData[9])) { if (isset($pos_jt_arr[$job_arr[strtolower($rowData[8])]]) && !in_array(strtolower($rowData[9]), $pos_jt_arr[$job_arr[strtolower($rowData[8])]]) && !empty($rowData[8])) { $err_msg = "Position is not belongs to '" . $rowData[8] . "' job title at row " . $i . "."; break; } } } //end of for loop if (!empty($err_msg)) { return array('status' => 'error', 'msg' => $err_msg); } $err_msg = ""; for ($i = 2; $i <= $sizeOfWorksheet; $i++) { $rowData_org = $sheet->rangeToArray('A' . $i . ':' . $highestColumn . $i, NULL, TRUE, TRUE); $rowData = $rowData_org[0]; $rowData_cpy = $rowData; foreach ($rowData_cpy as $rkey => $rvalue) { $rowData[$rkey] = trim($rvalue); } $ex_prefix_arr[] = $rowData[0]; //$ex_fullname_arr[] = $rowData[1]; $ex_firstname_arr[] = $rowData[1]; $ex_lastname_arr[] = $rowData[2]; $ex_role_arr[] = $rowData[3]; $ex_email_arr[$i] = $rowData[4]; $ex_bu_arr[] = $rowData[5]; $ex_dep_arr[] = $rowData[6]; $ex_rm_arr[] = $rowData[7]; $ex_jt_arr[] = $rowData[8]; $ex_pos_arr[] = $rowData[9]; $ex_es_arr[] = $rowData[10]; $ex_doj_arr[] = $rowData[11]; $ex_dol_arr[] = $rowData[12]; $ex_exp_arr[] = $rowData[13]; $ex_ext_arr[] = $rowData[14]; $ex_wn_arr[] = $rowData[15]; $ex_fax_arr[] = $rowData[16]; $tot_rec_cnt++; } foreach ($ex_email_arr as $key1 => $value1) { $d = 0; foreach ($ex_email_arr as $key2 => $value2) { if ($key1 != $key2 && $value1 == $value2) { $err_msg = "Duplicate email entry at row " . $key2 . "."; $d++; break; } } if ($d > 0) { break; } } if (!empty($err_msg)) { return array('status' => 'error', 'msg' => $err_msg); } //end of validations //start of saving if ($tot_rec_cnt > 0) { for ($i = 2; $i <= $sizeOfWorksheet; $i++) { $emp_id = $emp_identity_code . str_pad($usersModel->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT); $rowData_org = $sheet->rangeToArray('A' . $i . ':' . $highestColumn . $i, NULL, TRUE, TRUE); $rowData = $rowData_org[0]; $rowData_cpy = $rowData; foreach ($rowData_cpy as $rkey => $rvalue) { $rowData[$rkey] = trim($rvalue); } $emppassword = sapp_Global::generatePassword(); $date = new DateTime($rowData[11]); $date_of_joining = $date->format('Y-m-d'); $date_of_leaving = ""; if ($rowData[12] != '') { $ldate = new DateTime($rowData[12]); $date_of_leaving = $ldate->format('Y-m-d'); } $userfullname = $rowData[1] . ' ' . $rowData[2]; $user_data = array('emprole' => $roles_arr[strtolower($rowData[3])], 'userfullname' => $userfullname, 'firstname' => $rowData[1], 'lastname' => $rowData[2], 'emailaddress' => $rowData[4], 'jobtitle_id' => $job_arr[strtolower($rowData[8])], 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'emppassword' => md5($emppassword), 'employeeId' => $emp_id, 'modeofentry' => "Direct", 'selecteddate' => $date_of_joining, 'userstatus' => 'old'); $user_data['createdby'] = $loginUserId; $user_data['createddate'] = gmdate("Y-m-d H:i:s"); $user_data['isactive'] = 1; $user_id = $usersModel->SaveorUpdateUserData($user_data, ''); $data = array('user_id' => $user_id, 'reporting_manager' => $users_arr[strtolower($rowData[7])], 'emp_status_id' => $emp_stat_arr[strtolower($rowData[10])], 'businessunit_id' => !empty($rowData[4]) ? $bu_arr[strtolower($rowData[5])] : 0, 'department_id' => !empty($rowData[5]) ? $dep_arr[strtolower($rowData[6])] : null, 'jobtitle_id' => $job_arr[strtolower($rowData[8])], 'position_id' => $positions_arr[strtolower($rowData[9])], 'prefix_id' => $prefix_arr[strtolower($rowData[0])], 'extension_number' => $rowData[13] != '' ? $rowData[14] : NULL, 'office_number' => $rowData[14] != '' ? $rowData[15] : NULL, 'office_faxnumber' => $rowData[15] != '' ? $rowData[16] : NULL, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'years_exp' => $rowData[13] == '' ? null : $rowData[13], 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $emp_model->SaveorUpdateEmployeeData($data, ''); $text = "<div style='padding: 0; text-align: left; font-size:14px; font-family:Arial, Helvetica, sans-serif;'>\t\t\t\t\n\t<span style='color:#3b3b3b;'>Hello " . ucfirst($userfullname) . ",</span><br />\n\t\n\t<div style='padding:20px 0 0 0;color:#3b3b3b;'>You have been added to " . APPLICATION_NAME . ". The login credentials for your Sentrifugo account are:</div>\n\t\n\t<div style='padding:20px 0 0 0;color:#3b3b3b;'>Username: <strong>" . $emp_id . "</strong></div>\n\t<div style='padding:5px 0 0 0;color:#3b3b3b;'>Password: <strong>" . $emppassword . "</strong></div>\n\t\n\t<div style='padding:20px 0 10px 0;'>Please <a href='" . DOMAIN . "index/popup' target='_blank' style='color:#b3512f;'>click here</a> to login to your Sentrifugo account.</div>\n\n</div>"; $options['subject'] = APPLICATION_NAME . ': Login Credentials'; $options['header'] = 'Greetings from Sentrifugo'; $options['toEmail'] = $rowData[4]; $options['toName'] = $userfullname; $options['message'] = $text; $options['cron'] = 'yes'; $result = sapp_Global::_sendEmail($options); } //end of for loop $trDb->commit(); return array('status' => "success", 'msg' => 'Employees saved successfully.'); } else { return array('status' => 'error', 'msg' => "No records to save."); } //end of saving } catch (Exception $e) { $trDb->rollBack(); return array('status' => 'error', 'msg' => "Something went wrong,please try again."); } } else { return array('status' => 'error', 'msg' => "No records to save."); } }
public function viewAction() { if (defined('EMPTABCONFIGS')) { $empOrganizationTabs = explode(",", EMPTABCONFIGS); if (in_array('employeedocs', $empOrganizationTabs)) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('userid'); try { if ($id && is_numeric($id) && $id > 0 && $id != $loginUserId) { $employeeModal = new Default_Model_Employee(); $empdata = $employeeModal->getActiveEmployeeData($id); if (!empty($empdata)) { $empDocuModel = new Default_Model_Employeedocs(); $empDocuments = $empDocuModel->getEmpDocumentsByFieldOrAll('user_id', $id); $this->view->empDocuments = $empDocuments; } $usersModel = new Default_Model_Users(); $employeeData = $usersModel->getUserDetailsByIDandFlag($id); if (!empty($employeeData)) { $this->view->employeedata = $employeeData[0]; } $this->view->id = $id; $this->view->empdata = $empdata; } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } } else { $this->_redirect('error'); } } else { $this->_redirect('error'); } }
public function editAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->getRequest()->getParam('id'); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $appraisalinitform = new Default_Form_Appraisalinit(); $appraisalinitform->submit->setLabel('Update'); try { if ($id) { if (is_numeric($id) && $id > 0) { $appraisalinitmodel = new Default_Model_Appraisalinit(); $data = $appraisalinitmodel->getConfigData($id); if (!empty($data)) { $empSummaryModel = new Default_Model_Employee(); $empData = $empSummaryModel->getEmp_from_summary($loginUserId); $appraisalinitform->businessunit_name->setValue($empData['businessunit_name']); $appraisalinitform->department_name->setValue($empData['department_name']); $employmentstatusModel = new Default_Model_Employmentstatus(); $employmentStatusData = $employmentstatusModel->getempstatusActivelist(); if (!empty($employmentStatusData)) { foreach ($employmentStatusData as $employmentStatusres) { $appraisalinitform->eligibility->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']); } } $data = $data[0]; $appraisalinitform->populate($data); $appraisalinitform->setAttrib('action', DOMAIN . 'appraisalinit/edit/id/' . $id); $this->view->data = $data; } else { $this->view->ermsg = 'norecord'; } } else { $this->view->ermsg = 'norecord'; } } else { $this->view->ermsg = ''; } } catch (Exception $e) { $this->view->ermsg = 'nodata'; } $this->view->eligibility_value = $data['eligibility']; $this->view->form = $appraisalinitform; if ($this->getRequest()->getPost()) { $result = $this->save($appraisalinitform); $this->view->msgarray = $result; } $this->render('form'); }