========== 完整测试免海牙文档生成修复 ==========

测试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
2. 文件下载失败
3. OCR识别失败
4. 模板文件不存在
5. PDF转换或合并失败

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

修复总结:
✅ 营业执照处理：增强了文件下载失败时的数据回退机制
✅ 身份证处理：增加了详细的调试信息和字段检查
✅ PDF合并：增加了文件存在性检查和详细日志
✅ 地址格式化：改进了空格和标点符号的处理
✅ 错误处理：增强了异常情况下的日志记录

如果仍有问题，请检查:
1. 日志文件中的详细错误信息
2. 数据库中的文件ID是否正确
3. 文件服务器是否可访问
4. 模板文件是否存在
5. 临时文件夹权限是否正确