mescloud/db/mysql/mes_product_fsw_menu.sql

-- FSW过程参数菜单（已有库执行本脚本即可）
-- 路径：生产管理 -> 工艺过程参数 -> FSW过程参数

INSERT INTO `js_sys_menu` VALUES (
'2072000000000000001', '2042038662094802944', '0,1672118505143263232,2042038662094802944,',
195, '0000009290,0000000660,0000000195,', '1', 2,
'生产管理/工艺过程参数/FSW过程参数', 'FSW过程参数', '1', '/mes/mesProductFsw/list',
'', '', '', '', 'mes:mesProductFsw:view,mes:mesProductFsw:edit',
40, '1', 'default', 'core', NULL, NULL, '0',
'system', NOW(), 'system', NOW(),
'', '', '', '', '', '', '', '', '',
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
);

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