指标绑定调整关联产品id

zss

2 天以前 83d3c6ec7fc56157d7624ab2dc98d5aed0943d9b

指标绑定调整关联产品id

 src/main/java/com/ruoyi/quality/dto/QualityTestStandardBindingDto.java

@@ -8,6 +8,8 @@
public class QualityTestStandardBindingDto {

    private String productName;
    private String model;
    private String materialCode;

    private Long qualityTestStandardBindingId;
}

 src/main/resources/mapper/quality/QualityTestStandardBindingMapper.xml

@@ -14,10 +14,13 @@
        <result column="tenant_id" property="tenantId"/>
    </resultMap>
    <select id="listBinding" resultType="com.ruoyi.quality.dto.QualityTestStandardBindingDto">
        select t2.product_name,
        select t3.product_name ,
               t2.model ,
               t2.material_code ,
               t1.id qualityTestStandardBindingId
        from quality_test_standard_binding t1
                 left join product t2 on t1.product_id = t2.id
                 left join product_material_sku t2 on t1.product_id = t2.id
                 left join product_material t3 on t2.product_id = t3.id
        where t1.test_standard_id = #{testStandardId}
    </select>