Начало Каталог Помощ
Регистрация Вход
yeguanglin
/
forecast
1
0
Разклонения 0
Файлове Задачи 0 Заявки за сливане 0 Уики
ИН на ревизия: 1457cc5375
Клонове Маркери
forecast
/
release_note
/
2026.09.17
/
20260917_dp.sql

20260917_dp.sql 9.0 KB
История Директен файл

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 
  1. -- 隐藏菜单
    2. 

  2. UPDATE "public"."sys_menu" set status = 1 where menu_name in ('多源多模型预测', '理论功率预测');
    3. 

  3. 

  4. -- data_weather_local 斜面辐照度字段 -> 总辐照度
    5. 

  5. ALTER TABLE "public"."data_weather_local" RENAME COLUMN "inclined_irradiance" TO "irradiance";
    6. 

  6. COMMENT ON COLUMN "public"."data_weather_local"."irradiance" IS '总辐照度，单位 W/m²';
    7. 

  7. 

  8. -- =============================================================================
    9. 

  9. -- 任务编号 2026090805  增加"短期预测报表"功能
    10. 

  10. -- =============================================================================
    11. 

  11. 

  12. 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") VALUES (2071, '短期预测日报', 2016, 3, 'short-term-forecast-daily', 'ufo/electricity/datareport/shorTermForecastDailyReport', '', 'ShorTermForecastDailyReport', 1, 0, 'C', '0', '0', 'data:shortTermForecastReport:daily', 'StockOutlined', 'admin', '2026-09-14 00:00:00', '', NULL, '短期预测日报页面');
    13. 

  13. 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") VALUES (2072, '短期预测月报', 2016, 4, 'short-term-forecast-monthly', 'ufo/electricity/datareport/shorTermForecastMonthlyReport', '', 'ShorTermForecastMonthlyReport', 1, 0, 'C', '0', '0', 'data:shortTermForecastReport:monthly', 'LineChartOutlined', 'admin', '2026-09-14 00:00:00', '', NULL, '短期预测月报页面');
    14. 

  14. 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") VALUES (2073, '短期预测年报', 2016, 5, 'short-term-forecast-yearly', 'ufo/electricity/datareport/shorTermForecastYearlyReport', '', 'ShorTermForecastYearlyReport', 1, 0, 'C', '0', '0', 'data:shortTermForecastReport:yearly', 'AreaChartOutlined', 'admin', '2026-09-14 00:00:00', '', NULL, '短期预测年报页面');
    15. 

  15. 

  16. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2087);
    17. 

  17. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2088);
    18. 

  18. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2089);
    19. 

  19. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2090);
    20. 

  20. 

  21. -- =============================================================================
    22. 

  22. -- 任务编号 2026090806  增加"超短期预测报表"功能
    23. 

  23. -- =============================================================================
    24. 

  24. 

  25. 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") VALUES (2091, '超短期预测日报', 2016, 6, 'ultra-short-term-forecast-daily', 'ufo/datareport/ultraShortTermForecastDailyReport', '', 'UltraShorTermForecastDailyReport', 1, 0, 'C', '0', '0', 'data:ultraShortTermForecastReport:daily', 'StockOutlined', 'admin', '2026-09-14 00:00:00', '', NULL, '超短期预测日报页面');
    26. 

  26. 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") VALUES (2092, '超短期预测月报', 2016, 7, 'ultra-short-term-forecast-monthly', 'ufo/datareport/ultraShortTermForecastMonthlyReport', '', 'UltraShorTermForecastMonthlyReport', 1, 0, 'C', '0', '0', 'data:ultraShortTermForecastReport:monthly', 'LineChartOutlined', 'admin', '2026-09-14 00:00:00', '', NULL, '超短期预测月报页面');
    27. 

  27. 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") VALUES (2093, '超短期预测年报', 2016, 8, 'ultra-short-term-forecast-yearly', 'ufo/datareport/ultraShortTermForecastYearlyReport', '', 'UltraShorTermForecastYearlyReport', 1, 0, 'C', '0', '0', 'data:ultraShortTermForecastReport:yearly', 'AreaChartOutlined', 'admin', '2026-09-14 00:00:00', '', NULL, '超短期预测年报页面');
    28. 

  28. 

  29. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2091);
    30. 

  30. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2092);
    31. 

  31. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2093);
    32. 

  32. 

  33. -- =============================================================================
    34. 

  34. -- 任务编号 2026091401  增加"光伏电场累计报表"功能
    35. 

  35. -- =============================================================================
    36. 

  36. 

  37. 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") VALUES (2101, '光伏电场累计日报', 2016, 9, 'pv-plant-cumulative-daily', 'ufo/datareport/pvPlantCumulativeDailyReport', '', 'PvPlantCumulativeDailyReport', 1, 0, 'C', '0', '0', 'data:pvPlantCumulativeReport:daily', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '光伏电场累计日报页面');
    38. 

  38. 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") VALUES (2102, '光伏电场累计月报', 2016, 10, 'pv-plant-cumulative-monthly', 'ufo/datareport/pvPlantCumulativeMonthlyReport', '', 'PvPlantCumulativeMonthlyReport', 1, 0, 'C', '0', '0', 'data:pvPlantCumulativeReport:monthly', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '光伏电场累计月报页面');
    39. 

  39. 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") VALUES (2103, '光伏电场累计年报', 2016, 11, 'pv-plant-cumulative-yearly', 'ufo/datareport/pvPlantCumulativeYearlyReport', '', 'PvPlantCumulativeYearlyReport', 1, 0, 'C', '0', '0', 'data:pvPlantCumulativeReport:yearly', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '光伏电场累计年报页面');
    40. 

  40. 

  41. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2101);
    42. 

  42. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2102);
    43. 

  43. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2103);
    44. 

  44. 

  45. -- =============================================================================
    46. 

  46. -- 任务编号 2026091402  增加"光伏气象资源数据报表"功能
    47. 

  47. -- =============================================================================
    48. 

  48. 

  49. 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") VALUES (2111, '光伏气象资源数据报表', 2016, 12, 'pv-meteorological-resource-data', 'ufo/datareport/pvMeteorologicalResourceDataReport', '', 'PvMeteorologicalResourceDataReport', 1, 0, 'C', '0', '0', 'data:pvMeteorologicalResourceData:list', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '光伏气象资源数据报表页面');
    50. 

  50. 

  51. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 2111);
    52. 

  52. 

  53. 

  54. -- 修复菜单名称
    55. 

  55. update "public"."sys_menu" set menu_name = '湿度曲线图' where menu_name = '温度曲线图' and menu_id = 2074;
    56. 

  56. update "public"."sys_menu" set menu_name = '气压曲线图' where menu_name = '湿度曲线图' and menu_id = 2075;
    57. 

  57. update "public"."sys_menu" set menu_name = '辐照曲线图' where menu_name = '气压曲线图' and menu_id = 2076;
    58. 

  58. update "public"."sys_menu" set menu_name = '功率预测' where menu_name = '预报管理' and menu_id = 2007;
    59. 

  59. update "public"."sys_menu" set status =  1 where menu_name = '发电量预测' and menu_id = 2010;
    60. 

  60. update "public"."sys_menu" set status =  1 where menu_name = '短期预测功率' and menu_id = 2083;
    61. 

  61. update "public"."sys_menu" set status =  1 where menu_name = '超短期预测功率' and menu_id = 2084;
    62. 

  62. update "public"."sys_menu" set menu_name = '短期功率预测修正' where menu_name = '短期预测功率修正' and menu_id = 2085;
    63. 

  63. update "public"."sys_menu" set menu_name = '超短期功率预测修正' where menu_name = '超短期预测功率修正' and menu_id = 2086;
    64. 

  64. update "public"."sys_menu" set parent_id =  2007 where parent_id = 2004 and menu_id = 2080;
    65. 

  65. update "public"."sys_menu" set parent_id =  2007 where parent_id = 2004 and menu_id = 2076;
    66.