From b3fe06c151dc8455649bf0a46e481ceb83e3ea2a Mon Sep 17 00:00:00 2001
From: 吴羡 <16976746+Xian-TT3@user.noreply.gitee.com>
Date: 星期六, 07 十一月 2026 13:37:54 +0800
Subject: [PATCH] feat: 完成好水川 MOM 需求1/2/4/5/8（装箱、BOM成本、销售合同、劳动合同、留样）
---
yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseOrderItemMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseOrderItemMapper.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseOrderItemMapper.java
index 7e62d58..910f193 100644
--- a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseOrderItemMapper.java
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseOrderItemMapper.java
@@ -1,7 +1,10 @@
package cn.iocoder.yudao.module.erp.dal.mysql.purchase;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.MPJLambdaWrapperX;
+import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseOrderDO;
import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseOrderItemDO;
+import cn.iocoder.yudao.module.erp.enums.ErpAuditStatus;
import org.apache.ibatis.annotations.Mapper;
import java.util.Collection;
@@ -27,4 +30,16 @@
return delete(ErpPurchaseOrderItemDO::getOrderId, orderId);
}
+ /**
+ * 鏌ヨ鎸囧畾鐗╂枡鐨勫凡瀹℃牳閲囪喘璁㈠崟鏄庣粏
+ */
+ default List<ErpPurchaseOrderItemDO> selectListByApprovedOrderAndProductIds(Collection<Long> productIds) {
+ MPJLambdaWrapperX<ErpPurchaseOrderItemDO> query = new MPJLambdaWrapperX<>();
+ query.selectAll(ErpPurchaseOrderItemDO.class);
+ query.innerJoin(ErpPurchaseOrderDO.class, ErpPurchaseOrderDO::getId, ErpPurchaseOrderItemDO::getOrderId);
+ query.eq(ErpPurchaseOrderDO::getStatus, ErpAuditStatus.APPROVE.getStatus());
+ query.in(ErpPurchaseOrderItemDO::getProductId, productIds);
+ return selectJoinList(ErpPurchaseOrderItemDO.class, query);
+ }
+
}
\ No newline at end of file
--
Gitblit v1.9.3