package com.chinaztt.mes.warehouse.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; /** * @Author: yangyao * @Date: 2022-10-17 9:30 */ @Data public class InventoryData { @ExcelProperty("盘点编号") private String inyNo; @ExcelProperty(value="盘点描述") private String inyDesc; @ExcelProperty(value="状态") private String inyStatus; @ExcelProperty(value="创建人") private String createUser; @ExcelProperty(value="创建时间",converter = LocalDateStringConverter.class) private LocalDateTime createTime; @ExcelProperty(value="零件号") private String partNo; @ExcelProperty(value="零件名称") private String partName; @ExcelProperty(value="计划方法(只能传A、K、P)") private String planningMethod; @ExcelProperty(value="sn号") private String sn; @ExcelProperty(value="ifs批次号") private String ifsBatchNo; @ExcelProperty(value="仓库") private String warehouseName; @ExcelProperty(value="库位编号") private String locNo; @ExcelProperty(value="库存数量") private BigDecimal stockQuantity; @ExcelProperty(value="盘点数量") private BigDecimal inyQty; @ExcelProperty(value="盘点差异数量") private BigDecimal inyDiffQty; @ExcelProperty(value="扫码提交次数") private Long commitNum; @ExcelProperty(value="单位") private String unit; }