From 82735e4d46ac7b9969facef2acc8f8e793b68f71 Mon Sep 17 00:00:00 2001 From: doum <doum> Date: 星期一, 15 九月 2025 16:11:42 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- server/services/src/main/java/com/doumee/dao/business/MemberMapper.java | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/server/services/src/main/java/com/doumee/dao/business/MemberMapper.java b/server/services/src/main/java/com/doumee/dao/business/MemberMapper.java index 11e2e15..afb2f5b 100644 --- a/server/services/src/main/java/com/doumee/dao/business/MemberMapper.java +++ b/server/services/src/main/java/com/doumee/dao/business/MemberMapper.java @@ -22,8 +22,8 @@ " where id in ( " + " select ii.member_id from identity_info ii where ii.AUDIT_STATUS = 2 and type = #{orderType} " + " and ( CONVERT( ST_Distance_Sphere ( POINT ( ii.lgt, ii.lat ), POINT ( #{lgt}, #{lat} )) /1000,DECIMAL(15,2))) < 100 " + - " )" + + " ) and RELEASE_MEMBER_ID != #{releaseMemberId} " + " order by level , score desc , distance asc ") - List<Member> getList(@Param("lgt") BigDecimal lgt, @Param("lat") BigDecimal lat, @Param("orderType") Integer orderType); + List<Member> getList(@Param("lgt") BigDecimal lgt, @Param("lat") BigDecimal lat, @Param("orderType") Integer orderType, @Param("releaseMemberId") Integer releaseMemberId); } -- Gitblit v1.9.3