← Back to branch summary

~technofluid-team/openobject-addons/technofluid_multiple_installations

« back to all changes in this revision

Viewing changes to hr/report/attendance_errors.py

  • Committer: pinky
  • Date: 2006-12-07 13:41:40 UTC
  • Revision ID: pinky-dedd7f8a42bd4557112a0513082691b8590ad6cc
New trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
hr/report/attendance_errors.py
 
1
##############################################################################
 
2
#
 
3
# Copyright (c) 2006 TINY SPRL. (http://tiny.be) All Rights Reserved.
 
4
#                    Fabien Pinckaers <fp@tiny.Be>
 
5
#
 
6
# WARNING: This program as such is intended to be used by professional
 
7
# programmers who take the whole responsability of assessing all potential
 
8
# consequences resulting from its eventual inadequacies and bugs
 
9
# End users who are looking for a ready-to-use solution with commercial
 
10
# garantees and support are strongly adviced to contract a Free Software
 
11
# Service Company
 
12
#
 
13
# This program is Free Software; you can redistribute it and/or
 
14
# modify it under the terms of the GNU General Public License
 
15
# as published by the Free Software Foundation; either version 2
 
16
# of the License, or (at your option) any later version.
 
17
#
 
18
# This program is distributed in the hope that it will be useful,
 
19
# but WITHOUT ANY WARRANTY; without even the implied warranty of
 
20
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 
21
# GNU General Public License for more details.
 
22
#
 
23
# You should have received a copy of the GNU General Public License
 
24
# along with this program; if not, write to the Free Software
 
25
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 
26
#
 
27
##############################################################################
 
28
 
 
29
 
 
30
import time
 
31
from report import report_sxw
 
32
 
 
33
class attendance_print(report_sxw.rml_parse):
 
34
        def __init__(self, cr, uid, name, context):
 
35
                super(attendance_print, self).__init__(cr, uid, name, context)
 
36
                self.localcontext.update({
 
37
                        'time': time,
 
38
                        'lst': self._lst,
 
39
                        'total': self._lst_total,
 
40
                })
 
41
 
 
42
        def _sign(self, dt):
 
43
                if abs(dt.days)>1:
 
44
                        format = '%d day'+(((abs(dt.days)>=2) and 's') or '')+' %H:%M:%S'
 
45
                else:
 
46
                        format = '%H:%M:%S'
 
47
                if dt.seconds<0:
 
48
                        return dt.strftime('- '+format)
 
49
                else:
 
50
                        return dt.strftime(format)
 
51
 
 
52
        def _lst(self, employee_id, dt_from, dt_to, max, *args):
 
53
                self.cr.execute('select name as date, create_date, action, create_date-name as delay from hr_attendance where employee_id=%d and name<=%s and name>=%s and action in (%s,%s) order by name', (employee_id, dt_to, dt_from, 'sign_in', 'sign_out'))
 
54
                res = self.cr.dictfetchall()
 
55
                for r in res:
 
56
                        if r['action']=='sign_out':
 
57
                                r['delay'] = - r['delay']
 
58
                        temp = r['delay'].seconds
 
59
                        r['delay'] = self._sign(r['delay'])
 
60
                        if abs(temp) < max*60:
 
61
                                r['delay2'] = r['delay']
 
62
                        else:
 
63
                                r['delay2'] = '/'
 
64
                return res
 
65
 
 
66
        def _lst_total(self, employee_id, dt_from, dt_to, max, *args):
 
67
                self.cr.execute('select name as date, create_date, action, create_date-name as delay from hr_attendance where employee_id=%d and name<=%s and name>=%s and action in (%s,%s)', (employee_id, dt_to, dt_from, 'sign_in', 'sign_out'))
 
68
                res = self.cr.dictfetchall()
 
69
                if not res:
 
70
                        return ('/','/')
 
71
                total = 0
 
72
                total2 = 0
 
73
                for r in res:
 
74
                        if r['action']=='sign_out':
 
75
                                r['delay'] = - r['delay']
 
76
                        total += r['delay']
 
77
                        if abs(r['delay'].seconds) < max*60:
 
78
                                total2 += r['delay']
 
79
 
 
80
                return (self._sign(total),total2 and self._sign(total2))
 
81
 
 
82
report_sxw.report_sxw('report.hr.timesheet.attendance.error', 'hr.employee', 'addons/hr/report/attendance_errors.rml',parser=attendance_print)
 
83