/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $bookings = Bookings::where('bookings.id', '=', $id)->join('users', 'users.id', '=', 'bookings.host_id')->join('listings', 'listings.id', '=', 'bookings.listing_id')->select('bookings.id', 'bookings.checkin', 'bookings.checkout', 'bookings.status', 'bookings.host_id', 'listings.title', 'listings.address', 'listings.city', 'users.name', 'users.avatar', 'bookings.total')->first(); $messages = Messages::where('messages.bookings_id', '=', $bookings->id)->join('users', 'users.id', '=', 'messages.user_id')->select('users.avatar', 'users.name', 'users.id', 'messages.content', 'messages.created_at')->orderBy('created_at', 'DESC')->get(); $bookings['messages'] = $messages; $bookings['auth'] = Auth::user()->id; return response()->json($bookings); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $bookings = Bookings::where('listing_id', '=', $id)->join('listings', 'listings.id', '=', 'bookings.listing_id')->join('users', 'users.id', '=', 'bookings.user_id')->select('checkin', 'checkout', 'users.name', 'bookings.id', 'bookings.status')->get(); return response()->json($bookings); }