The website we are working on is for scheduling photoshoots of homes.
Currently our order form looks like this:
[url removed, login to view]
We need the system to display a list of available times for user when a day is selected. This is done by finding available times between calendar events.
There are multiple variables:
*sunset sunrise times change and homes cannot be photographed before or after, I have this info and it can be added to a table.
*photoshoots vary in length depending on what is ordered: each product ordered by user has a time in minutes in a table that will need to be added for "total shoot time".
*a google calendar will need to be checked for available times (calendar will have shoot start times, end times, and location in each entry)
*a google maps (distance matrix) will need to check for driving times between events already scheduled. "total shoot time", time to drive from previous event, time to drive to next event will be added together. If there is enough time between events for all three things then that time will be displayed as an option for the user to pick.
*If there is more than enough time, extra time slots will be shown in 30 minute increments.
*When a user chooses a time, the event should be added to the database and the event will be added to google calendar.
*If driving directly to or from an event the drive is also scheduled as a separate event.
*The scheduler should only plan 1 month in advance
100% escrowed up front
100% released when job is finished.
Coders that show examples of previous work with google map/calendar apis will have a better chance of winning the project.
When this is complete more options will be added such as multiple photographers and discounts for users that choose times that minimize driving. This will be a separate job.