“KP工作台数据漏斗”的版本间的差异
来自qingwei personal wiki
（→SQL配置） |
（→oneService） |
||
| 第22行： | 第22行： | ||
and cate_lv2_id=100010695 | and cate_lv2_id=100010695 | ||
</source> | </source> | ||
| + | === 参数 === | ||
| + | <pre> | ||
| + | statDate (根据statisticsType校验，返回相应错误) | ||
| + | terminalType | ||
| + | statisticsType | ||
| + | adminMemberSeq | ||
| + | </pre> | ||
=== SQL配置 === | === SQL配置 === | ||
* external.kpwork.overview | * external.kpwork.overview | ||
2018年11月12日 (一) 06:01的版本
描述
接口
external/kpwork/overview
oneService
SELECT
stat_date,
imps_cnt_1d_027,
clk_cnt_1d_092,
uv_1d_169,
fb_cnt_1d_013,
fst_reply_rate_1m_003
FROM
dwp_en_dm_comp_term_catelv2_eff_d
where
stat_date="2018-10-8"
and statistic_type="ALL"
and admin_mbr_seq="14"
and terminal_type="PC"
and is_main_cate="Y"
and cate_lv2_id=100010695
参数
statDate (根据statisticsType校验，返回相应错误) terminalType statisticsType adminMemberSeq
SQL配置
- external.kpwork.overview
select
${returnFields}
from
<if test='statisticsType == "day"'>
dwp_en_dm_comp_term_catelv2_eff_d
</if>
<if test='statisticsType == "week"'>
dwp_en_dm_comp_term_catelv2_eff_w
</if>
<if test='statisticsType == "month"'>
dwp_en_dm_comp_term_catelv2_eff_m
</if>
where
stat_date= #{statDate}
and admin_mbr_seq= #{adminMemberSeq}
and statistic_type= #{region}
and terminal_type= #{terminalType}
and is_main_cate= #{isMainCate}
and cate_lv2_id= #{cateLv2Id}
