public function save()
{
$empStatusId = $this->getValue('empStatusId');
if (!empty($empStatusId)) {
$empStatus = $this->getEmploymentStatusService()->getEmploymentStatusById($empStatusId);
} else {
$empStatus = new EmploymentStatus();
}
$empStatus->setName($this->getValue('name'));
$empStatus->save();
}
/**
* Get employee list after sorting and filtering using given parameters.
*
* @param EmployeeSearchParameterHolder $parameterHolder
*/
public function searchEmployees(EmployeeSearchParameterHolder $parameterHolder)
{
$sortField = $parameterHolder->getOrderField();
$sortOrder = $parameterHolder->getOrderBy();
$offset = $parameterHolder->getOffset();
$limit = $parameterHolder->getLimit();
$filters = $parameterHolder->getFilters();
$returnType = $parameterHolder->getReturnType();
$select = '';
$query = '';
$bindParams = array();
$orderBy = '';
$this->_getEmployeeListQuery($select, $query, $bindParams, $orderBy, $sortField, $sortOrder, $filters);
$completeQuery = $select . ' ' . $query . ' ' . $orderBy;
if (!is_null($offset) && !is_null($limit)) {
$completeQuery .= ' LIMIT ' . $offset . ', ' . $limit;
}
if (sfConfig::get('sf_logging_enabled')) {
$msg = $completeQuery;
if (count($bindParams) > 0) {
$msg .= ' (' . implode(',', $bindParams) . ')';
}
sfContext::getInstance()->getLogger()->info($msg);
}
$conn = Doctrine_Manager::connection();
$statement = $conn->prepare($completeQuery);
$result = $statement->execute($bindParams);
if ($returnType == EmployeeSearchParameterHolder::RETURN_TYPE_OBJECT) {
$employees = new Doctrine_Collection(Doctrine::getTable('Employee'));
if ($result) {
while ($row = $statement->fetch()) {
$employee = new Employee();
$employee->setEmpNumber($row['empNumber']);
$employee->setEmployeeId($row['employeeId']);
$employee->setFirstName($row['firstName']);
$employee->setMiddleName($row['middleName']);
$employee->setLastName($row['lastName']);
$employee->setTerminationId($row['terminationId']);
$jobTitle = new JobTitle();
$jobTitle->setId($row['jobTitleId']);
$jobTitle->setJobTitleName($row['jobTitle']);
$jobTitle->setIsDeleted($row['isDeleted']);
$employee->setJobTitle($jobTitle);
$employeeStatus = new EmploymentStatus();
$employeeStatus->setId($row['employeeStatusId']);
$employeeStatus->setName($row['employeeStatus']);
$employee->setEmployeeStatus($employeeStatus);
$workStation = new SubUnit();
$workStation->setName($row['subDivision']);
$workStation->setId($row['subDivisionId']);
$employee->setSubDivision($workStation);
$supervisorList = isset($row['supervisors']) ? $row['supervisors'] : '';
if (!empty($supervisorList)) {
$supervisors = new Doctrine_Collection(Doctrine::getTable('Employee'));
$supervisorArray = explode(',', $supervisorList);
foreach ($supervisorArray as $supervisor) {
list($first, $middle, $last) = explode('##', $supervisor);
$supervisor = new Employee();
$supervisor->setFirstName($first);
$supervisor->setMiddleName($middle);
$supervisor->setLastName($last);
$employee->supervisors[] = $supervisor;
}
}
$locationList = $row['locationIds'];
if (!empty($locationList)) {
// $locations = new Doctrine_Collection(Doctrine::getTable('EmpLocations'));
$locationArray = explode(',', $locationList);
foreach ($locationArray as $location) {
list($id, $name) = explode('##', $location);
$empLocation = new Location();
$empLocation->setId($id);
$empLocation->setName($name);
$employee->locations[] = $empLocation;
}
}
$employees[] = $employee;
}
}
} else {
return $statement->fetchAll();
}
return $employees;
}
<?php
class EmploymentStatus extends ICEHRM_Record
{
var $_table = 'EmploymentStatus';
public function getAdminAccess()
{
return array("get", "element", "save", "delete");
}
public function getUserAccess()
{
return array();
}
}
EmploymentStatus::SetDatabaseAdapter($dbLocal);
function reDirect($getArr, $object = null)
{
$form_creator = new FormCreator($getArr);
switch ($getArr['uniqcode']) {
case 'BNK':
$form_creator->formPath = '/templates/eimadmin/bankinformation.php';
$bankinfo = new BankInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $bankinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $bankinfo->filterBankInfo($getArr['id']);
}
break;
case 'BCH':
$form_creator->formPath = '/templates/eimadmin/branches.php';
$brch = new Branches();
$bank = new BankInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $brch->getLastRecord();
$form_creator->popArr['bankcode'] = $bank->getBankCodes();
} elseif ($getArr['captuIMPremode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $brch->filterBranches($getArr['id']);
$form_creator->popArr['bankcode'] = $bank->getBankCodes();
}
break;
case 'TAX':
$form_creator->formPath = '/templates/eimadmin/taxinformation.php';
$taxinfo = new TaxInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $taxinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $taxinfo->filterTaxInfo($getArr['id']);
}
break;
case 'CCB':
$form_creator->formPath = '/templates/eimadmin/cashben.php';
$cashben = new CashBen();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $cashben->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $cashben->filterCashBenefits($getArr['id']);
}
break;
case 'BBS':
$form_creator->formPath = '/templates/eimadmin/cashbensal.php';
$salgrd = new SalaryGrades();
$cashbensal = new CashBenSalary();
$cashben = new CashBen();
$form_creator->popArr['salDet'] = $salgrd->filterSalaryGrades($getArr['id']);
$form_creator->popArr['benListAll'] = $cashben->getAllCashBenefits();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $cashbensal->filterCashBenefits($arr);
} else {
$form_creator->popArr['benListUnAss'] = $cashben->getCashBenCodes($getArr['id']);
}
$form_creator->popArr['benListAss'] = $cashbensal->getAssCashBenefits($getArr['id']);
break;
case 'COS':
$form_creator->formPath = '/templates/eimadmin/costcenters.php';
$cost = new CostCenter();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $cost->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $cost->filterCostCenter($getArr['id']);
}
break;
case 'COU':
$form_creator->formPath = '/templates/eimadmin/countryinformation.php';
$country = new CountryInfo();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $country->filterCountryInfo($getArr['id']);
}
break;
case 'CUR':
$form_creator->formPath = '/templates/eimadmin/currencytypes.php';
$currency = new CurrencyTypes();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $currency->filterCurrencyTypes($getArr['id']);
}
break;
case 'DWT':
$form_creator->formPath = '/templates/eimadmin/dwellinginformation.php';
$dwinfo = new DwellingType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $dwinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $dwinfo->filterDwellingType($getArr['id']);
}
break;
case 'ELE':
$form_creator->formPath = '/templates/eimadmin/electorateinformation.php';
$eleinfo = new ElectorateInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $eleinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $eleinfo->filterElectorateInfo($getArr['id']);
}
break;
case 'EMC':
$form_creator->formPath = '/templates/eimadmin/empcatinfo.php';
$empcatinfo = new EmployeeCat();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empcatinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $empcatinfo->filterEmployeeCat($getArr['id']);
}
break;
case 'EMG':
$form_creator->formPath = '/templates/eimadmin/employeegroups.php';
$empgrpinfo = new EmployeeGroup();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empgrpinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $empgrpinfo->filterEmployeeGroup($getArr['id']);
}
break;
case 'ETY':
$form_creator->formPath = '/templates/eimadmin/emptypes.php';
$emptype = new EmployeeType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $emptype->getLastRecord();
} elseif ($getArr['capturemIMPode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $emptype->filterEmployeeType($getArr['id']);
}
break;
case 'EXC':
$form_creator->formPath = '/templates/eimadmin/extracurractcat.php';
$exccat = new ExtraCurrActCat();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $exccat->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $exccat->filterExtraCurrActCat($getArr['id']);
}
break;
case 'DEF':
$form_creator->formPath = '/templates/eimadmin/hierarchydef.php';
$hidef = new HierarchyDefInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $hidef->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $hidef->filterHierarchyDefInfo($getArr['id']);
}
break;
case 'CHI':
$form_creator->formPath = '/templates/eimadmin/comphier.php';
$cmphier = new CompHierachy();
$hidef = new HierarchyDefInfo();
$loc = new models_eimadmin_Location();
$empinfo = new EmpInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $cmphier->getLastRecord();
$form_creator->popArr['hiercodes'] = $hidef->getHierachyCodes();
$form_creator->popArr['empcodes'] = $empinfo->getEmpCodes();
$form_creator->popArr['deflev'] = $cmphier->getHierachyDef();
$form_creator->popArr['loccodes'] = $loc->getLocCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $cmphier->filterCompHierachy($getArr['id']);
$form_creator->popArr['hiercodes'] = $cmphier->getHierachyCodes();
$form_creator->popArr['empcodes'] = $empinfo->getEmpCodes();
$form_creator->popArr['deflev'] = $cmphier->getHierachyDef();
$form_creator->popArr['loccodes'] = $loc->getLocCodes();
}
break;
case 'LOC':
$form_creator->formPath = '/templates/eimadmin/locations.php';
$loc = new models_eimadmin_Location();
$country = new CountryInfo();
$form_creator->popArr['cntlist'] = $country->getCountryCodes();
if ($getArr['capturemode'] == 'updatemode') {
$province = new ProvinceInfo();
$district = new DistrictInfo();
$form_creator->popArr['editArr'] = $edit = $loc->filterLocation($getArr['id']);
$form_creator->popArr['provlist'] = $province->getProvinceCodes($edit[0][2]);
$form_creator->popArr['districtlist'] = $district->getDistrictCodes($edit[0][3]);
}
break;
case 'JDC':
$form_creator->formPath = '/templates/eimadmin/jdcategory.php';
$jdcat = new JDCategory();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $jdcat->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jdcat->filterJDCategory($getArr['id']);
}
break;
case 'MEM':
$form_creator->formPath = '/templates/eimadmin/membershiptypes.php';
$memtype = new MembershipType();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $memtype->filterMembershipType($getArr['id']);
}
break;
case 'EMX':
$form_creator->formPath = '/templates/eimadmin/emailConfiguration.php';
$emailConfigObj = new EmailConfiguration();
$form_creator->popArr['editArr'] = $emailConfigObj;
break;
case 'CSE':
$form_creator->formPath = '/templates/eimadmin/dataExport.php';
$csvExport = new CSVExport();
$form_creator->popArr['exportTypes'] = $csvExport->getDefinedExportTypes();
break;
case 'IMP':
if (isset($getArr['upload']) && $getArr['upload'] == 1) {
$form_creator->formPath = '/templates/eimadmin/dataUploadStatus.php';
$form_creator->popArr['uploadStatus'] = $object;
$form_creator->popArr['recordLimit'] = CSVSplitter::getRecordLimit();
$form_creator->popArr['delimiterLevels'] = AjaxCalls::getDelimiterLevelsArray(3);
} else {
$form_creator->formPath = '/templates/eimadmin/dataImport.php';
$csvImport = new CSVImport();
$form_creator->popArr['importTypes'] = $csvImport->getDefinedImportTypes();
}
break;
case 'ENS':
$form_creator->formPath = '/templates/eimadmin/emailNotificationConfiguration.php';
$emailNotificationConfObj = new EmailNotificationConfiguration($_SESSION['user']);
$form_creator->popArr['editArr'] = $emailNotificationConfObj->fetchNotifcationStatus();
break;
case 'NAT':
$form_creator->formPath = '/templates/eimadmin/nationalityinformation.php';
$natinfo = new NationalityInfo();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $natinfo->filterNationalityInfo($getArr['id']);
}
break;
case 'NCB':
$form_creator->formPath = '/templates/eimadmin/noncashben.php';
$noncashben = new NonCashBen();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $noncashben->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $noncashben->filterNonCashBenefits($getArr['id']);
}
break;
case 'QLF':
$form_creator->formPath = '/templates/eimadmin/qualificationtypes.php';
$qualtype = new QualificationType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $qualtype->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $qualtype->filterQualificationType($getArr['id']);
}
break;
case 'RTM':
$form_creator->formPath = '/templates/eimadmin/ratingmethods.php';
$rattype = new RatingTypes();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $rattype->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $rattype->filterRatingTypes($getArr['id']);
}
break;
case 'RTE':
$form_creator->formPath = '/templates/eimadmin/routeinformation.php';
$rouinfo = new RouteInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $rouinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $rouinfo->filterRouteInfo($getArr['id']);
}
break;
case 'SGR':
$form_creator->formPath = '/templates/eimadmin/salarygrades.php';
$salgrade = new SalaryGrades();
$salcurdet = new SalCurDet();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $salgrade->filterSalaryGrades($getArr['id']);
$form_creator->popArr['assCurrency'] = $salcurdet->getAssSalCurDet($getArr['id']);
if (!isset($getArr['editID'])) {
$form_creator->popArr['unAssCurrency'] = $salcurdet->getUnAssSalCurDet($getArr['id']);
} else {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editAssCurrency'] = $salcurdet->filterSalCurDet($arr);
}
}
break;
case 'SKI':
$form_creator->formPath = '/templates/eimadmin/skills.php';
$skill = new Skills();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $skill->filterSkills($getArr['id']);
}
break;
case 'ETH':
$form_creator->formPath = '/templates/eimadmin/ethnicrace.php';
$ethnicrace = new EthnicRace();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $ethnicrace->filterEthnicRace($getArr['id']);
}
break;
case 'EXA':
$form_creator->formPath = '/templates/eimadmin/extracurractinfo.php';
$extcainfo = new ExtraCurActInfo();
$excurac = new ExtraCurrActCat();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $extcainfo->getLastRecord();
$form_creator->popArr['getResultSet'] = $extcainfo->getExtraCatCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $extcainfo->filterExtraCurActInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $excurac->getExtraCatCodes();
}
break;
case 'MME':
$form_creator->formPath = '/templates/eimadmin/membershipinformation.php';
$meminfo = new MembershipInfo();
$memtype = new MembershipType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['getResultSet'] = $memtype->getMembershipTypeCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $meminfo->filterMembershipInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $memtype->getMembershipTypeCodes();
}
break;
case 'JDK':
$form_creator->formPath = '/templates/eimadmin/jdkra.php';
$jdkr = new JDKra();
$skill = new Skills();
$jdtyp = new JDType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $jdkr->getLastRecord();
$form_creator->popArr['jdktyplist'] = $jdtyp->getJDTypeCodes();
$form_creator->popArr['sktyplist'] = $skill->getSkillCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jdkr->filterJDKra($getArr['id']);
$form_creator->popArr['jdktyplist'] = $jdtyp->getJDTypeCodes();
$form_creator->popArr['sktyplist'] = $skill->getSkillCodes();
}
break;
case 'LAN':
$form_creator->formPath = '/templates/eimadmin/languageinformation.php';
$laninfo = new LanguageInfo();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $laninfo->filterLanguageInfo($getArr['id']);
}
break;
case 'RLG':
$form_creator->formPath = '/templates/eimadmin/religioninformation.php';
$relinfo = new ReligionInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $relinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $relinfo->filterReligionInfo($getArr['id']);
}
break;
case 'SAT':
$form_creator->formPath = '/templates/eimadmin/satutoryinfo.php';
$satinfo = new SatutoryInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $satinfo->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $satinfo->filterSatutoryInfo($getArr['id']);
}
break;
case 'UNI':
$form_creator->formPath = '/templates/eimadmin/uniformtypes.php';
$unitype = new UniformType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $unitype->getLastRecord();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $unitype->filterUniformType($getArr['id']);
}
break;
case 'EXA':
$form_creator->formPath = '/templates/eimadmin/extracurractinfo.php';
$excurac = new ExtraCurActInfo();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $excurac->getLastRecord();
$form_creator->popArr['getResultSet'] = $excurac->getExtraCatCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $excurac->filterExtraCurActInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $excurac->getExtraCatCodes();
}
break;
case 'EDU':
$form_creator->formPath = '/templates/eimadmin/qualifications.php';
$edu = new Education();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $edu->filterEducation($getArr['id']);
}
break;
case 'JDT':
$form_creator->formPath = '/templates/eimadmin/jdtypes.php';
$jdtyp = new JDType();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $jdtyp->getLastRecord();
$form_creator->popArr['jdcatcodes'] = $jdtyp->getJDTypeCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jdtyp->filterJDType($getArr['id']);
$form_creator->popArr['jdcatcodes'] = $jdtyp->getJDTypeCodes();
}
break;
case 'SBJ':
$form_creator->formPath = '/templates/eimadmin/subjectinformation.php';
$subin = new SubjectInfo();
$qualifi = new Qualifications();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $subin->getLastRecord();
$form_creator->popArr['getResultSet'] = $qualifi->getQualifiCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $subin->filterSubjectInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $qualifi->getQualifiCodes();
}
break;
case 'SSK':
$form_creator->formPath = '/templates/eimadmin/subskillinformation.php';
$subsk = new SubSkillInfo();
$skill = new Skills();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $subsk->getLastRecord();
$form_creator->popArr['getResultSet'] = $skill->getSkillCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $subsk->filterSubSkillInfo($getArr['id']);
$form_creator->popArr['getResultSet'] = $skill->getSkillCodes();
}
break;
case 'CTT':
$form_creator->formPath = '/templates/eimadmin/corptit.php';
$corptit = new CorpTitle();
$salgrd = new SalaryGrades();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $corptit->getLastRecord();
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['salgrds'] = $corptit->getSalGrades();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $corptit->filterCorpTitles($getArr['id']);
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['salgrds'] = $salgrd->getSalGrades();
}
break;
case 'DSG':
$form_creator->formPath = '/templates/eimadmin/designations.php';
$desig = new Designations();
$corptit = new CorpTitle();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $desig->getLastRecord();
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['des'] = $desig->getDes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $desig->filterDesignations($getArr['id']);
$form_creator->popArr['corptitles'] = $corptit->getCorpTitles();
$form_creator->popArr['des'] = $desig->getDes();
}
break;
case 'DIS':
$form_creator->formPath = '/templates/eimadmin/districtinformation.php';
$disinfo = new DistrictInfo();
$prov = new ProvinceInfo();
$country = new CountryInfo();
$form_creator->popArr['countrylist'] = $country->getCountryCodes();
if ($getArr['capturemode'] == 'addmode') {
if ($object != null) {
$form_creator->popArr['txtDistrictDesc'] = $object->txtDistrictDesc;
$form_creator->popArr['cmbCountry'] = $object->cmbCountry;
$form_creator->popArr['selProvince'] = $object->selProvince;
$form_creator->popArr['provlist'] = $prov->getProvinceCodes($object->cmbCountry);
}
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $editArr = $disinfo->filterDistrictInfo($getArr['id']);
if ($object != null) {
$form_creator->popArr['txtDistrictDesc'] = $object->txtDistrictDesc;
$form_creator->popArr['cmbCountry'] = $object->cmbCountry;
$form_creator->popArr['selProvince'] = $object->selProvince;
$form_creator->popArr['provlist'] = $prov->getProvinceCodes($object->cmbCountry);
} else {
$temp = $prov->filterGetProvinceCodeInfo($editArr[0][2]);
$form_creator->popArr['selcountry'] = $temp[0][2];
$form_creator->popArr['provlist'] = $prov->getProvinceCodes($temp[0][2]);
}
}
break;
case 'NBS':
$form_creator->formPath = '/templates/eimadmin/noncashbensal.php';
$salgrd = new SalaryGrades();
$noncashbensal = new NonCashBenSalary();
$noncashben = new NonCashBen();
$form_creator->popArr['salDet'] = $salgrd->filterSalaryGrades($getArr['id']);
$form_creator->popArr['benListAll'] = $noncashben->getAllNonCashBenefits();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $noncashben->filterNonCashBenefits($arr);
} else {
$form_creator->popArr['benListUnAss'] = $noncashben->getNonCashBenCodes($getArr['id']);
}
$form_creator->popArr['benListAss'] = $noncashbensal->getAssCashBenefits($getArr['id']);
break;
case 'DDI':
$form_creator->formPath = '/templates/eimadmin/desdis.php';
$desig = new Designations();
$desdis = new DesDescription();
$form_creator->popArr['desDet'] = $desig->getDes();
$form_creator->popArr['desDisAss'] = $desdis->getAssigned($getArr['id']);
if (isset($getArr['editID'])) {
$arr[1] = $getArr['id'];
$arr[0] = $getArr['editID'];
$form_creator->popArr['editArr'] = $desdis->filterJDKPI($arr);
}
if (isset($getArr['addForm']) && $getArr['addForm'] == 'ADD') {
$form_creator->popArr['desDisUnAss'] = $desdis->getGrouping($getArr['id']);
}
break;
case 'DQA':
$form_creator->formPath = '/templates/eimadmin/desqua.php';
$desig = new Designations();
$desqual = new DesQualification();
$form_creator->popArr['desDet'] = $desig->getDes();
$form_creator->popArr['qualListAll'] = $desqual->getAllQualifications();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $desqual->filterJDQual($arr);
} else {
$form_creator->popArr['qualListUnAss'] = $desqual->getQual($getArr['id']);
}
$form_creator->popArr['qualListAss'] = $desqual->getAssJDQual($getArr['id']);
break;
case 'DQS':
$form_creator->formPath = '/templates/eimadmin/desquasub.php';
$desig = new Designations();
$desqualsub = new DesQualSubject();
$qualifi = new Qualifications();
$form_creator->popArr['desDet'] = $desig->filterDesignations($getArr['id']);
$form_creator->popArr['qualDet'] = $qualifi->getQualCodes();
$form_creator->popArr['gradlist'] = $desqualsub->getRatGrds($getArr['QUA']);
$form_creator->popArr['subDet'] = $desqualsub->getSubjectCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$arr[2] = $getArr['QUA'];
$form_creator->popArr['editArr'] = $desqualsub->filterQuaSub($arr);
} else {
$form_creator->popArr['sublist'] = $desqualsub->getSubjects($getArr['id'], $getArr['QUA']);
}
$form_creator->popArr['rset'] = $desqualsub->getAssQuaSub($getArr['id']);
break;
case 'RTG':
$form_creator->formPath = '/templates/eimadmin/ratinggrade.php';
$rattyp = new RatingTypes();
$form_creator->popArr['ratDet'] = $rattyp->filterRatingTypes($getArr['id']);
$ratgrd = new RatingGrade();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $ratgrd->filterRatGrd($arr);
} else {
$form_creator->popArr['newID'] = $ratgrd->getLastRecord();
}
$form_creator->popArr['ratGrdAss'] = $ratgrd->getAssRatGrd($getArr['id']);
break;
case 'EEC':
$form_creator->formPath = '/templates/eimadmin/eeojobcat.php';
$eeojobcat = new EEOJobCat();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $eeojobcat->filterEEOJobCat($getArr['id']);
}
break;
case 'LIC':
$form_creator->formPath = '/templates/eimadmin/licenses.php';
$licenses = new Licenses();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $licenses->filterLicenses($getArr['id']);
}
break;
case 'CST':
$form_creator->formPath = '/templates/eimadmin/compstruct.php';
/*
$hierachinfo = new HierarchyDefInfo();
$comphier = new CompHierachy();
$compstruct = new CompStruct();
$form_creator->popArr['hierlist'] = $hierachinfo -> getHierarchyDef();
$form_creator->popArr['compstruct'] = $comphier ->getAssCompHier(1,'');
$form_creator->popArr['unAssCompStruct'] = $compstruct->getUnAssCompStruct('',1);
*/
$locations = new models_eimadmin_Location();
$countries = new CountryInfo();
$form_creator->popArr['locations'] = $locations->getLocCodes();
$form_creator->popArr['countries'] = $countries->getCountryCodes();
break;
case 'TCP':
$form_creator->formPath = '/templates/eimadmin/companyProperty.php';
$authorizeObj = new authorize($_SESSION['empID'], $_SESSION['isAdmin']);
if (!isset($_GET['action'])) {
$empInfo = new EmpInfo();
if ($authorizeObj->isAdmin()) {
$form_creator->popArr['emplist'] = $empInfo->getListofEmployee();
} else {
$empReportTo = new EmpRepTo();
$form_creator->popArr['emplist'] = $empReportTo->getEmpSubDetails($_SESSION['empID']);
/* An element of the value from $empInfo->getListofEmployee() will contain
* an array with 6 elements. Values from $empReportTo->getEmpSubDetails() will
* only contain 3 elements. But there won't be a problem because only first 3 values
* will be used in the template
*/
}
}
$compProp = new CompProperty();
$propertyCount = count($compProp->getPropertyList());
$pageNo = 1;
if (isset($_REQUEST['pageNo'])) {
$pageNo = $_REQUEST['pageNo'];
} else {
$pageNo = ceil($propertyCount / 10);
}
if ($authorizeObj->isAdmin()) {
$form_creator->popArr['properties'] = $compProp->getPropertyList($pageNo);
} else {
$subordinateList = array();
foreach ($form_creator->popArr['emplist'] as $subordinate) {
$subordinateList[] = $subordinate[0];
}
$form_creator->popArr['properties'] = $compProp->getPropertyList($pageNo, $subordinateList, true);
}
$form_creator->popArr['allProperties'] = $compProp->getPropertyList();
$form_creator->popArr['pageNo'] = $pageNo;
$form_creator->popArr['recordCount'] = $propertyCount;
$form_creator->popArr['authObj'] = $authorizeObj;
break;
case 'JOB':
$form_creator->formPath = '/templates/eimadmin/jobtitle.php';
$jobtitle = new JobTitle();
$paygrade = new SalaryGrades();
$jobtit_empstat = new JobTitEmpStat();
$form_creator->popArr['paygrade'] = $paygrade->getSalGrades(true);
$form_creator->popArr['jobSpecList'] = JobSpec::getAll();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $jobtitle->filterJobTitles($getArr['id']);
$form_creator->popArr['assEmploymentStat'] = $jobtit_empstat->getAssEmpStat($getArr['id']);
$form_creator->popArr['unAssEmploymentStat'] = $jobtit_empstat->getUnAssEmpStat($getArr['id']);
}
break;
case 'SPC':
$form_creator->formPath = '/templates/eimadmin/jobSpec.php';
// Here we fetch all job specs for easier validation of duplicate names
// Assuming it's unlikely that very large number of job specs will be defined.
$form_creator->popArr['jobSpecList'] = JobSpec::getAll();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['jobSpec'] = JobSpec::getJobSpec($getArr['id']);
} else {
$form_creator->popArr['jobSpec'] = new JobSpec();
}
break;
case 'EST':
$form_creator->formPath = '/templates/eimadmin/empstat.php';
$empstat = new EmploymentStatus();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $empstat->filterEmpStat($getArr['id']);
}
break;
case 'GEN':
$form_creator->formPath = '/templates/eimadmin/geninfo.php';
$geninfo = new GenInfo();
$country = new CountryInfo();
$province = new ProvinceInfo();
$district = new DistrictInfo();
$tabArr = $geninfo->filterGenInfo();
$genInfoKeys = explode('|', $tabArr[0][0]);
$genInfoValues = explode('|', $tabArr[0][1]);
for ($c = 0; $genInfoKeys && count($genInfoKeys) > $c; $c++) {
$editArr[$genInfoKeys[$c]] = $genInfoValues[$c];
}
$form_creator->popArr['editArr'] = $editArr;
$form_creator->popArr['cntlist'] = $country->getCountryCodes();
if (isset($editArr['COUNTRY'])) {
$form_creator->popArr['provlist'] = $province->getProvinceCodes($editArr['COUNTRY']);
}
if (isset($editArr['STATE'])) {
$form_creator->popArr['districtlist'] = $district->getDistrictCodes($editArr['STATE']);
}
//Finding the numer of employees
$empInfo = new EmpInfo();
$form_creator->popArr['empcount'] = $empInfo->countEmployee();
break;
case 'CUS':
$form_creator->formPath = '/templates/eimadmin/customer.php';
$customer = new Customer();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $customer->fetchCustomer($getArr['id']);
} else {
$form_creator->popArr['editArr'] = new Customer();
}
break;
case 'CTM':
$form_creator->formPath = '/templates/eimadmin/customFields.php';
$form_creator->popArr['available'] = CustomFields::getAvailableFieldNumbers();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = CustomFields::getCustomField($getArr['id']);
} else {
$form_creator->popArr['editArr'] = new CustomFields();
}
break;
case 'CEX':
$form_creator->formPath = '/templates/eimadmin/customExportDefine.php';
$form_creator->popArr['customExportList'] = CustomExport::getCustomExportList();
if ($getArr['capturemode'] == 'updatemode') {
$customExport = CustomExport::getCustomExport($getArr['id']);
$form_creator->popArr['headings'] = $customExport->getHeadings();
$form_creator->popArr['available'] = $customExport->getAvailableFields();
$form_creator->popArr['assigned'] = $customExport->getAssignedFields();
$form_creator->popArr['exportName'] = $customExport->getName();
$form_creator->popArr['id'] = $customExport->getId();
} else {
$form_creator->popArr['headings'] = array();
$form_creator->popArr['available'] = CustomExport::getAllFields();
$form_creator->popArr['assigned'] = array();
$form_creator->popArr['exportName'] = null;
$form_creator->popArr['id'] = null;
}
break;
case 'CIM':
$form_creator->formPath = '/templates/eimadmin/customImportDefine.php';
$form_creator->popArr['customImportList'] = CustomImport::getCustomImportList();
if ($getArr['capturemode'] == 'updatemode') {
$customImport = CustomImport::getCustomImport($getArr['id']);
$form_creator->popArr['has_heading'] = $customImport->getContainsHeader();
$form_creator->popArr['available'] = $customImport->getAvailableFields();
$form_creator->popArr['assigned'] = $customImport->getAssignedFields();
$form_creator->popArr['importName'] = $customImport->getName();
$form_creator->popArr['id'] = $customImport->getId();
$form_creator->popArr['compulsary_fields'] = CustomImport::getCompulsaryFields();
} else {
$customImport = new CustomImport();
// Assign compulsary fields
$compulsary = CustomImport::getCompulsaryFields();
$customImport->setAssignedFields($compulsary);
$form_creator->popArr['has_heading'] = true;
$form_creator->popArr['available'] = $customImport->getAvailableFields();
$form_creator->popArr['assigned'] = $compulsary;
$form_creator->popArr['importName'] = null;
$form_creator->popArr['id'] = null;
$form_creator->popArr['compulsary_fields'] = $compulsary;
}
break;
case 'CHD':
$form_creator->formPath = '/templates/eimadmin/customExportHeadingDefine.php';
$customExport = CustomExport::getCustomExport($getArr['id']);
$headings = $customExport->getHeadings();
$form_creator->popArr['headings'] = empty($headings) ? $customExport->getAssignedFields() : $headings;
$form_creator->popArr['assigned'] = $customExport->getAssignedFields();
$form_creator->popArr['exportName'] = $customExport->getName();
$form_creator->popArr['id'] = $customExport->getId();
break;
case 'PAD':
// Project Admin. Fall through to PRJ case below.
$form_creator->getArr['uniqcode'] = "PRJ";
case 'PRJ':
$form_creator->formPath = '/templates/eimadmin/project.php';
$project = new Projects();
$customer = new Customer();
$form_creator->popArr['cusid'] = $customer->fetchCustomers();
$form_creator->popArr['employeeList'] = EmpInfo::getEmployeeMainDetails();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $project->fetchProject($getArr['id']);
$gw = new ProjectAdminGateway();
$form_creator->popArr['admins'] = $gw->getAdmins($getArr['id']);
}
break;
case 'PAC':
$form_creator->formPath = '/templates/eimadmin/projectActivity.php';
/* If a HR admin, show all projects. Otherwise only show projects for which
* user is an admin
*/
$authorizeObj = new authorize($_SESSION['empID'], $_SESSION['isAdmin']);
if ($authorizeObj->isAdmin()) {
$projects = new Projects();
/* Filter only not deleted projects */
$projects->setDeleted(Projects::PROJECT_NOT_DELETED);
$projectList = $projects->fetchProjects();
} else {
if ($authorizeObj->isProjectAdmin()) {
$gw = new ProjectAdminGateway();
$projectList = $gw->getProjectsForAdmin($_SESSION['empID']);
}
}
/* If projectId given, get activities for that project else load first
* project in list
*/
$projectId = null;
$activities = array();
if (!empty($projectList)) {
if (isset($getArr['projectId']) && ($authorizeObj->isAdmin() || $authorizeObj->isProjectAdminOf($getArr['projectId']))) {
$projectId = $getArr['projectId'];
} else {
$projectId = $projectList[0]->getProjectId();
}
$activities = ProjectActivity::getActivityList($projectId);
}
$form_creator->popArr['projects'] = $projectList;
$form_creator->popArr['projectId'] = $projectId;
$form_creator->popArr['activities'] = $activities;
break;
case 'USR':
$form_creator->formPath = '/templates/maintenance/users.php';
$user = new Users();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['emplist'] = $user->getEmployeeCodes();
$form_creator->popArr['uglist'] = $user->getUserGroupCodes();
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $user->filterUsers($getArr['id']);
$form_creator->popArr['emplist'] = $user->getEmployeeCodes();
$form_creator->popArr['uglist'] = $user->getUserGroupCodes();
//$form_creator ->popArr['editArr'] = $user->filterChangeUsers($getArr['id']);
}
$form_creator->popArr['employeeSearchList'] = EmpInfo::getEmployeeSearchList();
break;
case 'USG':
$form_creator->formPath = '/templates/maintenance/usergroups.php';
$usrgrp = new UserGroups();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $usrgrp->filterUserGroups($getArr['id']);
}
break;
case 'UGR':
$form_creator->formPath = '/templates/maintenance/AdminMenu.php';
$urights = new Rights();
$usergroup = new UserGroups();
$form_creator->popArr['ugDet'] = $usergroup->filterUserGroups($getArr['id']);
$form_creator->popArr['modlist'] = $urights->getAllModules();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $urights->filterRights($arr);
} else {
$form_creator->popArr['modlistUnAss'] = $urights->getModuleCodes($getArr['id']);
}
$form_creator->popArr['modlistAss'] = $urights->getAssRights($getArr['id']);
break;
case 'LDAP':
if ($_SESSION['ldap'] == "enabled") {
$form_creator->formPath = '/templates/eimadmin/ldapConfiguration.php';
$ldapConfigObj = new LdapDetails();
$form_creator->popArr['editArr'] = $ldapConfigObj->retrieveLdapDetails();
}
break;
}
$form_creator->display();
}
function reDirect($getArr, $postArr, $object = null)
{
$form_creator = new FormCreator($getArr, $postArr);
if ($_SESSION['isAdmin'] !== 'Yes') {
trigger_error("Unauthorized access", E_USER_NOTICE);
}
switch ($getArr['repcode']) {
case 'EMPDEF':
//if ()
$form_creator->formPath = '/templates/report/emprepinfo.php';
$form_creator->popArr['arrAgeSim'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
//$form_creator->popArr['arrEmpType']= array( 'Permanent', 'Expatriate', 'Contract', 'Temporary' , 'Others');
$form_creator->popArr['arrSerPer'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
$form_creator->popArr['arrJoiDat'] = array('Joined After' => '>', 'Joined Before' => '<', 'Joined In Between' => 'range');
$report = new EmpReport();
$empinfo = new EmpInfo();
$edu = new Education();
$jobtit = new JobTitle();
$salgrd = new SalaryGrades();
$empstat = new EmploymentStatus();
$langObj = new LanguageInfo();
$skillObj = new Skills();
$form_creator->popArr['grdlist'] = $salgrd->getSalGrdCodes();
$form_creator->popArr['edulist'] = $edu->getAllEducation();
$form_creator->popArr['deslist'] = $jobtit->getJobTit();
$form_creator->popArr['arrEmpType'] = $empstat->getEmpStat();
$form_creator->popArr['languageList'] = $langObj->getLang();
$form_creator->popArr['skillList'] = $skillObj->getSkillCodes();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $edit = $report->filterReport($getArr['id']);
$criteria_value = explode('|', $edit[0][2]);
for ($c = 0; count($criteria_value) > $c; $c++) {
$crit_data = explode("=", $criteria_value[$c]);
$criteriaChkBox[$c] = $crit_data[0];
for ($d = 1; count($crit_data) > $d; $d++) {
$crit_form_data[$crit_data[0]][$d - 1] = $crit_data[$d];
}
}
$form_creator->popArr['editCriteriaChk'] = $criteriaChkBox;
$form_creator->popArr['editCriteriaData'] = $crit_form_data;
$form_creator->popArr['fieldList'] = explode('|', $edit[0][3]);
}
if ($object != null) {
$form_creator->popArr['empqual'] = $empqual->getQualifications($object->TypeCode);
}
break;
case 'EMPVIEW':
$report = new EmpReport();
$repgen = new ReportGenerator();
$edit = $report->filterReport($getArr['id']);
$repgen->reportId = $edit[0][0];
/* TODO: The following actions should be moved to model class */
$criteria = explode('|', $edit[0][2]);
$criteriaCount = count($criteria);
for ($c = 0; $criteriaCount > $c; $c++) {
$crit_value = explode("=", $criteria[$c]);
$repgen->setCriteria($crit_value[0], '');
$criteriaValueCount = count($crit_value);
for ($d = 1; $criteriaValueCount > $d; $d++) {
if ($d == count($crit_value) - 1) {
$repgen->setCriteria($crit_value[0], $crit_value[$d], true);
} else {
$repgen->setCriteria($crit_value[0], $crit_value[$d] . "|", true);
}
}
}
$field = explode('|', $edit[0][3]);
$fieldCount = count($field);
for ($c = 0; $fieldCount > $c; $c++) {
$repgen->setField($field[$c], 1);
}
$sqlQ = $repgen->buildReportQuery();
$arrayDispList = $repgen->buildDisplayList($sqlQ);
$employee = array();
if (is_array($arrayDispList)) {
$employee = current($arrayDispList);
}
$columns = count($employee);
$rows = count($arrayDispList);
$objs['reportName'] = $edit[0][1];
$objs['arrayDispList'] = $arrayDispList;
$objs['headerNames'] = $repgen->getHeaders();
$objs['replacements'] = array('directReportingMode' => EmpRepTo::REPORTING_MODE_DIRECT, 'indirectReportingMode' => EmpRepTo::REPORTING_MODE_INDIRECT);
$templatePath = '/templates/report/report.php';
$template = new TemplateMerger($objs, $templatePath, null, null);
$template->display();
return;
break;
case 'RUG':
$form_creator->formPath = '/templates/report/repusg.php';
$report = new EmpReport();
$emprepgroup = new EmpRepUserGroup();
$form_creator->popArr['report'] = $report->filterReport($getArr['id']);
$form_creator->popArr['usgAll'] = $emprepgroup->getAllUserGroups();
$form_creator->popArr['repUsgAss'] = $emprepgroup->getAssignedUserGroup($getArr['id']);
$form_creator->popArr['usgUnAss'] = $emprepgroup->getUnAssUserGroups($getArr['id']);
break;
}
$form_creator->display();
}
public function viewSelectTimesheet()
{
if ($_SESSION['isAdmin'] == 'No' && !$_SESSION['isSupervisor']) {
die('You are not authorized to view this page');
}
$path = "/templates/time/selectTimesheets.php";
$dataArr = null;
$employmentStatusObj = new EmploymentStatus();
$dataArr[0] = $employmentStatusObj->getListofEmpStat(0, '', -1);
if ($_SESSION['isSupervisor']) {
$repObj = new EmpRepTo();
$dataArr[1] = $repObj->getEmpSubDetails($_SESSION['empID']);
}
$template = new TemplateMerger($dataArr, $path);
$template->display();
}
public function viewSelectTimesheet()
{
if ($_SESSION['isAdmin'] == 'No' && !$_SESSION['isSupervisor']) {
die('You are not authorized to view this page');
}
$path = "/templates/time/selectTimesheets.php";
$dataArr = null;
$employmentStatusObj = new EmploymentStatus();
$dataArr[0] = $employmentStatusObj->getListofEmpStat(0, '', -1, 1);
if ($_SESSION['isSupervisor']) {
$repObj = new EmpRepTo();
$dataArr[1] = $repObj->getEmpSubDetails($_SESSION['empID']);
}
$dataArr['empList'] = array();
/* Setting employee list for Auto-Complete */
if ($this->authorizeObj->isAdmin()) {
$dataArr['empList'] = EmpInfo::getEmployeeMainDetails();
} elseif ($this->authorizeObj->isSupervisor()) {
$dataArr['empList'] = $this->_getSubsForAutoComplete($_SESSION['empID']);
}
$template = new TemplateMerger($dataArr, $path);
$template->display();
}
if (isset($this->postArr['cmbType'])) {
if ($this->postArr['cmbType'] == $arrEmpType[$c][0]) {
echo "<option selected=\"selected\" value='" . $arrEmpType[$c][0] . "'>" . $arrEmpType[$c][1] . "</option>";
$selectedEmpStatusValue = $arrEmpType[$c][0];
} else {
echo "<option value='" . $arrEmpType[$c][0] . "'>" . $arrEmpType[$c][1] . "</option>";
}
} elseif ($edit1[0][1] == $arrEmpType[$c][0]) {
echo "<option selected=\"selected\" value='" . $arrEmpType[$c][0] . "'>" . $arrEmpType[$c][1] . "</option>";
$selectedEmpStatusValue = $arrEmpType[$c][0];
} else {
echo "<option value='" . $arrEmpType[$c][0] . "'>" . $arrEmpType[$c][1] . "</option>";
}
}
if (count($arrEmpType) == 0) {
$empStatDefault = new EmploymentStatus();
$arrDisplayEmpStat = $empStatDefault->filterEmpStat(EmploymentStatus::EMPLOYMENT_STATUS_ID_TERMINATED);
echo "<option value='" . $arrDisplayEmpStat[0][0] . "'>" . $arrDisplayEmpStat[0][1] . "</option>";
}
?>
</select>
<input type="hidden" name="hidJobTitle" id="hidJobTitle" value="<?php
echo $selectedJobTitle;
?>
" />
<input type="hidden" name="hidType" id="hidType"value="<?php
echo $selectedEmpStatusValue;
?>
" />
</div>
<br class="clear" />
function reDirect($getArr, $postArr, $object = null)
{
$form_creator = new FormCreator($getArr, $postArr);
if ($_SESSION['isAdmin'] !== 'Yes') {
trigger_error("Unauthorized access", E_USER_NOTICE);
}
switch ($getArr['repcode']) {
case 'EMPDEF':
//if ()
$form_creator->formPath = '/templates/report/emprepinfo.php';
$form_creator->popArr['arrAgeSim'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
//$form_creator->popArr['arrEmpType']= array( 'Permanent', 'Expatriate', 'Contract', 'Temporary' , 'Others');
$form_creator->popArr['arrSerPer'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
$form_creator->popArr['arrJoiDat'] = array('Joined After' => '>', 'Joined Before' => '<', 'Joined In Between' => 'range');
$report = new EmpReport();
$empinfo = new EmpInfo();
$edu = new Education();
$jobtit = new JobTitle();
$salgrd = new SalaryGrades();
$empstat = new EmploymentStatus();
$langObj = new LanguageInfo();
$skillObj = new Skills();
$form_creator->popArr['grdlist'] = $salgrd->getSalGrdCodes();
$form_creator->popArr['edulist'] = $edu->getAllEducation();
$form_creator->popArr['deslist'] = $jobtit->getJobTit();
$form_creator->popArr['arrEmpType'] = $empstat->getEmpStat();
$form_creator->popArr['languageList'] = $langObj->getLang();
$form_creator->popArr['skillList'] = $skillObj->getSkillCodes();
if ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editArr'] = $edit = $report->filterReport($getArr['id']);
$criteria_value = explode('|', $edit[0][2]);
for ($c = 0; count($criteria_value) > $c; $c++) {
$crit_data = explode("=", $criteria_value[$c]);
$criteriaChkBox[$c] = $crit_data[0];
for ($d = 1; count($crit_data) > $d; $d++) {
$crit_form_data[$crit_data[0]][$d - 1] = $crit_data[$d];
}
}
$form_creator->popArr['editCriteriaChk'] = $criteriaChkBox;
$form_creator->popArr['editCriteriaData'] = $crit_form_data;
$form_creator->popArr['fieldList'] = explode('|', $edit[0][3]);
}
if ($object != null) {
$form_creator->popArr['empqual'] = $empqual->getQualifications($object->TypeCode);
}
break;
case 'EMPVIEW':
$report = new EmpReport();
$repgen = new ReportGenerator();
$form_creator->popArr['editArr'] = $edit = $report->filterReport($getArr['id']);
$repgen->repID = $edit[0][0];
$repgen->repName = $edit[0][1];
$criteria = explode('|', $edit[0][2]);
for ($c = 0; count($criteria) > $c; $c++) {
$crit_value = explode("=", $criteria[$c]);
$repgen->criteria[$crit_value[0]] = '';
for ($d = 1; count($crit_value) > $d; $d++) {
if ($d == count($crit_value) - 1) {
$repgen->criteria[$crit_value[0]] .= $crit_value[$d];
} else {
$repgen->criteria[$crit_value[0]] .= $crit_value[$d] . "|";
}
}
}
$field = explode('|', $edit[0][3]);
$empNoField = false;
for ($c = 0; count($field) > $c; $c++) {
$repgen->field[$field[$c]] = 1;
if ($field[$c] == 'EMPNO') {
$empNoField = true;
}
}
$repgen->field['EMPNO'] = 1;
$sqlQ = $repgen->reportQueryBuilder();
//echo $sqlQ."<br/>";
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQ);
$i = 0;
while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
for ($c = 0; count($repgen->field) * 2 > $c; $c += 2) {
$arrayDispList[$line[0]][$c / 2][$line[$c]] = $line[$c + 1];
}
$i++;
}
//print_r($arrayDispList);
if (!isset($arrayDispList)) {
$arrayDispList = null;
}
$repgen->reportDisplay($arrayDispList, $empNoField);
return;
break;
case 'RUG':
$form_creator->formPath = '/templates/report/repusg.php';
$emprepgroup = new EmpRepUserGroup();
$form_creator->popArr['repDet'] = $emprepgroup->getReportInfo();
$form_creator->popArr['usgAll'] = $emprepgroup->getAllUserGroups();
$form_creator->popArr['repUsgAss'] = $emprepgroup->getAssignedUserGroup($getArr['id']);
$form_creator->popArr['usgUnAss'] = $emprepgroup->getUnAssUserGroups($getArr['id']);
break;
}
$form_creator->display();
}
