From e8a5942bd0ac1188281cda29c882bb0e107896dc Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 13 十月 2022 16:56:32 +0800
Subject: [PATCH] 1

---
 data/db_fn.sql |   18 +++++++-----------
 1 files changed, 7 insertions(+), 11 deletions(-)

diff --git a/data/db_fn.sql b/data/db_fn.sql
index 23f7a00..d5a24db 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -150,25 +150,21 @@
 ----------------------------------------------------------------------------------------------------- 
 select a.*,fn_uname(a.create_user) createUserName,fn_uname(a.update_user) updateUserName from lf.sys_blacklist a order by a.id;
 select * from lf.sys_user a where uname like '%' and a.depid=ANY(fn_rec_array(1,'dep'));
-
 select * from lf.sys_user a left join lf.sys_role_user b on a.id=b.userid
-where exist 
 
-select * from lf.sys_user a where not exists (select id from lf.sys_role_user b where b.userid = a.id and b.roleid = 1)
+select a.* from lf.sys_user a where not exists (select b.id from lf.sys_role_user b where b.userid = a.id and b.roleid = 1)
 and uname like '%瀹�%' and a.depid = ANY(fn_rec_array(1, 'dep'))
 order by a.id limit 10 offset 0;
 
-select a.*,fn_uname(a.userid) uname from lf.sys_role_user a order by a.id
-select a.*,fn_uname(a.userid) uname from lf.sys_role_user a where a.id = 1
-
 select a.*,fn_rec_query(a.depid, 'dep') depName,fn_rec_query(a.dirid, 'dir') dirName from lf.sys_style a;
-
-select * from lf.sys_auth order by id;
+------------------------------------------------------------
+select * from lf.sys_auth;
+select * from lf.sys_menu;
 select * from lf.sys_menu_auth;
 
-select * from lf.sys_args;
-
-
+select * from lf.sys_auth a left join lf.sys_menu;
+select a.* from lf.sys_auth a where not exists (select b.id from lf.sys_menu_auth b where b.authid=a.id and b.menuid=1);
+----------------------------------------------------------------------------------------------------- 
 
 
 

--
Gitblit v1.9.3