From 5f0bb044b603a335954b11bf3880f4ad6824e98f Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期五, 20 十二月 2024 17:37:47 +0800 Subject: [PATCH] add: 花材销售统计 --- 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