getWeather/src/main/java/com/example/getweather/service/GetWeather.java

package com.example.getweather.service;

import cn.hutool.core.date.DateUtil;
import cn.hutool.db.Db;
import cn.hutool.db.Entity;
import cn.hutool.http.HttpUtil;
import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import com.example.getweather.entity.DistrictCodeDO;
import com.example.getweather.entity.HeFengDay;
import com.example.getweather.util.WeixinPush;
import com.taosdata.jdbc.TSDBDriver;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.validation.annotation.Validated;

import javax.annotation.Resource;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.time.Instant;
import java.time.LocalDate;
import java.time.ZonedDateTime;
import java.util.*;
import java.util.stream.Collectors;

@Service
@Validated
@Slf4j
public class GetWeather {
    @Resource
    private WeixinPush weixinPush;

    /**
     * 根据风速获取对应风力等级
     * 2025-01-09 改为km/h单位
     *
     * @param speed 风速，单位为 km/h
     * @return 风力等级
     */
    public static int speedLevel(String speed) {
        BigDecimal val = new BigDecimal(speed);
        //<0.3	无风 0级
        if (val.compareTo(new BigDecimal("1")) < 0) {
            return 0;
        } else if (val.compareTo(new BigDecimal("6")) < 0) {
            //0.3-1.6	微风徐徐 1级
            return 1;
        } else if (val.compareTo(new BigDecimal("12")) < 0) {
            //1.6-3.4	清风 2级
            return 2;
        } else if (val.compareTo(new BigDecimal("20")) < 0) {
            //3.4-5.5	树叶摇摆 3级
            return 3;
        } else if (val.compareTo(new BigDecimal("29")) < 0) {
            //5.5-8.0	树枝摇动 4级
            return 4;
        } else if (val.compareTo(new BigDecimal("39")) < 0) {
            //8.0-10.8	风吹折小树 5级
            return 5;
        } else if (val.compareTo(new BigDecimal("50")) < 0) {
            //10.8-13.9	树枝折断 6级
            return 6;
        } else if (val.compareTo(new BigDecimal("62")) < 0) {
            //13.9-17.2	风吹倒树木 7级
            return 7;
        } else if (val.compareTo(new BigDecimal("75")) < 0) {
            //17.2-20.8	风吹断大树 8级
            return 8;
        } else if (val.compareTo(new BigDecimal("89")) < 0) {
            //20.8-24.5	强风 9级
            return 9;
        } else if (val.compareTo(new BigDecimal("103")) < 0) {
            //24.5-28.5	狂风 10级
            return 10;
        } else if (val.compareTo(new BigDecimal("117")) < 0) {
            //28.5-32.7	暴风 11级
            return 11;
        } else if (val.compareTo(new BigDecimal("134")) < 0) {
            //32.7-37.0	大暴风 12级
            return 12;
        } else if (val.compareTo(new BigDecimal("150")) < 0) {
            //37.0-41.5	飓风 13级
            return 13;
        } else if (val.compareTo(new BigDecimal("167")) < 0) {
            //41.5-46.2	强飓风 14级
            return 14;
        } else if (val.compareTo(new BigDecimal("184")) < 0) {
            //46.2-50.9	猛烈飓风 15级
            return 15;
        } else if (val.compareTo(new BigDecimal("202")) < 0) {
            //50.9-56.1	毁灭性飓风 16级
            return 16;
        } else {
            //56.1-61.3	超级飓风 17级
            return 17;
        }
    }

    public static Timestamp convertStringToTimestamp(String dateStr) {
        LocalDate localDate = LocalDate.parse(dateStr); // 解析 yyyy-MM-dd
        return Timestamp.valueOf(localDate.atStartOfDay()); // 转换为当天的开始时间
    }

    public void download() {
        List<String> areaCodes = new ArrayList<>();
        List<DistrictCodeDO> districtCodeDOList = new ArrayList<>();
        List<DistrictCodeDO> districtCodeDOList1 = new ArrayList<>();
        boolean isApiQuotaExhausted = false; // 引入标志变量
        String startDate = DateUtil.today();
        String endDate = DateUtil.offsetDay(DateUtil.date(), 15).toString("yyyy-MM-dd");
        try {
            List<Entity> dictList = Db.use().findAll("system_dict_data");
            for (Entity entity : dictList) {
                String name = entity.getStr("label");
                if (name.contains("area_code")) {
                    String code = entity.getStr("value");
                    String[] s = code.split(",");
                    areaCodes = Arrays.asList(s);
                }
            }
            List<Entity> districtCodes = Db.use().findAll("jy_district_code");
            for (Entity e : districtCodes) {
                DistrictCodeDO districtCodeDO = new DistrictCodeDO();
                districtCodeDO.setCode(e.getStr("code"));
                districtCodeDO.setName(e.getStr("name"));
                districtCodeDO.setLevel(Integer.parseInt(e.getStr("level")));
                districtCodeDO.setType(Integer.parseInt(e.getStr("type")));
                districtCodeDO.setAbname(e.getStr("abname"));
                districtCodeDO.setPid(Integer.parseInt(e.getStr("pid")));
                districtCodeDO.setLat(!Objects.equals(e.getStr("lat"), "") && e.getStr("lat") != null ? new BigDecimal(e.getStr("lat")).setScale(6, RoundingMode.HALF_UP).doubleValue() : 0d);
                districtCodeDO.setLng(!Objects.equals(e.getStr("lng"), "") && e.getStr("lng") != null ? new BigDecimal(e.getStr("lng")).setScale(6, RoundingMode.HALF_UP).doubleValue() : 0d);
                districtCodeDOList.add(districtCodeDO);
            }
            List<Entity> districtCodes1 = Db.use().findAll("jy_power_station");
            for (Entity e : districtCodes1) {
                DistrictCodeDO districtCodeDO = new DistrictCodeDO();
                districtCodeDO.setCode(e.getStr("code"));
                districtCodeDO.setName(e.getStr("name"));
                districtCodeDO.setLat(!Objects.equals(e.getStr("lat"), "") && e.getStr("lat") != null ? new BigDecimal(e.getStr("lat")).setScale(6, RoundingMode.HALF_UP).doubleValue() : 0d);
                districtCodeDO.setLng(!Objects.equals(e.getStr("lng"), "") && e.getStr("lng") != null ? new BigDecimal(e.getStr("lng")).setScale(6, RoundingMode.HALF_UP).doubleValue() : 0d);
                districtCodeDOList1.add(districtCodeDO);
            }
            String jdbcUrl = "jdbc:TAOS://192.168.12.241:29500/etadm_local?user=root&password=taosdata";
            Properties connProps = new Properties();
            connProps.setProperty(TSDBDriver.PROPERTY_KEY_CHARSET, "UTF-8");
            connProps.setProperty(TSDBDriver.PROPERTY_KEY_LOCALE, "en_US.UTF-8");
            connProps.setProperty(TSDBDriver.PROPERTY_KEY_TIME_ZONE, "UTC-8");
            Connection conn = DriverManager.getConnection(jdbcUrl, connProps);
            //省份
            for (String code : areaCodes) {
                //只有甘肃用xmo天气日接口
                if (code.equals("620000")) {
                    if (isApiQuotaExhausted) break; // 检查标志变量
                    List<DistrictCodeDO> shiList = districtCodeDOList.stream().filter(item -> item.getPid().toString().equals(code)).collect(Collectors.toList());
                    //市
                    for (DistrictCodeDO d : shiList) {
                        if (isApiQuotaExhausted) break; // 检查标志变量
                        List<DistrictCodeDO> quList = districtCodeDOList.stream().filter(item -> item.getPid().toString().equals(d.getCode())).collect(Collectors.toList());
                        String xmoUrl;
                        //xmo综合数据查询
                        xmoUrl = "https://weather-api.xm-opt.com/v1/forecastDaily?latitude=" + d.getLat() + "&longitude=" + d.getLng() + "&daily=weather_code,temperature_2m_max,rain_sum,wind_speed_10m_max,wind_direction_10m_dominant,shortwave_radiation_sum,temperature_2m_min,precipitation_sum&timezone=Asia%2FShanghai&start_date=" + startDate + "&end_date=" + endDate;
                        isApiQuotaExhausted = analysisXMO(xmoUrl, d.getCode(), d.getName(), conn); // 传递标志变量
                        if (isApiQuotaExhausted) break; // 检查标志变量
                        //区
                        for (DistrictCodeDO q : quList) {
                            if (isApiQuotaExhausted) break; // 检查标志变量
                            xmoUrl = "https://weather-api.xm-opt.com/v1/forecastDaily?latitude=" + q.getLat() + "&longitude=" + q.getLng() + "&daily=weather_code,temperature_2m_max,rain_sum,wind_speed_10m_max,wind_direction_10m_dominant,shortwave_radiation_sum,temperature_2m_min,precipitation_sum&timezone=Asia%2FShanghai&start_date=" + startDate + "&end_date=" + endDate;
                            isApiQuotaExhausted = analysisXMO(xmoUrl, q.getCode(), q.getName(), conn); // 传递标志变量
                            if (isApiQuotaExhausted) break; // 检查标志变量
                            //线程睡5秒 防止请求过快
                            //花钱了 硬气 不管他
                            //Thread.sleep(5000);
                        }
                    }
                    //2025-07-18 新增 甘肃库里 powerstation表里场站的经纬度也获取数据, td表的tag是场站编号而不是地区编号
                    for (DistrictCodeDO d : districtCodeDOList1) {
                        String xmoUrl = "https://weather-api.xm-opt.com/v1/forecastDaily?latitude=" + d.getLat() + "&longitude=" + d.getLng() + "&daily=weather_code,temperature_2m_max,rain_sum,wind_speed_10m_max,wind_direction_10m_dominant,shortwave_radiation_sum,temperature_2m_min,precipitation_sum&timezone=Asia%2FShanghai&start_date=" + startDate + "&end_date=" + endDate;
                        if (isApiQuotaExhausted) break; // 检查标志变量
                        isApiQuotaExhausted = analysisXMO(xmoUrl, d.getCode(), d.getName(), conn); // 传递标志变量
                        if (isApiQuotaExhausted) break; // 检查标志变量
                    }
                } else {
                    if (isApiQuotaExhausted) break; // 检查标志变量
                    List<DistrictCodeDO> shiList = districtCodeDOList.stream().filter(item -> item.getPid().toString().equals(code)).collect(Collectors.toList());
                    //市
                    for (DistrictCodeDO d : shiList) {
                        if (isApiQuotaExhausted) break; // 检查标志变量
                        List<DistrictCodeDO> quList = districtCodeDOList.stream().filter(item -> item.getPid().toString().equals(d.getCode())).collect(Collectors.toList());
                        String caiyun;
                        //彩云综合数据查询
                        caiyun = "https://api.caiyunapp.com/v2.6/SRQIFijX5MGtdmhe/" + d.getLng() + "," + d.getLat() + "/weather?alert=true&dailysteps=7&hourlysteps=72";
                        isApiQuotaExhausted = analysis(caiyun, d.getCode(), d.getName(), conn); // 传递标志变量
                        if (isApiQuotaExhausted) break; // 检查标志变量
                        //区
                        for (DistrictCodeDO q : quList) {
                            if (isApiQuotaExhausted) break; // 检查标志变量
                            caiyun = "https://api.caiyunapp.com/v2.6/SRQIFijX5MGtdmhe/" + q.getLng() + "," + q.getLat() + "/weather?alert=true&dailysteps=7&hourlysteps=72";
                            isApiQuotaExhausted = analysis(caiyun, q.getCode(), q.getName(), conn); // 传递标志变量
                            if (isApiQuotaExhausted) break; // 检查标志变量
                            //线程睡5秒 防止请求过快
                            //花钱了 硬气 不管他
                            //Thread.sleep(5000);
                        }
                    }
                }
            }
            conn.close();
            String alarm = "电力交易系统在获取日级天气数据时报错, 彩云天气API 额度已用尽";
            String description = "接口调用异常";
            if (isApiQuotaExhausted) {
                //给企业微信发送消息
                weixinPush.sendMessageBot(alarm, description);
            } else {
                alarm = "电力交易系统每日天气数据全部下载完毕";
                description = "接口调用成功";
                weixinPush.sendMessageBot(alarm, description);
                log.info("每日天气数据全部下载完毕");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public boolean analysis(String caiyun, String areaCode, String name, Connection conn) {
        log.info("开始下载地区:{} 的天气数据", name);
        try {
            Statement ps = conn.createStatement();
            String caiyunBody = HttpUtil.createGet(caiyun).execute().charset("utf-8").body();
            JSONObject caiyunjsonObject = JSONUtil.parseObj(caiyunBody);
            if (caiyunjsonObject.toString().contains("API quota is exhausted")) {
                return true;
            }
            JSONObject caiyunResult = JSONUtil.parseObj(caiyunjsonObject.get("result"));
            //小时数据 72小时
            /*JSONObject hourly = JSONUtil.parseObj(caiyunResult.get("hourly"));
            //小时->温度
            JSONArray temperature = JSONUtil.parseArray(hourly.get("temperature"));
            //小时->辐照度
            JSONArray dswrf = JSONUtil.parseArray(hourly.get("dswrf"));
            //小时->风速
            JSONArray windSpeed = JSONUtil.parseArray(hourly.get("wind"));
            //小时->天气标识
            JSONArray skyconHour = JSONUtil.parseArray(hourly.get("skycon"));
            //小时->湿度
            JSONArray humidityHour = JSONUtil.parseArray(hourly.get("humidity"));
            //小时->压强
            JSONArray pressureHour = JSONUtil.parseArray(hourly.get("pressure"));*/
            //日数据 7d
            JSONObject daily = JSONUtil.parseObj(caiyunResult.get("daily"));
            //日->辐照度
            JSONArray dswrfDay = JSONUtil.parseArray(daily.get("dswrf"));
            //日->温度
            JSONArray temperatureDay = JSONUtil.parseArray(daily.get("temperature"));
            //日->风速 8点到20点
            JSONArray windSpeed8Day = JSONUtil.parseArray(daily.get("wind_08h_20h"));
            //日->风速 20点到32点
            JSONArray windSpeed20Day = JSONUtil.parseArray(daily.get("wind_20h_32h"));
            //日->天气描述 8点到20点
            JSONArray skycon8 = JSONUtil.parseArray(daily.get("skycon_08h_20h"));
            //日->天气描述 20点到32点
            JSONArray skycon20 = JSONUtil.parseArray(daily.get("skycon_20h_32h"));
            //小时数据写入。  时间 风速 辐照度
            /*List<HeFengHour> heFengHourList = new ArrayList<>();
            if (windSpeed.size() == 72 && dswrf.size() == 72 && temperature.size() == 72) {
                for (int i = 0; i < windSpeed.size(); i++) {
                    String time = ((JSONObject) windSpeed.get(i)).get("datetime").toString();
                    HeFengHour heFengHour = new HeFengHour();
                    heFengHour.setTs(getTimestamp(time));
                    heFengHour.setWindSpeed(new BigDecimal(((JSONObject) windSpeed.get(i)).get("speed").toString()).floatValue());
                    heFengHour.setWindSpeedM(new BigDecimal(((JSONObject) windSpeed.get(i)).get("speed").toString()).floatValue() * 1000 / 3600);
                    heFengHour.setWindScale(speedLevel(((JSONObject) windSpeed.get(i)).get("speed").toString()));
                    heFengHour.setWind360(new BigDecimal(((JSONObject) windSpeed.get(i)).get("direction").toString()).floatValue());
                    heFengHour.setHumidity(new BigDecimal(((JSONObject) humidityHour.get(i)).get("value").toString()).floatValue());
                    heFengHour.setPressure(new BigDecimal(((JSONObject) pressureHour.get(i)).get("value").toString()).floatValue());
                    heFengHour.setText(skycon(((JSONObject) skyconHour.get(i)).get("value").toString()));
                    heFengHour.setDswrf(new BigDecimal(((JSONObject) dswrf.get(i)).get("value").toString()).floatValue());
                    heFengHour.setTemp(new BigDecimal(((JSONObject) temperature.get(i)).get("value").toString()).floatValue());
                    heFengHourList.add(heFengHour);
                }
            } else {
                log.info("{} 的彩云小时数据不足72小时,不入库!", name);
            }*/
            //日数据写入
            List<HeFengDay> heFengDayList = new ArrayList<>();
            if (windSpeed8Day.size() == 7 && windSpeed20Day.size() == 7 && skycon8.size() == 7 && skycon20.size() == 7 && dswrfDay.size() == 7 & temperatureDay.size() == 7) {
                for (int i = 0; i < windSpeed8Day.size(); i++) {
                    String time = ((JSONObject) windSpeed8Day.get(i)).get("date").toString();
                    //白天风速
                    Map windspeedDay = (Map) ((JSONObject) windSpeed8Day.get(i)).get("avg");
                    String windspeedDay1 = windspeedDay.get("speed").toString();
                    //白天风向
                    String wind360Day1 = windspeedDay.get("direction").toString();
                    //夜间风速
                    Map windspeedNight = (Map) ((JSONObject) windSpeed20Day.get(i)).get("avg");
                    String windspeedNight1 = windspeedNight.get("speed").toString();
                    String wind360Night1 = windspeedNight.get("direction").toString();
                    //辐照度
                    String dswrf1 = ((JSONObject) dswrfDay.get(i)).get("avg").toString();
                    //白天天气
                    String skycon = ((JSONObject) skycon8.get(i)).get("value").toString();
                    //夜间天气
                    String skyconN = ((JSONObject) skycon20.get(i)).get("value").toString();
                    //最高温度
                    String temperatureMax = ((JSONObject) temperatureDay.get(i)).get("max").toString();
                    //最低温度
                    String temperatureMin = ((JSONObject) temperatureDay.get(i)).get("min").toString();
                    HeFengDay heFengDay = new HeFengDay();
                    heFengDay.setTs(getTimestamp(time));
                    heFengDay.setWindSpeedDay(new BigDecimal(windspeedDay1).floatValue());
                    heFengDay.setWindSpeedMDay(new BigDecimal(windspeedDay1).floatValue() * 1000 / 3600);
                    heFengDay.setWind360Day(new BigDecimal(wind360Day1).floatValue());
                    heFengDay.setWindScaleDay(speedLevel(windspeedDay1));
                    heFengDay.setWindSpeedNight(new BigDecimal(windspeedNight1).floatValue());
                    heFengDay.setWindSpeedMNight(new BigDecimal(windspeedNight1).floatValue() * 1000 / 3600);
                    heFengDay.setWind360Night(new BigDecimal(wind360Night1).floatValue());
                    heFengDay.setWindScaleNight(speedLevel(windspeedNight1));
                    heFengDay.setDswrf(new BigDecimal(dswrf1).floatValue());
                    heFengDay.setTextDay(skycon(skycon));
                    heFengDay.setTextNight(skycon(skyconN));
                    heFengDay.setTempMax(new BigDecimal(temperatureMax).floatValue());
                    heFengDay.setTempMin(new BigDecimal(temperatureMin).floatValue());
                    heFengDayList.add(heFengDay);
                }
            } else {
                log.info("{} 的彩云日数据不足7天,不入库!", name);
            }
            /*for (HeFengHour item : heFengHourList) {
                String insertSql = " INSERT INTO hefeng_hour_unit_" + areaCode + " USING hefeng_hour_unit TAGS('" + areaCode + "') values('" + item.getTs() + "', " + item.getTemp() + ", '" + item.getText() + "', '" + item.getWindDir() + "', " + item.getWind360() + ", " + item.getWindSpeed()  + ", " + item.getWindScale() + ", " + item.getHumidity() + ", " + item.getCloud() + ", " + item.getPrecip() + ", " + item.getDew() + ", " + item.getPressure() + ", " + item.getDswrf() +", " + item.getWindSpeedM()+ ")";
                int affectedRows = ps.executeUpdate(insertSql);
            }*/
            for (HeFengDay item : heFengDayList) {
                String insertSQL = "INSERT INTO hefeng_day_unit_" + areaCode + " USING hefeng_day_unit TAGS('" + areaCode + "')  values('" + item.getTs() + "', " + item.getTempMax() + ", " + item.getTempMin() + ", '" + item.getTextDay() + "', '" + item.getTextNight() + "', " + item.getWind360Day() + ", '" + item.getWindDirDay() + "', " + item.getWindScaleDay() + ", " + item.getWindSpeedDay() + ", " + item.getWind360Night() + ", '" + item.getWindDirNight() + "', " + item.getWindScaleNight() + ", " + item.getWindSpeedNight() + ", " + item.getHumidity() + ", " + item.getPrecip() + ", " + item.getPressure() + ", " + item.getDswrf() + ", " + item.getWindSpeedMDay() + ", " + item.getWindSpeedMNight() + ")";
                int affectedRows = ps.executeUpdate(insertSQL);
            }
            if (ps != null)
                ps.close();
        } catch (Exception e) {
            log.error("彩云天气,地区:{} 日天气数据下载失败JSON格式化错误", name);
            return true;
        }
        log.info("彩云天气,地区:{} 日天气数据下载完成", name);
        return false;
    }

    public boolean analysisXMO(String xmoUrl, String areaCode, String name, Connection conn) {
        log.info("开始下载地区:{} 的天气数据", name);
        try {
            Statement ps = conn.createStatement();
            String body = HttpUtil.createGet(xmoUrl).header("apikey", "c615a8f6-f5dd-4a81-86fe-db2a42862c15").execute().charset("utf-8").body();
            //String body = HttpUtil.createGet(xmoUrl).header("apikey", "51bcabf8-3a5e-41e9-8bf2-b7676936cb22").execute().charset("utf-8").body();
            JSONObject jsonObject = JSONUtil.parseObj(body);
            //log.info("获取到的数据为:{}", body);
            if (jsonObject.toString().contains("API call limit has been reached")) {
                return true;
            }
            //日数据 7d
            JSONObject daily = JSONUtil.parseObj(jsonObject.get("daily"));
            //日期
            JSONArray date = JSONUtil.parseArray(daily.get("time"));
            //日->辐照度
            JSONArray dswrfDay = JSONUtil.parseArray(daily.get("shortwave_radiation_sum"));
            //日->风速
            JSONArray windSpeedDay = JSONUtil.parseArray(daily.get("wind_speed_10m_max"));
            //雨量
            JSONArray precip = JSONUtil.parseArray(daily.get("rain_sum"));
            //2m温度
            JSONArray temp = JSONUtil.parseArray(daily.get("temperature_2m_max"));
            JSONArray tempMin = JSONUtil.parseArray(daily.get("temperature_2m_min"));
            JSONArray precipitationSum = JSONUtil.parseArray(daily.get("precipitation_sum"));
            //10米风向
            JSONArray direction = JSONUtil.parseArray(daily.get("wind_direction_10m_dominant"));
            //天气代码
            JSONArray code = JSONUtil.parseArray(daily.get("weather_code"));
            //日数据写入
            List<HeFengDay> heFengDayList = new ArrayList<>();
            if (date.size() == 16) {
                for (int i = 0; i < date.size(); i++) {
                    String time = date.get(i).toString();
                    HeFengDay heFengDay = new HeFengDay();
                    heFengDay.setTs(convertStringToTimestamp(time));
                    heFengDay.setWindSpeedDay(windSpeedDay.get(i).toString().equals("null") ? -0.99f : new BigDecimal(windSpeedDay.get(i).toString()).floatValue());
                    heFengDay.setWindSpeedMDay(windSpeedDay.get(i).toString().equals("null") ? -0.99f : new BigDecimal(windSpeedDay.get(i).toString()).floatValue() * 1000 / 3600);
                    heFengDay.setWindScaleDay(speedLevel(windSpeedDay.get(i).toString().equals("null") ? "0" : windSpeedDay.get(i).toString()));
                    heFengDay.setWind360Day(direction.get(i).toString().equals("null") ? -0.99f : new BigDecimal(direction.get(i).toString()).floatValue());
                    heFengDay.setPrecip(precip.get(i).toString().equals("null") ? -0.99f : new BigDecimal(precip.get(i).toString()).floatValue());
                    heFengDay.setTextDay(ConversionWeatherCodeXmo(code.get(i).toString().equals("null") ? "0" : code.get(i).toString()));
                    heFengDay.setTempMax(temp.get(i).toString().equals("null") ? -0.99f : new BigDecimal(temp.get(i).toString()).floatValue());
                    heFengDay.setTempMin(tempMin.get(i).toString().equals("null") ? -0.99f : new BigDecimal(tempMin.get(i).toString()).floatValue());
                    heFengDay.setHumidity(precipitationSum.get(i).toString().equals("null") ? -0.99f : new BigDecimal(precipitationSum.get(i).toString()).floatValue());
                    heFengDay.setDswrf(dswrfDay.get(i).toString().equals("null") ? -0.99f : new BigDecimal(dswrfDay.get(i).toString()).floatValue());
                    heFengDayList.add(heFengDay);
                }
            } else {
                log.info("{} 的曦谋日数据不足16天,不入库!", name);
            }
            for (HeFengDay item : heFengDayList) {
                String insertSQL = "INSERT INTO hefeng_day_unit_" + areaCode + " USING hefeng_day_unit TAGS('" + areaCode + "')  " +
                        "(ts,wind_speed_day,wind_speed_m_day,wind_scale_day,wind_360_Day,precip,text_day,temp_max,temp_min,humidity,dswrf) values('"
                        + item.getTs() + "', " + item.getWindSpeedDay() + ", " + item.getWindSpeedMDay() + ", " + item.getWindScaleDay() + ", " + item.getWind360Day() + ", "
                        + item.getPrecip() + ", '" + item.getTextDay() + "', " + item.getTempMax() + ", " + item.getTempMin() + ", " + item.getHumidity() + ", "
                        + item.getDswrf() + ")";
                SimpleDateFormat simpleFormatter = new SimpleDateFormat("yyyy-MM-dd");
                String insertSnap = "INSERT INTO weather_day_snap_" + areaCode + "_" + simpleFormatter.format(new Date()) + " USING hefeng_day_unit TAGS('" + areaCode + "','" + simpleFormatter.format(new Date()) + "')  " +
                        "(ts,wind_speed_day,wind_speed_m_day,wind_scale_day,wind_360_Day,precip,text_day,temp_max,temp_min,humidity,dswrf) values('"
                        + item.getTs() + "', " + item.getWindSpeedDay() + ", " + item.getWindSpeedMDay() + ", " + item.getWindScaleDay() + ", " + item.getWind360Day() + ", "
                        + item.getPrecip() + ", '" + item.getTextDay() + "', " + item.getTempMax() + ", " + item.getTempMin() + ", " + item.getHumidity() + ", "
                        + item.getDswrf() + ")";
                int affectedRows = ps.executeUpdate(insertSQL);
            }
            if (ps != null)
                ps.close();
        } catch (Exception e) {
            log.error("曦谋天气,地区:{} 日天气数据下载失败JSON格式化错误", name);
            return true;
        }
        log.info("曦谋天气,地区:{} 日天气数据下载完成", name);
        return false;
    }

    private Timestamp getTimestamp(String time) {
        // 解析字符串为 ZonedDateTime
        ZonedDateTime zonedDateTime = ZonedDateTime.parse(time);
        // 将 ZonedDateTime 转换为 Instant
        Instant instant = zonedDateTime.toInstant();
        // 将 Instant 转换为 Timestamp
        return Timestamp.from(instant);
    }

    /**
     * 根据代码获取对应天气描述
     *
     * @param skycon
     * @return
     */
    private String skycon(String skycon) {
        switch (skycon) {
            case "CLEAR_DAY":
            case "CLEAR_NIGHT":
                return "晴";
            case "PARTLY_CLOUDY_DAY":
            case "PARTLY_CLOUDY_NIGHT":
                return "多云";
            case "CLOUDY":
                return "阴";
            case "LIGHT_HAZE":
                return "轻度雾霾";
            case "MODERATE_HAZE":
                return "中度雾霾";
            case "HEAVY_HAZE":
                return "重度雾霾";
            case "LIGHT_RAIN":
                return "小雨";
            case "MODERATE_RAIN":
                return "中雨";
            case "HEAVY_RAIN":
                return "大雨";
            case "STORM_RAIN":
                return "暴雨";
            case "FOG":
                return "雾";
            case "LIGHT_SNOW":
                return "小雪";
            case "MODERATE_SNOW":
                return "中雪";
            case "HEAVY_SNOW":
                return "大雪";
            case "STORM_SNOW":
                return "暴雪";
            case "DUST":
                return "浮尘";
            case "SAND":
                return "沙尘";
            case "WIND":
                return "大风";
        }
        return "晴";
    }

    private String ConversionWeatherCodeXmo(String code) {
        switch (code) {
            case "0":
                return "晴";
            case "1":
                return "多云";
            case "2":
                return "少云";
            case "3":
                return "阴";
            case "45":
                return "雾";
            case "48":
                return "冻雾";
            case "51":
            case "53":
            case "55":
                return "毛毛雨";
            case "56":
            case "57":
                return "冻毛毛雨";
            case "61":
                return "小雨";
            case "63":
                return "中雨";
            case "65":
                return "大雨";
            case "66":
            case "67":
                return "冻雨";
            case "71":
                return "小雪";
            case "73":
                return "中雪";
            case "75":
                return "大雪";
            case "77":
                return "雪粒";
            case "80":
                return "小阵雨";
            case "81":
                return "阵雨";
            case "82":
                return "强阵雨";
            case "85":
                return "小阵雪";
            case "86":
                return "阵雪";
            case "95":
                return "雷雨";
            case "96":
            case "99":
                return "雷雨伴有冰雹";
            default:
                return "晴"; // 默认返回晴
        }
    }
}