CheckQuery.java 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270
  1. package com.dk.mdm.model.query.ivt;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.baomidou.mybatisplus.annotation.*;
  4. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  5. import com.dk.common.infrastructure.handler.TimestampTypeHandler;
  6. import com.dk.common.infrastructure.handler.UuidTypeHandler;
  7. import com.dk.common.model.pojo.PageInfo;
  8. import com.fasterxml.jackson.annotation.JsonFormat;
  9. import io.swagger.annotations.ApiModel;
  10. import io.swagger.annotations.ApiModelProperty;
  11. import lombok.AllArgsConstructor;
  12. import lombok.Data;
  13. import lombok.EqualsAndHashCode;
  14. import lombok.NoArgsConstructor;
  15. import lombok.experimental.Accessors;
  16. import java.io.Serializable;
  17. import java.time.LocalDate;
  18. import java.time.LocalDateTime;
  19. import java.util.List;
  20. /**
  21. * 盘点单
  22. */
  23. @Data
  24. @AllArgsConstructor
  25. @NoArgsConstructor
  26. @EqualsAndHashCode(callSuper = true)
  27. @Accessors(chain = true)
  28. @ExportTitle("盘点单")
  29. @TableName(value = "t_psi_check", autoResultMap = true)
  30. @ApiModel(value="实体类:盘点单", description="表名:t_psi_check")
  31. public class CheckQuery extends PageInfo<CheckQuery> implements Serializable {
  32. /*
  33. * 数据库字段
  34. */
  35. /**
  36. * 盘点ID
  37. */
  38. @TableId(value = "check_id", type = IdType.AUTO)
  39. @ApiModelProperty(value = "盘点ID")
  40. @TableField(typeHandler = UuidTypeHandler.class)
  41. private String checkId;
  42. /**
  43. * 盘点单号
  44. */
  45. @Excel(name = "盘点单号")
  46. @ApiModelProperty(value = "盘点单号")
  47. private String checkNo;
  48. @ApiModelProperty(value = "入库时间开始")
  49. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  50. private LocalDate makeTimeStart;
  51. @ApiModelProperty(value = "入库时间结束")
  52. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  53. private LocalDate makeTimeEnd;
  54. /**
  55. * 部门
  56. */
  57. @Excel(name = "部门")
  58. @ApiModelProperty(value = "部门")
  59. @TableField(typeHandler = UuidTypeHandler.class)
  60. private String orgId;
  61. /**
  62. * 盘点员工
  63. */
  64. @Excel(name = "盘点员工")
  65. @ApiModelProperty(value = "盘点员工")
  66. @TableField(typeHandler = UuidTypeHandler.class)
  67. private String staffId;
  68. /**
  69. * 盘点日期
  70. */
  71. @Excel(name = "盘点日期")
  72. @ApiModelProperty(value = "盘点日期")
  73. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  74. @TableField(typeHandler = TimestampTypeHandler.class)
  75. private LocalDate checkDate;
  76. /**
  77. * 库区ID
  78. */
  79. @Excel(name = "库区ID")
  80. @ApiModelProperty(value = "库区ID")
  81. @TableField(typeHandler = UuidTypeHandler.class)
  82. private String whId;
  83. /**
  84. * 制单员
  85. */
  86. @Excel(name = "制单员")
  87. @ApiModelProperty(value = "制单员")
  88. @TableField(typeHandler = UuidTypeHandler.class)
  89. private String makeStaff;
  90. /**
  91. * 制单时间
  92. */
  93. @Excel(name = "制单时间")
  94. @ApiModelProperty(value = "制单时间")
  95. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  96. @TableField(typeHandler = TimestampTypeHandler.class)
  97. private LocalDateTime makeTime;
  98. /**
  99. * 有效标识 (1:正常 0:停用)
  100. */
  101. @Excel(name = "有效标识 (1:正常 0:停用)")
  102. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  103. private Boolean flgValid;
  104. /**
  105. * 备注
  106. */
  107. @Excel(name = "备注")
  108. @ApiModelProperty(value = "备注")
  109. private String remarks;
  110. /**
  111. * 企业ID
  112. */
  113. @TableField(fill = FieldFill.INSERT)
  114. @Excel(name = "企业ID")
  115. @ApiModelProperty(value = "企业ID")
  116. private Integer cpId;
  117. /**
  118. * 创建时间 (触发器自动处理)
  119. */
  120. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  121. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  122. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  123. @TableField(typeHandler = TimestampTypeHandler.class)
  124. private LocalDateTime opCreateTime;
  125. /**
  126. * 创建用户 (触发器自动处理)
  127. */
  128. @Excel(name = "创建用户 (触发器自动处理)")
  129. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  130. @TableField(typeHandler = UuidTypeHandler.class)
  131. private String opCreateUserId;
  132. /**
  133. * 修改时间 (触发器自动处理)
  134. */
  135. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  136. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  137. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  138. @TableField(typeHandler = TimestampTypeHandler.class)
  139. private LocalDateTime opUpdateTime;
  140. /**
  141. * 修改用户 (触发器自动处理)
  142. */
  143. @Excel(name = "修改用户 (触发器自动处理)")
  144. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  145. @TableField(typeHandler = UuidTypeHandler.class)
  146. private String opUpdateUserId;
  147. /**
  148. * 数据操作应用 (触发器自动处理)
  149. */
  150. @Excel(name = "数据操作应用 (触发器自动处理)")
  151. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  152. private String opAppCode;
  153. /**
  154. * 数据时间戳 (触发器自动处理)
  155. */
  156. @Excel(name = "数据时间戳 (触发器自动处理)")
  157. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  158. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  159. @TableField(typeHandler = TimestampTypeHandler.class)
  160. private LocalDateTime opTimestamp;
  161. /**
  162. * 数据操作数据库用户 (触发器自动处理)
  163. */
  164. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  165. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  166. private String opDbUser;
  167. /**
  168. * 锁库标识
  169. */
  170. @Excel(name = "锁库标识")
  171. @ApiModelProperty(value = "锁库标识")
  172. private Boolean flgLock;
  173. /**
  174. * 盘点状态(系统字典)
  175. */
  176. @Excel(name = "盘点状态(系统字典)")
  177. @ApiModelProperty(value = "盘点状态(系统字典)")
  178. private String checkStatus;
  179. /**
  180. * @desc : 有效标识List
  181. * @author : 宋扬
  182. * @date : 2024/3/19 10:37
  183. */
  184. @Excel(name = "有效标识 (1:正常 0:停用)")
  185. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  186. private List<Boolean> flgValidList;
  187. /**
  188. * @desc : 组织名称
  189. * @author : 宋扬
  190. * @date : 2024/3/19 10:44
  191. */
  192. @ApiModelProperty(value = "组织名称")
  193. private List<String> orgIdList;
  194. /**
  195. * @desc : 员工
  196. * @author : 宋扬
  197. * @date : 2024/3/19 10:46
  198. */
  199. @ApiModelProperty(value = "员工姓名")
  200. private List<String> staffIdList;
  201. /**
  202. * @desc : 盘点状态
  203. * @author : 宋扬
  204. * @date : 2024/3/19 11:08
  205. */
  206. @ApiModelProperty(value = "盘点状态")
  207. private List<String> checkStatusList;
  208. /*
  209. * 相关属性
  210. * @TableField(exist = false)
  211. */
  212. /*
  213. * 关联属性 + 查询条件
  214. * @TableField(exist = false)
  215. */
  216. private static final long serialVersionUID = 1L;
  217. }