Please enable JavaScript.

Coggle requires JavaScript to display documents.

網投首頁串接API功能（WHomepage.vue） (http://XXXX/ezbaoService 試算API (年金險試算…

- - - - 【select】 MFP_BANNERS(首頁Banner檔)
    - - 【select】MFP_MARQUEES(首頁跑馬燈檔)
    - - 【select】PRO_CATS(險種類型檔) join PRO_CATS_MAP( 險種類型對應主約商品檔) join PRODUCTS( 商品資料檔)
        
        SELECT PC.*, PCM.PRO_CODE
        FROM PRO_CATS PC
        JOIN PRO_CATS_MAP PCM ON PCM.CAT_CODE = PC.CAT_CODE
        JOIN (SELECT PRO_CODE, MAX(PLAN_VERSION||VERSION) FROM PRODUCTS
        WHERE (VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(START_DATE), 'YYYYMMDD'), 'YYYYMMDD') <= '20190905'
        AND VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(END_DATE), 'YYYYMMDD'), 'YYYYMMDD') >= '20190905'
        ) AND VARCHAR_FORMAT(CURRENT TIMESTAMP, 'YYYYMMDD') || CHAR(HOUR(CURRENT TIME))
        NOT BETWEEN COALESCE(VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(HIDDEN_START_DATE), 'YYYYMMDD'), 'YYYYMMDD') || HIDDEN_START_TIME, '9999123100')
        AND COALESCE(VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(HIDDEN_END_DATE), 'YYYYMMDD'), 'YYYYMMDD') || HIDDEN_END_TIME, '9999123100')
        GROUP BY PRO_CODE) P ON P.PRO_CODE = PCM.PRO_CODE
        WHERE PC.MAIN_YN = 'Y' AND PC.OPEN_YN = 'Y'
        ORDER BY PC.SHOW_ORDER
    - - 【select】PRO_CATS(險種類型檔) join PRO_CATS_MAP( 險種類型對應主約商品檔) join PRODUCTS( 商品資料檔)
        
        SELECT PC.SHOW_ORDER CAT_SHOW_ORDER, PC.CAT_CODE, PC.CAT_NAME, PCM.PRO_CODE, PCM.SHOW_ORDER PRO_SHOW_ORDER
        FROM PRO_CATS PC
        JOIN PRO_CATS_MAP PCM ON PCM.CAT_CODE = PC.CAT_CODE
        JOIN (SELECT PRO_CODE, MAX(PLAN_VERSION||VERSION) FROM PRODUCTS
        WHERE (VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(START_DATE), 'YYYYMMDD'), 'YYYYMMDD') <= '20190905'
        AND VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(END_DATE), 'YYYYMMDD'), 'YYYYMMDD') >= '20190905'
        ) AND VARCHAR_FORMAT(CURRENT TIMESTAMP, 'YYYYMMDD') || CHAR(HOUR(CURRENT TIME))
        NOT BETWEEN COALESCE(VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(HIDDEN_START_DATE), 'YYYYMMDD'), 'YYYYMMDD') || HIDDEN_START_TIME, '9999123100')
        AND COALESCE(VARCHAR_FORMAT(TIMESTAMP_FORMAT(CHAR(HIDDEN_END_DATE), 'YYYYMMDD'), 'YYYYMMDD') || HIDDEN_END_TIME, '9999123100')
        GROUP BY PRO_CODE) P ON P.PRO_CODE = PCM.PRO_CODE
        WHERE PC.OPEN_YN = 'Y' AND PC.SHOW_YN = 'Y'
        ORDER BY PC.SHOW_ORDER, PCM.SHOW_ORDER
    - - 【select】MKT_ACTIVITIES( 行銷活動檔)
    - - 【select】MFP_PROTECTIONS(首頁我們的保障檔)
    - - 【select】PRODUCTS(商品資料檔)
    - - 【select】DB2INST1.PLAN
        
        SELECT * FROM DB2INST1.PLAN
        WHERE TRIM(PLAN_CODE) LIKE 'WADD'
        AND ( '2019/09/05' >= PLAN_START_DATE AND '2019/09/05' <= PLAN_END_DATE )
  - - - 【select】PRO_STATEMENTS(聲明事項檔) join PRO_STATEMENTS_MAP(聲明事項對應商品檔)
        傷害險需新增DB資料