-- ============================================= -- 长辉 chdl 数采监控菜单 -- 生成时间:2026-10-28 -- 说明:后端 /mes/collect/* 接口已就绪,前端页面已开发,这里补菜单入口 -- ============================================= -- 1. 设备数采(二级菜单,挂在设备管理下) INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (5392, '设备数采', '', 2, 2, 5300, 'collect', 'ep:data-line', 'mes/dv/collect/index', 'MesDvCollect', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE name=VALUES(name), component=VALUES(component), component_name=VALUES(component_name), status=0, deleted=b'0', update_time=NOW(); -- 2. 数采查询按钮 INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (5393, '数采查询', 'mes:collect:query', 3, 1, 5392, '', '', '', NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE permission=VALUES(permission), status=0, deleted=b'0', update_time=NOW(); -- 3. 报警确认按钮 INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (5394, '报警确认', 'mes:collect-alarm:ack', 3, 2, 5392, '', '', '', NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE permission=VALUES(permission), status=0, deleted=b'0', update_time=NOW(); -- 4. 给已有「设备台账」权限的角色自动授予数采权限 INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted, tenant_id) SELECT DISTINCT x.role_id, m.id, '1', NOW(), '1', NOW(), b'0', x.tenant_id FROM system_role_menu x JOIN system_menu m ON m.id IN (5392, 5393, 5394) WHERE x.menu_id = 5320 AND x.deleted = b'0' AND NOT EXISTS ( SELECT 1 FROM system_role_menu y WHERE y.role_id = x.role_id AND y.menu_id = m.id AND y.tenant_id = x.tenant_id AND y.deleted = b'0' ); -- 5. 校验 SELECT id, name, parent_id, permission, component, deleted+0 AS deleted FROM system_menu WHERE id IN (5392, 5393, 5394) ORDER BY id; SELECT CONCAT('授权角色数=', COUNT(DISTINCT role_id)) AS grants FROM system_role_menu WHERE menu_id IN (5392, 5393, 5394) AND deleted = b'0';