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