A Timesheet Application

linux01

Hello all, I am trying to get the thought process going on what is gonna be needed to write a Timesheet application. I am looking for an example of someone who has written this type of app. I did find one on sourceforge.com but I would need a lot more functionality than that. Basically, employees will be logging in which will capture the time and mark them as "punched in", when they punch out. mark them as "punched out". The hard part I am thinking is if someone forgets to punch out and their timesheet would reflect them working 24 hours. Also if someone comes in 8 minutes after the hour round the time up to the next quarter hour. Anyone have any ideas or resources where I could look? Thanks in advance.

weekender

Logging out: if someone forgets to log out, their session file will be deleted after session_cache_expire minutes. Store the session id of the user whenever he/she logs in, then create a script that compares the filenames of the session files with the session and marks log out times for users that don't have sessions. Then set this on a cron job to run ever ten mins or so

adam

linux01

I forgot to mention that when a employee punches in this will capture the time and store the time in a mysql table. When a employee punches out to go to lunch it will also store this in a table in the database, so that when the time totals are calculated for their work period it will be bases on entries in the (my table is called timesheet_times)
table. So far I am thinking I will need a table for timesheets, employee info, location info(where the employee works at (ex. Atlanta, Chicago), and maybe a employee schedules. I understand what you mean by sessions. Thanks for the input.