Time tracking and payment registration architecture
Posted
by
egis
on Programmers
See other posts from Programmers
or by egis
Published on 2012-10-05T17:03:40Z
Indexed on
2012/10/05
21:53 UTC
Read the original article
Hit count: 303
?itle might be a little bit incorrect. :) Anyway, I'm building a software where employees input time they worked per day (work hours) and employer "pays" for this time. "Payment" is done outside this system, so employer just "confirms" (checkbox or something like this) which work hours are paid.
So the question is - what is the best way (both UI and data storage wise) to implement this? At the moment I have this idea:
Employee selects week and manually (with some Javascript helpers, like "fill the same time for all days") inputs work hours in every day of the week. Employer confirms payment the same way employee inputs data (selects week, confirms each day). Data is saved in DB as unix timestamp (one day per table row).
Problem is 14 inputs (7 days * ("hours from" + "hours to" input), yet this approach seems kinda easy to implement.
Maybe I'm overlooking something and this can be done differently and better? Maybe someone has any example of already working software?
© Programmers or respective owner