From 3aa3f9e730127147236c9e7627920dd8aacf3a36 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期三, 15 七月 2026 15:49:59 +0800
Subject: [PATCH] 1.仓储物流-批次号优化覆盖数据 2.仓储物流-新增自定义出入库流水查询 3.采购管理-清理无用代码和表 4.销售管理-清理无用代码和表 5.销售流程状态字段数据回游

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java |   19 +++++++++++++++++++
 1 files changed, 19 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 fee5fe3..8f55684 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
@@ -1,6 +1,9 @@
 package cn.iocoder.yudao.module.mes.dal.mysql.wm.transaction;
 
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
 import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.transaction.vo.MesWmTransactionPageReqVO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.wm.transaction.MesWmTransactionDO;
 import org.apache.ibatis.annotations.Mapper;
 
@@ -10,4 +13,20 @@
 @Mapper
 public interface MesWmTransactionMapper extends BaseMapperX<MesWmTransactionDO> {
 
+    default PageResult<MesWmTransactionDO> selectPage(MesWmTransactionPageReqVO reqVO) {
+        return selectPage(reqVO, new LambdaQueryWrapperX<MesWmTransactionDO>()
+                .eqIfPresent(MesWmTransactionDO::getItemId, reqVO.getItemId())
+                .likeIfPresent(MesWmTransactionDO::getBatchCode, reqVO.getBatchCode())
+                .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::getMaterialStockId, reqVO.getMaterialStockId())
+                .geIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getStartTime())
+                .leIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getEndTime())
+                .orderByDesc(MesWmTransactionDO::getTransactionTime));
+    }
+
 }

--
Gitblit v1.9.3