75 lines
4.1 KiB
SQL
75 lines
4.1 KiB
SQL
-- Add system online monitor menu and resource.
|
|
-- Idempotent for existing tenants: creates menu/resource rows, binds menu to resource,
|
|
-- and grants super_admin default access. User-group admins can be granted this menu
|
|
-- from the database menu permission management UI.
|
|
|
|
INSERT INTO sys_resource (`parent_id`, `code`, `name`, `description`, `source`, `type`, `sort_index`, `status`, `_tenant_id`, `creator_id`, `creator`, `yn`)
|
|
SELECT 0, 'online_monitor', '在线监控模块', '在线监控模块', 1, 1, 17, 1, t._tenant_id, 0, 'system', 1
|
|
FROM (SELECT DISTINCT `_tenant_id` FROM sys_resource) t
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM sys_resource r
|
|
WHERE r.`_tenant_id` = t.`_tenant_id` AND r.`code` = 'online_monitor' AND r.`yn` = 1
|
|
);
|
|
|
|
INSERT INTO sys_resource (`parent_id`, `code`, `name`, `description`, `source`, `type`, `sort_index`, `status`, `_tenant_id`, `creator_id`, `creator`, `yn`)
|
|
SELECT parent.id, 'online_monitor_query', '查询', '查询在线监控', 1, 2, 1, 1, parent.`_tenant_id`, 0, 'system', 1
|
|
FROM sys_resource parent
|
|
WHERE parent.`code` = 'online_monitor' AND parent.`yn` = 1
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM sys_resource r
|
|
WHERE r.`_tenant_id` = parent.`_tenant_id` AND r.`code` = 'online_monitor_query' AND r.`yn` = 1
|
|
);
|
|
|
|
INSERT INTO sys_menu (`parent_id`, `code`, `name`, `description`, `source`, `path`, `open_type`, `icon`, `sort_index`, `status`, `_tenant_id`, `creator_id`, `creator`, `yn`)
|
|
SELECT parent.id, 'online_monitor', '在线监控', '在线监控', 1, '/system/online-monitor', 1, '', 11, 1, parent.`_tenant_id`, 0, 'system', 1
|
|
FROM sys_menu parent
|
|
WHERE parent.`code` = 'system_manage' AND parent.`yn` = 1
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM sys_menu m
|
|
WHERE m.`_tenant_id` = parent.`_tenant_id` AND m.`code` = 'online_monitor' AND m.`yn` = 1
|
|
);
|
|
|
|
INSERT INTO sys_menu_resource (`menu_id`, `resource_id`, `resource_bind_type`, `_tenant_id`, `creator_id`, `creator`, `yn`)
|
|
SELECT m.id, r.id, 1, m.`_tenant_id`, 0, 'system', 1
|
|
FROM sys_menu m
|
|
JOIN sys_resource r ON r.`_tenant_id` = m.`_tenant_id` AND r.`code` = 'online_monitor' AND r.`yn` = 1
|
|
WHERE m.`code` = 'online_monitor' AND m.`yn` = 1
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM sys_menu_resource mr
|
|
WHERE mr.`_tenant_id` = m.`_tenant_id` AND mr.`menu_id` = m.id AND mr.`resource_id` = r.id AND mr.`yn` = 1
|
|
);
|
|
|
|
UPDATE sys_menu_resource mr
|
|
JOIN sys_menu m ON m.id = mr.menu_id AND m.`_tenant_id` = mr.`_tenant_id` AND m.`code` = 'online_monitor' AND m.`yn` = 1
|
|
JOIN sys_resource r ON r.id = mr.resource_id AND r.`_tenant_id` = mr.`_tenant_id` AND r.`code` = 'online_monitor' AND r.`yn` = 1
|
|
SET mr.`resource_bind_type` = 1,
|
|
mr.`modified` = CURRENT_TIMESTAMP
|
|
WHERE mr.`yn` = 1;
|
|
|
|
INSERT INTO sys_role_menu (`role_id`, `menu_id`, `menu_bind_type`, `resource_tree_json`, `_tenant_id`, `creator_id`, `creator`, `yn`)
|
|
SELECT role.id,
|
|
menu.id,
|
|
1,
|
|
JSON_ARRAY(JSON_OBJECT('id', resource.id, 'code', resource.`code`, 'resourceBindType', 1)),
|
|
menu.`_tenant_id`,
|
|
0,
|
|
'system',
|
|
1
|
|
FROM sys_role role
|
|
JOIN sys_menu menu ON menu.`_tenant_id` = role.`_tenant_id` AND menu.`code` = 'online_monitor' AND menu.`yn` = 1
|
|
JOIN sys_resource resource ON resource.`_tenant_id` = role.`_tenant_id` AND resource.`code` = 'online_monitor' AND resource.`yn` = 1
|
|
WHERE role.`code` = 'super_admin' AND role.`yn` = 1
|
|
AND NOT EXISTS (
|
|
SELECT 1 FROM sys_role_menu rm
|
|
WHERE rm.`_tenant_id` = role.`_tenant_id` AND rm.`role_id` = role.id AND rm.`menu_id` = menu.id AND rm.`yn` = 1
|
|
);
|
|
|
|
UPDATE sys_role_menu rm
|
|
JOIN sys_role role ON role.id = rm.role_id AND role.`_tenant_id` = rm.`_tenant_id` AND role.`code` = 'super_admin' AND role.`yn` = 1
|
|
JOIN sys_menu menu ON menu.id = rm.menu_id AND menu.`_tenant_id` = rm.`_tenant_id` AND menu.`code` = 'online_monitor' AND menu.`yn` = 1
|
|
JOIN sys_resource resource ON resource.`_tenant_id` = rm.`_tenant_id` AND resource.`code` = 'online_monitor' AND resource.`yn` = 1
|
|
SET rm.`menu_bind_type` = 1,
|
|
rm.`resource_tree_json` = JSON_ARRAY(JSON_OBJECT('id', resource.id, 'code', resource.`code`, 'resourceBindType', 1)),
|
|
rm.`modified` = CURRENT_TIMESTAMP
|
|
WHERE rm.`yn` = 1;
|