Odoo18-Base/addons/account/tools/structured_reference.py

125 lines
4.5 KiB
Python
Raw Permalink Normal View History

2025-03-10 11:12:23 +07:00
import re
from itertools import zip_longest
from stdnum import iso11649, luhn
from stdnum.iso7064 import mod_97_10
def sanitize_structured_reference(reference):
"""Removes whitespace and specific characters from Belgian structured references:
Example: ` RF18 1234 5678 9 ` -> `RF18123456789`
`+++020/3430/57642+++` -> `020343057642`
`***020/3430/57642***` -> `020343057642`
"""
ref = re.sub(r'\s', '', reference)
if re.match(r'(\+{3}|\*{3})\d{3}/\d{4}/\d{5}(\+{3}|\*{3})', ref):
return re.sub(r'[+*/]', '', ref)
return ref
def format_structured_reference_iso(number):
"""Format a string into a Structured Creditor Reference.
The Creditor Reference is an international standard (ISO 11649).
Example: `123456789` -> `RF18 1234 5678 9`
"""
check_digits = mod_97_10.calc_check_digits('{}RF'.format(number))
return 'RF{} {}'.format(
check_digits,
' '.join(''.join(x) for x in zip_longest(*[iter(str(number))]*4, fillvalue=''))
)
def is_valid_structured_reference_iso(reference):
"""Check whether the provided reference is a valid Structured Creditor Reference (ISO).
:param reference: the reference to check
"""
ref = sanitize_structured_reference(reference)
return iso11649.is_valid(ref)
def is_valid_structured_reference_be(reference):
"""Check whether the provided reference is a valid structured reference for Belgium.
:param reference: the reference to check
"""
ref = sanitize_structured_reference(reference)
be_ref = re.fullmatch(r'(\d{10})(\d{2})', ref)
return be_ref and int(be_ref.group(1)) % 97 == int(be_ref.group(2)) % 97
def is_valid_structured_reference_fi(reference):
"""Check whether the provided reference is a valid structured reference for Finland.
:param reference: the reference to check
"""
ref = sanitize_structured_reference(reference)
fi_ref = re.fullmatch(r'(\d{1,19})(\d)', ref)
if not fi_ref:
return False
total = sum((7, 3, 1)[idx % 3] * int(val) for idx, val in enumerate(fi_ref.group(1)[::-1]))
check_digit = (10 - (total % 10)) % 10
return check_digit == int(fi_ref.group(2))
def is_valid_structured_reference_no_se(reference):
"""Check whether the provided reference is a valid structured reference for Norway or Sweden.
:param reference: the reference to check
"""
ref = sanitize_structured_reference(reference)
no_se_ref = re.fullmatch(r'\d+', ref)
return no_se_ref and luhn.is_valid(ref)
def is_valid_structured_reference_nl(reference):
""" Generates a valid Dutch structured payment reference (betalingskenmerk)
by ensuring it follows the correct format.
Valid reference lengths:
- 7 digits: Simple reference with no check digit.
- 9-14 digits: Includes a check digit and a length code.
- 16 digits: Contains only a check digit, commonly used for wire transfers.
:param reference: the reference to check
:return: True if reference is a structured reference, False otherwise
"""
sanitized_reference = sanitize_structured_reference(reference)
if re.fullmatch(r'\d{7}', sanitized_reference):
return True
if not re.fullmatch(r'\d{9,16}', sanitized_reference):
return False
if len(sanitized_reference) == 15:
return False
check, reference_to_check = sanitized_reference[0], sanitized_reference[1:]
weigths = [2, 4, 8, 5, 10, 9, 7, 3, 6, 1]
reference_to_check = reference_to_check.zfill(16)[::-1]
total = sum(
int(digit) * weigths[index % len(weigths)]
for index, digit in enumerate(reference_to_check)
)
computed_check = 11 - (total % 11)
if computed_check == 11:
computed_check = 0
elif computed_check == 10:
computed_check = 1
return computed_check == int(check)
def is_valid_structured_reference(reference):
"""Check whether the provided reference is a valid structured reference.
This is currently supporting SEPA enabled countries. More specifically countries covered by functions in this file.
:param reference: the reference to check
"""
reference = sanitize_structured_reference(reference or '')
return (
is_valid_structured_reference_be(reference) or
is_valid_structured_reference_fi(reference) or
is_valid_structured_reference_no_se(reference) or
is_valid_structured_reference_nl(reference) or
is_valid_structured_reference_iso(reference)
)