dprichard Posted February 6, 2008 Share Posted February 6, 2008 I want to setup something to track employee's time off, but am trying to figure out the best way to save the time off in the database. I need to show a report that has a calendar with highlighted days for the days off color coded by the type of days off they are. Would I be better off having a form with say 7 days and they pick a date for each day they want off and if they need more than 7 days off they have to do 2 request? Or would it be better to have a start date and end date and figure out the hours based on that? I am just trying to get some advice on what the best direction would be to handle something like this before I go one direction or the other and have to back up and redo something. Any advice you can give on this would be greatly appreciated! Link to comment https://forums.phpfreaks.com/topic/89719-tracking-days-off-design-question/ Share on other sites More sharing options...
fenway Posted February 6, 2008 Share Posted February 6, 2008 From a DB perspective, you can have a record with from and until date/time values, one per block of time off. How you want to show this to the user is up to you. Link to comment https://forums.phpfreaks.com/topic/89719-tracking-days-off-design-question/#findComment-459871 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.