RecPayQuery.java 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  1. package com.dk.mdm.model.query.mac;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.baomidou.mybatisplus.annotation.FieldFill;
  6. import com.baomidou.mybatisplus.annotation.TableField;
  7. import com.baomidou.mybatisplus.annotation.TableName;
  8. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  9. import com.dk.common.infrastructure.handler.*;
  10. import com.dk.common.model.pojo.PageInfo;
  11. import com.fasterxml.jackson.annotation.JsonFormat;
  12. import io.swagger.annotations.ApiModel;
  13. import io.swagger.annotations.ApiModelProperty;
  14. import lombok.AllArgsConstructor;
  15. import lombok.Data;
  16. import lombok.EqualsAndHashCode;
  17. import lombok.NoArgsConstructor;
  18. import lombok.experimental.Accessors;
  19. import java.io.Serializable;
  20. import java.math.BigDecimal;
  21. import java.time.LocalDate;
  22. import java.time.LocalDateTime;
  23. import java.util.List;
  24. /**
  25. * 收付款单
  26. */
  27. @Data
  28. @AllArgsConstructor
  29. @NoArgsConstructor
  30. @EqualsAndHashCode(callSuper = true)
  31. @Accessors(chain = true)
  32. @ExportTitle("收付款单")
  33. @TableName(value = "t_mac_rec_pay", autoResultMap = true)
  34. @ApiModel(value="实体类:收付款单", description="表名:t_mac_rec_pay")
  35. public class RecPayQuery extends PageInfo<RecPayQuery> implements Serializable {
  36. /*
  37. * 数据库字段
  38. */
  39. /**
  40. * 收款单ID
  41. */
  42. // @TableId(value = "rp_id", type = IdType.AUTO)
  43. @ApiModelProperty(value = "收款单ID")
  44. @TableField(typeHandler = UuidTypeHandler.class)
  45. private String rpId;
  46. /**
  47. * 收付款单号
  48. */
  49. @Excel(name = "收付款单号")
  50. @ApiModelProperty(value = "收付款单号")
  51. private String rpNo;
  52. /**
  53. * 收付款类型 (【系统字典】收款、付款)
  54. */
  55. @Excel(name = "收付款类型 (【系统字典】收款、付款)")
  56. @ApiModelProperty(value = "收付款类型 (【系统字典】收款、付款)")
  57. private String rpType;
  58. /**
  59. * 账务对象ID (账务对象:客户、供应商)
  60. */
  61. @Excel(name = "账务对象ID (账务对象:客户、供应商)")
  62. @ApiModelProperty(value = "账务对象ID (账务对象:客户、供应商)")
  63. @TableField(typeHandler = UuidTypeHandler.class)
  64. private String objectId;
  65. /**
  66. * 部门
  67. */
  68. @Excel(name = "部门")
  69. @ApiModelProperty(value = "部门")
  70. @TableField(typeHandler = UuidTypeHandler.class)
  71. private String orgId;
  72. /**
  73. * 员工
  74. */
  75. @Excel(name = "员工")
  76. @ApiModelProperty(value = "员工")
  77. @TableField(typeHandler = UuidTypeHandler.class)
  78. private String staffId;
  79. /**
  80. * 收款金额
  81. */
  82. @Excel(name = "收款金额")
  83. @ApiModelProperty(value = "收款金额")
  84. private BigDecimal sumAmtRec;
  85. /**
  86. * 付款金额
  87. */
  88. @Excel(name = "付款金额")
  89. @ApiModelProperty(value = "付款金额")
  90. private BigDecimal sumAmtPay;
  91. @Excel(name = "待核销金额")
  92. @ApiModelProperty(value = "待核销金额")
  93. private BigDecimal sumShouldHandle;
  94. @Excel(name = "预收抵扣")
  95. @ApiModelProperty(value = "预收抵扣")
  96. private BigDecimal sumUseReceiptResidue;
  97. @Excel(name = "预付抵扣")
  98. @ApiModelProperty(value = "预付抵扣")
  99. private BigDecimal sumUsePaymentResidue;
  100. @Excel(name = "合计应收冲抵金额")
  101. @ApiModelProperty(value = "合计应收冲抵金额")
  102. private BigDecimal sumAmtReceivableHandle;
  103. @Excel(name = "合计应付冲抵金额")
  104. @ApiModelProperty(value = "合计应付冲抵金额")
  105. private BigDecimal sumAmtPayableHandle;
  106. @Excel(name = "合计核销金额")
  107. @ApiModelProperty(value = "合计核销金额")
  108. private BigDecimal sumWaiveAmt;
  109. /**
  110. * 小程序的查询条件
  111. */
  112. @ApiModelProperty(value = "小程序的查询条件")
  113. private String searchText;
  114. /**
  115. * 收付款日期 (账务日期)
  116. */
  117. @Excel(name = "收付款日期 (账务日期)")
  118. @ApiModelProperty(value = "收付款日期 (账务日期)")
  119. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  120. @TableField(typeHandler = TimestampTypeHandler.class)
  121. private LocalDate accDate;
  122. /**
  123. * 备注
  124. */
  125. @Excel(name = "备注")
  126. @ApiModelProperty(value = "备注")
  127. private String remarks;
  128. /**
  129. * 附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)
  130. */
  131. @Excel(name = "附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)")
  132. @ApiModelProperty(value = "附件 (index(显示顺序)、name(文件名)、path(路径)、type(类型)、time(上传时间)...)")
  133. @TableField(typeHandler = JsonTypeHandler.class)
  134. private JSONArray annexPaths;
  135. /**
  136. * 业务单据 (表名(哪个业务单据触发的收款))
  137. */
  138. @Excel(name = "业务单据 (表名(哪个业务单据触发的收款))")
  139. @ApiModelProperty(value = "业务单据 (表名(哪个业务单据触发的收款))")
  140. private String biznisType;
  141. /**
  142. * 业务单ID
  143. */
  144. @Excel(name = "业务单ID")
  145. @ApiModelProperty(value = "业务单ID")
  146. @TableField(typeHandler = UuidTypeHandler.class)
  147. private String biznisId;
  148. /**
  149. * 业务单号
  150. */
  151. @Excel(name = "业务单号")
  152. @ApiModelProperty(value = "业务单号")
  153. private String biznisNo;
  154. /**
  155. * 核销标识(是否是订单的出库的核销单)
  156. */
  157. @Excel(name = "核销标识(是否是订单的出库的核销单)")
  158. @ApiModelProperty(value = "核销标识(是否是订单的出库的核销单)")
  159. private Boolean flgOrderHandle;
  160. /**
  161. * 锁定标识
  162. */
  163. @Excel(name = "锁定标识")
  164. @ApiModelProperty(value = "锁定标识")
  165. private Boolean flgLock;
  166. /**
  167. * 制单员
  168. */
  169. @Excel(name = "制单员")
  170. @ApiModelProperty(value = "制单员")
  171. @TableField(typeHandler = UuidTypeHandler.class)
  172. private String makeStaff;
  173. /**
  174. * 制单时间
  175. */
  176. @Excel(name = "制单时间")
  177. @ApiModelProperty(value = "制单时间")
  178. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  179. @TableField(typeHandler = TimestampTypeHandler.class)
  180. private LocalDateTime makeTime;
  181. /**
  182. * 有效标识 (1:正常 0:停用)
  183. */
  184. @Excel(name = "有效标识 (1:正常 0:停用)")
  185. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  186. private Boolean flgValid;
  187. /**
  188. * 企业ID
  189. */
  190. @TableField(fill = FieldFill.INSERT)
  191. @Excel(name = "企业ID")
  192. @ApiModelProperty(value = "企业ID")
  193. private Integer cpId;
  194. @ApiModelProperty(value = "客户电话")
  195. private String cusPhone;
  196. @ApiModelProperty(value = "客户名称")
  197. private String cusName;
  198. @ApiModelProperty(value = "部门List")
  199. private List<String> orgIdList;
  200. @ApiModelProperty(value = "业务员List")
  201. private List<String> staffIdList;
  202. @ApiModelProperty(value = "制单时间开始")
  203. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  204. private LocalDate makeTimeStart;
  205. @ApiModelProperty(value = "制单时间结束")
  206. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  207. private LocalDate makeTimeEnd;
  208. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  209. private List<Boolean> flgValidList;
  210. @ApiModelProperty(value = "供应商名称")
  211. private String supName;
  212. @ApiModelProperty(value = "部门名称")
  213. private String orgName;
  214. @ApiModelProperty(value = "员工名称")
  215. private String staffName;
  216. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  217. @TableField(typeHandler = TimestampTypeHandler.class)
  218. private LocalDate createtimeStart;
  219. @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
  220. @TableField(typeHandler = TimestampTypeHandler.class)
  221. private LocalDate createtimeEnd;
  222. @ApiModelProperty(value = "业务员idList")
  223. private List<String> staffIds;
  224. private List<String> rpTypeList;
  225. private static final long serialVersionUID = 1L;
  226. }