# -*- 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