1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo import api, fields, models
class SaleOrderLine(models.Model):
_inherit = "sale.order.line"
margin = fields.Float(
"Margin", compute='_compute_margin',
digits='Product Price', store=True, groups="base.group_user")
margin_percent = fields.Float(
"Margin (%)", compute='_compute_margin', store=True, groups="base.group_user")
purchase_price = fields.Float(
string='Cost', compute="_compute_purchase_price",
digits='Product Price', store=True, readonly=False,
groups="base.group_user")
@api.depends('product_id', 'company_id', 'currency_id', 'product_uom')
def _compute_purchase_price(self):
for line in self:
if not line.product_id:
line.purchase_price = 0.0
continue
line = line.with_company(line.company_id)
product = line.product_id
product_cost = product.standard_price
if not product_cost:
# If the standard_price is 0
# Avoid unnecessary computations
# and currency conversions
if not line.purchase_price:
line.purchase_price = 0.0
continue
fro_cur = product.cost_currency_id
to_cur = line.currency_id or line.order_id.currency_id
if line.product_uom and line.product_uom != product.uom_id:
product_cost = product.uom_id._compute_price(
product_cost,
line.product_uom,
)
line.purchase_price = fro_cur._convert(
from_amount=product_cost,
to_currency=to_cur,
company=line.company_id or self.env.company,
date=line.order_id.date_order or fields.Date.today(),
round=False,
) if to_cur and product_cost else product_cost
# The pricelist may not have been set, therefore no conversion
# is needed because we don't know the target currency..
@api.depends('price_subtotal', 'product_uom_qty', 'purchase_price')
def _compute_margin(self):
for line in self:
line.margin = line.price_subtotal - (line.purchase_price * line.product_uom_qty)
line.margin_percent = line.price_subtotal and line.margin/line.price_subtotal
class SaleOrder(models.Model):
_inherit = "sale.order"
margin = fields.Monetary("Margin", compute='_compute_margin', store=True)
margin_percent = fields.Float("Margin (%)", compute='_compute_margin', store=True)
@api.depends('order_line.margin', 'amount_untaxed')
def _compute_margin(self):
if not all(self._ids):
for order in self:
order.margin = sum(order.order_line.mapped('margin'))
order.margin_percent = order.amount_untaxed and order.margin/order.amount_untaxed
else:
self.env["sale.order.line"].flush(['margin'])
# On batch records recomputation (e.g. at install), compute the margins
# with a single read_group query for better performance.
# This isn't done in an onchange environment because (part of) the data
# may not be stored in database (new records or unsaved modifications).
grouped_order_lines_data = self.env['sale.order.line'].read_group(
[
('order_id', 'in', self.ids),
], ['margin', 'order_id'], ['order_id'])
mapped_data = {m['order_id'][0]: m['margin'] for m in grouped_order_lines_data}
for order in self:
order.margin = mapped_data.get(order.id, 0.0)
order.margin_percent = order.amount_untaxed and order.margin/order.amount_untaxed
|
