From 81806860ff519555f494ac3c871dc92615d06cd4 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 05 十一月 2026 20:15:47 +0800
Subject: [PATCH] feat(qc): 实现质检模板物料防重复选择功能

---
 yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java |    1 +
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java              |    5 +++--
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemPageReqVO.java |    6 +++++-
 3 files changed, 9 insertions(+), 3 deletions(-)

diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemPageReqVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemPageReqVO.java
index 93e87b5..eb1604b 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemPageReqVO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemPageReqVO.java
@@ -7,12 +7,16 @@
 import lombok.ToString;
 
 import java.time.LocalDateTime;
+import java.util.List;
 
 @Schema(description = "绠$悊鍚庡彴 - MDM 鐗╂枡鍒嗛〉 Request VO")
 @Data
 @EqualsAndHashCode(callSuper = true)
 @ToString(callSuper = true)
 public class MdmItemPageReqVO extends PageParam {
+
+    @Schema(description = "鎺掗櫎鐨勭墿鏂欑紪鍙�")
+    private List<Long> excludeIds;
 
     @Schema(description = "鐗╂枡缂栫爜", example = "ITEM001")
     private String code;
@@ -38,4 +42,4 @@
     @Schema(description = "鍒涘缓鏃堕棿")
     private LocalDateTime[] createTime;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java
index e729149..0dd3f9f 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java
@@ -31,7 +31,8 @@
                 .eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())
                 .betweenIfPresent(MdmItemDO::getCreateTime, reqVO.getCreateTime())
                 .orderByAsc(MdmItemDO::getSort)
-                .orderByDesc(MdmItemDO::getId));
+                .orderByDesc(MdmItemDO::getId)
+                .notIn(reqVO.getExcludeIds() != null && !reqVO.getExcludeIds().isEmpty(), MdmItemDO::getId, reqVO.getExcludeIds()));
     }
 
     default List<MdmItemDO> selectList(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) {
@@ -93,4 +94,4 @@
      */
     List<Map<String, Object>> selectItemReferenceCount(@Param("itemId") Long itemId);
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java
index 0806302..dd3126d 100644
--- a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java
+++ b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java
@@ -22,6 +22,7 @@
 
     // ===== 璐ㄦ =====
     QUALITY_INSPECT("quality_inspect", "璐ㄦ"),
+    MES_QC_PATROL("mes_qc_patrol", "宸℃"),
 
     // ===== 璁惧 =====
     DEVICE_MAINTENANCE("device_maintenance", "璁惧缁存姢"),

--
Gitblit v1.9.3