← Back to branch summary

~21-openerp/+junk/hr6.1

« back to all changes in this revision

Viewing changes to hr_holidays/report/hr_holidays_report.py

  • Committer: Carlos
  • Date: 2012-10-22 09:57:54 UTC
  • Revision ID: carlos@viavansi-desktop-20121022095754-5f3atcrs1b5975ly
vacaciones y activos, inicial

Show diffs side-by-side

added added

removed removed

Lines of Context:
hr_holidays/report/hr_holidays_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
import tools
 
23
from osv import fields,osv
 
24
 
 
25
class hr_holidays_remaining_leaves_user(osv.osv):
 
26
    _name = "hr.holidays.remaining.leaves.user"
 
27
    _description = "Total holidays by type"
 
28
    _auto = False
 
29
    _columns = {
 
30
        'name': fields.char('Employee', size=64),
 
31
        'no_of_leaves': fields.integer('Remaining leaves'),
 
32
        'user_id': fields.many2one('res.users', 'User'),
 
33
        'leave_type': fields.char('Leave Type', size=64),
 
34
        }
 
35
 
 
36
    def init(self, cr):
 
37
        tools.drop_view_if_exists(cr, 'hr_holidays_remaining_leaves_user')
 
38
        cr.execute("""
 
39
            CREATE or REPLACE view hr_holidays_remaining_leaves_user as (
 
40
                 SELECT
 
41
                    min(hrs.id) as id,
 
42
                    rr.name as name,
 
43
                    sum(hrs.number_of_days) as no_of_leaves,
 
44
                    rr.user_id as user_id,
 
45
                    hhs.name as leave_type
 
46
                FROM
 
47
                    hr_holidays as hrs, hr_employee as hre,
 
48
                    resource_resource as rr,hr_holidays_status as hhs
 
49
                WHERE
 
50
                    hrs.employee_id = hre.id and
 
51
                    hre.resource_id =  rr.id and
 
52
                    hhs.id = hrs.holiday_status_id
 
53
                GROUP BY
 
54
                    rr.name,rr.user_id,hhs.name
 
55
            )
 
56
        """)
 
57
 
 
58
hr_holidays_remaining_leaves_user()
 
59
 
 
60
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: