From 66958ca7242928b76795d98124e1d012665e8782 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期五, 16 十月 2026 17:41:59 +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