From 35a8e2f73dd2a959409d07b1bd657580662b6956 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期二, 24 三月 2026 13:03:44 +0800
Subject: [PATCH] feat: 根据产品规格获取产品名称
---
src/main/java/com/ruoyi/production/service/ProductMaterialService.java | 3 +++
src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java | 5 +++++
src/main/java/com/ruoyi/production/mapper/ProductMaterialMapper.java | 3 +++
src/main/resources/mapper/production/ProductMaterialMapper.xml | 16 ++++++++++++++++
4 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ruoyi/production/mapper/ProductMaterialMapper.java b/src/main/java/com/ruoyi/production/mapper/ProductMaterialMapper.java
index 277d9e1..1c5a682 100644
--- a/src/main/java/com/ruoyi/production/mapper/ProductMaterialMapper.java
+++ b/src/main/java/com/ruoyi/production/mapper/ProductMaterialMapper.java
@@ -13,4 +13,7 @@
* @since 2026/03/11 16:35
*/
public interface ProductMaterialMapper extends BaseMapper<ProductMaterial> {
+
+ String selectProductModelIdByName(Long productModelId);
+
}
diff --git a/src/main/java/com/ruoyi/production/service/ProductMaterialService.java b/src/main/java/com/ruoyi/production/service/ProductMaterialService.java
index 75a32cc..b2c451b 100644
--- a/src/main/java/com/ruoyi/production/service/ProductMaterialService.java
+++ b/src/main/java/com/ruoyi/production/service/ProductMaterialService.java
@@ -30,4 +30,7 @@
void deleteProductMaterial(List<Long> ids);
List<ProductMaterialGroupDto> productMaterialListByQuery(String materialName, Integer materialTypeId);
+
+ String selectProductModelIdByName(Long productId);
+
}
diff --git a/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java b/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java
index 1336736..d8ad015 100644
--- a/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java
+++ b/src/main/java/com/ruoyi/production/service/impl/ProductMaterialServiceImpl.java
@@ -409,6 +409,11 @@
log.info("鍒犻櫎鐗╂枡鎴愬姛 ids={}", ids);
}
+ @Override
+ public String selectProductModelIdByName(Long productId) {
+ return baseMapper.selectProductModelIdByName(productId);
+ }
+
private void validateProductMaterial(ProductMaterial productMaterial, boolean requireId) {
if (productMaterial == null) {
throw new ServiceException("鍙傛暟涓嶈兘涓虹┖");
diff --git a/src/main/resources/mapper/production/ProductMaterialMapper.xml b/src/main/resources/mapper/production/ProductMaterialMapper.xml
index 827273a..7e014c9 100644
--- a/src/main/resources/mapper/production/ProductMaterialMapper.xml
+++ b/src/main/resources/mapper/production/ProductMaterialMapper.xml
@@ -16,4 +16,20 @@
<result property="updateTime" column="update_time"/>
</resultMap>
+ <select id="selectProductModelIdByName" resultType="java.lang.String" parameterType="java.lang.Long">
+ select pm.product_name
+ from product_material pm
+ left join product_material_sku pms on pms.product_id = pm.id
+ <where>
+ <choose>
+ <when test="productModelId != null">
+ pms.id = #{productModelId}
+ </when>
+ <otherwise>
+ 1 = 0
+ </otherwise>
+ </choose>
+ </where>
+ </select>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3