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-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
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 58289e2..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
@@ -15,7 +15,7 @@
/**
* MDM 鐗╂枡涓绘暟鎹� Mapper
*
- * @author 鑺嬮亾婧愮爜
+ * @author 瓒呯骇绠＄悊鍛�
*/
@Mapper
public interface MdmItemMapper extends BaseMapperX<MdmItemDO> {
@@ -30,7 +30,9 @@
.eqIfPresent(MdmItemDO::getBrandId, reqVO.getBrandId())
.eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())
.betweenIfPresent(MdmItemDO::getCreateTime, reqVO.getCreateTime())
- .orderByDesc(MdmItemDO::getId));
+ .orderByAsc(MdmItemDO::getSort)
+ .orderByDesc(MdmItemDO::getId)
+ .notIn(reqVO.getExcludeIds() != null && !reqVO.getExcludeIds().isEmpty(), MdmItemDO::getId, reqVO.getExcludeIds()));
}
default List<MdmItemDO> selectList(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) {
@@ -40,6 +42,7 @@
.inIfPresent(MdmItemDO::getCategoryId, categoryIds)
.eqIfPresent(MdmItemDO::getItemType, reqVO.getItemType())
.eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())
+ .orderByAsc(MdmItemDO::getSort)
.orderByDesc(MdmItemDO::getId));
}
@@ -91,4 +94,4 @@
*/
List<Map<String, Object>> selectItemReferenceCount(@Param("itemId") Long itemId);
-}
\ No newline at end of file
+}
--
Gitblit v1.9.3