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! Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.