MyBatis 结果映射：使用 SQL 查询生成 GoodsInfo 对象

SELECT * FROM (
  SELECT
    A.GBID CODE,
    GBBARCODE BARCODE,
    GBCNAME NAME,
    GBENAME ENG_NAME,
    GBSPEC SPECIFICATION,
    GBISDJ,
    GBMANAMODE,
    CASE GBWMID
      WHEN '1' THEN 0
      WHEN '5' THEN 5
      WHEN '4' THEN 3
      ELSE 1
    END account_meth,
    D.TRANSFER_DATE,
    GBUNIT UNIT,
    GBBZHL TEXTURE_CONTENT,
    GBCATCODE CLASSIFICATION,
    GBPPCODE BRANDID,
    GBSPHS DESIGN_COLOR,
    GBSPKS PLU_CODE,
    GBSPDJ QUALITY_LEVEL,
    GBSPXT SALESHOP,
    GBCSHH ART_NO,
    GBBZYJTS DAY_EXP,
    NVL(GBJXTAX, 0) SALE_VAT_RATE,
    GBNEWHSJJ pur_p_rate,
    ROUND(NVL(GBLASTJJ, GBNEWHSJJ / (1 + NVL(GBJXTAX, 0))), 4) pur_p,
    GBMAXSJ,
    GBMINSJ min_price,
    NVL(GBJXTAX, 0) INPUT_VAT_RATE,
    GBCDCODE REGION_CODE,
    GBINPUTOR INPUT_PERN,
    GBINPUTDATE INPUT_DATE,
    GBXGR UPDATE_PERN,
    GBXGDATE UPDATE_DATE,
    GBFLAG3 DUTY_TYPE,
    GBSTR4 SUBCATEGORY_CODE,
    GBSTR5 NCCCODE,
    MARKET,
    NVL(GBNUM10, 0) CAPACITY,
    NVL(GBNUM8, 1) SUIT_NUM,
    GBWEIGHT WEIGHT,
    GBSTR14 MARK_USE,
    GBSTR6 HS_CODE,
    A.GBGBDIYBARCODE GBARCODE,
    A.GBIMMEDCATID
  FROM DBUSRPUB.goodsbase A, DBUSRNPOS.GOODS_TRANSFER D
  WHERE A.GBSTATUS = 'Y' AND D.GBID = A.GBID
  UNION
  SELECT
    GBID CODE,
    GBBARCODE BARCODE,
    GBCNAME NAME,
    GBENAME ENG_NAME,
    GBSPEC SPECIFICATION,
    GBISDJ,
    GBMANAMODE,
    CASE GBWMID
      WHEN '1' THEN 0
      WHEN '5' THEN 5
      WHEN '4' THEN 3
      ELSE 1
    END account_meth,
    SYSDATE TRANSFER_DATE,
    GBUNIT UNIT,
    GBBZHL TEXTURE_CONTENT,
    GBCATCODE CLASSIFICATION,
    GBPPCODE BRANDID,
    GBSPHS DESIGN_COLOR,
    GBSPKS PLU_CODE,
    GBSPDJ QUALITY_LEVEL,
    GBSPXT SALESHOP,
    GBCSHH ART_NO,
    GBBZYJTS DAY_EXP,
    NVL(GBJXTAX, 0) SALE_VAT_RATE,
    GBNEWHSJJ pur_p_rate,
    ROUND(NVL(GBLASTJJ, GBNEWHSJJ / (1 + NVL(GBJXTAX, 0))), 4) pur_p,
    GBMAXSJ,
    GBMINSJ min_price,
    NVL(GBJXTAX, 0) INPUT_VAT_RATE,
    GBCDCODE REGION_CODE,
    GBINPUTOR INPUT_PERN,
    GBINPUTDATE INPUT_DATE,
    GBXGR UPDATE_PERN,
    GBXGDATE UPDATE_DATE,
    GBFLAG3 DUTY_TYPE,
    GBSTR4 SUBCATEGORY_CODE,
    GBSTR5 NCCCODE,
    MARKET,
    NVL(GBNUM10, 0) CAPACITY,
    NVL(GBNUM8, 1) SUIT_NUM,
    GBWEIGHT WEIGHT,
    GBSTR14 MARK_USE,
    GBSTR6 HS_CODE,
    A.GBGBDIYBARCODE GBARCODE,
    A.GBIMMEDCATID
  FROM DBUSRPUB.goodsbase A
  WHERE
    A.GBSTATUS = 'Y'
    AND EXISTS (SELECT 1 FROM DBUSRPUB.goodsmframe B WHERE A.GBID = B.GMFGDID AND B.GMFMARKET IN ({CHANL_CODE}))
    AND NOT EXISTS (SELECT 1 FROM DBUSRNPOS.GOODSTRANSFER C WHERE C.GBID = A.GBID)
) WHERE ROWNUM <= {TerDetail[1]} ORDER BY TRANSFER_DATE