81 lines
3.2 KiB
Python
81 lines
3.2 KiB
Python
|
# -*- coding: utf-8 -*-
|
||
|
|
# Part of Odoo. See LICENSE file for full copyright and licensing details.
|
||
|
|
from odoo.addons.account.tests.common import AccountTestInvoicingCommon
|
||
|
|
from odoo.tests import tagged
|
||
|
|
|
||
|
|
|
||
|
|
@tagged('post_install', '-at_install')
|
||
|
|
class TestProductMargin(AccountTestInvoicingCommon):
|
||
|
|
|
||
|
|
def test_aggregates(self):
|
||
|
|
model = self.env['product.product']
|
||
|
|
field_names = [
|
||
|
|
'turnover', 'sale_avg_price', 'sale_num_invoiced', 'purchase_num_invoiced',
|
||
|
|
'sales_gap', 'purchase_gap', 'total_cost', 'sale_expected', 'normal_cost',
|
||
|
|
'total_margin', 'expected_margin', 'total_margin_rate', 'expected_margin_rate',
|
||
|
|
]
|
||
|
|
self.assertEqual(
|
||
|
|
model.fields_get(field_names, ['aggregator']),
|
||
|
|
dict.fromkeys(field_names, {'aggregator': 'sum'}),
|
||
|
|
f"Fields {', '.join(map(repr, field_names))} must be flagged as aggregatable.",
|
||
|
|
)
|
||
|
|
|
||
|
|
def test_product_margin(self):
|
||
|
|
''' In order to test the product_margin module '''
|
||
|
|
|
||
|
|
supplier = self.env['res.partner'].create({'name': 'Supplier'})
|
||
|
|
customer = self.env['res.partner'].create({'name': 'Customer'})
|
||
|
|
ipad = self.env['product.product'].create({
|
||
|
|
'name': 'Ipad',
|
||
|
|
'standard_price': 500.0,
|
||
|
|
'list_price': 750.0,
|
||
|
|
})
|
||
|
|
|
||
|
|
invoices = self.env['account.move'].create([
|
||
|
|
{
|
||
|
|
'move_type': 'in_invoice',
|
||
|
|
'partner_id': supplier.id,
|
||
|
|
'invoice_line_ids': [(0, 0, {'product_id': ipad.id, 'quantity': 10.0, 'price_unit': 300.0})],
|
||
|
|
},
|
||
|
|
{
|
||
|
|
'move_type': 'in_invoice',
|
||
|
|
'partner_id': supplier.id,
|
||
|
|
'invoice_line_ids': [(0, 0, {'product_id': ipad.id, 'quantity': 4.0, 'price_unit': 450.0})],
|
||
|
|
},
|
||
|
|
{
|
||
|
|
'move_type': 'out_invoice',
|
||
|
|
'partner_id': customer.id,
|
||
|
|
'invoice_line_ids': [(0, 0, {'product_id': ipad.id, 'quantity': 20.0, 'price_unit': 750.0})],
|
||
|
|
},
|
||
|
|
{
|
||
|
|
'move_type': 'out_invoice',
|
||
|
|
'partner_id': customer.id,
|
||
|
|
'invoice_line_ids': [(0, 0, {'product_id': ipad.id, 'quantity': 10.0, 'price_unit': 550.0})],
|
||
|
|
},
|
||
|
|
])
|
||
|
|
invoices.invoice_date = invoices[0].date
|
||
|
|
invoices.action_post()
|
||
|
|
|
||
|
|
result = ipad._compute_product_margin_fields_values()
|
||
|
|
|
||
|
|
# Sale turnover ( Quantity * Price Subtotal / Quantity)
|
||
|
|
sale_turnover = ((20.0 * 750.00) + (10.0 * 550.00))
|
||
|
|
|
||
|
|
# Expected sale (Total quantity * Sale price)
|
||
|
|
sale_expected = (750.00 * 30.0)
|
||
|
|
|
||
|
|
# Purchase total cost (Quantity * Unit price)
|
||
|
|
purchase_total_cost = ((10.0 * 300.00) + (4.0 * 450.00))
|
||
|
|
|
||
|
|
# Purchase normal cost ( Total quantity * Cost price)
|
||
|
|
purchase_normal_cost = (14.0 * 500.00)
|
||
|
|
|
||
|
|
total_margin = sale_turnover - purchase_total_cost
|
||
|
|
expected_margin = sale_expected - purchase_normal_cost
|
||
|
|
|
||
|
|
# Check total margin
|
||
|
|
self.assertEqual(result[ipad.id]['total_margin'], total_margin, "Wrong Total Margin.")
|
||
|
|
|
||
|
|
# Check expected margin
|
||
|
|
self.assertEqual(result[ipad.id]['expected_margin'], expected_margin, "Wrong Expected Margin.")
|