-- 光储监控菜单调整：设备管理重命名，报表重命名，并将视频监控置于数据菜单首位。
|
|
UPDATE sys_menu
|
SET menu_name = '光储监控设备管理', update_time = NOW()
|
WHERE parent_id = 0
|
AND menu_type = 'M'
|
AND (path = '/deviceManagement' OR perms = '/deviceManagement');
|
|
SET @energy_data_id := (
|
SELECT menu_id
|
FROM sys_menu
|
WHERE parent_id = 0
|
AND menu_type = 'M'
|
AND (path = '/energyReport' OR perms = '/energyReport')
|
ORDER BY menu_id
|
LIMIT 1
|
);
|
|
UPDATE sys_menu
|
SET menu_name = '光储监控数据', update_time = NOW()
|
WHERE menu_id = @energy_data_id;
|
|
INSERT INTO sys_menu
|
(menu_name, parent_id, order_num, path, component, query, is_frame, is_cache,
|
menu_type, visible, status, perms, icon, create_by, create_time, remark)
|
SELECT '视频监控', @energy_data_id, 1, '/videoMonitor', 'videoMonitor', NULL, 1, 0,
|
'C', '0', 0, '/energyReport/videoMonitor', '#', 'admin', NOW(), '光储监控数据-视频监控'
|
WHERE @energy_data_id IS NOT NULL
|
AND NOT EXISTS (
|
SELECT 1 FROM sys_menu
|
WHERE parent_id = @energy_data_id AND path = '/videoMonitor'
|
);
|
|
SET @video_monitor_id := (
|
SELECT menu_id
|
FROM sys_menu
|
WHERE parent_id = @energy_data_id AND path = '/videoMonitor'
|
ORDER BY menu_id
|
LIMIT 1
|
);
|
|
UPDATE sys_menu
|
SET menu_name = '视频监控', order_num = 1, component = 'videoMonitor', menu_type = 'C',
|
visible = '0', status = 0, perms = '/energyReport/videoMonitor', update_time = NOW()
|
WHERE menu_id = @video_monitor_id;
|
|
UPDATE sys_menu
|
SET order_num = order_num + 1, update_time = NOW()
|
WHERE parent_id = @energy_data_id
|
AND menu_id <> @video_monitor_id
|
AND order_num >= 1;
|
|
-- 已拥有“光储监控数据”目录权限的角色同步获得视频监控权限。
|
INSERT IGNORE INTO sys_role_menu (role_id, menu_id)
|
SELECT role_id, @video_monitor_id
|
FROM sys_role_menu
|
WHERE menu_id = @energy_data_id;
|
|
-- 光储监控设备管理的子菜单名称及顺序。
|
SET @device_monitoring_id := (
|
SELECT menu_id FROM sys_menu
|
WHERE parent_id = 0
|
AND menu_type = 'M'
|
AND (path = '/deviceManagement' OR perms = '/deviceManagement')
|
ORDER BY menu_id
|
LIMIT 1
|
);
|
|
UPDATE sys_menu
|
SET menu_name = '监控摄像头列表', order_num = 1, update_time = NOW()
|
WHERE parent_id = @device_monitoring_id AND path = '/deviceManagement/list';
|
|
UPDATE sys_menu
|
SET menu_name = '光伏电站管理', order_num = 2, update_time = NOW()
|
WHERE parent_id = @device_monitoring_id AND path = '/deviceManagement/photovoltaicStation/list';
|
|
UPDATE sys_menu
|
SET menu_name = '储能电站管理', order_num = 3, update_time = NOW()
|
WHERE parent_id = @device_monitoring_id AND path = '/deviceManagement/energyStorage/list';
|
|
UPDATE sys_menu
|
SET menu_name = '光伏逆变器管理', order_num = 4, update_time = NOW()
|
WHERE parent_id = @device_monitoring_id AND path = '/deviceManagement/photovoltaicInverter/list';
|
|
UPDATE sys_menu
|
SET menu_name = '储能能量链管理', order_num = 5, update_time = NOW()
|
WHERE parent_id = @device_monitoring_id AND path = '/deviceManagement/energyChain/list';
|
