?i*dZddlmZddlZddlZddlddlmZdZerddl m Z dZ d!d Z e d e DZejd d Dd Zdddddddddddddd ZdZddj'ezZdZedzezdzezdzedzezdzezdzgZd"dZd#dZd$d%dZd&dZdZ d' d(d Zy))aHandelsregisternummer (German company register number). The number consists of the court where the company has registered, the type of register and the registration number. The type of the register is either HRA or HRB where the letter "B" stands for HR section B, where limited liability companies and corporations are entered (GmbH's and AG's). There is also a section HRA for business partnerships (OHG's, KG's etc.). In other words: businesses in section HRB are limited liability companies, while businesses in HRA have personally liable partners. More information: * https://www.handelsregister.de/ * https://en.wikipedia.org/wiki/German_Trade_Register * https://offeneregister.de/ >>> validate('Aachen HRA 11223') 'Aachen HRA 11223' >>> validate('Frankfurt/Oder GnR 11223', company_form='e.G.') 'Frankfurt/Oder GnR 11223' >>> validate('Aachen HRC 44123') Traceback (most recent call last): ... InvalidFormat: ... >>> validate('Aachen HRA 44123', company_form='GmbH') Traceback (most recent call last): ... InvalidComponent: ... ) annotationsN)*)cleanF)Any)Aachen AltenburgAmbergAnsbachApoldaArnsbergzArnstadt Zweigstelle IlmenauArnstadt AschaffenburgAugsburgAurichz Bad HersfeldBad Homburg v.d.H.z Bad KreuznachzBad Oeynhausenz Bad SalzungenBambergBayreuthBerlin (Charlottenburg) BielefeldBochumBonn BraunschweigBremenChemnitzCoburgCoesfeldCottbus Darmstadt DeggendorfDortmundDresdenDuisburguDürenu DüsseldorfEisenachErfurtEschwegeEssen FlensburgzFrankfurt am MainzFrankfurt/OderFreiburg FriedbergFritzlarFuldauFürth GelsenkirchenGerauGießenGothaGreizu Göttingenu GüterslohHagenHamburgHammHanauHannoverzHeilbad HeiligenstadtHildburghausen HildesheimHofHomburg IngolstadtIserlohnJenaKaiserslauternKasselKempten (Allgäu)KielKleveKoblenzKorbachKrefeldKölnu KönigsteinLandauLandshut LangenfeldLebachLeipzigLemgoLimburg#Ludwigshafen a.Rhein (Ludwigshafen)uLübecku LüneburgMainzMannheimMarburg Meiningen MemmingenMerzig MontabauruMönchengladbachu MühlhausenuMünchenuMünsterNeubrandenburg Neunkirchen NeuruppinNeuss Nordhausenu NürnbergzOffenbach am MainOldenburg (Oldenburg)u Osnabrück Ottweiler PaderbornPassau PinnebergPotsdamu$Pößneck Zweigstelle Bad Lobensteinu PößneckRecklinghausen RegensburgRostockzRudolstadt Zweigstelle Saalfeld Rudolstadtu Saarbrücken Saarlouis SchweinfurtSchwerinSiegburgSiegen Sondershausen SonnebergSt. Ingbert (St Ingbert)St. Wendel (St Wendel) Stadthagen Stadtroda SteinfurtStendal Stralsund Straubing StuttgartSuhlu SömmerdaTostedt TraunsteinUlmu VölklingenWalsrodeWeiden i. d. OPf.WeimarWetzlar WiesbadenWittlich Wuppertalu Würzburgu Zweibrückencvdjdtjd|jDS)zDConvert the court name for quick comparison without encoding issues.c3(K|] }|dvr| yw)abcdefghijklmnopqrstuvwxyzN.0xs f/var/www/html/myprovider/mon_projet_qr/lib/python3.12/site-packages/stdnum/de/handelsregisternummer.py z_to_min..s!. , , .sNFD)join unicodedata normalizelower)courts r_to_minrs3 77.(( >. ..c#6K|]}t||fywNr)rrs rrrs8 %WU^U8sc#<K|]\}}t||fywrr)raliasrs rrrs" ,uWU^Us))uAllgäur>)z Bad Homburgr)Berlinr)Charlottenburgr)zCharlottenburg (Berlin)r)KalnrD)Kemptenr>)z$Ludwigshafen am Rhein (Ludwigshafen)rL)zLudwigshafen am RheinrL) LudwigshafenrL) OldenburgrY)z St. Ingbertrj)z St. Wendelrk)zWeiden in der Oberpfalzrx)Weidenrx)uPaderborn früher Höxterr[)HRAHRBPRGnRVRrrrrr) ze.K.ze.V.VereinOHGKGKGaAzVor-GmbHGmbHUGzUG i.G.AGze.G.PartGz (?P.*)z(?P%s)|u0(?P[1-9][0-9]{0,5})(\s*(?P[A-ZÖ]{1,3}))?z\s+z,?\s+$ctt|j}tD]}tj||tj tj z}|s=|jdj|jd|jd|jdfcSt)zVSplit the number into a court, registry, register number and optionally qualifier.)flagsrregistrynrr) rstrip_formatsrematchIUgroup InvalidFormat)numberfmtms r_splitr"s6] "F^ HHS&rtt 4 777#))+QWWZ-@!''$-QRQXQXY\Q]] ]^ /rcZt|\}}}}djd||||fDS)zConvert the number to the minimal representation. This strips the number of any valid separators and removes surrounding whitespace. c3&K|] }|s| ywrrrs rrzcompact..1I!qAI)rr)rrr qualifiers rcompactr-s4*0&E8VY 88IxCI IIrct|\}}}}tjt|}|s t |r"t j||k7r t dj d||||fDS)zCheck if the number is a valid company registry number. If a company_form (eg. GmbH or PartG) is given, the number is validated to have the correct registry type.rc3&K|] }|s| ywrrrs rrzvalidate..?rr)r_courtsgetrInvalidComponentCOMPANY_FORM_REGISTRY_TYPESr)r company_formrrrs rvalidater4sq *0&E8VY KK 'E   377 EQ  88IxCI IIrcJ tt|S#t$rYywxYw)z7Check if the number is a valid company registry number.F)boolrValidationError)rs ris_validrBs)HV$%% s  ""z.https://db.offeneregister.de/openregister.jsonc (ddl}t|\}}}}|jtd|d|d|d||}|j  |j }t t|d|ddS#ttf$r } Yd} ~ yd} ~ wwxYw) aRetrieve registration information from the OffeneRegister.de web site. The `timeout` argument specifies the network timeout in seconds. The `verify` argument is either a boolean that determines whether the server's certificate is validate or a string which must be a path the CA certificate bundle to use for verification. This basically returns the JSON response from the web service as a dict. It will contain something like the following:: { 'companyId': 'U1206_HRB14011', 'courtCode': 'U1206', 'courtName': 'Chemnitz', 'globalId': 'sn_293298', 'isCurrent': 'True', 'name': 'Internet hier GmbH Presentation Provider', 'nativeReferenceNumber': 'Chemnitz HRB 14011', 'referenceNumberFirstSeen': '2020-06-12', 'stdRefNo': 'U1206_HRB14011', 'validFrom': '2020-06-12', 'validTill': '', } Will return None if the number is invalid or unknown. rNz select * from ReferenceNumbers join Names on ReferenceNumbers.companyId = Names.companyId where nativeReferenceNumber = :p0 limit 1 r)sqlp0)paramstimeoutverifycolumnsrows) requestsrr_offeneregister_urlraise_for_statusjsondictzipKeyError IndexError) rrrrrrrresponseres rcheck_offeneregisterrNsD)/&E8VY||!&x8: H }}CYfa9:: j !s -A88B B)rstrreturnr)rrrz tuple[str, str, str, str | None])rrrrr)rrrz str | Nonerr)rrrr)T)rrrfloatrz bool | strrzdict[str, Any] | None)__doc__ __future__rrrstdnum.exceptions stdnum.utilr TYPE_CHECKINGtypingr GERMAN_COURTSrrrupdateREGISTRY_TYPESr _court_rer _registry_re _number_rerrrrrrrrrrrsP,>#  X v. 8)68 81,          $  "SXXn%== @ 6J&1I=C <'&0:=C  J JG 6 6 6 6 6r