From 1d53dd8f501a98ddcce8146443b51b357ef5f9b1 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 29 十二月 2022 16:55:46 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java | 40 ++++++++++++++++++++++++++++++++++------
1 files changed, 34 insertions(+), 6 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 03e93c5..7d7f724 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
@@ -26,17 +28,43 @@
* @param tab 琛ㄥ悕
* @return SRID
*/
- @Select("select ST_SRID(geom) from ${tab} limit 1")
+ @Select("select ST_SRID(geom) from ${tab} where geom is not null limit 1")
public Integer selectSrid(@Param("tab") String tab);
+
+ /**
+ * 鏍规嵁琛ㄥ悕鏌ヨ绌洪棿绫诲瀷
+ *
+ * @param tab 琛ㄥ悕
+ * @return SRID
+ */
+ @Select("select ST_GeometryType(geom) from ${tab} where geom is not null limit 1")
+ 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 > 0 and depid != ALL(fn_rec_array(#{depid}, 'dep'))" +
+ " <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);
/**
* 鏇存柊绌洪棿浣嶇疆
*
- * @param tab 琛ㄥ悕
- * @param gid GID
- * @param geom 绌洪棿浣嶇疆
+ * @param tab 琛ㄥ悕
+ * @param gid GID
+ * @param wkt WKT
* @return 褰卞搷琛屾暟
*/
- @Update("update ${tab} set geom = ST_GeomFromText('${geom}') where gid = #{gid}")
- public Integer updateGeom(@Param("tab") String tab, @Param("gid") Integer gid, @Param("geom") String geom);
+ @Update("update ${tab} set geom = ST_GeomFromText('${wkt}') where gid = #{gid}")
+ public Integer updateGeom(@Param("tab") String tab, @Param("gid") Integer gid, @Param("wkt") String wkt);
}
--
Gitblit v1.9.3