package com.ruoyi.basic.pojo; import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; import com.alibaba.excel.annotation.ExcelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.v3.oas.annotations.media.Schema; import lombok.Data; import java.io.Serializable; import java.math.BigDecimal; import java.time.LocalDateTime; @Data @TableName("ifs_inventory_quantity") @ExcelIgnoreUnannotated public class IfsInventoryQuantity implements Serializable { @TableId(type = IdType.AUTO) private Long id; @Schema(description = "域") private String contract; @ExcelProperty(index = 13, value = "订单号") @Schema(description = "订单号") private String orderNo; @Schema(description = "行号") private String lineNo; @Schema(description = "下达号") private String releaseNo; @Schema(description = "接收号") private Integer receiptNo; @Schema(description = "订单类型(01raw:原材料,02wg:外购成品)") private String orderType; @Schema(description = "物料属性,用于区分铜、铝导体等零件") private String materialProp; @ExcelProperty(index = 3, value = "零件号") @Schema(description = "零件号") private String partNo; @ExcelProperty(index = 4, value = "零件描述") @Schema(description = "零件描述") private String partDesc; @Schema(description = "状态描述(IFS原本拉取的状态)") private String status; @Schema(description = "状态(IFS原本拉取的状态)") private String statusDb; @ExcelProperty(index = 11, value = "抵达的采购数量") @Schema(description = "抵达的采购数量") private BigDecimal qtyArrived; @Schema(description = "已检验的购买数量") private BigDecimal qtyInspected; @Schema(description = "要检验的采购数量") private BigDecimal qtyToInspect; @Schema(description = "供应商编号") private String supplierId; @ExcelProperty(index = 5, value = "供应商名称") @Schema(description = "供应商名称") private String supplierName; @Schema(description = "抵达的库存数量") private BigDecimal invQtyInStore; @Schema(description = "抵达的采购数量") private BigDecimal purQtyInStore; @Schema(description = "配置标识") private String configurationId; @Schema(description = "批号") private String lotBatchNo; @Schema(description = "wdr号") private String waivDevRejNo; @Schema(description = "活动序列") private Integer activitySeq; @Schema(description = "序列号") private String serialNo; @Schema(description = "库位号") private String locationNo; @Schema(description = "版本号") private String engChgLevel; @Schema(description = "接收人") private String receiver; @Schema(description = "接收人姓名") private String receiverName; @Schema(description = "采购员") private String buyerCode; @Schema(description = "采购员姓名") private String buyerName; @Schema(description = "实际到货日期") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime arriveDate; @Schema(description = "实际交货日期") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime deliveryDate; @Schema(description = "生产日期") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime productDate; @Schema(description = "失效日期") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime invalidDate; @Schema(description = "审批日期") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime approvedDate; @Schema(description = "采购申请创建人") private String reqCeater; @Schema(description = "采购申请创建人姓名") private String reqCeaterName; @Schema(description = "采购订单行备注") private String lineRemarks; @ExcelProperty(index = 12, value = "单位") @Schema(description = "单位") private String buyUnitMeas; @Schema(description = "是否为ifs拉取,0 否, 1是") private Integer isSource; private Integer number; @Schema(description = "状态: 0:待报检, 1:待检验, :已审核") private Integer state; @Schema(description = "接收时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime receiverDate; @Schema(description = "是否为首次出现 0 否 1 是") private Integer isFirst; @Schema(description = "目标库位号") private String toLocation; @Schema(description = "是否是报检 0 否 1 是") private Integer isInspect; @Schema(description = "报检人") private String declareUser; @Schema(description = "报检人id") private Integer declareUserId; @Schema(description = "单位") private String partUnit; @Schema(description = "产业链检测数据") private String industryChain; @Schema(description = "报检时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") private LocalDateTime declareDate; @Schema(description = "是否卡可以季度检验 0 否 1 是") private Integer isQuarter; // 修改后的 @ExcelProperty(index = 1, value = "批号") @Schema(description = "批号") private String updateBatchNo; @Schema(description = "是否结束, 0否, 1是") private Integer isFinish; @Schema(description = "是否是铜单丝, 0否, 1是") private Integer isCopper; // 合格状态,: 0 检验中, 1合格, 2不合格, 3未下单,4让步放行 @Schema(description = "检验状态") private Integer inspectStatus; @Schema(description = "是否采购订单登记: 0否, 1:是") private Integer isRegister; @Schema(description = "是否修改过批号: 0否, 1:是") private Integer isUpdateBatch; // 是否是过期材料: 0否, 1:是" @Schema(description = "物料类型") private Integer isExpire; @Schema(description = "是否为拆分订单(1:是,0:否)") private Integer isSplitOrder; }