From 97f048ce14db07ee41ca05f9c7010dfe132150e4 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期二, 03 十一月 2026 11:06:59 +0800
Subject: [PATCH] feat(mes): 补生产准备检查与仓储收发存汇总接口，附 CFWJ 演示数据种子脚本
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productissue/MesWmProductIssueMapper.java | 18 ++++++++++++++++--
1 files changed, 16 insertions(+), 2 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productissue/MesWmProductIssueMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productissue/MesWmProductIssueMapper.java
index 9b72cd6..76e0470 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productissue/MesWmProductIssueMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/productissue/MesWmProductIssueMapper.java
@@ -1,5 +1,6 @@
package cn.iocoder.yudao.module.mes.dal.mysql.wm.productissue;
+import cn.hutool.core.util.StrUtil;
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;
@@ -16,15 +17,23 @@
public interface MesWmProductIssueMapper extends BaseMapperX<MesWmProductIssueDO> {
default PageResult<MesWmProductIssueDO> selectPage(MesWmProductIssuePageReqVO reqVO) {
- return selectPage(reqVO, new LambdaQueryWrapperX<MesWmProductIssueDO>()
+ LambdaQueryWrapperX<MesWmProductIssueDO> wrapper = new LambdaQueryWrapperX<MesWmProductIssueDO>()
.likeIfPresent(MesWmProductIssueDO::getCode, reqVO.getCode())
.likeIfPresent(MesWmProductIssueDO::getName, reqVO.getName())
.eqIfPresent(MesWmProductIssueDO::getWorkstationId, reqVO.getWorkstationId())
.eqIfPresent(MesWmProductIssueDO::getWorkOrderId, reqVO.getWorkOrderId())
+ .eqIfPresent(MesWmProductIssueDO::getIssueType, reqVO.getIssueType())
.eqIfPresent(MesWmProductIssueDO::getTaskId, reqVO.getTaskId())
.eqIfPresent(MesWmProductIssueDO::getStatus, reqVO.getStatus())
.betweenIfPresent(MesWmProductIssueDO::getIssueDate, reqVO.getIssueDate())
- .orderByDesc(MesWmProductIssueDO::getId));
+ .orderByDesc(MesWmProductIssueDO::getId);
+ // 鎸夊伐鍗曠紪鍙锋绱細璧板瓙鏌ヨ锛岄伩鍏嶄笌宸ュ崟琛ㄨ仈琛ㄥ奖鍝嶅垎椤垫�绘暟
+ if (StrUtil.isNotBlank(reqVO.getWorkOrderCode())) {
+ wrapper.apply("work_order_id IN (SELECT id FROM mes_pro_work_order"
+ + " WHERE deleted = 0 AND code LIKE CONCAT('%', {0}, '%'))",
+ reqVO.getWorkOrderCode());
+ }
+ return selectPage(reqVO, wrapper);
}
default MesWmProductIssueDO selectByCode(String code) {
@@ -37,4 +46,9 @@
.eq(MesWmProductIssueDO::getStatus, status));
}
+ default List<MesWmProductIssueDO> selectListByWorkOrderId(Long workOrderId) {
+ return selectList(new LambdaQueryWrapperX<MesWmProductIssueDO>()
+ .eq(MesWmProductIssueDO::getWorkOrderId, workOrderId));
+ }
+
}
--
Gitblit v1.9.3