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; } }