openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #24108
[Bug 1204224] [NEW] [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
Public bug reported:
When entering attendances you might encounter serious issue as depending
on the timezone, the attendances won't go on the correct timesheet.
This is due because a timesheet has its start and end date defined in as
DATE format. Thus it will mean timesheet start and end have no timezone
defined.
On the other hand, attendances will be in user timezone. This lead to
attendances which will be out of scope of their timesheet if the
timesheet was in local timezone too.
Now let's say that a DATE in database means the timesheet is in users'
timezone. Because a date isn't precise to be converted without
overlapping from UTC to local timezone. And because it doesn't make sens
for an Australian business to have its timesheets in UTC.
Then we need to match attendances to this local timezone when trying to
match the sheet_id on attendance. And as we have no timezone field
defined on timesheet what we can do is taking this information from the
employee.
See linked MP
** Affects: ocb-addons
Importance: Undecided
Status: New
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1204224
Title:
[7.0] hr_timesheet_sheet - timesheet start and end are without
timezone as it is date instead of datetime
Status in OpenERP Community Backports (Addons):
New
Status in OpenERP Addons (modules):
New
Bug description:
When entering attendances you might encounter serious issue as
depending on the timezone, the attendances won't go on the correct
timesheet.
This is due because a timesheet has its start and end date defined in
as DATE format. Thus it will mean timesheet start and end have no
timezone defined.
On the other hand, attendances will be in user timezone. This lead to
attendances which will be out of scope of their timesheet if the
timesheet was in local timezone too.
Now let's say that a DATE in database means the timesheet is in users'
timezone. Because a date isn't precise to be converted without
overlapping from UTC to local timezone. And because it doesn't make
sens for an Australian business to have its timesheets in UTC.
Then we need to match attendances to this local timezone when trying
to match the sheet_id on attendance. And as we have no timezone field
defined on timesheet what we can do is taking this information from
the employee.
See linked MP
To manage notifications about this bug go to:
https://bugs.launchpad.net/ocb-addons/+bug/1204224/+subscriptions
Follow ups
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Martin Trigaux (OpenERP), 2014-04-28
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Houssine, 2013-11-07
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-11-01
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Houssine, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-10-31
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-10-29
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-10-24
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-09-11
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Christophe Chauvet - http://www.syleam.fr/, 2013-09-11
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-09-03
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Launchpad Bug Tracker, 2013-09-03
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-09-03
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Amit Parik (OpenERP), 2013-07-26
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Bill Ennals, 2013-07-23
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-07-23
-
[Bug 1204224] Re: [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Launchpad Bug Tracker, 2013-07-23
-
[Bug 1204224] [NEW] [7.0] hr_timesheet_sheet - timesheet start and end are without timezone as it is date instead of datetime
From: Yannick Vaucher @ Camptocamp, 2013-07-23
References