From 3b4ff9fba93ee13919f990ef8c2910a902a2a8f3 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期二, 24 九月 2024 10:17:26 +0800
Subject: [PATCH] add：会员等级筛选
---
src/main/java/com/mzl/flower/dto/request/menber/UserMemberRecordQueryDTO.java | 2 ++
src/main/resources/mapper/member/MemberGrowthRecordMapper.xml | 3 +++
2 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/request/menber/UserMemberRecordQueryDTO.java b/src/main/java/com/mzl/flower/dto/request/menber/UserMemberRecordQueryDTO.java
index 47fd2d8..c20e370 100644
--- a/src/main/java/com/mzl/flower/dto/request/menber/UserMemberRecordQueryDTO.java
+++ b/src/main/java/com/mzl/flower/dto/request/menber/UserMemberRecordQueryDTO.java
@@ -10,4 +10,6 @@
private String nickName;
@ApiModelProperty(value = "联系方式")
private String tel;
+ @ApiModelProperty(value = "联系方式")
+ private String levelName;
}
diff --git a/src/main/resources/mapper/member/MemberGrowthRecordMapper.xml b/src/main/resources/mapper/member/MemberGrowthRecordMapper.xml
index a9f2622..3e38c93 100644
--- a/src/main/resources/mapper/member/MemberGrowthRecordMapper.xml
+++ b/src/main/resources/mapper/member/MemberGrowthRecordMapper.xml
@@ -42,6 +42,9 @@
<if test="dto.tel!= null and dto.tel != ''">
and t.tel like CONCAT('%',#{dto.tel},'%')
</if>
+ <if test="dto.levelName!= null and dto.levelName != ''">
+ and m.name like CONCAT('%',#{dto.levelName},'%')
+ </if>
GROUP BY c.id
order by c.update_time desc
</select>
--
Gitblit v1.9.3