From f52e59d2cb5391b6cb46d2d75e4ffa586aa61df1 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Fri, 15 Sep 2023 11:24:42 +0800
Subject: [PATCH] chore:过滤无人机无效数据

---
 screen-api/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java |  492 +++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 480 insertions(+), 12 deletions(-)

diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java
index c6c3f77..c2d9206 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/HistoryMonthlyServiceImpl.java
@@ -1,18 +1,30 @@
 package com.moral.api.service.impl;
 
+import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.moral.api.entity.HistoryMonthly;
+import com.moral.api.entity.*;
+import com.moral.api.mapper.DeviceMapper;
 import com.moral.api.mapper.HistoryMonthlyMapper;
+import com.moral.api.mapper.ServicesScopeDeviceMapper;
+import com.moral.api.mapper.ServicesScopeMapper;
 import com.moral.api.service.HistoryMonthlyService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.moral.api.service.OrganizationService;
+import com.moral.api.utils.GetCenterPointFromListOfCoordinates;
+import com.moral.constant.Constants;
+import com.moral.util.PollutantUtils;
+
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.util.ObjectUtils;
 
-import java.util.Date;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.function.Supplier;
+import java.util.stream.Collectors;
+import java.util.stream.DoubleStream;
+import java.util.stream.Stream;
 
 /**
  * <p>
@@ -28,13 +40,25 @@
     @Autowired
     HistoryMonthlyMapper historyMonthlyMapper;
 
+    @Autowired
+    DeviceMapper deviceMapper;
+
+    @Autowired
+    private OrganizationService organizationService;
+
+    @Autowired
+    private ServicesScopeMapper servicesScopeMapper;
+
+    @Autowired
+    private ServicesScopeDeviceMapper servicesScopeDeviceMapper;
+
     @Override
     public HistoryMonthly getHistoryMonthlyByMacAndDate(String mac, Date date) {
         QueryWrapper<HistoryMonthly> wrapper = new QueryWrapper<>();
-        wrapper.eq("mac",mac);
-        wrapper.eq("time",date);
+        wrapper.eq("mac", mac);
+        wrapper.eq("time", date);
         List<HistoryMonthly> historyMonthlies = historyMonthlyMapper.selectList(wrapper);
-        if(ObjectUtils.isEmpty(historyMonthlies))
+        if (ObjectUtils.isEmpty(historyMonthlies))
             return null;
         return historyMonthlies.get(0);
     }
@@ -42,13 +66,457 @@
     @Override
     public Map<String, HistoryMonthly> getHistoryMonthlyByMacsAndDate(List<String> mac, Date date) {
         QueryWrapper<HistoryMonthly> wrapper = new QueryWrapper<>();
-        wrapper.in("mac",mac);
-        wrapper.eq("time",date);
+        wrapper.in("mac", mac);
+        wrapper.eq("time", date);
         List<HistoryMonthly> historyMonthlies = historyMonthlyMapper.selectList(wrapper);
-        Map<String,HistoryMonthly> map = new HashMap<>();
+        Map<String, HistoryMonthly> map = new HashMap<>();
         for (HistoryMonthly historyMonthly : historyMonthlies) {
-            map.put(historyMonthly.getMac(),historyMonthly);
+            map.put(historyMonthly.getMac(), historyMonthly);
         }
         return map;
     }
+
+    @Override
+    public Map<String, Object> getThermodynamicDiagramDataByOrgIdSensorCodeTime(Map<String, Object> parameters) {
+        Map<String, Object> resultMap = new HashMap<>();
+        int orgId = Integer.parseInt(parameters.get("organization_id").toString());
+        //���������������������������������id
+        List<Integer> allOrgId = new ArrayList<>();
+        allOrgId.add(orgId);
+        //������������
+        //���������������
+        List<Organization> allChildrenOrganization = organizationService.getChildrenOrganizationsById(orgId);
+        if (!ObjectUtils.isEmpty(allChildrenOrganization) || allChildrenOrganization.size() < 1) {
+            for (Organization organization : allChildrenOrganization) {
+                allOrgId.add(organization.getId());
+            }
+        }
+        //������������
+        List<Integer> allOrgIdWithoutDuplicates = allOrgId.stream().distinct().collect(Collectors.toList());
+        //������������list���������������mac
+        List<String> deviceMacList = new ArrayList<>();
+        //������������map���Mac������key���device������value
+        Map<String, Device> deviceMap = new HashMap<>();
+        List<Double> longitudeList = new ArrayList<>();
+        List<Double> latitudeList = new ArrayList<>();
+        for (Integer orgIdWithoutDuplicates : allOrgIdWithoutDuplicates) {
+            //������id������������������
+            QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
+            wrapper_device.eq("is_delete", Constants.NOT_DELETE).eq("organization_id", orgIdWithoutDuplicates);
+            List<Device> devices = new ArrayList<>();
+            devices = deviceMapper.selectList(wrapper_device);
+            if (devices.size() > 0) {
+                for (Device device : devices) {
+                    String mac = device.getMac();
+                    deviceMacList.add(mac);
+                    deviceMap.put(mac, device);
+                    double longitude = device.getLongitude();
+                    double latitude = device.getLatitude();
+                    longitudeList.add(longitude);
+                    latitudeList.add(latitude);
+                }
+            } else {
+                continue;
+            }
+        }
+        //������������
+        String time = parameters.get("time").toString().substring(0, 7) + "-01 00:00:00";
+        resultMap.put("time", time);
+        QueryWrapper<HistoryMonthly> historyMonthlyQueryWrapper = new QueryWrapper<>();
+        historyMonthlyQueryWrapper.eq("time", time);
+        historyMonthlyQueryWrapper.in("mac", deviceMacList);
+        List<HistoryMonthly> historyDailies = historyMonthlyMapper.selectList(historyMonthlyQueryWrapper);
+        List<Object> list = new ArrayList<>();
+        for (HistoryMonthly historyDailyData : historyDailies) {
+            List<Object> list1 = new ArrayList<>();
+            String mac = historyDailyData.getMac();
+            Device device = deviceMap.get(mac);
+            double longitude = device.getLongitude();
+            double latitude = device.getLatitude();
+            JSONObject value = JSONObject.parseObject(historyDailyData.getValue());
+            double num = Double.parseDouble(value.get(parameters.get("sensor_code")).toString());
+            int level = PollutantUtils.pollutantLevel(num, (parameters.get("sensor_code")).toString());
+            list1.add(longitude);
+            list1.add(latitude);
+            list1.add(level);
+            list.add(list1);
+        }
+        resultMap.put("list", list);
+        double latitudeMin = Collections.min(latitudeList) - 0.0018;
+        double latitudeMax = Collections.max(latitudeList) + 0.0018;
+        double longitudeMin = Collections.min(longitudeList) - 0.2 / (111 * Math.cos(latitudeMin));
+        double longitudeMax = Collections.max(longitudeList) + 0.2 / (111 * Math.cos(latitudeMin));
+        List<Double> bound = new ArrayList<>();
+        bound.add(longitudeMin);
+        bound.add(latitudeMin);
+        bound.add(longitudeMax);
+        bound.add(latitudeMax);
+        resultMap.put("bound", bound);
+        List<List> bound1 = new ArrayList<>();
+        List<Double> left_up = new ArrayList<>();
+        left_up.add(latitudeMax);
+        left_up.add(longitudeMin);
+        List<Double> right_up = new ArrayList<>();
+        right_up.add(latitudeMax);
+        right_up.add(longitudeMax);
+        List<Double> left_down = new ArrayList<>();
+        left_down.add(latitudeMin);
+        left_down.add(longitudeMin);
+        List<Double> right_down = new ArrayList<>();
+        right_down.add(latitudeMin);
+        right_down.add(longitudeMax);
+        bound1.add(left_up);
+        bound1.add(right_up);
+        bound1.add(right_down);
+        bound1.add(left_down);
+        List<GeoCoordinate> geoCoordinates = new ArrayList<>();
+        for (List bo : bound1) {
+            GeoCoordinate g = new GeoCoordinate();
+            g.setLatitude(Double.parseDouble(bo.get(0).toString()));
+            g.setLongitude(Double.parseDouble(bo.get(1).toString()));
+            geoCoordinates.add(g);
+        }
+        GeoCoordinate centerPoint400 = GetCenterPointFromListOfCoordinates.getCenterPoint400(geoCoordinates);
+        List centerPoint = new ArrayList();
+        centerPoint.add(centerPoint400.getLongitude());
+        centerPoint.add(centerPoint400.getLatitude());
+        resultMap.put("centerPoint", centerPoint);
+        return resultMap;
+    }
+
+    @Override
+    public Map<String, Object> getThermodynamicDiagramDataByOrgIdSensorCodeTimeV2(Map<String, Object> parameters) {
+        Map<String, Object> resultMap = new HashMap<>();
+        int servicesScopeId = Integer.parseInt(parameters.get("servicesScopeId").toString());
+        QueryWrapper<ServicesScopeDevice> servicesScopeDeviceQueryWrapper = new QueryWrapper<>();
+        servicesScopeDeviceQueryWrapper.eq("is_delete",Constants.NOT_DELETE);
+        servicesScopeDeviceQueryWrapper.eq("services_scope_id",servicesScopeId);
+        List<ServicesScopeDevice> servicesScopeDevices = servicesScopeDeviceMapper.selectList(servicesScopeDeviceQueryWrapper);
+        List<Integer> deviceIds = servicesScopeDevices.stream().map(p -> p.getDeviceId()).collect(Collectors.toList());
+        //������������list���������������mac
+        List<String> deviceMacList = new ArrayList<>();
+        //������������map���Mac������key���device������value
+        Map<String, Device> deviceMap = new HashMap<>();
+        //������id������������������
+        QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
+        wrapper_device.eq("is_delete", Constants.NOT_DELETE);
+        wrapper_device.in("id",deviceIds);
+        List<Device> devices = new ArrayList<>();
+        devices = deviceMapper.selectList(wrapper_device);
+        if (devices.size() > 0) {
+            for (Device device : devices) {
+                String mac = device.getMac();
+                deviceMacList.add(mac);
+                deviceMap.put(mac, device);
+            }
+        }
+        //������������
+        String time = parameters.get("time").toString().substring(0, 7) + "-01 00:00:00";
+        resultMap.put("time", time);
+        QueryWrapper<HistoryMonthly> historyMonthlyQueryWrapper = new QueryWrapper<>();
+        historyMonthlyQueryWrapper.eq("time", time);
+        historyMonthlyQueryWrapper.in("mac", deviceMacList);
+        List<HistoryMonthly> historyDailies = historyMonthlyMapper.selectList(historyMonthlyQueryWrapper);
+        List<Object> list = new ArrayList<>();
+        for (HistoryMonthly historyDailyData : historyDailies) {
+            List<Object> list1 = new ArrayList<>();
+            String mac = historyDailyData.getMac();
+            Device device = deviceMap.get(mac);
+            double longitude = device.getLongitude();
+            double latitude = device.getLatitude();
+            JSONObject value = JSONObject.parseObject(historyDailyData.getValue());
+            double num = Double.parseDouble(value.get(parameters.get("sensor_code")).toString());
+            int level = PollutantUtils.pollutantLevel(num, (parameters.get("sensor_code")).toString());
+            list1.add(longitude);
+            list1.add(latitude);
+            list1.add(level);
+            list.add(list1);
+        }
+        resultMap.put("list", list);
+        ServicesScope servicesScope = servicesScopeMapper.selectById(servicesScopeId);
+        String boundary = servicesScope.getBoundary();
+        String[] boundary_points = boundary.split(";");
+        List boundary_pointList = new ArrayList();
+        List bound = new ArrayList();
+        for (String boundary_point:boundary_points) {
+            List boundary_point_one = new ArrayList();
+            String[] boundary_point_one_array = boundary_point.split(",");
+            boundary_point_one.add(Double.parseDouble(boundary_point_one_array[0]));
+            boundary_point_one.add(Double.parseDouble(boundary_point_one_array[1]));
+            boundary_pointList.add(boundary_point_one);
+        }
+        if (boundary_pointList.size()>0){
+            boundary_pointList.add(boundary_pointList.get(0));
+        }
+        bound.add(boundary_pointList);
+        resultMap.put("bound", bound);
+        List centerPoint = new ArrayList();
+        centerPoint.add(servicesScope.getCenterLongitude());
+        centerPoint.add(servicesScope.getCenterLatitude());
+        resultMap.put("centerPoint", centerPoint);
+        return resultMap;
+    }
+
+    @Override
+    public List<Map<String, Object>> getThermodynamicDiagramDataByOrgIdSensorCodeTimeSlot(Map<String, Object> parameters) {
+        int orgId = Integer.parseInt(parameters.get("organization_id").toString());
+        //���������������������������������id
+        List<Integer> allOrgId = new ArrayList<>();
+        allOrgId.add(orgId);
+        //������������
+        //���������������
+        List<Organization> allChildrenOrganization = organizationService.getChildrenOrganizationsById(orgId);
+        if (!ObjectUtils.isEmpty(allChildrenOrganization) || allChildrenOrganization.size() < 1) {
+            for (Organization organization : allChildrenOrganization) {
+                allOrgId.add(organization.getId());
+            }
+        }
+        //������������
+        List<Integer> allOrgIdWithoutDuplicates = allOrgId.stream().distinct().collect(Collectors.toList());
+        //������������list���������������mac
+        List<String> deviceMacList = new ArrayList<>();
+        //������������map���Mac������key���device������value
+        Map<String, Device> deviceMap = new HashMap<>();
+        List<Double> longitudeList = new ArrayList<>();
+        List<Double> latitudeList = new ArrayList<>();
+        for (Integer orgIdWithoutDuplicates : allOrgIdWithoutDuplicates) {
+            //������id������������������
+            QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
+            wrapper_device.eq("is_delete", Constants.NOT_DELETE).eq("organization_id", orgIdWithoutDuplicates);
+            List<Device> devices = new ArrayList<>();
+            devices = deviceMapper.selectList(wrapper_device);
+            if (devices.size() > 0) {
+                for (Device device : devices) {
+                    String mac = device.getMac();
+                    deviceMacList.add(mac);
+                    deviceMap.put(mac, device);
+                    double longitude = device.getLongitude();
+                    double latitude = device.getLatitude();
+                    longitudeList.add(longitude);
+                    latitudeList.add(latitude);
+                }
+            } else {
+                continue;
+            }
+        }
+        double latitudeMin = Collections.min(latitudeList) - 0.0018;
+        double latitudeMax = Collections.max(latitudeList) + 0.0018;
+        double longitudeMin = Collections.min(longitudeList) - 0.2 / (111 * Math.cos(latitudeMin));
+        double longitudeMax = Collections.max(longitudeList) + 0.2 / (111 * Math.cos(latitudeMin));
+        List<Double> bound = new ArrayList<>();
+        bound.add(longitudeMin);
+        bound.add(latitudeMin);
+        bound.add(longitudeMax);
+        bound.add(latitudeMax);
+        List<List> bound1 = new ArrayList<>();
+        List<Double> left_up = new ArrayList<>();
+        left_up.add(latitudeMax);
+        left_up.add(longitudeMin);
+        List<Double> right_up = new ArrayList<>();
+        right_up.add(latitudeMax);
+        right_up.add(longitudeMax);
+        List<Double> left_down = new ArrayList<>();
+        left_down.add(latitudeMin);
+        left_down.add(longitudeMin);
+        List<Double> right_down = new ArrayList<>();
+        right_down.add(latitudeMin);
+        right_down.add(longitudeMax);
+        bound1.add(left_up);
+        bound1.add(right_up);
+        bound1.add(right_down);
+        bound1.add(left_down);
+        List<GeoCoordinate> geoCoordinates = new ArrayList<>();
+        for (List bo : bound1) {
+            GeoCoordinate g = new GeoCoordinate();
+            g.setLatitude(Double.parseDouble(bo.get(0).toString()));
+            g.setLongitude(Double.parseDouble(bo.get(1).toString()));
+            geoCoordinates.add(g);
+        }
+        GeoCoordinate centerPoint400 = GetCenterPointFromListOfCoordinates.getCenterPoint400(geoCoordinates);
+        List centerPoint = new ArrayList();
+        centerPoint.add(centerPoint400.getLongitude());
+        centerPoint.add(centerPoint400.getLatitude());
+        List<Map<String, Object>> resultList = new ArrayList<>();
+        //������������
+        String endTime = parameters.get("endTime").toString().substring(0, 7) + "-01 00:00:00";
+        //������������
+        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM");
+        int months = Integer.parseInt(parameters.get("months").toString());
+        Date newEndTime = new Date();
+        for (int i = months; i >= 0; i--) {
+            Map<String, Object> resultMap = new HashMap<>();
+            //������������������������������
+            resultMap.put("centerPoint", centerPoint);
+            resultMap.put("bound", bound);
+            Calendar calendar = Calendar.getInstance();
+            try {
+                newEndTime = df.parse(endTime);
+            } catch (ParseException e) {
+                e.printStackTrace();
+            }
+            calendar.setTime(newEndTime);
+            calendar.set(Calendar.MONTH, calendar.get(Calendar.MONDAY) - i);
+            String time = df.format(calendar.getTime()) + "-01 00:00:00";
+            //������������
+            resultMap.put("time", time);
+            QueryWrapper<HistoryMonthly> historyMonthlyQueryWrapper = new QueryWrapper<>();
+            historyMonthlyQueryWrapper.eq("time", time);
+            historyMonthlyQueryWrapper.in("mac", deviceMacList);
+            List<HistoryMonthly> historyDailies = historyMonthlyMapper.selectList(historyMonthlyQueryWrapper);
+            List<Object> list = new ArrayList<>();
+            for (HistoryMonthly historyMonthlyData : historyDailies) {
+                List<Object> list1 = new ArrayList<>();
+                String mac = historyMonthlyData.getMac();
+                Device device = deviceMap.get(mac);
+                double longitude = device.getLongitude();
+                double latitude = device.getLatitude();
+                JSONObject value = JSONObject.parseObject(historyMonthlyData.getValue());
+                double num = Double.parseDouble(value.get(parameters.get("sensor_code")).toString());
+                int level = PollutantUtils.pollutantLevel(num, (parameters.get("sensor_code")).toString());
+                list1.add(longitude);
+                list1.add(latitude);
+                list1.add(level);
+                list.add(list1);
+            }
+            resultMap.put("list", list);
+            resultList.add(resultMap);
+        }
+        return resultList;
+    }
+
+    @Override
+    public List<Map<String, Object>> getThermodynamicDiagramDataByOrgIdSensorCodeTimeSlotV2(Map<String, Object> parameters) {
+        int servicesScopeId = Integer.parseInt(parameters.get("servicesScopeId").toString());
+        QueryWrapper<ServicesScopeDevice> servicesScopeDeviceQueryWrapper = new QueryWrapper<>();
+        servicesScopeDeviceQueryWrapper.eq("is_delete",Constants.NOT_DELETE);
+        servicesScopeDeviceQueryWrapper.eq("services_scope_id",servicesScopeId);
+        List<ServicesScopeDevice> servicesScopeDevices = servicesScopeDeviceMapper.selectList(servicesScopeDeviceQueryWrapper);
+        List<Integer> deviceIds = servicesScopeDevices.stream().map(p -> p.getDeviceId()).collect(Collectors.toList());
+        //������������list���������������mac
+        List<String> deviceMacList = new ArrayList<>();
+        //������������map���Mac������key���device������value
+        Map<String, Device> deviceMap = new HashMap<>();
+        //������id������������������
+        QueryWrapper<Device> wrapper_device = new QueryWrapper<>();
+        wrapper_device.eq("is_delete", Constants.NOT_DELETE);
+        wrapper_device.in("id",deviceIds);
+        List<Device> devices = new ArrayList<>();
+        devices = deviceMapper.selectList(wrapper_device);
+        if (devices.size() > 0) {
+            for (Device device : devices) {
+                String mac = device.getMac();
+                deviceMacList.add(mac);
+                deviceMap.put(mac, device);
+            }
+        }
+        ServicesScope servicesScope = servicesScopeMapper.selectById(servicesScopeId);
+        String boundary = servicesScope.getBoundary();
+        String[] boundary_points = boundary.split(";");
+        List boundary_pointList = new ArrayList();
+        List bound = new ArrayList();
+        for (String boundary_point:boundary_points) {
+            List boundary_point_one = new ArrayList();
+            String[] boundary_point_one_array = boundary_point.split(",");
+            boundary_point_one.add(Double.parseDouble(boundary_point_one_array[0]));
+            boundary_point_one.add(Double.parseDouble(boundary_point_one_array[1]));
+            boundary_pointList.add(boundary_point_one);
+        }
+        if (boundary_pointList.size()>0){
+            boundary_pointList.add(boundary_pointList.get(0));
+        }
+        bound.add(boundary_pointList);
+        List centerPoint = new ArrayList();
+        centerPoint.add(servicesScope.getCenterLongitude());
+        centerPoint.add(servicesScope.getCenterLatitude());
+        List<Map<String, Object>> resultList = new ArrayList<>();
+        //������������
+        String endTime = parameters.get("endTime").toString().substring(0, 7) + "-01 00:00:00";
+        //������������
+        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM");
+        int months = Integer.parseInt(parameters.get("months").toString());
+        Date newEndTime = new Date();
+        for (int i = months; i >= 0; i--) {
+            Map<String, Object> resultMap = new HashMap<>();
+            //������������������������������
+            resultMap.put("centerPoint", centerPoint);
+            resultMap.put("bound", bound);
+            Calendar calendar = Calendar.getInstance();
+            try {
+                newEndTime = df.parse(endTime);
+            } catch (ParseException e) {
+                e.printStackTrace();
+            }
+            calendar.setTime(newEndTime);
+            calendar.set(Calendar.MONTH, calendar.get(Calendar.MONDAY) - i);
+            String time = df.format(calendar.getTime()) + "-01 00:00:00";
+            //������������
+            resultMap.put("time", time);
+            QueryWrapper<HistoryMonthly> historyMonthlyQueryWrapper = new QueryWrapper<>();
+            historyMonthlyQueryWrapper.eq("time", time);
+            historyMonthlyQueryWrapper.in("mac", deviceMacList);
+            List<HistoryMonthly> historyDailies = historyMonthlyMapper.selectList(historyMonthlyQueryWrapper);
+            List<Object> list = new ArrayList<>();
+            for (HistoryMonthly historyMonthlyData : historyDailies) {
+                List<Object> list1 = new ArrayList<>();
+                String mac = historyMonthlyData.getMac();
+                Device device = deviceMap.get(mac);
+                double longitude = device.getLongitude();
+                double latitude = device.getLatitude();
+                JSONObject value = JSONObject.parseObject(historyMonthlyData.getValue());
+                double num = Double.parseDouble(value.get(parameters.get("sensor_code")).toString());
+                int level = PollutantUtils.pollutantLevel(num, (parameters.get("sensor_code")).toString());
+                list1.add(longitude);
+                list1.add(latitude);
+                list1.add(level);
+                list.add(list1);
+            }
+            resultMap.put("list", list);
+            resultList.add(resultMap);
+        }
+        return resultList;
+    }
+
+    @Override
+    public List<HistoryMonthly> getValueByMacs(List<String> macs, String time) {
+        QueryWrapper<HistoryMonthly> queryWrapper = new QueryWrapper<>();
+        queryWrapper.select("time", "value")
+                .likeRight("time", time)
+                .in("mac", macs);
+        return historyMonthlyMapper.selectList(queryWrapper);
+    }
+
+    @Override
+    public Double calculatedValue(List<HistoryMonthly> list, String sensorCode, String type) {
+        Supplier<Stream<HistoryMonthly>> supplier = list::stream;
+        DoubleStream doubleStream = supplier.get()
+                .flatMapToDouble(v -> {
+                    Map<String, Object> dataValue = JSONObject.parseObject(v.getValue(), Map.class);
+                    Object sensorValue = dataValue.get(sensorCode);
+                    if (ObjectUtils.isEmpty(sensorValue)) {
+                        return null;
+                    }
+                    double aDouble = Double.parseDouble(sensorValue.toString());
+                    return DoubleStream.of(aDouble);
+                });
+        Double result = null;
+        OptionalDouble optionalDouble = null;
+        if ("sum".equals(type)) {
+            result = doubleStream.sum();
+        } else {
+            if ("min".equals(type)) {
+                optionalDouble = doubleStream.min();
+
+            } else if ("max".equals(type)) {
+                optionalDouble = doubleStream.max();
+
+            } else if ("avg".equals(type)) {
+                optionalDouble = doubleStream.average();
+            }
+
+            if (optionalDouble.isPresent()) {
+                result = optionalDouble.getAsDouble();
+            }
+        }
+        return result;
+    }
 }

--
Gitblit v1.8.0