PayableAmountExcel.java 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. package com.ydtech.modules.admin.model.dto;
  2. import com.alibaba.excel.annotation.ExcelIgnore;
  3. import com.alibaba.excel.annotation.ExcelProperty;
  4. import io.swagger.annotations.ApiModelProperty;
  5. import lombok.Data;
  6. @Data
  7. public class PayableAmountExcel {
  8. @ApiModelProperty("保险公司id")
  9. @ExcelIgnore
  10. private String companyId;
  11. @ApiModelProperty("接口类型")
  12. @ExcelIgnore
  13. private String apiType;
  14. @ApiModelProperty("驾意json字符串")
  15. @ExcelIgnore
  16. private String crossInsurance;
  17. @ApiModelProperty("渠道")
  18. @ExcelProperty("渠道")
  19. private String username;
  20. @ApiModelProperty("出单日期")
  21. @ExcelProperty("出单日期")
  22. private String signingTime;
  23. @ApiModelProperty("车牌号")
  24. @ExcelProperty("车牌号")
  25. private String licenseno;
  26. @ApiModelProperty("被保险人")
  27. @ExcelProperty("被保险人")
  28. private String applyname;
  29. @ApiModelProperty("承保公司")
  30. @ExcelProperty("承保公司")
  31. private String insCompany;
  32. @ApiModelProperty("险种")
  33. @ExcelProperty("险种")
  34. private String product;
  35. @ApiModelProperty("合作公司")
  36. @ExcelProperty("合作公司")
  37. private String namesimple;
  38. @ApiModelProperty("交强保单号")
  39. @ExcelProperty("交强保单号")
  40. private String jqpolicyno;
  41. @ApiModelProperty("商业保单号")
  42. @ExcelProperty("商业保单号")
  43. private String sypolicyno;
  44. @ApiModelProperty("非车保单号")
  45. @ExcelProperty("非车保单号")
  46. private String jypolicyno;
  47. @ApiModelProperty("交强保费")
  48. @ExcelProperty("交强保费")
  49. private String jqpremium;
  50. @ApiModelProperty("车船税")
  51. @ExcelProperty("车船税")
  52. private String taxamount;
  53. @ApiModelProperty("商业保费")
  54. @ExcelProperty("商业保费")
  55. private String sypremium;
  56. @ApiModelProperty("非车保费")
  57. @ExcelProperty("非车保费")
  58. private String jypremium;
  59. @ExcelProperty(value = "协议号")
  60. private String agreementCode;
  61. @ExcelProperty(value = "工号描述")
  62. private String jobDescription;
  63. @ExcelProperty(value = "对接人")
  64. private String dockingPerson;
  65. @ExcelProperty(value = "联系方式")
  66. private String dockingPhone;
  67. @ApiModelProperty("交强出口比例")
  68. @ExcelProperty("交强出口比例")
  69. private String jqExportProportion;
  70. @ApiModelProperty("商业出口比例")
  71. @ExcelProperty("商业出口比例")
  72. private String syExportProportion;
  73. @ApiModelProperty("非车出口比例")
  74. @ExcelProperty("非车出口比例")
  75. private String noExportProportion;
  76. @ApiModelProperty("结算金额")
  77. @ExcelProperty("结算金额")
  78. private String settlement;
  79. @ApiModelProperty("交强入口")
  80. @ExcelProperty("交强入口")
  81. private String jqEntranceProportion;
  82. @ApiModelProperty("商业入口")
  83. @ExcelProperty("商业入口")
  84. private String syEntranceProportion;
  85. @ApiModelProperty("非车入口")
  86. @ExcelProperty("非车入口")
  87. private String noEntranceProportion;
  88. @ApiModelProperty("应收金额")
  89. @ExcelProperty("应收金额")
  90. private String receivable;
  91. @ApiModelProperty("一级机构管理费")
  92. @ExcelProperty("一级机构管理费")
  93. private String deptPremiumsLevel1;
  94. @ApiModelProperty("二级机构管理费")
  95. @ExcelProperty("二级机构管理费")
  96. private String deptPremiumsLevel2;
  97. @ApiModelProperty("三级机构管理费")
  98. @ExcelProperty("三级机构管理费")
  99. private String deptPremiumsLevel3;
  100. @ApiModelProperty("四级机构管理费")
  101. @ExcelProperty("四级机构管理费")
  102. private String deptPremiumsLevel4;
  103. @ApiModelProperty("五级机构管理费")
  104. @ExcelProperty("五级机构管理费")
  105. private String deptPremiumsLevel5;
  106. @ApiModelProperty("一级分销金额")
  107. @ExcelProperty("一级分销金额")
  108. private String firstDetailPremiums;
  109. @ApiModelProperty("二级分销金额")
  110. @ExcelProperty("二级分销金额")
  111. private String secondDetailPremiums;
  112. @ApiModelProperty("三级分销金额")
  113. @ExcelProperty("三级分销金额")
  114. private String thirdDetailPremiums;
  115. @ApiModelProperty("交强利润差值")
  116. @ExcelProperty("交强利润差值")
  117. private String jqProfitMarginPremiums;
  118. @ApiModelProperty("商业利润差值")
  119. @ExcelProperty("商业利润差值")
  120. private String syProfitMarginPremiums;
  121. @ApiModelProperty("非车利润差值")
  122. @ExcelProperty("非车利润差值")
  123. private String noProfitMarginPremiums;
  124. @ApiModelProperty("是否是补录订单")
  125. @ExcelProperty("补录订单")
  126. private String isExternal;
  127. }