The approximation of saving clock in / clock out time in database

[prosenkiewicz]

Hi,
the time is saved with big approximation, so when you click multiple times during the day button to clock in and clock out, you get a difference between real time and calculated time around a few minutes.

I noticed that with simple js timer, when clock out timer shows e.g 00:05:30 but after page refresh it shows 00:05:20.

Regards.

[dhanasingh]

ok, how many times did you click clock in and clock out during that 00:05:30 period ?
Can you get those clock in and clock out times from the clock in / our summary page ?

[prosenkiewicz]

the 00:05:30 was just an example. But this is the dump of our table wk_attendances
dump.txt

and this is the sql select statment we used to compare real time and calculated time.
select realtime, calctime, timestampdiff(SECOND, realtime, calctime) FROM (select from_unixtime(SUM(TIMESTAMPDIFF(SECOND, start_time, end_time))) as realtime, from_unixtime(sum(hours)*3600) as calctime from wk_attendances where user_id=1 and start_time like '2018-04-17 %') as t1;

Would also like to ask if there are chances that I get response for my pull request with polish translation, would appreciate it :)

Kind regards.