“组件化”的版本间的差异
来自qingwei personal wiki
第35行: | 第35行: | ||
{ | { | ||
"statData": "日期" | "statData": "日期" | ||
+ | } | ||
+ | ] | ||
+ | </source> | ||
+ | == 测试接口 == | ||
+ | <source> | ||
+ | [ | ||
+ | "vip/product/getProdcutSummaryTrend", | ||
+ | { | ||
+ | "beginDate": "2019-01-01", | ||
+ | "endDate": "2019-01-02", | ||
+ | "statisticsType": "day", | ||
+ | "adminMemberSeq": "200042360" | ||
} | } | ||
] | ] | ||
</source> | </source> |
2019年2月16日 (六) 08:47的版本
首页经营数据店铺指标概览
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"
}
]