From b94c87e3c909c549edafa6f74eca4a675ffbc383 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 28 二月 2023 09:55:55 +0800
Subject: [PATCH] 20230228@xingjs@提交官网一张图相关内容接口(专题展示和工程展示相关模块内容)

---
 src/main/java/com/lf/server/controller/show/OneMapController.java |   30 +++++++++++++++
 src/main/java/com/lf/server/mapper/show/OneMapMapper.java         |   16 ++++++++
 src/main/java/com/lf/server/service/show/OneMapService.java       |   22 +++++++++++
 src/main/resources/mapper/show/OneMapMapper.xml                   |   19 +++++++++
 4 files changed, 87 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 3a10735..7cd65fd 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -318,6 +318,36 @@
         return success(resList);
     }
 
+    /**
+     * 鍗曚釜椤圭洰鏂囦欢鏁伴噺
+     * The number of individual project files
+     *
+     * @param projectCode 椤圭洰浠g爜
+     * @return {@link ResponseMsg}<{@link Object}>
+     */
+    @SysLog()
+    @ApiOperation(value = "鍗曚釜椤圭洰瀛樺偍閲�")
+    @GetMapping("/countProjectType")
+    public ResponseMsg<Object> countProjectType(@RequestParam("projectCode") String projectCode) {
+        List<String> resList = aMapOfPipelineService.countProjectType(projectCode);
+        return success(resList);
+    }
+
+
+    /**
+     * 缁熻椤圭洰涓�
+     * 鍗曚釜椤圭洰涓嬭浇閲�
+     *
+     * @param projectCode 椤圭洰浠g爜
+     * @return {@link ResponseMsg}<{@link Object}>
+     */
+    @SysLog()
+    @ApiOperation(value = "鍗曚釜椤圭洰涓嬭浇閲�")
+    @GetMapping("/countProjectDown")
+    public ResponseMsg<Object> countProjectDown(@RequestParam("projectCode") String projectCode) {
+        List<String> resList = aMapOfPipelineService.countProjectDown(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 d5d073d..c39e057 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -183,5 +183,21 @@
      */
     public List<String> countProjectStorage(String projectCode);
 
+    /**
+     * 缁熻椤圭洰绫诲瀷
+     *
+     * @param projectCode 椤圭洰浠g爜
+     * @return {@link List}<{@link String}>
+     */
+    public List<String> countProjectType(String projectCode);
+
+    /**
+     * 缁熻椤圭洰涓�
+     *
+     * @param projectCode 椤圭洰浠g爜
+     * @return {@link List}<{@link String}>
+     */
+    public List<String> countProjectDown(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 17b291f..121563d 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -307,4 +307,26 @@
         return aMapOfPipelineMapper.countProjectStorage(projectCode);
     }
 
+    /**
+     * 缁熻椤圭洰绫诲瀷
+     *
+     * @param projectCode 椤圭洰浠g爜
+     * @return {@link List}<{@link String}>
+     */
+    @Override
+    public List<String> countProjectType(String projectCode) {
+        return aMapOfPipelineMapper.countProjectType(projectCode);
+    }
+
+    /**
+     * 缁熻椤圭洰涓�
+     *
+     * @param projectCode 椤圭洰浠g爜
+     * @return {@link List}<{@link String}>
+     */
+    @Override
+    public List<String> countProjectDown(String projectCode) {
+        return aMapOfPipelineMapper.countProjectDown(projectCode);
+    }
+
 }
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 3da41cc..cc86967 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -216,6 +216,25 @@
     </select>
 
 
+    <select id="countProjectType" 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>
+
+    <!--  鍗曚釜椤圭洰鐨勪笅杞戒釜鏁般�佷笅杞芥鏁板拰鏁版嵁閲�-->
+    <select id="countProjectDown" resultType="java.util.Map">
+        select count(*) "number", sum(c.dcount) "count", sum(c.sizes) "size"
+        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
+        where dircode like '${projectCode}%';
+    </select>
+
+
 
 
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.3