From d3334bbb98a1524e67bd50aee1078a7eec40a55f Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期日, 26 二月 2023 13:05:55 +0800
Subject: [PATCH] 20230226@xingjs@提交官网一张图相关内容接口(优化完善sql--修改数据存储sql)
---
src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 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 5cc4632..0014a67 100644
--- a/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java
@@ -4,6 +4,8 @@
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
+import java.util.List;
+
/**
* 绌洪棿鍩虹Mapper
* @author WWW
@@ -39,6 +41,23 @@
public String selectGeometryType(@Param("tab") String tab);
/**
+ * 鏌ヨDB涓孩鍑虹殑鍗曚綅ID
+ *
+ * @param tab 琛ㄥ悕
+ * @param depid 鍗曚綅ID
+ * @param geoFilter 绌洪棿杩囨护鏉′欢
+ * @return 婧㈠嚭鐨勫崟浣岻D
+ */
+ @Select("<script>" +
+ " 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") String depid, @Param("geoFilter") String geoFilter);
+
+ /**
* 鏇存柊绌洪棿浣嶇疆
*
* @param tab 琛ㄥ悕
--
Gitblit v1.9.3