/**
*
* Show analytics of employees reporting to manager
*/
public function employeereportAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
if ($loginuserGroup == MANAGER_GROUP || $loginuserGroup == MANAGEMENT_GROUP || $loginuserRole == SUPERADMINROLE) {
$norec_arr = array();
$form = new Default_Form_Employeereport();
$requi_model = new Default_Model_Requisition();
$employmentstatusModel = new Default_Model_Employmentstatus();
$role_model = new Default_Model_Roles();
$departmentsmodel = new Default_Model_Departments();
$bu_model = new Default_Model_Businessunits();
$roles_arr = $role_model->getRolesList_EMP();
$job_data = $requi_model->getJobTitleList();
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (count($job_data) == 0) {
$norec_arr['jobtitle_id'] = "Job titles are not configured yet.";
$norec_arr['position_id'] = "Positions are not configured yet.";
}
if (count($employmentStatusData) == 0) {
$norec_arr['emp_status_id'] = "Employment status is not configured yet.";
}
$form->jobtitle_id->addMultiOptions(array('' => 'Select Job Title') + $job_data);
if (count($employmentStatusData) > 0) {
$form->emp_status_id->addMultiOption('', 'Select Employment Status');
foreach ($employmentStatusData as $employmentStatusres) {
$form->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
if (sizeof($roles_arr) > 0) {
$form->emprole->addMultiOptions(array('' => 'Select Role') + $roles_arr);
} else {
$norec_arr['emprole'] = 'Roles are not added yet.';
}
$bu_arr = $bu_model->getBU_report();
if (!empty($bu_arr)) {
foreach ($bu_arr as $bu) {
$form->businessunit_id->addMultiOption($bu['id'], utf8_encode($bu['bu_name']));
}
} else {
$norec_arr['businessunit_id'] = 'Business Units are not added yet.';
}
// 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();
//$this->_helper->layout->setLayout("analyticslayout");
$this->view->count_emp_reporting = $employee_model->getCountEmpReporting($myEmployees_model->getLoginUserId());
$this->view->form = $form;
$this->view->messages = $norec_arr;
$this->view->ermsg = '';
} else {
$this->render('error/error.phtml');
}
}
public function indexAction()
{
$editPrivilege = "";
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $loginUserId;
$data = array();
$tabName = "employee";
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$employeeform = new Default_Form_employee();
try {
if ($id != '' && $id > 0) {
$employeeModal = new Default_Model_Employee();
$usersModel = new Default_Model_Users();
$employmentstatusModel = new Default_Model_Employmentstatus();
$busineesUnitModel = new Default_Model_Businessunits();
$deptModel = new Default_Model_Departments();
$role_model = new Default_Model_Roles();
$user_model = new Default_Model_Usermanagement();
$candidate_model = new Default_Model_Candidatedetails();
$jobtitlesModel = new Default_Model_Jobtitles();
$positionsmodel = new Default_Model_Positions();
$prefix_model = new Default_Model_Prefix();
$data = $employeeModal->getsingleEmployeeData($id);
if ($data == 'norows') {
$this->view->rowexist = "norows";
$this->view->empdata = "";
} else {
if (!empty($data)) {
$this->view->rowexist = "rows";
$this->view->empdata = $data;
$elements = $employeeform->getElements();
if (count($elements) > 0) {
foreach ($elements as $key => $element) {
if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") {
$element->setAttrib("disabled", "disabled");
}
}
}
$employeeform->removeElement("submit");
$data = $data[0];
if ($loginUserId == SUPERADMIN) {
//If login user is superAdmin..... role is 'Super Admin'.
$employeeform->emprole->addMultiOption('superAdmin', 'Super Admin');
} else {
$roles_arr = $role_model->getRolesDataByID($data['emprole']);
if (sizeof($roles_arr) > 0) {
$employeeform->emprole->addMultiOption($roles_arr[0]['id'] . '_' . $roles_arr[0]['group_id'], utf8_encode($roles_arr[0]['rolename']));
}
}
$prefix_data = $prefix_model->getsinglePrefixData($data['prefix_id']);
if ($prefix_data != 'norows') {
$prefix_data = $prefix_data[0];
$employeeform->prefix_id->addMultiOption($prefix_data['id'], $prefix_data['prefix']);
}
$referedby_options = $user_model->getRefferedByForUsers();
/* Code for reporting manager dropdown */
$reportingManagerData = $usersModel->getUserDetailsByID($data['reporting_manager']);
if (!empty($reportingManagerData)) {
$employeeform->reporting_manager->addMultiOption($reportingManagerData[0]['id'], $reportingManagerData[0]['userfullname']);
}
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (sizeof($employmentStatusData) > 0) {
$employeeform->emp_status_id->addMultiOption('', 'Select a Employment Status');
foreach ($employmentStatusData as $employmentStatusres) {
$employeeform->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
$businessunitData = $busineesUnitModel->getDeparmentList();
if (sizeof($businessunitData) > 0) {
$employeeform->businessunit_id->addMultiOption('0', 'No Business Unit');
foreach ($businessunitData as $businessunitres) {
$employeeform->businessunit_id->addMultiOption($businessunitres['id'], $businessunitres['unitname']);
}
}
$departmentsData = $deptModel->getDepartmentList($data['businessunit_id']);
if (sizeof($departmentsData) > 0) {
$employeeform->department_id->addMultiOption('', 'Select a Department');
foreach ($departmentsData as $departmentsres) {
$employeeform->department_id->addMultiOption($departmentsres['id'], $departmentsres['deptname']);
}
}
$jobtitleData = $jobtitlesModel->getJobTitleList();
if (sizeof($jobtitleData) > 0) {
$employeeform->jobtitle_id->addMultiOption('', 'Select a Job Title');
foreach ($jobtitleData as $jobtitleres) {
$employeeform->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
}
$positionlistArr = $positionsmodel->getPositionList($data['jobtitle_id']);
if (sizeof($positionlistArr) > 0) {
$employeeform->position_id->addMultiOption('', 'Select a Position');
foreach ($positionlistArr as $positionlistres) {
$employeeform->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']);
}
}
$employeeform->populate($data);
$employeeform->setDefault('user_id', $data['user_id']);
$employeeform->setDefault('emp_status_id', $data['emp_status_id']);
$employeeform->setDefault('businessunit_id', $data['businessunit_id']);
$employeeform->setDefault('jobtitle_id', $data['jobtitle_id']);
$employeeform->setDefault('department_id', $data['department_id']);
$employeeform->setDefault('position_id', $data['position_id']);
if ($data['date_of_joining'] != '' && $data['date_of_joining'] != '0000-00-00') {
$date_of_joining = sapp_Global::change_date($data['date_of_joining'], 'view');
$employeeform->date_of_joining->setValue($date_of_joining);
}
if ($data['date_of_leaving'] != '' && $data['date_of_leaving'] != '0000-00-00') {
$date_of_leaving = sapp_Global::change_date($data['date_of_leaving'], 'view');
$employeeform->date_of_leaving->setValue($date_of_leaving);
}
if ($data['modeofentry'] != 'Direct') {
$employeeform->rccandidatename->setValue($data['userfullname']);
}
if (sizeof($referedby_options) > 0 && $data['candidatereferredby'] != '' && $data['candidatereferredby'] != 0) {
$employeeform->candidatereferredby->setValue($referedby_options[$data['candidatereferredby']]);
}
$employeeform->setAttrib('action', DOMAIN . 'mydetails/edit/');
$this->view->id = $id;
$this->view->form = $employeeform;
$this->view->employeedata = !empty($data) ? $data : "";
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->view->empdata = $data;
$this->view->editPrivilege = $this->mydetailsobjPrivileges;
}
}
} else {
$this->view->rowexist = "norows";
}
} catch (Exception $e) {
$this->view->rowexist = "norows";
}
if ($this->getRequest()->getPost()) {
$result = $this->save($employeeform, $tabName);
$this->view->msgarray = $result;
}
}
public function editAction()
{
$auth = Zend_Auth::getInstance();
$role_datap = array();
$empGroup = "";
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$loginuserUnitID = $auth->getStorage()->read()->businessunit_id;
$loginuserDeptID = $auth->getStorage()->read()->department_id;
}
$id = (int) $this->getRequest()->getParam('id');
$id = abs($id);
if ($id == '') {
$id = $loginUserId;
}
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$employeeform = new Default_Form_Myteamemployee();
try {
if ($id != '' && is_numeric($id) && $id > 0 && $id != $loginUserId) {
$employeeModal = new Default_Model_Employee();
$usersModel = new Default_Model_Users();
$employmentstatusModel = new Default_Model_Employmentstatus();
$busineesUnitModel = new Default_Model_Businessunits();
$deptModel = new Default_Model_Departments();
$role_model = new Default_Model_Roles();
$user_model = new Default_Model_Usermanagement();
$candidate_model = new Default_Model_Candidatedetails();
$jobtitlesModel = new Default_Model_Jobtitles();
$positionsmodel = new Default_Model_Positions();
$prefixModel = new Default_Model_Prefix();
$data = array();
$empDeptId = "";
$empRoleId = "";
$data = $employeeModal->getsingleEmployeeData($id);
if ($data == 'norows') {
$this->view->rowexist = "norows";
} else {
if (!empty($data)) {
$this->view->rowexist = "rows";
$employeeform->submit->setLabel('Update');
$data = $data[0];
/* Earlier code to fetch employee details */
$employeeData = $employeeModal->getsingleEmployeeData($id);
$roles_arr = $role_model->getRolesListByGroupID(EMPLOYEE_GROUP);
if (sizeof($roles_arr) > 0) {
$employeeform->emprole->addMultiOptions(array('' => 'Select Role') + $roles_arr);
}
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (sizeof($employmentStatusData) > 0) {
$employeeform->emp_status_id->addMultiOption('', 'Select Employment Status');
foreach ($employmentStatusData as $employmentStatusres) {
$employeeform->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
$businessunitData = $busineesUnitModel->getDeparmentList();
if (sizeof($businessunitData) > 0) {
foreach ($businessunitData as $businessunitres) {
if ($businessunitres['id'] == $loginuserUnitID) {
$employeeform->businessunit_id->addMultiOption($businessunitres['id'], $businessunitres['unitname']);
}
}
}
$departmentsData = $deptModel->getDepartmentList($data['businessunit_id']);
if (sizeof($departmentsData) > 0) {
foreach ($departmentsData as $departmentsres) {
if ($departmentsres['id'] == $loginuserDeptID) {
$employeeform->department_id->addMultiOption($departmentsres['id'], $departmentsres['deptname']);
}
}
}
$jobtitleData = $jobtitlesModel->getJobTitleList();
if (sizeof($jobtitleData) > 0) {
$employeeform->jobtitle_id->addMultiOption('', 'Select Job Title');
foreach ($jobtitleData as $jobtitleres) {
$employeeform->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
}
$positionlistArr = $positionsmodel->getPositionList($data['jobtitle_id']);
if (sizeof($positionlistArr) > 0) {
$employeeform->position_id->addMultiOption('', 'Select Position');
foreach ($positionlistArr as $positionlistres) {
$employeeform->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']);
}
}
$prefixData = $prefixModel->getPrefixList();
if (!empty($prefixData)) {
foreach ($prefixData as $prefixres) {
$employeeform->prefix_id->addMultiOption($prefixres['id'], $prefixres['prefix']);
}
}
$userData = $usersModel->getUserDetails($loginUserId);
if (count($userData) > 0) {
$employeeform->reporting_manager->addMultiOption($userData[0]['id'], $userData[0]['userfullname']);
}
$employeeform->populate($data);
$employeeform->setDefault('user_id', $data['user_id']);
$employeeform->setDefault('emp_status_id', $data['emp_status_id']);
$employeeform->setDefault('businessunit_id', $data['businessunit_id']);
$employeeform->setDefault('jobtitle_id', $data['jobtitle_id']);
$employeeform->setDefault('department_id', $data['department_id']);
$employeeform->setDefault('position_id', $data['position_id']);
$employeeform->setDefault('prefix_id', $data['prefix_id']);
$date_of_joining = sapp_Global::change_date($data['date_of_joining'], 'view');
$employeeform->date_of_joining->setValue($date_of_joining);
if ($data['date_of_leaving'] != '' && $data['date_of_leaving'] != '0000-00-00') {
$date_of_leaving = sapp_Global::change_date($data['date_of_leaving'], 'view');
$employeeform->date_of_leaving->setValue($date_of_leaving);
}
$role_data = $role_model->getRoleDataById($data['emprole']);
$employeeform->emprole->setValue($data['emprole'] . "_" . $role_data['group_id']);
$employeeform->setAttrib('action', DOMAIN . 'myemployees/edit/id/' . $id);
$this->view->id = $id;
$this->view->form = $employeeform;
$this->view->employeedata = !empty($employeeData) ? $employeeData[0] : "";
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->view->data = $data;
}
}
} else {
$this->view->rowexist = "norows";
}
if ($this->getRequest()->getPost()) {
$result = $this->save($employeeform);
$this->view->msgarray = $result;
$employeeform->modeofentry->setValue($data['modeofentry']);
}
} catch (Exception $e) {
$this->view->rowexist = "norows";
}
}
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $exParam1 = '', $exParam2 = '', $exParam3 = '', $exParam4 = '')
{
$searchQuery = '';
$tablecontent = '';
$emptyroles = 0;
$empstatus_opt = array();
$searchArray = array();
$data = array();
$id = '';
$dataTmp = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'astatus') {
$searchQuery .= " e.isactive like '%" . $val . "%' AND ";
} else {
if ($key == 'extn') {
$searchQuery .= " concat(e.office_number,' (ext ',e.extension_number,')') like '%" . $val . "%' AND ";
} else {
$searchQuery .= $key . " like '%" . $val . "%' AND ";
}
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
$objName = 'employee';
$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', 'reporting_manager_name' => 'Reporting Manager', 'contactnumber' => 'Contact Number', 'emp_status_name' => 'Employment Status', 'emprole_name' => "Role");
$tablecontent = $this->getEmployeesData($sort, $by, $pageNo, $perPage, $searchQuery, '', $exParam1);
if ($tablecontent == "emptyroles") {
$emptyroles = 1;
} else {
$employmentstatusModel = new Default_Model_Employmentstatus();
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (count($employmentStatusData) > 0) {
foreach ($employmentStatusData as $empsdata) {
$empstatus_opt[$empsdata['workcodename']] = $empsdata['statusname'];
}
}
}
$dataTmp = array('userid' => $id, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'menuName' => 'Employees', 'dashboardcall' => $dashboardcall, 'add' => 'add', 'call' => $call, 'search_filters' => array('astatus' => array('type' => 'select', 'filter_data' => array('' => 'All', 1 => 'Active', 0 => 'Inactive')), 'emp_status_id' => array('type' => 'select', 'filter_data' => array('' => 'All') + $empstatus_opt)), 'emptyroles' => $emptyroles);
return $dataTmp;
}
public function viewAction()
{
$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();
}
$objName = 'employee';
$employeeform = new Default_Form_employee();
$employeeform->removeElement("submit");
$elements = $employeeform->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();
$usersModel = new Default_Model_Users();
$employmentstatusModel = new Default_Model_Employmentstatus();
$busineesUnitModel = new Default_Model_Businessunits();
$deptModel = new Default_Model_Departments();
$role_model = new Default_Model_Roles();
$user_model = new Default_Model_Usermanagement();
$candidate_model = new Default_Model_Candidatedetails();
$jobtitlesModel = new Default_Model_Jobtitles();
$positionsmodel = new Default_Model_Positions();
$prefixModel = new Default_Model_Prefix();
$data = array();
$data = $employeeModal->getsingleEmployeeData($id);
if ($data == 'norows') {
$this->view->rowexist = "norows";
} else {
if (!empty($data)) {
$this->view->rowexist = "rows";
$data = $data[0];
$employeeData = $usersModel->getUserDetailsByIDandFlag($data['user_id']);
$roles_arr = $role_model->getRolesDataByID($data['emprole']);
if (sizeof($roles_arr) > 0) {
$employeeform->emprole->addMultiOption($roles_arr[0]['id'] . '_' . $roles_arr[0]['group_id'], utf8_encode($roles_arr[0]['rolename']));
}
$referedby_options = $user_model->getRefferedByForUsers();
$reportingManagerData = $usersModel->getReportingManagerList_employees($data['department_id'], $data['id'], $roles_arr[0]['group_id']);
if (!empty($reportingManagerData)) {
$employeeform->reporting_manager->addMultiOption('', 'Select Reporting Manager');
foreach ($reportingManagerData as $reportingManagerres) {
$employeeform->reporting_manager->addMultiOption($reportingManagerres['id'], $reportingManagerres['name']);
}
}
$employeeform->setDefault('reporting_manager', $data['reporting_manager']);
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (sizeof($employmentStatusData) > 0) {
$employeeform->emp_status_id->addMultiOption('', 'Select Employment Status');
foreach ($employmentStatusData as $employmentStatusres) {
$employeeform->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
$businessunitData = $busineesUnitModel->getDeparmentList();
if (sizeof($businessunitData) > 0) {
$employeeform->businessunit_id->addMultiOption('0', 'No Business Unit');
foreach ($businessunitData as $businessunitres) {
$employeeform->businessunit_id->addMultiOption($businessunitres['id'], $businessunitres['unitname']);
}
}
$departmentsData = $deptModel->getDepartmentList($data['businessunit_id']);
if (sizeof($departmentsData) > 0) {
$employeeform->department_id->addMultiOption('', 'Select Department');
foreach ($departmentsData as $departmentsres) {
$employeeform->department_id->addMultiOption($departmentsres['id'], $departmentsres['deptname']);
}
}
$jobtitleData = $jobtitlesModel->getJobTitleList();
if (sizeof($jobtitleData) > 0) {
$employeeform->jobtitle_id->addMultiOption('', 'Select Job Title');
foreach ($jobtitleData as $jobtitleres) {
$employeeform->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
}
$positionlistArr = $positionsmodel->getPositionList($data['jobtitle_id']);
if (sizeof($positionlistArr) > 0) {
$employeeform->position_id->addMultiOption('', 'Select a Position');
foreach ($positionlistArr as $positionlistres) {
$employeeform->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']);
}
}
if (isset($data['prefix_id']) && $data['prefix_id'] != '') {
$singlePrefixArr = $prefixModel->getsinglePrefixData($data['prefix_id']);
if ($singlePrefixArr != 'norows') {
$employeeform->prefix_id->addMultiOption($singlePrefixArr[0]['id'], $singlePrefixArr[0]['prefix']);
}
}
$employeeform->populate($data);
$employeeform->setDefault('user_id', $data['user_id']);
$employeeform->setDefault('emp_status_id', $data['emp_status_id']);
$employeeform->setDefault('businessunit_id', $data['businessunit_id']);
$employeeform->setDefault('jobtitle_id', $data['jobtitle_id']);
$employeeform->setDefault('department_id', $data['department_id']);
$employeeform->setDefault('position_id', $data['position_id']);
$date_of_joining = sapp_Global::change_date($data['date_of_joining'], 'view');
$employeeform->date_of_joining->setValue($date_of_joining);
if ($data['date_of_leaving'] != '' && $data['date_of_leaving'] != '0000-00-00') {
$date_of_leaving = sapp_Global::change_date($data['date_of_leaving'], 'view');
$employeeform->date_of_leaving->setValue($date_of_leaving);
}
if ($data['modeofentry'] != 'Direct') {
$employeeform->rccandidatename->setValue($data['userfullname']);
}
if (sizeof($referedby_options) > 0 && $data['candidatereferredby'] != '' && $data['candidatereferredby'] != 0) {
$employeeform->candidatereferredby->setValue($referedby_options[$data['candidatereferredby']]);
}
if ($data['rccandidatename'] != '' && $data['rccandidatename'] != 0) {
$cand_data = $candidate_model->getCandidateById($data['rccandidatename']);
$data['requisition_code'] = $cand_data['requisition_code'];
}
$employeeform->setAttrib('action', BASE_URL . 'employee/edit/id/' . $id);
$this->view->id = $id;
$this->view->form = $employeeform;
$this->view->employeedata = !empty($employeeData) ? $employeeData[0] : "";
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->view->data = $data;
$this->view->controllername = $objName;
$this->view->id = $id;
}
}
} else {
$this->view->rowexist = "norows";
}
} catch (Exception $e) {
$this->view->rowexist = "norows";
}
}
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $exParam1 = '', $exParam2 = '', $exParam3 = '', $exParam4 = '')
{
$searchQuery = '';
$tablecontent = '';
$emptyroles = 0;
$empstatus_opt = array();
$searchArray = array();
$data = array();
$id = '';
$dataTmp = array();
$auth = Zend_Auth::getInstance();
$request = Zend_Controller_Front::getInstance();
if ($auth->hasIdentity()) {
$loginUserGroup = $auth->getStorage()->read()->group_id;
$loginUserRole = $auth->getStorage()->read()->emprole;
}
$controllerName = $request->getRequest()->getControllerName();
if ($controllerName == 'employee' && ($loginUserRole == SUPERADMINROLE || $loginUserGroup == HR_GROUP || $loginUserGroup == MANAGEMENT_GROUP)) {
$filterArray = array('' => 'All', 1 => 'Active', 0 => 'Inactive', 2 => 'Resigned', 3 => 'Left', 4 => 'Suspended');
} else {
$filterArray = array('' => 'All', 1 => 'Active');
}
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == 'astatus') {
$searchQuery .= " e.isactive like '%" . $val . "%' AND ";
} else {
if ($key == 'extn') {
$searchQuery .= " concat(e.office_number,' (ext ',e.extension_number,')') like '%" . $val . "%' AND ";
} else {
$searchQuery .= $key . " like '%" . $val . "%' AND ";
}
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
$objName = 'employee';
$tableFields = array('action' => 'Action', 'firstname' => 'First Name', 'lastname' => 'Last Name', 'emailaddress' => 'Email', 'employeeId' => 'Employee ID', 'businessunit_name' => 'Business Unit', 'department_name' => 'Department', 'astatus' => 'User Status', 'extn' => 'Work Phone', 'jobtitle_name' => 'Job Title', 'reporting_manager_name' => 'Reporting Manager', 'contactnumber' => 'Contact Number', 'emp_status_name' => 'Employment Status', 'emprole_name' => "Role");
$tablecontent = $this->getEmployeesData($sort, $by, $pageNo, $perPage, $searchQuery, '', $exParam1);
if ($tablecontent == "emptyroles") {
$emptyroles = 1;
} else {
$employmentstatusModel = new Default_Model_Employmentstatus();
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (count($employmentStatusData) > 0) {
foreach ($employmentStatusData as $empsdata) {
$empstatus_opt[$empsdata['workcodename']] = $empsdata['statusname'];
}
}
}
$dataTmp = array('userid' => $id, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'menuName' => 'Employees', 'dashboardcall' => $dashboardcall, 'add' => 'add', 'call' => $call, 'search_filters' => array('astatus' => array('type' => 'select', 'filter_data' => $filterArray), 'emp_status_id' => array('type' => 'select', 'filter_data' => array('' => 'All') + $empstatus_opt)), 'emptyroles' => $emptyroles);
return $dataTmp;
}
public function employeereportAction()
{
$norec_arr = array();
$form = new Default_Form_Employeereport();
$requi_model = new Default_Model_Requisition();
$employmentstatusModel = new Default_Model_Employmentstatus();
$role_model = new Default_Model_Roles();
$departmentsmodel = new Default_Model_Departments();
$bu_model = new Default_Model_Businessunits();
$roles_arr = $role_model->getRolesList_EMP();
$job_data = $requi_model->getJobTitleList();
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (count($job_data) == 0) {
$norec_arr['jobtitle_id'] = "Job titles are not configured yet.";
$norec_arr['position_id'] = "Positions are not configured yet.";
}
if (count($employmentStatusData) == 0) {
$norec_arr['emp_status_id'] = "Employment status is not configured yet.";
}
$form->jobtitle_id->addMultiOptions(array('' => 'Select Job Title') + $job_data);
if (count($employmentStatusData) > 0) {
$form->emp_status_id->addMultiOption('', 'Select Employment Status');
foreach ($employmentStatusData as $employmentStatusres) {
$form->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
if (sizeof($roles_arr) > 0) {
$form->emprole->addMultiOptions(array('' => 'Select Role') + $roles_arr);
} else {
$norec_arr['emprole'] = 'Roles are not added yet.';
}
$bu_arr = $bu_model->getBU_report();
if (!empty($bu_arr)) {
foreach ($bu_arr as $bu) {
$form->businessunit_id->addMultiOption($bu['id'], utf8_encode($bu['bu_name']));
}
} else {
$norec_arr['businessunit_id'] = 'Business Units are not added yet.';
}
$this->view->form = $form;
$this->view->messages = $norec_arr;
}
public function addpopupAction()
{
$screenFlag = "";
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');
if ($this->getRequest()->getParam('screenflag')) {
$screenFlag = $this->getRequest()->getParam('screenflag');
}
$boxid = $this->_getParam('boxid', null);
$fromcontroller = $this->_getParam('fromcontroller', null);
$msgarray = array();
$controllername = 'employmentstatus';
$employmentstatusform = new Default_Form_employmentstatus();
$employmentstatusmodel = new Default_Model_Employmentstatus();
$employmentstatusform->setAction(BASE_URL . 'employmentstatus/addpopup');
$activeEmploymentStatusArr = $employmentstatusmodel->getEmploymentStatuslist();
$newarr = array();
$empstatusstr = '';
if (!empty($activeEmploymentStatusArr)) {
for ($i = 0; $i < sizeof($activeEmploymentStatusArr); $i++) {
$newarr1[] = $activeEmploymentStatusArr[$i]['workcodename'];
}
if ($screenFlag == 'add') {
array_push($newarr1, 8, 9, 10);
}
$empstatusstr = implode(",", $newarr1);
}
if ($empstatusstr != '') {
$statusArr = $employmentstatusmodel->getStatuslist($empstatusstr);
} else {
$statusArr = $employmentstatusmodel->getCompleteStatuslist();
}
if (!empty($statusArr)) {
$employmentstatusform->workcodename->addMultiOption('', 'Select Work Code');
for ($i = 0; $i < sizeof($statusArr); $i++) {
if ($fromcontroller == 'requisition') {
if (!in_array($statusArr[$i]['id'], array(5, 7, 8, 9, 10))) {
$employmentstatusform->workcodename->addMultiOption($statusArr[$i]['id'], utf8_encode($statusArr[$i]['employemnt_status']));
}
} else {
$employmentstatusform->workcodename->addMultiOption($statusArr[$i]['id'], utf8_encode($statusArr[$i]['employemnt_status']));
}
}
}
$this->view->statusArr = $statusArr;
$this->view->ermsg = '';
if ($this->getRequest()->getPost()) {
if ($employmentstatusform->isValid($this->_request->getPost())) {
$id = $this->_request->getParam('id');
$workcode = $this->_request->getParam('workcode');
$workcodename = $this->_request->getParam('workcodename');
$default_leaves = $this->_request->getParam('default_leaves');
$description = $this->_request->getParam('description');
$screenFlag = $this->getRequest()->getParam('screenflag');
$date = new Zend_Date();
$actionflag = '';
$tableid = '';
$data = array('workcode' => trim($workcode), 'workcodename' => trim($workcodename), 'description' => trim($description), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('id=?' => $id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $employmentstatusmodel->SaveorUpdateEmploymentStatusData($data, $where);
$tableid = $Id;
$menuID = EMPLOYMENTSTATUS;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
if (isset($_POST['fromcontroller']) && $_POST['fromcontroller'] != '') {
$fromcontroller = $_POST['fromcontroller'];
}
if (isset($_POST['boxid']) && $_POST['boxid'] != '') {
$boxid = $_POST['boxid'];
}
} else {
$messages = $employmentstatusform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$this->view->msgarray = $msgarray;
}
}
$opt = '';
if ($fromcontroller == '') {
if ($screenFlag == 'edit') {
$empstatusData = $employmentstatusmodel->getempstatuslist();
}
if ($screenFlag == 'add') {
$empstatusData = $employmentstatusmodel->getempstatusActivelist();
}
if (!empty($empstatusData)) {
foreach ($empstatusData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['workcodename'], $record['statusname']);
}
}
} else {
if ($fromcontroller == 'requisition') {
$requi_model = new Default_Model_Requisition();
$empstatusData = $requi_model->getStatusOptionsForRequi();
foreach ($empstatusData as $stat_id => $stat_name) {
$opt .= sapp_Global::selectOptionBuilder($stat_id, $stat_name);
}
}
}
$this->view->empstatusData = $opt;
$this->view->screenFlag = $screenFlag;
$this->view->controllername = $controllername;
$this->view->form = $employmentstatusform;
$this->view->ermsg = '';
$this->view->boxid = $boxid;
$this->view->fromcontroller = $fromcontroller;
}
