From 18003d8679f2235ac232d9330deeb96c5375535d Mon Sep 17 00:00:00 2001 From: xing <xingjs@qq.com> Date: 星期日, 26 二月 2023 13:08:43 +0800 Subject: [PATCH] 20230226@xingjs@提交官网一张图相关内容接口(优化完善sql--修改数据存储sql) --- src/main/resources/mapper/show/OneMapMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml index 9c5621e..4d97925 100644 --- a/src/main/resources/mapper/show/OneMapMapper.xml +++ b/src/main/resources/mapper/show/OneMapMapper.xml @@ -40,7 +40,7 @@ <!-- 鏁版嵁缁熻 鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟 select type,count(*),count(sizes) from lf.sys_meta group by type; --> <select id="fileFormatCount" resultType="java.util.Map"> - select type,count(type) AS number,count(sizes) AS capacity from lf.sys_meta group by type; + select type,count(type) AS number,sum(sizes) AS capacity from lf.sys_meta group by type; </select> <!-- 鏁版嵁缁熻 鏁版嵁鐢宠 select * from lf.sys_apply a inner join lf.sys_user b on a.userid = b.id; --> -- Gitblit v1.9.3