[FIX] Project_timesheet: wrong calculation on amount field on timesheet line
[odoo/odoo.git] / addons / project_timesheet / project_timesheet.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 import time
22 import datetime
23
24 from osv import fields, osv
25 import pooler
26 import tools
27 from tools.translate import _
28
29 class project_work(osv.osv):
30     _inherit = "project.task.work"
31
32     def get_user_related_details(self, cr, uid, user_id):
33         res = {}
34         emp_obj = self.pool.get('hr.employee')
35         emp_id = emp_obj.search(cr, uid, [('user_id', '=', user_id)])
36         if not emp_id:
37             user_name = self.pool.get('res.users').read(cr, uid, [user_id], ['name'])[0]['name']
38             raise osv.except_osv(_('Bad Configuration !'),
39                  _('No employee defined for user "%s". You must create one.')% (user_name,))
40         emp = self.pool.get('hr.employee').browse(cr, uid, emp_id[0])
41         if not emp.product_id:
42             raise osv.except_osv(_('Bad Configuration !'),
43                  _('No product defined on the related employee.\nFill in the timesheet tab of the employee form.'))
44
45         if not emp.journal_id:
46             raise osv.except_osv(_('Bad Configuration !'),
47                  _('No journal defined on the related employee.\nFill in the timesheet tab of the employee form.'))
48
49         a =  emp.product_id.product_tmpl_id.property_account_expense.id
50         if not a:
51             a = emp.product_id.categ_id.property_account_expense_categ.id
52             if not a:
53                 raise osv.except_osv(_('Bad Configuration !'),
54                         _('No product and product category property account defined on the related employee.\nFill in the timesheet tab of the employee form.'))
55         res['product_id'] = emp.product_id.id
56         res['journal_id'] = emp.journal_id.id
57         res['general_account_id'] = a
58         res['product_uom_id'] = emp.product_id.uom_id.id
59         return res
60
61     def create(self, cr, uid, vals, *args, **kwargs):
62         obj_timesheet = self.pool.get('hr.analytic.timesheet')
63         task_obj = self.pool.get('project.task')
64         vals_line = {}
65         context = kwargs.get('context', {})
66         obj_task = task_obj.browse(cr, uid, vals['task_id'])
67         result = self.get_user_related_details(cr, uid, vals.get('user_id', uid))
68         vals_line['name'] = '%s: %s' % (tools.ustr(obj_task.name), tools.ustr(vals['name']) or '/')
69         vals_line['user_id'] = vals['user_id']
70         vals_line['product_id'] = result['product_id']
71         vals_line['date'] = vals['date'][:10]
72         vals_line['unit_amount'] = vals['hours']
73         acc_id = obj_task.project_id.analytic_account_id.id
74         vals_line['account_id'] = acc_id
75         res = obj_timesheet.on_change_account_id(cr, uid, False, acc_id)
76         if res.get('value'):
77             vals_line.update(res['value'])
78         vals_line['general_account_id'] = result['general_account_id']
79         vals_line['journal_id'] = result['journal_id']
80         vals_line['amount'] = 0.0
81         vals_line['product_uom_id'] = result['product_uom_id']
82         amount = vals_line['unit_amount']
83         prod_id = vals_line['product_id']
84         unit = False
85         timeline_id = obj_timesheet.create(cr, uid, vals=vals_line, context=context)
86
87         # Compute based on pricetype
88         amount_unit = obj_timesheet.on_change_unit_amount(cr, uid, timeline_id,
89             prod_id, amount, unit, context=context)
90         if amount_unit and 'amount' in amount_unit.get('value',{}):
91             updv = { 'amount': amount_unit['value']['amount'] * (-1.0) }
92             obj_timesheet.write(cr, uid, [timeline_id], updv, context=context)
93         vals['hr_analytic_timesheet_id'] = timeline_id
94         return super(project_work,self).create(cr, uid, vals, *args, **kwargs)
95
96     def write(self, cr, uid, ids, vals, context=None):
97         if context is None:
98             context = {}
99         obj = self.pool.get('hr.analytic.timesheet')
100         timesheet_obj = self.pool.get('hr.analytic.timesheet')
101         if isinstance(ids, (long, int)):
102             ids = [ids,]
103
104         for task in self.browse(cr, uid, ids, context=context):
105             line_id = task.hr_analytic_timesheet_id
106             if not line_id:
107                 # if a record is deleted from timesheet, the line_id will become
108                 # null because of the foreign key on-delete=set null
109                 continue
110             vals_line = {}
111             if 'name' in vals:
112                 vals_line['name'] = '%s: %s' % (tools.ustr(task.task_id.name), tools.ustr(vals['name']) or '/')
113             if 'user_id' in vals:
114                 vals_line['user_id'] = vals['user_id']
115                 result = self.get_user_related_details(cr, uid, vals['user_id'])
116                 for fld in ('product_id', 'general_account_id', 'journal_id', 'product_uom_id'):
117                     if result.get(fld, False):
118                         vals_line[fld] = result[fld]
119                         
120             if 'date' in vals:
121                 vals_line['date'] = vals['date'][:10]
122             if 'hours' in vals:
123                 vals_line['unit_amount'] = vals['hours']
124                 prod_id = vals_line.get('product_id', line_id.product_id.id) # False may be set
125                 # Compute based on pricetype
126                 amount_unit = obj.on_change_unit_amount(cr, uid, line_id.id,
127                     prod_id=prod_id,
128                     unit_amount=vals_line['unit_amount'], unit=False, context=context)
129
130                 if amount_unit and 'amount' in amount_unit.get('value',{}):
131                     vals_line['amount'] = amount_unit['value']['amount'] * (-1.0)
132
133             obj.write(cr, uid, [line_id.id], vals_line, context=context)
134             
135         return super(project_work,self).write(cr, uid, ids, vals, context)
136
137     def unlink(self, cr, uid, ids, *args, **kwargs):
138         hat_obj = self.pool.get('hr.analytic.timesheet')
139         hat_ids = []
140         for task in self.browse(cr, uid, ids):
141             if task.hr_analytic_timesheet_id:
142                 hat_ids.append(task.hr_analytic_timesheet_id)
143 #            delete entry from timesheet too while deleting entry to task.
144         if hat_ids:
145             hat_obj.unlink(cr, uid, hat_ids, *args, **kwargs)
146         return super(project_work,self).unlink(cr, uid, ids, *args, **kwargs)
147
148     _columns={
149         'hr_analytic_timesheet_id':fields.many2one('hr.analytic.timesheet','Related Timeline Id', ondelete='set null'),
150     }
151
152 project_work()
153
154 class task(osv.osv):
155     _inherit = "project.task"
156
157     def unlink(self, cr, uid, ids, *args, **kwargs):
158         for task_obj in self.browse(cr, uid, ids, *args, **kwargs):
159             if task_obj.work_ids:
160                 work_ids = [x.id for x in task_obj.work_ids]
161                 self.pool.get('project.task.work').unlink(cr, uid, work_ids, *args, **kwargs)
162
163         return super(task,self).unlink(cr, uid, ids, *args, **kwargs)
164
165     def write(self, cr, uid, ids,vals,context=None):
166         if context is None:
167             context = {}
168         if (vals.has_key('project_id') and vals['project_id']) or (vals.has_key('name') and vals['name']):
169             vals_line = {}
170             hr_anlytic_timesheet = self.pool.get('hr.analytic.timesheet')
171             task_obj_l = self.browse(cr, uid, ids, context)
172             if (vals.has_key('project_id') and vals['project_id']):
173                 project_obj = self.pool.get('project.project').browse(cr, uid, vals['project_id'])
174                 acc_id = project_obj.analytic_account_id.id
175
176             for task_obj in task_obj_l:
177                 if len(task_obj.work_ids):
178                     for task_work in task_obj.work_ids:
179                         line_id = task_work.hr_analytic_timesheet_id
180                         if (vals.has_key('project_id') and vals['project_id']):
181                             vals_line['account_id'] = acc_id
182                         if (vals.has_key('name') and vals['name']):
183                             vals_line['name'] = '%s: %s' % (tools.ustr(vals['name']), tools.ustr(task_work.name) or '/')
184                         hr_anlytic_timesheet.write(cr, uid, [line_id], vals_line, {})
185         return super(task,self).write(cr, uid, ids, vals, context)
186
187 task()
188
189 class project_project(osv.osv):
190     _inherit = "project.project"
191
192     def name_get(self, cr, user, ids, context=None):
193         if context is None:
194             context = {}
195         result = []
196         for project in self.browse(cr, user, ids, context):
197             name = "[%s] %s" % (project.analytic_account_id and project.analytic_account_id.code or '?', project.name)
198             result.append((project.id, name))
199         return result
200
201 project_project()
202
203 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: