public function confirmPayment($package, $cabin)
{
$passenger = App\passenger::where('passenger_id', $_POST['txtIC'])->first();
if ($passenger == null) {
$passenger = new App\passenger();
}
$passenger->passenger_id = $_POST['txtIC'];
$passenger->first_name = $_POST['txtFirstName'];
$passenger->last_name = $_POST['txtLastName'];
$passenger->gender = $_POST['optGender'];
$passenger->dob = date("Y-m-d", strtotime($_POST['dateDOB']));
$passenger->address = $_POST['txtAddress'];
$passenger->email = $_POST['txtEmail'];
$passenger->save();
$reservation = new App\reservation();
$reservation->passenger_id = $_POST['txtIC'];
$reservation->package_id = $package;
$reservation->cruise_cabin = $cabin;
$reservation->save();
if ($passenger->gender == 'M') {
Session::flash('message', 'Thank you Mr. ' . $_POST['txtFirstName'] . ' for booking our cruise ticket. Enjoy your trip!');
} else {
Session::flash('message', 'Thank you Ms. ' . $_POST['txtFirstName'] . ' for booking our cruise ticket. Enjoy your trip!');
}
Session::flash('alert-class', 'alert-success');
AIServer::trackEvent('complete reservation');
AIServer::flush();
return redirect('/booking');
}
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'));
}
function cancel_reservation()
{
try {
$input = Request::all();
$res_id = $input['res_id'];
$affectedRows = reservation::RelevantReservation($res_id)->update(array('status' => 'cancelled'));
$not_added_services = DB::table('available_onrequest')->whereNotIn('onrequest_id', function ($query) {
$input = Request::all();
$res_id = $input['res_id'];
$query->select('onrequest_id')->from('reservation_onrequest')->where('res_id', '=', $res_id);
})->select('*')->get();
$added_services = DB::table('reservation_onrequest')->leftJoin('available_onrequest', 'available_onrequest.onrequest_id', '=', 'reservation_onrequest.onrequest_id')->where('res_id', '=', $res_id)->select('*')->get();
Session::put($res_id . 'added_services', $added_services);
Session::put('service_res_id', $res_id);
Session::put($res_id . 'not_added_services', $not_added_services);
return redirect('/updateres')->with(['succ_status' => 'Reservation has been cancelled successfully']);
} catch (Exception $e) {
return redirect('/FO_mainpage')->with(['exception' => 'You have errors in your last request.Try again!']);
}
}
