/**
  * 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);
 }
Example #2
0
 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);
     }
 }
Example #3
0
 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();
 }