package cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo;
|
|
import cn.idev.excel.annotation.ExcelProperty;
|
import lombok.Data;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
/** 多工作表完整工艺路线导入数据，所有关联通过业务编码定位。 */
|
@Data
|
public class MesProRouteCompleteImportWorkbook {
|
|
private List<RouteRow> routes;
|
private List<ProductRow> products;
|
private List<ProcessRow> processes;
|
private List<OutputRow> outputs;
|
private List<InputRow> inputs;
|
|
@Data
|
public static class RouteRow {
|
@ExcelProperty("路线编码") private String routeCode;
|
@ExcelProperty("路线名称") private String name;
|
@ExcelProperty("路线说明") private String description;
|
@ExcelProperty("备注") private String remark;
|
}
|
|
@Data
|
public static class ProductRow {
|
@ExcelProperty("路线编码") private String routeCode;
|
@ExcelProperty("产品物料编码") private String itemCode;
|
@ExcelProperty("仓库编码") private String warehouseCode;
|
@ExcelProperty("库区编码") private String locationCode;
|
@ExcelProperty("库位编码") private String areaCode;
|
@ExcelProperty("生产数量") private Integer quantity;
|
@ExcelProperty("生产用时") private BigDecimal productionTime;
|
@ExcelProperty("时间单位") private String timeUnitType;
|
@ExcelProperty("备注") private String remark;
|
}
|
|
@Data
|
public static class ProcessRow {
|
@ExcelProperty("路线编码") private String routeCode;
|
@ExcelProperty("工序编码") private String processCode;
|
@ExcelProperty("排序") private Integer sort;
|
@ExcelProperty("工艺参数模板ID") private Long paramTemplateId;
|
@ExcelProperty("工序收率") private BigDecimal yieldRate;
|
@ExcelProperty("与下一工序关系") private Integer linkType;
|
@ExcelProperty("准备时间(分钟)") private Integer prepareTime;
|
@ExcelProperty("等待时间(分钟)") private Integer waitTime;
|
@ExcelProperty("甘特图颜色") private String colorCode;
|
@ExcelProperty("关键工序(是/否)") private String keyFlag;
|
@ExcelProperty("质检工序(是/否)") private String checkFlag;
|
@ExcelProperty("倒冲(是/否)") private String backflushFlag;
|
@ExcelProperty("备注") private String remark;
|
}
|
|
@Data
|
public static class OutputRow {
|
@ExcelProperty("路线编码") private String routeCode;
|
@ExcelProperty("工序编码") private String processCode;
|
@ExcelProperty("产出物料编码") private String itemCode;
|
@ExcelProperty("归属产品编码(空为通用)") private String productCode;
|
@ExcelProperty("排序") private Integer sort;
|
@ExcelProperty("备注") private String remark;
|
}
|
|
@Data
|
public static class InputRow {
|
@ExcelProperty("路线编码") private String routeCode;
|
@ExcelProperty("工序编码") private String processCode;
|
@ExcelProperty("归属产品编码") private String productCode;
|
@ExcelProperty("投料物料编码") private String itemCode;
|
@ExcelProperty("用料比例") private BigDecimal quantity;
|
@ExcelProperty("备注") private String remark;
|
}
|
|
@Data
|
public static class GuideRow {
|
@ExcelProperty("工作表") private String sheet;
|
@ExcelProperty("填写说明") private String description;
|
|
public GuideRow(String sheet, String description) {
|
this.sheet = sheet;
|
this.description = description;
|
}
|
}
|
}
|
