-- 光储监控菜单调整：设备管理重命名，报表重命名，并将视频监控置于数据菜单首位。

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';