public function index()
{
if (Session::has('st_date')) {
$st_date = Session::get('st_date');
} else {
$st_date = date("Y/m/d");
}
//Session::flush();
if (Session::has('ed_date')) {
$ed_date = Session::get('ed_date');
} else {
$ed_date = date("Y/m/d", strtotime($st_date . ' + 2 days'));
}
$tour = Tour::take(5)->get();
$excursion = Excursion::take(5)->get();
$user_review = HotelReview::take(3)->get();
$transport_packages = TransportPackage::take(5)->get();
return View::make('index')->with(array('tour' => $tour, 'excursion' => $excursion, 'user_review' => $user_review, 'st_date' => $st_date, 'ed_date' => $ed_date, 'transport_packages' => $transport_packages));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function excursionDetail($country = '', $excursion_type = '', $excursion = '')
{
$x = 0;
if (!empty($country)) {
$country = str_replace('-', ' ', $country);
$get_country_id = DB::table('countries')->where('country', 'LIKE', $country)->where('val', 1)->first();
$country_id = $get_country_id->id;
}
if (!empty($excursion_type)) {
$excursion_type = str_replace('-', ' ', $excursion_type);
$get_excursion_type_id = DB::table('excursion_types')->where('excursion_type', 'LIKE', $excursion_type)->first();
$excursion_type_id = $get_excursion_type_id->id;
}
if (!empty($excursion)) {
$excursion = str_replace('-', ' ', $excursion);
$get_excursion_id = DB::table('excursions')->where('excursion', 'LIKE', $excursion)->where('val', 1)->first();
$excursion_id = $get_excursion_id->id;
}
$transport_type = ExcursionTransportType::where('excursion_type_id', '=', $excursion_type_id)->lists('transport_type', 'id');
$path = array();
$directory = public_path() . '/images/excursion_images/excursion_types/';
$images = glob($directory . $excursion_id . "_" . "*.*");
foreach ($images as $image) {
$path[] = $image;
}
$excursion = Excursion::where('id', $excursion_id)->where('val', 1)->first();
$excursion_type = ExcursionType::where('id', $excursion_type_id)->first();
$excursion_rate = ExcursionRate::where('excursion_id', $excursion_id)->where('val', 1)->get();
// dd(DB::getQueryLog());
if (!$excursion->count()) {
return Redirect::to('/403');
}
return View::make('excursion.excursion_details')->with(array('x' => $x, 'excursion' => $excursion, 'excursion_id' => $excursion_id, 'excursion_type_id' => $excursion_type_id, 'path' => $path, 'excursion_type' => $excursion_type, 'transport_type' => $transport_type, 'excursion_rate' => $excursion_rate));
}
