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

老版分段產品統計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>