From 4bec63c802692a402039f0d99eae068d26d63c55 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期六, 07 十一月 2026 16:11:44 +0800
Subject: [PATCH] 完善物料颜色同步并保护数据

---
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java |    5 ++++-
 1 files changed, 4 insertions(+), 1 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 1309623..7fe4c99 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
@@ -25,18 +25,21 @@
                 .likeIfPresent(MdmItemDO::getCode, reqVO.getCode())
                 .likeIfPresent(MdmItemDO::getName, reqVO.getName())
                 .likeIfPresent(MdmItemDO::getBarCode, reqVO.getBarCode())
+                .likeIfPresent(MdmItemDO::getColor, reqVO.getColor())
                 .inIfPresent(MdmItemDO::getCategoryId, categoryIds)
                 .eqIfPresent(MdmItemDO::getItemType, reqVO.getItemType())
                 .eqIfPresent(MdmItemDO::getBrandId, reqVO.getBrandId())
                 .eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())
                 .betweenIfPresent(MdmItemDO::getCreateTime, reqVO.getCreateTime())
-                .orderByDesc(MdmItemDO::getId));
+                // 鍒楄〃鎸夌墿鏂欑紪鐮佹帓搴忥紙鍘熸潵鍏堟寜鐗╂枡鍒嗙被鍒嗙粍鍐嶆寜缂栫爜锛屽悓涓�鍒嗙被鐨勭墿鏂欐墠鎺掑湪涓�璧凤紝璺ㄥ垎绫荤湅缂栫爜鏄贡搴忕殑锛�
+                .orderByAsc(MdmItemDO::getCode));
     }
 
     default List<MdmItemDO> selectList(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) {
         return selectList(new LambdaQueryWrapperX<MdmItemDO>()
                 .likeIfPresent(MdmItemDO::getCode, reqVO.getCode())
                 .likeIfPresent(MdmItemDO::getName, reqVO.getName())
+                .likeIfPresent(MdmItemDO::getColor, reqVO.getColor())
                 .inIfPresent(MdmItemDO::getCategoryId, categoryIds)
                 .eqIfPresent(MdmItemDO::getItemType, reqVO.getItemType())
                 .eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())

--
Gitblit v1.9.3