58 lines
2.9 KiB
Python
58 lines
2.9 KiB
Python
|
from odoo import api, fields, models, _
|
||
|
|
|
||
|
|
|
||
|
|
class ProductProduct(models.Model):
|
||
|
|
_inherit = "product.product"
|
||
|
|
|
||
|
|
standard_price_update_warning = fields.Char(compute="_compute_standard_price_update_warning")
|
||
|
|
|
||
|
|
@api.onchange('standard_price')
|
||
|
|
def _compute_standard_price_update_warning(self):
|
||
|
|
undone_expenses = self.env['hr.expense']._read_group(
|
||
|
|
domain=[('state', 'in', ['draft', 'reported']), ('product_id', 'in', self.ids)],
|
||
|
|
groupby=['price_unit'],
|
||
|
|
)
|
||
|
|
# The following list is composed of all the unit_amounts of expenses that use this product and should NOT trigger a warning.
|
||
|
|
# Those are the amounts of any undone expense using this product and 0.0 which is the default unit_amount.
|
||
|
|
unit_amounts_no_warning = [self.env.company.currency_id.round(row[0]) for row in undone_expenses]
|
||
|
|
for product in self:
|
||
|
|
product.standard_price_update_warning = False
|
||
|
|
if undone_expenses:
|
||
|
|
rounded_price = self.env.company.currency_id.round(product.standard_price)
|
||
|
|
if rounded_price and (len(unit_amounts_no_warning) > 1 or (len(unit_amounts_no_warning) == 1 and rounded_price not in unit_amounts_no_warning)):
|
||
|
|
product.standard_price_update_warning = _(
|
||
|
|
"There are unsubmitted expenses linked to this category. Updating the category cost will change expense amounts. "
|
||
|
|
"Make sure it is what you want to do."
|
||
|
|
)
|
||
|
|
|
||
|
|
def write(self, vals):
|
||
|
|
result = super().write(vals)
|
||
|
|
if 'standard_price' in vals:
|
||
|
|
expenses_sudo = self.env['hr.expense'].sudo().search([
|
||
|
|
('company_id', '=', self.env.company.id),
|
||
|
|
('product_id', 'in', self.ids),
|
||
|
|
('state', 'in', ['reported', 'draft']),
|
||
|
|
])
|
||
|
|
for expense_sudo in expenses_sudo:
|
||
|
|
expense_product_sudo = expense_sudo.product_id
|
||
|
|
tax_domain = self.env['account.tax']._check_company_domain(expense_sudo.company_id)
|
||
|
|
product_has_cost = (
|
||
|
|
expense_product_sudo
|
||
|
|
and not expense_sudo.company_currency_id.is_zero(expense_product_sudo.standard_price)
|
||
|
|
)
|
||
|
|
expense_vals = {
|
||
|
|
'product_has_cost': product_has_cost,
|
||
|
|
'product_has_tax': bool(expense_product_sudo.supplier_taxes_id.filtered_domain(tax_domain)),
|
||
|
|
}
|
||
|
|
if product_has_cost:
|
||
|
|
expense_vals.update({
|
||
|
|
'price_unit': expense_product_sudo.standard_price,
|
||
|
|
})
|
||
|
|
else:
|
||
|
|
expense_vals.update({
|
||
|
|
'quantity': 1,
|
||
|
|
'price_unit': expense_sudo.total_amount
|
||
|
|
})
|
||
|
|
expense_sudo.write(expense_vals)
|
||
|
|
return result
|