public function getDatatable() { $booking = Booking::select(array('bookings.id', 'bookings.cust_name', 'bookings.tour_name', 'bookings.tour_date', 'bookings.price', 'bookings.created_at')); return Datatables::of($booking)->addColumn('action', function ($booking) { return '<a href="booking/edit/' . $booking->id . '" class="btn btn-xs btn-primary">Edit</a> <a href="booking/delete/' . $booking->id . '" class="btn btn-xs btn-danger">Delete</a>'; })->removeColumn('update_at')->make(true); }
/** * acceptedDates * list of date ranges for accepted booking * * @author Rasmus Ebbesen <*****@*****.**> * @date 18-09-2015 * @access public * * @param int $room * @return \Illuminate\Http\JsonResponse */ public function acceptedDates($room) { $bookings = Booking::select('from', 'to')->where('room', $room)->where('state', 'accepted')->where('to', '>', Carbon::now())->orderBy('from', 'asc')->get(); return response()->json($bookings); }