From 8cc2cacaa3df7f53bc3f2476c10f9924ef45e6e9 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 21 二月 2023 10:59:59 +0800
Subject: [PATCH] 20230221@xingjs@提交官网一张图相关内容接口
---
src/main/java/com/lf/server/controller/show/OneMapController.java | 37 ++++++++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 16 ++++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 20 ++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 19 +++++++++
4 files changed, 92 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 af0b4dc..c41bf3a 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -138,4 +138,41 @@
}
+ /**
+ * 椤圭洰宸ョ▼灞曠ず
+ * Project engineering display
+ */
+ @SysLog()
+ @ApiOperation(value = "椤圭洰宸ョ▼灞曠ず")
+ @GetMapping("/countProjectDisplay")
+ public ResponseMsg<Object> countProjectDisplay() {
+ List<String> resList = aMapOfPipelineService.countProjectDisplay();
+ return success(resList);
+ }
+
+ /**
+ * 椤圭洰宸ョ▼宸¤
+ * Project inspection tour
+ */
+ @SysLog()
+ @ApiOperation(value = "椤圭洰宸ョ▼宸¤")
+ @GetMapping("/countProjectTour")
+ public ResponseMsg<Object> countProjectTour() {
+ return success("hello! 鎮ㄥ凡缁忔垚鍔熻闂�-椤圭洰宸ョ▼宸¤");
+ }
+
+
+ /**
+ * 椤圭洰宸ョ▼绫诲瀷
+ * Project type
+ */
+ /*@SysLog()
+ @ApiOperation(value = "椤圭洰宸ョ▼绫诲瀷")
+ @GetMapping("/countProjectType")
+ public ResponseMsg<Object> countProjectType() {
+ List<String> resList = aMapOfPipelineService.countProjectType1();
+ 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 31268c7..dbf8201 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -67,5 +67,21 @@
*/
public List<String> dataVisitCount();
+ /**
+ * 缁熻椤圭洰鏄剧ず
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countProjectDisplay();
+
+
+
+ /**
+ * 缁熻椤圭洰绫诲瀷
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countProjectType1();
+ //public List<String> countProjectType2();
}
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 94b25f3..30f0053 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -82,5 +82,25 @@
return aMapOfPipelineMapper.dataVisitCount();
}
+ /**
+ * 缁熻椤圭洰鏄剧ず
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countProjectDisplay() {
+ return aMapOfPipelineMapper.countProjectDisplay();
+ }
+
+
+
+ /**
+ * 缁熻椤圭洰绫诲瀷
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectType1() {
+ return aMapOfPipelineMapper.countProjectType1();
+ }
}
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 6200e9f..2c2aa17 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -48,6 +48,25 @@
select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
</select>
+ <!-- 缁熻椤圭洰鏄剧ず -->
+ <select id="countProjectDisplay" resultType="java.util.Map">
+ select PROJNAME,* from bs.bs_project WHERE PROJNAME IS NOT NULL;
+ </select>
+
+
+ <!-- 缁熻椤圭洰绫诲瀷 1 -->
+ <select id="countProjectType1" resultType="java.util.Map">
+ select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a
+ where name in ('娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�') group by name order by name;
+ </select>
+
+ <!-- 缁熻椤圭洰绫诲瀷 2 -->
+ <select id="countProjectType2" resultType="java.util.Map">
+ select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
+ </select>
+
+
+
--
Gitblit v1.9.3