-- 将本菜单挂到“业务管理”父菜单下；若后台已有对应菜单，请跳过此脚本并在菜单管理中配置相同路径。
START TRANSACTION;

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon, create_by, create_time)
SELECT '云璞FDE内容', 2027, 30, 'fdeContent', 'business/fdeContent/index', 'C', '0', '0', 'business:fdeContent:list', 'edit', 'admin', NOW()
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'business:fdeContent:list');

SET @fde_menu_id = (SELECT menu_id FROM sys_menu WHERE perms = 'business:fdeContent:list' LIMIT 1);
UPDATE sys_menu SET parent_id = 2027 WHERE menu_id = @fde_menu_id;

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon, create_by, create_time)
SELECT 'FDE新增', @fde_menu_id, 1, '', '', 'F', '0', '0', 'business:fdeContent:add', '#', 'admin', NOW()
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'business:fdeContent:add');

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon, create_by, create_time)
SELECT 'FDE编辑', @fde_menu_id, 2, '', '', 'F', '0', '0', 'business:fdeContent:edit', '#', 'admin', NOW()
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'business:fdeContent:edit');

INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon, create_by, create_time)
SELECT 'FDE删除', @fde_menu_id, 3, '', '', 'F', '0', '0', 'business:fdeContent:remove', '#', 'admin', NOW()
WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = 'business:fdeContent:remove');

INSERT INTO sys_role_menu (role_id, menu_id)
SELECT 2, menu_id FROM sys_menu
WHERE perms IN ('business:fdeContent:list', 'business:fdeContent:add', 'business:fdeContent:edit', 'business:fdeContent:remove')
  AND NOT EXISTS (SELECT 1 FROM sys_role_menu rm WHERE rm.role_id = 2 AND rm.menu_id = sys_menu.menu_id);

COMMIT;