-- ============================================================
-- 任务 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');