From 8aa0bf51f21e023a6cf244183cd25a7cdab7b356 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 14 二月 2023 17:25:43 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
index 7d7f724..0014a67 100644
--- a/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
@@ -49,13 +49,13 @@
* @return 婧㈠嚭鐨勫崟浣岻D
*/
@Select("<script>" +
- " select depid from ${tab} where depid > 0 and depid != ALL(fn_rec_array(#{depid}, 'dep'))" +
+ " select depid from ${tab} where depid is not null and depid not like '${depid}%'" +
" <if test='geoFilter != null'>" +
" and ${geoFilter}" +
" </if>" +
" group by depid" +
"</script>")
- public List<Integer> selectDbOverflowDep(@Param("tab") String tab, @Param("depid") Integer depid, @Param("geoFilter") String geoFilter);
+ public List<Integer> selectDbOverflowDep(@Param("tab") String tab, @Param("depid") String depid, @Param("geoFilter") String geoFilter);
/**
* 鏇存柊绌洪棿浣嶇疆
--
Gitblit v1.9.3