diff options
| author | Christophe Simonis <christophe@tinyerp.com> | 2008-11-20 16:38:25 +0100 |
|---|---|---|
| committer | Christophe Simonis <christophe@tinyerp.com> | 2008-11-20 16:38:25 +0100 |
| commit | d126387243ff9ecc5f295083dde0a0e2f5a33b1f (patch) | |
| tree | 30e8f59a3195479e6182d04e2d64927e39b9f8a7 /addons/hr/report | |
| parent | 1557e18e44d6124d8a88e5e249b38ba58149da1d (diff) | |
[FIX] use string instead of numeric format for day of week
lp bug: https://launchpad.net/bugs/289035 fixed
bzr revid: christophe@tinyerp.com-20081120153825-ksfmm1rtrr359c6c
Diffstat (limited to 'addons/hr/report')
| -rw-r--r-- | addons/hr/report/bymonth.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/addons/hr/report/bymonth.py b/addons/hr/report/bymonth.py index a2f05b75e2e..98a613608b1 100644 --- a/addons/hr/report/bymonth.py +++ b/addons/hr/report/bymonth.py @@ -94,14 +94,14 @@ class report_custom(report_rml): inner join (hr_timesheet_group as g inner join hr_timesheet_employee_rel as rel on rel.tgroup_id = g.id and rel.emp_id = %s) on t.tgroup_id = g.id - where dayofweek = %s + where dayofweek = '%s' and date_from = (select max(date_from) from hr_timesheet inner join (hr_timesheet_employee_rel inner join hr_timesheet_group on hr_timesheet_group.id = hr_timesheet_employee_rel.tgroup_id and hr_timesheet_employee_rel.emp_id = %s) on hr_timesheet.tgroup_id = hr_timesheet_group.id - where dayofweek = %s and date_from <= '%s') + where dayofweek = '%s' and date_from <= '%s') order by date_from desc ''' isPH = False |