QueryMenu.java 10.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469
  1. package com.ruoyi.warehouseBusiness.excel;
  2. import com.fasterxml.jackson.annotation.JsonFormat;
  3. import com.ruoyi.common.annotation.Excel;
  4. import java.math.BigDecimal;
  5. import java.util.Date;
  6. /**
  7. * 查询菜单导出
  8. *
  9. * @author shz
  10. * @date 2021-12-17
  11. */
  12. public class QueryMenu {
  13. private static final long serialVersionUID = 1L;
  14. /**
  15. * 客户姓名
  16. */
  17. @Excel(name = "客户姓名")
  18. private String corpName;
  19. /**
  20. * 提单号
  21. */
  22. @Excel(name = "提单号")
  23. private String fMblno;
  24. /**
  25. * 业务日期
  26. */
  27. @Excel(name = "业务日期", width = 30, dateFormat = "yyyy-MM-dd")
  28. @JsonFormat(pattern = "yyyy-MM-dd")
  29. private Date fBsdate;
  30. /**
  31. * 审核日期
  32. */
  33. @JsonFormat(pattern = "yyyy-MM-dd")
  34. @Excel(name = "审核日期", width = 30, dateFormat = "yyyy-MM-dd")
  35. private Date fReviewDate;
  36. /**
  37. * 计费起始日期
  38. */
  39. @JsonFormat(pattern = "yyyy-MM-dd")
  40. @Excel(name = "费用起始日期", width = 30, dateFormat = "yyyy-MM-dd")
  41. private Date fChargedate;
  42. /**
  43. * 计费截止日期
  44. */
  45. @JsonFormat(pattern = "yyyy-MM-dd")
  46. @Excel(name = "费用截止日期", width = 30, dateFormat = "yyyy-MM-dd")
  47. private Date fBillingDeadline;
  48. /**
  49. * 原始入库日期
  50. */
  51. @JsonFormat(pattern = "yyyy-MM-dd")
  52. @Excel(name = "原始入库日期", width = 30, dateFormat = "yyyy-MM-dd")
  53. private Date fOriginalbilldate;
  54. /**
  55. * 费用名称
  56. */
  57. @Excel(name = "费用名称")
  58. private String feeName;
  59. /**
  60. * 费用状态
  61. */
  62. @Excel(name = "费用状态")
  63. private String fBillstatusName;
  64. /**
  65. * 收、付,D:收 C:付
  66. */
  67. @Excel(name = "收/付", readConverterExp = "D=收,C=付")
  68. private String fDc;
  69. /**
  70. * 金额
  71. */
  72. @Excel(name = "金额")
  73. private BigDecimal fAmount;
  74. /**
  75. * 汇率
  76. */
  77. @Excel(name = "汇率")
  78. private String fExrate;
  79. /**
  80. * 税率
  81. */
  82. @Excel(name = "税率")
  83. private String fTaxrate;
  84. /**
  85. * 结算金额
  86. */
  87. @Excel(name = "结算金额")
  88. private BigDecimal fStlamount;
  89. /**
  90. * 结算日期
  91. */
  92. @Excel(name = "结算日期", width = 30, dateFormat = "yyyy-MM-dd")
  93. private Date fStlamountDate;
  94. /**
  95. * 开票金额
  96. */
  97. @Excel(name = "开票金额")
  98. private BigDecimal fInvamount;
  99. /**
  100. * 发票号
  101. */
  102. @Excel(name = "发票号")
  103. private String fInvnos;
  104. /**
  105. * 对账金额
  106. */
  107. @Excel(name = "对账金额")
  108. private BigDecimal fAccamount;
  109. /**
  110. * 对账日期
  111. */
  112. @Excel(name = "对账日期", width = 30, dateFormat = "yyyy-MM-dd")
  113. @JsonFormat(pattern = "yyyy-MM-dd")
  114. private Date fAccamountDate;
  115. /**
  116. * 对账单号
  117. */
  118. @Excel(name = "对账单号")
  119. private String fStatementNo;
  120. /**
  121. * 计价单位
  122. */
  123. @Excel(name = "计价单位", readConverterExp = "1=件数,2=毛重,3=净重,4=尺码,5=固定,6=其他,7=箱量")
  124. private Integer fFeeunitid;
  125. /**
  126. * 数量
  127. */
  128. @Excel(name = "数量")
  129. private BigDecimal fQty;
  130. /**
  131. * 单价
  132. */
  133. @Excel(name = "单价")
  134. private BigDecimal fUnitprice;
  135. /**
  136. * 业务类型
  137. */
  138. @Excel(name = "业务类型", readConverterExp = "SJRK=入库,SJCK=实际出库,CKDB=调拨,HQZY=货权转移,CDZZ=场地直装")
  139. private String fBilltype;
  140. /**
  141. * 业务编号
  142. */
  143. @Excel(name = "业务编号")
  144. private String fSrcBillno;
  145. /**
  146. * 货物名称
  147. */
  148. @Excel(name = "货物名称")
  149. private String fProductName;
  150. /**
  151. * 结算方式
  152. */
  153. @Excel(name = "结算方式", dictType = "data_stltype_type")
  154. private Long fStltypeid;
  155. /**
  156. * 备注
  157. */
  158. @Excel(name = "备注")
  159. private String remark;
  160. /**
  161. * 发货方
  162. */
  163. @Excel(name = "发货方")
  164. private String fShipper;
  165. /** 出口单号 */
  166. @Excel(name = "出口单号")
  167. private String fEmblno;
  168. public String getfExrate() {
  169. return fExrate;
  170. }
  171. public void setfExrate(String fExrate) {
  172. this.fExrate = fExrate;
  173. }
  174. public String getfTaxrate() {
  175. return fTaxrate;
  176. }
  177. public void setfTaxrate(String fTaxrate) {
  178. this.fTaxrate = fTaxrate;
  179. }
  180. public Date getfBillingDeadline() {
  181. return fBillingDeadline;
  182. }
  183. public void setfBillingDeadline(Date fBillingDeadline) {
  184. this.fBillingDeadline = fBillingDeadline;
  185. }
  186. public Date getfOriginalbilldate() {
  187. return fOriginalbilldate;
  188. }
  189. public void setfOriginalbilldate(Date fOriginalbilldate) {
  190. this.fOriginalbilldate = fOriginalbilldate;
  191. }
  192. public String getfEmblno() {
  193. return fEmblno;
  194. }
  195. public void setfEmblno(String fEmblno) {
  196. this.fEmblno = fEmblno;
  197. }
  198. public Date getfChargedate() {
  199. return fChargedate;
  200. }
  201. public void setfChargedate(Date fChargedate) {
  202. this.fChargedate = fChargedate;
  203. }
  204. public String getfSrcBillno() {
  205. return fSrcBillno;
  206. }
  207. public void setfSrcBillno(String fSrcBillno) {
  208. this.fSrcBillno = fSrcBillno;
  209. }
  210. public String getfShipper() {
  211. return fShipper;
  212. }
  213. public void setfShipper(String fShipper) {
  214. this.fShipper = fShipper;
  215. }
  216. public String getCorpName() {
  217. return corpName;
  218. }
  219. public void setCorpName(String corpName) {
  220. this.corpName = corpName;
  221. }
  222. public String getfMblno() {
  223. return fMblno;
  224. }
  225. public void setfMblno(String fMblno) {
  226. this.fMblno = fMblno;
  227. }
  228. public Date getfBsdate() {
  229. return fBsdate;
  230. }
  231. public void setfBsdate(Date fBsdate) {
  232. this.fBsdate = fBsdate;
  233. }
  234. public Date getfReviewDate() {
  235. return fReviewDate;
  236. }
  237. public void setfReviewDate(Date fReviewDate) {
  238. this.fReviewDate = fReviewDate;
  239. }
  240. public String getFeeName() {
  241. return feeName;
  242. }
  243. public void setFeeName(String feeName) {
  244. this.feeName = feeName;
  245. }
  246. public String getfBillstatusName() {
  247. return fBillstatusName;
  248. }
  249. public void setfBillstatusName(String fBillstatusName) {
  250. this.fBillstatusName = fBillstatusName;
  251. }
  252. public String getfDc() {
  253. return fDc;
  254. }
  255. public void setfDc(String fDc) {
  256. this.fDc = fDc;
  257. }
  258. public BigDecimal getfAmount() {
  259. return fAmount;
  260. }
  261. public void setfAmount(BigDecimal fAmount) {
  262. this.fAmount = fAmount;
  263. }
  264. public BigDecimal getfStlamount() {
  265. return fStlamount;
  266. }
  267. public void setfStlamount(BigDecimal fStlamount) {
  268. this.fStlamount = fStlamount;
  269. }
  270. public BigDecimal getfInvamount() {
  271. return fInvamount;
  272. }
  273. public void setfInvamount(BigDecimal fInvamount) {
  274. this.fInvamount = fInvamount;
  275. }
  276. public BigDecimal getfAccamount() {
  277. return fAccamount;
  278. }
  279. public void setfAccamount(BigDecimal fAccamount) {
  280. this.fAccamount = fAccamount;
  281. }
  282. public BigDecimal getfUnitprice() {
  283. return fUnitprice;
  284. }
  285. public void setfUnitprice(BigDecimal fUnitprice) {
  286. this.fUnitprice = fUnitprice;
  287. }
  288. public Date getfStlamountDate() {
  289. return fStlamountDate;
  290. }
  291. public void setfStlamountDate(Date fStlamountDate) {
  292. this.fStlamountDate = fStlamountDate;
  293. }
  294. public String getfInvnos() {
  295. return fInvnos;
  296. }
  297. public void setfInvnos(String fInvnos) {
  298. this.fInvnos = fInvnos;
  299. }
  300. public Date getfAccamountDate() {
  301. return fAccamountDate;
  302. }
  303. public void setfAccamountDate(Date fAccamountDate) {
  304. this.fAccamountDate = fAccamountDate;
  305. }
  306. public String getfStatementNo() {
  307. return fStatementNo;
  308. }
  309. public void setfStatementNo(String fStatementNo) {
  310. this.fStatementNo = fStatementNo;
  311. }
  312. public Integer getfFeeunitid() {
  313. return fFeeunitid;
  314. }
  315. public void setfFeeunitid(Integer fFeeunitid) {
  316. this.fFeeunitid = fFeeunitid;
  317. }
  318. public BigDecimal getfQty() {
  319. return fQty;
  320. }
  321. public void setfQty(BigDecimal fQty) {
  322. this.fQty = fQty;
  323. }
  324. public String getfBilltype() {
  325. return fBilltype;
  326. }
  327. public void setfBilltype(String fBilltype) {
  328. this.fBilltype = fBilltype;
  329. }
  330. public String getfProductName() {
  331. return fProductName;
  332. }
  333. public void setfProductName(String fProductName) {
  334. this.fProductName = fProductName;
  335. }
  336. public Long getfStltypeid() {
  337. return fStltypeid;
  338. }
  339. public void setfStltypeid(Long fStltypeid) {
  340. this.fStltypeid = fStltypeid;
  341. }
  342. public String getRemark() {
  343. return remark;
  344. }
  345. public void setRemark(String remark) {
  346. this.remark = remark;
  347. }
  348. @Override
  349. public String toString() {
  350. return "QueryMenu{" +
  351. "corpName='" + corpName + '\'' +
  352. ", fMblno='" + fMblno + '\'' +
  353. ", fBsdate=" + fBsdate +
  354. ", fReviewDate=" + fReviewDate +
  355. ", feeName='" + feeName + '\'' +
  356. ", fBillstatusName='" + fBillstatusName + '\'' +
  357. ", fDc='" + fDc + '\'' +
  358. ", fAmount=" + fAmount +
  359. ", fStlamount=" + fStlamount +
  360. ", fStlamountDate=" + fStlamountDate +
  361. ", fInvamount=" + fInvamount +
  362. ", fInvnos='" + fInvnos + '\'' +
  363. ", fAccamount=" + fAccamount +
  364. ", fAccamountDate=" + fAccamountDate +
  365. ", fStatementNo='" + fStatementNo + '\'' +
  366. ", fFeeunitid=" + fFeeunitid +
  367. ", fQty=" + fQty +
  368. ", fUnitprice=" + fUnitprice +
  369. ", fBilltype='" + fBilltype + '\'' +
  370. ", fProductName='" + fProductName + '\'' +
  371. ", fStltypeid=" + fStltypeid +
  372. ", remark='" + remark + '\'' +
  373. '}';
  374. }
  375. }