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);
}
