From 9e3fbec7b77dd4d42ed7976b16f2727276313ae3 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期日, 26 二月 2023 13:27:08 +0800
Subject: [PATCH] 20230226@xingjs@提交官网一张图相关内容接口(新增服务大类统计、数据服务类型统计)
---
src/main/java/com/lf/server/controller/show/OneMapController.java | 25 ++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 14 +++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 20 ++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 30 +++++++++++++++
4 files changed, 89 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 03d6951..8c23851 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -102,6 +102,31 @@
}
/**
+ * 鏁版嵁澶х被缁熻
+ * Statistics of large categories of data
+ */
+ @SysLog()
+ @ApiOperation(value = "鏁版嵁澶х被缁熻")
+ @GetMapping("/countLargeCategories")
+ public ResponseMsg<Object> statisticalDataCategories() {
+ List<String> resList = aMapOfPipelineService.statisticalDataCategories();
+ return success(resList);
+ }
+
+ /**
+ * 鏁版嵁鏈嶅姟绫诲瀷缁熻
+ * Data service type statistics
+ * */
+ @SysLog()
+ @ApiOperation(value = "鏁版嵁鏈嶅姟绫诲瀷缁熻")
+ @GetMapping("/countDataServiceType")
+ public ResponseMsg<Object> statisticalDataServiceType() {
+ List<String> resList = aMapOfPipelineService.statisticalDataServiceType();
+ return success(resList);
+ }
+
+
+ /**
* 鏁版嵁缁熻
* 鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟
* File format dimension
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 bbc1632..dc8a847 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -51,6 +51,20 @@
public List<String> dataStorageCount();
/**
+ * 缁熻鏁版嵁绫诲埆
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> statisticalDataCategories();
+
+ /**
+ * 缁熻鏁版嵁鏈嶅姟绫诲瀷
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> statisticalDataServiceType();
+
+ /**
* 鏂囦欢鏍煎紡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 09a4dda..c099f85 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -83,6 +83,26 @@
}
/**
+ * 缁熻鏁版嵁绫诲埆
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> statisticalDataCategories() {
+ return aMapOfPipelineMapper.statisticalDataCategories();
+ }
+
+ /**
+ * 缁熻鏁版嵁鏈嶅姟绫诲瀷
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> statisticalDataServiceType() {
+ return aMapOfPipelineMapper.statisticalDataServiceType();
+ }
+
+ /**
* 鏂囦欢鏍煎紡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 4d97925..3199f94 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -38,6 +38,36 @@
from lf.sys_dir a where id > 1 and pid = 0;
</select>
+ <!-- 鏁版嵁澶х被缁熻 -->
+ <select id="statisticalDataCategories" 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 name IN ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠＄悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�')
+ GROUP BY name
+ ORDER BY name;
+ </select>
+
+
+ <!-- 缁熻鏁版嵁鏈嶅姟绫诲瀷 -->
+ <select id="statisticalDataServiceType" resultType="java.util.Map">
+ SELECT COUNT(*),TYPE FROM lf.sys_serve_log GROUP BY TYPE;
+ </select>
+
<!-- 鏁版嵁缁熻 鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟 select type,count(*),count(sizes) from lf.sys_meta group by type; -->
<select id="fileFormatCount" resultType="java.util.Map">
select type,count(type) AS number,sum(sizes) AS capacity from lf.sys_meta group by type;
--
Gitblit v1.9.3