X-Git-Url: http://git.inspyration.org/?a=blobdiff_plain;f=addons%2Fbase_vat%2Fbase_vat.py;h=51c1663d3662ea70b4070ca520de8977996fb01f;hb=117bf937b9b9489718a46ad5d6a967110ee5c3f7;hp=ba858d10e643a47f01842e40c98f2a30c241b67a;hpb=011d92bb6c3212f638786ccdb57f7cd51c066648;p=odoo%2Fodoo.git diff --git a/addons/base_vat/base_vat.py b/addons/base_vat/base_vat.py index ba858d1..51c1663 100644 --- a/addons/base_vat/base_vat.py +++ b/addons/base_vat/base_vat.py @@ -23,11 +23,12 @@ import logging import string import datetime import re +_logger = logging.getLogger(__name__) try: import vatnumber except ImportError: - logging.getLogger('base_vat').warning("VAT validation partially unavailable because the `vatnumber` Python library cannot be found. " + _logger.warning("VAT validation partially unavailable because the `vatnumber` Python library cannot be found. " "Install it to support more countries, for example with `easy_install vatnumber`.") vatnumber = None @@ -36,22 +37,38 @@ from tools.misc import ustr from tools.translate import _ _ref_vat = { - 'be': 'BE0477472701', 'at': 'ATU12345675', - 'bg': 'BG1234567892', 'cy': 'CY12345678F', - 'cz': 'CZ12345679', 'de': 'DE123456788', - 'dk': 'DK12345674', 'ee': 'EE123456780', - 'es': 'ESA12345674', 'fi': 'FI12345671', - 'fr': 'FR32123456789', 'gb': 'GB123456782', - 'gr': 'GR12345670', 'hu': 'HU12345676', - 'ie': 'IE1234567T', 'it': 'IT12345670017', - 'lt': 'LT123456715', 'lu': 'LU12345613', - 'lv': 'LV41234567891', 'mt': 'MT12345634', - 'nl': 'NL123456782B90', 'pl': 'PL1234567883', - 'pt': 'PT123456789', 'ro': 'RO1234567897', - 'se': 'SE123456789701', 'si': 'SI12345679', - 'sk': 'SK0012345675', 'el': 'EL12345670', - 'mx': 'MXABC123456T1B', 'no': 'NO123456785', + 'at': 'ATU12345675', + 'be': 'BE0477472701', + 'bg': 'BG1234567892', + 'ch': 'CHE-123.456.788 TVA or CH TVA 123456', #Swiss by Yannick Vaucher @ Camptocamp + 'cy': 'CY12345678F', + 'cz': 'CZ12345679', + 'de': 'DE123456788', + 'dk': 'DK12345674', + 'ee': 'EE123456780', + 'el': 'EL12345670', + 'es': 'ESA12345674', + 'fi': 'FI12345671', + 'fr': 'FR32123456789', + 'gb': 'GB123456782', + 'gr': 'GR12345670', + 'hu': 'HU12345676', 'hr': 'HR01234567896', # Croatia, contributed by Milan Tribuson + 'ie': 'IE1234567T', + 'it': 'IT12345670017', + 'lt': 'LT123456715', + 'lu': 'LU12345613', + 'lv': 'LV41234567891', + 'mt': 'MT12345634', + 'mx': 'MXABC123456T1B', + 'nl': 'NL123456782B90', + 'no': 'NO123456785', + 'pl': 'PL1234567883', + 'pt': 'PT123456789', + 'ro': 'RO1234567897', + 'se': 'SE123456789701', + 'si': 'SI12345679', + 'sk': 'SK0012345675', } class res_partner(osv.osv): @@ -61,27 +78,53 @@ class res_partner(osv.osv): vat_country, vat_number = vat[:2].lower(), vat[2:].replace(' ', '') return vat_country, vat_number - def check_vat(self, cr, uid, ids, context=None): + def simple_vat_check(self, cr, uid, country_code, vat_number, context=None): ''' Check the VAT number depending of the country. http://sima-pc.com/nif.php ''' - country_obj = self.pool.get('res.country') + check_func_name = 'check_vat_' + country_code + check_func = getattr(self, check_func_name, None) or \ + getattr(vatnumber, check_func_name, None) + if not check_func: + # No VAT validation available, default to check that the country code exists + res_country = self.pool.get('res.country') + return bool(res_country.search(cr, uid, [('code', '=ilike', country_code)], context=context)) + return check_func(vat_number) + + def vies_vat_check(self, cr, uid, country_code, vat_number, context=None): + try: + # Validate against VAT Information Exchange System (VIES) + # see also http://ec.europa.eu/taxation_customs/vies/ + return vatnumber.check_vies(country_code.upper()+vat_number) + except Exception: + # see http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl + # Fault code may contain INVALID_INPUT, SERVICE_UNAVAILABLE, MS_UNAVAILABLE, + # TIMEOUT or SERVER_BUSY. There is no way we can validate the input + # with VIES if any of these arise, including the first one (it means invalid + # country code or empty VAT number), so we fall back to the simple check. + return self.simple_vat_check(cr, uid, country_code, vat_number, context=context) + + def button_check_vat(self, cr, uid, ids, context=None): + if not self.check_vat(cr, uid, ids, context=context): + msg = self._construct_constraint_msg(cr, uid, ids, context=context) + raise osv.except_osv(_('Error!'), msg) + return True + + def check_vat(self, cr, uid, ids, context=None): + user_company = self.pool.get('res.users').browse(cr, uid, uid).company_id + if user_company.vat_check_vies: + # force full VIES online check + check_func = self.vies_vat_check + else: + # quick and partial off-line checksum validation + check_func = self.simple_vat_check for partner in self.browse(cr, uid, ids, context=context): if not partner.vat: continue vat_country, vat_number = self._split_vat(partner.vat) - check_func_name = 'check_vat_' + vat_country - check_func = getattr(self, check_func_name, None) or \ - getattr(vatnumber, check_func_name, None) - if not check_func: - # No VAT validation available, default to check that the country code - # exists. - if country_obj.search(cr, uid, [('code', 'ilike', vat_country)], context=context): - continue - # Country code not found, considered invalid + if not check_func(cr, uid, vat_country, vat_number, context=context): return False - return check_func(vat_number) return True def vat_change(self, cr, uid, ids, value, context=None): @@ -106,6 +149,43 @@ class res_partner(osv.osv): _constraints = [(check_vat, _construct_constraint_msg, ["vat"])] + __check_vat_ch_re1 = re.compile(r'(MWST|TVA|IVA)[0-9]{6}$') + __check_vat_ch_re2 = re.compile(r'E([0-9]{9}|-[0-9]{3}\.[0-9]{3}\.[0-9]{3})(MWST|TVA|IVA)$') + + def check_vat_ch(self, vat): + ''' + Check Switzerland VAT number. + ''' + # VAT number in Switzerland will change between 2011 and 2013 + # http://www.estv.admin.ch/mwst/themen/00154/00589/01107/index.html?lang=fr + # Old format is "TVA 123456" we will admit the user has to enter ch before the number + # Format will becomes such as "CHE-999.999.99C TVA" + # Both old and new format will be accepted till end of 2013 + # Accepted format are: (spaces are ignored) + # CH TVA ###### + # CH IVA ###### + # CH MWST ####### + # + # CHE#########MWST + # CHE#########TVA + # CHE#########IVA + # CHE-###.###.### MWST + # CHE-###.###.### TVA + # CHE-###.###.### IVA + # + if self.__check_vat_ch_re1.match(vat): + return True + match = self.__check_vat_ch_re2.match(vat) + if match: + # For new TVA numbers, do a mod11 check + num = filter(lambda s: s.isdigit(), match.group(1)) # get the digits only + factor = (5,4,3,2,7,6,5,4) + csum = sum([int(num[i]) * factor[i] for i in range(8)]) + check = 11 - (csum % 11) + return check == int(num[8]) + return False + + # Mexican VAT verification, contributed by # and Panos Christeas __check_vat_mx_re = re.compile(r"(?P[A-Za-z\xd1\xf1&]{3,4})" \