package com.ruoyi.inspect.excel; import com.alibaba.excel.annotation.ExcelProperty; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import java.time.LocalDate; @Data public class InsUnqualifiedHandlerExcelData { @ExcelProperty("域") private String contract; @ExcelProperty(value = "编号") private String no; @ExcelProperty("OA流程状态") private String operation; @ExcelProperty("订单号") private String orderNo; @ExcelProperty("零件号") private String partNo; @ExcelProperty("零件描述") private String partDesc; @ExcelProperty("物料属性") private String materialProp; @ExcelProperty(value = "物料名称") private String materialName; @ExcelProperty(value = "生产批次") private String productionBatch; @ExcelProperty(value = "到货数量") private String cargoQuantity; @ExcelProperty(value = "规格型号") private String specsModels; @ExcelProperty(value = "报检日期") @JsonFormat(pattern = "yyyy-MM-dd") private LocalDate inspectTime; @ExcelProperty(value = "反馈人") private String feedbackUser; @ExcelProperty(value = "反馈日期") @JsonFormat(pattern = "yyyy-MM-dd") private LocalDate feedbackTime; @ExcelProperty(value = "分类") private String classification; @ExcelProperty(value = "不合格归属") private String offGradeAscription; @ExcelProperty(value = "不合格描述") private String unqualifiedDesc; @ExcelProperty("供应商名称") private String supplierName; }