package cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo;
|
|
import cn.idev.excel.annotation.ExcelProperty;
|
import cn.idev.excel.annotation.write.style.HeadFontStyle;
|
import lombok.Data;
|
import java.math.BigDecimal;
|
|
/** 工艺流程分表模板。字段映射到既有完整模板，保持导入语义一致。 */
|
public final class MesProRouteWorkbookVO {
|
private MesProRouteWorkbookVO() {}
|
@Data public static class Basic {
|
@HeadFontStyle(color = 10) @ExcelProperty("路线编码") private String routeCode;
|
@HeadFontStyle(color = 10) @ExcelProperty("路线名称") private String routeName;
|
@ExcelProperty("路线说明") private String routeDescription;
|
@ExcelProperty("路线备注") private String routeRemark;
|
@ExcelProperty("填写提示") private String guide;
|
}
|
@Data public static class Product {
|
@HeadFontStyle(color = 10) @ExcelProperty("产品编码") private String productCode;
|
@ExcelProperty("产品名称(参考)") private String productName;
|
@HeadFontStyle(color = 10) @ExcelProperty("模板产品(是/否)") private String templateReference;
|
@HeadFontStyle(color = 10) @ExcelProperty("仓库编码") private String warehouseCode;
|
@HeadFontStyle(color = 10) @ExcelProperty("库区编码") private String locationCode;
|
@HeadFontStyle(color = 10) @ExcelProperty("库位编码") private String areaCode;
|
@ExcelProperty("生产数量") private Integer quantity;
|
@ExcelProperty("生产用时") private BigDecimal productionTime;
|
@ExcelProperty("时间单位") private String timeUnitType;
|
@ExcelProperty("备注") private String productRemark;
|
}
|
@Data public static class Process {
|
@HeadFontStyle(color = 10) @ExcelProperty("工序编码") private String processCode;
|
@ExcelProperty("工序名称(参考)") private String processName;
|
@HeadFontStyle(color = 10) @ExcelProperty("顺序") private Integer processSort;
|
@ExcelProperty("关键工序(是/否)") private String keyFlag;
|
@ExcelProperty("质检(是/否)") private String checkFlag;
|
@ExcelProperty("倒冲(是/否)") private String backflushFlag;
|
@ExcelProperty("准备时间(分钟)") private Integer prepareTime;
|
@ExcelProperty("等待时间(分钟)") private Integer waitTime;
|
@ExcelProperty("下一工序关系") private String linkType;
|
@ExcelProperty("工序颜色") private String colorCode;
|
@ExcelProperty("备注") private String processRemark;
|
}
|
@Data public static class Output {
|
@HeadFontStyle(color = 10) @ExcelProperty("工序编码") private String processCode;
|
@ExcelProperty("工序名称(参考)") private String processName;
|
@ExcelProperty("归属产品") private String productCode;
|
@HeadFontStyle(color = 10) @ExcelProperty("产出物料") private String itemCode;
|
@ExcelProperty("产出名称(参考)") private String itemName;
|
@ExcelProperty("顺序") private Integer outputSort;
|
@ExcelProperty("备注") private String detailRemark;
|
}
|
@Data public static class Material {
|
@HeadFontStyle(color = 10) @ExcelProperty("工序编码") private String processCode;
|
@ExcelProperty("工序名称(参考)") private String processName;
|
@HeadFontStyle(color = 10) @ExcelProperty("归属产品") private String productCode;
|
@HeadFontStyle(color = 10) @ExcelProperty("投料物料编码") private String itemCode;
|
@ExcelProperty("投料名称(参考)") private String itemName;
|
@HeadFontStyle(color = 10) @ExcelProperty("用料比例") private BigDecimal bomQuantity;
|
@ExcelProperty("备注") private String detailRemark;
|
}
|
}
|
