From 13301ea21fe2a1c5878050780d6bd946871e27c3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 12 六月 2023 10:16:30 +0800
Subject: [PATCH] 数据统计修改数据量统计接口，添加按文件类型统计、按项目统计数据接口

---
 data/update.sql |    8 +++++++-
 1 files changed, 7 insertions(+), 1 deletions(-)

diff --git a/data/update.sql b/data/update.sql
index 0fce38e..c2adf2f 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -225,8 +225,13 @@
 	(select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "鏁伴噺(MB)"
 from lf.sys_dir a where id > 1 and pid = 0;
 
--- 鎸夋枃浠剁被鍨嬬粺璁�
+select name "m1", (select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "sizes",
+	(select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "count"	
+from lf.sys_dir a where pid = 0 order by a.code;
+
+-- 鎸夋枃浠剁被鍨嬬粺璁� *
 select type,count(*),sum(sizes) from lf.sys_meta group by type;
+select type "m1", cast(sum(sizes) as decimal(18, 3)) "sizes", count(*) "count" from lf.sys_meta group by type order by type;
 
 -- type绫诲瀷锛�1-Shp鏂囦欢锛�2-涓撻鍥撅紝3-鍏冩暟鎹紝4-涓氬姟鏁版嵁锛�5-绠￠亾鍒嗘瀽锛�6-缁熻鎶ュ憡
 select * from lf.sys_download;
@@ -314,6 +319,7 @@
 from lf.sys_dir d
 where pid = 0
 order by d.code;
+
 --------------------------------------------------------- 02.閫掑綊鏌ヨ
 with recursive rs as(
   select * from lf.sys_menu where cn_name='绠￠亾鍩虹澶ф暟鎹钩鍙�'

--
Gitblit v1.9.3