Hi, I am trying to figure out a problem but i cant my mind is totally blocked. I have to make conditions for this:
When someone makes reservation it checks the availability of the table.
the time of a reservation should last 3 hrs.
Now i want a condition that checks the time of other reservation and if it is smaller than the other reservation time it checks if in 3 hours there are no reservations.
and if it is bigger it ccheckes that the reservation held before (+3hrs) does not clash with the current reservation.
I have my ideas confused. Help pls