-- 合作商已拥有光储子菜单权限时，同时补齐父级目录权限。
-- sys_role_menu 的菜单树要求目录(M)本身也被授权，否则前端不会展示整组子菜单。

SET @device_monitoring_menu_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
);

SET @energy_data_menu_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
);

-- 光储监控设备管理：监控摄像头、光伏电站、储能电站、逆变器、能量链任一权限。
INSERT IGNORE INTO sys_role_menu (role_id, menu_id)
SELECT DISTINCT role_menu.role_id, @device_monitoring_menu_id
FROM sys_role_menu role_menu
INNER JOIN sys_menu child_menu ON child_menu.menu_id = role_menu.menu_id
WHERE @device_monitoring_menu_id IS NOT NULL
  AND (
      child_menu.path LIKE '/deviceManagement/%'
      OR child_menu.perms LIKE '/deviceManagement/%'
  );

-- 光储监控数据：视频监控、光伏报表、储能日充放电报表任一权限。
INSERT IGNORE INTO sys_role_menu (role_id, menu_id)
SELECT DISTINCT role_menu.role_id, @energy_data_menu_id
FROM sys_role_menu role_menu
INNER JOIN sys_menu child_menu ON child_menu.menu_id = role_menu.menu_id
WHERE @energy_data_menu_id IS NOT NULL
  AND (
      child_menu.path LIKE '/energyReport/%'
      OR child_menu.perms LIKE '/energyReport/%'
      OR child_menu.path = '/videoMonitor'
      OR child_menu.perms = '/energyReport/videoMonitor'
  );