========== VAT文档生成测试 ==========

<br />
<b>Warning</b>:  Undefined variable $argc in <b>E:\phpProject\TEST\es\es_haiya\scripts\test_vat_generate.php</b> on line <b>22</b><br />
测试ID: fffec2be-4b21-4d9e-a6bd-a0fa280c162a


========== 生成失败 ==========
错误信息: 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
        

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