Odoo18-Base/addons/l10n_eu_oss/models/res_company.py
2025-01-06 10:57:38 +07:00

190 lines
9.7 KiB
Python

# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
import re
from itertools import product
from odoo import Command, api, models
from .eu_account_map import EU_ACCOUNT_MAP
from .eu_tag_map import EU_TAG_MAP
from .eu_tax_map import EU_TAX_MAP
class Company(models.Model):
_inherit = 'res.company'
@api.model
def _map_all_eu_companies_taxes(self):
''' Identifies EU companies and calls the _map_eu_taxes function
'''
eu_countries = self.env.ref('base.europe').country_ids
companies = self.search([('account_fiscal_country_id', 'in', eu_countries.ids)])
companies._map_eu_taxes()
def _map_eu_taxes(self):
'''Creates or updates Fiscal Positions for each EU country excluding the company's account_fiscal_country_id
'''
eu_countries = self.env.ref('base.europe').country_ids
oss_tax_groups = self.env['ir.model.data'].search([
('name', 'ilike', 'oss_tax_group'),
('module', '=', 'account'),
('model', '=', 'account.tax.group')])
for company in self:
# instantiate OSS taxes on the first branch with a TAX ID, default on root company
company = company.parent_ids.filtered(lambda c: c.vat)[-1:] or company.root_id
invoice_repartition_lines, refund_repartition_lines = company._get_repartition_lines_oss()
taxes = self.env['account.tax'].search([
*self.env['account.tax']._check_company_domain(company),
('type_tax_use', '=', 'sale'),
('amount_type', '=', 'percent'),
('tax_group_id', 'not in', oss_tax_groups.mapped('res_id'))
])
multi_tax_reports_countries_fpos = self.env['account.fiscal.position'].search([
('foreign_vat', '!=', False),
])
oss_countries = eu_countries - company.account_fiscal_country_id - multi_tax_reports_countries_fpos.country_id
for destination_country in oss_countries:
mapping = []
fpos = self.env['account.fiscal.position'].search([
('company_id', '=', company.id),
('country_id', '=', destination_country.id),
('auto_apply', '=', True),
('vat_required', '=', False),
('foreign_vat', '=', False)], limit=1)
if not fpos:
fpos = self.env['account.fiscal.position'].create({
'name': f'OSS B2C {destination_country.name}',
'country_id': destination_country.id,
'company_id': company.id,
'auto_apply': True,
})
foreign_taxes = {tax.amount: tax for tax in fpos.tax_ids.tax_dest_id if tax.amount_type == 'percent'}
for domestic_tax in taxes:
tax_amount = EU_TAX_MAP.get((domestic_tax.country_id.code, domestic_tax.amount, destination_country.code), False)
if tax_amount and domestic_tax not in fpos.tax_ids.tax_src_id:
if not foreign_taxes.get(tax_amount, False):
oss_tax_group_local_xml_id = f"{company.id}_oss_tax_group_{str(tax_amount).replace('.', '_')}_{company.account_fiscal_country_id.code}"
if not self.env.ref(f"account.{oss_tax_group_local_xml_id}", raise_if_not_found=False):
tg = self.env['account.tax.group'].search([
*self.env['account.tax.group']._check_company_domain(company),
('tax_payable_account_id', '!=', False)], limit=1)
self.env['ir.model.data'].create({
'name': oss_tax_group_local_xml_id,
'module': 'account',
'model': 'account.tax.group',
'res_id': self.env['account.tax.group'].create({
'name': f'OSS {tax_amount}%',
'country_id': company.account_fiscal_country_id.id,
'company_id': company.id,
'tax_payable_account_id': tg.tax_payable_account_id.id,
'tax_receivable_account_id': tg.tax_receivable_account_id.id,
}).id,
'noupdate': True,
})
foreign_taxes[tax_amount] = self.env['account.tax'].create({
'name': f'{tax_amount}% {destination_country.code} {destination_country.vat_label}',
'amount': tax_amount,
'invoice_repartition_line_ids': invoice_repartition_lines,
'refund_repartition_line_ids': refund_repartition_lines,
'type_tax_use': 'sale',
'description': f"{tax_amount}%",
'tax_group_id': self.env.ref(f'account.{oss_tax_group_local_xml_id}').id,
'country_id': company.account_fiscal_country_id.id,
'sequence': 1000,
'company_id': company.id,
})
mapping.append((0, 0, {'tax_src_id': domestic_tax.id, 'tax_dest_id': foreign_taxes[tax_amount].id}))
if mapping:
fpos.write({
'tax_ids': mapping
})
def _get_repartition_lines_oss(self):
self.ensure_one()
oss_account, oss_tags = self._get_oss_account(), self._get_oss_tags()
repartition_line_ids = {}
for doc_type, rep_type in product(('invoice', 'refund'), ('base', 'tax')):
vals = {'document_type': doc_type, 'repartition_type': rep_type, 'tag_ids': [Command.link(tag.id) for tag in oss_tags[f'{doc_type}_{rep_type}_tag']]}
if oss_account:
vals['account_id'] = oss_account.id
repartition_line_ids.setdefault(doc_type, []).append(Command.create(vals))
return repartition_line_ids['invoice'], repartition_line_ids['refund']
def _get_oss_account(self):
self.ensure_one()
if not (oss_account := self.env.ref(f'l10n_eu_oss.oss_tax_account_company_{self.id}', raise_if_not_found=False)):
oss_account = self._create_oss_account()
return oss_account
def _create_oss_account(self):
if (
self.chart_template in EU_ACCOUNT_MAP
and (oss_account_if_exists :=
self.env['account.account'].with_company(self).search([
('company_ids', '=', self.id),
('code', '=', EU_ACCOUNT_MAP[self.chart_template])
])
)
):
oss_account = oss_account_if_exists
else:
sales_tax_accounts = self.env['account.tax'].search([
*self.env['account.tax']._check_company_domain(self),
('type_tax_use', '=', 'sale'),
]).invoice_repartition_line_ids.mapped('account_id')
if not sales_tax_accounts:
return False
new_code = self.env['account.account'].with_company(self)._search_new_account_code(sales_tax_accounts[0].with_company(self).code)
oss_account = self.env['account.account'].create({
'name': f'{sales_tax_accounts[0].name} OSS',
'code': new_code,
'account_type': sales_tax_accounts[0].account_type,
'company_ids': [Command.link(self.id)],
'tag_ids': [(4, tag.id, 0) for tag in sales_tax_accounts[0].tag_ids],
})
self.env['ir.model.data'].create({
'name': f'oss_tax_account_company_{self.id}',
'module': 'l10n_eu_oss',
'model': 'account.account',
'res_id': oss_account.id,
'noupdate': True,
})
return oss_account
def _get_oss_tags(self):
oss_tag = self.env.ref('l10n_eu_oss.tag_oss')
country = None
# Try to use the VAT country if vat is set and easily guessable
if self.vat:
country_prefix = re.match('^[a-zA-Z]{2}|^', self.vat).group()
if country_prefix:
country = self.env['res.country'].search([('code', '=', country_prefix)], limit=1)
# otherwise fallback on the fiscal country
if not country:
country = self.account_fiscal_country_id
chart_template = self.env['account.chart.template']._guess_chart_template(country)
# If that l10n module isn't installed, it means the company doesn't use any tax report for that country
# and thus hasn't nor need those tax report tag
is_coa_module_installed = self.env['account.chart.template']._get_chart_template_mapping()[chart_template]['installed']
if not is_coa_module_installed:
chart_template = None
tag_for_country = EU_TAG_MAP.get(chart_template, {
'invoice_base_tag': None,
'invoice_tax_tag': None,
'refund_base_tag': None,
'refund_tax_tag': None,
})
mapping = {}
for repartition_line_key, tag_xml_id in tag_for_country.items():
tag = self.env.ref(tag_xml_id) if tag_xml_id else self.env['account.account.tag']
if tag and tag._name == "account.report.expression":
tag = tag._get_matching_tags("+")
mapping[repartition_line_key] = tag + oss_tag
return mapping