From 944096fd50bc101de418c3aa4411801053522b78 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期一, 27 二月 2023 17:21:11 +0800
Subject: [PATCH] 20230227@xingjs@提交官网一张图相关内容接口(专题展示和工程展示相关模块内容)
---
src/main/java/com/lf/server/controller/show/OneMapController.java | 46 ++++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 25 ++++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 33 +++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 21 +++++++
4 files changed, 123 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 09507c2..10a37f0 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -116,7 +116,7 @@
/**
* 鏁版嵁鏈嶅姟绫诲瀷缁熻
* Data service type statistics
- * */
+ */
@SysLog()
@ApiOperation(value = "鏁版嵁鏈嶅姟绫诲瀷缁熻")
@GetMapping("/countDataServiceType")
@@ -128,7 +128,7 @@
/**
* 鐧诲綍娆℃暟缁熻
* Number of logins
- * */
+ */
@SysLog()
@ApiOperation(value = "鐧诲綍娆℃暟缁熻")
@GetMapping("/countLoginNumber")
@@ -252,4 +252,46 @@
}
+ //============[涓撻灞曠ず Thematic presentations]==================
+
+ /**
+ * 鍏ㄧ悆绠＄綉鍥�
+ * Global pipe network map
+ */
+ @SysLog()
+ @ApiOperation(value = "鍏ㄧ悆绠＄綉鍥�")
+ @GetMapping("/countGlobalPipeMap")
+ public ResponseMsg<Object> countGlobalPipeMap() {
+ List<String> resList = aMapOfPipelineService.countGlobalPipeMap();
+ return success(resList);
+ }
+
+ /**
+ * 鍏ㄥ浗绠＄綉鍥�
+ * National pipe network map
+ */
+ @SysLog()
+ @ApiOperation(value = "鍏ㄥ浗绠＄綉鍥�")
+ @GetMapping("/countNationalPipeMap")
+ public ResponseMsg<Object> countNationalPipeMap() {
+ List<String> resList = aMapOfPipelineService.countNationalPipeMap();
+ return success(resList);
+ }
+
+
+ //============[宸ョ▼灞曠ず Engineering Showcase]==================
+
+ /**
+ * 椤圭洰淇℃伅鏌ヨ
+ * Project information query
+ */
+ @SysLog()
+ @ApiOperation(value = "椤圭洰淇℃伅鏌ヨ")
+ @GetMapping("/selectProjectInfo")
+ public ResponseMsg<Object> selectProjectInfo(@RequestParam("projectName") String projectName) {
+ List<String> resList = aMapOfPipelineService.selectProjectInfo(projectName);
+ return success(resList);
+ }
+
+
}
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 6a212e4..8230b5f 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -10,6 +10,7 @@
/**
* 绠＄綉涓�寮犲浘Mapper
+ *
* @author 閭㈤敠鍙�
*/
@Mapper
@@ -143,4 +144,28 @@
* @return {@link List}<{@link String}>
*/
public List<String> queryTableInfo(@Param("tableName") String tableName);
+
+ /**
+ * 璁＄畻鍏ㄧ悆绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countGlobalPipeMap();
+
+ /**
+ * 璁＄畻鍏ㄥ浗绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countNationalPipeMap();
+
+ /**
+ * 閫夋嫨椤圭洰淇℃伅
+ * 鏌ヨ椤圭洰淇℃伅
+ *
+ * @param projectName 椤圭洰鍚嶇О
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> selectProjectInfo(String projectName);
+
}
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 eff91aa..adf26d8 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -253,4 +253,37 @@
public List<String> queryTableInfo(String tableName) {
return aMapOfPipelineMapper.queryTableInfo(tableName);
}
+
+ /**
+ * 璁＄畻鍏ㄧ悆绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countGlobalPipeMap() {
+ return aMapOfPipelineMapper.countGlobalPipeMap();
+ }
+
+ /**
+ * 璁＄畻鍏ㄥ浗绠￠亾鍥�
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countNationalPipeMap() {
+ return aMapOfPipelineMapper.countNationalPipeMap();
+ }
+
+ /**
+ * 閫夋嫨椤圭洰淇℃伅
+ * 鏌ヨ椤圭洰淇℃伅
+ *
+ * @param projectName 椤圭洰鍚嶇О
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> selectProjectInfo(String projectName) {
+ return aMapOfPipelineMapper.selectProjectInfo(projectName);
+ }
+
}
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 1e7222e..faa611c 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -175,7 +175,28 @@
</select>
+ <!-- 缁熻璁＄畻鍏ㄧ悆绠￠亾鍥� -->
+ <select id="countGlobalPipeMap" resultType="java.util.Map">
+ SELECT projname,count(*) AS count FROM bs.m_pipesegment group by projname ;
+ </select>
+ <!-- 缁熻璁＄畻鍏ㄥ浗绠￠亾鍥� -->
+ <select id="countNationalPipeMap" resultType="java.util.Map">
+ SELECT projname,count(*) AS count FROM bs.m_pipesegment group by projname ;
+ </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 ;
+ </select>
+
+ <select id="selectProjectInfo1" resultType="java.util.Map">
+ select PROJNAME,* from bs.bs_project
+ <where>
+ <if test="projname != null and projname != ''"> and projname like concat('%', #{projectName}, '%')</if>
+ </where>
+ AND PROJNAME IS NOT NULL ;
+ </select>
--
Gitblit v1.9.3