/** * 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); }
public function run() { // We want to delete the users table if it exists before running the seed DB::table('bookings')->delete(); $bookings = array(['user_id' => '4', 'host_id' => '1', 'listing_id' => '1', 'checkin' => '1439825178000', 'checkout' => '1440478800000', 'status' => 'Pending'], ['user_id' => '1', 'host_id' => '4', 'listing_id' => '1', 'checkin' => '1439825178000', 'checkout' => '1440478800000', 'status' => 'Pending']); // Loop through each user above and create the record for them in the database foreach ($bookings as $booking) { Bookings::create($booking); } }
public function charge(Request $request) { $token = $request->input('token'); $amount = $request->input('amount') * 100; $booking_id = $request->input('booking_id'); $user = Auth::user(); $user->charge($amount, ['source' => $token, 'receipt_email' => $user->email]); $bookings = Bookings::find($booking_id); $bookings->status = 'Booked'; $bookings->save(); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $bookings = Bookings::find($id); $bookings->status = $request->input('status'); $bookings->save(); }
public function block($id, Request $request) { $bookings = new Bookings(); $bookings->checkin = strtotime($request->input('checkin')) * 1000; $bookings->checkout = strtotime($request->input('checkout')) * 1000; $bookings->user_id = Auth::user()->id; $bookings->listing_id = $id; $bookings->status = 'Blocked'; $bookings->save(); }