addons/hr_timesheet_sheet/report/hr_timesheet_report.py

   1 # -*- coding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    OpenERP, Open Source Management Solution
   5 #    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
   6 #
   7 #    This program is free software: you can redistribute it and/or modify
   8 #    it under the terms of the GNU Affero General Public License as
   9 #    published by the Free Software Foundation, either version 3 of the
  10 #    License, or (at your option) any later version.
  11 #
  12 #    This program is distributed in the hope that it will be useful,
  13 #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  14 #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15 #    GNU Affero General Public License for more details.
  16 #
  17 #    You should have received a copy of the GNU Affero General Public License
  18 #    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  19 #
  20 ##############################################################################
  21
  22 from openerp import tools
  23 from openerp.osv import fields,osv
  24
  25 class hr_timesheet_report(osv.osv):
  26     _inherit = "hr.timesheet.report"
  27     _columns = {
  28         'to_invoice': fields.many2one('hr_timesheet_invoice.factor', 'Type of Invoicing',readonly=True),
  29         'nbr': fields.integer('#Nbr',readonly=True),
  30         'total_diff': fields.float('#Total Diff',readonly=True),
  31         'total_timesheet': fields.float('#Total Timesheet',readonly=True),
  32         'total_attendance': fields.float('#Total Attendance',readonly=True),
  33         'department_id':fields.many2one('hr.department','Department',readonly=True),
  34         'date_from': fields.date('Date from',readonly=True,),
  35         'date_to': fields.date('Date to',readonly=True),
  36         'state' : fields.selection([
  37             ('new', 'New'),
  38             ('draft','Draft'),
  39             ('confirm','Confirmed'),
  40             ('done','Done')], 'Status', readonly=True),
  41         }
  42
  43     def _select(self):
  44         return super(hr_timesheet_report, self)._select() + """,
  45                         htss.name,
  46                         htss.date_from,
  47                         htss.date_to,
  48                         count(*) as nbr,
  49                         (SELECT   sum(day.total_difference)
  50                             FROM hr_timesheet_sheet_sheet AS sheet
  51                             LEFT JOIN hr_timesheet_sheet_sheet_day AS day
  52                             ON (sheet.id = day.sheet_id) where sheet.id=htss.id) as total_diff,
  53                         (SELECT sum(day.total_timesheet)
  54                             FROM hr_timesheet_sheet_sheet AS sheet
  55                             LEFT JOIN hr_timesheet_sheet_sheet_day AS day
  56                             ON (sheet.id = day.sheet_id) where sheet.id=htss.id) as total_timesheet,
  57                         (SELECT sum(day.total_attendance)
  58                             FROM hr_timesheet_sheet_sheet AS sheet
  59                             LEFT JOIN hr_timesheet_sheet_sheet_day AS day
  60                             ON (sheet.id = day.sheet_id) where sheet.id=htss.id) as total_attendance,
  61                         aal.to_invoice,
  62                         htss.department_id,
  63                         htss.state"""
  64
  65     def _from(self):
  66         return super(hr_timesheet_report, self)._from() + "left join hr_timesheet_sheet_sheet as htss ON (hat.sheet_id=htss.id)"
  67
  68     def _group_by(self):
  69         return super(hr_timesheet_report, self)._group_by() + """,
  70                         htss.date_from,
  71                         htss.date_to,
  72                         aal.unit_amount,
  73                         aal.amount,
  74                         aal.to_invoice,
  75                         htss.name,
  76                         htss.state,
  77                         htss.id,
  78                         htss.department_id"""
  79
  80
  81 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: