Hi
I'm Making a basic Clock In Clock Out Application
In which every employee Has an Emp ID/username
When he comes to the office he needs to do clock in
if he takes a break he need to do break in and break out
when he returns from the break
finally clock out when he leaves for the day
the table is something like this
shift is the date of the shift, username=empid, nameemp=name header=(woff, Leave, Working), clkin=clockin_timestamp, clkbrkin=breakin_timestamp, clkbrkout=breakin_timestamp, clkout=clockout_timestamp, hours=no of hours excluding break and comments will have a leave Id if on a leave
table 1
pid | shift | username | nameemp | header | clkin | clkbrkin | clkbrkout | clkout | hours | comments
Now if the employee works after 00:00Am the date will change and will not look for the old rec....Its confusing
Also The user can apply leaves and the admin can approve
them
table 2
lid | username | name | fdate | edate | reason | status
if the manager aproves the following should also create a leave rec in table 1
also the user table has a feild woff=weekly off which should also create a rec for the emp if a weekly off
Please give suggestions, links or example apps
Thanks