From 87733eb3623593da247c051593d64b8ff9e1d3a4 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期五, 06 十一月 2026 19:00:39 +0800
Subject: [PATCH] feat(crm,mes): 扩展客户字段与重构批次号生成逻辑
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.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/transaction/MesWmTransactionMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java
index 1d18be0..8371c77 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java
@@ -13,17 +13,23 @@
@Mapper
public interface MesWmTransactionMapper extends BaseMapperX<MesWmTransactionDO> {
+ @org.apache.ibatis.annotations.Select("SELECT COALESCE(-SUM(quantity), 0) FROM mes_wm_transaction WHERE biz_type = 119 AND type = 2 AND biz_line_id = #{lineId} AND deleted = 0")
+ java.math.BigDecimal sumSalesOutboundByLineId(Long lineId);
+
default PageResult<MesWmTransactionDO> selectPage(MesWmTransactionPageReqVO reqVO) {
return selectPage(reqVO, new LambdaQueryWrapperX<MesWmTransactionDO>()
.eqIfPresent(MesWmTransactionDO::getItemId, reqVO.getItemId())
.likeIfPresent(MesWmTransactionDO::getBatchCode, reqVO.getBatchCode())
+ .eqIfPresent(MesWmTransactionDO::getBatchCode, reqVO.getBatchCodeExact())
.likeIfPresent(MesWmTransactionDO::getBagCode, reqVO.getBagCode())
+ .eqIfPresent(MesWmTransactionDO::getShipmentId, reqVO.getShipmentId())
.eqIfPresent(MesWmTransactionDO::getWarehouseId, reqVO.getWarehouseId())
.eqIfPresent(MesWmTransactionDO::getLocationId, reqVO.getLocationId())
.eqIfPresent(MesWmTransactionDO::getAreaId, reqVO.getAreaId())
.eqIfPresent(MesWmTransactionDO::getType, reqVO.getType())
.eqIfPresent(MesWmTransactionDO::getBizType, reqVO.getBizType())
.likeIfPresent(MesWmTransactionDO::getBizCode, reqVO.getBizCode())
+ .eqIfPresent(MesWmTransactionDO::getBizCode, reqVO.getBizCodeExact())
.eqIfPresent(MesWmTransactionDO::getMaterialStockId, reqVO.getMaterialStockId())
.geIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getStartTime())
.leIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getEndTime())
--
Gitblit v1.9.3