feat(quality): 添加产品质量不合格记录中的产品型号ID字段

liyong

8 天以前 8d1f92edc90852b07a95f297b661adbd6f540c0b

feat(quality): 添加产品质量不合格记录中的产品型号ID字段

- 在QualityUnqualified实体类中新增productModelId字段
- 在质量检验服务实现中将检验记录的产品型号ID复制到不合格记录
- 更新MyBatis映射文件中产品型号关联的字段名从model改为product_model_id

 src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java

@@ -143,4 +143,7 @@

    @TableField(fill = FieldFill.INSERT)
    private Long deptId;

    @Schema(description = "关联产品型号id")
    private Long productModelId;
}

 src/main/java/com/ruoyi/quality/service/impl/QualityInspectServiceImpl.java

@@ -93,6 +93,7 @@
            QualityUnqualified qualityUnqualified = new QualityUnqualified();
            BeanUtils.copyProperties(qualityInspect, qualityUnqualified);
            qualityUnqualified.setInspectState(0);//待处理
            qualityUnqualified.setProductModelId(qualityInspect.getProductModelId());
            List<QualityInspectParam> inspectParams = qualityInspectParamService.list(Wrappers.<QualityInspectParam>lambdaQuery().eq(QualityInspectParam::getInspectId, inspect.getId()));
            String text = inspectParams.stream().map(QualityInspectParam::getParameterItem).collect(Collectors.joining(","));
            qualityUnqualified.setDefectivePhenomena(text + "这些指标中存在不合格");//不合格现象

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

@@ -84,7 +84,7 @@
                ELSE false
                END AS method
        FROM quality_unqualified qu
                 LEFT JOIN product_model pm ON qu.model = pm.id
                 LEFT JOIN product_model pm ON qu.product_model_id = pm.id
        where
            1=1
        and qu.id = #{id}