券查询优化

yujian

2019-03-05 c0889821c4c76ad646ed6a69a02a2fba16a2de5d

券查询优化

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

@@ -117,6 +117,7 @@
  <select id="getEnableListByCouponId" resultMap="ResultVOMap">
    SELECT * FROM `yeshi_ec_user_system_coupon` uc
    WHERE uc.`usc_uid`= #{uid} AND uc.usc_state = 1 
        AND DATE_FORMAT(CURDATE(),'%Y%m%d') <![CDATA[ >= ]]>DATE_FORMAT(uc.`usc_start_time`,'%Y%m%d');
        <if test="activated != null">AND uc.usc_state_activate = #{activated}</if>
        AND uc.usc_coupon_id in
        <foreach collection="list" item="item" open="(" close=")"

 fanli/src/main/java/com/yeshi/fanli/service/impl/user/UserSystemCouponServiceImpl.java

@@ -1078,7 +1078,9 @@
            

            // 消息推送

            try {

                userOtherMsgNotificationService.welfareCouponActive(userSystemCoupon, new UserInfo(uid));

                UserInfo userInfo = userInfoService.selectByPKey(uid);

				
                userOtherMsgNotificationService.welfareCouponActive(userSystemCoupon, userInfo);

            } catch(Exception e) {

                try {

                    LogHelper.errorDetailInfo(e);

@@ -1452,7 +1454,5 @@
        userInfoExtraService.saveUserInfoExtra(userInfoExtra);

    

    }

	
	
	
}