券查询兼容

yujian

2020-06-09 e72a1e701659e06e704976464b8de20ebbcac8ea

券查询兼容

 fanli/src/main/java/com/yeshi/fanli/mapping/user/UserSystemCouponRecordMapper.xml

@@ -79,12 +79,16 @@
  <select id="getRecordByOrderNoList" resultMap="BaseResultMap">

    SELECT * FROM  `yeshi_ec_user_system_coupon_record` cd 

      LEFT JOIN `yeshi_ec_user_system_coupon` uc ON uc.`usc_id` = cd.`ucr_user_coupon_id`

    WHERE <if test="source == 1">(cd.ucr_good_source = 0 or cd.ucr_good_source = 1)</if>

          <if test="source == 2">cd.ucr_good_source = 2</if>

            <if test="source == 3">cd.ucr_good_source = 3</if>

    WHERE 1=1

          <if test="source == 1"> AND (cd.ucr_good_source = 0 or cd.ucr_good_source = 1)</if>

          <if test="source == 2">AND cd.ucr_good_source = 2</if>

            <if test="source == 3">AND cd.ucr_good_source = 3</if>

            <if test="source == 4">AND cd.ucr_good_source = 4</if>

            <if test="source == 5">AND cd.ucr_good_source = 5</if>

        <if test="list != null">

            AND cd.`ucr_order_no` in

        <foreach collection="list" item="item" open="(" close=")"

            separator=",">#{item}</foreach>

            <foreach collection="list" item="item" open="(" close=")" separator=",">#{item}</foreach>

        </if>

  </select>

  

  <select id="getNearByUserCouponId" resultMap="BaseResultMap">