From 6f3576aefe5b73487b18f15070b385e11d366c0a Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 28 二月 2023 10:56:24 +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 | 12 ++++++++++++
4 files changed, 41 insertions(+), 0 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 549d1a7..ab8b03e 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -290,6 +290,18 @@
return success(resList);
}
+ /**
+ * 缁熻鍏ㄥ浗绔欏満搴ф暟
+ * Number of station seats nationwide
+ */
+ @SysLog()
+ @ApiOperation(value = "鍏ㄥ浗绔欏満搴ф暟銆侀榾瀹ゃ�佺閬撴暟绛�")
+ @GetMapping("/countZhPipeStations")
+ public ResponseMsg<Object> countZhPipeStations() {
+ List<String> resList = aMapOfPipelineService.countZhPipeStations();
+ return success(resList);
+ }
+
//============[宸ョ▼灞曠ず Engineering Showcase]==================
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 51611db..725bd75 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -167,6 +167,13 @@
public List<String> countZhPipeMapLenByMed();
/**
+ * 鍏ㄥ浗绔欏満搴ф暟
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countZhPipeStations();
+
+ /**
* 閫夋嫨椤圭洰淇℃伅
* 鏌ヨ椤圭洰淇℃伅
*
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 49ea90c..c2ac9e7 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -285,6 +285,16 @@
}
/**
+ * 鍏ㄥ浗绔欏満搴ф暟
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countZhPipeStations() {
+ return aMapOfPipelineMapper.countZhPipeStations();
+ }
+
+ /**
* 閫夋嫨椤圭洰淇℃伅
* 鏌ヨ椤圭洰淇℃伅
*
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 56bbb7e..67de5d7 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -190,6 +190,18 @@
SELECT medium AS type,count(*) AS count,sum(length)AS length FROM bs.m_pipesegment GROUP BY medium ;
</select>
+ <!-- 缁熻鍏ㄥ浗绔欏満搴ф暟 -->
+ <select id="countZhPipeStations" resultType="java.util.Map">
+ select
+ case medium when 'CPY' then '鎴愬搧娌�' when 'TRQ' then '澶╃劧姘�' when 'YY' then '鍘熸补' else '鍏跺畠' end "杈撻�佷粙璐�",
+ round(sum(st_length(geom))::numeric, 2) "鎬婚噷绋�",
+ count(*) "绠￠亾鏁伴噺",
+ (select count(*) from bs.m_sitepoint b inner join bs.m_pipeline c on b.pipename = c.pipename where c.medium = a.medium) "绔欏満鏁伴噺",
+ (select count(*) from bs.m_valvehousepoint d inner join bs.m_pipeline e on d.pipename = e.pipename where e.medium = a.medium) "闃�瀹ゆ暟閲�"
+ from bs.m_pipeline a
+ group by medium;
+ </select>
+
<!-- 鏌ヨ椤圭洰淇℃伅 select PROJNAME,* from bs.bs_project WHERE PROJNAME LIKE '${projectName}%' AND PROJNAME IS NOT NULL ; -->
<select id="selectProjectInfo" resultType="java.util.Map">
select PROJNAME,* from bs.bs_project WHERE PROJNAME LIKE '${projectName}%' AND PROJNAME IS NOT NULL ;
--
Gitblit v1.9.3