MoneyItemQuery.java 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  1. package com.dk.mdm.model.query.mst;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.baomidou.mybatisplus.annotation.FieldFill;
  4. import com.baomidou.mybatisplus.annotation.TableField;
  5. import com.baomidou.mybatisplus.annotation.TableName;
  6. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  7. import com.dk.common.infrastructure.handler.TimestampTypeHandler;
  8. import com.dk.common.infrastructure.handler.UuidTypeHandler;
  9. import com.dk.common.model.pojo.PageInfo;
  10. import com.fasterxml.jackson.annotation.JsonFormat;
  11. import io.swagger.annotations.ApiModel;
  12. import io.swagger.annotations.ApiModelProperty;
  13. import lombok.AllArgsConstructor;
  14. import lombok.Data;
  15. import lombok.EqualsAndHashCode;
  16. import lombok.NoArgsConstructor;
  17. import lombok.experimental.Accessors;
  18. import java.io.Serializable;
  19. import java.math.BigDecimal;
  20. import java.time.LocalDate;
  21. import java.time.LocalDateTime;
  22. /**
  23. * 资金流水明细
  24. */
  25. @Data
  26. @AllArgsConstructor
  27. @NoArgsConstructor
  28. @EqualsAndHashCode(callSuper = true)
  29. @Accessors(chain = true)
  30. @ExportTitle("资金流水明细")
  31. @TableName(value = "t_mst_money_item", autoResultMap = true)
  32. @ApiModel(value="实体类:资金流水明细", description="表名:t_mst_money_item")
  33. public class MoneyItemQuery extends PageInfo<MoneyItemQuery> implements Serializable {
  34. /*
  35. * 数据库字段
  36. */
  37. /**
  38. * 明细ID
  39. */
  40. // @TableId(value = "item_id", type = IdType.AUTO)
  41. @ApiModelProperty(value = "明细ID")
  42. @TableField(typeHandler = UuidTypeHandler.class)
  43. private String itemId;
  44. /**
  45. * 资金账户ID
  46. */
  47. @Excel(name = "资金账户ID")
  48. @ApiModelProperty(value = "资金账户ID")
  49. @TableField(typeHandler = UuidTypeHandler.class)
  50. private String macId;
  51. /**
  52. * 流水类型 (数据字典:收退款单、付退款单、资金转账)
  53. */
  54. @Excel(name = "流水类型 (数据字典:收退款单、付退款单、资金转账)")
  55. @ApiModelProperty(value = "流水类型 (数据字典:收退款单、付退款单、资金转账)")
  56. private String flowType;
  57. /**
  58. * 流水单ID (为空时为期初)
  59. */
  60. @Excel(name = "流水单ID (为空时为期初)")
  61. @ApiModelProperty(value = "流水单ID (为空时为期初)")
  62. @TableField(typeHandler = UuidTypeHandler.class)
  63. private String invoiceId;
  64. /**
  65. * 流入金额 (流入为正数,流出为负数)
  66. */
  67. @Excel(name = "流入金额 (流入为正数,流出为负数)")
  68. @ApiModelProperty(value = "流入金额 (流入为正数,流出为负数)")
  69. private BigDecimal inflowAmount;
  70. /**
  71. * 账务日期 (账务日期)
  72. */
  73. @Excel(name = "账务日期 (账务日期)")
  74. @ApiModelProperty(value = "账务日期 (账务日期)")
  75. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  76. @TableField(typeHandler = TimestampTypeHandler.class)
  77. private LocalDate accountDate;
  78. /**
  79. * 备注
  80. */
  81. @Excel(name = "备注")
  82. @ApiModelProperty(value = "备注")
  83. private String remarks;
  84. /**
  85. * 制单员
  86. */
  87. @Excel(name = "制单员")
  88. @ApiModelProperty(value = "制单员")
  89. @TableField(typeHandler = UuidTypeHandler.class)
  90. private String makeStaff;
  91. /**
  92. * 制单时间
  93. */
  94. @Excel(name = "制单时间")
  95. @ApiModelProperty(value = "制单时间")
  96. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  97. @TableField(typeHandler = TimestampTypeHandler.class)
  98. private LocalDateTime makeTime;
  99. /**
  100. * 有效标识 (1:正常 0:停用)
  101. */
  102. @Excel(name = "有效标识 (1:正常 0:停用)")
  103. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  104. private Boolean flgValid;
  105. /**
  106. * 企业ID
  107. */
  108. @TableField(fill = FieldFill.INSERT)
  109. @Excel(name = "企业ID")
  110. @ApiModelProperty(value = "企业ID")
  111. private Integer cpId;
  112. /**
  113. * 创建时间 (触发器自动处理)
  114. */
  115. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  116. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  117. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  118. @TableField(typeHandler = TimestampTypeHandler.class)
  119. private LocalDateTime opCreateTime;
  120. /**
  121. * 创建用户 (触发器自动处理)
  122. */
  123. @Excel(name = "创建用户 (触发器自动处理)")
  124. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  125. @TableField(typeHandler = UuidTypeHandler.class)
  126. private String opCreateUserId;
  127. /**
  128. * 修改时间 (触发器自动处理)
  129. */
  130. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  131. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  132. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  133. @TableField(typeHandler = TimestampTypeHandler.class)
  134. private LocalDateTime opUpdateTime;
  135. /**
  136. * 修改用户 (触发器自动处理)
  137. */
  138. @Excel(name = "修改用户 (触发器自动处理)")
  139. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  140. @TableField(typeHandler = UuidTypeHandler.class)
  141. private String opUpdateUserId;
  142. /**
  143. * 数据操作应用 (触发器自动处理)
  144. */
  145. @Excel(name = "数据操作应用 (触发器自动处理)")
  146. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  147. private String opAppCode;
  148. /**
  149. * 数据时间戳 (触发器自动处理)
  150. */
  151. @Excel(name = "数据时间戳 (触发器自动处理)")
  152. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  153. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  154. @TableField(typeHandler = TimestampTypeHandler.class)
  155. private LocalDateTime opTimestamp;
  156. /**
  157. * 数据操作数据库用户 (触发器自动处理)
  158. */
  159. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  160. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  161. private String opDbUser;
  162. /*
  163. * 相关属性
  164. * @TableField(exist = false)
  165. */
  166. /*
  167. * 关联属性 + 查询条件
  168. * @TableField(exist = false)
  169. */
  170. private static final long serialVersionUID = 1L;
  171. }