更新散装件审批

whycxzp

2022-08-11 3ad798d9cd0f5579506ce9c086a6b6c4e6d14d2b

更新散装件审批

 src/main/java/com/whyc/pojo/ComponentApproving.java

New file
@@ -0,0 +1,224 @@
package com.whyc.pojo;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModelProperty;
import org.apache.ibatis.type.Alias;

import java.util.Date;
import java.util.List;

/**
 * 散装件
 */
@TableName(schema = "db_doc",value = "tb_component_approving")
@Alias("ComponentApproving")
public class ComponentApproving {

    private Integer   id;
    @ApiModelProperty("母料编号")
    private String type;
    @ApiModelProperty("类别")
    private String     category;
    @ApiModelProperty("子件编码")
    private String     subCode;
    @ApiModelProperty("子件名称")
    private String     subName;
    @ApiModelProperty("子件型号")
    private String     subModel;
    @ApiModelProperty("单位")
    private String     unit;
    @ApiModelProperty("子件数量")
    private Integer   quantity;
    @ApiModelProperty("生产商")
    private String     producer;
    @ApiModelProperty("封装类型/材质")
    private String     material;
    @ApiModelProperty("元件编号/料厚")
    private String     thickness;
    @ApiModelProperty("表面处理/物料详情")
    private String     surfaceDetail;
    @ApiModelProperty("备注")
    private String     notes;
    private String     pictureUrl;
    private String     fileUrl;
    @ApiModelProperty("上传人")
    private Long     upUserId;
    private Date    createDate;
    private Date updateDate;
    @ApiModelProperty(value = "是否可以表示",notes ="1可用，0不可用")
    private int status;

    @ApiModelProperty("工程图纸url")
    private String dwgUrl;

    private Integer mainId;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public String getCategory() {
        return category;
    }

    public void setCategory(String category) {
        this.category = category;
    }

    public String getSubCode() {
        return subCode;
    }

    public void setSubCode(String subCode) {
        this.subCode = subCode;
    }

    public String getSubName() {
        return subName;
    }

    public void setSubName(String subName) {
        this.subName = subName;
    }

    public String getSubModel() {
        return subModel;
    }

    public void setSubModel(String subModel) {
        this.subModel = subModel;
    }

    public String getUnit() {
        return unit;
    }

    public void setUnit(String unit) {
        this.unit = unit;
    }

    public Integer getQuantity() {
        return quantity;
    }

    public void setQuantity(Integer quantity) {
        this.quantity = quantity;
    }

    public String getProducer() {
        return producer;
    }

    public void setProducer(String producer) {
        this.producer = producer;
    }

    public String getMaterial() {
        return material;
    }

    public void setMaterial(String material) {
        this.material = material;
    }

    public String getThickness() {
        return thickness;
    }

    public void setThickness(String thickness) {
        this.thickness = thickness;
    }

    public String getSurfaceDetail() {
        return surfaceDetail;
    }

    public void setSurfaceDetail(String surfaceDetail) {
        this.surfaceDetail = surfaceDetail;
    }

    public String getNotes() {
        return notes;
    }

    public void setNotes(String notes) {
        this.notes = notes;
    }

    public String getPictureUrl() {
        return pictureUrl;
    }

    public void setPictureUrl(String pictureUrl) {
        this.pictureUrl = pictureUrl;
    }

    public String getFileUrl() {
        return fileUrl;
    }

    public void setFileUrl(String fileUrl) {
        this.fileUrl = fileUrl;
    }

    public Long getUpUserId() {
        return upUserId;
    }

    public void setUpUserId(Long upUserId) {
        this.upUserId = upUserId;
    }

    public Date getCreateDate() {
        return createDate;
    }

    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    public Date getUpdateDate() {
        return updateDate;
    }

    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }

    public String getDwgUrl() {
        return dwgUrl;
    }

    public void setDwgUrl(String dwgUrl) {
        this.dwgUrl = dwgUrl;
    }

    public int getStatus() {
        return status;
    }

    public void setStatus(int status) {
        this.status = status;
    }

    public Integer getMainId() {
        return mainId;
    }

    public void setMainId(Integer mainId) {
        this.mainId = mainId;
    }
}

 src/main/java/com/whyc/service/ComponentApprovingService.java

@@ -2,6 +2,8 @@

import com.whyc.dto.FileUrlDTO;
import com.whyc.dto.Response;
import com.whyc.pojo.ComponentApproving;
import com.whyc.pojo.ComponentProductApproving;
import com.whyc.pojo.DocUser;
import com.whyc.pojo.ProductBomApproving;
import com.whyc.util.ActionUtil;
@@ -32,8 +34,7 @@
     * @throws InvalidFormatException
     */
    public Response zipParse(MultipartFile file) throws IOException, InvalidFormatException {
        List<ProductBomApproving> list = new LinkedList<>();
        List<ProductBomApproving> referenceList = new LinkedList<>();
        List<ComponentApproving> list = new LinkedList<>();
        Response response = new Response();
        //检查是否为zip
        boolean isZip = Zip4jUtil.checkZipFileParam(file);
@@ -82,11 +83,7 @@
                Row row3 = sheet.getRow(3);
                String productVersion = row3.getCell(5).getStringCellValue();
                for (int l = 8; l < lastRowNum-1; l++) {
                    ProductBomApproving bomApproving = new ProductBomApproving();
                    bomApproving.setParentModel(productModel);
                    bomApproving.setParentVersion(productVersion);
                    bomApproving.setType(type);
                    bomApproving.setExcelName(fileTempUrl.substring(fileTempUrl.lastIndexOf(File.separator)+1));
                    ComponentApproving approving = new ComponentApproving();

                    for (int m = 2; m < lastCellNum; m++) {
                        row = sheet.getRow(l);
@@ -107,18 +104,17 @@
                        }

                        switch (m){
                            case 2:{bomApproving.setCategory(cellValue);}break;
                            case 3:{bomApproving.setSubCode(cellValue);}break;
                            case 4:{bomApproving.setSubName(cellValue);}break;
                            case 5:{
                            }break;
                            case 6:{bomApproving.setMaterial(cellValue);}break;
                            case 7:{bomApproving.setThickness(cellValue);}break;
                            case 8:{bomApproving.setQuantity(cellValueDouble.intValue());}break;
                            case 9:{bomApproving.setSurfaceDetail(cellValue);}break;
                            case 2:{approving.setCategory(cellValue);}break;
                            case 3:{approving.setSubCode(cellValue);}break;
                            case 4:{approving.setSubName(cellValue);}break;
                            case 5:{approving.setSubModel(cellValue);}break;
                            case 6:{approving.setUnit(cellValue);}break;
                            case 7:{approving.setQuantity(cellValueDouble.intValue());}break;
                            case 8:{approving.setProducer(cellValue);}break;
                            case 9:{approving.setNotes(cellValue);}break;
                        }
                    }
                    list.add(bomApproving);
                    list.add(approving);
                }
            }
        }