From c9ae4fb9e1e99beec9ffde48243b5564fcd7163f Mon Sep 17 00:00:00 2001
From: lisy <linlangsur163@163.com>
Date: 星期二, 01 八月 2023 14:13:35 +0800
Subject: [PATCH] 管理后台优惠券列表sql语句bug
---
cloud-server-activity/src/main/resources/mapper/CouponMapper.xml | 21 ++++-----------------
1 files changed, 4 insertions(+), 17 deletions(-)
diff --git a/cloud-server-activity/src/main/resources/mapper/CouponMapper.xml b/cloud-server-activity/src/main/resources/mapper/CouponMapper.xml
index 5ea88d3..491e235 100644
--- a/cloud-server-activity/src/main/resources/mapper/CouponMapper.xml
+++ b/cloud-server-activity/src/main/resources/mapper/CouponMapper.xml
@@ -26,23 +26,10 @@
`status`,
state
from t_coupon
- where 1 = 1SELECT id,
- `name`,
- useScope,
- `type`,
- distributionMethod,
- date_format(startTime ,'%Y-%m-%d') as startTime,
- date_format(endTime ,'%Y-%m-%d') as endTime,
- userPopulation,
- quantityIssued,
- pickUpQuantity,
- `status`,
- state
- from t_coupon
- where 1=1
- <if test="name != null">
- and `name` like concat('%', #{name}, '%')
- </if>
+ where 1 = 1
+ <if test="name != null">
+ and `name` like concat('%', #{name}, '%')
+ </if>
<if test="type != null">
and type = #{type}
</if>
--
Gitblit v1.7.1