/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { if (!isset($id) || intval($id) <= 0) { return redirect('/history'); } $detail = BookingDetail::where('bookingID', $id)->get(); // dd($detail); return view('history.detail', ['data' => $detail]); }
private function saveDetail($booking, $locks, $user) { $count = 0; foreach ($locks as $key => $lock) { $zoneCode = substr($lock, 0, 1); $calendar = Calendar::where('opened_at', $booking->sale_at)->where('code', $zoneCode)->first(); $detail = BookingDetail::create(['code' => date('Ymd-His') . '-' . $user->id . '-' . ($count + 1), 'bookingID' => $booking->id, 'bookingCode' => $booking->code, 'zoneID' => $calendar->zoneID, 'zoneCode' => $calendar->code, 'zoneNumber' => $lock, 'price' => $calendar->price_type2, 'status' => 'BK', 'sale_at' => $booking->sale_at]); $count++; } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update($id) { $a = Booking::where('id', $id)->update(['verify' => 1]); $b = BookingDetail::where('bookingID', $id)->update(['verify' => 1]); if ($a <= 0 || $b <= 0) { return response()->json(['result' => false, 'message' => 'can not find this booking.']); } $temp_booking = ViewBookingAndDetail::where('active', 1)->where('id', $id)->groupBy('id')->orderBy('zoneNumber')->get(); foreach ($temp_booking as $key => $value) { $value->detail = BookingDetail::where('bookingID', $value->id)->get(); $value->user = User::where('id', $value->userID)->first(); } return response()->json(['result' => true, 'message' => 'success', 'data' => $temp_booking]); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update($date) { if ($date == null) { return response()->json(['result' => false, 'message' => 'date can not be null.']); } $booking = Booking::where('sale_at', $date . ' 00:00:00')->where('status', 'BK')->update(['status' => 'RM', 'active' => 0]); $booking_list = Booking::where('sale_at', $date . ' 00:00:00')->where('status', 'RM')->get(); foreach ($booking_list as $key => $book) { BookingDetail::where('bookingID', $book->id)->update(['status' => 'RM', 'active' => 0]); } if ($booking != null) { return response()->json(['result' => true, 'data' => $booking, 'message' => 'success']); } return response()->json(['result' => false, 'message' => 'clear fail.']); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { if ($id == null) { return response()->json(array('result' => false, 'message' => 'Booking id can not be null.')); } $rules = array('id' => 'required', 'code' => 'required', 'canCheckIn' => 'required|boolean:true', 'bookingDetail' => 'required|array'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return response()->json(array('result' => false, 'message' => 'invalid input field.')); } $date = new DateTime(); $date->setTimezone(new DateTimeZone('Asia/Bangkok')); $booking = Booking::where('id', $id)->first(); $booking->status = 'CN'; $booking->checkin_at = $date->format('Y-m-d H:i:s'); $result = $booking->save(); if (!$result) { return response()->json(array('result' => false, 'message' => 'Booking id $id check-in has error.')); } BookingDetail::where('bookingID', $id)->update(['status' => 'CN']); return response()->json(array('result' => true, 'message' => 'success.')); }
public function getBlockMonthly(Request $request) { $date = $request->input('date'); $blocks = BookingDetail::select('zoneNumber')->where('sale_at', $date . ' 00:00:00')->whereIn('status', ['BK', 'CN'])->get(); return response()->json($blocks); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // $booking = Booking::where('id', $id)->first(); if ($booking == null) { return response()->json(['result' => false, 'message' => 'can not get this booking detail.']); } $booking->detail = BookingDetail::where('bookingID', $booking->id)->get(); $user = User::where('id', $booking->userID)->first(); return response()->json(['result' => true, 'message' => 'success', 'data' => $booking, 'user' => $user]); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // $booking = Booking::where('code', $id)->get(); if ($booking == null) { return response()->json(['result' => false, 'message' => 'can not get this booking detail.']); } $grandprice = 0; foreach ($booking as $key => $book) { $book->detail = BookingDetail::where('bookingID', $book->id)->get(); $grandprice += $book->totalPrice; } $user = User::where('id', $booking[0]->userID)->first(); return response()->json(['result' => true, 'message' => 'success', 'data' => $booking, 'user' => $user, 'grandprice' => $grandprice]); }