-- ============================================================ -- 任务编号: 2026091501 -- 任务名称: 增加场站 -- 数据库: PostgreSQL -- 日期: 2026-09-15 -- ============================================================ -- 1.3.1 江门 (JMJD01) INSERT INTO config_station ( station_name, station_code, superior_area_id, period_total, longitude, latitude, province_number, city_number, position, installed_capacity, grid_connected_capacity, fans_pv_panelquantity, elevation, operation_time, boosterstation_voltage_level, booster_station_longitude, boosterstation_latitude, responsible_person_name, responsible_person_phone, is_enable, push_status, subject_total, is_full_power, is_del, create_by, create_time, update_by, update_time, station_type, system_power_uuid, area_id ) select '江门', 'JMJD01', 'EAST01', 0, '113.135232', '22.555907', '440700', '440700', '广东省江门市江海区东宁路91号', 4050, 4050, 8723, '6', '2025-05-30', '10.5KV', '113.135232', '22.555907', '张工', '13800000000', 'true', 1, 1, '0', 'false', 'admin', NOW(), 'admin', NOW(), 1, '', 'EAST01' WHERE NOT EXISTS (SELECT 1 FROM config_station t WHERE t.station_code = 'JMJD01'); -- 1.3.2 北流煜炜 (YUWEI) INSERT INTO config_station ( station_name, station_code, superior_area_id, period_total, longitude, latitude, province_number, city_number, position, installed_capacity, grid_connected_capacity, fans_pv_panelquantity, elevation, operation_time, boosterstation_voltage_level, booster_station_longitude, boosterstation_latitude, responsible_person_name, responsible_person_phone, is_enable, push_status, subject_total, is_full_power, is_del, create_by, create_time, update_by, update_time, station_type, system_power_uuid, area_id ) select '北流煜炜', 'YUWEI', 'EAST01', 0, '110.305066', '22.615142', '450981', '450981', '广西壮族自治区玉林市北流市塘岸镇六和村241国道与和谐路交叉口东北 480 米处', 3000, 3000, 5567, '108', '2025-04-30', '10.5KV', '110.305066', '22.615142', '', '', 'true', 1, 1, '0', 'false', 'admin', NOW(), 'admin', NOW(), 1, '', 'EAST01' WHERE NOT EXISTS (SELECT 1 FROM config_station t WHERE t.station_code = 'YUWEI'); -- 1.3.3 清远忠信 (ZHONGXIN) INSERT INTO config_station ( station_name, station_code, superior_area_id, period_total, longitude, latitude, province_number, city_number, position, installed_capacity, grid_connected_capacity, fans_pv_panelquantity, elevation, operation_time, boosterstation_voltage_level, booster_station_longitude, boosterstation_latitude, responsible_person_name, responsible_person_phone, is_enable, push_status, subject_total, is_full_power, is_del, create_by, create_time, update_by, update_time, station_type, system_power_uuid, area_id ) select '清远忠信', 'ZHONGXIN', 'EAST01', 0, '112.996233', '23.542156', '441802', '441802', '广东省清远市清城区石龙大道建滔循环经济工业园', 2250, 2250, 3980, '13', '', '10.5KV', '112.996233', '23.542156', '', '', 'true', 1, 1, '0', 'false', 'admin', NOW(), 'admin', NOW(), 1, '', 'EAST01' WHERE NOT EXISTS (SELECT 1 FROM config_station t WHERE t.station_code = 'ZHONGXIN'); -- ============================================================ -- UPDATE 脚本 (站码已存在时执行) -- ============================================================ -- 1.3.1 江门 UPDATE config_station SET station_name = '江门', superior_area_id = 'EAST01', period_total = 0, longitude = '113.135232', latitude = '22.555907', province_number = '440700', city_number = '440700', position = '广东省江门市江海区东宁路91号', installed_capacity = 4050, grid_connected_capacity = 4050, fans_pv_panelquantity = 8723, elevation = '6', operation_time = '2025-05-30', boosterstation_voltage_level = '10.5KV', booster_station_longitude = '113.135232', boosterstation_latitude = '22.555907', responsible_person_name = '张工', responsible_person_phone = '13800000000', is_enable = 'true', push_status = 1, subject_total = 1, is_full_power = '0', update_by = 'admin', update_time = NOW(), station_type = 1, system_power_uuid = '', area_id = 'EAST01' WHERE station_code = 'JMJD01'; -- 1.3.2 北流煜炜 UPDATE config_station SET station_name = '北流煜炜', superior_area_id = 'EAST01', period_total = 0, longitude = '110.305066', latitude = '22.615142', province_number = '450981', city_number = '450981', position = '广西壮族自治区玉林市北流市塘岸镇六和村241国道与和谐路交叉口东北 480 米处', installed_capacity = 3000, grid_connected_capacity = 3000, fans_pv_panelquantity = 5567, elevation = '108', operation_time = '2025-04-30', boosterstation_voltage_level = '10.5KV', booster_station_longitude = '110.305066', boosterstation_latitude = '22.615142', responsible_person_name = '', responsible_person_phone = '', is_enable = 'true', push_status = 1, subject_total = 1, is_full_power = '0', update_by = 'admin', update_time = NOW(), station_type = 1, system_power_uuid = '', area_id = 'EAST01' WHERE station_code = 'YUWEI'; -- 1.3.3 清远忠信 UPDATE config_station SET station_name = '清远忠信', superior_area_id = 'EAST01', period_total = 0, longitude = '112.996233', latitude = '23.542156', province_number = '441802', city_number = '441802', position = '广东省清远市清城区石龙大道建滔循环经济工业园', installed_capacity = 2250, grid_connected_capacity = 2250, fans_pv_panelquantity = 3980, elevation = '13', operation_time = '', boosterstation_voltage_level = '10.5KV', booster_station_longitude = '112.996233', boosterstation_latitude = '23.542156', responsible_person_name = '', responsible_person_phone = '', is_enable = 'true', push_status = 1, subject_total = 1, is_full_power = '0', update_by = 'admin', update_time = NOW(), station_type = 1, system_power_uuid = '', area_id = 'EAST01' WHERE station_code = 'ZHONGXIN';