forecast/release_note/2026.09.03/20260903_dp.sql

-- 辐照度功率对比菜单权限
INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2080, '辐照度功率对比', 2004, 9, 'irradiance-power-comparison', 'ufo/electricity/forecast/IrradiancePowerComparison', NULL,
    'IrradiancePowerComparison', 1, 0, 'C', '0', '0', 'data:irradiancePowerComparison:list',
    'BarChartOutlined', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '辐照度功率对比'
);


INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2083, '短期预测功率', 2007, 9, 'powerForecastIssued', 'ufo/electricity/forecast/ShortTermPowerForecastIssued', NULL,
    'ShortTermPowerForecastIssued', 1, 0, 'C', '0', '0', 'power:powerForecastIssued:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '短期预测功率'
);

INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2085, '短期预测功率修正', 2007, 11, 'shortTermPowerForecastCorrect', 'ufo/electricity/forecast/DataShortTermPowerForecastCorrect', NULL,
    'DataShortTermPowerForecastCorrect', 1, 0, 'C', '0', '0', 'power:powerForecastCorrect:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '短期预测功率修正'
);


INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2086, '超短期预测功率修正', 2007, 12, 'superShortTermForecastCorrect', 'ufo/electricity/forecast/DataSuperShortTermForecastCorrect', NULL,
    'DataSuperShortTermForecastCorrect', 1, 0, 'C', '0', '0', 'supershort:dataSuperForecastCorrect:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '超短期预测功率修正'
);

INSERT INTO "public"."sys_menu" (
    "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
    "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
    "icon", "create_by", "create_time", "update_by", "update_time", "remark"
)
SELECT
    2084, '超短期预测功率', 2007, 10, 'superShortTermForecastIssued', 'ufo/electricity/forecast/DataSuperShortTermForecastIssued', NULL,
    'DataSuperShortTermForecastIssued', 1, 0, 'C', '0', '0', 'supershort:dataSuperForecastIssued:list',
    'chart', 'admin', '2026-08-31 00:00:00', '', NULL, ''
WHERE NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE menu_name = '超短期预测功率'
);