From 74916b92e0a94053e206cd559622a671427f7d2b Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期二, 03 九月 2024 11:16:42 +0800 Subject: [PATCH] 1.优惠券相关代码提交 --- src/main/resources/mapper/coupon/CouponRecordMapperCustom.xml | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/main/resources/mapper/coupon/CouponRecordMapperCustom.xml b/src/main/resources/mapper/coupon/CouponRecordMapperCustom.xml index 1254df6..820cc2d 100644 --- a/src/main/resources/mapper/coupon/CouponRecordMapperCustom.xml +++ b/src/main/resources/mapper/coupon/CouponRecordMapperCustom.xml @@ -32,12 +32,12 @@ </resultMap> <update id="checkCouponExpired"> - update t_coupon_record set `status`='expired' where `status`='unused' and effective_end < NOW() + update t_coupon_record set `status`='expired' where `status`='unused' and effective_end < NOW() <if test="param.userId != null and param.userId != ''"> - AND t.user_id = #{param.userId} + AND user_id = #{param.userId} </if> <if test="param.customerId != null and param.customerId != ''"> - AND t.customer_id = #{param.customerId} + AND customer_id = #{param.customerId} </if> </update> -- Gitblit v1.9.3