“首页经营效果中,增加按发布产品拆分指标选项”的版本间的差异
来自qingwei personal wiki
(→hsf 测试) |
(→vip.home.getShopSummary) |
||
第30行: | 第30行: | ||
admin_mbr_seq = #{adminMemberSeq} | admin_mbr_seq = #{adminMemberSeq} | ||
and terminal_type = #{terminalType} | and terminal_type = #{terminalType} | ||
− | and cate_lv3_id = #{cateId} | + | <if test='seperateByCate == "true"'> |
+ | and cate_lv3_id = #{cateId} | ||
+ | </if> | ||
<if test="statDateList != null"> | <if test="statDateList != null"> | ||
and stat_date in | and stat_date in | ||
第41行: | 第43行: | ||
</if> | </if> | ||
</source> | </source> | ||
+ | |||
== hsf 测试 == | == hsf 测试 == | ||
=== vip/home/getShopSummary === | === vip/home/getShopSummary === |
2018年12月4日 (二) 12:31的版本
新表
- 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>
<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"
}
]