“组件化”的版本间的差异
来自qingwei personal wiki
(→映射表接口) |
(→映射表接口) |
||
(未显示同一用户的3个中间版本) | |||
第30行: | 第30行: | ||
"totalProductCount" : "产品总数", | "totalProductCount" : "产品总数", | ||
"totalVisitProductCount": "有访问产品数" | "totalVisitProductCount": "有访问产品数" | ||
+ | }, | ||
+ | { | ||
+ | "beginDate": "开始日期", | ||
+ | "endDate": "结束日期", | ||
+ | "statisticsType": "日期类型", | ||
+ | "adminMemberSeq": "用户ID" | ||
+ | }, | ||
+ | { | ||
+ | "statDate": "日期" | ||
+ | } | ||
+ | ] | ||
+ | |||
+ | |||
+ | [ | ||
+ | "vip/home/getShopTrendsForGeek", | ||
+ | { | ||
+ | "shopUv": "店铺访问人数", | ||
+ | "shopPv": "店铺访问次数", | ||
+ | "searchImps" : "搜索曝光次数", | ||
+ | "searchClicks": "搜索点击次数", | ||
+ | "fbUv": "询盘人数", | ||
+ | "fbPv": "询盘个数", | ||
+ | "tmUv": "tm咨询人数", | ||
+ | "orderAmount": "信保交易订单个数", | ||
+ | "orderCount": "信保交易金额" | ||
+ | |||
}, | }, | ||
{ | { | ||
第43行: | 第69行: | ||
</source> | </source> | ||
− | == 测试接口 == | + | == 现有 测试接口 == |
− | <source> | + | <source lang="json"> |
[ | [ | ||
"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: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"
}
]