From 4ddfd502023662f6d25c4be416d88751e206d91a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 25 十月 2022 09:45:30 +0800
Subject: [PATCH] 1
---
data/db_fn.sql | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index a1de102..3af94e6 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -207,6 +207,12 @@
select a.*,b.menuid,c.name from lf.sys_role_menu_auth a inner join lf.sys_menu_auth b on a.menu_auth_id = b.id
inner join lf.sys_auth c on b.authid = c.id where a.roleid = 1 and b.menuid = 1 order by c.id;
+-----------------------------------------------------------------------------------------------------
+update lf.sys_operate set modular1='杩愮淮绠＄悊',modular2='鑿滃崟绠＄悊' where position('/Menu/select' in url)>0 and (modular1 is null or modular2 is null);
+update lf.sys_operate set modular1='杩愮淮绠＄悊',modular2='鐢ㄦ埛绠＄悊' where position('/user/select' in url)>0 and (modular1 is null or modular2 is null);
+update lf.sys_operate set modular1='杩愮淮绠＄悊',modular2='璧勬簮绠＄悊' where position('/res/select' in url)>0 and (modular1 is null or modular2 is null);
+
+delete from lf.sys_operate where modular1 is null or modular2 is null;
-----------------------------------------------------------------------------------------------------
select gid,gb,name,st_astext(a.geom) from bd.dlg_agnp a;
select * from lf.sys_menu;
@@ -243,7 +249,10 @@
inner join lf.sys_auth f on d.authid = f.id
where a.uid = 'admin';
+select modular2,count(*) from lf.sys_operate group by modular2;
+select to_char(optime,'yyyy-mm-dd') as optime,count(*) from lf.sys_login where optime between (select optime - interval '30 day')
+and optime group by to_char(optime, 'yyyy-mm-dd') order by to_char(optime, 'yyyy-mm-dd') asc;
--
Gitblit v1.9.3