“首页经营效果中,增加按发布产品拆分指标选项”的版本间的差异

来自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>