Re: PERL/MySQL Punch Clock

Gentlemen, I have been asked to implement ..

We gonna get into trouble with that mode of address!

Difficult to say without knowing more about your design, but would it not be simpler to have: employeeNumber, clockedInAt,ClockedOutAt
and then add up all the instances for the individual employeeNumber in the day?

So a given individual would have perhaps two lines in the table for day x, one from clock in until lunch when he or she clocks out, then another from clocking back in after lunch until quitting time.

Comment on Re: PERL/MySQL Punch Clock

Replies are listed 'Best First'.
Re^2: PERL/MySQL Punch Clock by amt (Monk) on Jan 26, 2005 at 16:02 UTC
Much apologies. I was thinking of using that method, after rethinking it a bit i am considering using the structure. `uid varchar(255) #uid from ldap date date #date time time #time stat enum() #transaction type` [download] This way when i want to do reporting i can pull the dates seperately from the times, and do the math of the times. amt. perlcheat	[reply] [d/l]