================================================================================
 CSV 字段与 epr_weee_query_api.php 代码源数据映射对照表
================================================================================

 HILBIADI SARL 是一家法国公司(FR)，欧盟成员(IsEUMember=1)，服务项为WEEE(非户外，ContractType=EEE Ménager)


 列号  | 列名                                   | CSV 实际值                                    | 代码来源字段/逻辑
 ------|----------------------------------------|-----------------------------------------------|--------------------------------------------------
 A     | Company Name*                          | HILBIADI SARL                                 | companyresults['NameEng']
 B     | Company registration number*          | 10085007200016                                | companyresults['CTRegNumber'] (INSEE API siret_siege)
 C     | Registered office address*            | Bureau 1762 37 passage du Ponceau Paris       | companyresults['CompanyAddressLine1En']
 D     | Registered office address 2           | (空)                                          | companyresults['CompanyAddressLine2En']
 E     | Registered office postcode*           | 75002                                         | companyresults['CompanyAddressPostcode']
 F     | Registered office city*               | Paris                                         | companyresults['CityEngName']
 G     | Registered office country*            | France                                        | country_cache.json: Country_epr_weee_fr['FR'] = 'France'
 H     | EU VAT number                         | FR50100850072                                 | companyresults['VATNumber'] (IsEUMember=1时填充)
 I     | Share capital*                        | 100                                           | companyresults['RegisteredCapital']
 J     | Company type*                         | Société à responsabilité limitée (SARL)       | companyresults['legal_form'] (INSEE API legal_form)
 K     | Place of registration*                | Paris                                         | companyresults['CityEngName']
 L     | Naf code                              | 4791A                                         | companyresults['naf_code'] (INSEE API naf_code)
 M     | Company phone number*                 | 337 59 10 91 09                               | formatFrenchPhoneNumber(companyresults['LegalPersonPhone'])
 N     | Website                               | (空)                                          | 固定空字符串 ''
 O     | Retailer                              | (空)                                          | 固定空字符串 ''
 P     | Account effective date*               | 01/01/2026                                    | "01/01/{ServiceYear}", companyresults['ServiceYear']=2026
 Q     | Postal Address*                       | MEIOU(CHENGDU)GUOJIMAOYIYOUXIANGONGSI (SEAMEW)| 固定值
 R     | Postal address 2                      | Shuxilu 9hao 1dong 19ceng 1902hao jinniuqu    | 固定值
 S     | Postal Postcode *                     | 610036                                        | 固定值
 T     | Postal City*                          | Chengdu                                       | 固定值
 U     | Postal Country*                       | Chine                                         | 固定值
 V     | Contact Agent's Name*                 | WANG                                          | 固定值
 W     | Contact Agent's First name*           | Mia                                           | 固定值
 X     | Contact Agent's Function*             | mandataire                                    | 固定值
 Y     | Contact Angent's Email address*       | info@seamew.de                                | 固定值
 Z     | Contact Agent's Phone Number*         | 86177 61 22 42 68                             | 固定值
 AA    | Customer contact name                 | (空)                                          | 固定空字符串 ''
 AB    | Customer contact first name           | (空)                                          | 固定空字符串 ''
 AC    | Customer Contact position             | (空)                                          | 固定空字符串 ''
 AD    | Customer Contact Email address        | (空)                                          | 固定空字符串 ''
 AE    | Customer contact telephone number     | (空)                                          | 固定空字符串 ''
 AF    | Type of contract *                    | EEE Ménager                                   | ServiceItemName不含'户外'→'EEE Ménager'
 AG    | Contract effective date*              | 01/01/2026                                    | "01/01/{ServiceYear}"
 AH    | Signatory's name*                     | WANG                                          | 固定值
 AI    | Signatory's first name*               | Mia                                           | 固定值
 AJ    | Signatory's Email address*            | info@seamew.de                                | 固定值
 AK    | Signatory's phone number*             | 86177 61 22 42 68                             | 固定值
 AL    | Equipment sold                        | (空)                                          | 固定空字符串 ''
 AM    | Name of legal representative*         | Hillman                                       | LegalPersonFullNamePinYin 拆分的姓(lastName)
 AN    | First name of legal representative*   | BidossessiAdinsi                              | LegalPersonFullNamePinYin 拆分的名(firstName)
 AO    | Position of the legal representative* | Director                                      | 固定值 'Director'
 AP    | Starting date of mandate*             | 01/01/2026                                    | "01/01/{ServiceYear}"
 AQ    | Reporting period*                     | A                                             | 固定值 'A'
 AR    | Name of the Power of attorney*        | EPR_Ecologic_HILBIADISARL                     | 'EPR_Ecologic_' + NameEng(去除非字母中文的字符)
 AS    | European mandate contract             | YES                                           | IsEUMember=1 → 'YES'
 AT    | Other European mandate contract       | (空)                                          | 固定空字符串 ''
 AU    | Email of legal representative*        | adinsihill@outlook.com                        | companyresults['LegalPersonEmail']
 AV    | Signatory's Function*                 | Director                                      | 固定值 'Director'


================================================================================
 关键验证点：
================================================================================

 ✅ 正确项:
   - B列 SIRET(10085007200016) 来源于 INSEE API 返回的 siret_siege
   - G列 国家(France) 来源于 country_cache.json 的 Country_epr_weee_fr['FR']
   - H列 VAT(FR50100850072) 因为是欧盟公司(FR)所以填了 VATNumber
   - J列 公司类型(SARL) 来源于 INSEE API 返回的 legal_form
   - L列 NAF(4791A) 来源于 INSEE API 返回的 naf_code
   - M列 电话(337 59 10 91 09) 从右往左每2位分组，最多4组
   - AF列 EEE Ménager 来源于 ServiceItemName 不含'户外'
   - AM列 Hillman 是 LegalPersonFullNamePinYin 拆分姓氏
   - AN列 BidossessiAdinsi 是 LegalPersonFullNamePinYin 拆分名字
   - AS列 YES 因为是欧盟公司(IsEUMember=1)

 ⚠️ 需确认项:
   - C列地址 "Bureau 1762 37 passage du Ponceau Paris" 共45字符，未超50字符限制
   - AR列 POA名称 "EPR_Ecologic_HILBIADISARL"
      代码逻辑: NameEng 去除非字母/中文字符 → "HILBIADISARL" → 拼上前缀
      这个名称必须和上传的 Mandat ZIP 文件名一致