Hi, I have 3 tables courses, instructors and instructor_calendar. When I want to select an instructor for one of my courses I want to know if he is busy on the day the course is scheduled.
I tried to add a button to say "busy" but I have a problem with the instructor calendar, if the event the instructor has is added using an interval I don't see it when interogating using the api.(for example an instructor has an event from 12/12/2016 until 20/12/2016, if I search for the date 15/12/2016 I don't get a result)
So I was thinking when I choose an instructor from the list to show his calendar for the month the course is held but I have no idea how to aproach that.
Has anyone an idea? Or tried to do something similar?