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

jinpengyong

2020-08-24 11dc24b3492b034a4c40e122d08b3ceeeaa57cb6

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

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



import java.math.BigDecimal;

import java.text.DecimalFormat;

import java.text.ParseException;

import java.text.SimpleDateFormat;

@@ -38,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;



@@ -73,6 +75,9 @@


    @Resource

    private HistoryHourlyMapper historyHourlyMapper;



    @Resource

    private ShAreaMapper shAreaMapper;



    @Override

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

@@ -309,6 +314,7 @@
        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);

@@ -399,7 +405,8 @@
            hashMap.put("end", endTime);

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

            if (O3Map != null) {

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

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

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

            }

        }



@@ -421,16 +428,12 @@
                }

            }

        }

        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());

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

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

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

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

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

            hashMap.putAll(jsonMap);

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

            realAqilist.add(hashMap);

@@ -472,7 +475,6 @@
            for (Device device : deviceList) {

                macList.add(device.getMac());

            }



            parameters.put("macs", macList);

            beamList = historyHourlyMapper.getBeamByMacs(parameters);

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

@@ -531,7 +533,10 @@
            for (Map<String, Object> tvocMap : tvocList) {

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

                if (ttime.equals(rtime)) {

                    realMap.put("TVOC", tvocMap.get("TVOC").toString());

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

                }

            }



@@ -637,7 +642,7 @@
            }

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

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

                map.put("windScale",windScale);

                map.put("windScale", windScale);

            }

        }



@@ -650,38 +655,69 @@
        }

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

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

                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 == 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", 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", 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", v);

                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;

    }





    @Override

    public void updateForecastWeather(Map<String, Object> parameters) {