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
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):
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):
_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 <moylop260@hotmail.com>
# and Panos Christeas <p_christ@hol.gr>
__check_vat_mx_re = re.compile(r"(?P<primeras>[A-Za-z\xd1\xf1&]{3,4})" \