From 5af8ff1fbdc7183bf611f1971edf1f6e8f68c961 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 11 四月 2023 13:35:47 +0800
Subject: [PATCH] 1
---
src/main/java/com/terra/coal/mapper/MainMapper.java | 15 ++++++++++-----
1 files changed, 10 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/terra/coal/mapper/MainMapper.java b/src/main/java/com/terra/coal/mapper/MainMapper.java
index 80505a4..e0f59f9 100644
--- a/src/main/java/com/terra/coal/mapper/MainMapper.java
+++ b/src/main/java/com/terra/coal/mapper/MainMapper.java
@@ -2,6 +2,8 @@
import com.terra.coal.entity.CountEntity;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import java.util.List;
@@ -16,10 +18,13 @@
/**
* 鏍规嵁鑼冨洿缁熻
*
- * @param wkt
- * @param z
- * @param deep
- * @return
+ * @param top 椤堕珮
+ * @param bottom 搴曢珮
+ * @param wkt WKT
+ * @return CountEntity闆嗗悎
*/
- public List<CountEntity> countByRange(String wkt, double z, double deep);
+ @Select("select ctype, sum(volume) \"volume\", sum(coal_prod) \"coal_prod\", sum(gangue_prod) \"gangue_prod\", 0 \"soil_prod\" from public.coal2000 " +
+ "where (top between #{bottom} and #{top} or bottom between #{bottom} and #{top}) and ST_Intersects(geom, ST_PolygonFromText(#{wkt}, 4490)) " +
+ "group by ctype order by ctype")
+ public List<CountEntity> countByRange(@Param("top") Double top, @Param("bottom") Double bottom, @Param("wkt") String wkt);
}
--
Gitblit v1.9.3