BusinessAgentExcel.java 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. package com.ydtech.modules.admin.model.dto;
  2. import com.alibaba.excel.annotation.ExcelProperty;
  3. import lombok.Data;
  4. import java.math.BigDecimal;
  5. @Data
  6. public class BusinessAgentExcel {
  7. @ExcelProperty(value = "姓名", index = 0)
  8. private String userName;
  9. @ExcelProperty(value = "工号", index = 1)
  10. private String userId;
  11. @ExcelProperty(value = "归属机构", index = 2)
  12. private String deptName;
  13. @ExcelProperty(value = "管理人", index = 3)
  14. private String leaderName;
  15. @ExcelProperty(value = "机构来源", index = 4)
  16. private String managementSource;
  17. @ExcelProperty(value = "签单保费", index = 5)
  18. private BigDecimal sumPremium;
  19. @ExcelProperty(value = "交强险保费", index = 6)
  20. private BigDecimal jqpremium;
  21. @ExcelProperty(value = "车船税", index = 7)
  22. private BigDecimal taxamount;
  23. @ExcelProperty(value = "商业险保费", index = 8)
  24. private BigDecimal sypremium;
  25. @ExcelProperty(value = "非车险保费", index = 9)
  26. private BigDecimal jypremium;
  27. @ExcelProperty(value = "单交订单数", index = 10)
  28. private Integer riskCodeDj;
  29. @ExcelProperty(value = "单商订单数", index = 11)
  30. private Integer riskCodeDs;
  31. @ExcelProperty(value = "单三订单数", index = 12)
  32. private Integer riskCodeDsan;
  33. @ExcelProperty(value = "交三订单数", index = 13)
  34. private Integer riskCodeJs;
  35. @ExcelProperty(value = "交商订单数", index = 14)
  36. private Integer riskCodeJshang;
  37. }