From 6b8585fc452ecdcaa82d86fab79a9f27bb442851 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期四, 05 十一月 2026 09:13:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_南通_苏珩' into dev_南通_苏珩
---
yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java | 9 ++++++++-
1 files changed, 8 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 eec20ce..dcebb8a 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
@@ -20,6 +20,9 @@
@Mapper
public interface MdmItemMapper extends BaseMapperX<MdmItemDO> {
+ @org.apache.ibatis.annotations.Select("SELECT COALESCE(MAX(CAST(SUBSTRING(code, 5) AS UNSIGNED)), 0) FROM mdm_item WHERE deleted = 0 AND code LIKE CONCAT(#{prefix}, '%')")
+ Integer selectMaxSequenceByPrefix(@Param("prefix") String prefix);
+
default PageResult<MdmItemDO> selectPage(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) {
return selectPage(reqVO, new LambdaQueryWrapperX<MdmItemDO>()
.likeIfPresent(MdmItemDO::getCode, reqVO.getCode())
@@ -46,6 +49,10 @@
default MdmItemDO selectByCode(String code) {
return selectOne(MdmItemDO::getCode, code);
+ }
+
+ default List<MdmItemDO> selectListByCode(String code) {
+ return selectList(MdmItemDO::getCode, code);
}
/**
@@ -92,4 +99,4 @@
*/
List<Map<String, Object>> selectItemReferenceCount(@Param("itemId") Long itemId);
-}
\ No newline at end of file
+}
--
Gitblit v1.9.3