[FIX] account,hr,hr_recruitment,hr_payroll,product:- enforced _sql_constraint to...
[odoo/odoo.git] / addons / hr / hr.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 osv import fields, osv
23 import logging
24 import addons
25
26 class hr_employee_category(osv.osv):
27
28     def name_get(self, cr, uid, ids, context=None):
29         if not ids:
30             return []
31         reads = self.read(cr, uid, ids, ['name','parent_id'], context=context)
32         res = []
33         for record in reads:
34             name = record['name']
35             if record['parent_id']:
36                 name = record['parent_id'][1]+' / '+name
37             res.append((record['id'], name))
38         return res
39
40     def _name_get_fnc(self, cr, uid, ids, prop, unknow_none, context=None):
41         res = self.name_get(cr, uid, ids, context=context)
42         return dict(res)
43
44     _name = "hr.employee.category"
45     _description = "Employee Category"
46     _columns = {
47         'name': fields.char("Category", size=64, required=True),
48         'complete_name': fields.function(_name_get_fnc, type="char", string='Name'),
49         'parent_id': fields.many2one('hr.employee.category', 'Parent Category', select=True),
50         'child_ids': fields.one2many('hr.employee.category', 'parent_id', 'Child Categories')
51     }
52
53     def _check_recursion(self, cr, uid, ids, context=None):
54         level = 100
55         while len(ids):
56             cr.execute('select distinct parent_id from hr_employee_category where id IN %s', (tuple(ids), ))
57             ids = filter(None, map(lambda x:x[0], cr.fetchall()))
58             if not level:
59                 return False
60             level -= 1
61         return True
62
63     _constraints = [
64         (_check_recursion, 'Error ! You cannot create recursive Categories.', ['parent_id'])
65     ]
66
67 hr_employee_category()
68
69 class hr_job(osv.osv):
70
71     def _no_of_employee(self, cr, uid, ids, name, args, context=None):
72         res = {}
73         for job in self.browse(cr, uid, ids, context=context):
74             nb_employees = len(job.employee_ids or [])
75             res[job.id] = {
76                 'no_of_employee': nb_employees,
77                 'expected_employees': nb_employees + job.no_of_recruitment,
78             }
79         return res
80
81     _name = "hr.job"
82     _description = "Job Description"
83     _columns = {
84         'name': fields.char('Job Name', size=128, required=True, select=True),
85         'expected_employees': fields.function(_no_of_employee, string='Expected Employees', help='Required number of Employees in total for that job.', multi="no_of_employee", store=True),
86         'no_of_employee': fields.function(_no_of_employee, string="No of Employee", help='Number of employee with that job.', multi="no_of_employee", store=True),
87         'no_of_recruitment': fields.float('Expected in Recruitment'),
88         'employee_ids': fields.one2many('hr.employee', 'job_id', 'Employees'),
89         'description': fields.text('Job Description'),
90         'requirements': fields.text('Requirements'),
91         'department_id': fields.many2one('hr.department', 'Department'),
92         'company_id': fields.many2one('res.company', 'Company'),
93         'state': fields.selection([('open', 'In Position'),('old', 'Old'),('recruit', 'In Recruitement')], 'State', readonly=True, required=True),
94     }
95     _defaults = {
96         'expected_employees': 1,
97         'company_id': lambda self,cr,uid,c: self.pool.get('res.company')._company_default_get(cr, uid, 'hr.job', context=c),
98         'state': 'open',
99     }
100     
101     _sql_constraints = [
102         ('name_company_uniq', 'unique(name, company_id)', 'The name of the job position must be unique per company !'),
103     ]
104
105
106     def on_change_expected_employee(self, cr, uid, ids, no_of_recruitment, no_of_employee, context=None):
107         if context is None:
108             context = {}
109         return {'value': {'expected_employees': no_of_recruitment + no_of_employee}}
110
111     def job_old(self, cr, uid, ids, *args):
112         self.write(cr, uid, ids, {'state': 'old', 'no_of_recruitment': 0})
113         return True
114
115     def job_recruitement(self, cr, uid, ids, *args):
116         for job in self.browse(cr, uid, ids):
117             no_of_recruitment = job.no_of_recruitment == 0 and 1 or job.no_of_recruitment
118             self.write(cr, uid, [job.id], {'state': 'recruit', 'no_of_recruitment': no_of_recruitment})
119         return True
120
121     def job_open(self, cr, uid, ids, *args):
122         self.write(cr, uid, ids, {'state': 'open', 'no_of_recruitment': 0})
123         return True
124
125 hr_job()
126
127 class hr_employee(osv.osv):
128     _name = "hr.employee"
129     _description = "Employee"
130     _inherits = {'resource.resource': "resource_id"}
131     _columns = {
132         'country_id': fields.many2one('res.country', 'Nationality'),
133         'birthday': fields.date("Date of Birth"),
134         'ssnid': fields.char('SSN No', size=32, help='Social Security Number'),
135         'sinid': fields.char('SIN No', size=32, help="Social Insurance Number"),
136         'identification_id': fields.char('Identification No', size=32),
137         'otherid': fields.char('Other Id', size=64),
138         'gender': fields.selection([('male', 'Male'),('female', 'Female')], 'Gender'),
139         'marital': fields.selection([('single', 'Single'), ('married', 'Married'), ('widower', 'Widower'), ('divorced', 'Divorced')], 'Marital Status'),
140         'department_id':fields.many2one('hr.department', 'Department'),
141         'address_id': fields.many2one('res.partner.address', 'Working Address'),
142         'address_home_id': fields.many2one('res.partner.address', 'Home Address'),
143         'partner_id': fields.related('address_home_id', 'partner_id', type='many2one', relation='res.partner', readonly=True, help="Partner that is related to the current employee. Accounting transaction will be written on this partner belongs to employee."),
144         'bank_account_id':fields.many2one('res.partner.bank', 'Bank Account Number', domain="[('partner_id','=',partner_id)]", help="Employee bank salary account"),
145         'work_phone': fields.char('Work Phone', size=32, readonly=False),
146         'mobile_phone': fields.char('Work Mobile', size=32, readonly=False),
147         'work_email': fields.char('Work E-mail', size=240),
148         'work_location': fields.char('Office Location', size=32),
149         'notes': fields.text('Notes'),
150         'parent_id': fields.many2one('hr.employee', 'Manager'),
151         'category_ids': fields.many2many('hr.employee.category', 'employee_category_rel', 'emp_id', 'category_id', 'Categories'),
152         'child_ids': fields.one2many('hr.employee', 'parent_id', 'Subordinates'),
153         'resource_id': fields.many2one('resource.resource', 'Resource', ondelete='cascade', required=True),
154         'coach_id': fields.many2one('hr.employee', 'Coach'),
155         'job_id': fields.many2one('hr.job', 'Job'),
156         'photo': fields.binary('Photo'),
157         'passport_id':fields.char('Passport No', size=64)
158     }
159
160     def unlink(self, cr, uid, ids, context=None):
161         resource_obj = self.pool.get('resource.resource')
162         resource_ids = []
163         for employee in self.browse(cr, uid, ids, context=context):
164             resource = employee.resource_id
165             if resource:
166                 resource_ids.append(resource.id)
167         if resource_ids:
168             resource_obj.unlink(cr, uid, resource_ids, context=context)
169         return super(hr_employee, self).unlink(cr, uid, ids, context=context)
170
171     def onchange_address_id(self, cr, uid, ids, address, context=None):
172         if address:
173             address = self.pool.get('res.partner.address').browse(cr, uid, address, context=context)
174             return {'value': {'work_email': address.email, 'work_phone': address.phone, 'mobile_phone': address.mobile}}
175         return {'value': {}}
176
177     def onchange_company(self, cr, uid, ids, company, context=None):
178         address_id = False
179         if company:
180             company_id = self.pool.get('res.company').browse(cr, uid, company, context=context)
181             address = self.pool.get('res.partner').address_get(cr, uid, [company_id.partner_id.id], ['default'])
182             address_id = address and address['default'] or False
183         return {'value': {'address_id' : address_id}}
184
185     def onchange_department_id(self, cr, uid, ids, department_id, context=None):
186         value = {'parent_id': False}
187         if department_id:
188             department = self.pool.get('hr.department').browse(cr, uid, department_id)
189             value['parent_id'] = department.manager_id.id
190         return {'value': value}
191
192     def onchange_user(self, cr, uid, ids, user_id, context=None):
193         work_email = False
194         if user_id:
195             work_email = self.pool.get('res.users').browse(cr, uid, user_id, context=context).user_email
196         return {'value': {'work_email' : work_email}}
197
198     def _get_photo(self, cr, uid, context=None):
199         photo_path = addons.get_module_resource('hr','images','photo.png')
200         return open(photo_path, 'rb').read().encode('base64')
201
202     _defaults = {
203         'active': 1,
204         'photo': _get_photo,
205     }
206
207     def _check_recursion(self, cr, uid, ids, context=None):
208         level = 100
209         while len(ids):
210             cr.execute('SELECT DISTINCT parent_id FROM hr_employee WHERE id IN %s AND parent_id!=id',(tuple(ids),))
211             ids = filter(None, map(lambda x:x[0], cr.fetchall()))
212             if not level:
213                 return False
214             level -= 1
215         return True
216
217     _constraints = [
218         (_check_recursion, 'Error ! You cannot create recursive Hierarchy of Employees.', ['parent_id']),
219     ]
220
221 hr_employee()
222
223 class hr_department(osv.osv):
224     _description = "Department"
225     _inherit = 'hr.department'
226     _columns = {
227         'manager_id': fields.many2one('hr.employee', 'Manager'),
228         'member_ids': fields.one2many('hr.employee', 'department_id', 'Members', readonly=True),
229     }
230
231 hr_department()
232
233
234 class res_users(osv.osv):
235     _name = 'res.users'
236     _inherit = 'res.users'
237
238     def create(self, cr, uid, data, context=None):
239         user_id = super(res_users, self).create(cr, uid, data, context=context)
240         
241         # add shortcut unless 'noshortcut' is True in context
242         if not(context and context.get('noshortcut', False)):
243             data_obj = self.pool.get('ir.model.data')
244             try:
245                 data_id = data_obj._get_id(cr, uid, 'hr', 'ir_ui_view_sc_employee')
246                 view_id  = data_obj.browse(cr, uid, data_id, context=context).res_id
247                 self.pool.get('ir.ui.view_sc').copy(cr, uid, view_id, default = {
248                                             'user_id': user_id}, context=context)
249             except:
250                 # Tolerate a missing shortcut. See product/product.py for similar code.
251                 logging.getLogger('orm').debug('Skipped meetings shortcut for user "%s"', data.get('name','<new'))
252         
253         return user_id
254
255 res_users()
256
257
258 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: