From 5953543e954a3f7bf0e0a03df0f532fc2cca2efb Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 28 二月 2023 14:56:41 +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                   |   17 +++++++++++++++++
 4 files changed, 46 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 39bb65e..c42dfad 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -314,6 +314,18 @@
         return success(resList);
     }
 
+    /**
+     * 鎸夐」鐩粺璁¢」鐩瓨鍌ㄩ噺
+     * Count the amount of project storage by project
+     */
+    @SysLog()
+    @ApiOperation(value = "鎸夐」鐩粺璁¢」鐩瓨鍌ㄩ噺")
+    @GetMapping("/countStorageByProject")
+    public ResponseMsg<Object> countStorageByProject() {
+        List<String> resList = aMapOfPipelineService.countStorageByProject();
+        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 852e2ff..8668d3b 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -181,6 +181,13 @@
     public List<String> countZhPipeStations();
 
     /**
+     * 鎸夐」鐩粺璁¢」鐩瓨鍌ㄩ噺
+     *
+     * @return {@link List}<{@link String}>
+     */
+    public List<String> countStorageByProject();
+
+    /**
      * 閫夋嫨椤圭洰淇℃伅
      * 鏌ヨ椤圭洰淇℃伅
      *
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 c201afc..6b9ef8e 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -305,6 +305,16 @@
     }
 
     /**
+     * 鎸夐」鐩粺璁¢」鐩瓨鍌ㄩ噺
+     *
+     * @return {@link List}<{@link String}>
+     */
+    @Override
+    public List<String> countStorageByProject() {
+        return aMapOfPipelineMapper.countStorageByProject();
+    }
+
+    /**
      * 閫夋嫨椤圭洰淇℃伅
      * 鏌ヨ椤圭洰淇℃伅
      *
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 08a7d80..d314114 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -207,6 +207,23 @@
         group by medium;
     </select>
 
+    <!--  鎸夐」鐩粺璁¢」鐩瓨鍌ㄩ噺  -->
+    <select id="countStorageByProject" resultType="java.util.Map">
+        with rs as (
+            select a.dircode, c.dcount, c.sizes
+            from lf.sys_meta a
+                     inner join lf.sys_meta_down b on a.id = b.metaid
+                     inner join lf.sys_download c on b.downid = c.id
+        )
+        select
+            d.name "椤圭洰鍚嶇О",
+            (select count(*) from rs where rs.dircode like d.code || '%') "涓嬭浇涓暟",
+            (select coalesce(sum(rs.dcount), 0) from rs where rs.dircode like d.code || '%') "涓嬭浇鏁伴噺",
+            (select round(coalesce(sum(rs.dcount * rs.sizes), 0)::numeric, 3) from rs where rs.dircode like d.code || '%') "鏁伴噺鎬婚噺(MB)"
+        from lf.sys_dir d
+        where pid = 0 order by d.code;
+    </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