From 87733eb3623593da247c051593d64b8ff9e1d3a4 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期五, 06 十一月 2026 19:00:39 +0800
Subject: [PATCH] feat(crm,mes): 扩展客户字段与重构批次号生成逻辑

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedIndicatorRangeMapper.java |   49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 49 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedIndicatorRangeMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedIndicatorRangeMapper.java
index b43584e..fedc93a 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedIndicatorRangeMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/qc/seedquality/MesQcSeedIndicatorRangeMapper.java
@@ -1,9 +1,58 @@
 package cn.iocoder.yudao.module.mes.dal.mysql.qc.seedquality;
 
+import cn.hutool.core.util.StrUtil;
 import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
 import cn.iocoder.yudao.module.mes.dal.dataobject.qc.seedquality.MesQcSeedIndicatorRangeDO;
 import org.apache.ibatis.annotations.Mapper;
 
+import java.util.List;
+
 @Mapper
 public interface MesQcSeedIndicatorRangeMapper extends BaseMapperX<MesQcSeedIndicatorRangeDO> {
+
+    default List<MesQcSeedIndicatorRangeDO> selectListByItemId(Long itemId, String keyword, Integer status) {
+        LambdaQueryWrapperX<MesQcSeedIndicatorRangeDO> wrapper = new LambdaQueryWrapperX<>();
+        if (itemId == null) {
+            wrapper.isNull(MesQcSeedIndicatorRangeDO::getItemId);
+        } else {
+            wrapper.eq(MesQcSeedIndicatorRangeDO::getItemId, itemId);
+        }
+        wrapper.and(StrUtil.isNotBlank(keyword), w -> w
+                .like(MesQcSeedIndicatorRangeDO::getIndicatorName, keyword)
+                .or().like(MesQcSeedIndicatorRangeDO::getIndicatorCode, keyword));
+        wrapper.eqIfPresent(MesQcSeedIndicatorRangeDO::getStatus, status)
+                .orderByAsc(MesQcSeedIndicatorRangeDO::getSort)
+                .orderByAsc(MesQcSeedIndicatorRangeDO::getId);
+        return selectList(wrapper);
+    }
+
+    /** 浜у搧涓撳睘涓斿惎鐢ㄧ殑鎸囨爣锛屾寜鎺掑簭杩斿洖 */
+    default List<MesQcSeedIndicatorRangeDO> selectEnabledByItemId(Long itemId) {
+        return selectList(new LambdaQueryWrapperX<MesQcSeedIndicatorRangeDO>()
+                .eq(MesQcSeedIndicatorRangeDO::getItemId, itemId)
+                .eq(MesQcSeedIndicatorRangeDO::getStatus, 0)
+                .orderByAsc(MesQcSeedIndicatorRangeDO::getSort)
+                .orderByAsc(MesQcSeedIndicatorRangeDO::getId));
+    }
+
+    /** 鏈粦瀹氫骇鍝佺殑閫氱敤榛樿鎸囨爣锛屾寜鎺掑簭杩斿洖 */
+    default List<MesQcSeedIndicatorRangeDO> selectEnabledDefaults() {
+        return selectList(new LambdaQueryWrapperX<MesQcSeedIndicatorRangeDO>()
+                .isNull(MesQcSeedIndicatorRangeDO::getItemId)
+                .eq(MesQcSeedIndicatorRangeDO::getStatus, 0)
+                .orderByAsc(MesQcSeedIndicatorRangeDO::getSort)
+                .orderByAsc(MesQcSeedIndicatorRangeDO::getId));
+    }
+
+    default MesQcSeedIndicatorRangeDO selectByItemIdAndCode(Long itemId, String indicatorCode) {
+        LambdaQueryWrapperX<MesQcSeedIndicatorRangeDO> wrapper = new LambdaQueryWrapperX<>();
+        if (itemId == null) {
+            wrapper.isNull(MesQcSeedIndicatorRangeDO::getItemId);
+        } else {
+            wrapper.eq(MesQcSeedIndicatorRangeDO::getItemId, itemId);
+        }
+        wrapper.eq(MesQcSeedIndicatorRangeDO::getIndicatorCode, indicatorCode);
+        return selectOne(wrapper);
+    }
 }

--
Gitblit v1.9.3