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