From e97c393e23f4c015a44b5fef5fd26ae288bc6c0f Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Wed, 10 Jul 2019 11:31:35 +0800
Subject: [PATCH] 天气预报

---
 src/main/java/com/moral/service/impl/HistoryServiceImpl.java |   43 +++++++++++++++++++++++++++++++++++++++----
 1 files changed, 39 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java
index f6dbae7..72410be 100644
--- a/src/main/java/com/moral/service/impl/HistoryServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/HistoryServiceImpl.java
@@ -1,10 +1,14 @@
 package com.moral.service.impl;
 
+import java.time.Instant;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
+import java.time.ZoneId;
+import java.time.ZoneOffset;
 import java.time.temporal.ChronoUnit;
 import java.time.temporal.TemporalAdjusters;
 import java.util.ArrayList;
+import java.util.Arrays;
 import java.util.Collections;
 import java.util.Comparator;
 import java.util.Date;
@@ -26,10 +30,10 @@
 import com.moral.entity.Sensor;
 import com.moral.mapper.DeviceMapper;
 import com.moral.mapper.HistoryMapper;
-import com.moral.mapper.ProfessionMapper;
 import com.moral.mapper.SensorMapper;
 import com.moral.service.AccountService;
 import com.moral.service.HistoryService;
+import com.moral.service.ProfessionService;
 
 @Service
 public class HistoryServiceImpl implements HistoryService {
@@ -47,7 +51,7 @@
 	private SensorMapper sensorMapper;
 
     @Resource
-    private ProfessionMapper professionMapper;
+    private ProfessionService professionService;
 
 	@Override
 	public Map<String, Object> getAllSensorAverageByDevice(Map<String, Object> parameters) throws Exception {
@@ -107,6 +111,7 @@
 		ValidateUtil.notNull(parameters.get("accountId"), "param.is.null");
 
 		String regionCode = parameters.get("regionCode").toString();
+		parameters.put("provinceCode", regionCode.substring(0,2).concat("0000"));
 		String regionType = "village";
 		String nextLevel = "";
 		if (regionCode.length() == 6) {
@@ -135,7 +140,7 @@
 		String column = "value";
 		if ("month".equals(timeType)) {
 			if (1 != localDate.getDayOfMonth()) {
-				table = "history_minutely";
+				table = "history_daily";
 				column = "json";
 			}
 			parameters.put("start", localDate.with(TemporalAdjusters.firstDayOfMonth()));
@@ -164,7 +169,7 @@
 			}
 		}
 		if ("profession".equals(parameters.get("dimension"))) {
-			List<Profession> professions = professionMapper.selectAll();
+			List<Profession> professions = professionService.getProfessiontList(parameters);
 			for (Map<String, Object> map : result) {
 				for (Profession profession : professions) {
 					if (map.get("name").equals(profession.getName())) {
@@ -260,4 +265,34 @@
 		return values;
 	}
 
+	@Override
+	public Map<String, Object> getActualDataByRegion(Map<String, Object> parameters) {
+		Object sensorKey = parameters.get("sensorKey");
+		ValidateUtil.notNull(sensorKey, "param.is.null");
+		ValidateUtil.notNull(parameters.get("accountId"), "param.is.null");
+		ValidateUtil.notNull(parameters.get("interval"), "param.is.null");
+		Integer interval = Integer.valueOf(parameters.get("interval").toString());
+		LocalDateTime start, end;
+		if (!parameters.containsKey("time")) {
+			end = LocalDateTime.now();
+			int second = end.getSecond() / interval * interval;
+			end = end.truncatedTo(ChronoUnit.MINUTES).plusSeconds(second);
+			start = end.minusSeconds(interval);
+		} else {
+			//start = LocalDateTime.ofEpochSecond(Long.valueOf(parameters.get("time").toString()) / 1000, 0, ZoneOffset.ofHours(8));
+			start = LocalDateTime.ofInstant(Instant.ofEpochMilli(Long.valueOf(parameters.get("time").toString())),ZoneId.of("+8"));
+			end = start.plusSeconds(interval);
+		}
+		parameters.put("start", start);
+		parameters.put("end", end);
+		parameters.put("sensorKeys", Arrays.asList(((String) sensorKey).split(",")));
+		accountService.setOrgIdsByAccount(parameters);
+		Map<String, Object> result = historyMapper.getActualDataByRegion(parameters);
+		if (ObjectUtils.isEmpty(result)) {
+			result = new HashMap<String, Object>();
+		}
+		result.put("time", end.toInstant(ZoneOffset.of("+8")).toEpochMilli());
+		return result;
+	}
+
 }

--
Gitblit v1.8.0