“组件化”的版本间的差异
来自qingwei personal wiki
(→映射表接口) |
|||
第24行: | 第24行: | ||
<source lang="json"> | <source lang="json"> | ||
[ | [ | ||
− | "vip/ | + | "vip/product/getProdcutSummaryTrend", |
{ | { | ||
− | " | + | "totalFbProductCount": " 有询盘产品数", |
− | " | + | "totalOrderProductCount": "有订单产品数", |
+ | "totalProductCount" : "产品总 数", | ||
+ | "totalVisitProductCount": " 有 访问 产品 数" | ||
}, | }, | ||
{ | { | ||
− | " | + | "beginDate": " 开始日期", |
− | " | + | "endDate": "结束日期", |
+ | "statisticsType": "日期 类型", | ||
+ | "adminMemberSeq": "用户ID" | ||
}, | }, | ||
{ | { | ||
− | " | + | "statDate": "日期" |
} | } | ||
] | ] | ||
</source> | </source> | ||
+ | |||
== 测试接口 == | == 测试接口 == | ||
<source> | <source> |
2019年2月16日 (六) 08:54的版本
首页经营数据店铺指标概览
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"
}
]