public function edit($userID)
{
$branches = array();
foreach (Branches::all() as $branch) {
$branches[$branch->ID] = "(" . $branch->BranchID . ") " . $branch->Name;
}
return View::make("users.editUser", ['user' => User::find($userID), 'branches' => $branches]);
}
public function get_branches()
{
$branches = Branches::all();
$res = "";
foreach ($branches as $branch) {
$res = $res . "<option value=\"" . $branch->ID . "\">" . $branch->BranchID . "</option>";
}
return $res;
}
public function findKit($bookingID)
{
$branch = Branches::find(Session::get('branch'));
// If the session is not set, default to the IT depot
if (!isset($branch)) {
$branch = Branches::find(0);
}
// Get Kits to be received
$data = DB::select('SELECT
K.ID AS KitID, K.KitType, K.Name AS KitName, K.AtBranch, K.KitState, K.BarcodeNumber, K.Specialized, K.SpecializedName,
B.ID as BookingID, B.ForBranch, B.StartDate, B.EndDate, B.ShadowStartDate, B.ShadowEndDate, B.Purpose,
KS.StateName,
KT.Name AS KitTypeName, KT.TypeDescription as KitTypeDesc
FROM Booking AS B
INNER JOIN Kits as K ON (K.ID = B.KitID)
INNER JOIN KitTypes AS KT ON (KT.ID = K.KitType)
INNER JOIN KitSTate AS KS ON (KS.ID = K.KitState)
WHERE now() BETWEEN DATE_ADD(B.ShadowStartDate, INTERVAL -1 DAY) AND B.ShadowEndDate
AND B.ForBranch = ?
AND B.ForBranch <> K.AtBranch
ORDER BY BookingID
', array($branch->ID));
// Get Kits to be sent out
$data2 = DB::select('SELECT
K.ID AS KitID, K.KitType, K.Name AS KitName, K.AtBranch, K.KitState, K.BarcodeNumber, K.Specialized, K.SpecializedName,
B.ID as BookingID, B.ForBranch, B.StartDate, B.EndDate, B.ShadowStartDate, B.ShadowEndDate, B.Purpose,
KS.StateName,
KT.Name AS KitTypeName, KT.TypeDescription as KitTypeDesc
FROM Booking AS B
INNER JOIN Kits as K ON (K.ID = B.KitID)
INNER JOIN KitTypes AS KT ON (KT.ID = K.KitType)
INNER JOIN KitSTate AS KS ON (KS.ID = K.KitState)
WHERE now() BETWEEN DATE_ADD(B.ShadowStartDate, INTERVAL -1 DAY) AND B.ShadowEndDate
AND K.AtBranch = ?
AND B.ForBranch <> K.AtBranch
ORDER BY BookingID
', array($branch->ID));
$theBooking = Booking::findOrFail($bookingID);
$theBookID = $theBooking->ID;
return CheckIfAuthenticated('members.receiveKitManagement', ['mode' => 'receive', 'branch' => $branch, 'selected_menu' => 'main-menu-receive', 'receiveKits' => $data, 'sendKits' => $data2, 'findBookID' => $theBookID, 'kitTypes' => KitTypes::all()], 'home.index', [], false);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getBranches()
{
return $this->hasMany(Branches::className(), ['companies_company_id' => 'company_id']);
}
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();
}
public function index()
{
return CheckIfAuthenticated('kit.kitManagment', ['selected_menu' => 'main-menu-administration', 'selected_admin_menu' => 'admin-menu-manage-kits', 'kitTypes' => KitTypes::all(), 'branches' => Branches::all(), 'kitStates' => KitState::all()], 'home.index', [], true);
}
function getBranche()
{
$t = new Branches();
$s = $t->select()->distinct()->from('branche')->join('unite_type', 'unite_type.branche = branche.id', array())->where('unite_type.id = ?', $this->type);
return $t->fetchOne($s);
}
public function getShadowDays()
{
if (!Request::ajax()) {
return "not a json request";
}
$data = Input::all();
if (intval($data['ID']) == 0) {
$branch = 'MNA';
} else {
$branch = Branches::select('BranchID')->where('ID', '=', $data['ID'])->pluck('BranchID');
$branch = str_replace(['EPL'], [''], $branch);
}
$url = str_replace([':FORMAT', ':BRANCH'], ['xml', $branch], API_URL());
return xmlToJSON($url);
}
public function getInventory()
{
$branch = Branches::find(Session::get('branch'));
// If the session is not set, default to the IT depot
if (!isset($branch)) {
$branch = Branches::find(0);
}
$data = DB::select('SELECT
K.ID AS KitID, K.KitType, K.Name AS KitName, K.AtBranch, K.KitState, K.BarcodeNumber, K.Specialized, K.SpecializedName,
B.ID as BookingID, B.ForBranch, B.StartDate, B.EndDate, B.ShadowStartDate, B.ShadowEndDate, B.Purpose,
KS.StateName,
KT.Name AS KitTypeName, KT.TypeDescription as KitTypeDesc
FROM Booking AS B
INNER JOIN Kits as K ON (K.ID = B.KitID)
INNER JOIN KitTypes AS KT ON (KT.ID = K.KitType)
INNER JOIN KitSTate AS KS ON (KS.ID = K.KitState)
WHERE now() BETWEEN DATE_ADD(B.ShadowStartDate, INTERVAL -1 DAY) AND B.ShadowEndDate
AND B.ForBranch = ?
AND B.ForBranch <> K.AtBranch
UNION
SELECT
K.ID AS KitID, K.KitType, K.Name AS KitName, K.AtBranch, K.KitState, K.BarcodeNumber, K.Specialized, K.SpecializedName,
B.ID as BookingID, B.ForBranch, B.StartDate, B.EndDate, B.ShadowStartDate, B.ShadowEndDate, B.Purpose,
KS.StateName,
KT.Name AS KitTypeName, KT.TypeDescription as KitTypeDesc
FROM Booking AS B
INNER JOIN Kits as K ON (K.ID = B.KitID)
INNER JOIN KitTypes AS KT ON (KT.ID = K.KitType)
INNER JOIN KitSTate AS KS ON (KS.ID = K.KitState)
WHERE now() BETWEEN DATE_ADD(B.ShadowStartDate, INTERVAL -1 DAY) AND B.ShadowEndDate
AND K.AtBranch = ?
AND K.KitState = 1
AND B.ForBranch <> K.AtBranch
UNION
SELECT
K.ID AS KitID, K.KitType, K.Name AS KitName, K.AtBranch, K.KitState, K.BarcodeNumber, K.Specialized, K.SpecializedName,
"", "", "", "", "", "", "",
KS.StateName,
KT.Name AS KitTypeName, KT.TypeDescription as KitTypeDesc
FROM Kits AS K
INNER JOIN KitTypes AS KT ON (KT.ID = K.KitType)
INNER JOIN KitSTate AS KS ON (KS.ID = K.KitState)
LEFT JOIN Booking AS B ON ( B.ForBranch <> K.AtBranch
AND B.KitID = K.ID
AND now() BETWEEN DATE_ADD(B.ShadowStartDate, INTERVAL -1 DAY) AND B.ShadowEndDate
)
WHERE B.ID is null
AND K.KitState = 1
AND K.AtBranch = ?
ORDER BY KitID
', array($branch->ID, $branch->ID, $branch->ID));
$allBranches = array();
foreach (Branches::all() as $brnch) {
$allBranches[$brnch->ID] = array('ID' => $brnch->ID, 'BranchID' => $brnch->BranchID, 'Name' => $brnch->Name, 'Address' => $brnch->EPLAddress, 'PhoneNumber' => $brnch->PhoneNumber);
}
// Build a list of the users bookings.
$userBookingIDs = array();
$detRecords = DB::table("BookingDetails")->where('UserID', '=', Auth::user()->id)->where('BookingDetails.Booker', '=', 1)->join('Booking', 'BookingDetails.BookingID', '=', 'Booking.ID')->join('Kits', 'Booking.KitID', '=', 'Kits.ID')->join('Branches', 'Booking.ForBranch', '=', 'Branches.ID')->where('Booking.EndDate', '>=', new DateTime('today'))->select('Kits.Name as KitName', 'BookingDetails.*', 'Kits.KitType', 'Kits.Specialized', 'Kits.SpecializedName', 'Booking.*', 'Branches.BranchID');
foreach ($detRecords->get() as $det) {
array_unshift($userBookingIDs, $det->BookingID);
}
// union that with the bookings for this branch.
$bookings = $detRecords->union(DB::table("BookingDetails")->where('BookingDetails.Booker', '=', 1)->join('Booking', 'BookingDetails.BookingID', '=', 'Booking.ID')->wherenotin('Booking.ID', $userBookingIDs)->join('Kits', 'Booking.KitID', '=', 'Kits.ID')->join('Branches', 'Booking.ForBranch', '=', 'Branches.ID')->where('Booking.EndDate', '>=', new DateTime('today'))->select('Kits.Name as KitName', 'BookingDetails.*', 'Kits.KitType', 'Kits.Specialized', 'Kits.SpecializedName', 'Booking.*', 'Branches.BranchID'))->orderBy('StartDate', 'desc');
// slice out only the columns we need and send them to the client.
$bookingDetails = array();
foreach ($bookings->get() as $det) {
array_unshift($bookingDetails, array('KitID' => $det->KitID, 'type' => $det->KitType, 'Name' => $det->Specialized ? $det->KitName . ' + ' . $det->SpecializedName : $det->KitName, 'Booker' => user::find($det->UserID)->realname, 'Branch' => $det->BranchID, 'Event' => $det->Purpose, 'Start Date' => date("d-m-y", strtotime($det->StartDate)), 'End Date' => date("d-m-y", strtotime($det->EndDate))));
}
//get today's date
$res = array();
// $res['sql'] = $bookings->toSql();
$res['kitTypes'] = KitTypes::all();
$res['data'] = $data;
$res['branches'] = $allBranches;
$res['branch_ID'] = $branch->ID;
$res['branch_BranchID'] = $branch->BranchID;
$res['branch_name'] = $branch->Name;
$res['bookings'] = $bookingDetails;
return json_encode($res);
}