MA切流反饋修復

首頁經營效果中，增加按發布產品拆分指標選項

首頁經營效果中，增加按發布產品拆分指標選項

新版產品>產品分析缺失 頂級展位、P4P

• 前端問題；增加兩個參數： TR, P4P

" 如果没有，不传递参数 "
{
"TR": "TR",
"P4P": "P4P"
}

• 後端接口[ vip/product/getEffectiveProductsTotal ]
  • http://oneness2.alibaba-inc.com/businessFlow?moduleId=114&interfaceId=1943&group=alidata

增加產品列表增加數據統計及分段功能

描述

https://aone.alibaba-inc.com/req/18338586

表

• 老版： dwp_en_dm_prod_terminal_eff_d
• 新版： dwp_en_dm_vip_prod_eff_d

老版分段產品統計sql

<sql id="effectiveProductWhereCondition" >
        stat_date = #statDate# and
        admin_mbr_seq = #adminMemberSeq# and

        <isEqual property="newProductTable" compareValue="true">
            terminal_type = 'TOTAL'
        </isEqual>

        <isEqual property="newProductTable" compareValue="false">
            terminal_type = 'PC_WAP'
        </isEqual>

      <dynamic>
        <isNotNull prepend=" and " property="minViews">
            imps_cnt_1d_027 &gt;= #minViews#</isNotNull>
        <isNotNull prepend=" and " property="maxViews">
            imps_cnt_1d_027 &lt;= #maxViews#</isNotNull>
        <isNotNull prepend=" and " property="minClicks">
            clk_cnt_1d_092 &gt;= #minClicks#</isNotNull>
        <isNotNull prepend=" and " property="maxClicks">
            clk_cnt_1d_092 &lt;= #maxClicks#</isNotNull>
        <isNotNull prepend=" and " property="minInquiries">
            fb_cnt_1d_013 &gt;= #minInquiries#</isNotNull>
        <isNotNull prepend=" and " property="maxInquiries">
            fb_cnt_1d_013 &lt;= #maxInquiries#</isNotNull>
        <isNotNull prepend=" and " property="minVisitors">
            uv_1d_169 &gt;= #minVisitors#</isNotNull>
        <isNotNull prepend=" and " property="maxVisitors">
            uv_1d_169 &lt;= #maxVisitors#</isNotNull>
        <isNotNull prepend=" and " property="minClkRate">
            clk_rate_1d_068 &gt;= #minClkRate#</isNotNull>
        <isNotNull prepend=" and " property="maxClkRate">
            clk_rate_1d_068 &lt;= #maxClkRate#</isNotNull>
        <isNotNull prepend=" and " property="name">
            prod_name like #name#</isNotNull>
        <isNotNull prepend=" and " property="AD">
            is_kw_prod = 'Y'</isNotNull>
        <isNotNull prepend=" and " property="PS">
            is_show_win = 'Y'</isNotNull>
        <isNotNull prepend=" and " property="TR">
            is_intlbw = 'Y'</isNotNull>
        <isNotNull prepend=" and " property="P4P">
            is_p4p_prod = 'Y'</isNotNull>
        <isNotNull prepend=" and " property="owner">
            owner_mbr_seq = #owner#</isNotNull>
        <isNotNull prepend=" and " property="groupLevel1">
            prod_group_id = #groupLevel1#</isNotNull>
        <isNotNull prepend=" and " property="groupLevel2">
            group_id2 = #groupLevel2#</isNotNull>
        <isNotNull prepend=" and " property="groupLevel3">
            group_id3 = #groupLevel3#</isNotNull>
        <isNotNull prepend=" and " property="model">
            prod_model like #model#</isNotNull>
        <isNotNull prepend=" and " property="beginUpdatedDate">
            mdf_time &gt;= #beginUpdatedDate#</isNotNull>
        <isNotNull prepend=" and " property="endUpdatedDate">
            mdf_time &lt;= #endUpdatedDate#</isNotNull>
        <isNotNull prepend=" and " property="hasEffect">
           is_effer_prod = 'Y'</isNotNull>

      </dynamic>
</sql>