“组件化”的版本间的差异
来自qingwei personal wiki
（创建页面，内容为“== 首页经营数据店铺指标概览 == === SQL === <source lang="sql"> select stat_date as statDate, fb_uv_1d_013 as fbUv, suc_ord_amt_1d as orderAmo…”） |
|||
| 第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/home/getShopTrends-new", | ||
| + | { | ||
| + | "fbUv2": "店铺访问人数", | ||
| + | "tmUV2": "临时访问人数" | ||
| + | }, | ||
| + | { | ||
| + | "admMbrSeq": "用户ID", | ||
| + | "statDate": "日期" | ||
| + | }, | ||
| + | { | ||
| + | "statData": "日期" | ||
| + | } | ||
| + | ] | ||
</source> | </source> | ||
2019年2月13日 (三) 10:37的版本
首页经营数据店铺指标概览
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": "日期"
}
]
