“MA切流反馈修复”的版本间的差异

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

<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>