| 123456789101112131415161718192021222324252627282930313233 |
- 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');
|