forecast/release_note/20260924/增加场站.sql

-- ============================================================
-- 任务编号: 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';