原辅材下单标准展示

liding

2025-04-10 3637c851cf6a63fc9cf2d8eab6a3fb139937aa71

原辅材下单标准展示

 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>