From c2a0a337498445683f81e33597bf694e0dc9fb68 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 15 Sep 2022 17:55:02 +0800
Subject: [PATCH] 20220902
---
src/main/resources/mapper/modules/MallTeamLeaderMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/mapper/modules/MallTeamLeaderMapper.xml b/src/main/resources/mapper/modules/MallTeamLeaderMapper.xml
index b66b32e..90324c4 100644
--- a/src/main/resources/mapper/modules/MallTeamLeaderMapper.xml
+++ b/src/main/resources/mapper/modules/MallTeamLeaderMapper.xml
@@ -145,7 +145,7 @@
select
a.*
from mall_team_leader a
- where a.state = 1
+ where a.state = 1 and a.online_state = 1
</select>
<select id="selectLeaderByUniqueCode" resultType="cc.mrbird.febs.mall.entity.MallTeamLeader">
@@ -168,7 +168,7 @@
) * 1000
) AS distance
from mall_team_leader a
- where a.state = 1
+ where a.state = 1 and a.online_state = 1
order by distance ASC limit 1
</select>
--
Gitblit v1.9.1