Looking for a Yii programmer who is versed in PHP and efficient MySQL database design.
The project is an event (shift) scheduler module, with infinite recurring shifts, and exceptions by day. The schedule will be tracking users' work shifts by day, not random appointments. The web application and database are already setup for users. This is just an addition.
The model will be returning 100's of user schedules for a department in the month view, so the design must be efficiently collecting the data from the database.
Each shift will have a start date, end date, and custom work related info, such as: hours on shift per day, location, arrival flight, departure flight, housing, confirmations, etc. I'd like to be able to change certain information on a specific day. That's where the exceptions come in.
Attached is an example that is similar to the end product I desire. HOWEVER, I only need the backend work completed, so that it will pass the shift information data to the view.
Please have a plan before you bid on this project. When you bid, send a pm with related work - and your plan on how you will design this module/database.