查看“KP工作台数据漏斗”的源代码

== 描述 ==
=== aone ===
[https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone]
=== RPC接口 ===
[http://oneness2.alibaba-inc.com/businessFlow?moduleId=145&interfaceId=2649&group=alidata 接口]

== 需求==
=== 接口 ===
external/kpwork/overview
=== sql ===
* terminal_type: PC, TOTAL, WS
<source lang="sql">
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 stat_date<="2018-10-9"
    and statistic_type="ALL"
    and admin_mbr_seq="14"
    and terminal_type="PC"
    and is_main_cate="Y"
    and cate_lv2_id=100010695
</source>
=== 展现的条目 ===
*  （投）fb_cnt_1d_013                :   最近1天有效MC询盘数
*  （曝）imps_cnt_1d_027           :   最近1天排除联盟的搜索item和p4p商品曝光量
*  （访）uv_1d_169                       :   最近1天访客数
*  （点）clk_cnt_1d_092              ： 最近1天排除联盟的搜索item和p4p商品相关点击次数
*  （反）fst_reply_rate_1m_003   :  最近30天及时回复率

== oneService ==
===  参数 ===
*statDate (根据statisticsType校验，返回相应错误) 
*terminalType
*statisticsType
*adminMemberSeq

=== SQL配置 ===
* external.kpwork.overview
<source lang="sql">
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} 
       or stat_date = #{prevDate} )
    and admin_mbr_seq = #{adminMemberSeq}
    and terminal_type = #{terminalType}
    and is_main_cate = #{isMainCate}
    and cate_lv2_id = #{cateLv2Id}
</source>
=== java脚本 ===
* 计算前一天/周/月
<source lang="java">
import java.text.SimpleDateFormat;
import org.apache.commons.lang.time.DateUtils;


SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date statDate = new Date(sdf.parse(statDateStr).getTime());
Date prevDate = statDate;
if ("day".equalsIgnoreCase(statisticsType)) {
    prevDate = DateUtils.addDays(statDate, -1);
} else if ("week".equalsIgnoreCase(statisticsType)) {
    prevDate = DateUtils.addWeeks(statDate, -1);
} else if ("month".equalsIgnoreCase(statisticsType)) {
    prevDate = DateUtils.addMonths(statDate, -1);
}

return sdf.format(prevDate);
</source>
[[category: 阿里]]
[[category: 数据管家]]