StaffQuery.java 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  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. @TableField(typeHandler = UuidTypeHandler.class)
  69. private String orgId;
  70. /**
  71. * 员工状态 (【数据种类】员工状态-在职、离职)
  72. */
  73. @Excel(name = "员工状态 (【数据种类】员工状态-在职、离职)")
  74. @ApiModelProperty(value = "员工状态 (【数据种类】员工状态-在职、离职)")
  75. private String staffStatus;
  76. /**
  77. * 备注
  78. */
  79. @Excel(name = "备注")
  80. @ApiModelProperty(value = "备注")
  81. private String remarks;
  82. /**
  83. * 有效标识 (1:正常 0:停用)
  84. */
  85. @Excel(name = "有效标识 (1:正常 0:停用)")
  86. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  87. private Boolean flgValid;
  88. /**
  89. * 登录标识
  90. */
  91. @ApiModelProperty(value = "登录标识")
  92. private Boolean flgCanLogin;
  93. /**
  94. * 工厂ID
  95. */
  96. @Excel(name = "工厂ID")
  97. @ApiModelProperty(value = "工厂ID")
  98. private Integer cpId;
  99. /**
  100. * 创建时间 (触发器自动处理)
  101. */
  102. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  103. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  104. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  105. @TableField(typeHandler = TimestampTypeHandler.class)
  106. private LocalDateTime opCreateTime;
  107. /**
  108. * 创建用户 (触发器自动处理)
  109. */
  110. @Excel(name = "创建用户 (触发器自动处理)")
  111. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  112. private Long opCreateUserId;
  113. /**
  114. * 修改时间 (触发器自动处理)
  115. */
  116. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  117. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  118. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  119. @TableField(typeHandler = TimestampTypeHandler.class)
  120. private LocalDateTime opUpdateTime;
  121. /**
  122. * 修改用户 (触发器自动处理)
  123. */
  124. @Excel(name = "修改用户 (触发器自动处理)")
  125. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  126. private Long opUpdateUserId;
  127. /**
  128. * 数据操作应用 (触发器自动处理)
  129. */
  130. @Excel(name = "数据操作应用 (触发器自动处理)")
  131. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  132. private String opAppCode;
  133. /**
  134. * 数据时间戳 (触发器自动处理)
  135. */
  136. @Excel(name = "数据时间戳 (触发器自动处理)")
  137. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  138. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  139. @TableField(typeHandler = TimestampTypeHandler.class)
  140. private LocalDateTime opTimestamp;
  141. /**
  142. * 数据操作数据库用户 (触发器自动处理)
  143. */
  144. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  145. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  146. private String opDbUser;
  147. /*
  148. * 相关属性
  149. * @TableField(exist = false)
  150. */
  151. /*
  152. * 关联属性 + 查询条件
  153. * @TableField(exist = false)
  154. */
  155. /**
  156. * @desc : 有效标识list
  157. * @author : 姜宁
  158. * @date : 2023/1/9 11:24
  159. */
  160. @TableField(exist = false)
  161. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  162. private List<Boolean> flgValidList;
  163. /**
  164. * @desc : 角色list
  165. */
  166. @ApiModelProperty(value = "员工状态list")
  167. @TableField(exist = false)
  168. private List<String> roleIds;
  169. /**
  170. * @desc : 组织部门list
  171. */
  172. @TableField(exist = false)
  173. @ApiModelProperty(value = "组织部门list")
  174. private List<String> orgIds;
  175. /**
  176. * 登录标识1能登录 0不能登录
  177. */
  178. @Excel(name = "登录标识")
  179. @ApiModelProperty(value = "登录标识")
  180. private Integer hrStatus;
  181. /**
  182. * 小程序的查询条件
  183. */
  184. @ApiModelProperty(value = "小程序的查询条件")
  185. private String searchText;
  186. private static final long serialVersionUID = 1L;
  187. }