========== 调试营业执照原件问题 ==========

问题描述: 免海牙文件的PDF中营业执照原件没有合并到最终PDF中

可能的原因分析:
1. 营业执照文件下载失败
2. 原件路径没有正确保存到templateData中
3. PDF合并时原件路径为空或文件不存在
4. 文件格式不支持或转换失败

测试步骤:
1. 查询数据库数据
2. 检查营业执照文件配置
3. 模拟营业执照处理过程
4. 检查原件路径传递
5. 验证PDF合并逻辑

步骤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. 确认数据库中BusinessLicensePic字段不为空
2. 确认Base_AnnexesFile表中对应的文件记录存在
3. 确认文件服务器上的文件可以正常访问
4. 运行完整的生成流程并查看日志
5. 检查临时文件夹中是否有下载的营业执照文件

日志关键词:
- '营业执照下载成功' - 确认文件下载成功
- '营业执照原件路径调试' - 查看原件路径是否正确
- '处理营业执照-原件' - 确认PDF合并时找到原件
- '营业执照原件文件不存在' - 问题所在

临时解决方案:
如果问题持续存在，可以:
1. 检查文件下载是否成功
2. 手动验证文件路径
3. 检查文件格式是否支持
4. 验证PDF转换逻辑

========== 调试完成 ==========