package com.dk.mdm.model.pojo.ivt; import cn.afterturn.easypoi.excel.annotation.Excel; import com.baomidou.mybatisplus.annotation.*; import java.io.Serializable; import com.dk.common.infrastructure.annotaiton.ExportTitle; import com.dk.common.infrastructure.handler.*; import com.dk.common.model.pojo.PageInfo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import lombok.AllArgsConstructor; import lombok.NoArgsConstructor; import lombok.EqualsAndHashCode; import lombok.experimental.Accessors; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import java.math.BigDecimal; import java.time.LocalDate; import java.time.LocalDateTime; /** * 盘点单明细 */ @Data @AllArgsConstructor @NoArgsConstructor @EqualsAndHashCode(callSuper = true) @Accessors(chain = true) @ExportTitle("盘点单明细") @TableName(value = "t_psi_check_item", autoResultMap = true, schema = "dkic_b") @ApiModel(value="实体类:盘点单明细", description="表名:t_psi_check_item") public class CheckItem extends PageInfo implements Serializable { /* * 数据库字段 */ /** * 明细ID */ @TableId(value = "item_id", type = IdType.AUTO) @ApiModelProperty(value = "明细ID") @TableField(typeHandler = UuidTypeHandler.class) private String itemId; /** * 盘点ID */ @Excel(name = "盘点ID") @ApiModelProperty(value = "盘点ID") @TableField(typeHandler = UuidTypeHandler.class) private String checkId; /** * 商品顺序 */ @Excel(name = "商品顺序") @ApiModelProperty(value = "商品顺序") private Integer itemIndex; /** * 商品ID */ @Excel(name = "商品ID") @ApiModelProperty(value = "商品ID") @TableField(typeHandler = UuidTypeHandler.class) private String skuId; @Excel(name = "箱") @ApiModelProperty(value = "箱") private Integer box; @Excel(name = "片") @ApiModelProperty(value = "片") private Integer piece; @Excel(name = "包装") @ApiModelProperty(value = "包装") private Integer packBox; /** * 基本单位 */ @ApiModelProperty(value = "基本单位") @TableField(typeHandler = UuidTypeHandler.class) private String unitId; /** * 包装单位 */ @ApiModelProperty(value = "包装单位") @TableField(typeHandler = UuidTypeHandler.class) private String subUnitId; /** * 库存ID */ @Excel(name = "库存ID") @ApiModelProperty(value = "库存ID") @TableField(typeHandler = UuidTypeHandler.class) private String invId; /** * 库存数量 */ @Excel(name = "库存数量") @ApiModelProperty(value = "库存数量") private BigDecimal invQty; /** * 盘点数量 */ @Excel(name = "盘点数量") @ApiModelProperty(value = "盘点数量") private BigDecimal checkQty; /** * 差异数量 (库存数量-出库中数量) */ @Excel(name = "差异数量 (库存数量-出库中数量)") @ApiModelProperty(value = "差异数量 (库存数量-出库中数量)") private BigDecimal balanceQty; /** * 责任人 (盘亏需要有责任人) */ @Excel(name = "责任人 (盘亏需要有责任人)") @ApiModelProperty(value = "责任人 (盘亏需要有责任人)") @TableField(typeHandler = UuidTypeHandler.class) private String staffId; /** * 盘亏原因 (【数据字典】) */ @Excel(name = "盘亏原因 (【数据字典】)") @ApiModelProperty(value = "盘亏原因 (【数据字典】)") @TableField(typeHandler = UuidTypeHandler.class) private String lossReason; /** * 盘点日期 */ @Excel(name = "盘点日期") @ApiModelProperty(value = "盘点日期") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDate checkDate; /** * 备注 */ @Excel(name = "备注") @ApiModelProperty(value = "备注") private String remarks; /** * 有效标识 (1:正常 0:停用) */ @Excel(name = "有效标识 (1:正常 0:停用)") @ApiModelProperty(value = "有效标识 (1:正常 0:停用)") private Boolean flgValid; /** * 企业ID */ @TableField(fill = FieldFill.INSERT) @Excel(name = "企业ID") @ApiModelProperty(value = "企业ID") private Integer cpId; /** * 创建时间 (触发器自动处理) */ @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20) @ApiModelProperty(value = "创建时间 (触发器自动处理)") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime opCreateTime; /** * 创建用户 (触发器自动处理) */ @Excel(name = "创建用户 (触发器自动处理)") @ApiModelProperty(value = "创建用户 (触发器自动处理)") @TableField(typeHandler = UuidTypeHandler.class) private String opCreateUserId; /** * 修改时间 (触发器自动处理) */ @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20) @ApiModelProperty(value = "修改时间 (触发器自动处理)") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime opUpdateTime; /** * 修改用户 (触发器自动处理) */ @Excel(name = "修改用户 (触发器自动处理)") @ApiModelProperty(value = "修改用户 (触发器自动处理)") @TableField(typeHandler = UuidTypeHandler.class) private String opUpdateUserId; /** * 数据操作应用 (触发器自动处理) */ @Excel(name = "数据操作应用 (触发器自动处理)") @ApiModelProperty(value = "数据操作应用 (触发器自动处理)") private String opAppCode; /** * 数据时间戳 (触发器自动处理) */ @Excel(name = "数据时间戳 (触发器自动处理)") @ApiModelProperty(value = "数据时间戳 (触发器自动处理)") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime opTimestamp; /** * 数据操作数据库用户 (触发器自动处理) */ @Excel(name = "数据操作数据库用户 (触发器自动处理)") @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)") private String opDbUser; /** * 原库存数量 */ @Excel(name = "原库存数量") @ApiModelProperty(value = "原库存数量") private BigDecimal oInvQty; /** * 入库价 */ @Excel(name = "入库价") @ApiModelProperty(value = "入库价") private BigDecimal priceInto; /** * 入库中金额 */ @Excel(name = "入库中金额") @ApiModelProperty(value = "入库中金额") private BigDecimal intoingAmt; /* * 相关属性 * @TableField(exist = false) */ /* * 关联属性 + 查询条件 * @TableField(exist = false) */ private static final long serialVersionUID = 1L; }