public function homePage()
{
$all_countries = DB::table('tbl_countries')->select('id', 'code', 'name')-
>get();
$option_values = [];
$concerns = DB::table('concern_images')->select('concern_images')->get();
foreach ($all_countries as $eachCountry) {
$option_values[] = [
'country' => $eachCountry->name,
'code' => $eachCountry->code,
'id' => $eachCountry->id
];
}
$airports = DB::table('airports')->select('code', 'countryName',
'cityName', 'name')->get();
$cached = $this->render_selectize($airports);
// $all_airports = [];
// foreach ($airports as $eachAirport) {
// $all_airports[] = [
// 'area' => $eachAirport->code . ' ' . $eachAirport->countryName .
',' . $eachAirport->cityName,
// 'city' => $eachAirport->cityName,
// ];
// }
$tour_packages = DB::table('tour_packages')-
>select('image_url_one','image_url_two','image_url_three','image_url_four','image_u
rl_five','country_name','id','package_name','price_per_person','valid_until')-
>where('featured', 1)->get();
$active_images = [];
foreach ($tour_packages as $key => $eachPackage) {
if ($eachPackage->image_url_one != null) {
$active_images[] = $eachPackage->image_url_one;
} else if ($eachPackage->image_url_two != null) {
$active_images[] = $eachPackage->image_url_two;
} else if ($eachPackage->image_url_three != null) {
$active_images[] = $eachPackage->image_url_three;
} else if ($eachPackage->image_url_four != null) {
$active_images[] = $eachPackage->image_url_four;
} else if ($eachPackage->image_url_five != null) {
$active_images[] = $eachPackage->image_url_five;
} else {
$active_images[] = 'no_image';
}
}
$top_packages = DB::table('tour_packages')->where('top', 1)->get();
$top_images = [];
foreach ($top_packages as $key => $eachPackage) {
if ($eachPackage->image_url_one != null) {
$top_images[] = $eachPackage->image_url_one;
} else if ($eachPackage->image_url_two != null) {
$top_images[] = $eachPackage->image_url_two;
} else if ($eachPackage->image_url_three != null) {
$top_images[] = $eachPackage->image_url_three;
} else if ($eachPackage->image_url_four != null) {
$top_images[] = $eachPackage->image_url_four;
} else if ($eachPackage->image_url_five != null) {
$top_images[] = $eachPackage->image_url_five;
} else {
$top_images[] = 'no_image';
}
}
$all_airports = $airports[0];
return view('homePage', compact('active_images', 'tour_packages',
'top_images', 'top_packages', 'all_countries', 'option_values', 'concerns',
'cached', 'all_airports'));
}
public function bookings(Request $request)
{
$all_countries = DB::table('tbl_countries')->select('id','code','name')-
>get();
$option_values = [];
$airports = DB::table('airports')->select('code', 'countryName',
'cityName', 'name')->get();
$cached = $this->render_selectize($airports);
$all_airports = $airports[0];
DB::disableQueryLog();
// foreach ($all_countries as $eachCountry) {
// $option_values[] = [
// 'country' => $eachCountry->name,
// 'code' => $eachCountry->code,
// 'id' => $eachCountry->id
// ];
// }
return view('bookings.travel_bookings', compact('all_countries',
'option_values', 'cached', 'all_airports'));
}
@foreach ($airports->take(1000) as $data)
<option data-city={{ $data->cityName }}>
{{ $data->code . ' ' . $data->name . ' ' . $data->countryName}}
</option>
@endforeach
