========== 测试签名图片插入修复 ==========

测试记录ID: 5c82d912-a31b-4c41-822b-ce5bf1fd74ed
修复内容: 在免海牙授权书生成后插入签名图片

问题分析:
之前的问题: 签名文件路径只是作为文本插入到Word中
导致结果: 免海牙授权书中显示的是文件路径而不是实际图片
修复方案: 使用SignatureToWordConverter插入实际的签名图片

修复对比:
修复前: {{signature_image}} → /temp/signature.jpg (文本)
修复后: {{signature_image}} → [实际的签名图片] (图片)

开始生成免海牙文档...
❌ 免海牙文档生成失败
错误信息: 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
        

========== 修复总结 ==========

修复的关键问题:
✅ 图片插入: 使用SignatureToWordConverter替换文本占位符为实际图片
✅ 处理时机: 在Word文档生成后、PDF转换前插入图片
✅ 错误处理: 添加文件存在检查和插入结果验证

修复前的处理流程:
1. prepareApostilleNotRequiredData() → 设置signature_image为文件路径
2. WordTemplateProcessor.process() → 将文件路径作为文本插入
3. 结果: Word中显示 '/temp/signature.jpg' 文本

修复后的处理流程:
1. prepareApostilleNotRequiredData() → 设置signature_image为文件路径
2. WordTemplateProcessor.process() → 处理其他文本字段
3. SignatureToWordConverter.replaceImageInWord() → 插入实际签名图片
4. 结果: Word中显示实际的签名图片

技术细节:
- 使用占位符: {{signature_image}}
- 图片尺寸: 1.5英寸宽 x 0.8英寸高
- 插入方法: SignatureToWordConverter.replaceImageInWord()
- 错误处理: 检查文件存在性和插入结果

与营业执照二维码的对比:
营业执照翻译件:
- 占位符: {{license_qrcode_image}}
- 图片类型: 二维码
- 尺寸: 0.79x0.79英寸

免海牙授权书:
- 占位符: {{signature_image}}
- 图片类型: 签名图片
- 尺寸: 1.5x0.8英寸

预期效果:
- 免海牙授权书中的签名位置现在应该显示实际的签名图片
- 签名图片应该清晰可见，尺寸合适
- 不再显示文件路径文本

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