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: 364
        
?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