From c6908e1d2efd4f3a1fcfdb1af7f1b78156d07d91 Mon Sep 17 00:00:00 2001
From: Cui Zhi Feng <7426394+wuxixiaocui@user.noreply.gitee.com>
Date: 星期三, 23 十月 2024 09:15:58 +0800
Subject: [PATCH] 统计 待发货 在售商品 待审核商品 待售后处理
---
src/main/java/com/mzl/flower/mapper/member/MemberMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java b/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java
index 9d705c4..e1081ba 100644
--- a/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/member/MemberMapper.java
@@ -42,4 +42,10 @@
List<MemberVO> queryPage(@Param("dto") MemberQueryDTO dto, Page page);
+ @Select("select * from t_member where deleted = '0'")
+ List<Member> getAllMember();
+
+ @Select("select * from t_member where deleted = '0' and id != #{id} ")
+ List<Member> getOtherAllMember(@Param("id") Long id);
+
}
--
Gitblit v1.9.3