mescloud/db/mysql/mes_screen_manage_menu.sql

-- 生产线管理 / 大屏管理：集中打开各块大屏
-- 挂在「生产线管理」下，授权给已经能看「MES大屏」的角色

DELETE FROM `js_sys_role_menu` WHERE `menu_code` = '2099051000000000001';
DELETE FROM `js_sys_menu` WHERE `menu_code` = '2099051000000000001';

INSERT INTO `js_sys_menu`
(`menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
 `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`, `menu_title`,
 `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`, `status`,
 `create_by`, `create_date`, `update_by`, `update_date`, `remarks`)
SELECT
'2099051000000000001', p.`menu_code`, CONCAT(p.`parent_codes`, p.`menu_code`, ','),
400, CONCAT(p.`tree_sorts`, '0000000400,'), '1', p.`tree_level` + 1,
CONCAT(p.`tree_names`, '/大屏管理'), '大屏管理', '1',
'/mes/mesScreen/list', '', 'fa fa-desktop', '', '',
'mes:mesScreen:view,mes:mesScreen:edit', 40, '1', 'default', 'core', NULL, NULL, '0',
'system', NOW(), 'system', NOW(), '集中打开各块大屏'
FROM `js_sys_menu` p
WHERE p.`menu_code` = '1680784143702568960';

INSERT INTO `js_sys_role_menu` (`role_code`, `menu_code`)
SELECT rm.`role_code`, '2099051000000000001'
FROM `js_sys_role_menu` rm
WHERE rm.`menu_code` = '1915638797464936448'
  AND NOT EXISTS (
    SELECT 1 FROM `js_sys_role_menu` x
    WHERE x.`role_code` = rm.`role_code`
      AND x.`menu_code` = '2099051000000000001'
  );