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'));
}
