Hi guys,
I have a booking system I'm having trouble with. I think I'm overcomplicating this in my head but if anyone can shed some light, I'd be grateful!
I add a new shift to the system and I need to find all people in the db that aren't already booked at the time the shift is happening.
So, if the shift is between 15:00 and 23:00 on a particular day, I need to exclude anyone already overlapping into those hours. i.e - if a cand is booked in from 09:00 to 16:00 they can't do it.
How do I do it?!?!? I've tried a number of ways but it's just baffling me!
I have a booking system I'm having trouble with. I think I'm overcomplicating this in my head but if anyone can shed some light, I'd be grateful!
I add a new shift to the system and I need to find all people in the db that aren't already booked at the time the shift is happening.
So, if the shift is between 15:00 and 23:00 on a particular day, I need to exclude anyone already overlapping into those hours. i.e - if a cand is booked in from 09:00 to 16:00 they can't do it.
How do I do it?!?!? I've tried a number of ways but it's just baffling me!