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

来自qingwei personal wiki
跳转至: 导航搜索
vip.home.getShopSummary
新表
第1行: 第1行:
 
== 新表 ==
 
== 新表 ==
 
* dwp_en_dm_vip_comp_term_region_catelv3_cube_d
 
* dwp_en_dm_vip_comp_term_region_catelv3_cube_d
* dwp_en_dm_vip_catelv3_term_cube_d
+
* dwp_en_dm_vip_catelv3_term_cube_d (dwp_en_dm_vip_cate_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 ==
 
== oneness ==
 
=== vip.home.getShopSummary ===
 
=== vip.home.getShopSummary ===

2018年12月4日 (二) 13:05的版本

新表

  • dwp_en_dm_vip_comp_term_region_catelv3_cube_d
  • dwp_en_dm_vip_catelv3_term_cube_d (dwp_en_dm_vip_cate_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>
    <if test='statisticsType == "day" and seperateByCate == "true"'> 
        dwp_en_dm_vip_comp_cate_term_eff_d
    </if>  
    <if test='statisticsType == "week" and seperateByCate == "true"'> 
        dwp_en_dm_vip_comp_cate_term_eff_w
    </if>
    <if test='statisticsType == "month" and seperateByCate == "true"'> 
        dwp_en_dm_vip_comp_cate_term_eff_m
    </if>
where
    admin_mbr_seq = #{adminMemberSeq}
    and terminal_type = #{terminalType}
    <if test='seperateByCate == "true"'>
        and cate_lv3_id = #{cateId}
    </if>
     <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>

hsf 测试

vip/home/getShopSummary

[
  "vip/home/getShopSummary",
  {
    "adminMemberSeq": "14",
    "statDate": "2018-11-13",
    "statisticsType": "day",
    "prevDate": "2018-11-12",
    "cateId": "145"
  }
]