package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import com.doumee.core.model.LoginUserModel; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.math.BigDecimal; import java.util.Date; /** * 运维盘点信息表 * @author 江蹄蹄 * @date 2025/01/06 11:05 */ @Data @ApiModel("运维盘点信息表") @TableName("`yw_stocktaking`") public class YwStocktaking extends LoginUserModel { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主键", example = "1") @ExcelColumn(name="主键") private Integer id; @ApiModelProperty(value = "创建人编码", example = "1") @ExcelColumn(name="创建人编码") private Integer creator; @ApiModelProperty(value = "创建时间") @ExcelColumn(name="创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date createDate; @ApiModelProperty(value = "更新人编码", example = "1") @ExcelColumn(name="更新人编码") private Integer editor; @ApiModelProperty(value = "更新时间") @ExcelColumn(name="更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date editDate; @ApiModelProperty(value = "是否删除0否 1是", example = "1") @ExcelColumn(name="是否删除0否 1是") private Integer isdeleted; @ApiModelProperty(value = "位置") @ExcelColumn(name="位置") private String position; @ApiModelProperty(value = "备注") @ExcelColumn(name="备注") private String remark; @ApiModelProperty(value = "状态 0未开始 1进行中 2已完成 3已取消", example = "1") @ExcelColumn(name="状态 0未开始 1进行中 2已完成 3已取消") private Integer status; @ApiModelProperty(value = "盘点员编码(关联system_user)") @ExcelColumn(name="盘点员编码(关联system_user)") private Integer userId; @ApiModelProperty(value = "名称") @ExcelColumn(name="名称") private String name; @ApiModelProperty(value = "盘点时间") @ExcelColumn(name="盘点时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date planDate; @ApiModelProperty(value = "编号") @ExcelColumn(name="编号") private String code; @ApiModelProperty(value = "仓库编码(关联yw_warehouse)") @ExcelColumn(name="仓库编码(关联yw_warehouse)") private Integer warehouseId; @ApiModelProperty(value = "开始处理人(关联system_user)", example = "1") @ExcelColumn(name="开始处理人(关联system_user)") private Integer dealUserId; @ApiModelProperty(value = "开始时间") @ExcelColumn(name="开始时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date dealDate; @ApiModelProperty(value = "开始备注") @ExcelColumn(name="开始备注") private String dealInfo; @ApiModelProperty(value = "已盘点物资数量", example = "1") @ExcelColumn(name="已盘点物资数量") private Integer doneNum; @ApiModelProperty(value = "未盘点物资数量", example = "1") @ExcelColumn(name="未盘点物资数量") private Integer waitNum; @ApiModelProperty(value = "总物资数量", example = "1") @ExcelColumn(name="总物资数量") private Integer totalNum; @ApiModelProperty(value = "盘盈物资数量", example = "1") @ExcelColumn(name="盘盈物资数量") private Integer profitNum; @ApiModelProperty(value = "盘亏物资数量", example = "1") @ExcelColumn(name="盘亏物资数量") private Integer lossNum; @ApiModelProperty(value = "账实相符物资数量", example = "1") @ExcelColumn(name="账实相符物资数量") private Integer equalNum; @ApiModelProperty(value = "完成处理人(关联system_user)", example = "1") @ExcelColumn(name="完成处理人(关联system_user)") private Integer doneUserId; @ApiModelProperty(value = "完成时间") @ExcelColumn(name="完成时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date doneDate; @ApiModelProperty(value = "完成备注") @ExcelColumn(name="完成备注") private String doneInfo; @ApiModelProperty(value = "取消处理人(关联system_user)", example = "1") @ExcelColumn(name="取消处理人(关联system_user)") private Integer cancelUserId; @ApiModelProperty(value = "取消时间") @ExcelColumn(name="取消时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date cancelDate; @ApiModelProperty(value = "取消备注") @ExcelColumn(name="取消备注") private String cancelInfo; @ApiModelProperty(value = "仓库名称") @TableField(exist = false) private String warehouseName; @ApiModelProperty(value = "创建人名称") @TableField(exist = false) private String createName; @ApiModelProperty(value = "盘点员名称") @TableField(exist = false) private String userName; @ApiModelProperty(value = "已盘记录数") @TableField(exist = false) private Integer finishAmount; @ApiModelProperty(value = "未盘记录数") @TableField(exist = false) private Integer unFinishAmount; @ApiModelProperty(value = "盘盈记录数") @TableField(exist = false) private Integer profitAmount; @ApiModelProperty(value = "盘亏记录数") @TableField(exist = false) private Integer lossAmount; @ApiModelProperty(value = "相符记录数") @TableField(exist = false) private Integer equalAmount; }