From 3637c851cf6a63fc9cf2d8eab6a3fb139937aa71 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期四, 10 四月 2025 13:56:42 +0800
Subject: [PATCH] 原辅材下单标准展示
---
basic-server/src/main/resources/mapper/StandardProductListMapper.xml | 29 ++++++++++++++++++-----------
1 files changed, 18 insertions(+), 11 deletions(-)
diff --git a/basic-server/src/main/resources/mapper/StandardProductListMapper.xml b/basic-server/src/main/resources/mapper/StandardProductListMapper.xml
index a85d156..c375e2d 100644
--- a/basic-server/src/main/resources/mapper/StandardProductListMapper.xml
+++ b/basic-server/src/main/resources/mapper/StandardProductListMapper.xml
@@ -165,21 +165,28 @@
</update>
<select id="standardProductListNoPage" resultType="com.ruoyi.basic.pojo.StandardProductList">
- SELECT * FROM standard_product_list
+ SELECT
+ spl.*,
+ sm.code as methodS
+ FROM
+ standard_product_list spl
+ LEFT JOIN
+ standard_method sm ON sm.id = spl.standard_method_list_id
<where>
- <if test="standardProductListDto.standardMethodListIds != null">
- AND standard_method_list_id IN
- <foreach collection="standardProductListDto.standardMethodListIds" open="(" close=")" separator="," item="item">
- #{item}
- </foreach>
+ <if test="standardProductListDto.standardMethodListIds != null and standardProductListDto.standardMethodListIds.size() > 0">
+ spl.standard_method_list_id IN
+ <foreach collection="standardProductListDto.standardMethodListIds" open="(" close=")" separator="," item="item">
+ #{item}
+ </foreach>
</if>
- <if test="standardProductListDto.tree != null and standardProductListDto.tree != '' ">
- AND tree = #{standardProductListDto.tree}
+ <if test="standardProductListDto.tree != null and standardProductListDto.tree != ''">
+ AND spl.tree = #{standardProductListDto.tree}
</if>
- <if test="standardProductListDto.state != null ">
- AND state = #{standardProductListDto.state}
+ <if test="standardProductListDto.state != null">
+ AND spl.state = #{standardProductListDto.state}
</if>
</where>
- ORDER BY standard_method_list_id ASC
+ ORDER BY
+ spl.standard_method_list_id ASC
</select>
</mapper>
--
Gitblit v1.9.3