From 2d37870b8924e93f5a8504b3e11645ac2a9da4f4 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期四, 17 七月 2025 11:01:00 +0800 Subject: [PATCH] 修改bug --- ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java | 26 +++++++++++++++++++------- 1 files changed, 19 insertions(+), 7 deletions(-) diff --git a/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java b/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java index 529427e..b63291a 100644 --- a/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java +++ b/ruoyi-service/ruoyi-integration/src/main/java/com/ruoyi/integration/mongodb/service/impl/UploadRealTimeMonitoringDataServiceImpl.java @@ -2,6 +2,7 @@ import cn.hutool.db.sql.Direction; import com.ruoyi.common.core.utils.StringUtils; +import com.ruoyi.integration.api.model.BmsDemandAndChargerExportation; import com.ruoyi.integration.api.model.UploadRealTimeMonitoringData; import com.ruoyi.integration.api.model.UploadRealTimeMonitoringPageData; import com.ruoyi.integration.iotda.constant.IotConstant; @@ -20,6 +21,7 @@ import java.text.ParseException; import java.text.SimpleDateFormat; +import java.time.LocalDateTime; import java.util.Date; import java.util.List; @@ -78,6 +80,9 @@ if (mongoChargingOrderQuery.getSiteId() != null){ query.addCriteria(Criteria.where("siteId").is(mongoChargingOrderQuery.getSiteId())); } + if (!mongoChargingOrderQuery.getSiteIds().isEmpty()){ + query.addCriteria(Criteria.where("siteId").in(mongoChargingOrderQuery.getSiteIds())); + } if (mongoChargingOrderQuery.getChargingPileCode() != null && !mongoChargingOrderQuery.getChargingPileCode().isEmpty()) { query.addCriteria(Criteria.where("charging_pile_code").is(mongoChargingOrderQuery.getChargingPileCode())); } @@ -88,21 +93,21 @@ query.addCriteria(Criteria.where("status").is(mongoChargingOrderQuery.getStatus())); } - if (mongoChargingOrderQuery.getStartTime() != null) { - String[] split = mongoChargingOrderQuery.getStartTime().split(" - "); + if (mongoChargingOrderQuery.getCreateTime() != null) { + String[] split = mongoChargingOrderQuery.getCreateTime().split(" - "); SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date start = dateFormat.parse(split[0]); Date end = dateFormat.parse(split[1]); - query.addCriteria(Criteria.where("startTime").gte(start).lt(end)); + query.addCriteria(Criteria.where("create_time").gte(start).lt(end)); } - if (mongoChargingOrderQuery.getEndTime() != null && mongoChargingOrderQuery.getEndTime() != null) { - String[] split = mongoChargingOrderQuery.getEndTime().split(" - "); + if (mongoChargingOrderQuery.getLastTime() != null && mongoChargingOrderQuery.getLastTime() != null) { + String[] split = mongoChargingOrderQuery.getLastTime().split(" - "); SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); Date start = dateFormat.parse(split[0]); Date end = dateFormat.parse(split[1]); - query.addCriteria(Criteria.where("lastTime").gte(start).lt(end)); + query.addCriteria(Criteria.where("last_time").gte(start).lt(end)); } @@ -170,5 +175,12 @@ // 执行更新操作 mongoTemplate.updateFirst(query, update, UploadRealTimeMonitoringData.class); } - + + + @Override + public void taskDelete() { + Query query = new Query(); + query.addCriteria(Criteria.where("create_time").lt(LocalDateTime.now().minusMonths(2))); + mongoTemplate.remove(query, UploadRealTimeMonitoringData.class); + } } -- Gitblit v1.7.1