From e2c9154d3381b365ef4fff5367840725e0c4a57b Mon Sep 17 00:00:00 2001 From: ZhuDongming <773644075@qq.com> Date: Mon, 02 Sep 2019 17:41:54 +0800 Subject: [PATCH] 污染传播接口修改 --- src/main/java/com/moral/service/impl/HistoryServiceImpl.java | 62 +++++++++++++++++++++++++++++++ 1 files changed, 62 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java index 6628fe1..dff8765 100644 --- a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java +++ b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java @@ -1,5 +1,6 @@ package com.moral.service.impl; +import java.text.SimpleDateFormat; import java.time.Instant; import java.time.LocalDate; import java.time.LocalDateTime; @@ -33,6 +34,8 @@ import com.moral.entity.Sensor; import com.moral.mapper.DeviceMapper; import com.moral.mapper.HistoryMapper; +import com.moral.mapper.MonitorPointMapper; +import com.moral.mapper.OrganizationRelationMapper; import com.moral.mapper.SensorMapper; import com.moral.mapper.SensorUnitMapper; import com.moral.service.AccountService; @@ -57,6 +60,12 @@ @Resource private ProfessionService professionService; + + @Resource + private OrganizationRelationMapper organizationRelationMapper; + + @Resource + private MonitorPointMapper monitorPointMapper; @Override public Map<String, Object> getAllSensorAverageByDevice(Map<String, Object> parameters) throws Exception { @@ -376,4 +385,57 @@ return returnMap; } + + @Override + public List<Map<String, Object>> getMointorPointRankByOrganizationId(Map<String, Object> parameters) { + //������������id + String organizationId = parameters.get("organization_id").toString(); + //������������������������������������������������������id + List<Object> organizationIdList = new ArrayList<>(); + organizationIdList.add(organizationId); + //���������������������������������id + List<Object> parentIdList = new ArrayList<>(); + parentIdList.add(organizationId); + + //������������ + for(int i=0;i<10;i++) { + if(!parentIdList.isEmpty()) { + //������������������������������ + List<Map<String, Object>> childIdList = organizationRelationMapper.getChildIdByParentId(parentIdList); + //���������������id������ + parentIdList.clear(); + //������������id������������������ + for (Map<String, Object> map : childIdList) { + organizationIdList.add(map.get("child_id")); + parentIdList.add(map.get("child_id")); + } + }else { + break; + } + } + System.out.println(organizationIdList); + + //������������id������������id + List<Map<String, Object>> monitorPointIdListMap = monitorPointMapper.getIdByOrganizationId(organizationIdList); + //���List<Map<String, Object>>���������List<Object> + List<Object> monitorPointIdList = new ArrayList<>(); + for (Map<String, Object> map : monitorPointIdListMap) { + monitorPointIdList.add(map.get("id")); + } + + //������������id��������������������������� + //������������������������ + Calendar rightNow = Calendar.getInstance(); + //��������������������������� + Calendar beforeTime = Calendar.getInstance(); + beforeTime.add(Calendar.MINUTE, -5);// 5��������������������� + Date beforeD = beforeTime.getTime(); + Date end = rightNow.getTime(); + String endTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(end); + String before5Time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(beforeD); // ������������������ + + String sensor = parameters.get("sensor").toString(); + List<Map<String, Object>> result = historyMapper.getAVGSensorRankByMonitorPointIdList(sensor, monitorPointIdList, before5Time, endTime); + return result; + } } -- Gitblit v1.8.0