From e9cee4fcb5732b8e4e489e13e777f6c3c8ddd429 Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Tue, 28 Sep 2021 15:50:17 +0800
Subject: [PATCH] fix

---
 src/main/resources/mapper/modules/MallMemberMapper.xml |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml
index 8349b25..81c198b 100644
--- a/src/main/resources/mapper/modules/MallMemberMapper.xml
+++ b/src/main/resources/mapper/modules/MallMemberMapper.xml
@@ -158,7 +158,7 @@
 
     <select id="selectMemberParentAgentList" resultType="cc.mrbird.febs.mall.entity.MallMember">
         select * from mall_member
-        where level != 'FIRST_LEVEL' and  invite_id IN
+        where level not in  ('ZERO_LEVEL', 'FIRST_LEVEL') and  invite_id IN
         <foreach collection = "list" item = "item"  separator=","  open = "(" close = ")" >
             #{item}
         </foreach >

--
Gitblit v1.9.1