From eccde23ea401394aed432865bfbbbcb89539ba20 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Wed, 18 Aug 2021 15:33:45 +0800
Subject: [PATCH] 特殊设备历史表数据查询、删除，校准接口判断特殊设备表
---
screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java | 28 +++++++++++-----------------
1 files changed, 11 insertions(+), 17 deletions(-)
diff --git a/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java b/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
index ba88b76..e555273 100644
--- a/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
+++ b/screen-manage/src/main/java/com/moral/api/service/impl/HistoryHourlyServiceImpl.java
@@ -37,37 +37,31 @@
@Override
@Transactional
public void insertHistoryHourly(Map<String, Object> data) {
+ Integer version = (Integer) data.remove("ver");
Map<String, Object> dataAdjust = new HashMap<>(data);
String mac = data.remove("mac").toString();
Date time = DateUtils.getDate((String) data.remove("DataTime"), DateUtils.yyyyMMddHHmmss_EN);
- Integer version = (Integer) data.remove("ver");
+
Map<String, Object> result = new HashMap<>();
result.put("mac", mac);
result.put("time", time);
result.put("version", version);
result.put("timeUnits", Constants.UN_ADJUST);
result.put("value", JSONObject.toJSONString(data));
- //���������������������������
- historyHourlyMapper.insertHistoryHourlyUnAdjust(result);
+ //������������������insert
+ historyHourlyMapper.insertHistoryHourly(result);
//������������
dataAdjust = deviceService.adjustDeviceData(dataAdjust);
- dataAdjust.remove("mac");
- dataAdjust.remove("DataTime");
- dataAdjust.remove("ver");
- int count = historyHourlyMapper.getCountByMacAndTime(mac, DateUtils.dateToDateString(time));
+ HistoryHourly historyHourly = new HistoryHourly();
+ historyHourly.setMac(mac);
+ historyHourly.setTime(time);
+ historyHourly.setVersion(version);
+ historyHourly.setValue(JSONObject.toJSONString(dataAdjust));
- //���������������������������mac,���������������������������������������������������
- if (count == 0) {
- //������������������������������������������
- result.put("value", JSONObject.toJSONString(dataAdjust));
- //������
- historyHourlyMapper.insertHistoryHourlyTransition(result);
- } else {
- //������
- historyHourlyMapper.updateHistoryTransition(mac, DateUtils.dateToDateString(time));
- }
+ //������������������insert
+ historyHourlyMapper.insert(historyHourly);
}
}
--
Gitblit v1.8.0