根据城市名，获取sh_area表中经纬度并显示

jinpengyong

2020-08-24 11dc24b3492b034a4c40e122d08b3ceeeaa57cb6

 src/main/java/com/moral/service/impl/WeatherServiceImpl.java

@@ -1,5 +1,7 @@
package com.moral.service.impl;



import java.math.BigDecimal;

import java.text.DecimalFormat;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

@@ -37,6 +39,7 @@
import com.moral.mapper.MonitorPointMapper;

import com.moral.mapper.ProvinceMapper;

import com.moral.mapper.RealWeatherMapper;

import com.moral.mapper.ShAreaMapper;

import com.moral.service.OrganizationService;

import com.moral.service.WeatherService;



@@ -72,6 +75,9 @@


    @Resource

    private HistoryHourlyMapper historyHourlyMapper;



    @Resource

    private ShAreaMapper shAreaMapper;



    @Override

    public Map<String, Object> getWeatherDataByRegion(Map<String, Object> parameters) {

@@ -176,6 +182,7 @@


    @Override

    public List<Map<String, Object>> getForecastAndReal(Map<String, Object> parameters) throws ParseException {

        parameters.put("typeFormat", "%Y-%m-%d %H:%i:%s");

        String monitorPointId = parameters.get("monitorPointId").toString();

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        String time = parameters.get("time").toString() + " 00:00:00";

@@ -187,17 +194,17 @@
        String nextDay = sdf.format(c.getTime());

        parameters.put("start", sdf.parse(time));

        parameters.put("end", sdf.parse(nextDay));

        List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecastHour(parameters);

        MonitorPoint monitorPoint = monitorPointMapper.selectByPrimaryKey(Integer.valueOf(monitorPointId));

        parameters.put("areaCode", monitorPoint.getAreaCode());

        String sensors = "O3C";

        String sensor1 = "O3";

        parameters.put("sensors", sensors);

        parameters.put("sensors1", sensor1);

        parameters.put("sensors2", sensor1);

        if (monitorPoint.getAreaCode() == null) {

            parameters.put("cityCode", monitorPoint.getCityCode());

        } else {

            parameters.put("cityCode", monitorPoint.getAreaCode());

        }

        List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters);

        List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecastHour(parameters);



        if (aqiList.size() == 0) {

            parameters.put("areaCode", monitorPoint.getCityCode());

            parameters.put("cityCode", monitorPoint.getCityCode());

            aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters);

        }

        for (Map<String, Object> map : aqiList) {

@@ -218,7 +225,7 @@
                }

                map.put("time", Integer.valueOf(hour));

                values.add("");

                values.add(aqiMap.get(sensor1).toString());

                values.add(aqiMap.get("O3").toString());

                map.put("values", values);

                resultList.add(map);

            }

@@ -232,8 +239,8 @@
                    hour = "24";

                }

                map.put("time", Integer.valueOf(hour));

                if (forecastMap.get("result") != null) {

                    values.add(forecastMap.get("result").toString().replace("\"", ""));

                if (forecastMap.get("O3") != null) {

                    values.add(forecastMap.get("O3").toString().replace("\"", ""));

                } else {

                    values.add("");

                }

@@ -250,14 +257,14 @@
                    hour = "24";

                }

                map.put("time", Integer.valueOf(hour));

                if (forecastMap.get("result") != null) {

                    values.add(forecastMap.get("result").toString().replace("\"", ""));

                if (forecastMap.get("O3") != null) {

                    values.add(forecastMap.get("O3").toString().replace("\"", ""));

                } else {

                    values.add("");

                }

                for (Map<String, Object> aqiMap : aqiList) {

                    if (forecastMap.get("time").equals(aqiMap.get("time"))) {

                        values.add(aqiMap.get(sensor1).toString());

                        values.add(aqiMap.get("O3").toString());

                    }

                }

                map.put("values", values);

@@ -275,147 +282,183 @@


    @Override

    public List<Map<String, Object>> getWeatherData(Map<String, Object> parameters) throws ParseException {

        parameters.put("typeFormat", "%Y-%m-%d %H:%i:%s");

        String cityName = parameters.get("city").toString();

        Area area = areaMapper.getAreaByName(cityName);

        MonitorPoint monitorPoint;

        Integer areaCode = 0;

        Integer cityCode = 0;

        Integer code = 0;

        String name = "";

        if (area == null) {

            City city = cityMapper.getCityByName(cityName);

            if (city == null) {

                Province province = provinceMapper.getProvinceByName(cityName);

                Integer provinceCode = province.getProvinceCode();

                monitorPoint = monitorPointMapper.getFirstMonitorPointByProvinceCode(provinceCode);

                parameters.put("areaCode", provinceCode);

                parameters.put("city", province.getProvinceName());

                code = province.getProvinceCode();

                name = province.getProvinceName();

            } else {

                cityCode = city.getCityCode();

                monitorPoint = monitorPointMapper.getFirstMonitorPointByCityCode(cityCode);

                parameters.put("areaCode", cityCode);

                parameters.put("city", city.getCityName());

                code = city.getCityCode();

                name = city.getCityName();

            }

        } else {

            areaCode = area.getAreaCode();

            monitorPoint = monitorPointMapper.getFirstMonitorPointByAreaCode(areaCode);

            cityCode = area.getCityCode();

            parameters.put("areaCode", areaCode);

            parameters.put("city", area.getAreaName());

            code = area.getAreaCode();

            name = area.getAreaName();

        }

        if (monitorPoint == null) {

            return new ArrayList<>();

        }

        parameters.put("monitorPointId", monitorPoint.getId());



        parameters.put("cityCode", code);

        parameters.put("name", name);

        String time = parameters.get("time").toString();

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        Date now = new Date();

        Date selectTime = sdf1.parse(time + " 00:00:00");

        Calendar c1 = Calendar.getInstance();

        c1.setTime(selectTime);

        c1.add(Calendar.DAY_OF_MONTH, -1);

        Date beforeDay = c1.getTime();

        String format = sdf.format(beforeDay);

        Calendar c = Calendar.getInstance();

        c.setTime(sdf.parse(time));

        c.add(Calendar.HOUR_OF_DAY, 1);

        Date start = c.getTime();

        c.add(Calendar.DAY_OF_MONTH, 1);

        Date end = c.getTime();

        parameters.put("start", start);

        Date selectTime = sdf1.parse(time + " 01:00:00");

        Calendar cal = Calendar.getInstance();

        cal.setTime(selectTime);

        cal.add(Calendar.DAY_OF_MONTH, 1);

        Date end = cal.getTime();

        cal.setTime(sdf.parse(time));

        Date time1 = cal.getTime();

        cal.add(Calendar.DAY_OF_MONTH, -1);

        String beforeDay = sdf.format(cal.getTime());

        parameters.put("start", selectTime);

        parameters.put("end", end);

        Integer fcode = 0;

        List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecast(parameters);

        if (forecastList.size() == 0) {

            List<Area> areaList = areaMapper.getAreaByCityCode(code);

            for (Area area1 : areaList) {

                if (area1 != null) {

                    parameters.put("cityCode", area1.getAreaCode());

                    fcode = area1.getAreaCode();

                    forecastList = forecastWeatherMapper.getForecast(parameters);

                    if (forecastList.size() != 0) {

                        break;

                    }

                }

            }

        } else {

            fcode = Integer.valueOf(parameters.get("cityCode").toString());

        }



        List<Map<String, Object>> foreList = new ArrayList<>();

        for (Map<String, Object> map : forecastList) {

        for (Map<String, Object> forecastMap : forecastList) {

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("time", map.get("time").toString());

            String ftime = forecastMap.get("time").toString();

            hashMap.put("time", ftime);

            hashMap.put("type", "预测");

            hashMap.put("TVOC", "");

            hashMap.put("altitude", "");

            hashMap.put("vegetation", "");

            hashMap.put("river", "");

            hashMap.put("AQI", "");

            hashMap.put("SO2C", "");

            hashMap.put("NO2C", "");

            hashMap.put("COC", "");

            hashMap.put("O3C", "");

            if (forecastMap.get("O3C") == null) {

                hashMap.put("O3C", "");

            }

            hashMap.put("PM25C", "");

            hashMap.put("PM10C", "");

            hashMap.put("city", parameters.get("city").toString());



            if (selectTime.getTime() <= now.getTime()) {

                hashMap.put("fxTime", (format + " 15:00").substring(5, 16));

            hashMap.put("city", parameters.get("name").toString());

            hashMap.put("code", fcode);

            if (sdf.parse(time).getTime() <= now.getTime()) {

                hashMap.put("fxTime", (beforeDay + " 15:00").substring(5, 16));

            } else {

                String s = sdf1.format(now).split(" ")[1].split(":")[0];

                Integer hour = Integer.valueOf(s);

                if (hour > 15) {

                    hashMap.put("fxTime", (format + " 15:00").substring(5, 16));

                } else if (hour > 7 && hour < 15) {

                    hashMap.put("fxTime", (format + " 07:00").substring(5, 16));

                String format = sdf1.format(now).split(" ")[0];

                Date date1 = sdf1.parse(format + " 07:00:00");

                Date date2 = sdf1.parse(format + " 15:00:00");

                if (now.getTime() > date2.getTime()) {

                    hashMap.put("fxTime", (beforeDay + " 15:00").substring(5, 16));

                } else if (now.getTime() > date1.getTime() && (now.getTime() < date2.getTime() || now.getTime() == date2.getTime())) {

                    hashMap.put("fxTime", (beforeDay + " 07:00").substring(5, 16));

                }

            }

            Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(map.get("json").toString());

            Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(forecastMap.get("json").toString());

            hashMap.putAll(jsonMap);

            foreList.add(hashMap);

        }



        //预测6小时降水量

        for (Map<String, Object> foreMap : foreList) {

            String ftime = foreMap.get("time").toString();

            Calendar calendar = Calendar.getInstance();

            Date endTime = sdf1.parse(ftime);

            calendar.setTime(endTime);

            calendar.add(Calendar.HOUR, -6);

            Date startTime = calendar.getTime();

            cal.setTime(endTime);

            cal.add(Calendar.HOUR, -6);

            Date startTime = cal.getTime();

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString()));

            hashMap.put("start", startTime);

            hashMap.put("end", endTime);

            hashMap.put("monitorPointId", Integer.valueOf(parameters.get("monitorPointId").toString()));

            hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString()));

            Map<String, Object> precip6HourMap = forecastWeatherMapper.getPrecip6Hour(hashMap);

            foreMap.put("precip6", "");

            if (precip6HourMap != null) {

                foreMap.put("precip6", precip6HourMap.get("precip6").toString());

            }

        }



        List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters);

        if (aqiList.size() == 0) {

            parameters.put("areaCode", cityCode);

            aqiList = hangzhouAqiMapper.getAqi(parameters);

        //预测O3C_8H

        for (Map<String, Object> map : foreList) {

            Date endTime = sdf1.parse(map.get("time").toString());

            cal.setTime(endTime);

            cal.add(Calendar.HOUR, -8);

            Date startTime = cal.getTime();

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString()));

            hashMap.put("start", startTime);

            hashMap.put("end", endTime);

            Map<String, Object> O3Map = forecastWeatherMapper.getO38Hours(hashMap);

            if (O3Map != null) {

                Double O3C_8H = Double.valueOf(O3Map.get("O3C_8H").toString());

                map.put("O3C_8H", String.valueOf(Math.round(O3C_8H)));

            }

        }



        String ac = parameters.get("cityCode").toString();

        List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters);

        if (aqiList.size() == 0) {

            parameters.put("cityCode", code);

            aqiList = hangzhouAqiMapper.getAqi(parameters);

            if (aqiList.size() == 0) {

                List<Area> areaList = areaMapper.getAreaByCityCode(code);

                for (Area area1 : areaList) {

                    if (area1 != null) {

                        parameters.put("cityCode", area1.getAreaCode());

                        aqiList = hangzhouAqiMapper.getAqi(parameters);

                        if (aqiList.size() != 0) {

                            break;

                        }

                    }

                }

            }

        }

        DecimalFormat df = new DecimalFormat(".####");

        List<Map<String, Object>> realAqilist = new ArrayList<>();

        for (Map<String, Object> aqiMap : aqiList) {

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("time", aqiMap.get("time"));

            Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(aqiMap.get("json").toString());

            hashMap.putAll(jsonMap);

            hashMap.put("city", parameters.get("city").toString());

            hashMap.put("city", parameters.get("name").toString());

            realAqilist.add(hashMap);

        }



        for (Map<String, Object> map : realAqilist) {

            Date endTime = sdf1.parse(map.get("time").toString());

            c.setTime(endTime);

            c.add(Calendar.HOUR, -8);

            Date startTime = c.getTime();

            String rtime = map.get("time").toString();

            Date endTime = sdf1.parse(rtime);

            cal.setTime(endTime);

            cal.add(Calendar.HOUR, -8);

            Date startTime = cal.getTime();

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString()));

            hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString()));

            hashMap.put("start", startTime);

            hashMap.put("end", endTime);

            Map<String, Object> O3Map = hangzhouAqiMapper.getAvgO3EightHours(hashMap);

            map.put("O3_8H", O3Map.get("O3_8H").toString());

            if (O3Map.get("O3C_8H") != null) {

                map.put("O3C_8H", O3Map.get("O3C_8H").toString());

            }

            map.put("O3C_8H", O3Map.get("O3C_8H").toString());

        }



        //光照

        String code = parameters.get("areaCode").toString();

        Map<String, Object> params = new HashMap<>();

        if (code.endsWith("00")) {

            params.put("cityCode", Integer.valueOf(code));

        if (ac.endsWith("00")) {

            params.put("cityCode", Integer.valueOf(ac));

        } else {

            params.put("areaCode", Integer.valueOf(code));

            params.put("areaCode", Integer.valueOf(ac));

        }



        List<MonitorPoint> monitorList = monitorPointMapper.getMonitorList(params);



        List<Integer> pointList = new ArrayList<>();

@@ -423,21 +466,35 @@
            Integer pointId = point.getId();

            pointList.add(pointId);

        }



        List<Device> deviceList = deviceMapper.getDeviceListByMonitorPointIds(pointList);

        List<String> macList = new ArrayList<>();

        List<String> macList1 = new ArrayList<>();

        List<Map<String, Object>> beamList = new ArrayList<>();

        List<Map<String, Object>> tvocList = new ArrayList<>();

        if (deviceList.size() != 0) {

            for (Device device : deviceList) {

                String mac = device.getMac();

                macList.add(mac);

                macList.add(device.getMac());

            }



            parameters.put("macs", macList);

            beamList = historyHourlyMapper.getBeamByMacs(parameters);

            Map<String, Object> map = new HashMap<>();

            if (name.equals("沧州市")) {

                List<Integer> list = new ArrayList<>();

                list.add(48);

                List<Device> pointIds = deviceMapper.getDeviceListByMonitorPointIds(list);

                for (Device device : pointIds) {

                    if (device.getId() != 1075) {

                        macList1.add(device.getMac());

                    }

                }

            } else {

                macList1 = macList;

            }

            map.put("macs", macList1);

            map.put("start", parameters.get("start"));

            map.put("end", parameters.get("end"));

            tvocList = historyHourlyMapper.getTVOCByMacs(map);

        }





        List<Map<String, Object>> realList = realWeatherMapper.getRealWeather(parameters);

        List<Map<String, Object>> realWeatherList = new ArrayList<>();

        for (Map<String, Object> realMap : realList) {

@@ -445,7 +502,7 @@
            hashMap.put("time", realMap.get("time"));

            Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(realMap.get("json").toString());

            hashMap.putAll(jsonMap);

            hashMap.put("city", parameters.get("city").toString());

            hashMap.put("city", parameters.get("name").toString());

            realWeatherList.add(hashMap);

        }



@@ -454,21 +511,35 @@
            for (Map<String, Object> beamMap : beamList) {

                String btime = beamMap.get("time").toString();

                if (btime.equals(rtime)) {

                    realMap.put("beam", beamMap.get("beam").toString());

                    realMap.put("beam", Math.floor((Double) beamMap.get("beam")));

                }

            }

            Calendar calendar = Calendar.getInstance();



            Date endTime = sdf1.parse(rtime);

            calendar.setTime(endTime);

            calendar.add(Calendar.HOUR, -6);

            Date startTime = calendar.getTime();

            cal.setTime(endTime);

            cal.add(Calendar.HOUR, -6);

            Date startTime = cal.getTime();

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString()));

            hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString()));

            hashMap.put("start", startTime);

            hashMap.put("end", endTime);

            hashMap.put("monitorPointId", Integer.valueOf(parameters.get("monitorPointId").toString()));



            Map<String, Object> precip6HourMap = realWeatherMapper.getPrecip6Hour(hashMap);

            realMap.put("precip6", precip6HourMap.get("precip6").toString());



            if (precip6HourMap != null) {

                realMap.put("precip6", precip6HourMap.get("precip6").toString());

            }



            for (Map<String, Object> tvocMap : tvocList) {

                String ttime = tvocMap.get("time").toString();

                if (ttime.equals(rtime)) {

                    Double tvoc = Double.valueOf(tvocMap.get("TVOC").toString());

                    BigDecimal bd = new BigDecimal(tvoc);

                    tvoc = bd.setScale(3,BigDecimal.ROUND_HALF_UP).doubleValue();

                    realMap.put("TVOC", tvoc);

                }

            }



        }



        List<Map<String, Object>> list = new ArrayList<>();

@@ -506,13 +577,10 @@
            }

        }





        list.removeAll(Collections.singleton(null));





        for (Map<String, Object> map : list) {

            map.put("type", "实测");

            map.put("city", parameters.get("city").toString());

            map.put("city", parameters.get("name").toString());

        }



        List<Map<String, Object>> resultList = new ArrayList<>();

@@ -525,20 +593,128 @@
                }

            }

        }



        for (int i = list.size(); i < foreList.size(); i++) {

            Map<String, Object> map = foreList.get(i);

            resultList.add(map);

            Map<String, Object> hashMap = new HashMap<>();

            hashMap.put("time", map.get("time").toString());

            hashMap.put("type", "实测");

            hashMap.put("city", parameters.get("city").toString());

            hashMap.put("city", parameters.get("name").toString());

            resultList.add(hashMap);

        }



        for (Map<String, Object> map : resultList) {

            String date = map.get("time").toString().substring(0, 16);

            map.put("time", date);

            if (map.get("AQI") != null) {

                String aqi = map.get("AQI").toString().split("\\.")[0];

                map.put("AQI", aqi);

            }

            if (map.get("precip") != null) {

                String aqi = map.get("precip").toString();

                if (aqi.equals("0.0")) {

                    map.put("precip", "");

                }

            }

            if (map.get("precip6") != null) {

                String aqi = map.get("precip6").toString();

                if (aqi.equals("0.0")) {

                    map.put("precip6", "");

                }

            }

            if ((!map.containsKey("SO2C")) && map.containsKey("SO2")) {

                map.put("SO2C", map.get("SO2").toString());

            }

            if ((!map.containsKey("NO2C")) && map.containsKey("NO2")) {

                map.put("NO2C", map.get("NO2").toString());

            }

            if ((!map.containsKey("O3C")) && map.containsKey("O3")) {

                map.put("O3C", map.get("O3").toString());

            }

            if ((!map.containsKey("COC")) && map.containsKey("CO")) {

                map.put("COC", map.get("CO").toString());

            }

            if ((!map.containsKey("PM25C")) && map.containsKey("PM2_5")) {

                map.put("PM25C", map.get("PM2_5").toString());

            }

            if ((!map.containsKey("PM10C")) && map.containsKey("PM10")) {

                map.put("PM10C", map.get("PM10").toString());

            }

            if (map.get("windScale") != null) {

                String windScale = map.get("windScale").toString().replace("-", "~");

                map.put("windScale", windScale);

            }

        }



        //后4小时保良值

        double value = 160.0 * 8;

        int nowHour = Integer.valueOf(sdf1.format(now).substring(11, 13));

        String format = sdf1.format(now).substring(0, 13) + ":00:00";

        if (nowHour < 8) {

            return resultList;

        }

        for (Map<String, Object> resultMap : resultList) {

            if (resultMap.get("type").equals("实测")) {

                if (sdf.parse(time).getTime() == sdf.parse(sdf.format(now)).getTime()) {

                    String rtime = resultMap.get("time").toString() + ":00";

                    int rhour = Integer.valueOf(rtime.substring(11, 13));

                    cal.setTime(sdf1.parse(rtime));

                    cal.add(Calendar.HOUR_OF_DAY, -7);

                    Date startTime = cal.getTime();

                    Date endTime = sdf1.parse(format);

                    Map<String, Object> hashMap = new HashMap<>();

                    hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString()));

                    hashMap.put("start", startTime);

                    hashMap.put("end", endTime);

                    if (rhour == 0) {

                        rhour = 24;

                    }

                    if (rhour == nowHour) {

                        Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap);

                        double v = value - Double.valueOf(sumO3Map.get("O3Sum").toString());

                        resultMap.put("goodValue", v);

                    } else if (rhour == nowHour + 1) {

                        Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap);

                        double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 2;

                        resultMap.put("goodValue", String.valueOf(Math.round(v)));

                    } else if (rhour == nowHour + 2) {

                        Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap);

                        double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 3;

                        resultMap.put("goodValue", String.valueOf(Math.round(v)));

                    } else if (rhour == nowHour + 3) {

                        Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap);

                        double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 4;

                        resultMap.put("goodValue", String.valueOf(Math.round(v)));

                    }

                }

            }

            if (resultMap.get("O3C_8H") != null && !resultMap.get("O3C_8H").equals("")) {

                Double O3C_8H = Double.valueOf(resultMap.get("O3C_8H").toString());

                resultMap.put("O3C_8H", String.valueOf(Math.round(O3C_8H)));

            }



            if (resultMap.get("PM25C") != null && !resultMap.get("PM25C").equals("")) {

                Double PM25C = Double.valueOf(resultMap.get("PM25C").toString());

                resultMap.put("PM25C", String.valueOf(Math.round(PM25C)));

            }



            if (resultMap.get("PM10C") != null && !resultMap.get("PM10C").equals("")) {

                Double PM10C = Double.valueOf(resultMap.get("PM10C").toString());

                resultMap.put("PM10C", String.valueOf(Math.round(PM10C)));

            }



            if (resultMap.get("O3C") != null && !resultMap.get("O3C").equals("")) {

                Double O3C = Double.valueOf(resultMap.get("O3C").toString());

                resultMap.put("O3C", String.valueOf(Math.round(O3C)));

            }

        }



        Map<String, Object> point = shAreaMapper.getLngAndLat(name);

        for (Map<String, Object> map : resultList) {

            double longitude = Double.valueOf(point.get("lng").toString());

            double latitude = Double.valueOf(point.get("lat").toString());

            map.put("longitude",df.format(longitude));

            map.put("latitude",df.format(latitude));

        }

        return resultList;

    }

@@ -567,32 +743,16 @@
                String time = map.get("time").toString() + ":00";

                Map<String, Object> hashMap = new HashMap<>();

                hashMap.put("time", time);

                String city = map.get("city").toString();

                Area area = areaMapper.getAreaByName(city);

                Map<String, Object> idMap = new HashMap<>();

                if (area == null) {

                    Integer cityCode = cityMapper.getCityByName(city).getCityCode();

                    idMap.put("cityCode", cityCode);

                } else {

                    Integer areaCode = area.getAreaCode();

                    idMap.put("areaCode", areaCode);

                }



                List<MonitorPoint> monitorList = monitorPointMapper.getMonitorList(idMap);

                hashMap.put("cityCode", Integer.valueOf(map.get("code").toString()));

                Map<String, Object> jsonMap = new HashMap<>();

                for (String key : map.keySet()) {

                    if (!key.equals("city") && !key.equals("time") && !key.equals("type") && !key.equals("fxTime")) {

                    if (!key.equals("city") && !key.equals("time") && !key.equals("type") && !key.equals("fxTime") && !key.equals("code")) {

                        String value = map.get(key).toString();

                        jsonMap.put(key, value);

                    }

                }



                String json = JSONObject.toJSONString(jsonMap);

                hashMap.put("json", json);

                for (MonitorPoint monitorPoint : monitorList) {

                    hashMap.put("monitorPointId", monitorPoint.getId());

                    forecastWeatherMapper.updateForecastWeather(hashMap);

                }

                hashMap.put("json", JSONObject.toJSONString(jsonMap));

                forecastWeatherMapper.updateForecastWeather(hashMap);

            }

        }

    }