“组件化”的版本间的差异

来自qingwei personal wiki
跳转至： 导航， 搜索
（创建页面，内容为“== 首页经营数据店铺指标概览 == === SQL === <source lang="sql"> select stat_date as statDate, fb_uv_1d_013 as fbUv, suc_ord_amt_1d as orderAmo…”）
 
（→‎映射表接口）
 
（未显示同一用户的6个中间版本）
第20行： 第20行：
 
     and (stat_date = '2018-12-17' or stat_date = '2018-12-16')     
 
     and (stat_date = '2018-12-17' or stat_date = '2018-12-16')     
 
     and statistic_type = 'all'
 
     and statistic_type = 'all'
 +
</source>
 +
== 映射表接口 ==
 +
<source lang="json">
 +
[
 +
  "vip/product/getProdcutSummaryTrend",
 +
  {
 +
    "totalFbProductCount": "有询盘产品数",
 +
    "totalOrderProductCount": "有订单产品数",
 +
    "totalProductCount" : "产品总数",
 +
    "totalVisitProductCount": "有访问产品数"
 +
  },
 +
  {
 +
    "beginDate": "开始日期",
 +
    "endDate": "结束日期",
 +
    "statisticsType": "日期类型",
 +
    "adminMemberSeq": "用户ID"
 +
  },
 +
  {
 +
    "statDate": "日期"
 +
  }
 +
]
 +
 +
 +
[
 +
  "vip/home/getShopTrendsForGeek",
 +
  {
 +
    "shopUv": "店铺访问人数",
 +
    "shopPv": "店铺访问次数",
 +
    "searchImps" : "搜索曝光次数",
 +
    "searchClicks": "搜索点击次数",
 +
    "fbUv": "询盘人数",
 +
    "fbPv": "询盘个数",
 +
    "tmUv": "tm咨询人数",
 +
    "orderAmount": "信保交易订单个数",
 +
    "orderCount": "信保交易金额"
 +
 +
  },
 +
  {
 +
    "beginDate": "开始日期",
 +
    "endDate": "结束日期",
 +
    "statisticsType": "日期类型",
 +
    "adminMemberSeq": "用户ID"
 +
  },
 +
  {
 +
    "statDate": "日期"
 +
  }
 +
]
 +
</source>
 +
 +
== 现有测试接口 ==
 +
<source lang="json">
 +
[
 +
  "vip/product/getProdcutSummaryTrend",
 +
  {
 +
    "beginDate": "2019-01-01",
 +
    "endDate": "2019-01-02",
 +
    "statisticsType": "day",
 +
    "adminMemberSeq": "200042360"
 +
  }
 +
]
 +
 +
[
 +
  "vip/home/getShopTrendsForGeek",
 +
  {
 +
    "beginDate": "2019-01-01",
 +
    "endDate": "2019-01-02",
 +
    "statisticsType": "day",
 +
    "adminMemberSeq": "200042360"
 +
  }
 +
]
 
</source>
 
</source>

2019年2月16日 (六) 12:20的最新版本

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

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/product/getProdcutSummaryTrend",
  {
    "totalFbProductCount": "有询盘产品数",
    "totalOrderProductCount": "有订单产品数",
    "totalProductCount" : "产品总数",
    "totalVisitProductCount": "有访问产品数"
  },
  {
    "beginDate": "开始日期",
    "endDate": "结束日期",
    "statisticsType": "日期类型",
    "adminMemberSeq": "用户ID"
  },
  {
    "statDate": "日期"
  }
]


[
  "vip/home/getShopTrendsForGeek",
  {
    "shopUv": "店铺访问人数",
    "shopPv": "店铺访问次数",
    "searchImps" : "搜索曝光次数",
    "searchClicks": "搜索点击次数",
    "fbUv": "询盘人数",
    "fbPv": "询盘个数",
    "tmUv": "tm咨询人数",
    "orderAmount": "信保交易订单个数",
    "orderCount": "信保交易金额"

  },
  {
    "beginDate": "开始日期",
    "endDate": "结束日期",
    "statisticsType": "日期类型",
    "adminMemberSeq": "用户ID"
  },
  {
    "statDate": "日期"
  }
]

现有测试接口

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

[
  "vip/home/getShopTrendsForGeek",
  {
    "beginDate": "2019-01-01",
    "endDate": "2019-01-02",
    "statisticsType": "day",
    "adminMemberSeq": "200042360"
  }
]
取自“http://106.14.10.253:8190/index.php?title=组件化&oldid=1042”