diff options
Diffstat (limited to 'addons/l10n_be/xml_export.py')
| -rw-r--r-- | addons/l10n_be/xml_export.py | 301 |
1 files changed, 301 insertions, 0 deletions
diff --git a/addons/l10n_be/xml_export.py b/addons/l10n_be/xml_export.py new file mode 100644 index 00000000000..f64348cd539 --- /dev/null +++ b/addons/l10n_be/xml_export.py @@ -0,0 +1,301 @@ +# -*- coding: utf-8 -*- +############################################################################## +# +# Odoo, Open Source Management Solution +# Copyright (C) 2004-2014 OpenErp S.A. (<http://odoo.com>). +# +# This program is free software: you can redistribute it and/or modify +# it under the terms of the GNU Affero General Public License as +# published by the Free Software Foundation, either version 3 of the +# License, or (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU Affero General Public License for more details. +# +# You should have received a copy of the GNU Affero General Public License +# along with this program. If not, see <http://www.gnu.org/licenses/>. +# +############################################################################## +from openerp import models, api, _ +from openerp.exceptions import UserError +import calendar + + +class AccountFinancialReportXMLExport(models.AbstractModel): + _inherit = "account.financial.report.xml.export" + + @api.model + def is_xml_export_available(self, report_name, report_id=None): + if report_name == 'l10n.be.report.partner.vat.listing' or (report_name == 'account.financial.report' and report_id == self.env['ir.model.data'].xmlid_to_res_id('l10n_be.account_financial_report_l10n_be_tva0')): + return True + else: + return super(AccountFinancialReportXMLExport, self).is_xml_export_available(report_name, report_id) + + def do_xml_export(self, context): + if context.get_report_obj()._name == 'account.financial.report' and context.get_report_obj().id == self.env['ir.model.data'].xmlid_to_res_id('l10n_be.account_financial_report_l10n_be_tva0'): + return self._l10n_be_vat_export(context) + if context.get_report_obj()._name == 'l10n.be.report.partner.vat.listing': + return self._l10n_be_partner_vat_export(context) + else: + return super(AccountFinancialReportXMLExport, self).do_xml_export(context) + + @api.model + def check(self, report_name, report_id=None): + if report_name == 'account.financial.report' and report_id == self.env['ir.model.data'].xmlid_to_res_id('l10n_be.account_financial_report_l10n_be_tva0'): + company = self.env.user.company_id + vat_no = company.partner_id.vat + if not vat_no: + return _('No VAT number associated with your company.') + default_address = company.partner_id.address_get() + address = self.env['res.partner'].browse(default_address.get("default", company.partner_id)) + if not address.email: + return _('No email address associated with the company.') + if not address.phone: + return _('No phone associated with the company.') + return True + if report_name == 'l10n.be.report.partner.vat.listing': + company = self.env.user.company_id + vat_no = company.partner_id.vat + if not vat_no: + return _('No VAT number associated with your company.') + default_address = company.partner_id.address_get() + address = default_address.get('invoice', company.partner_id) + if not address.email: + return _('No email address associated with the company.') + if not address.phone: + return _('No phone associated with the company.') + return True + else: + return super(AccountFinancialReportXMLExport, self).check(report_name, report_id) + + def _l10n_be_partner_vat_export(self, context): + seq_declarantnum = self.env['ir.sequence'].get('declarantnum') + company = self.env.user.company_id + company_vat = company.partner_id.vat + + company_vat = company_vat.replace(' ', '').upper() + SenderId = company_vat[2:] + issued_by = company_vat[:2] + dnum = company_vat[2:] + seq_declarantnum[-4:] + street = city = country = '' + addr = company.partner_id.address_get(['invoice']) + if addr.get('invoice', False): + ads = self.env['res.partner'].browse([addr['invoice']])[0] + phone = ads.phone and ads.phone.replace(' ', '') or '' + email = ads.email or '' + city = ads.city or '' + zip = ads.zip or '' + if not city: + city = '' + if ads.street: + street = ads.street + if ads.street2: + street += ' ' + ads.street2 + if ads.country_id: + country = ads.country_id.code + + annual_listing_data = { + 'issued_by': issued_by, + 'company_vat': company_vat, + 'comp_name': company.name, + 'street': street, + 'zip': zip, + 'city': city, + 'country': country, + 'email': email, + 'phone': phone, + 'SenderId': SenderId, + 'period': context.date_from[0:4], + 'comments': context.summary or '', + } + + data_file = """<?xml version="1.0" encoding="ISO-8859-1"?> +<ns2:ClientListingConsignment xmlns="http://www.minfin.fgov.be/InputCommon" xmlns:ns2="http://www.minfin.fgov.be/ClientListingConsignment" ClientListingsNbr="1"> + <ns2:Representative> + <RepresentativeID identificationType="NVAT" issuedBy="%(issued_by)s">%(SenderId)s</RepresentativeID> + <Name>%(comp_name)s</Name> + <Street>%(street)s</Street> + <PostCode>%(zip)s</PostCode> + <City>%(city)s</City>""" + if annual_listing_data['country']: + data_file += "\n\t\t<CountryCode>%(country)s</CountryCode>" + data_file += """ + <EmailAddress>%(email)s</EmailAddress> + <Phone>%(phone)s</Phone> + </ns2:Representative>""" + data_file = data_file % annual_listing_data + + data_comp = """ + <ns2:Declarant> + <VATNumber>%(SenderId)s</VATNumber> + <Name>%(comp_name)s</Name> + <Street>%(street)s</Street> + <PostCode>%(zip)s</PostCode> + <City>%(city)s</City> + <CountryCode>%(country)s</CountryCode> + <EmailAddress>%(email)s</EmailAddress> + <Phone>%(phone)s</Phone> + </ns2:Declarant> + <ns2:Period>%(period)s</ns2:Period> + """ % annual_listing_data + + # Turnover and Farmer tags are not included + date_from = context.date_from[0:4] + '-01-01' + date_to = context.date_from[0:4] + '-12-31' + lines = context.get_report_obj().with_context(no_format=True, date_from=date_from, date_to=date_to).get_lines(context) + + data_client_info = '' + seq = 0 + sum_turnover = 0.00 + sum_tax = 0.00 + for line in lines: + seq += 1 + sum_turnover += line['columns'][1] + sum_tax += line['columns'][2] + amount_data = { + 'seq': str(seq), + 'only_vat': line['columns'][0][2:], + 'turnover': '%.2f' % line['columns'][1], + 'vat_amount': '%.2f' % line['columns'][2], + } + data_client_info += """ + <ns2:Client SequenceNumber="%(seq)s"> + <ns2:CompanyVATNumber issuedBy="BE">%(only_vat)s</ns2:CompanyVATNumber> + <ns2:TurnOver>%(turnover)s</ns2:TurnOver> + <ns2:VATAmount>%(vat_amount)s</ns2:VATAmount> + </ns2:Client>""" % amount_data + + amount_data_begin = { + 'seq': str(seq), + 'dnum': dnum, + 'sum_turnover': sum_turnover, + 'sum_tax': sum_tax, + } + data_begin = """ + <ns2:ClientListing SequenceNumber="1" ClientsNbr="%(seq)s" DeclarantReference="%(dnum)s" + TurnOverSum="%(sum_turnover)s" VATAmountSum="%(sum_tax)s"> +""" % amount_data_begin + + data_end = """ + + <ns2:Comment>%(comments)s</ns2:Comment> + </ns2:ClientListing> +</ns2:ClientListingConsignment> +""" % annual_listing_data + + return data_file + data_begin + data_comp + data_client_info + data_end + + def _l10n_be_vat_export(self, context): + list_of_tags = ['00', '01', '02', '03', '44', '45', '46', '47', '48', '49', '54', '55', '56', '57', '59', '61', '62', '63', '64', '71', '72', '81', '82', '83', '84', '85', '86', '87', '88', '91'] + company = self.env.user.company_id + + vat_no = company.partner_id.vat + if not vat_no: + raise UserError(_('No VAT number associated with your company.')) + + vat_no = vat_no.replace(' ', '').upper() + + default_address = company.partner_id.address_get() + address = self.env['res.partner'].browse(default_address.get("default", company.partner_id)) + + issued_by = vat_no[:2] + + send_ref = str(company.partner_id.id) + str(context.date_from[5:7]) + str(context.date_to[:4]) + starting_month = context.date_from[5:7] + ending_month = context.date_to[5:7] + quarter = str(((int(starting_month) - 1) / 3) + 1) + + date_from = context.date_from[0:7] + '-01' + date_to = context.date_to[0:7] + '-' + str(calendar.monthrange(int(context.date_to[0:4]), int(ending_month))[1]) + lines = context.get_report_obj().with_context(no_format=True, date_from=date_from, date_to=date_to).get_lines(context) + + data = {'client_nihil': False, 'ask_restitution': False, 'ask_payment': False} + + if not address.email: + raise UserError(_('No email address associated with the company.')) + if not address.phone: + raise UserError(_('No phone associated with the company.')) + file_data = { + 'issued_by': issued_by, + 'vat_no': vat_no, + 'only_vat': vat_no[2:], + 'cmpny_name': company.name, + 'address': "%s %s" % (address.street or "", address.street2 or ""), + 'post_code': address.zip or "", + 'city': address.city or "", + 'country_code': address.country_id and address.country_id.code or "", + 'email': address.email or "", + 'phone': address.phone.replace('.', '').replace('/', '').replace('(', '').replace(')', '').replace(' ', ''), + 'send_ref': send_ref, + 'quarter': quarter, + 'month': starting_month, + 'year': str(context.date_to[:4]), + 'client_nihil': (data['client_nihil'] and 'YES' or 'NO'), + 'ask_restitution': (data['ask_restitution'] and 'YES' or 'NO'), + 'ask_payment': (data['ask_payment'] and 'YES' or 'NO'), + 'comments': context.summary or '', + } + + data_of_file = """<?xml version="1.0"?> +<ns2:VATConsignment xmlns="http://www.minfin.fgov.be/InputCommon" xmlns:ns2="http://www.minfin.fgov.be/VATConsignment" VATDeclarationsNbr="1"> + <ns2:Representative> + <RepresentativeID identificationType="NVAT" issuedBy="%(issued_by)s">%(only_vat)s</RepresentativeID> + <Name>%(cmpny_name)s</Name> + <Street>%(address)s</Street> + <PostCode>%(post_code)s</PostCode> + <City>%(city)s</City> + <CountryCode>%(country_code)s</CountryCode> + <EmailAddress>%(email)s</EmailAddress> + <Phone>%(phone)s</Phone> + </ns2:Representative> + <ns2:VATDeclaration SequenceNumber="1" DeclarantReference="%(send_ref)s"> + <ns2:Declarant> + <VATNumber xmlns="http://www.minfin.fgov.be/InputCommon">%(only_vat)s</VATNumber> + <Name>%(cmpny_name)s</Name> + <Street>%(address)s</Street> + <PostCode>%(post_code)s</PostCode> + <City>%(city)s</City> + <CountryCode>%(country_code)s</CountryCode> + <EmailAddress>%(email)s</EmailAddress> + <Phone>%(phone)s</Phone> + </ns2:Declarant> + <ns2:Period> + """ % (file_data) + + if starting_month != ending_month: + # starting month and ending month of selected period are not the same + # it means that the accounting isn't based on periods of 1 month but on quarters + data_of_file += '\t\t<ns2:Quarter>%(quarter)s</ns2:Quarter>\n\t\t' % (file_data) + else: + data_of_file += '\t\t<ns2:Month>%(month)s</ns2:Month>\n\t\t' % (file_data) + data_of_file += '\t<ns2:Year>%(year)s</ns2:Year>' % (file_data) + data_of_file += '\n\t\t</ns2:Period>\n' + data_of_file += '\t\t<ns2:Data>\t' + cases_list = [] + for line in lines: + if line['name'].startswith('91') and ending_month != 12: + # the tax code 91 can only be send for the declaration of December + continue + currency_id = self.env.user.company_id.currency_id + if line['columns'][0] and not currency_id.is_zero(line['columns'][0]): + for tag in list_of_tags: + if line['name'].startswith(tag): + cases_list.append((tag, line['columns'][0])) + del tag + cases_list = sorted(cases_list, key=lambda a: a[0]) + for item in cases_list: + grid_amount_data = { + 'code': str(int(item[0])), + 'amount': '%.2f' % abs(item[1]), + } + data_of_file += '\n\t\t\t<ns2:Amount GridNumber="%(code)s">%(amount)s</ns2:Amount''>' % (grid_amount_data) + + data_of_file += '\n\t\t</ns2:Data>' + data_of_file += '\n\t\t<ns2:ClientListingNihil>%(client_nihil)s</ns2:ClientListingNihil>' % (file_data) + data_of_file += '\n\t\t<ns2:Ask Restitution="%(ask_restitution)s" Payment="%(ask_payment)s"/>' % (file_data) + data_of_file += '\n\t\t<ns2:Comment>%(comments)s</ns2:Comment>' % (file_data) + data_of_file += '\n\t</ns2:VATDeclaration> \n</ns2:VATConsignment>' + + return data_of_file |