组件化

首页经营数据店铺指标概览

SQL

select
    stat_date as statDate,
    fb_uv_1d_013 as fbUv,
    suc_ord_amt_1d as orderAmount,
    pv_1d_01 as shopPv,
    suc_ord_cnt_1d as orderCount,
    clk_cnt_1d_092 as searchClicks,
    uv_1d_063 as shopUv,
    fb_uv_1d_014 as tmUv,
    imps_cnt_1d_027 as searchImps,
    fb_cnt_1d_013 as fbPv  
from
    dwp_en_dm_vip_comp_term_eff_d  
where
    admin_mbr_seq = '200042360'      
    and terminal_type = 'TOTAL'      
    and (stat_date = '2018-12-17' or stat_date = '2018-12-16')     
    and statistic_type = 'all'

映射表接口

[
  "vip/home/getShopTrends-new",
  {
    "fbUv2": "店铺访问人数",
    "tmUV2": "临时访问人数"
  },
  {
    "admMbrSeq": "用户ID",
    "statDate": "日期"
  },
  {
    "statData": "日期"
  }
]

测试接口

[
  "vip/product/getProdcutSummaryTrend",
  {
    "beginDate": "2019-01-01",
    "endDate": "2019-01-02",
    "statisticsType": "day",
    "adminMemberSeq": "200042360"
  }
]