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/wm/productsales/MesWmProductSalesMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productsales/MesWmProductSalesMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productsales/MesWmProductSalesMapper.java
index 8c79c6e..013c8cd 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productsales/MesWmProductSalesMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productsales/MesWmProductSalesMapper.java
@@ -18,6 +18,10 @@
@Mapper
public interface MesWmProductSalesMapper extends BaseMapperX<MesWmProductSalesDO> {
+ default MesWmProductSalesDO selectByIdForUpdate(Long id) {
+ return selectOne(new LambdaQueryWrapperX<MesWmProductSalesDO>().eq(MesWmProductSalesDO::getId, id).last("FOR UPDATE"));
+ }
+
default PageResult<MesWmProductSalesDO> selectPage(MesWmProductSalesPageReqVO reqVO) {
return selectPage(reqVO, new LambdaQueryWrapperX<MesWmProductSalesDO>()
.likeIfPresent(MesWmProductSalesDO::getCode, reqVO.getCode())
@@ -25,6 +29,7 @@
.eqIfPresent(MesWmProductSalesDO::getClientId, reqVO.getClientId())
.eqIfPresent(MesWmProductSalesDO::getStatus, reqVO.getStatus())
.betweenIfPresent(MesWmProductSalesDO::getSalesDate, reqVO.getShipmentDate())
+ .betweenIfPresent(MesWmProductSalesDO::getOutboundTime, reqVO.getOutboundTime())
.orderByDesc(MesWmProductSalesDO::getId));
}
@@ -38,6 +43,7 @@
.eqIfPresent(MesWmProductSalesDO::getClientId, reqVO.getClientId())
.eqIfPresent(MesWmProductSalesDO::getStatus, reqVO.getStatus())
.betweenIfPresent(MesWmProductSalesDO::getSalesDate, reqVO.getShipmentDate())
+ .betweenIfPresent(MesWmProductSalesDO::getOutboundTime, reqVO.getOutboundTime())
.orderByDesc(MesWmProductSalesDO::getId);
if (permittedClientIds != null) {
if (CollUtil.isEmpty(permittedClientIds)) {
--
Gitblit v1.9.3