Advertisement
Guest User

Untitled

a guest
May 22nd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. //most simple algoritm: return rooms where there is no reservation/lecture in the requested time-period
  2. public function index?(requested_b_time, requested_e_time){
  3. $rooms = Room::join('reservation', 'room.id', '=', 'reservation.room_id')
  4. ->select('room.id', 'reservation.begin_time', 'reservation.end_time')
  5. ->whereDay('begin_time', requested_b_time->format('d')) //day equal to requested begin day
  6. ->whereDate('begin_time', '>=', requested_b_time) //begintime after or at the requested begintime
  7. ->whereDate('end_time','<=', requested_e_time); //endtime befor or at the requested endtime
  8.  
  9. return $rooms;???
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement