From bf5f52656e128f578ed42c7979c31cf4b476ce46 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期六, 31 十月 2026 19:04:40 +0800
Subject: [PATCH] feat: 优化业务导入及工艺流程管理
---
yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java | 30 +++++++++++++++++++++++++++++-
1 files changed, 29 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 0ab2d68..e729149 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
@@ -6,14 +6,16 @@
import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemPageReqVO;
import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemDO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
import java.util.Collection;
import java.util.List;
+import java.util.Map;
/**
* MDM 鐗╂枡涓绘暟鎹� Mapper
*
- * @author 鑺嬮亾婧愮爜
+ * @author 瓒呯骇绠＄悊鍛�
*/
@Mapper
public interface MdmItemMapper extends BaseMapperX<MdmItemDO> {
@@ -28,6 +30,7 @@
.eqIfPresent(MdmItemDO::getBrandId, reqVO.getBrandId())
.eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())
.betweenIfPresent(MdmItemDO::getCreateTime, reqVO.getCreateTime())
+ .orderByAsc(MdmItemDO::getSort)
.orderByDesc(MdmItemDO::getId));
}
@@ -38,12 +41,29 @@
.inIfPresent(MdmItemDO::getCategoryId, categoryIds)
.eqIfPresent(MdmItemDO::getItemType, reqVO.getItemType())
.eqIfPresent(MdmItemDO::getStatus, reqVO.getStatus())
+ .orderByAsc(MdmItemDO::getSort)
.orderByDesc(MdmItemDO::getId));
}
default MdmItemDO selectByCode(String code) {
return selectOne(MdmItemDO::getCode, code);
}
+
+ /**
+ * 鏍规嵁缂栫爜鍜屽垹闄ょ姸鎬佹煡璇㈢墿鏂欙紙鐢ㄤ簬瑙ｅ喅杞垹闄ゅ敮涓�閿啿绐侊級
+ */
+ default MdmItemDO selectByCodeAndDeleted(String code, Boolean deleted) {
+ return selectOne(new LambdaQueryWrapperX<MdmItemDO>()
+ .eq(MdmItemDO::getCode, code)
+ .eq(MdmItemDO::getDeleted, deleted));
+ }
+
+ /**
+ * 鐗╃悊鍒犻櫎锛堢敤浜庢竻鐞嗗凡杞垹闄ょ殑閲嶅璁板綍锛�
+ * 娉ㄦ剰锛氱敱浜� BaseDO 鏈� @TableLogic锛宒eleteById 鏄蒋鍒犻櫎锛岄渶瑕佷娇鐢ㄥ師鐢� SQL
+ */
+ @org.apache.ibatis.annotations.Delete("DELETE FROM mdm_item WHERE id = #{id}")
+ void physicalDeleteById(Long id);
default MdmItemDO selectByBarCode(String barCode) {
return selectOne(MdmItemDO::getBarCode, barCode);
@@ -65,4 +85,12 @@
return selectList(MdmItemDO::getId, ids);
}
+ /**
+ * 鏌ヨ鐗╂枡琚摢浜涗笟鍔¤〃寮曠敤锛堟湭鍒犻櫎鐨勮褰曪級
+ *
+ * @param itemId 鐗╂枡缂栧彿
+ * @return 寮曠敤鏉ユ簮鍒楄〃锛屾瘡椤瑰寘鍚� source(鏉ユ簮鍚�) 鍜� cnt(寮曠敤鏁伴噺)锛屼粎杩斿洖 cnt > 0 鐨�
+ */
+ List<Map<String, Object>> selectItemReferenceCount(@Param("itemId") Long itemId);
+
}
\ No newline at end of file
--
Gitblit v1.9.3