fix(mes): 过滤异常未来遥测时间

liu

20 小时以前 f57a9de2dbe69e7f867b39c25abdab58b401a2df

 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));