查看“首页经营效果中，增加按发布产品拆分指标选项”的源代码

== 新表 ==
* dwp_en_dm_vip_comp_term_region_catelv3_cube_d (dwp_en_dm_vip_comp_term_region_cube_d)
* dwp_en_dm_vip_catelv3_term_cube_d (dwp_en_dm_vip_cate_term_cube_d)
** 获取具体类目的指标在行业平均效果 （老表不分类目，是店铺的所有类目汇总）
** 指标包括 'comp_fb_uv' , 'comp_ord_amt' , 'shop_pv' , 'comp_ord_cnt' , 'comp_clk_cnt' , 'comp_atm_uv' , 'shop_uv' , 'comp_imps_cnt' , 'comp_fb_cnt'
* dwp_en_dm_vip_comp_cate_term_eff_d (dwp_en_dm_vip_comp_term_eff_d)

== oneness ==
=== vip.home.getShopSummary ===
<source lang="sql">
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>
</source>

== hsf 测试 ==
=== vip/home/getShopSummary ===
<source lang=json>
[
  "vip/home/getShopSummary-new",
  {
    "adminMemberSeq": "14",
    "statDate": "2018-12-04",
    "statisticsType": "day",
    "prevDate": "2018-12-03",
    "cateId": "330",
    "seperateByCate": "true"
  }
]
</source>
* 比较老版少了4个字段  (dwp_en_dm_vip_comp_cate_term_eff_d)
** statDate {1} fbUv {4} orderAmount {4} shopPv {4} orderCount {4} searchClicks {4} shopUv {4} tmUv {4} searchImps {4} fbPv
** statDate {1} fbUv {4} searchClicks {4} tmUv {4} searchImps {4} fbPv {4}
** 少的字段： orderAmount  shopPv  orderCount  shopUv

=== vip/home/getShopTrends ===
<source lang="json">
[
  "vip/home/getShopTrends-new",
  {
    "adminMemberSeq": "14",
    "beginDate": "2018-12-03",
    "endDate": "2018-12-04",
    "statisticsType": "day",
    "cateId": "145",
    "seperateByCate": "true"
  }
]
</source>

=== vip/home/getShopRegionAnalysis ===
<source lang="json">
[
  "vip/home/getShopRegionAnalysis-new",
  {
    "adminMemberSeq": "14",
    "statDate": "2018-10-01",
    "statisticsType": "day",
    "cateId": "145",
    "seperateByCate": "true"
  }
]
</source>
[[category: 阿里]]
[[category: 数据管家]]