From 02a1ae81eba7b48223052fb833859f0a65dd7d21 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 19 十月 2026 17:31:08 +0800
Subject: [PATCH] feat(mes): 实现袋码大批量生成异步任务功能
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/bagcode/MesProBagCodeMapper.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/bagcode/MesProBagCodeMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/bagcode/MesProBagCodeMapper.java
index bc35f78..a4f9fb0 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/bagcode/MesProBagCodeMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/bagcode/MesProBagCodeMapper.java
@@ -260,11 +260,33 @@
.orderByAsc(MesProBagCodeDO::getId));
}
+ default List<MesProBagCodeDO> selectUnboundPalletlessList() {
+ return selectList(new LambdaQueryWrapperX<MesProBagCodeDO>()
+ .isNull(MesProBagCodeDO::getBatchId)
+ .isNull(MesProBagCodeDO::getPalletId)
+ .in(MesProBagCodeDO::getStatus, MesProBagCodeStatusEnum.GENERATED.getStatus(),
+ MesProBagCodeStatusEnum.PRINTED.getStatus())
+ .isNotNull(MesProBagCodeDO::getItemId)
+ .orderByAsc(MesProBagCodeDO::getId));
+ }
+
/** 鎵规鍐呮湁鏁堣鐮佺殑鍝佺缂栧彿闆嗗悎锛堝拷鐣ュ巻鍙茬┖鍝佺琚嬬爜锛夛紝鐢ㄤ簬褰曞叆鎵规鏃剁殑鍝佺涓�鑷存�ф牎楠� */
@Select("SELECT DISTINCT item_id FROM mes_pro_bag_code " +
"WHERE deleted = 0 AND status <> 30 AND batch_id = #{batchId} AND item_id IS NOT NULL")
List<Long> selectDistinctItemIdsByBatchId(@Param("batchId") Long batchId);
+ /**
+ * 鐗╃悊鍒犻櫎鐢熸垚缁勪笅鐨勪竴鎵硅鐮侊紙浠呯敤浜庣敓鎴愬け璐�/鍙栨秷鍚庣殑鍗婃垚鍝佹竻鐞嗭級
+ * <p>
+ * 鍗婃垚鍝佷粠鏈澶栧睍绀猴紝閫昏緫鍒犻櫎鍙細鐣欎笅鍑犲崄涓囨潯鍨冨溇骞跺崰鐢ㄧ储寮曠┖闂达紝鍥犳杩欓噷鐩存帴鐗╃悊鍒犻櫎銆�
+ *
+ * @param uuid 鐢熸垚缁� UUID
+ * @param limit 鍗曟鏈�澶氬垹闄よ鏁�
+ * @return 瀹為檯鍒犻櫎琛屾暟
+ */
+ @org.apache.ibatis.annotations.Delete("DELETE FROM mes_pro_bag_code WHERE uuid = #{uuid} LIMIT #{limit}")
+ int deletePhysicallyByUuidChunk(@Param("uuid") String uuid, @Param("limit") int limit);
+
default List<MesProBagCodeDO> selectListByIdsForUpdate(Collection<Long> ids) {
return selectList(new LambdaQueryWrapperX<MesProBagCodeDO>()
.in(MesProBagCodeDO::getId, ids)
--
Gitblit v1.9.3