I currently have system set up where soccer referees are creating an account for individual use. An assignor is inputing games into the database, and then assigning 3 referees to each game through the program. However, I need to add a feature allowing each referee to submit an availability for the assignor to work from.
What I would like to do:
When a user logs in, they click a link "Update Availability," there it will display a calendar (or something similiar) where they can select dates that they ARE available to work. This would then be saved to a table in the database, and then when the assignor goes to the page to assign games, the dropdown menu would only list officials available for that day.
I believe I know enough of php that I can modify my current assignment area for the dropdown menus, but I really need help with setting up the availability part.
What would be the easiest (or most effective) way of doing this?
An example of an old html form-based thing can be seen here:
http://ecisoa.org/pages/referee_availability.html
The only problem with this, is that the calendar isn't really a calendar, and I would have to go in and reset everyones availability at the start of each year if I used a similar setup for the php program.
Thank you for any help!
Landis
