From 66517edf1de22c8203daa256abffddae43bae704 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 16 十月 2026 17:58:28 +0800
Subject: [PATCH] feat(mes): 袋码绑定托盘免先录生产批次

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/pallet/MesProPalletMapper.java |   16 ++++++++++++++++
 1 files changed, 16 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/pallet/MesProPalletMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/pallet/MesProPalletMapper.java
index 045b669..6c1b01f 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/pallet/MesProPalletMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/pallet/MesProPalletMapper.java
@@ -56,6 +56,22 @@
                 .orderByAsc(MesProPalletDO::getId));
     }
 
+    /**
+     * 鏌ヨ琚嬬爜缁戝畾鎵樼洏鏃跺彲閫夌殑鐩爣鎵樼洏锛氭湭浣滃簾鐨勪复鏃舵墭鐩樹笌姝e紡鎵樼洏銆�
+     * <p>
+     * 浼犲叆鍝佺鏃朵粎杩斿洖璇ュ搧绉嶇殑鎵樼洏锛屼互鍙婂皻鏈‘瀹氬搧绉嶇殑棰勭敓鎴愪复鏃舵墭鐩橈紙item_id 涓虹┖锛岀粦瀹氳鐮佹椂鍥炲~鍝佺锛夈��
+     *
+     * @param itemId 琚嬬爜鍝佺缂栧彿锛屽彲涓虹┖
+     * @return 鎵樼洏鍒楄〃
+     */
+    default List<MesProPalletDO> selectBindableList(Long itemId) {
+        return selectList(new LambdaQueryWrapperX<MesProPalletDO>()
+                .ne(MesProPalletDO::getStatus, MesProPalletStatusEnum.CANCELED.getStatus())
+                .and(itemId != null, q -> q.eq(MesProPalletDO::getItemId, itemId)
+                        .or().isNull(MesProPalletDO::getItemId))
+                .orderByDesc(MesProPalletDO::getId));
+    }
+
     default PageResult<MesProPalletDO> selectPage(MesProPalletPageReqVO reqVO) {
         return selectPage(reqVO, new LambdaQueryWrapperX<MesProPalletDO>()
                 .likeIfPresent(MesProPalletDO::getBusinessCode, reqVO.getBusinessCode())

--
Gitblit v1.9.3