StaffQuery.java 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245
  1. package com.dk.mdm.model.query.mst;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.baomidou.mybatisplus.annotation.IdType;
  4. import com.baomidou.mybatisplus.annotation.TableField;
  5. import com.baomidou.mybatisplus.annotation.TableId;
  6. import com.baomidou.mybatisplus.annotation.TableName;
  7. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  8. import com.dk.common.infrastructure.handler.TimestampTypeHandler;
  9. import com.dk.common.infrastructure.handler.UuidListTypeHandler;
  10. import com.dk.common.infrastructure.handler.UuidTypeHandler;
  11. import com.dk.common.model.pojo.PageInfo;
  12. import com.fasterxml.jackson.annotation.JsonFormat;
  13. import io.swagger.annotations.ApiModel;
  14. import io.swagger.annotations.ApiModelProperty;
  15. import lombok.AllArgsConstructor;
  16. import lombok.Data;
  17. import lombok.EqualsAndHashCode;
  18. import lombok.NoArgsConstructor;
  19. import lombok.experimental.Accessors;
  20. import java.io.Serializable;
  21. import java.time.LocalDateTime;
  22. import java.util.List;
  23. /**
  24. * 员工
  25. */
  26. @Data
  27. @AllArgsConstructor
  28. @NoArgsConstructor
  29. @EqualsAndHashCode(callSuper = true)
  30. @Accessors(chain = true)
  31. @ExportTitle("员工")
  32. @TableName(value = "t_mst_staff", autoResultMap = true)
  33. @ApiModel(value="实体类:员工", description="表名:t_mst_staff")
  34. public class StaffQuery extends PageInfo<StaffQuery> implements Serializable {
  35. /*
  36. * 数据库字段
  37. */
  38. /**
  39. * 员工ID
  40. */
  41. @TableId(value = "staff_id", type = IdType.AUTO)
  42. @ApiModelProperty(value = "员工ID")
  43. @TableField(typeHandler = UuidTypeHandler.class)
  44. private String staffId;
  45. /**
  46. * 员工编码
  47. */
  48. @Excel(name = "员工编码")
  49. @ApiModelProperty(value = "员工编码")
  50. private String staffCode;
  51. /**
  52. * 员工名称
  53. */
  54. @Excel(name = "员工名称")
  55. @ApiModelProperty(value = "员工名称")
  56. private String staffName;
  57. /**
  58. * 员工电话
  59. */
  60. @Excel(name = "员工电话")
  61. @ApiModelProperty(value = "员工电话")
  62. private String staffPhone;
  63. /**
  64. * 员工工种
  65. */
  66. @Excel(name = "员工工种")
  67. @ApiModelProperty(value = "员工工种")
  68. private Integer jobId;
  69. /**
  70. * 员工职务
  71. */
  72. @Excel(name = "员工职务")
  73. @ApiModelProperty(value = "员工职务")
  74. private Integer postId;
  75. /**
  76. * 组织部门
  77. */
  78. @Excel(name = "组织部门")
  79. @ApiModelProperty(value = "组织部门")
  80. @TableField(typeHandler = UuidTypeHandler.class)
  81. private String orgId;
  82. /**
  83. * 员工状态 (【数据种类】员工状态-在职、离职)
  84. */
  85. @Excel(name = "员工状态 (【数据种类】员工状态-在职、离职)")
  86. @ApiModelProperty(value = "员工状态 (【数据种类】员工状态-在职、离职)")
  87. private String staffStatus;
  88. /**
  89. * 备注
  90. */
  91. @Excel(name = "备注")
  92. @ApiModelProperty(value = "备注")
  93. private String remarks;
  94. /**
  95. * 有效标识 (1:正常 0:停用)
  96. */
  97. @Excel(name = "有效标识 (1:正常 0:停用)")
  98. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  99. private Boolean flgValid;
  100. /**
  101. * 登录标识
  102. */
  103. @ApiModelProperty(value = "登录标识")
  104. private Boolean flgCanLogin;
  105. /**
  106. * 工厂ID
  107. */
  108. @Excel(name = "工厂ID")
  109. @ApiModelProperty(value = "工厂ID")
  110. private Integer ftyId;
  111. /**
  112. * 创建时间 (触发器自动处理)
  113. */
  114. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  115. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  116. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  117. @TableField(typeHandler = TimestampTypeHandler.class)
  118. private LocalDateTime opCreateTime;
  119. /**
  120. * 创建用户 (触发器自动处理)
  121. */
  122. @Excel(name = "创建用户 (触发器自动处理)")
  123. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  124. private Long opCreateUserId;
  125. /**
  126. * 修改时间 (触发器自动处理)
  127. */
  128. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  129. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  130. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  131. @TableField(typeHandler = TimestampTypeHandler.class)
  132. private LocalDateTime opUpdateTime;
  133. /**
  134. * 修改用户 (触发器自动处理)
  135. */
  136. @Excel(name = "修改用户 (触发器自动处理)")
  137. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  138. private Long opUpdateUserId;
  139. /**
  140. * 数据操作应用 (触发器自动处理)
  141. */
  142. @Excel(name = "数据操作应用 (触发器自动处理)")
  143. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  144. private String opAppCode;
  145. /**
  146. * 数据时间戳 (触发器自动处理)
  147. */
  148. @Excel(name = "数据时间戳 (触发器自动处理)")
  149. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  150. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  151. @TableField(typeHandler = TimestampTypeHandler.class)
  152. private LocalDateTime opTimestamp;
  153. /**
  154. * 数据操作数据库用户 (触发器自动处理)
  155. */
  156. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  157. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  158. private String opDbUser;
  159. /*
  160. * 相关属性
  161. * @TableField(exist = false)
  162. */
  163. /*
  164. * 关联属性 + 查询条件
  165. * @TableField(exist = false)
  166. */
  167. /**
  168. * @desc : 有效标识list
  169. * @author : 姜宁
  170. * @date : 2023/1/9 11:24
  171. */
  172. @TableField(exist = false)
  173. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  174. private List<Boolean> flgValidList;
  175. /**
  176. * @desc : 角色list
  177. */
  178. @ApiModelProperty(value = "员工状态list")
  179. @TableField(exist = false)
  180. private List<String> roleIds;
  181. /**
  182. * @desc : 组织部门list
  183. */
  184. @TableField(exist = false)
  185. @ApiModelProperty(value = "组织部门list")
  186. private List<String> orgIds;
  187. /**
  188. * 登录标识1能登录 0不能登录
  189. */
  190. @Excel(name = "登录标识")
  191. @ApiModelProperty(value = "登录标识")
  192. private Integer hrStatus;
  193. private String searchText;
  194. private static final long serialVersionUID = 1L;
  195. }