From f57a9de2dbe69e7f867b39c25abdab58b401a2df Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期六, 07 十一月 2026 16:01:32 +0800
Subject: [PATCH] fix(mes): 过滤异常未来遥测时间
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/telemetry/MesDvTelemetryMapper.java | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/telemetry/MesDvTelemetryMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/telemetry/MesDvTelemetryMapper.java
index cf333b1..0fb1c9c 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/telemetry/MesDvTelemetryMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/telemetry/MesDvTelemetryMapper.java
@@ -8,6 +8,7 @@
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.telemetry.MesDvTelemetryDO;
import org.apache.ibatis.annotations.Mapper;
+import java.time.LocalDateTime;
import java.util.List;
/**
@@ -26,6 +27,7 @@
.eqIfPresent(MesDvTelemetryDO::getWhetherAnomaly, reqVO.getWhetherAnomaly())
.eqIfPresent(MesDvTelemetryDO::getShiftName, reqVO.getShiftName())
.betweenIfPresent(MesDvTelemetryDO::getTelemetryDataTime, reqVO.getTelemetryDataTime())
+ .le(MesDvTelemetryDO::getTelemetryDataTime, LocalDateTime.now().plusMinutes(5))
.orderByDesc(MesDvTelemetryDO::getTelemetryDataTime)
.orderByDesc(MesDvTelemetryDO::getId));
}
@@ -34,6 +36,7 @@
return selectList(new LambdaQueryWrapperX<MesDvTelemetryDO>()
.eqIfPresent(MesDvTelemetryDO::getTbDeviceId, reqVO.getTbDeviceId())
.likeIfPresent(MesDvTelemetryDO::getDeviceName, reqVO.getDeviceName())
+ .le(MesDvTelemetryDO::getTelemetryDataTime, LocalDateTime.now().plusMinutes(5))
.orderByDesc(MesDvTelemetryDO::getTelemetryDataTime)
.orderByDesc(MesDvTelemetryDO::getId)
.last("LIMIT " + limit));
--
Gitblit v1.9.3