1 # -*- coding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
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.
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.
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/>.
20 ##############################################################################
22 from openerp.osv import fields,osv
23 from openerp.tools.translate import _
24 import openerp.addons.decimal_precision as dp
26 class analytic_user_funct_grid(osv.osv):
27 _name="analytic.user.funct.grid"
28 _description= "Price per User"
30 'user_id': fields.many2one("res.users", "User", required=True,),
31 'product_id': fields.many2one("product.product", "Service", required=True,),
32 'account_id': fields.many2one("account.analytic.account", "Analytic Account", required=True,),
33 'uom_id': fields.related("product_id", "uom_id", relation="product.uom", string="Unit of Measure", type="many2one", readonly=True),
34 'price': fields.float('Price', digits_compute=dp.get_precision('Product Price'), help="Price per hour for this user.", required=True),
36 def onchange_user_product_id(self, cr, uid, ids, user_id, product_id, context=None):
39 emp_obj = self.pool.get('hr.employee')
40 emp_id = emp_obj.search(cr, uid, [('user_id', '=', user_id)], context=context)
45 emp = emp_obj.browse(cr, uid, emp_id[0], context=context)
46 if emp.product_id and not product_id:
47 value['product_id'] = emp.product_id.id
50 prod = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
52 value['price'] = prod.list_price
53 value['uom_id'] = prod.uom_id.id
54 return {'value': value}
57 class account_analytic_account(osv.osv):
58 _inherit = "account.analytic.account"
60 'user_product_ids': fields.one2many('analytic.user.funct.grid', 'account_id', 'Users/Products Rel.'),
64 class hr_analytic_timesheet(osv.osv):
65 _inherit = "hr.analytic.timesheet"
66 # Look in account, if no value for the user => look in parent until there is no more parent to look
67 # Take the first found... if nothing found => return False
68 def _get_related_user_account_recursiv(self, cr, uid, user_id, account_id):
69 temp=self.pool.get('analytic.user.funct.grid').search(cr, uid, [('user_id', '=', user_id),('account_id', '=', account_id) ])
70 account=self.pool.get('account.analytic.account').browse(cr, uid, account_id)
75 return self._get_related_user_account_recursiv(cr, uid, user_id, account.parent_id.id)
79 def on_change_account_id(self, cr, uid, ids, account_id, user_id=False, unit_amount=0):
82 #avoid a useless call to super
86 return super(hr_analytic_timesheet, self).on_change_account_id(cr, uid, ids, account_id)
88 #get the browse record related to user_id and account_id
89 temp = self._get_related_user_account_recursiv(cr, uid, user_id, account_id)
91 #if there isn't any record for this user_id and account_id
92 return super(hr_analytic_timesheet, self).on_change_account_id(cr, uid, ids, account_id)
94 #get the old values from super and add the value from the new relation analytic_user_funct_grid
95 r = self.pool.get('analytic.user.funct.grid').browse(cr, uid, temp)[0]
96 res.setdefault('value',{})
97 res['value']= super(hr_analytic_timesheet, self).on_change_account_id(cr, uid, ids, account_id)['value']
98 res['value']['product_id'] = r.product_id.id
99 res['value']['product_uom_id'] = r.product_id.uom_id.id
101 #the change of product has to impact the amount, uom and general_account_id
102 a = r.product_id.property_account_expense.id
104 a = r.product_id.categ_id.property_account_expense_categ.id
106 raise osv.except_osv(_('Error!'),
107 _('There is no expense account define ' \
108 'for this product: "%s" (id:%d)') % \
109 (r.product_id.name, r.product_id.id,))
110 # Compute based on pricetype
112 amount_unit = self.on_change_unit_amount(cr, uid, ids,
113 r.product_id.id, unit_amount, False, r.product_id.uom_id.id)['value']['amount']
114 amount = unit_amount * amount_unit
115 res ['value']['amount']= - round(amount, 2)
116 res ['value']['general_account_id']= a
119 def on_change_user_id(self, cr, uid, ids, user_id, account_id, unit_amount=0):
120 res = super(hr_analytic_timesheet, self).on_change_user_id(cr, uid, ids, user_id)
123 #get the browse record related to user_id and account_id
124 temp = self._get_related_user_account_recursiv(cr, uid, user_id, account_id)
126 #add the value from the new relation analytic_user_funct_grid
127 r = self.pool.get('analytic.user.funct.grid').browse(cr, uid, temp)[0]
128 res['value']['product_id'] = r.product_id.id
130 #the change of product has to impact the amount, uom and general_account_id
131 a = r.product_id.property_account_expense.id
133 a = r.product_id.categ_id.property_account_expense_categ.id
135 raise osv.except_osv(_('Error!'),
136 _('There is no expense account define ' \
137 'for this product: "%s" (id:%d)') % \
138 (r.product_id.name, r.product_id.id,))
139 # Compute based on pricetype
141 amount_unit = self.on_change_unit_amount(cr, uid, ids,
142 r.product_id.id, unit_amount, False, r.product_id.uom_id.id)['value']['amount']
144 amount = unit_amount * amount_unit
145 res ['value']['amount']= - round(amount, 2)
146 res ['value']['general_account_id']= a
149 class account_analytic_line(osv.osv):
150 _inherit = "account.analytic.line"
151 def _get_invoice_price(self, cr, uid, account, product_id, user_id, qty, context = {}):
152 for grid in account.user_product_ids:
153 if grid.user_id.id==user_id:
155 return super(account_analytic_line, self)._get_invoice_price(cr, uid, account, product_id, user_id, qty, context)