军歌化工不合格台账

liyong

5 天以前 dde6b22ac257f6d432d9e38f80a0df77f9eb157a

军歌化工不合格台账

 src/main/java/com/ruoyi/quality/controller/QualityUnqualifiedOrderController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
package com.ruoyi.quality.controller;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.framework.web.domain.R;
import com.ruoyi.quality.dto.QualityUnqualifiedOrderDto;
import com.ruoyi.quality.service.QualityUnqualifiedOrderService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * <p>
 * å†›æ­ŒåŒ–工不合格品处理单 å‰ç«¯æŽ§åˆ¶å™¨
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2026-05-26 11:42:49
 */
@RestController
@RequestMapping("/qualityUnqualifiedOrder")
@Api(tags = "军歌化工不合格品处理单")
@AllArgsConstructor
public class QualityUnqualifiedOrderController {

    private final QualityUnqualifiedOrderService qualityUnqualifiedOrderService;


    @GetMapping("/listPage")
    @ApiOperation(value = "分页查询不合格品处理单列表")
    public R listPage(Page page, QualityUnqualifiedOrderDto qualityUnqualifiedOrder) {
        return R.ok(qualityUnqualifiedOrderService.listPage(page, qualityUnqualifiedOrder));
    }

    @PostMapping("/save")
    @ApiOperation(value = "保存不合格品处理单")
    public R save(@RequestBody QualityUnqualifiedOrderDto qualityUnqualifiedOrder) {
        return R.ok(qualityUnqualifiedOrderService.save(qualityUnqualifiedOrder));
    }

    @PutMapping("/update")
    @ApiOperation(value = "更新不合格品处理单")
    public R update(@RequestBody QualityUnqualifiedOrderDto qualityUnqualifiedOrder) {
        return R.ok(qualityUnqualifiedOrderService.updateById(qualityUnqualifiedOrder));
    }

    @DeleteMapping("/delete")
    @ApiOperation(value = "删除不合格品处理单")
    public R delete (@RequestBody List<Long> ids) {
        return R.ok(qualityUnqualifiedOrderService.removeByIds(ids));
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
package com.ruoyi.quality.dto;

import com.ruoyi.quality.pojo.QualityUnqualifiedOrder;
import lombok.Data;

@Data
public class QualityUnqualifiedOrderDto extends QualityUnqualifiedOrder {
}

 src/main/java/com/ruoyi/quality/mapper/QualityUnqualifiedOrderMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
package com.ruoyi.quality.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.quality.dto.QualityUnqualifiedOrderDto;
import com.ruoyi.quality.pojo.QualityUnqualifiedOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * å†›æ­ŒåŒ–工不合格品处理单 Mapper æŽ¥å£
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2026-05-26 11:42:49
 */
@Mapper
public interface QualityUnqualifiedOrderMapper extends BaseMapper<QualityUnqualifiedOrder> {

    IPage<QualityUnqualifiedOrderDto> listPage(Page page,@Param("ew") QualityUnqualifiedOrderDto qualityUnqualifiedOrder);

}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,142 @@
package com.ruoyi.quality.pojo;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import lombok.Setter;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * <p>
 * å†›æ­ŒåŒ–工不合格品处理单
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2026-05-26 11:42:49
 */
@Getter
@Setter
@TableName("quality_unqualified_order")
@ApiModel(value = "QualityUnqualifiedOrder对象", description = "军歌化工不合格品处理单")
public class QualityUnqualifiedOrder implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty("主键ID")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    @ApiModelProperty("处理单编号")
    private String orderNo;

    @ApiModelProperty("关联不合格记录ID")
    private Long unqualifiedId;

    @ApiModelProperty("项目名称")
    private String projectName;

    @ApiModelProperty("项目编号")
    private String projectNo;

    @ApiModelProperty("关联设备ID")
    private Long equipmentId;

    @ApiModelProperty("设备名称")
    private String equipmentName;

    @ApiModelProperty("设备图号")
    private String equipmentDrawingNo;

    @ApiModelProperty("物料/部件名称")
    private String materialName;

    @ApiModelProperty("物料图号")
    private String materialDrawingNo;

    @ApiModelProperty("型号规格")
    private String specificationModel;

    @ApiModelProperty("材质")
    private String materialQuality;

    @ApiModelProperty("数量")
    private BigDecimal quantity;

    @ApiModelProperty("不合格数量")
    private BigDecimal unqualifiedQuantity;

    @ApiModelProperty("不合格工序:1来料 2制程 3成品")
    private Byte unqualifiedProcess;

    @ApiModelProperty("供应商名称")
    private String supplierName;

    @ApiModelProperty("检验员")
    private String inspectorName;

    @ApiModelProperty("检验日期")
    private LocalDate inspectDate;

    @ApiModelProperty("责任人")
    private String responsiblePerson;

    @ApiModelProperty("责任部门")
    private String responsibleDept;

    @ApiModelProperty("问题描述")
    private String problemDescription;

    @ApiModelProperty("原因分析及建议")
    private String reasonAnalysis;

    @ApiModelProperty("纠正措施")
    private String correctionAction;

    @ApiModelProperty("处置方式:1让步接收 2厂内维修 3返厂维修 4换货 5退货 6报废")
    private Byte disposalMethod;

    @ApiModelProperty("厂内/返厂维修评估")
    private String repairEvaluation;

    @ApiModelProperty("预防措施")
    private String preventiveAction;

    @ApiModelProperty("状态:0草稿 1待审批 2审批中 3已完成 4已驳回")
    private Byte status;

    @ApiModelProperty("备注")
    private String remark;

    @ApiModelProperty("租户ID")
    @TableField(fill = FieldFill.INSERT)
    private Long tenantId;

    @ApiModelProperty("部门ID")
    private Long deptId;

    @ApiModelProperty("创建人")
    private Long createBy;

    @ApiModelProperty("创建时间")
    @TableField(fill = FieldFill.INSERT)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTime;

    @ApiModelProperty("更新人")
    private Long updateBy;

    @ApiModelProperty("更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;

    @ApiModelProperty("逻辑删除:0否 1是")
    private Byte deleted;
}

 src/main/java/com/ruoyi/quality/service/QualityUnqualifiedOrderService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
package com.ruoyi.quality.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.quality.dto.QualityUnqualifiedOrderDto;
import com.ruoyi.quality.pojo.QualityUnqualifiedOrder;
import com.baomidou.mybatisplus.extension.service.IService;

/**
 * <p>
 * å†›æ­ŒåŒ–工不合格品处理单 æœåŠ¡ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2026-05-26 11:42:49
 */
public interface QualityUnqualifiedOrderService extends IService<QualityUnqualifiedOrder> {

    IPage<QualityUnqualifiedOrderDto> listPage(Page page, QualityUnqualifiedOrderDto qualityUnqualifiedOrder);

}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,31 @@
package com.ruoyi.quality.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.quality.dto.QualityUnqualifiedOrderDto;
import com.ruoyi.quality.pojo.QualityUnqualifiedOrder;
import com.ruoyi.quality.mapper.QualityUnqualifiedOrderMapper;
import com.ruoyi.quality.service.QualityUnqualifiedOrderService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;

/**
 * <p>
 * å†›æ­ŒåŒ–工不合格品处理单 æœåŠ¡å®žçŽ°ç±»
 * </p>
 *
 * @author èŠ¯å¯¼è½¯ä»¶ï¼ˆæ±Ÿè‹ï¼‰æœ‰é™å…¬å¸
 * @since 2026-05-26 11:42:49
 */
@Service
@RequiredArgsConstructor
public class QualityUnqualifiedOrderServiceImpl extends ServiceImpl<QualityUnqualifiedOrderMapper, QualityUnqualifiedOrder> implements QualityUnqualifiedOrderService {

    private final QualityUnqualifiedOrderMapper qualityUnqualifiedOrderMapper;

    @Override
    public IPage<QualityUnqualifiedOrderDto> listPage(Page page, QualityUnqualifiedOrderDto qualityUnqualifiedOrder) {
        return qualityUnqualifiedOrderMapper.listPage(page,qualityUnqualifiedOrder);
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,58 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.quality.mapper.QualityUnqualifiedOrderMapper">

    <!-- é€šç”¨æŸ¥è¯¢æ˜ å°„结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.quality.pojo.QualityUnqualifiedOrder">
        <id column="id" property="id" />
        <result column="order_no" property="orderNo" />
        <result column="unqualified_id" property="unqualifiedId" />
        <result column="project_name" property="projectName" />
        <result column="project_no" property="projectNo" />
        <result column="equipment_name" property="equipmentName" />
        <result column="equipment_drawing_no" property="equipmentDrawingNo" />
        <result column="material_name" property="materialName" />
        <result column="material_drawing_no" property="materialDrawingNo" />
        <result column="specification_model" property="specificationModel" />
        <result column="material_quality" property="materialQuality" />
        <result column="quantity" property="quantity" />
        <result column="unqualified_quantity" property="unqualifiedQuantity" />
        <result column="unqualified_process" property="unqualifiedProcess" />
        <result column="supplier_name" property="supplierName" />
        <result column="inspector_name" property="inspectorName" />
        <result column="inspect_date" property="inspectDate" />
        <result column="responsible_person" property="responsiblePerson" />
        <result column="responsible_dept" property="responsibleDept" />
        <result column="problem_description" property="problemDescription" />
        <result column="reason_analysis" property="reasonAnalysis" />
        <result column="correction_action" property="correctionAction" />
        <result column="disposal_method" property="disposalMethod" />
        <result column="repair_evaluation" property="repairEvaluation" />
        <result column="preventive_action" property="preventiveAction" />
        <result column="status" property="status" />
        <result column="remark" property="remark" />
        <result column="tenant_id" property="tenantId" />
        <result column="dept_id" property="deptId" />
        <result column="create_by" property="createBy" />
        <result column="create_time" property="createTime" />
        <result column="update_by" property="updateBy" />
        <result column="update_time" property="updateTime" />
        <result column="deleted" property="deleted" />
    </resultMap>
    <select id="listPage" resultType="com.ruoyi.quality.dto.QualityUnqualifiedOrderDto">
        select * from
            quality_unqualified_order
        <where>
            <if test="ew.status != null">
                status = #{ew.status}
            </if>
            <if test="ew.projectName != null">
                project_name = #{ew.projectName}
            </if>
            <if test="ew.orderNo != null">
                tenant_id = #{ew.orderNo}
            </if>
        </where>
    </select>

</mapper>