From 209abd30cffae7f3419c7046dbd4d696717600d0 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期一, 27 二月 2023 18:06:37 +0800
Subject: [PATCH] 20230227@xingjs@提交官网一张图相关内容接口(专题展示和工程展示相关模块内容)
---
src/main/java/com/lf/server/controller/show/OneMapController.java | 27 +++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 16 ++++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 21 ++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 18 +++++++++
4 files changed, 82 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 916ac9b..3a10735 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -292,6 +292,33 @@
List<String> resList = aMapOfPipelineService.selectProjectInfo(projectName);
return success(resList);
}
+ /**
+ * 椤圭洰鏂囦欢鍒楄〃鏌ヨ
+ * Project file list query
+ */
+ @SysLog()
+ @ApiOperation(value = "椤圭洰鏂囦欢鍒楄〃鏌ヨ")
+ @GetMapping("/selectProjectFileList")
+ public ResponseMsg<Object> selectProjectFileList() {
+ List<String> resList = aMapOfPipelineService.selectProjectFileList();
+ return success(resList);
+ }
+
+ /**
+ * 鍗曚釜椤圭洰瀛樺偍閲�
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link ResponseMsg}<{@link Object}>
+ */
+ @SysLog()
+ @ApiOperation(value = "鍗曚釜椤圭洰瀛樺偍閲�")
+ @GetMapping("/countProjectStorage")
+ public ResponseMsg<Object> countProjectStorage(@RequestParam("projectCode") String projectCode) {
+ List<String> resList = aMapOfPipelineService.countProjectStorage(projectCode);
+ 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 8230b5f..d5d073d 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -168,4 +168,20 @@
*/
public List<String> selectProjectInfo(String projectName);
+ /**
+ * 閫夋嫨椤圭洰鏂囦欢鍒楄〃
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> selectProjectFileList();
+
+ /**
+ * 璁＄畻瀛樺偍椤圭洰
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> countProjectStorage(String projectCode);
+
+
}
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 adf26d8..17b291f 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -286,4 +286,25 @@
return aMapOfPipelineMapper.selectProjectInfo(projectName);
}
+ /**
+ * 閫夋嫨椤圭洰鏂囦欢鍒楄〃
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> selectProjectFileList() {
+ return aMapOfPipelineMapper.selectProjectFileList();
+ }
+
+ /**
+ * 璁＄畻瀛樺偍椤圭洰
+ *
+ * @param projectCode 椤圭洰浠ｇ爜
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> countProjectStorage(String projectCode) {
+ return aMapOfPipelineMapper.countProjectStorage(projectCode);
+ }
+
}
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index ce90215..3da41cc 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -198,6 +198,24 @@
AND PROJNAME IS NOT NULL ;
</select>
+ <!-- 鏌ヨ椤圭洰鏂囦欢鍒楄〃 -->
+ <select id="selectProjectFileList" resultType="java.util.Map">
+ SELECT name,code FROM lf.sys_dir
+ WHERE pid = 0
+ ORDER BY code;
+ </select>
+
+ <select id="countProjectStorage" resultType="java.util.Map">
+ select name,
+ (select count(b.id) from lf.sys_meta b where dircode similar to '(' || (select string_agg(code, '|') from lf.sys_dir c where c.name = a.name) || ')%') "count",
+ (select coalesce(sum(b.sizes), 0) from lf.sys_meta b where dircode similar to '(' || (select string_agg(code, '|') from lf.sys_dir c where c.name = a.name) || ')%') "sizes"
+ from lf.sys_dir a
+ where code like '${projectCode}%' and name in ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
+ group by name
+ order by name;
+ </select>
+
+
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3