AccountExcel.java 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. package com.ydtech.modules.inv.model.excel;
  2. import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
  3. import com.alibaba.excel.annotation.ExcelProperty;
  4. import com.alibaba.excel.annotation.write.style.ContentStyle;
  5. import com.alibaba.excel.enums.poi.BorderStyleEnum;
  6. import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
  7. import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
  8. import com.google.gson.JsonObject;
  9. import io.swagger.annotations.ApiModelProperty;
  10. import lombok.Data;
  11. import java.io.Serializable;
  12. /**
  13. * @author jianlong
  14. * @date 2024-01-29 16:48
  15. */
  16. @Data
  17. public class AccountExcel implements Serializable {
  18. @ExcelProperty("编号")
  19. private String accountId;
  20. /**
  21. * 开户行名称
  22. */
  23. @ExcelProperty("开户行名称")
  24. private String bankName;
  25. //营业性质(3一般纳税 2小规模 1个体户)
  26. @ExcelProperty(value = "营业性质")
  27. private String businessQuality;
  28. @ExcelProperty(value = "所属地")
  29. private String owned;
  30. @ExcelProperty("成立日期")
  31. private String establishTime;
  32. @ExcelProperty("总开票额度")
  33. private String sumInvoicingAmount;
  34. @ExcelProperty("季度开票额度剩余")
  35. private String quarterAmountExcess;
  36. @ExcelProperty("剩余开票额度")
  37. private String invoicingAmountExcess;
  38. /**
  39. * 余额
  40. */
  41. @ExcelProperty("余额")
  42. private String balance;
  43. @ExcelProperty("暂估")
  44. private String estimate;
  45. }