forecast/release_note/20260924/20260924_dp.sql

-- ============================================================
-- 任务 2026091801: 增加调用Gateway服务Util
-- 新增字典配置项: 网关服务配置项 (gateway_app_config)
-- dict_value 为 JSON:
--   baseUrl                 网关服务url前缀
--   pointStateUrl           状态查询接口
--   channelStateExpressions 通道状态判断表达式(SpEL, 变量 #iValue)
--   channelOperationUrl     通道操作接口
-- ============================================================

ALTER TABLE "public"."sys_dict_data" ALTER COLUMN "dict_value" DROP DEFAULT, 
ALTER COLUMN "dict_value" TYPE character varying(1000) USING "dict_value"::character varying(1000), 
ALTER COLUMN "dict_value" SET DEFAULT '';

INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, remark)
SELECT
nextval(pg_get_serial_sequence('sys_dict_type', 'dict_id')),
'网关服务配置项', 'gateway_app_config', '0', 'admin', now(), '网关服务(gatewayapp)地址与接口配置, JSON格式'
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'gateway_app_config');

INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT
nextval(pg_get_serial_sequence('sys_dict_data', 'dict_code')),
1, '网关服务配置项', '{"baseUrl":"http://xxx","pointStateUrl":"/biz/point-state/real","channelStateExpressions":"#iValue != null and #iValue == 1","channelOperationUrl":"/biz/channel/control"}', 'gateway_app_config', '', '', 'Y', '0', 'admin', now(), 'JSON: baseUrl/pointStateUrl/channelStateExpressions/channelOperationUrl'
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data t WHERE t.dict_type = 'gateway_app_config');


-- 测点监测
INSERT INTO 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 nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
'测点监测', 
(select menu_id from sys_menu t where t.menu_name = '实时监控')
, 3, 'point-monitor', 'ufo/electricity/realtime/PointMonitor', '', 'PointMonitor', 1, 0, 'C', '0', '0', 'data:oointMonitor', 'MonitorOutlined', 'admin', now(), '', NULL, '测点监测页面'
WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '测点监测');

INSERT INTO sys_role_menu (role_id, menu_id)
SELECT 1, (SELECT menu_id FROM sys_menu t WHERE t.menu_name = '测点监测')
WHERE NOT EXISTS (SELECT 1 FROM sys_role_menu t WHERE t.role_id = 1 AND t.menu_id = (SELECT menu_id FROM sys_menu t WHERE t.menu_name = '测点监测'));

-- 优化菜单名称
update public.sys_menu set menu_name = '短期功率预测修正' where menu_name = '短期预测功率修正';
update public.sys_menu set menu_name = '超短期功率预测修正' where menu_name = '超短期预测功率修正';
update public.sys_menu set menu_name = '气象资源' where menu_name = '气象与灾害预警地图';
-- 20260922
UPDATE public.sys_menu set menu_name = '设备管理' where menu_name = '风机设备信息';
update public.sys_menu set status = 1 where menu_name = '设备状态监控';