From eaa5a3054d6158e980edc35c42a17ddcf2d575a2 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期二, 28 二月 2023 10:05:01 +0800
Subject: [PATCH] 20230228@xingjs@提交官网一张图相关内容接口(专题展示和工程展示相关模块内容)
---
src/main/resources/mapper/show/OneMapMapper.xml | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index cc86967..7de3e6e 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -217,13 +217,13 @@
<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 a.type,
+ count(a.type) AS number,
+ count(a.sizes) AS capacity
+ FROM lf.sys_meta a
+ INNER JOIN lf.sys_dir b ON a.dircode = b.code
+ WHERE a.dircode LIKE '${projectCode}%'
+ GROUP BY a.type;
</select>
<!-- 鍗曚釜椤圭洰鐨勪笅杞戒釜鏁般�佷笅杞芥鏁板拰鏁版嵁閲�-->
--
Gitblit v1.9.3