package com.dk.mdm.model.query.ivt; import cn.afterturn.easypoi.excel.annotation.Excel; import com.baomidou.mybatisplus.annotation.*; import com.dk.common.infrastructure.annotaiton.ExportTitle; import com.dk.common.infrastructure.handler.TimestampTypeHandler; import com.dk.common.infrastructure.handler.UuidTypeHandler; import com.dk.common.model.pojo.PageInfo; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.AllArgsConstructor; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.NoArgsConstructor; import lombok.experimental.Accessors; import java.io.Serializable; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.List; /** * 盘点单 */ @Data @AllArgsConstructor @NoArgsConstructor @EqualsAndHashCode(callSuper = true) @Accessors(chain = true) @ExportTitle("盘点单") @TableName(value = "t_psi_check", autoResultMap = true) @ApiModel(value="实体类:盘点单", description="表名:t_psi_check") public class CheckQuery extends PageInfo implements Serializable { /* * 数据库字段 */ /** * 盘点ID */ @TableId(value = "check_id", type = IdType.AUTO) @ApiModelProperty(value = "盘点ID") @TableField(typeHandler = UuidTypeHandler.class) private String checkId; /** * 盘点单号 */ @Excel(name = "盘点单号") @ApiModelProperty(value = "盘点单号") private String checkNo; @ApiModelProperty(value = "入库时间开始") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") private LocalDate makeTimeStart; @ApiModelProperty(value = "入库时间结束") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") private LocalDate makeTimeEnd; /** * 部门 */ @Excel(name = "部门") @ApiModelProperty(value = "部门") @TableField(typeHandler = UuidTypeHandler.class) private String orgId; /** * 盘点员工 */ @Excel(name = "盘点员工") @ApiModelProperty(value = "盘点员工") @TableField(typeHandler = UuidTypeHandler.class) private String staffId; /** * 盘点日期 */ @Excel(name = "盘点日期") @ApiModelProperty(value = "盘点日期") @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDate checkDate; /** * 库区ID */ @Excel(name = "库区ID") @ApiModelProperty(value = "库区ID") @TableField(typeHandler = UuidTypeHandler.class) private String whId; /** * 制单员 */ @Excel(name = "制单员") @ApiModelProperty(value = "制单员") @TableField(typeHandler = UuidTypeHandler.class) private String makeStaff; /** * 制单时间 */ @Excel(name = "制单时间") @ApiModelProperty(value = "制单时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(typeHandler = TimestampTypeHandler.class) private LocalDateTime makeTime; /** * 有效标识 (1:正常 0:停用) */ @Excel(name = "有效标识 (1:正常 0:停用)") @ApiModelProperty(value = "有效标识 (1:正常 0:停用)") private Boolean flgValid; /** * 备注 */ @Excel(name = "备注") @ApiModelProperty(value = "备注") private String remarks; /** * 企业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 Boolean flgLock; /** * 盘点状态(系统字典) */ @Excel(name = "盘点状态(系统字典)") @ApiModelProperty(value = "盘点状态(系统字典)") private String checkStatus; /** * @desc : 有效标识List * @author : 宋扬 * @date : 2024/3/19 10:37 */ @Excel(name = "有效标识 (1:正常 0:停用)") @ApiModelProperty(value = "有效标识 (1:正常 0:停用)") private List flgValidList; /** * @desc : 组织名称 * @author : 宋扬 * @date : 2024/3/19 10:44 */ @ApiModelProperty(value = "组织名称") private List orgIdList; /** * @desc : 员工 * @author : 宋扬 * @date : 2024/3/19 10:46 */ @ApiModelProperty(value = "员工姓名") private List staffIdList; /** * @desc : 盘点状态 * @author : 宋扬 * @date : 2024/3/19 11:08 */ @ApiModelProperty(value = "盘点状态") private List checkStatusList; /* * 相关属性 * @TableField(exist = false) */ /* * 关联属性 + 查询条件 * @TableField(exist = false) */ private static final long serialVersionUID = 1L; }