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