根据小时不同天气预测o3,光照

jinpengyong

2020-08-27 32983a583c99c190ecb4361d72b6f13cd06fefc7

根据小时不同天气预测o3,光照

 src/main/java/com/moral/mapper/DeviceMapper.java

@@ -35,4 +35,7 @@
    List<String> getMacByOrganizationid(@Param("organizationIdList") List<Object> organizationIdList);

    List<Map<String, Object>> macAndOrganizationIdMap(@Param("macs") List<String> macs);

    List<String> getMacsByMonitorPointIds(List<Integer> list);

}

 src/main/java/com/moral/mapper/HistoryHourlyMapper.java

@@ -15,4 +15,6 @@

    int insertHistoryO3Hourly(@Param("list") List<Map<String, Object>> list);

    List<Map<String,Object>> getBeamByMacs(Map<String,Object> params);

}

 src/main/java/com/moral/mapper/MonitorPointMapper.java

@@ -1,10 +1,13 @@
package com.moral.mapper;

import java.util.List;
import java.util.Map;

import com.moral.entity.MonitorPoint;

public interface MonitorPointMapper {

    List<MonitorPoint> getMonitorPointList();

    List<Integer>  getMonitorList(Map<String, Object> params);
}

 src/main/java/com/moral/mapper/RealWeatherMapper.java

@@ -7,5 +7,6 @@

    int insertRealWeather(List<Map<String,Object>> list);

    List<Map<String,Object>> getTemp(Map<String,Object> params);
    List<Map<String,Object>> getTempAndCloud(Map<String,Object> params);

}

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

@@ -25,7 +25,9 @@
import com.moral.mapper.AQIMapper;
import com.moral.mapper.AreaMapper;
import com.moral.mapper.CityMapper;
import com.moral.mapper.DeviceMapper;
import com.moral.mapper.ForecastWeatherMapper;
import com.moral.mapper.HistoryHourlyMapper;
import com.moral.mapper.MonitorPointMapper;
import com.moral.mapper.ProvinceMapper;
import com.moral.mapper.RealWeatherMapper;
@@ -55,6 +57,12 @@

    @Resource
    private AQIMapper aqiMapper;

    @Resource
    private DeviceMapper deviceMapper;

    @Resource
    private HistoryHourlyMapper historyHourlyMapper;

    @Override
    public int insertForecastWeather() throws ParseException {
@@ -142,98 +150,6 @@
        Date endTime = sdf.parse(sdf.format(c.getTime()));
        c.add(Calendar.MONTH, -2);
        Date startTime = sdf.parse(sdf.format(c.getTime()));

        for (Map<String, Object> hashmap : hashSet) {
            Map<String, Object> map1 = new HashMap<>();
            map1.put("typeFormat", "%Y-%m-%d %H:%i:%s");
            map1.put("startTime", startTime);
            map1.put("endTime", endTime);
            hashmap.put("typeFormat", "%Y-%m-%d %H:%i:%s");
            hashmap.put("startTime", startTime);
            hashmap.put("endTime", endTime);
            map1.put("cityCode", Integer.valueOf(hashmap.get("cityCode").toString()));
            List<List<Map<String, Object>>> list1 = new ArrayList<>();
            List<List<Map<String, Object>>> list2 = new ArrayList<>();

            for (int i = 0; i < 24; i++) {
                List<Map<String, Object>> list3 = new ArrayList<>();
                List<Map<String, Object>> list4 = new ArrayList<>();
                if (i < 10) {
                    map1.put("time", "0" + i + ":00:00");
                    hashmap.put("time", "0" + i + ":00:00");
                } else {
                    map1.put("time", i + ":00:00");
                    hashmap.put("time", i + ":00:00");
                }
                List<Map<String, Object>> tempList = realWeatherMapper.getTemp(hashmap);
                List<Map<String, Object>> O3List = aqiMapper.getO3(map1);
                if (O3List.size() == 0) {
                    map1.put("cityCode", Integer.valueOf(hashmap.get("parentCode").toString()));
                    O3List = aqiMapper.getO3(map1);
                }
                list3.addAll(tempList);
                list4.addAll(O3List);
                list1.add(list3);
                list2.add(list4);
            }
            List<List<Map<String, Object>>> list = new ArrayList<>();
            if (list2.get(0).size() == 0) {
                list = list1;
            } else {
                for (List<Map<String, Object>> tempList : list1) {
                    List<Map<String, Object>> list3 = new ArrayList<>();
                    for (List<Map<String, Object>> O3List : list2) {
                        for (Map<String, Object> tempMap : tempList) {
                            for (Map<String, Object> O3Map : O3List) {
                                if (O3Map.get("O3") != null) {
                                    if (tempMap.get("time").equals(O3Map.get("time"))) {
                                        Map<String, Object> map = new HashMap<>();
                                        map.put("time", tempMap.get("time"));
                                        map.put("temp", tempMap.get("temp").toString());
                                        map.put("O3", O3Map.get("O3").toString());
                                        list3.add(map);
                                    }
                                }
                            }
                        }
                    }
                    list.add(list3);
                }
            }

            if (list.get(0).size()!=0) {
                if (list.get(0).get(0).size() > 2) {
                    List<Map<String, Object>> constantList = new ArrayList<>();
                    for (int i = 0; i < list.size(); i++) {
                        List<Map<String, Object>> mapList = list.get(i);
                        double tempSum = 0;//温度和
                        double O3Sum = 0;//O3和
                        double sum = 0;//
                        double sum1 = 0;
                        int length = mapList.size();
                        Map<String, Object> cmap = new HashMap<>();
                        cmap.put("time", i);
                        for (Map<String, Object> map : mapList) {
                            double temp = Double.valueOf(map.get("temp").toString().replace("\"", "").split("\\.")[0]);
                            double O3 = Double.valueOf(map.get("O3").toString().replace("\"", "").split("\\.")[0]);
                            tempSum = tempSum + temp;
                            O3Sum = O3Sum + O3;
                            sum = sum + temp * O3;
                            sum1 = sum1 + temp * temp;
                        }
                        double tempAvg = tempSum / length;
                        double O3Avg = O3Sum / length;
                        double b = (sum - length * tempAvg * O3Avg) / (sum1 - length * tempAvg * tempAvg);
                        double a = O3Avg - (b * tempAvg);
                        cmap.put("a", a);
                        cmap.put("b", b);
                        constantList.add(cmap);
                    }
                    hashmap.put("constants", constantList);
                }
            }
        }

        int count = 0;
        for (Map<String, Object> map : hashSet) {
            String id = map.get("cityID").toString();
@@ -251,48 +167,194 @@
                String hour1 = hourlyMap.get("fxTime").toString().split("\\+")[0].split(":")[0].replace("T", " ");
                if (hour.equals(nextDay)) {
                    nextDayList.add(hourlyMap);

                }
                if (hour1.equals(nextNextDay)) {
                    nextDayList.add(hourlyMap);
                }
                map.put("data", nextDayList);
            }
            nextDayList.remove(0);
            for (Map<String, Object> nextDayMap : nextDayList) {
                String text = nextDayMap.get("text").toString();
                String condition = "";
                if ("晴".equals(text)) {
                    condition = "100";
                } else if ("多云".equals(text)) {
                    condition = "80";
                } else if ("阴".equals(text)) {
                    condition = "60";
                } else if ("雷阵雨".equals(text) || "阵雨".equals(text)) {
                    condition = "40";
                } else if ("小雨".equals(text)) {
                    condition = "20";
                } else if ("雨".equals(text)) {
                    condition = "0";
                }
                nextDayMap.put("condition", condition);
            }
            map.put("data", nextDayList);
        }

        for (Map<String, Object> map : hashSet) {
            String cityCode = map.get("cityCode").toString();
            List<Map<String, Object>> resultList = new ArrayList<>();
            String cityCode = map.get("cityCode").toString();
            map.put("startTime", startTime);
            map.put("endTime", endTime);
            map.put("typeFormat", "%Y-%m-%d %H:%i:%s");
            Map<String, Object> map1 = new HashMap<>();
            map1.put("typeFormat", "%Y-%m-%d %H:%i:%s");
            map1.put("cityCode", Integer.valueOf(cityCode));
            //根据city_code获取所有monitorPoint
            Map<String, Object> params = new HashMap<>();
            if (cityCode.endsWith("0000")) {
                params.put("provinceCode", Integer.valueOf(cityCode));
            } else if (cityCode.endsWith("00")) {
                params.put("cityCode", Integer.valueOf(cityCode));
            } else {
                params.put("areaCode", Integer.valueOf(cityCode));
            }
            List<Integer> pointList = new ArrayList<>();
            if (cityCode.equals("130900")) {
                pointList.add(48);
            } else {
                pointList = monitorPointMapper.getMonitorList(params);
            }
            List<String> macList = deviceMapper.getMacsByMonitorPointIds(pointList);
            if (macList.size() != 0) {
                map.put("macs", macList);
            }
            ArrayList<Map<String, Object>> dataList = (ArrayList<Map<String, Object>>) map.get("data");
            for (Map<String, Object> dataMap : dataList) {
                Map<String, Object> hashMap = new HashMap<>();
                hashMap.put("cityCode", cityCode);
                String time = dataMap.get("fxTime").toString().split("\\+")[0].replace("T", " ") + ":00";
                hashMap.put("time", sdf1.parse(time));

                String temp = dataMap.get("temp").toString();
                int hour = Integer.valueOf(time.substring(11, 13));
                if (map.get("constants") != null) {
                    List<Map<String, Object>> list = (List<Map<String, Object>>) map.get("constants");
                    for (Map<String, Object> listMap : list) {
                        int value = Integer.valueOf(listMap.get("time").toString());
                        Double a = Double.valueOf(listMap.get("a").toString());
                        Double b = Double.valueOf(listMap.get("b").toString());
                        if (hour == value) {
                            double O3C = b * Double.valueOf(temp) + a;
                            dataMap.put("O3C", String.valueOf(Math.round(O3C)));
                map.put("time", hour);
                hashMap.put("time", sdf1.parse(time));
                String nextDayTemp = dataMap.get("temp").toString();
                String nextDayCloud = dataMap.get("cloud").toString();
                Integer condition = Integer.valueOf(dataMap.get("condition").toString());
                String value="";
                if (condition >= 80) {
                    value = "80";
                } else if (condition >= 40) {
                    value = "40";
                } else if (condition >= 0) {
                    value = "0";
                }
                map.put("condition", value);
                List<Map<String, Object>> tempAndCloudList = realWeatherMapper.getTempAndCloud(map);
                List<String> times = new ArrayList<>();
                for (Map<String, Object> tempAndCloudMap : tempAndCloudList) {
                    times.add(tempAndCloudMap.get("time").toString());
                }
                map.put("times", times);
                map1.put("times", times);
                map1.put("time", hour);
                List<Map<String, Object>> O3List = aqiMapper.getO3(map1);
                if (O3List.size() == 0) {
                    map1.put("cityCode", Integer.valueOf(map.get("parentCode").toString()));
                    O3List = aqiMapper.getO3(map1);
                }
                List<Map<String, Object>> beamList = new ArrayList<>();
                if (map.get("macs") != null) {
                    beamList = historyHourlyMapper.getBeamByMacs(map);
                }
                for (Map<String, Object> tempAndCloudMap : tempAndCloudList) {
                    String time1 = tempAndCloudMap.get("time").toString();
                    for (Map<String, Object> beamMap : beamList) {
                        if (beamList.size() != 0) {
                            String time2 = beamMap.get("time").toString();
                            if (time1.equals(time2)) {
                                tempAndCloudMap.putAll(beamMap);
                            }
                        }
                    }
                }

                for (Map<String, Object> tempAndCloudMap : tempAndCloudList) {
                    String time1 = tempAndCloudMap.get("time").toString();
                    for (Map<String, Object> O3Map : O3List) {
                        if (O3List.size() != 0) {
                            String time3 = O3Map.get("time").toString();
                            if (time1.equals(time3)) {
                                tempAndCloudMap.putAll(O3Map);
                            }
                        }
                    }
                }

                double tempSum = 0.0;//温度和
                double O3Sum = 0.0;//O3和
                double sum1 = 0.0;//
                double sum2 = 0.0;

                double cloudSum = 0.0;//温度和
                double beamSum = 0.0;//O3和
                double sum3 = 0.0;//
                double sum4 = 0.0;
                int size = tempAndCloudList.size();
                Map<String, Object> cmap = new HashMap<>();
                cmap.put("time", hour);
                for (Map<String, Object> listMap : tempAndCloudList) {
                    //O3
                    double temp = Double.valueOf(listMap.get("temp").toString().replace("\"", "").split("\\.")[0]);
                    if (listMap.get("O3") != null) {
                        double O3 = Double.valueOf(listMap.get("O3").toString().replace("\"", "").split("\\.")[0]);
                        tempSum = tempSum + temp;
                        O3Sum = O3Sum + O3;
                        sum1 = sum1 + temp * O3;
                        sum2 = sum2 + temp * temp;
                    }
                    //光照
                    double cloud = Double.valueOf(listMap.get("cloud").toString().replace("\"", "").split("\\.")[0]);
                    if (listMap.get("beam") != null) {
                        double beam = Double.valueOf(listMap.get("beam").toString().replace("\"", "").split("\\.")[0]);
                        cloudSum = cloudSum + cloud;
                        beamSum = beamSum + beam;
                        sum3 = sum3 + cloud * beam;
                        sum4 = sum4 + cloud * cloud;
                    }
                }

                if (tempSum != 0.0) {
                    double tempAvg = tempSum / size;
                    double O3Avg = O3Sum / size;
                    double b = (sum1 - size * tempAvg * O3Avg) / (sum2 - size * tempAvg * tempAvg);
                    double a = O3Avg - (b * tempAvg);
                    cmap.put("a", a);
                    cmap.put("b", b);
                }

                if (cloudSum != 0.0) {
                    double cloudAvg = cloudSum / size;
                    double beamAvg = beamSum / size;
                    double n = (sum3 - size * cloudAvg * beamAvg) / (sum4 - size * cloudAvg * cloudAvg);
                    double m = beamAvg - (n * cloudAvg);
                    cmap.put("m", m);
                    cmap.put("n", n);
                }
                if (cmap.get("a") != null) {
                    Double a = Double.valueOf(cmap.get("a").toString());
                    Double b = Double.valueOf(cmap.get("b").toString());
                    double O3C = b * Double.valueOf(nextDayTemp) + a;
                    if (O3C < 1.0) {
                        O3C=1.0;
                    }
                    dataMap.put("O3C", String.valueOf(Math.round(O3C)));
                }
                if (cmap.get("m") != null) {
                    Double m = Double.valueOf(cmap.get("m").toString());
                    Double n = Double.valueOf(cmap.get("n").toString());
                    double beam = n * Double.valueOf(nextDayCloud) + m;
                    if (beam < 1.0) {
                        beam=1.0;
                    }
                    dataMap.put("beam", String.valueOf(Math.round(beam)));
                }
                dataMap.remove("icon");
                dataMap.remove("fxTime");
                hashMap.put("json", JSONObject.toJSONString(dataMap));
                resultList.add(hashMap);
            }
            resultList.remove(0);
            for (Map<String, Object> resultMap : resultList) {
                Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(resultMap.get("json").toString());
                jsonMap.remove("fxTime");
                jsonMap.remove("icon");
                resultMap.put("json", JSONObject.toJSONString(jsonMap));
            }
            Map<String, Object> parameters = new HashMap<>();
            parameters.put("start", start);

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

@@ -93,6 +93,13 @@
            hashMap.put("cityCode", code);
            hashSet.add(hashMap);
        }

        Map<String,Object> kunShanMap=new HashMap<>();
        kunShanMap.put("name1","苏州市");
        kunShanMap.put("parentName","江苏省");
        kunShanMap.put("cityCode",320500);
        hashSet.add(kunShanMap);

        List<Element> elements = Dom4jUtils.readDocument();
        String cityID = "101190404";
        for (Map<String, Object> map : hashSet) {
@@ -145,7 +152,7 @@
                jsonMap.put("condition","80");
            }else if(text.equals("阴")){
                jsonMap.put("condition","60");
            }else if(text.equals("雷阵雨")){
            }else if(text.equals("雷阵雨")||text.equals("阵雨")){
                jsonMap.put("condition","40");
            }else if(text.equals("小雨")){
                jsonMap.put("condition","20");

 src/main/resources/mapper/AQIMapper.xml

@@ -18,8 +18,9 @@
        ifnull(aqi_json->'$.O3C',aqi_json->'$.O3') 'O3'
        from hangzhou_aqi
        where city_code=#{cityCode}
        and time >= #{startTime}
        AND time <![CDATA[<]]> #{endTime}
         and DATE_FORMAT(time, #{typeFormat}) like '%${time}'
        and DATE_FORMAT(time, #{typeFormat}) in
        <foreach collection="times" open="(" separator="," close=")" item="time">
            #{time}
        </foreach>
    </select>
</mapper>

 src/main/resources/mapper/DeviceMapper.xml

@@ -58,8 +58,8 @@
  <select id="selectWithOrgIdsByMac" parameterType="java.lang.String" resultMap="BaseResultWithOrgIdsMap">
    select
    <include refid="simple_Column_List" /> ,
    dvn.version as device_version_value, 
    den.limit_val, 
    dvn.version as device_version_value,
    den.limit_val,
    mp.province_code,
    mp.city_code,
    mp.area_code,
@@ -74,7 +74,7 @@
    where mac = #{mac,jdbcType=VARCHAR}
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    select
    <include refid="Base_Column_List" />
    from device
    where id = #{id,jdbcType=INTEGER}
@@ -254,8 +254,8 @@
    FROM monitor_point mp, device d
    WHERE mp.id = d.monitor_point_id
    AND mp.organization_id IN
        <foreach collection="organizationIdList" index="index" item="organizationId" open="(" separator="," close=")">  
            #{organizationId}  
        <foreach collection="organizationIdList" index="index" item="organizationId" open="(" separator="," close=")">
            #{organizationId}
        </foreach>
    AND d.is_delete = '0';
  </select>
@@ -278,7 +278,7 @@
        </foreach>
        AND d.is_delete = '0'
    </select>
    

    <select id="macAndOrganizationIdMap" resultType="java.util.LinkedHashMap">
        select mac,organization_id as organizationId
        FROM monitor_point m,device d
@@ -290,5 +290,9 @@
        </foreach>
    </select>


    <select id="getMacsByMonitorPointIds" resultType="java.lang.String">
        select mac from device where monitor_point_id in
        <foreach item="item" collection="list" index="index" open="(" separator="," close=")">#{item}</foreach>
        and is_delete=0;
    </select>
</mapper>

 src/main/resources/mapper/HistoryHourlyMapper.xml

@@ -63,4 +63,21 @@
        </foreach>
    </insert>

    <select id="getBeamByMacs" resultType="java.util.Map">
        SELECT
        DATE_FORMAT(h.time,#{typeFormat}) time,
        avg(h.json->'$.e12[0]') 'beam'
        FROM history_hourly h
        WHERE h.mac in
        <foreach collection="macs" open="(" separator="," close=")" item="mac">
            #{mac}
        </foreach>
        and h.time in
        <foreach collection="times" open="(" separator="," close=")" item="time">
            #{time}
        </foreach>
        and h.json->'$.e12[0]' is not null
        group by h.time
    </select>

</mapper>

 src/main/resources/mapper/MonitorPointMapper.xml

@@ -18,4 +18,21 @@
    <select id="getMonitorPointList" resultType="com.moral.entity.MonitorPoint" resultMap="BaseResultMap">
            select * from monitor_point
    </select>

    <select id="getMonitorList" resultType="java.lang.Integer">
        select id
        from monitor_point
        where
        <if test="areaCode != null">
            area_code = #{areaCode}
        </if>

        <if test="cityCode != null">
            city_code = #{cityCode}
        </if>

        <if test="provinceCode != null">
            province_code = #{provinceCode}
        </if>
    </select>
</mapper>

 src/main/resources/mapper/RealWeatherMapper.xml

@@ -13,13 +13,15 @@
        </foreach>
    </insert>

    <select id="getTemp" resultType="java.util.Map">
    <select id="getTempAndCloud" resultType="java.util.Map">
        select DATE_FORMAT(time, #{typeFormat}) time,
        json->'$.temp' 'temp'
        json->'$.temp' 'temp',
        json->'$.cloud' 'cloud'
        from real_weather
        where city_code=#{cityCode}
        and time >= #{startTime}
        AND time <![CDATA[<]]> #{endTime}
        and DATE_FORMAT(time, #{typeFormat}) like '%${time}'
        and DATE_FORMAT(time,'%H:%i:%s')=#{time}
        and json->'$.condition'>=#{condition}
    </select>
</mapper>