From 6ae790cc95cf87e40f0f1fa49ed04fb722530211 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Fri, 06 Aug 2021 17:22:15 +0800
Subject: [PATCH] 均值计算加入数据有效性限制条件

---
 screen-job/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java |   86 +++++++++++++++++++++++++++++++++++-------
 1 files changed, 71 insertions(+), 15 deletions(-)

diff --git a/screen-job/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java
index 8acb57a..1018a88 100644
--- a/screen-job/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java
+++ b/screen-job/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java
@@ -57,8 +57,8 @@
         Date end = DateUtils.addMonths(start, 1);
         //������
         QueryWrapper<Sensor> sensorQueryWrapper = new QueryWrapper<>();
-        sensorQueryWrapper.select("code").eq("is_delete", Constants.NOT_DELETE);
-        List<Object> sensorCodes = sensorService.listObjs(sensorQueryWrapper);
+        sensorQueryWrapper.select("code", "lower", "upper").eq("is_delete", Constants.NOT_DELETE);
+        List<Sensor> sensors = sensorService.list(sensorQueryWrapper);
 
         //���������������������������
         QueryWrapper<HistoryDaily> historyDailyQueryWrapper = new QueryWrapper<>();
@@ -80,28 +80,72 @@
             dataMap.put("time", start);
 
             //���������������������������
-            Object windDirAvg = AmendUtils.getWindDirAvg(value);
-            if (windDirAvg != null) {
-                jsonMap.put(Constants.SENSOR_CODE_WIND_DIR, windDirAvg);
+            Map<String, Object> params = new HashMap<>();
+            params.put("data", value);
+            params.put("type", "month");
+            for (Sensor sensor : sensors) {
+                String sensorCode = sensor.getCode();
+                if (sensorCode.equals(Constants.SENSOR_CODE_WIND_DIR)) {
+                    if (sensor.getUpper() != null) {
+                        params.put("windDirUpper", sensor.getUpper());
+                    }
+                    if (sensor.getLower() != null) {
+                        params.put("windDirLower", sensor.getLower());
+                    }
+                }
+                if (sensorCode.equals(Constants.SENSOR_CODE_WIND_SPEED)) {
+                    if (sensor.getUpper() != null) {
+                        params.put("windSpeedUpper", sensor.getUpper());
+                    }
+                    if (sensor.getLower() != null) {
+                        params.put("windSpeedLower", sensor.getLower());
+                    }
+                }
+
+                if (sensorCode.equals(Constants.SENSOR_CODE_CO)) {
+                    if (sensor.getUpper() != null) {
+                        params.put("coUpper", sensor.getUpper());
+                    }
+                    if (sensor.getLower() != null) {
+                        params.put("coLower", sensor.getLower());
+                    }
+                }
+
+                if (sensorCode.equals(Constants.SENSOR_CODE_O3)) {
+                    if (sensor.getUpper() != null) {
+                        params.put("o3Upper", sensor.getUpper());
+                    }
+                    if (sensor.getLower() != null) {
+                        params.put("o3Lower", sensor.getLower());
+                    }
+                }
+
+            }
+            Map<String, Object> windDirAvg = AmendUtils.getWindDirAvg(params);
+            if (!ObjectUtils.isEmpty(windDirAvg)) {
+                jsonMap.putAll(windDirAvg);
             }
 
             //CO 95������������������������
-            Object coAvg = AmendUtils.getCOAvgOfWeekOrMonth(value);
-            if (coAvg != null) {
-                jsonMap.put(Constants.SENSOR_CODE_CO, coAvg);
+            Map<String, Object> coAvgOfWeekOrMonth = AmendUtils.getCOAvgOfWeekOrMonth(params);
+            if (!ObjectUtils.isEmpty(coAvgOfWeekOrMonth)) {
+                jsonMap.putAll(coAvgOfWeekOrMonth);
             }
 
             //O3 90������������������������
-            Object o3Avg = AmendUtils.getO3AvgOfWeekOrMonth(value);
-            if (o3Avg != null) {
-                jsonMap.put(Constants.SENSOR_CODE_O3, o3Avg);
+            Map<String, Object> o3AvgOfWeekOrMonth = AmendUtils.getO3AvgOfWeekOrMonth(params);
+            if (!ObjectUtils.isEmpty(o3AvgOfWeekOrMonth)) {
+                jsonMap.putAll(o3AvgOfWeekOrMonth);
             }
 
-            sensorCodes.forEach(sensorCode -> {
+            sensors.forEach(sensor -> {
+                String sensorCode = sensor.getCode();
+                Double upper = sensor.getUpper();
+                Double lower = sensor.getLower();
                 OptionalDouble optionalDouble = value.parallelStream()
                         .flatMapToDouble(v -> {
                             Map<String, Object> dataValue = JSONObject.parseObject((String) v.get("value"), Map.class);
-                            Object sensorValue = dataValue.get(sensorCode.toString());
+                            Object sensorValue = dataValue.get(sensorCode);
                             if (ObjectUtils.isEmpty(sensorValue)) {
                                 return null;
                             }
@@ -117,12 +161,24 @@
                             if (Constants.SENSOR_CODE_O3.equals(sensorCode)) {
                                 return null;
                             }
-                            return DoubleStream.of(Double.parseDouble(sensorValue.toString()));
+                            //������������������������������������
+                            double aDouble = Double.parseDouble(sensorValue.toString());
+                            if (!ObjectUtils.isEmpty(upper)) {
+                                if (aDouble < upper) {
+                                    return null;
+                                }
+                            }
+                            if (!ObjectUtils.isEmpty(lower)) {
+                                if (aDouble > lower) {
+                                    return null;
+                                }
+                            }
+                            return DoubleStream.of(aDouble);
                         }).average();
                 if (optionalDouble.isPresent()) {
                     //���������������������
                     double sciCal = AmendUtils.sciCal(optionalDouble.getAsDouble(), 4);
-                    jsonMap.put(sensorCode.toString(), sciCal);
+                    jsonMap.put(sensorCode, sciCal);
                 }
             });
             dataMap.put("value", JSONObject.toJSONString(jsonMap));

--
Gitblit v1.8.0