update "public"."sys_menu" set icon = 'OLDetection' where menu_name = '测点监测'; update "public"."sys_menu" set icon = 'OLDetection' where menu_name = '实时监控'; update "public"."sys_menu" set icon = 'OLDeviceManagement' where menu_name = '设备管理'; update "public"."sys_menu" set icon = 'OLMeteorologicalResources' where menu_name = '气象资源'; update "public"."sys_menu" set icon = 'OLPowerForecasting' where menu_name = '功率预测'; -- 字典类型: 算法配置(测光法系数) 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')), '算法配置', 'algorithm_config', '0', 'admin', now(), '理论功率-算法配置' WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'algorithm_config'); -- 算法配置字典数据(先删后插,保证幂等) DELETE FROM sys_dict_data WHERE dict_type = 'algorithm_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) VALUES (nextval(pg_get_serial_sequence('sys_dict_data', 'dict_code')), 1, '测光法配置', '{"a1": 0.0, "a2": 0.0}', 'algorithm_config', '', '', 'N', '0', 'admin', now(), '测光法 P=n*(a1*G+a2*T);a1/a2 初始为 0 占位,需运维替换为真实系数'); -- 字典类型: 理论功率配置项(校核阈值) 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')), '理论功率配置项', 'theoretical_power_config', '0', 'admin', now(), '理论功率-校核阈值' WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'theoretical_power_config'); -- 理论功率配置项字典数据(先删后插,保证幂等) DELETE FROM sys_dict_data WHERE dict_type = 'theoretical_power_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) VALUES (nextval(pg_get_serial_sequence('sys_dict_data', 'dict_code')), 1, '理论功率配置项', '{"installed2TheoreticalPercent": 99.99, "theoretical2AvailablePercent": 99.99, "available2ActualPercent": 95.00}', 'theoretical_power_config', '', '', 'N', '0', 'admin', now(), '校核阈值,比值≥阈值判合格'); -- config_station 逆变器数量初值(按 station_code 定值更新,天然幂等) UPDATE config_station SET inverter_quantity = 19 WHERE station_code = 'JMJD01'; UPDATE config_station SET inverter_quantity = 10 WHERE station_code IN ('YUWEI', 'ZHONGXIN', 'YMPV03', 'GBPV04');