Clock In Clock Out

[ankycooper]

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