package com.chinaztt.mes.plan.excel; import com.alibaba.excel.annotation.ExcelProperty; import com.chinaztt.mes.warehouse.util.LocalDateStringConverter; import lombok.Data; import java.math.BigDecimal; import java.time.LocalDateTime; @Data public class ManufacturingOrderData { @ExcelProperty(value = "状态") private String state; @ExcelProperty(value = "车间") private String workShop; @ExcelProperty(value = "车间订单工序") private String operationNames; @ExcelProperty(value = "当前工序") private String currentOperation; @ExcelProperty(value = "订单号") private String customerOrderNo; @ExcelProperty(value = "客户名称") private String customerName; @ExcelProperty(value = "生产计划号") private String mpsNo; @ExcelProperty(value = "印字要求") private String printRequirement; @ExcelProperty(value = "盘长要求") private String lengthRequirement; @ExcelProperty(value = "销售订单备注") private String orderRemark; @ExcelProperty(value = "车间订单类型") private String workshopTypeCode; @ExcelProperty(value = "车间订单号") private String moNo; @ExcelProperty(value = "制造属性") private String manufactureAttr; @ExcelProperty(value = "零件号") private String partNo; @ExcelProperty(value = "零件名称") private String partName; @ExcelProperty(value = "外护颜色") private String outerColor; @ExcelProperty(value = "绝缘颜色") private String insulationColor; @ExcelProperty(value = "需求数量") private BigDecimal qtyRequired; @ExcelProperty(value = "完成数量") private BigDecimal qtyFinished; @ExcelProperty(value = "单位") private String unit; @ExcelProperty(value = "需求日期") private String requiredDate; @ExcelProperty(value = "BOM状态") private String bomConfirmStatus; @ExcelProperty(value = "工艺状态") private String processConfirmStatus; @ExcelProperty(value = "检测标准状态") private String standardConfirmStatus; @ExcelProperty(value = "车间订单备注") private String remark; @ExcelProperty(value = "IFS订单号") private String ifsOrderNo; @ExcelProperty(value = "IFS下达号") private String ifsReleaseNo; @ExcelProperty(value = "IFS序列号") private String ifsSequenceNo; @ExcelProperty(value = "申请数量") private BigDecimal qtyApply; @ExcelProperty(value = "开始日期",converter = LocalDateStringConverter.class) private LocalDateTime startDate; @ExcelProperty(value = "到期日",converter = LocalDateStringConverter.class) private LocalDateTime endDate; @ExcelProperty(value = "订单同步IFS") private String ifsSync; @ExcelProperty(value = "工艺同步IFS") private String ifsRoutingOperationSync; @ExcelProperty(value = "物料同步IFS") private String ifsMatSync; @ExcelProperty(value = "工厂") private String factoryName; @ExcelProperty(value="更新时间",converter = LocalDateStringConverter.class) private LocalDateTime updateTime; @ExcelProperty(value = "更新人") private String updateUser; @ExcelProperty(value="创建时间",converter = LocalDateStringConverter.class) private LocalDateTime createTime; @ExcelProperty(value = "创建人") private String createUser; }