From 3f667355c7013b459f3ab5ec0c1bc035d7e2d5aa Mon Sep 17 00:00:00 2001
From: cjl <909710561@qq.com>
Date: Wed, 31 Jan 2024 10:57:28 +0800
Subject: [PATCH] fix：sql查询时间调整
---
screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java | 24 ++++++++----------------
1 files changed, 8 insertions(+), 16 deletions(-)
diff --git a/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java
index 008249f..e05a362 100644
--- a/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java
+++ b/screen-job/src/main/java/com/moral/api/service/impl/HistoryAqiServiceImpl.java
@@ -77,7 +77,7 @@
//���������aqi���������������������������������������������������������API--���������������
@Override
@Transactional
- public void insertHistoryAqi() {
+ public void insertHistoryAqi(String dateTime) {
//���������������
HttpHeaders headers = new HttpHeaders();
headers.set("Authorization", "APPCODE 31b6ea8f804a4472be3b633cfee44849");
@@ -86,14 +86,16 @@
QueryWrapper<GovMonitorPoint> queryWrapper = new QueryWrapper<>();
queryWrapper.select("guid").eq("is_delete", Constants.NOT_DELETE);
+ /*//
+ queryWrapper.eq("guid","d0955320-4632-4276-b9e2-959e5ace49b3");*/
//������������������������������������������
- String time1 = "2023-08-27 17:50:00";
+ String time1 = StringUtils.isNotEmpty(dateTime)?dateTime:DateUtils.dateToDateString(new Date(),DateUtils.yyyy_MM_dd_HH_EN);
List<GovMonitorPoint> govMonitorPoints = govMonitorPointService.list(queryWrapper);
- Date time = DateUtils.dataToTimeStampTime(DateUtils.convertDate(time1), DateUtils.yyyy_MM_dd_HH_EN);
- String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
-// String timeStr = DateUtils.dateToDateString(DateUtils.addHours(time, -1), DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
+ Date time = DateUtils.dataToTimeStampTime(DateUtils.getDate(time1, DateUtils.yyyy_MM_dd_HH_EN),DateUtils.yyyy_MM_dd_HH_EN);
+ //String timeStr = DateUtils.dateToDateString(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
+ String timeStr = DateUtils.dateToDateString(DateUtils.addHours(time, -1), DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
List<HistoryAqi> historyAqis = new ArrayList<>();
for (GovMonitorPoint govMonitorPoint : govMonitorPoints) {
@@ -151,14 +153,8 @@
if (!ObjectUtils.isEmpty(o3)) {
value.put(Constants.SENSOR_CODE_O3, o3);
}
-
-
//aqi������������redis
redisTemplate.opsForHash().put(RedisConstants.AQI_DATA, guid, value);
-
-// historyAqiMapper.insert(historyAqi);
-
-
}else {
ResponseEntity<String> response;
try {
@@ -177,7 +173,6 @@
historyAqi.setTime(DateUtils.addHours(time, -1));
//���������������
historyAqi.setValue(JSONObject.toJSONString(map));
-
historyAqis.add(historyAqi);
Map<String, Object> value = new HashMap<>();
@@ -210,11 +205,8 @@
if (!ObjectUtils.isEmpty(o3)) {
value.put(Constants.SENSOR_CODE_O3, o3);
}
-
//aqi������������redis
redisTemplate.opsForHash().put(RedisConstants.AQI_DATA, guid, value);
-// historyAqiMapper.insert(historyAqi);
-
}
}
@@ -222,7 +214,7 @@
XxlJobHelper.log("���������������");
}
//���������������
- // historyAqiMapper.insertHistoryAqi(historyAqis);
+ historyAqiMapper.insertHistoryAqi(historyAqis);
}
@Override
--
Gitblit v1.8.0