AccountObject.java 6.9 KB

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