“首页经营效果中,增加按发布产品拆分指标选项”的版本间的差异
来自qingwei personal wiki
第3行: | 第3行: | ||
* dwp_en_dm_vip_catelv3_term_cube_d | * dwp_en_dm_vip_catelv3_term_cube_d | ||
* dwp_en_dm_vip_comp_cate_term_eff_d (dwp_en_dm_vip_comp_term_eff_d) | * dwp_en_dm_vip_comp_cate_term_eff_d (dwp_en_dm_vip_comp_term_eff_d) | ||
− | + | == oneness == | |
+ | === 标题文字 === | ||
+ | <source lang="sql"> | ||
+ | select | ||
+ | ${returnFields} | ||
+ | from | ||
+ | <if test='statisticsType == "day"'> | ||
+ | dwp_en_dm_vip_comp_term_eff_d | ||
+ | </if> | ||
+ | <if test='statisticsType == "week"'> | ||
+ | dwp_en_dm_vip_comp_term_eff_w | ||
+ | </if> | ||
+ | <if test='statisticsType == "month"'> | ||
+ | dwp_en_dm_vip_comp_term_eff_m | ||
+ | </if> | ||
+ | where | ||
+ | admin_mbr_seq = #{adminMemberSeq} | ||
+ | and terminal_type = #{terminalType} | ||
+ | <if test="statDateList != null"> | ||
+ | and stat_date in | ||
+ | <foreach collection="statDateList" item="item" open="(" separator="," close=")"> | ||
+ | #{item} | ||
+ | </foreach> | ||
+ | </if> | ||
+ | <if test="region!= null"> | ||
+ | and statistic_type = #{region} | ||
+ | </if> | ||
+ | </source> | ||
[[category: 阿里]] | [[category: 阿里]] | ||
[[category: 数据管家]] | [[category: 数据管家]] |
2018年12月4日 (二) 12:11的版本
新表
- dwp_en_dm_vip_comp_term_region_catelv3_cube_d
- dwp_en_dm_vip_catelv3_term_cube_d
- dwp_en_dm_vip_comp_cate_term_eff_d (dwp_en_dm_vip_comp_term_eff_d)
oneness
标题文字
select
${returnFields}
from
<if test='statisticsType == "day"'>
dwp_en_dm_vip_comp_term_eff_d
</if>
<if test='statisticsType == "week"'>
dwp_en_dm_vip_comp_term_eff_w
</if>
<if test='statisticsType == "month"'>
dwp_en_dm_vip_comp_term_eff_m
</if>
where
admin_mbr_seq = #{adminMemberSeq}
and terminal_type = #{terminalType}
<if test="statDateList != null">
and stat_date in
<foreach collection="statDateList" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
<if test="region!= null">
and statistic_type = #{region}
</if>