public function chooseCruise($id) { $cabins = DB::table('cruise_cabin')->join('cruise', 'cruise_cabin.cruise_id', '=', 'cruise.cruise_id')->join('cruise_package', 'cruise_package.cruise_id', '=', 'cruise.cruise_id')->where('cruise_package.id', $id)->select('cruise_cabin.id', 'cruise_cabin.cruise_cabin', 'cruise_cabin.cabinClass_id', 'cruise_cabin.cruise_id')->get(); $reservations = App\reservation::where('package_id', $id)->get(); $classes = App\cabinclass::all(); $data = array("package_id" => $id, "cabins" => $cabins, "classes" => $classes, "reservations" => $reservations); AIServer::trackEvent('passenger choose cabin'); AIServer::flush(); return view('book.Cabin', $data); // return ($reservations); }
public function oldFolio_detailed($id) { try { $folio_num = folio_services::where('folio_num', $id)->orderBy('date')->get(); //obtain all services purchased by the current folio with purchased dates. $balance = folio::where('folio_num', $id)->first(); //to obtain the progressive balance of the current folio. $res_details = reservation::where('res_id', $balance->res_id)->first(); //to obtain reservation details of current folio. $services = DB::table('services')->select('service_id')->get(); $reason_code = DB::table('reason_codes')->select('reason_code')->get(); $updates = folio_update::where('folio_num', $id)->get(); } catch (ModelNotFoundException $e) { dd('no data'); } return view('Cashiering/oldFolio_detailed', compact('folio_num', 'balance', 'res_details', 'services', 'id', 'reason_code', 'updates')); }