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