“首页经营效果中，增加按发布产品拆分指标选项”的版本间的差异
来自qingwei personal wiki
（→标题文字） |
|||
| 第4行： | 第4行： | ||
* 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 == | == oneness == | ||
| − | === | + | === vip.home.getShopSummary === |
<source lang="sql"> | <source lang="sql"> | ||
select | select | ||
${returnFields} | ${returnFields} | ||
from | from | ||
| − | <if test='statisticsType == "day"'> | + | <if test='statisticsType == "day" and seperateByCate == "false"'> |
dwp_en_dm_vip_comp_term_eff_d | dwp_en_dm_vip_comp_term_eff_d | ||
</if> | </if> | ||
| − | <if test='statisticsType == "week"'> | + | <if test='statisticsType == "week" and seperateByCate == "false"'> |
dwp_en_dm_vip_comp_term_eff_w | dwp_en_dm_vip_comp_term_eff_w | ||
</if> | </if> | ||
| − | <if test='statisticsType == "month"'> | + | <if test='statisticsType == "month" and seperateByCate == "false"'> |
dwp_en_dm_vip_comp_term_eff_m | dwp_en_dm_vip_comp_term_eff_m | ||
</if> | </if> | ||
2018年12月4日 (二) 12:12的版本
新表
- 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
vip.home.getShopSummary
select
${returnFields}
from
<if test='statisticsType == "day" and seperateByCate == "false"'>
dwp_en_dm_vip_comp_term_eff_d
</if>
<if test='statisticsType == "week" and seperateByCate == "false"'>
dwp_en_dm_vip_comp_term_eff_w
</if>
<if test='statisticsType == "month" and seperateByCate == "false"'>
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>
