20260806_dp.sql 3.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. update public.sys_menu set component='ufo/config/station/cpoint/index' where menu_name = '测点配置';
  2. INSERT INTO "public"."sys_menu" (
  3. "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
  4. "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
  5. "icon", "create_by", "create_time", "update_by", "update_time", "remark"
  6. )
  7. SELECT
  8. 2071, '风向玫瑰图', 2004, 3, 'rose', 'ufo/electricity/weather/RoseChart', NULL,
  9. 'ElectricityRoseChart', 1, 0, 'C', '0', '0', 'electricity:weather:rose',
  10. 'alert', 'admin', '2026-08-04 00:00:00', '', NULL, ''
  11. WHERE NOT EXISTS (
  12. SELECT 1 FROM sys_menu WHERE menu_name = '风向玫瑰图'
  13. );
  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")
  15. SELECT
  16. 2072, '风速曲线图', 2004, 4, 'wind-speed-curve', 'ufo/electricity/weather/WindSpeedCurve', NULL, 'ElectricityWindSpeedCurve', 1, 0, 'C', '0', '0', 'electricity:weather:wschart', 'alert', 'admin', '2026-08-04 00:00:00', '', NULL, ''
  17. WHERE NOT EXISTS (
  18. SELECT 1 FROM sys_menu WHERE menu_name = '风速曲线图'
  19. );
  20. 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")
  21. SELECT
  22. 2073, '温度曲线图', 2004, 5, 'temperature-curve', 'ufo/electricity/weather/TemperatureCurve', NULL, 'ElectricityTemperatureCurve', 1, 0, 'C', '0', '0', 'electricity:weather:tsfcchart', 'alert', 'admin', '2026-08-04 00:00:00', '', NULL, ''
  23. WHERE NOT EXISTS (
  24. SELECT 1 FROM sys_menu WHERE menu_name = '温度曲线图'
  25. );
  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")
  27. SELECT
  28. 2074, '湿度曲线图', 2004, 6, 'humidity-curve', 'ufo/electricity/weather/HumidityCurve', NULL, 'ElectricityHumidityCurve', 1, 0, 'C', '0', '0', 'electricity:weather:tsfcchart', 'alert', 'admin', '2026-08-04 00:00:00', '', NULL, ''
  29. WHERE NOT EXISTS (
  30. SELECT 1 FROM sys_menu WHERE menu_name = '湿度曲线图'
  31. );
  32. 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")
  33. SELECT
  34. 2075, '气压曲线图', 2004, 7, 'pressure-curve', 'ufo/electricity/weather/PressureCurve', NULL, 'ElectricityPressureCurve', 1, 0, 'C', '0', '0', 'electricity:weather:rhsfcchart', 'alert', 'admin', '2026-08-04 00:00:00', '', NULL, ''
  35. WHERE NOT EXISTS (
  36. SELECT 1 FROM sys_menu WHERE menu_name = '气压曲线图'
  37. );
  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")
  39. SELECT
  40. 2076, '辐照曲线图', 2004, 8, 'irradiance-curve', 'ufo/electricity/weather/IrradianceCurve', NULL, 'ElectricityIrradianceCurve', 1, 0, 'C', '0', '0', 'electricity:weather:psfcchart', 'alert', 'admin', '2026-08-04 00:00:00', '', NULL, ''
  41. WHERE NOT EXISTS (
  42. SELECT 1 FROM sys_menu WHERE menu_name = '辐照曲线图'
  43. );