From ce8598cd6c6095f22bd867564c7ca7a77b3ca5bc Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 14 十月 2022 13:40:01 +0800 Subject: [PATCH] 1 --- data/db_fn.sql | 17 ++++++++++++++++- data/db_tab.sql | 2 +- 说明.txt | 4 ++-- 3 files changed, 19 insertions(+), 4 deletions(-) diff --git a/data/db_fn.sql b/data/db_fn.sql index 1efa683..4e6062c 100644 --- a/data/db_fn.sql +++ b/data/db_fn.sql @@ -152,6 +152,10 @@ alter table lf.sys_role_res add constraint idx_unique_role_res unique (roleid,resid); -- 鑱斿悎鍞竴绱㈠紩 insert into lf.sys_role_res (roleid,resid) values (1,1); select * from lf.sys_role_res; + +alter table lf.sys_role_menu_auth add constraint idx_unique_role_menu_auth unique (roleid,menu_auth_id); -- 鑱斿悎鍞竴绱㈠紩 +insert into lf.sys_role_menu_auth (roleid,menu_auth_id) values (1,1); +select * from lf.sys_role_menu_auth; ----------------------------------------------------------------------------------------------------- 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')); @@ -172,9 +176,20 @@ ------------------------------------------------------------ select * from lf.sys_res; select * from lf.sys_role; -select * from lf.sys_role_res; +select * from lf.sys_role_res;` ` select a.* from lf.sys_res a where not exists (select b.id from lf.sys_role_res b where b.resid = a.id and b.roleid = 1); + +select * from lf.sys_role; +select * from lf.sys_menu; +select * from lf.sys_auth; +select * from lf.sys_menu_auth; +select * from lf.sys_role_menu_auth; + +select a.*,c.name from lf.sys_menu_auth a inner join lf.sys_auth c on a.authid = c.id +where not exists (select b.id from lf.sys_role_menu_auth b where b.menu_auth_id = a.id and b.roleid = 1) and a.menuid = 1; + +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 ----------------------------------------------------------------------------------------------------- diff --git a/data/db_tab.sql b/data/db_tab.sql index 726b7da..7185ed6 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -502,7 +502,7 @@ comment on column lf.sys_menu_auth.create_time is '鍒涘缓鏃堕棿'; comment on column lf.sys_menu_auth.update_user is '鏇存柊浜篒D'; comment on column lf.sys_menu_auth.update_time is '鏇存柊鏃堕棿'; ---insert into lf.sys_menu_auth (menuid,authid) values (1,1); +--insert into lf.sys_menu_auth (menuid,authid) values (1,1),(1,2),(1,3),(1,4),(1,5); select * from lf.sys_menu_auth; ----------------------------------------------------------------------------------------------------- 14.瑙掕壊-鑿滃崟-鏉冮檺琛� diff --git "a/\350\257\264\346\230\216.txt" "b/\350\257\264\346\230\216.txt" index 9140dc1..882d9c3 100644 --- "a/\350\257\264\346\230\216.txt" +++ "b/\350\257\264\346\230\216.txt" @@ -1,6 +1,8 @@ 1.淇敼鑿滃崟銆佹暟鎹洰褰曘�佸崟浣嶇殑xls鏁版嵁锛岀紪鍐欓�掑綊鏌ヨSQL 2.鐧诲綍鏃堕獙璇佷娇鐢∕D5+Salt瀵嗙爜 3.鐧诲綍鏃剁殑鐢ㄦ埛鍚嶅拰瀵嗙爜浣跨敤RSA鍔犲瘑銆佽В瀵� +4.WebSocket鏈嶅姟 +5.璧勬簮瀹炴椂鐩戞帶锛圕PU淇℃伅+鍐呭瓨淇℃伅+鍦ㄧ嚎鐢ㄦ埛+璧勬簮鐘舵�侊級 3.淇敼鐢ㄦ埛瀵嗙爜鏃朵娇鐢∕D5+Salt瀵嗙爜 4.瑙ｅ喅Swagger-UI鏃犳硶浼犻�扖ookie淇℃伅 @@ -8,8 +10,6 @@ 7.鍚庡彴鏈嶅姟璁块棶娣诲姞鐧诲綍楠岃瘉鎷︽埅鍣� 8.寮�鍙戝垏闈㈡棩蹇楀姛鑳� 9.鏁版嵁搴撶洃鎺�(Druid Monitor)+鑷姩鐧诲綍 -10.WebSocket鏈嶅姟 -11.璧勬簮瀹炴椂鐩戞帶锛圕PU淇℃伅+鍐呭瓨淇℃伅+鍦ㄧ嚎鐢ㄦ埛+璧勬簮鐘舵�侊級 12.涓嬭浇鏂囦欢骞惰缃甅IME绫诲瀷 13.涓婁紶鏂囦欢锛坈ommons-fileupload锛� * ---------------------------------------------------------------------------------------------------- -- Gitblit v1.9.3