From 22ff049544a5f17fb954b1395233ab0acafa912f Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 28 二月 2023 11:52:28 +0800
Subject: [PATCH] 20230228@xingjs@提交官网一张图相关内容接口(专题展示和工程展示相关模块内容)
---
src/main/java/com/lf/server/controller/show/OneMapController.java | 12 ++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 7 +++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 10 ++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 9 +++++++--
4 files changed, 36 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/show/OneMapController.java b/src/main/java/com/lf/server/controller/show/OneMapController.java
index ab8b03e..d09bb45 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -85,6 +85,18 @@
return success(resList);
}
+ /**
+ * 鍏ㄥ浗缁村害-鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟
+ * Count the number of different items according to their type
+ */
+ @SysLog()
+ @ApiOperation(value = "鍏ㄥ浗缁村害-鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟")
+ @GetMapping("/countProjectTypeNumber")
+ public ResponseMsg<Object> countProjectTypeNumber() {
+ List<String> resList = aMapOfPipelineService.countProjectTypeNumber();
+ return success(resList);
+ }
+
//============[鏁版嵁缁熻 data Statistics]==================
diff --git a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
index c1c0203..a970e71 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -45,6 +45,13 @@
public List<String> provinceDimensionCount();
/**
+ * 鍏ㄥ浗缁村害-鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countProjectTypeNumber();
+
+ /**
* 鏁版嵁瀛樺偍conut
*
* @return {@link List}<{@link String}>
diff --git a/src/main/java/com/lf/server/service/show/OneMapService.java b/src/main/java/com/lf/server/service/show/OneMapService.java
index bed989d..baae83a 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -73,6 +73,16 @@
}
/**
+ * 鍏ㄥ浗缁村害-鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectTypeNumber() {
+ return aMapOfPipelineMapper.countProjectTypeNumber();
+ }
+
+ /**
* 鏁版嵁瀛樺偍conut
*
* @return {@link List}<{@link String}>
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index e3dcdc1..be484cb 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -21,16 +21,21 @@
select a.*,st_astext(geom) AS wkt from bs.bs_project a;
</select>
- <!-- 椤圭洰绫诲埆 鍥藉缁村害-鏁伴噺 -->
+ <!-- 鍏ㄧ悆 椤圭洰绫诲埆 鍥藉缁村害-鏁伴噺 -->
<select id="countryDimensionCount" resultType="java.util.Map">
select country,count(*) from bs.bs_project group by country;
</select>
- <!-- 椤圭洰绫诲埆 鐪佺淮搴�-鏁伴噺 -->
+ <!-- 鍏ㄥ浗 椤圭洰绫诲埆 鐪佺淮搴�-鏁伴噺 -->
<select id="provinceDimensionCount" resultType="java.util.Map">
select province,count(*) from bs.bs_project where country like '%涓浗%' group by province ;
</select>
+ <!-- 鍏ㄥ浗 鎸夌収椤硅嚜绫诲瀷缁熻涓嶅悓椤圭洰涓暟 -->
+ <select id="countProjectTypeNumber" resultType="java.util.Map">
+ select projtype,count(*) from bs.bs_project where country like '%涓浗%' group by projtype ;
+ </select>
+
<!-- 鏁版嵁缁熻 鏁版嵁瀛樺偍 -->
<select id="dataStorageCount" resultType="java.util.Map">
select name "鍚嶇О", (select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "鏂囦欢鏁�",
--
Gitblit v1.9.3