function fetchJobSpecInfo($value)
{
$lan = new Language();
require $lan->getLangPath("full.php");
$jobTitle = new JobTitle();
$status = $jobTitle->getJobStatusFromTitle($value);
$stat[] = array(0 => '', 1 => '0', 2 => "-- {$lang_hremp_selempstat} --");
for ($i = 0; $i < count($status); $i++) {
$stat[] = $status[$i];
}
$status = $stat;
$view_controller = new ViewController();
$response = new xajaxResponse();
$xajaxFiller = new xajaxElementFiller();
$objResponse = $xajaxFiller->cmbFillerById($response, $status, 1, 'frmEmp.empstatpp', 'cmbType');
$jobSpec = $view_controller->getJobSpecForJob($value);
if (empty($jobSpec)) {
$jobSpecName = '';
$jobSpecDuties = '';
} else {
$jobSpecName = CommonFunctions::escapeHtml($jobSpec->getName());
$jobSpecDuties = nl2br(CommonFunctions::escapeHtml($jobSpec->getDuties()));
}
$response->addAssign('jobSpecName', 'innerHTML', $jobSpecName);
$response->addAssign('jobSpecDuties', 'innerHTML', $jobSpecDuties);
$response->addAssign('status', 'innerHTML', '');
$response->addScript('reselectEmpStatus();');
return $response->getXML();
}
public function save()
{
$resultArray = array();
$jobTitle = $this->getValue('jobTitle');
$jobDescription = $this->getValue('jobDescription');
$note = $this->getValue('note');
$jobSpec = $this->getValue('jobSpec');
$jobSpecUpdate = $this->getValue('jobSpecUpdate');
if (!empty($this->jobTitleId)) {
$jobTitleObj = $this->getJobTitleService()->getJobTitleById($this->jobTitleId);
$attachment = $jobTitleObj->getJobSpecificationAttachment();
if (!empty($attachment) && $jobSpecUpdate != self::CONTRACT_KEEP) {
$attachment->delete();
}
$resultArray['messageType'] = 'success';
$resultArray['message'] = __(TopLevelMessages::UPDATE_SUCCESS);
} else {
$jobTitleObj = new JobTitle();
$resultArray['messageType'] = 'success';
$resultArray['message'] = __(TopLevelMessages::SAVE_SUCCESS);
}
$jobTitleObj->setJobTitleName($jobTitle);
$jobTitleObj->setJobDescription($jobDescription);
$jobTitleObj->setNote($note);
if (!empty($jobSpec)) {
$jobTitleObj->setJobSpecificationAttachment($this->__getJobSpecAttachmentObj());
} else {
$jobTitleObj->setJobSpecificationAttachment(null);
}
$jobTitleObj->save();
return $resultArray;
}
public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
JobTitle::create([]);
}
}
private function _getAllJobTitles()
{
$jobTitle = new JobTitle();
$kpiDefinedJobTitles = $jobTitle->getJobTitlesDefined();
if (empty($kpiDefinedJobTitles)) {
$choices = array('-1' => '- Select -');
} else {
foreach ($kpiDefinedJobTitles as $key => $val) {
foreach ($val as $jobTitleId => $jobTitleName) {
$arrFinal[$jobTitleId] = $jobTitleName;
}
}
$choices = array('-1' => '- Select -') + $arrFinal;
}
return $choices;
}
public function actionAjaxGetJobTitles()
{
if (isset($_POST['jobCat'])) {
$titles = CHtml::listData(JobTitle::getAllTitlesByCategory($_POST['jobCat']), 'job_title_id', 'job_title_name');
echo '<option value="">' . Yii::t('model', 'viewStudentJobTitle.jobTitles_empty') . '</option>';
foreach ($titles as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
}
public function configure()
{
$jobTitle = new JobTitle();
$kpiDefinedJobTitles = $jobTitle->getJobTitlesDefined();
if (empty($kpiDefinedJobTitles)) {
$choices = array('-1' => '- Select -');
} else {
foreach ($kpiDefinedJobTitles as $key => $val) {
foreach ($val as $jobTitleId => $jobTitleName) {
$arrFinal[$jobTitleId] = $jobTitleName;
}
}
$choices = array('-1' => '- Select -') + $arrFinal;
}
$this->setWidgets(array('JobTitle' => new sfWidgetFormDoctrineChoice(array('model' => 'JobTitle', 'add_empty' => '- Select -')), 'JobTitleFrom' => new sfWidgetFormSelect(array('choices' => $choices)), 'KpiDescription' => new sfWidgetFormTextarea(), 'MinRate' => new sfWidgetFormInputText(), 'MaxRate' => new sfWidgetFormInputText(), 'DefaultScale' => new sfWidgetFormInputCheckbox(), 'isCopy' => new sfWidgetFormInputHidden(), 'KpiId' => new sfWidgetFormInputHidden()));
$this->widgetSchema->setNameFormat('empdefinekpi[%s]');
$this->setValidators(array('JobTitle' => new sfValidatorDoctrineChoice(array('model' => 'JobTitle', 'column' => 'jobtit_code ', 'required' => true), array('required' => 'Please select Job Title')), 'JobTitleFrom' => new sfValidatorString(array('required' => false)), 'KpiDescription' => new sfValidatorString(array('required' => true, 'max_length' => 200), array('required' => 'Please enter KPI description', 'max_length' => 'Please enter KPI description less than 200 characters')), 'MinRate' => new sfValidatorNumber(array('required' => false)), 'MaxRate' => new sfValidatorNumber(array('required' => false)), 'DefaultScale' => new sfValidatorString(array('required' => false)), 'isCopy' => new sfValidatorString(array('required' => false)), 'KpiId' => new sfValidatorString(array('required' => false))));
$this->validatorSchema->setPostValidator(new sfValidatorCallback(array('callback' => array($this, 'checkMinMaxRates'))));
}
/**
* Parse common data for edit and update
* @return JobTitle object
*/
private function _parseCommonData($postArr)
{
$jobTitle = new JobTitle();
$jobTitle->setJobName(CommonFunctions::escapeHtml(trim($postArr['txtJobTitleName'])));
$jobTitle->setJobDesc(CommonFunctions::escapeHtml(trim($postArr['txtJobTitleDesc'])));
$jobTitle->setJobComm(CommonFunctions::escapeHtml(trim($postArr['txtJobTitleComments'])));
$jobTitle->setJobSalGrd(trim($postArr['cmbPayGrade']));
$jobSpecId = trim($postArr['cmbJobSpecId']);
if (CommonFunctions::isValidId($jobSpecId)) {
$jobTitle->setJobSpecId($jobSpecId);
}
return $jobTitle;
}
/**
* Get the job spec for the given job title
* @param String $jobTitleCode The job title code
* @return JobSpec JobSpec object or null if no job spec assigned for given job title
*/
public function getJobSpecForJob($jobTitleCode)
{
$jobSpec = null;
if (CommonFunctions::isValidId($jobTitleCode, 'JOB')) {
$jobTitle = new JobTitle();
$jobTitles = $jobTitle->filterJobTitles($jobTitleCode);
if (is_array($jobTitles) && count($jobTitles) == 1) {
$jobSpecId = $jobTitles[0][5];
try {
$jobSpec = JobSpec::getJobSpec($jobSpecId);
} catch (JobSpecException $ex) {
// ignore, we will be returning null
}
}
}
return $jobSpec;
}
function reDirect($getArr, $postArr, $object = null)
{
$form_creator = new FormCreator($getArr, $postArr);
switch ($getArr['reqcode']) {
case 'JSP':
$form_creator->formPath = '/templates/hrfunct/hrempjobspec.php';
$ejobsp = new EmpJobSpec();
$empinfo = new EmpInfo();
$jdcat = new JDCategory();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['catlist'] = $jdcat->getJDCatCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $ejobsp->filterEmpJobSpec($arr);
} else {
$form_creator->popArr['unasscatlist'] = $jdcat->getUnAssJDCatCodes($getArr['id']);
}
$form_creator->popArr['rset'] = $ejobsp->getAssEmpJobSpec($getArr['id']);
//$form_creator ->popArr['catlist']=$ejobsp->getJDCatCodes();
break;
case 'CXT':
$form_creator->formPath = '/templates/hrfunct/hrempconext.php';
$empconext = new EmpConExt();
$empinfo = new EmpInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['empstat'] = $empinfo->filterEmpJobStat($getArr['id']);
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empconext->filterConExt($arr);
$form_creator->popArr['lastrec'] = $empconext->getLastRecord($getArr['id']);
} else {
$form_creator->popArr['lastrec'] = $empconext->getLastRecord($getArr['id']);
}
$form_creator->popArr['rset'] = $empconext->getAssConExt($getArr['id']);
break;
case 'SAL':
$form_creator->formPath = '/templates/hrfunct/hrempbassal.php';
$empinfo = new EmpInfo();
$empbassal = new EmpBasSalary();
$currTyp = new CurrencyTypes();
$form_creator->popArr['einfo'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['empdet'] = $empdet = $empinfo->filterEmpJobInfo($getArr['id']);
$salGrd = $empdet[0][5];
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $edit = $empbassal->filterEmpBasSal($arr);
$form_creator->popArr['currlist'] = $empbassal->getCurrCodes($edit[0][1]);
} else {
$form_creator->popArr['curlist'] = $empbassal->getUnAssCurrCodes($salGrd, $getArr['id']);
if ($object != null) {
$form_creator->popArr['cmbCurrCode'] = $object->cmbCurrCode;
}
}
$form_creator->popArr['rset'] = $empbassal->getAssEmpBasSal($getArr['id']);
$form_creator->popArr['currAlllist'] = $currTyp->getAllCurrencyCodes();
break;
case 'LAN':
$form_creator->formPath = '/templates/hrfunct/hremplan.php';
$empinf = new EmpInfo();
$emplan = new EmpLanguage();
$laninfo = new LanguageInfo();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['lanlist'] = $lanlist = $laninfo->getLang();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $emplan->filterEmpLang($arr);
for ($c = 0; count($lanlist) > $c; $c++) {
if ($getArr['editID1'] == $lanlist[$c][0]) {
$ratSel = $lanlist[$c][2];
}
}
} else {
if ($object != null) {
$form_creator->popArr['cmbLanCode'] = $object->cmbLanCode;
for ($c = 0; $lanlist && count($lanlist) > $c; $c++) {
if ($lanlist[$c][0] == $object->cmbLanCode) {
$ratSel = $lanlist[$c][2];
}
}
$form_creator->popArr['ratSel'] = $ratSel;
}
$form_creator->popArr['lanlist'] = $laninfo->getLang();
}
$form_creator->popArr['rsets'] = $emplan->getAssEmpLang($getArr['id']);
break;
case 'MEM':
$form_creator->formPath = '/templates/hrfunct/hrempmemship.php';
$empinf = new EmpInfo();
$empmem = new EmpMembership();
$memtype = new MembershipType();
$memshipinfo = new MembershipInfo();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $edit = $empmem->filterEmpMembership($arr);
$form_creator->popArr['mship'] = $memshipinfo->getMembershipCodes($edit[0][2]);
} else {
if ($object != null) {
$form_creator->popArr['cmbMemTypeCode'] = $object->cmbMemTypeCode;
$form_creator->popArr['mship'] = $memshipinfo->getUnAssMembershipCodes($getArr['id'], $object->cmbMemTypeCode);
}
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
}
$form_creator->popArr['rset'] = $empmem->getAssEmpMembership($getArr['id']);
$form_creator->popArr['mshipAll'] = $memshipinfo->getAllMembershipCodes();
break;
case 'EXC':
$form_creator->formPath = '/templates/hrfunct/hrempextcur.php';
$empinfo = new EmpInfo();
$empextcur = new EmpExCur();
$extracurr = new ExtraCurrActCat();
$extrainfo = new ExtraCurActInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['catlist'] = $extracurr->getExCurCatCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $edit = $empextcur->filterEmpExCur($arr);
$form_creator->popArr['typelist'] = $extrainfo->getExCurTypeCodes($edit[0][2]);
} else {
$form_creator->popArr['lastrec'] = $empextcur->getLastRecord($getArr['id']);
if ($object != null) {
$form_creator->popArr['cmbExtCurCat'] = $catcode = $object->cmbExtCurCat;
$form_creator->popArr['typeunasslist'] = $extrainfo->getUnAssExCurTypeCodes($getArr['id'], $catcode);
}
}
$form_creator->popArr['rset'] = $empextcur->getAssExCur($getArr['id']);
$form_creator->popArr['allcatlist'] = $extracurr->getExCurCatCodes();
$form_creator->popArr['alltypelist'] = $extrainfo->getAllExtraCurActInfo();
break;
case 'EXP':
$form_creator->formPath = '/templates/hrfunct/hrempwrkexp.php';
$empinfo = new EmpInfo();
$empworkex = new EmpWorkExp();
$countryinfo = new CountryInfo();
$proinfo = new ProvinceInfo();
$form_creator->popArr['empDet'] = $empinfo->filterEmpMain($getArr['id']);
if ($object != null) {
$form_creator->popArr['txtEmpExpCompany'] = $object->txtEmpExpCompany;
$form_creator->popArr['txtEmpExpToDat'] = $object->txtEmpExpToDat;
$form_creator->popArr['txtEmpExpDesOnLev'] = $object->txtEmpExpDesOnLev;
$form_creator->popArr['txtEmpExpYears'] = $object->txtEmpExpYears;
$form_creator->popArr['chkEmpExpWorkRelFlag'] = $object->chkEmpExpWorkRelFlag;
$form_creator->popArr['txtEmpExpMonths'] = $object->txtEmpExpMonths;
$form_creator->popArr['txtEmpExpAdd1'] = $object->txtEmpExpAdd1;
$form_creator->popArr['txtEmpExpAcc'] = $object->txtEmpExpAcc;
$form_creator->popArr['txtEmpExpAdd2'] = $object->txtEmpExpAdd2;
}
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $edit = $empworkex->filterEmpWorkExp($arr);
$form_creator->popArr['list'] = $countryinfo->getCountryCodes();
if ($object != null) {
$form_creator->popArr['txtEmpExpAdd2'] = $pli = $object->txtEmpExpAdd2;
$form_creator->popArr['txtEmpExpConPers'] = $object->txtEmpExpConPers;
$form_creator->popArr['txtEmpExpAdd3'] = $object->txtEmpExpAdd3;
$form_creator->popArr['txtEmpExpTelep'] = $object->txtEmpExpTelep;
$form_creator->popArr['txtEmpResLev'] = $object->txtEmpResLev;
$form_creator->popArr['txtEmpExpAchmnt'] = $object->txtEmpExpAchmnt;
$form_creator->popArr['txtEmpExpFromDat'] = $object->txtEmpExpFromDat;
$form_creator->popArr['txtEmpExpEmail'] = $object->txtEmpExpEmail;
$form_creator->popArr['plist'] = $empinfo->getProvinceCodes($pli);
} else {
$form_creator->popArr['plist1'] = $proinfo->getProvinceCodes($edit[0][4]);
}
} else {
$form_creator->popArr['newID'] = $empworkex->getLastRecord($getArr['id']);
$form_creator->popArr['list'] = $countryinfo->getCountryCodes();
if ($object != null) {
$form_creator->popArr['txtEmpExpCompany'] = $object->txtEmpExpCompany;
$form_creator->popArr['txtEmpExpToDat'] = $object->txtEmpExpToDat;
$form_creator->popArr['txtEmpExpDesOnLev'] = $object->txtEmpExpDesOnLev;
$form_creator->popArr['txtEmpExpYears'] = $object->txtEmpExpYears;
$form_creator->popArr['chkEmpExpWorkRelFlag'] = $object->chkEmpExpWorkRelFlag;
$form_creator->popArr['txtEmpExpMonths'] = $object->txtEmpExpMonths;
$form_creator->popArr['txtEmpExpAdd1'] = $object->txtEmpExpAdd1;
$form_creator->popArr['txtEmpExpAcc'] = $object->txtEmpExpAcc;
$form_creator->popArr['txtEmpExpTelep'] = $object->txtEmpExpTelep;
$form_creator->popArr['txtEmpResLev'] = $object->txtEmpResLev;
$form_creator->popArr['txtEmpExpAchmnt'] = $object->txtEmpExpAchmnt;
$form_creator->popArr['txtEmpExpFromDat'] = $object->txtEmpExpFromDat;
$form_creator->popArr['txtEmpExpEmail'] = $object->txtEmpExpEmail;
$form_creator->popArr['txtEmpExpAdd2'] = $plis = $object->txtEmpExpAdd2;
$form_creator->popArr['txtEmpExpAdd3'] = $object->txtEmpExpAdd3;
$form_creator->popArr['txtEmpExpConPers'] = $object->txtEmpExpConPers;
$form_creator->popArr['plist2'] = $empinfo->getProvinceCodes($plis);
}
}
$form_creator->popArr['rset'] = $empworkex->getAssEmpWorkExp($getArr['id']);
break;
case 'QUA':
$form_creator->formPath = '/templates/hrfunct/hrempqual.php';
$empinfo = new EmpInfo();
$empqual = new EmpQualification();
$qualtyp = new QualificationType();
$qual = new Qualifications();
$form_creator->popArr['statlist'] = array('First Class', 'Second Class Upr.', 'Second Class Lwr.');
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['typlist'] = $qualtyp->getQualificationTypeCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['editID'];
$arr[1] = $getArr['id'];
$form_creator->popArr['editArr'] = $empqual->filterEmpQual($arr);
$form_creator->popArr['quallist'] = $qual->getAllQualifications();
} else {
if ($object != null) {
$form_creator->popArr['TypeCode'] = $object->TypeCode;
$form_creator->popArr['mship'] = $qual->getUnAssQualifications($getArr['id'], $object->TypeCode);
}
}
$form_creator->popArr['rset'] = $empqual->getAssEmpQual($getArr['id']);
$form_creator->popArr['allquallist'] = $qual->getAllQualifications();
break;
case 'QAS':
$form_creator->formPath = '/templates/hrfunct/hrempqualsub.php';
$empinfo = new EmpInfo();
$qual = new Qualifications();
$empqualsub = new EmpQualSubject();
$subinfo = new SubjectInfo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['qualDet'] = $qual->filterQualifications($getArr['QUA']);
$form_creator->popArr['sublistAll'] = $subinfo->getSubjectCodes($getArr['QUA']);
$form_creator->popArr['ratlist'] = $empqualsub->getRatGrds($getArr['QUA']);
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['QUA'];
$arr[2] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empqualsub->filterEmpQualSub($arr);
} else {
$form_creator->popArr['sublistUnAss'] = $subinfo->getUnAssSubjects($getArr['id'], $getArr['QUA']);
}
$arr[0] = $getArr['id'];
$arr[1] = $getArr['QUA'];
$form_creator->popArr['sublistAss'] = $empqualsub->getAssEmpQualSub($arr);
break;
case 'CBN':
$form_creator->formPath = '/templates/hrfunct/hrempcashben.php';
$empinfo = new EmpInfo();
$empcashben = new EmpCashBen();
$cashben = new CashBen();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['bfilter'] = array('Salary Point' => 1, 'Designation' => 2, 'Employee' => 3);
$form_creator->popArr['benlist'] = $cashben->getBenCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empcashben->filterEmpCashBen($arr);
}
$form_creator->popArr['cashbenAss'] = $empcashben->getAssEmpCashBen($getArr['id']);
$form_creator->popArr['cashbenUnAss'] = $empcashben->getUnAssEmpCashBen($getArr['id']);
if (isset($getArr['OBEN'])) {
$form_creator->popArr['cashbenOther'] = $cashben->getOthEmpCashBen($getArr['id']);
}
break;
case 'NBN':
$form_creator->formPath = '/templates/hrfunct/hrempnoncashben.php';
$empinfo = new EmpInfo();
$empnoncashben = new EmpNonCashBen();
$noncashben = new NonCashBen();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['bfilter'] = array('Salary Point' => 1, 'Designation' => 2, 'Employee' => 3);
$form_creator->popArr['benlist'] = $noncashben->getBenCodes();
if (isset($getArr['editID'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID'];
$form_creator->popArr['editArr'] = $empnoncashben->filterEmpNonCashBen($arr);
}
$form_creator->popArr['cashbenAss'] = $empnoncashben->getAssEmpNonCashBen($getArr['id']);
$form_creator->popArr['cashbenUnAss'] = $empnoncashben->getUnAssEmpNonCashBen($getArr['id']);
if (isset($getArr['OBEN'])) {
$form_creator->popArr['cashbenOther'] = $noncashben->getOthEmpNonCashBen($getArr['id']);
}
break;
case 'ESS':
case 'EMP':
$form_creator->formPath = '/templates/hrfunct/hrEmpMain.php';
//hremp.php';
$form_creator->popArr['arrMStat'] = array('Unmarried', 'Married', 'Divorced', 'Others');
$empinfo = new EmpInfo();
$pport = new EmpPassPort();
$ddebit = new EmpDirectDebit();
$dep = new EmpDependents();
$econ = new EmpEmergencyCon();
$chi = new EmpChildren();
$attachment = new EmpAttach();
$countryinfo = new CountryInfo();
$porinfo = new ProvinceInfo();
$nationinfo = new NationalityInfo();
$location = new models_eimadmin_Location();
$distric = new DistrictInfo();
$jobtit = new JobTitle();
$depen = new EmpDependents();
$ethnicrace = new EthnicRace();
$eeojobcat = new EEOJobCat();
$emplan = new EmpLanguage();
$laninfo = new LanguageInfo();
$emplicen = new EmpLicenses();
$licen = new Licenses();
$empmem = new EmpMembership();
$memtype = new MembershipType();
$memshipinfo = new MembershipInfo();
$emprepto = new EmpRepTo();
$empskill = new EmpSkill();
$skill = new Skills();
$empworkex = new EmpWorkExp();
$empeducation = new EmpEducation();
$education = new Education();
$empTax = new EmpTax();
$form_creator->popArr['nation'] = $nationinfo->getNationCodes();
$form_creator->popArr['loc'] = $location->getLocCodes();
$form_creator->popArr['cntlist'] = $countryinfo->getCountryCodes();
$form_creator->popArr['ethRace'] = $ethnicrace->getEthnicRaceCodes();
$form_creator->popArr['eeojobcat'] = $eeojobcat->getEEOJobCatCodes();
$form_creator->popArr['jobtit'] = $jobtit->getJobTit();
$form_creator->popArr['hier'] = isset($res) ? $res : false;
$form_creator->popArr['cntlist'] = $countrylist = $countryinfo->getCountryCodes();
$form_creator->popArr['ppcntlist'] = $countrylist;
$form_creator->popArr['customFieldList'] = CustomFields::getCustomFieldList();
if ($getArr['capturemode'] == 'addmode') {
$form_creator->popArr['newID'] = $empinfo->getLastId();
if ($object != null) {
$form_creator->popArr['ctlist'] = $corptit->getCorpTitlesEmpInfo($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $des->getDesEmpInfo($object->cmbCorpTit);
$form_creator->popArr['plist'] = $porinfo->getProvinceCodes($object->cmbTaxCountry);
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($object->cmbPermProvince);
if (isset($postArr['cmbJobTitle'])) {
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($postArr['cmbJobTitle'], 'JOB', 'allEmpStat');
}
$form_creator->popArr['ethRace'] = $ethnicrace->getEthnicRaceCodes($object->cmbEthnicRace);
}
} elseif ($getArr['capturemode'] == 'updatemode') {
$form_creator->popArr['editTaxInfo'] = $empTax->getEmployeeTaxInfo($getArr['id']);
$form_creator->popArr['usStateList'] = $porinfo->getProvinceCodes('US');
$form_creator->popArr['empDDAss'] = $ddebit->getEmployeeDirectDebit($getArr['id']);
if (isset($getArr['DDSEQ'])) {
$form_creator->popArr['editDDForm'] = $ddebit->getDirectDebit($getArr['id'], $getArr['DDSEQ']);
}
$form_creator->popArr['editMainArr'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['editPersArr'] = $empinfo->filterEmpPers($getArr['id']);
$form_creator->popArr['editJobInfoArr'] = $empJobInfo = $empinfo->filterEmpJobInfo($getArr['id']);
$form_creator->popArr['editCustomInfoArr'] = $empCustomInfo = $empinfo->filterEmpCustomInfo($getArr['id']);
$view_controller = new ViewController();
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($empJobInfo[0][2], 'JOB', 'allEmpStat');
$empJobTitle = $empJobInfo[0][2];
if (isset($postArr['cmbJobTitle'])) {
$form_creator->popArr['empstatlist'] = $view_controller->xajaxObjCall($postArr['cmbJobTitle'], 'JOB', 'allEmpStat');
$empJobTitle = $postArr['cmbJobTitle'];
}
if (CommonFunctions::isValidId($empJobTitle, 'JOB')) {
$empJobSpec = $view_controller->getJobSpecForJob($empJobTitle);
} else {
$empJobSpec = null;
}
$form_creator->popArr['jobSpec'] = $empJobSpec;
$jobTitleHistory = new JobTitleHistory();
$form_creator->popArr['jobTitleHistory'] = $jobTitleHistory->getHistory($getArr['id']);
$empDivisionHistory = new SubDivisionHistory();
$form_creator->popArr['subDivisionHistory'] = $empDivisionHistory->getHistory($getArr['id']);
$locationHistory = new LocationHistory();
$form_creator->popArr['locationHistory'] = $locationHistory->getHistory($getArr['id']);
$form_creator->popArr['assignedlocationList'] = EmpLocation::getEmpLocations($getArr['id']);
$form_creator->popArr['availablelocationList'] = EmpLocation::getUnassignedLocations($getArr['id']);
$form_creator->popArr['editPermResArr'] = $edit = $editPermRes = $empinfo->filterEmpContact($getArr['id']);
$form_creator->popArr['provlist'] = $porinfo->getProvinceCodes($edit[0][4]);
$form_creator->popArr['citylist'] = $distric->getDistrictCodes($edit[0][5]);
$form_creator->popArr['empPPAss'] = $pport->getAssEmpPP($getArr['id']);
$form_creator->popArr['empDepAss'] = $dep->getAssEmpDep($getArr['id']);
$form_creator->popArr['empECAss'] = $econ->getAssEmpEC($getArr['id']);
$form_creator->popArr['empChiAss'] = $chi->getAssEmpChi($getArr['id']);
$form_creator->popArr['empAttAss'] = $attachment->getAssEmpAtt($getArr['id']);
$form_creator->popArr['empDpAss'] = $depen->getAssEmpDep($getArr['id']);
$form_creator->popArr['newPPID'] = $pport->getLastRecord($getArr['id']);
if (isset($getArr['PPSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['PPSEQ'];
$form_creator->popArr['editPPForm'] = $pport->filterEmpPP($arr);
}
$form_creator->popArr['newECID'] = $econ->getLastRecord($getArr['id']);
if (isset($getArr['ECSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['ECSEQ'];
$form_creator->popArr['editECForm'] = $econ->filterEmpEC($arr);
}
$form_creator->popArr['newDepID'] = $dep->getLastRecord($getArr['id']);
if (isset($getArr['depSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['depSEQ'];
$form_creator->popArr['editDepForm'] = $dep->filterEmpDep($arr);
}
$form_creator->popArr['newCID'] = $chi->getLastRecord($getArr['id']);
if (isset($getArr['CHSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['CHSEQ'];
$form_creator->popArr['editChiForm'] = $chi->filterEmpChi($arr);
}
if (isset($getArr['ATTACH'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['ATTACH'];
$form_creator->popArr['editAttForm'] = $attachment->filterEmpAtt($arr);
}
$form_creator->popArr['lantype'] = array('Writing' => 1, 'Speaking' => 2, 'Reading' => 3);
$form_creator->popArr['grdcodes'] = array('Poor' => 1, 'Basic' => 2, 'Good' => 3, 'Mother Tongue' => 4);
$form_creator->popArr['lanlist'] = $lanlist = $laninfo->getLang();
if (isset($getArr['lanSEQ'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['lanSEQ'];
$arr[2] = $getArr['lanFLU'];
$form_creator->popArr['editLanArr'] = $emplan->filterEmpLang($arr);
}
$form_creator->popArr['rsetLang'] = $emplan->getAssEmpLang($getArr['id']);
$form_creator->popArr['allLicenlist'] = $licenlist = $licen->getLicensesCodes();
$form_creator->popArr['unassLicenlist'] = $licen->getUnAssLicensesCodes($getArr['id']);
if (isset($getArr['LIC'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['LIC'];
$form_creator->popArr['editLicenseArr'] = $emplicen->filterEmpLicenses($arr);
}
$form_creator->popArr['rsetLicense'] = $emplicen->getAssEmpLicenses($getArr['id']);
$form_creator->popArr['typlist'] = $typlist = $memtype->getMembershipTypeCodes();
if (isset($getArr['MEM'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['MEM'];
$arr[2] = $getArr['MTP'];
$form_creator->popArr['editMembershipArr'] = $edit = $empmem->filterEmpMembership($arr);
$form_creator->popArr['mship'] = $memshipinfo->getMembershipCodes($edit[0][2]);
}
$form_creator->popArr['rsetMembership'] = $empmem->getAssEmpMembership($getArr['id']);
$form_creator->popArr['mshipAll'] = $memshipinfo->getAllMembershipCodes();
$empbassal = new EmpBasSalary();
$currTyp = new CurrencyTypes();
$jobtit = new JobTitle();
$salgradelist = new SalaryGrades();
$form_creator->popArr['salgradelist'] = $salgradelist->getSalGrades(true);
$empdet = $empinfo->filterEmpJobInfo($getArr['id']);
$jt = $jobtit->filterJobTitles($empdet[0][2]);
$form_creator->popArr['payPeriodList'] = PayPeriod::getPayPeriodList();
$form_creator->popArr['salGrd'] = $salGrd = $empbassal->getEmpSalGrade($getArr['id']);
if (isset($getArr['PAY'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['PAY'];
$arr[2] = $getArr['CUR'];
$form_creator->popArr['editPaymentArr'] = $edit = $empbassal->filterEmpBasSal($arr);
$form_creator->popArr['salGrd'] = $salGrd = $edit[0][1];
$form_creator->popArr['currlist'] = $empbassal->getCurrCodes($edit[0][1]);
}
$form_creator->popArr['unAssCurrList'] = $empbassal->getUnAssCurrCodes($salGrd, $getArr['id']);
$form_creator->popArr['rsetPayment'] = $empbassal->getAssEmpBasSal($getArr['id']);
$form_creator->popArr['currAlllist'] = $currTyp->getAllCurrencyCodes();
$form_creator->popArr['suprset'] = $emprepto->getEmpSup($getArr['id']);
$form_creator->popArr['empname'] = $empinfo->getEmpInfo();
$form_creator->popArr['subrset'] = $emprepto->getEmpSub($getArr['id']);
if (isset($getArr['editIDSup'])) {
$arr[0] = $getArr['editIDSup'];
$arr[1] = $getArr['id'];
$arr[2] = $getArr['RepMethod'];
$form_creator->popArr['editIDSupInfo'] = $emprepto->filterEmpRepTo($arr);
}
if (isset($getArr['editIDSub'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editIDSub'];
$arr[2] = $getArr['RepMethod'];
$form_creator->popArr['editIDSubInfo'] = $emprepto->filterEmpRepTo($arr);
}
$form_creator->popArr['allSkilllist'] = $skill->getSkillCodes();
$form_creator->popArr['uskilllist'] = $skill->getUnAssSkillCodes($getArr['id']);
if (isset($getArr['SKILL'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['SKILL'];
$form_creator->popArr['editSkillArr'] = $empskill->filterEmpSkill($arr);
}
$form_creator->popArr['rsetSkill'] = $empskill->getAssEmpSkill($getArr['id']);
$form_creator->popArr['newWrkExpID'] = $empworkex->getLastRecord($getArr['id']);
if (isset($getArr['WRKEXP'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['WRKEXP'];
$form_creator->popArr['editWrkExpArr'] = $edit = $empworkex->filterEmpWorkExp($arr);
}
$form_creator->popArr['rsetWrkExp'] = $empworkex->getAssEmpWorkExp($getArr['id']);
$form_creator->popArr['allEduCodes'] = $education->getListofEducation(0, '', 0);
$form_creator->popArr['unAssEduCodes'] = $empeducation->getUnAssEduCodes($getArr['id']);
if (isset($getArr['EDU'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['EDU'];
$form_creator->popArr['editEducationArr'] = $empeducation->filterEmpEducation($arr);
}
$form_creator->popArr['rsetEducation'] = $empeducation->getAssEmpEducation($getArr['id']);
if ($object != null) {
$form_creator->popArr['ctlist'] = $corptit->getCorpTitlesEmpInfo($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $des->getDesEmpInfo($object->cmbCorpTit);
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($object->cmbPermProvince);
$form_creator->popArr['brchlist'] = $brch->getUnAssBranchCodes($getArr['id'], $object->cmbBank);
$form_creator->popArr['ctlist'] = $empinfo->getCorpTitles($object->cmbSalGrd);
$form_creator->popArr['deslist'] = $empinfo->getDes($object->cmbCorpTit);
$form_creator->popArr['resplist'] = $empinfo->getProvinceCodes($object->cmbPermCountry);
$form_creator->popArr['resdlist'] = $empinfo->getDistrictCodes($object->cmbPermProvince);
$form_creator->popArr['brchlist'] = $brch->getUnAssBranchCodes($getArr['id'], $object->cmbBank);
} else {
$form_creator->popArr['resplist'] = $porinfo->getProvinceCodes($editPermRes[0][10]);
$form_creator->popArr['resdlist'] = $distric->getDistrictCodes($editPermRes[0][11]);
}
$empconext = new EmpConExt();
$form_creator->popArr['newConExtID'] = $empconext->getLastRecord($getArr['id']);
if (isset($getArr['CONEXT'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['CONEXT'];
$form_creator->popArr['editConExtArr'] = $empconext->filterConExt($arr);
}
$form_creator->popArr['rsetConExt'] = $empconext->getAssConExt($getArr['id']);
}
break;
case 'REP':
$form_creator->formPath = '/templates/hrfunct/hremprepto.php';
$empinfo = new EmpInfo();
$emprepto = new EmpRepTo();
$form_creator->popArr['empdet'] = $empinfo->filterEmpMain($getArr['id']);
$form_creator->popArr['suprset'] = $emprepto->getEmpSup($getArr['id']);
$form_creator->popArr['empname'] = $empinfo->getEmpInfo();
$form_creator->popArr['subrset'] = $emprepto->getEmpSub($getArr['id']);
if (isset($getArr['editIDSup'])) {
$arr[0] = $getArr['editIDSup'];
$arr[1] = $getArr['id'];
$arr[2] = $getArr['repmethod'];
$form_creator->popArr['editIDSupInfo'] = $emprepto->filterEmpRepTo($arr);
}
if (isset($getArr['editIDSub'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editIDSub'];
$arr[2] = $getArr['repmethod'];
$form_creator->popArr['editIDSubInfo'] = $emprepto->filterEmpRepTo($arr);
}
break;
case 'SKI':
$form_creator->formPath = '/templates/hrfunct/hrempskill.php';
$empinf = new EmpInfo();
$empskill = new EmpSkill();
$skill = new Skills();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['allSkilllist'] = $skill->getSkillCodes();
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $empskill->filterEmpSkill($arr);
} else {
$form_creator->popArr['uskilllist'] = $skill->getUnAssSkillCodes($getArr['id']);
}
$form_creator->popArr['rsets'] = $empskill->getAssEmpSkill($getArr['id']);
break;
case 'LIC':
$form_creator->formPath = '/templates/hrfunct/hremplicenses.php';
$empinf = new EmpInfo();
$emplicen = new EmpLicenses();
$licen = new Licenses();
$form_creator->popArr['empDet'] = $empinf->filterEmpMain($getArr['id']);
$form_creator->popArr['allLicenlist'] = $licenlist = $licen->getLicensesCodes();
$form_creator->popArr['unassLicenlist'] = $licen->getUnAssLicensesCodes($getArr['id']);
if (isset($getArr['editID1'])) {
$arr[0] = $getArr['id'];
$arr[1] = $getArr['editID1'];
$arr[2] = $getArr['editID2'];
$form_creator->popArr['editArr'] = $emplicen->filterEmpLicenses($arr);
}
$form_creator->popArr['rsets'] = $emplicen->getAssEmpLicenses($getArr['id']);
break;
}
$form_creator->display();
}
require_once 'util/session.php';
require_once 'swwat/gizmos/parse.php';
$expo = getExpoCurrent();
if (isset($_POST[PARAM_SAVE])) {
$expo->title = swwat_parse_string(html_entity_decode($_POST[PARAM_TITLE]), true);
$expo->description = swwat_parse_string(html_entity_decode($_POST[PARAM_DESCRIPTION]), true);
$expo->expoHourCeiling = swwat_parse_string(html_entity_decode($_POST[PARAM_MAXHOURS]), true);
$expo->startTime = swwat_parse_date(html_entity_decode($_POST[PARAM_STARTTIME]), true);
$expo->stopTime = swwat_parse_date(html_entity_decode($_POST[PARAM_STOPTIME]), true);
$expo->scheduleAssignAsYouGo = isset($_POST[PARAM_SCHEDULE_ALGO]);
$expo->scheduleVisible = isset($_POST[PARAM_SCHEDULE_PUBLISH]);
$expo->allowScheduleTimeConflict = isset($_POST[PARAM_SCHEDULE_TIME_CONFLICT]);
$expo->newUserAddedOnRegistration = isset($_POST[PARAM_NEWUSER_ADDED_ON_REGISTRATION]);
if (is_null($expo->expoid)) {
$expo->insert();
$jobTitle = new JobTitle();
$jobTitle->expoid = $expo->expoid;
$jobTitle->jobTitle = 'Crew';
$jobTitle->insert();
} else {
$expo->update();
}
setExpoCurrent($expo);
// if saved
header('Location: ExpoViewPage.php');
include 'ExpoViewPage.php';
return;
}
// else, if not saved
header('Location: SiteAdminPage.php');
include 'SiteAdminPage.php';
// ok, start the html
include 'section/header.php';
?>
<div id="main">
<?php
if (!is_null($expo->expoid)) {
include 'section/LinkExpo.php';
}
?>
<div id="jobtitlepage_jobtitledata">
<form method="POST" id="jobtitlepage_jobtitledata">
<table>
<?php
$jobTitle = JobTitle::selectExpo($expo->expoid);
$cnt = count($jobTitle);
echo "<tr><td rowspan=\"" . ($cnt + 1) . "\" valign=\"top\">Job Title: </td>\n";
for ($j = 0; $j < $cnt; $j++) {
if (!strcmp($jobTitle[$j]->jobTitle, 'Crew')) {
echo "<td><input type=\"text\" name=\"" . PARAM_TITLE . $j . "\" value=\"" . $jobTitle[$j]->jobTitle . "\" disabled=\"disabled\" /></td>\n";
echo "<td></td>\n";
echo "<td></td>\n";
echo "</tr>\n";
}
}
for ($j = 0; $j < $cnt; $j++) {
if (strcmp($jobTitle[$j]->jobTitle, 'Crew')) {
echo "<tr>\n";
echo "<td><input type=\"text\" name=\"" . PARAM_TITLE . $j . "\" value=\"" . $jobTitle[$j]->jobTitle . "\" />";
echo "<input type=\"hidden\" name=\"" . PARAM_TITLE . $j . "_old\" value=\"" . $jobTitle[$j]->jobTitle . "\" /></td>\n";
@extends('layouts.admin.default')
@section('content')
<?php
$jobTitleCount = JobTitle::count();
$jobTitles = JobTitle::paginate(10);
$jobTitleDelete = JobTitle::find($id);
$message = Session::get('message');
?>
<div class="page-container">
<div class="row" style="padding-bottom:20px;">
<div class="col-md-2 clearfix">
<aside class="sidebar">
<nav class="sidebar-nav">
<ul id="menu">
<li>
<a href="{{ url('/admin/dashboard') }}">
<span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span>
<span class="sidebar-nav-item">Dashboard</span>
</a>
</li>
<li>
<a href="#">
<span class="sidebar-nav-item-icon fa fa-users fa-lg"></span>
<span class="sidebar-nav-item">Employees</span>
$ADODB_ASSOC_CASE = 2;
$user = getSessionObject('user');
include APP_BASE_PATH . "classes/BaseService.php";
include APP_BASE_PATH . "classes/FileService.php";
include APP_BASE_PATH . "classes/SubActionManager.php";
include APP_BASE_PATH . "classes/AbstractInitialize.php";
include APP_BASE_PATH . "classes/SettingsManager.php";
include APP_BASE_PATH . "classes/EmailSender.php";
include APP_BASE_PATH . "mysql_error_list.php";
include APP_BASE_PATH . "model/models.inc.php";
$dbLocal = NewADOConnection(APP_CON_STR);
CompanyStructure::SetDatabaseAdapter($dbLocal);
Country::SetDatabaseAdapter($dbLocal);
Province::SetDatabaseAdapter($dbLocal);
CurrencyType::SetDatabaseAdapter($dbLocal);
JobTitle::SetDatabaseAdapter($dbLocal);
ChucVu::SetDatabaseAdapter($dbLocal);
PayGrade::SetDatabaseAdapter($dbLocal);
EmploymentStatus::SetDatabaseAdapter($dbLocal);
Skill::SetDatabaseAdapter($dbLocal);
Education::SetDatabaseAdapter($dbLocal);
Certification::SetDatabaseAdapter($dbLocal);
Language::SetDatabaseAdapter($dbLocal);
Nationality::SetDatabaseAdapter($dbLocal);
Employee::SetDatabaseAdapter($dbLocal);
User::SetDatabaseAdapter($dbLocal);
EmployeeSkill::SetDatabaseAdapter($dbLocal);
EmployeeEducation::SetDatabaseAdapter($dbLocal);
EmployeeCertification::SetDatabaseAdapter($dbLocal);
EmployeeLanguage::SetDatabaseAdapter($dbLocal);
EmergencyContact::SetDatabaseAdapter($dbLocal);
function createExpoDataHTMLRows(Expo $expo, $formName, $isDisabledFlag = TRUE)
{
if (!is_null($expo)) {
if (!is_null($expo->startTime)) {
$_POST[PARAM_STARTTIME] = htmlspecialchars(swwat_format_isodate($expo->startTime));
} else {
$_POST[PARAM_STARTTIME] = htmlspecialchars($expo->startTime);
}
if (!is_null($expo->stopTime)) {
$_POST[PARAM_STOPTIME] = htmlspecialchars(swwat_format_isodate($expo->stopTime));
} else {
$_POST[PARAM_STOPTIME] = htmlspecialchars($expo->stopTime);
}
$_POST[PARAM_MAXHOURS] = htmlspecialchars($expo->expoHourCeiling);
$_POST[PARAM_TITLE] = htmlspecialchars($expo->title);
$_POST[PARAM_DESCRIPTION] = htmlspecialchars($expo->description);
$_POST[PARAM_SCHEDULE_ALGO] = $expo->scheduleAssignAsYouGo;
$_POST[PARAM_SCHEDULE_PUBLISH] = $expo->scheduleVisible;
$_POST[PARAM_SCHEDULE_TIME_CONFLICT] = $expo->allowScheduleTimeConflict;
$_POST[PARAM_NEWUSER_ADDED_ON_REGISTRATION] = $expo->newUserAddedOnRegistration;
}
echo "<table>\n";
echo " <tr>\n";
echo " <td>\n";
echo " <table>\n";
echo " <tr><td class='fieldTitle'>Title:</td>\n<td>";
swwat_createInputValidateLength(PARAM_TITLE, $formName, 'titleCheck', 255, $isDisabledFlag);
echo "</td></tr>\n";
echo " <tr><td class='fieldTitle'>Description:</td>\n<td>";
swwat_createInputValidateLength(PARAM_DESCRIPTION, $formName, 'descriptionCheck', 255, $isDisabledFlag);
echo "</td></tr>\n";
echo " <tr><td class='fieldTitle'>Max Hours:</td>\n<td>";
swwat_createInputValidateLength(PARAM_MAXHOURS, $formName, 'maxhoursCheck', 255, $isDisabledFlag);
echo "</td></tr>\n";
echo " <tr><td class='fieldTitle'>Start:</td>\n<td>";
echo '<input type="text" id="', PARAM_STARTTIME, '" name="', PARAM_STARTTIME, '" value="', $_POST[PARAM_STARTTIME], '" readonly="readonly" size="25" ';
if ($isDisabledFlag) {
echo ' disabled="disabled" ';
}
echo "/></td></tr>\n";
echo " <tr><td class='fieldTitle'>Stop:</td>\n<td>";
echo '<input type="text" id="', PARAM_STOPTIME, '" name="', PARAM_STOPTIME, '" value="', $_POST[PARAM_STOPTIME], '" readonly="readonly" size="25" ';
if ($isDisabledFlag) {
echo ' disabled="disabled" ';
}
echo "/></td></tr>\n";
echo " <tr><td class='fieldTitle'>Assign As You Go:</td>\n<td>\n";
swwat_createRadioOption(PARAM_SCHEDULE_ALGO, array(PARAM_SCHEDULE_ALGO, ""), SWWAT_CHECKBOX, $_POST[PARAM_SCHEDULE_ALGO], $isDisabledFlag);
echo "</td></tr>\n";
echo " <tr><td class='fieldTitle'>Publish Schedule:</td>\n<td>";
swwat_createRadioOption(PARAM_SCHEDULE_PUBLISH, array(PARAM_SCHEDULE_PUBLISH, ""), SWWAT_CHECKBOX, $_POST[PARAM_SCHEDULE_PUBLISH], $isDisabledFlag);
echo "</td></tr>\n";
echo " <tr><td class='fieldTitle'>Allow Time Conflicts:</td>\n<td>\n";
swwat_createRadioOption(PARAM_SCHEDULE_TIME_CONFLICT, array(PARAM_SCHEDULE_TIME_CONFLICT, ""), SWWAT_CHECKBOX, $_POST[PARAM_SCHEDULE_TIME_CONFLICT], $isDisabledFlag);
echo "</td></tr>\n";
echo " <tr><td class='fieldTitle'>New User Added on Registration:</td>\n<td>\n";
swwat_createRadioOption(PARAM_NEWUSER_ADDED_ON_REGISTRATION, array(PARAM_NEWUSER_ADDED_ON_REGISTRATION, ""), SWWAT_CHECKBOX, $_POST[PARAM_NEWUSER_ADDED_ON_REGISTRATION], $isDisabledFlag);
echo "</td></tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " <td valign=\"top\" style=\"padding-left: 150px;\">\n";
echo " <table>\n";
$jobTitle = JobTitle::selectExpo($expo->expoid);
for ($j = 0; $j < count($jobTitle); $j++) {
if ($j == 0) {
echo " <tr><td class='fieldTitle'>Job Titles:</td><td style=\"font-size: 10pt;\">" . $jobTitle[$j]->jobTitle . "</td></tr>\n";
} else {
echo " <tr><td></td><td style=\"font-size: 10pt;\">" . $jobTitle[$j]->jobTitle . "</td></tr>\n";
}
}
echo " </table>\n";
echo " </td>\n";
echo " </tr>\n";
echo "</table>\n";
}
/**
* 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;
}
/**
* View vacancy
* @param int $id Id of vacancy. If empty, A new vacancy is shown
*/
private function _viewVacancy($id = null)
{
$path = '/templates/recruitment/jobVacancy.php';
try {
if (empty($id)) {
$vacancy = new JobVacancy();
} else {
$vacancy = JobVacancy::getJobVacancy($id);
}
$empInfo = new EmpInfo();
$jobTitle = new JobTitle();
$jobTitles = $jobTitle->getJobTit();
$objs['vacancy'] = $vacancy;
$objs['manager'] = $vacancy->getManagerName();
$objs['noOfEmployees'] = $empInfo->countEmployee();
$objs['employeeSearchList'] = $this->_getEmployeeSearchList();
$objs['jobTitles'] = is_array($jobTitles) ? $jobTitles : array();
$template = new TemplateMerger($objs, $path);
$template->display();
} catch (JobVacancyException $e) {
$message = 'UNKNOWN_FAILURE';
$this->redirect($message);
}
}
public function deleteJobTitle()
{
$id = Input::get('id');
JobTitle::where('id', '=', $id)->delete();
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = JobTitle::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Test case for filterJobTitles()
*/
public function testFilterJobTitles()
{
// retrieve job title with job spec defined
$jobTitle = new JobTitle();
$result = $jobTitle->filterJobTitles('JOB002');
$this->_validateJobTitle($result, 'JOB002', 'Typist', 'Typist Desc', 'Typist comments', 'SAL002', 1);
// retrieve job title without job spec defined
$result = $jobTitle->filterJobTitles('JOB001');
$this->_validateJobTitle($result, 'JOB001', 'Driver', 'Driver Desc', 'Driver comments', 'SAL002', null);
}
public function actionAjaxJobTitles()
{
if (isset($_POST['jobCat'])) {
$titles = CHtml::listData(JobTitle::getTitlesByCategory($_POST['jobCat'], Yii::app()->user->id), 'job_title_id', 'job_title_name');
if (empty($titles)) {
echo CHtml::tag('label', array('class' => 'checkbox'), Yii::t('model', 'postResumeForm.jobTitles_empty'), true);
} else {
$model = new PostResumeForm();
echo CHtml::activeCheckBoxList($model, 'jobTitles', $titles, array('container' => '', 'separator' => '', 'template' => '<label class="checkbox">{input} {label}</label>'));
}
}
}
function createStationHTMLList($expo, array $stationList)
{
$jobList = Job::selectExpo($expo->expoid);
usort($jobList, "JobCompare");
$date = array();
foreach ($jobList as $j) {
$stationDateTime = swwat_format_shift($j->startTime, $j->stopTime);
list($stationDate, $stationTime, $start) = explode(';', $stationDateTime);
$date[] = $stationDate;
}
$date = array_values(array_unique($date));
echo "<table width=\"50%\">\n";
echo "<tr>\n";
echo "<td>\n";
echo "Select Date: <select id=\"" . PARAM_DATE . "\" name=\"" . PARAM_DATE . "\" onchange=\"hideDateRows()\">\n";
for ($k = 0; $k < count($date); $k++) {
echo "<option value=\"" . $date[$k] . "\"> " . $date[$k] . " </option>\n";
}
echo "<option value=\"All\"> All Dates </option>\n";
echo "</select>\n";
echo "</td>\n";
$jobTitle = JobTitle::titleEnums($expo->expoid);
echo "<td>\n";
echo "Select Job: <select id=\"" . PARAM_JOB . "\" name=\"" . PARAM_JOB . "\" onchange=\"hideJobRows()\">\n";
for ($k = 0; $k < count($jobTitle); $k++) {
echo "<option value=\"" . $jobTitle[$k] . "\"> " . $jobTitle[$k] . " </option>\n";
}
echo "<option value=\"All\" selected=\"selected\"> All Jobs </option>\n";
echo "</select>\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<p />Search Shift By: <input type=\"text\" id=\"search\" name=\"search\" onkeyup=\"searchRows()\"\\>";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "<p />\n";
echo "<div id=\"stationlist_table\">\n";
echo "<table>\n";
echo "<tr>\n";
echo "<th class=\"rowTitle\">Shift</th>\n";
echo "<th class=\"rowTitle\">Job</th>\n";
echo "<th class=\"rowTitle\">Location</th>\n";
echo "<th class=\"rowTitle\">Date</th>\n";
echo "<th class=\"rowTitle\">Time</th>\n";
echo "<th class=\"rowTitle\">Crew</th>\n";
echo "<th class=\"rowTitle\">Supervisors</th>\n";
echo "<th class=\"rowTitle\">Instructions</th>\n";
echo "<th class=\"rowTitle\"></th>\n";
echo "</tr>\n";
$c = count($stationList);
if ($c > 0) {
for ($k = 0; $k < $c; $k++) {
$s = $stationList[$k];
makeStationListHTMLRows($s, $k);
}
} else {
echo "<tr><td class=\"fieldError\" colspan=\"5\">No stations for this Expo currently exist.</td></tr>\n";
}
echo "</table></div><!-- stationlist_table -->\n";
}
@extends('layouts.admin.default')
@section('content')
<?php
$employeeEditId = $employeeEditInfo[0]->id;
$message = Session::get('message');
//echo 'employeeEdit:'.$employeeEditId;
//exit;
$companies = Company::all();
$departments = Department::all();
$jobTitles = JobTitle::all();
$managers = Employee::all();
$supervisors = Employee::all();
$roles = DB::table('groups')->get();
if (isset($employeeEditId) && !empty($employeeEditId)) {
$userEdit = DB::table('users')->where('employee_id', $employeeEditId)->first();
}
if (isset($userEdit) && !empty($userEdit)) {
$userGroupEdit = DB::table('users_groups')->where('user_id', $userEdit->id)->first();
}
if (isset($userGroupEdit) && !empty($userGroupEdit)) {
$groupEdit = DB::table('groups')->where('id', (int) $userGroupEdit->group_id)->first();
}
$companyArr[0] = '';
if (!empty($companies)) {
foreach ($companies as $company) {
$companyArr[$company->id] = $company->name;
}
}
$departmentArr[0] = '';
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();
}
@extends('layouts.admin.default')
@section('content')
<?php
$jobTitleCount = JobTitle::count();
$jobTitles = JobTitle::paginate(10);
$message = Session::get('message');
?>
<div class="page-container">
<div class="row" style="padding-bottom:20px;">
<div class="col-md-2 clearfix">
<aside class="sidebar">
<nav class="sidebar-nav">
<ul id="menu">
<li>
<a href="{{ url('/admin/dashboard') }}">
<span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span>
<span class="sidebar-nav-item">Dashboard</span>
</a>
</li>
<li>
<a href="#">
<span class="sidebar-nav-item-icon fa fa-users fa-lg"></span>
<span class="sidebar-nav-item">Employees</span>
</a>
// $Id: StationEditAction.php 2431 2003-01-07 20:24:44Z cross $ Copyright (c) ConSked, LLC. All Rights Reserved.
include 'util/authenticateOrganizer.php';
require_once 'properties/constants.php';
require_once 'db/StationJob.php';
require_once 'db/JobTitle.php';
require_once 'db/Worker.php';
require_once 'db/JobTitle.php';
require_once 'util/log.php';
require_once 'util/session.php';
require_once 'swwat/gizmos/parse.php';
$station = getStationCurrent();
if (isset($_REQUEST['copy'])) {
$station->stationid = NULL;
}
if (isset($_POST[PARAM_SAVE])) {
$titleEnums = JobTitle::titleEnums($station->expoid);
try {
$station->startTime = swwat_parse_date(html_entity_decode($_POST[PARAM_DATE] . " " . $_POST[PARAM_STARTHOUR]), true);
$station->stopTime = swwat_parse_date(html_entity_decode($_POST[PARAM_DATE] . " " . $_POST[PARAM_STOPHOUR]), true);
$station->jobTitle = swwat_parse_enum($_POST[PARAM_JOB], $titleEnums, false);
$station->maxCrew = swwat_parse_integer(html_entity_decode($_POST[PARAM_MAXCREW]), 11, true);
$station->minCrew = swwat_parse_integer(html_entity_decode($_POST[PARAM_MINCREW]), 11, true);
$station->maxSupervisor = swwat_parse_integer(html_entity_decode($_POST[PARAM_MAXSUPERVISOR]), 11, true);
$station->minSupervisor = swwat_parse_integer(html_entity_decode($_POST[PARAM_MINSUPERVISOR]), 11, true);
$station->description = swwat_parse_string(html_entity_decode($_POST[PARAM_DESCRIPTION]), true);
$station->title = swwat_parse_string(html_entity_decode($_POST[PARAM_TITLE]), true);
$station->location = swwat_parse_string(html_entity_decode($_POST[PARAM_LOCATION]), true);
$station->instruction = swwat_parse_string(html_entity_decode($_POST[PARAM_INSTRUCTION]), true);
} catch (Exception $ex) {
header('Location: WorkerLoginPage.php');
include 'WorkerLoginPage.php';
@extends('layouts.admin.default')
@section('content')
<?php
$jobTitleCount = JobTitle::count();
$jobTitles = JobTitle::paginate(10);
$jobTitleEdit = JobTitle::find($id);
$message = Session::get('message');
?>
<div class="page-container">
<div class="row" style="padding-bottom:20px;">
<div class="col-md-2 clearfix">
<aside class="sidebar">
<nav class="sidebar-nav">
<ul id="menu">
<li>
<a href="{{ url('/admin/dashboard') }}">
<span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span>
<span class="sidebar-nav-item">Dashboard</span>
</a>
</li>
<li>
<a href="#">
<span class="sidebar-nav-item-icon fa fa-users fa-lg"></span>
<span class="sidebar-nav-item">Employees</span>
}));
//DELETE: EXISTING COMPANY
Route::get('/admin/jobtitle/delete/{id}', array('as' => 'adminDeleteJobTitle', 'uses' => function ($id) {
$id = (int) $id;
$employeeId = Session::get('userEmployeeId');
$userId = Session::get('userId');
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
//return 'Update Company';
return View::make('admin.jobtitledelete', array('id' => $id, 'employeeInfo' => $employeeInfo));
}));
//DELETE: EXISTING COMPANY
Route::post('/admin/jobtitle/delete/{id}', array('as' => 'adminProcessDeleteJobTitle', 'uses' => function ($id) {
$data = Input::all();
$id = (int) $id;
$JobTitle = JobTitle::find($id);
if ($JobTitle->delete()) {
$message = 'Deleted Successfully.';
return Redirect::route('adminNewJobTitle')->with('message', $message);
}
}));
//----------------------- Ibyang's Routes ------------------------ //
//routes for Group Module
//route to edit group details page
Route::get('/editgroup/{id}', 'GroupController@editgroup');
//route for delete groups page
Route::delete('/destroygroup/{id}', 'GroupController@destroygroup');
Route::get('/getGroups', 'GroupController@index');
Route::post('/createGroup', 'GroupController@handleCreate');
Route::get('/getGroup', 'GroupController@createGroup');
//routes for Permissions Module
/**
* Save Job Title
* @param sfWebRequest $request
* @return unknown_type
*/
public function executeSaveJobTitle(sfWebRequest $request)
{
$jobService = new JobService();
if ($request->isMethod('post')) {
$arrEmployeeStatus = array();
$jobTitle = new JobTitle();
$jobTitle->setName($request->getParameter('txtName'));
$jobTitle->setDescription($request->getParameter('txtJobTitleDesc'));
$jobTitle->setComments($request->getParameter('txtJobTitleComments'));
$jobTitle->setJobspecId($request->getParameter('txtSpec'));
$jobTitle->setSalaryGradeId($request->getParameter('txtPayGrade'));
//$employeeStatus = $jobService->readEmployeeStatus($empStatusId);
//array_push($arrEmployeeStatus,$employeeStatus);
$jobService->saveJobTitle($jobTitle, $employeeStatus);
$this->setMessage('SUCCESS', array(TopLevelMessages::SAVE_SUCCESS));
$this->redirect('admin/listJobTitle');
}
$this->listJobSpecifications = $jobService->getJobSpecificationsList();
$this->saleryGradeList = $jobService->getSaleryGradeList();
}
SUM(regular) as regular, SUM(regular_overtime) as regular_overtime, SUM(regular_overtime_night_diff) as regular_overtime_night_diff, SUM(regular_night_differential) as regular_night_differential, SUM(rest_day) as rest_day, SUM(rest_day_overtime) as rest_day_overtime, SUM(rest_day_overtime_night_diff) as rest_day_overtime_night_diff, SUM(rest_day_night_differential) as rest_day_night_differential,
SUM(rest_day_special_holiday) as rest_day_special_holiday, SUM(rest_day_special_holiday_overtime) as rest_day_special_holiday_overtime, SUM(rest_day_special_holiday_overtime_night_diff) as rest_day_special_holiday_overtime_night_diff, SUM(rest_day_special_holiday_night_diff) as rest_day_special_holiday_night_diff, SUM(rest_day_legal_holiday) as rest_day_legal_holiday, SUM(rest_day_legal_holiday_overtime) as rest_day_legal_holiday_overtime,
SUM(rest_day_legal_holiday_overtime_night_diff) as rest_day_legal_holiday_overtime_night_diff, SUM(rest_day_legal_holiday_night_diff) as rest_day_legal_holiday_night_diff, SUM(special_holiday) as special_holiday, SUM(special_holiday_overtime) as special_holiday_overtime, SUM(special_holiday_overtime_night_diff) as special_holiday_overtime_night_diff, SUM(special_holiday_night_diff) as special_holiday_night_diff, SUM(legal_holiday) as legal_holiday,
SUM(legal_holiday_overtime) as legal_holiday_overtime, SUM(legal_holiday_overtime_night_diff) as legal_holiday_overtime_night_diff, SUM(legal_holiday_night_diff) as legal_holiday_night_diff'))->where('employee_id', $employeeId)->whereBetween('daydate', [$cutOffDateFrom, $cutOffDateTo])->first();
//dd($summary);
$userGroups = DB::table('users_groups')->where('user_id', $userId)->first();
//$userGroups = DB::table('users_groups')->where('user_id', Auth::user()->id)->first();
if (!empty($userGroups)) {
$groups = DB::table('groups')->where('id', (int) $userGroups->group_id)->first();
}
$currentUser = Sentry::getUser();
//$employeeId = Session::get('userEmployeeId');
//$employeeInfo[0]->id
$company = Company::find($employeeInfo[0]->company_id);
$department = Department::find($employeeInfo[0]->department_id);
$jobTitle = JobTitle::find($employeeInfo[0]->position_id);
$manager = '';
$manager = Employee::where('id', '=', $employeeInfo[0]->manager_id)->first();
if (!empty($manager)) {
$managerFullname = $manager->firstname . ', ' . $manager->lastname;
} else {
$managerFullname = '';
}
$employees = DB::table('employees')->where('manager_id', $employeeInfo[0]->id)->orWhere('supervisor_id', $employeeInfo[0]->id)->get();
$employeeArr[0] = '';
foreach ($employees as $employee) {
$employeeArr[$employee->id] = $employee->firstname . ', ' . $employee->lastname;
}
//$getSchedule = DB::table('employee_schedule')->where('employee_id', $employee->id)->where('schedule_date', trim($currentDate))->get();
//$getWorkShiftByDayOfTheWeek = DB::table('work_shift')->where('employee_id', $employee->id)->where('name_of_day', $dayOfTheWeek)->where('shift', $shift)->get();
?>
<?php
echo $form->dropDownList($model, 'college_id', CHtml::listData(College::getAllCollege(), 'college_name', 'college_name'), array('prompt' => Yii::t('model', 'student.college_id_empty')));
?>
<?php
echo $form->dropDownList($model, 'ECWS_id', CHtml::listData(EcwsCourse::getAllEcws(), 'ECWS_id', 'ECWS_name'), array('prompt' => Yii::t('model', 'postResumeForm.ecwsCourse_empty')));
?>
</div>
<div class="search-control-row">
<?php
echo $form->textField($model, 'first_name', array('placeholder' => Yii::t('model', 'user.first_name')));
?>
<?php
echo $form->textField($model, 'last_name', array('placeholder' => Yii::t('model', 'user.last_name')));
?>
<?php
echo $form->dropDownList($model, 'job_title_id', CHtml::listData(JobTitle::getAllTitlesByCategory($model->job_cat_id), 'job_title_id', 'job_title_name'), array('prompt' => Yii::t('model', 'viewStudentJobTitle.jobTitles_empty')));
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'label' => 'Go', 'type' => 'primary'));
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'button', 'label' => 'Close', 'htmlOptions' => array('id' => 'btn-close-emp-adv-search')));
?>
</div>
</div>
<?php
$this->endWidget();
Yii::app()->clientScript->registerScript('employer-search-form-advance-btn', "\n\n\$(document).on('click','#employer-search-form #btn-emp-adv-search', function(e){\n\tif(!\$('#employer-search-form .advance-search').toggle().is(':visible')){\n\t\t\$('#employer-search-form .advance-search input, #employer-search-form .advance-search select').val('');\n\t\t\$('#employer-search-form #emp-advanced-search').val(0);\n\t}else{\n\t\t\$('#employer-search-form #emp-advanced-search').val(1);\n\t}\n\treturn false;\n});\n\t\t\n\$(document).on('click','#employer-search-form #btn-close-emp-adv-search', function(e){\n\t\$('#employer-search-form .advance-search').hide();\n\t\$('#employer-search-form .advance-search input, #employer-search-form .advance-search select').val('');\n\t\$('#employer-search-form #emp-advanced-search').val(0);\n\treturn false;\n});\n\t\t", CClientScript::POS_READY);
?>
