========== 测试实际逗号分隔文件ID处理 ==========

测试ID: 1
注意：请确保这个记录的文件ID字段包含逗号分隔的多个ID

1. 查询数据库数据...
❌ 测试过程中发生异常
异常信息: SQL执行失败: SQLSTATE[42S22]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid column name 'AR'. SQL: 
            SELECT TOP 1
                fes.AR AS AR1,
                vg.AR AS AR2,
                gt.AR AS AR3,
                vg.Attachment,
                vg.BusinessLicenseDirection,
                fes.BusinessLicenseDirection AS BusinessLicenseDirection1,
                gt.BusinessLicenseDirection AS BusinessLicenseDirection2,
                gt.Attachment AS Attachment1,
                fes.Attachment AS Attachment2,
                bc.NameEng,
                bc.NameCN,
                bc.LegalPersonEmail,
                bc.RegNumber,
                bc.LegalPersonFullNamePinYin,
                bc.LegalPersonName,
                bc.RegisteredCapital,
                bc.RegisteredCapitalCurrency,
                bc.EstablishmentDate,
                bc.CityEngName,
                bc.RegAddressEng,
                bc.BusinessLicensePic,
                bc.LegalPersonIdNumberFrontPic,
                bc.LegalPersonIdNumberBackPic,
                bc.LegalPersonGender,
                bc.Nationality,
                bc.LegalPersonIdNumber,
                bc.LegalPersonIdStartDate,
                bc.LegalPersonIdEndDate,
                bc.LegalPersonCityEngName,
                bc.LegalPersonIDCardAddressEng,
                bc.LegalPersonBirthDate,
                bc.LegalSignedFile,
                bc.NameCN,
                vb.BusinessCode,
                vb.Code,
                vb.ID,
                vri.id AS VATRegInfoId,
                vb.PushTaxBureauStatus,
                vb.PushTaxBureauErrorMsg,
                ps.SpecsName,
                bc.LegalPersonIDCardType,
                bc.LegalPersonCountry,
                bc.LegalPersonAddressProvinceEn,
                bc.CompanyAddressLine1En,
                bc.CompanyAddressLine2En,
                bc.CompanyAddressPostcode,
                bc.CompanyAddressProvinceEn,
                bc.Country AS CompanyCountry,
                bu.F_Mobile as LinkedSalesContactPhone,
                vg.HagueType,
                fes.HagueType AS HagueType1,
                gt.HagueType AS HagueType2,
                bc.BusinessCRFile
            FROM VATRegInfo vri
            LEFT JOIN VATBusinessRecord vb ON vri.VATBusinessRecordID = vb.ID
            LEFT JOIN Base_Customer_Company bc ON bc.ID = vb.CompanyID
            LEFT JOIN ESVAT_Register vg ON vg.ID = vb.ID
            LEFT JOIN GeneralTemplateVAT gt ON gt.ID = vb.ID
            LEFT JOIN ESVAT_SubAgent fes ON fes.ID = vb.ID
            LEFT JOIN MS_OrderDetails mo ON vb.MSOrderDetailsID = mo.ID
            LEFT JOIN ProductSpecs ps ON ps.ID=mo.SKUSpecificationID
            LEFT JOIN Base_User bu ON bu.F_UserId = vb.BusinessCounselorId
            WHERE vb.Country = 'ES' AND vri.id = :id
        

========== 测试完成 ==========

处理逻辑总结:
1. 📥 接收原始文件ID字段（可能包含逗号分隔的多个ID）
2. 🔍 按逗号分割并去除空格
3. 🔄 逐个查询每个文件ID的记录
4. 🌐 对每个文件进行HTTP HEAD请求验证可访问性
5. ✅ 返回第一个存在且可访问的文件
6. 📝 记录详细的处理日志

优势:
✅ 支持多个备用文件，提高文档生成成功率
✅ 自动跳过损坏或不可访问的文件
✅ 兼容原有的单文件ID格式
✅ 提供详细的日志用于问题排查
✅ 在文件下载前就验证可访问性，节省时间

数据库配置建议:
1. 将多个文件ID用逗号分隔存储
2. 将最新或质量最好的文件ID放在前面
3. 定期清理无效的文件ID
4. 监控系统日志中的文件访问警告