Files
usdt/sql/rent_statement_export_menu.sql

15 lines
1.2 KiB
SQL

-- 租赁用户/供应商本人账单导出权限。可重复执行;不增加管理员读取他人账户的权限。
-- 在已有租赁工作台菜单下添加按钮,父菜单必须已经部署。
START TRANSACTION;
SET @statement_parent=(SELECT menu_id FROM sys_menu WHERE perms='rent:portal:view' AND menu_type='C' ORDER BY menu_id LIMIT 1);
INSERT INTO sys_menu(menu_name,parent_id,order_num,path,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time)
SELECT '导出本人资金对账单',@statement_parent,30,'#',1,0,'F','0','0','rent:statement:export','#','admin',NOW()
WHERE @statement_parent IS NOT NULL AND NOT EXISTS(SELECT 1 FROM sys_menu WHERE perms='rent:statement:export');
INSERT INTO sys_role_menu(role_id,menu_id)
SELECT r.role_id,m.menu_id FROM sys_role r JOIN sys_menu m ON m.perms='rent:statement:export'
WHERE r.role_key IN ('PROXY_ACCOUNT','PROXY_SUPPLIER') AND r.del_flag='0'
AND NOT EXISTS(SELECT 1 FROM sys_role_menu x WHERE x.role_id=r.role_id AND x.menu_id=m.menu_id);
COMMIT;
-- 若下面结果为空,说明租赁工作台菜单尚不存在;先部署工作台菜单再重新执行本脚本。
SELECT menu_id,menu_name,parent_id,perms FROM sys_menu WHERE perms='rent:statement:export';