/**
* 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]);
}
