Hi,
I have an application which uses the DBi Solutions::PIM ActiveX files for letting users schedule appointments. I build up a screen with time slots down the left and staff across the top. This works in conjunction with a calendar control which when you click on a day in the calendar that day's appointments are displayed.
The users have now asked to include a means of scheduling staff attendance in. For example one Optometrist doesn't work at that office in Tuesdays and Thursdays. Some staff go for lunch at 11:00 for an hour and others at 12:00. Of course handling staff vacation and public/bank holidays is required too.
In order to allow users to do this easily I was thinking of displaying a similar grid with time slots down the left and the days of the week (Sun to Sat) across the top. Then the user can select a staff member (from a listbox or dropdown) and drag and drop "Available" and "Unavailable" icons onto the grid for the required times.
I guess I'd also need a screen to enter the dates of public holidays (and allow them to be easily rolled over to the next year (at least for those that fall on standard dates). Also a vacation tabele would be needed where start and end dates can be entered.
So I have an attendance table with Staff ID, Day of week, start time, end time, Flag for available or unavailable.
Also a public holidays table with Holiday id (I'll store the possible holidays in a lookup table) and holiday date.
Also a vacation table with staff id, start date and end date.
Does that sound OK? Any ideas for improvement?
Thanks,