hr_attendance_analysis calculates attendance wrong if starting time is different to starting time defined in contract

Bug #1220097 reported by Laura
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
HR - Timesheet Management
New
Undecided
Unassigned

Bug Description

I installed hr_attendance_analysis v7 to empty db and when I create some test data (we have to insert attendances manually because people working in production have just clock cards so office people insert their attendances based on the clock card data manually to OE) the attendance duration is shown incorrectly if starting times are different to defined working scheludule starting time (in this case 8:00). See attached image.

In contract it is defined that working times are from 8:00 to 18:00 and as seen on the screenshot if attendance sign in happens at 8:00 and sign out at 18:00 everything works fine. Everything worked fine also if sign in happens at 8:00 and sign out 19:00 i.e. 1 hour overtime is shown (this is not shown in the screenshot because I tested this after screenshot was taken).

However as you can see on the screenshot if the sign in happens later than 8:00 (third row in screenshot) it is still assumed that employee signed in 8:00. And if sign in happens earlier than 8:00 (first row in screenshot) something really weird happens and it calculates attendance duration totally wrong.

I'm using saas-1 version of OE.
My time zone is UTC+8 if that matters (because this could be connected to timezone problems).

Revision history for this message
Laura (laura-jarvenpaa) wrote :
Revision history for this message
Muhammad Arsalan Ali Khan (m-arsalan-khan) wrote :

did you find any solution for this. I am experiencing the same problem..

Revision history for this message
Laura (laura-jarvenpaa) wrote :

No, but I found out why it fails. It is indeed timezone problem but it is not only in this module but in all modules that uses dates. Problem is actually connected to date change on utc e.g. for us it shows weird results for times that starts before eight as we are from utc+8 which means that in utc times before 8 are on previous date as it results on utc time which is not for today but day before.

I solved this just by recoding whole module after all it was not doing exactly what I needed so I modified it a lot and as on those modifications only duration matters the probmem with timezone vanished.

Revision history for this message
mohamed shedeed (cqq-102) wrote :

is there any chance u could share with us your updates we r having alot of problems with the module and cant find anyway to figur this out ?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.