From 704265308b1227dbada5a36b2027b588c062ded2 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 12 十月 2026 09:14:37 +0800
Subject: [PATCH] feat(mes): 新增业务码支持并优化追溯查询功能
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/scan/MesProScanEventMapper.java | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/scan/MesProScanEventMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/scan/MesProScanEventMapper.java
index 523c172..6a604fc 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/scan/MesProScanEventMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/scan/MesProScanEventMapper.java
@@ -7,6 +7,8 @@
import cn.iocoder.yudao.module.mes.controller.admin.pro.scan.vo.MesProScanEventPageReqVO;
import org.apache.ibatis.annotations.Mapper;
+import java.util.List;
+
@Mapper
public interface MesProScanEventMapper extends BaseMapperX<MesProScanEventDO> {
default MesProScanEventDO selectByEventIdForUpdate(String eventId) {
@@ -16,12 +18,14 @@
default PageResult<MesProScanEventDO> selectPage(MesProScanEventPageReqVO reqVO) {
return selectPage(reqVO, new LambdaQueryWrapperX<MesProScanEventDO>()
.eqIfPresent(MesProScanEventDO::getEventId, reqVO.getEventId())
+ .eqIfPresent(MesProScanEventDO::getCreator, reqVO.getCreator())
+ .betweenIfPresent(MesProScanEventDO::getReceivedTime, reqVO.getReceivedTime())
.likeIfPresent(MesProScanEventDO::getBagCode, reqVO.getBagCode())
.likeIfPresent(MesProScanEventDO::getBatchCode, reqVO.getBatchCode())
.eqIfPresent(MesProScanEventDO::getDeviceCode, reqVO.getDeviceCode())
.eqIfPresent(MesProScanEventDO::getStatus, reqVO.getStatus())
.eqIfPresent(MesProScanEventDO::getErrorCode, reqVO.getErrorCode())
- .orderByDesc(MesProScanEventDO::getEventTime));
+ .orderByDesc(MesProScanEventDO::getReceivedTime, MesProScanEventDO::getId));
}
default MesProScanEventDO selectLatest(String deviceCode) {
@@ -29,4 +33,10 @@
.eqIfPresent(MesProScanEventDO::getDeviceCode, deviceCode)
.orderByDesc(MesProScanEventDO::getEventTime).last("LIMIT 1"));
}
+
+ default List<MesProScanEventDO> selectListByBatchId(Long batchId) {
+ return selectList(new LambdaQueryWrapperX<MesProScanEventDO>()
+ .eq(MesProScanEventDO::getBatchId, batchId)
+ .orderByDesc(MesProScanEventDO::getEventTime));
+ }
}
--
Gitblit v1.9.3