From 39e35df1c928a6dbceb216a315f5238b8839af8e Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 10 二月 2023 15:11:12 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/entity/ctrl/CountEntity.java | 60 ++++++++++++++++++++++++++++++
data/ts.sql | 24 +++++++++--
src/main/resources/mapper/sys/ReportMapper.xml | 24 ++++++++++++
data/db_tab.sql | 2 +
4 files changed, 105 insertions(+), 5 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 7eb90a9..aa54ff7 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1139,6 +1139,8 @@
comment on column lf.sys_serve_log.create_user is '璁块棶浜篒D';
comment on column lf.sys_serve_log.create_time is '璁块棶鏃堕棿';
comment on column lf.sys_serve_log.bak is '澶囨敞';
+/* insert into lf.sys_serve_log (resid,name,type,url) values (1,'鍏ㄥ浗褰卞儚鍥�','01','http://192.168.20.205/LFData/2d/tiles/img/{z}/{x}/{y}.png');
+ insert into lf.sys_serve_log (resid,name,type,url) values (2,'鍏ㄥ浗鐭㈤噺鍥�','02','http://192.168.20.205/LFData/2d/tiles/vec/{z}/{x}/{y}.png'); */
select * from lf.sys_serve_log;
----------------------------------------------------------------------------------------------------- vacuum analyze md.md_zxcg;
diff --git a/data/ts.sql b/data/ts.sql
index 191b43c..3dfba03 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -119,10 +119,8 @@
select * from lf.sys_dict where field='gid';
select field,type,count(*) from lf.sys_dict where field='gid' group by field,type;
update lf.sys_dict set type='integer' where field='updateuser';
-
select * from lf.sys_layer;
alter sequence lf.sys_layer_id_seq restart with 1;
-select * from lf.sys_dict where ns='md';
select * from lf.sys_menu where position('http:' in url)>0;
select * from bd.b_hydrogeology_attach limit 1;
@@ -130,11 +128,27 @@
select * from lf.sys_serve_log;
select * from lf.sys_meta;
-select * from lf.sys_operate order by id limit 20;
+select * from lf.sys_operate order by id desc limit 20;
-select modular1,modular2,count(*) from lf.sys_operate group by modular1,modular2 order by modular1 desc,modular2;
-select type from lf.sys_operate group by type
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/src/main/java/com/lf/server/entity/ctrl/CountEntity.java b/src/main/java/com/lf/server/entity/ctrl/CountEntity.java
new file mode 100644
index 0000000..e40ecf5
--- /dev/null
+++ b/src/main/java/com/lf/server/entity/ctrl/CountEntity.java
@@ -0,0 +1,60 @@
+package com.lf.server.entity.ctrl;
+
+/**
+ * 缁熻瀹炰綋绫�
+ * @author WWW
+ */
+public class CountEntity {
+ private String m1;
+
+ private String m2;
+
+ private String m3;
+
+ private Long count;
+
+ private Double sizes;
+
+ public CountEntity() {
+ }
+
+ public String getM1() {
+ return m1;
+ }
+
+ public void setM1(String m1) {
+ this.m1 = m1;
+ }
+
+ public String getM2() {
+ return m2;
+ }
+
+ public void setM2(String m2) {
+ this.m2 = m2;
+ }
+
+ public String getM3() {
+ return m3;
+ }
+
+ public void setM3(String m3) {
+ this.m3 = m3;
+ }
+
+ public Long getCount() {
+ return count;
+ }
+
+ public void setCount(Long count) {
+ this.count = count;
+ }
+
+ public Double getSizes() {
+ return sizes;
+ }
+
+ public void setSizes(Double sizes) {
+ this.sizes = sizes;
+ }
+}
diff --git a/src/main/resources/mapper/sys/ReportMapper.xml b/src/main/resources/mapper/sys/ReportMapper.xml
index 4cb6c5c..40b56ce 100644
--- a/src/main/resources/mapper/sys/ReportMapper.xml
+++ b/src/main/resources/mapper/sys/ReportMapper.xml
@@ -71,4 +71,28 @@
where id = #{item.id}
</foreach>
</update>
+
+ <!-- 鏁版嵁閲忕粺璁� -->
+ <select id="countSizes" resultType="com.lf.server.entity.ctrl.CountEntity">
+ select fn_rec_query(depid, 'dep') "m1" , count(sizes) "sizes"
+ from lf.sys_meta
+ group by depid
+ order by depid;
+ </select>
+
+ <!-- 鏈嶅姟璋冪敤閲忕粺璁� -->
+ <select id="">
+ select name "m1", count(*) "count"
+ from lf.sys_serve_log
+ group by name
+ order by name;
+ </select>
+
+ <!-- 鐢ㄦ埛娴侀噺缁熻 -->
+ <select id="countOperate" resultType="com.lf.server.entity.ctrl.CountEntity">
+ select modular1 "m1", modular2 "m2", count(*) "count"
+ from lf.sys_operate
+ group by modular1,modular2
+ order by modular1 desc,modular2;
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3