QuotationDetailsExcel.java 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465
  1. package com.ydtech.modules.admin.model.dto;
  2. import com.alibaba.excel.annotation.ExcelIgnore;
  3. import com.alibaba.excel.annotation.ExcelProperty;
  4. import lombok.Data;
  5. @Data
  6. public class QuotationDetailsExcel {
  7. @ExcelProperty(value = "订单号",index = 0)
  8. private String orderno;
  9. @ExcelProperty(value = "协议编码",index = 1)
  10. private String agreementId;
  11. @ExcelProperty(value = "订单状态",index = 2)
  12. private String orderstatus;
  13. @ExcelProperty(value = "保险公司编号",index = 3)
  14. private String companyId;
  15. @ExcelProperty(value = "合作公司编号",index = 4)
  16. private String partnerCompaniesId;
  17. @ExcelProperty(value = "合作公司名称",index = 5)
  18. private String partnerCompaniesName;
  19. @ExcelProperty(value = "保险名称",index = 6)
  20. private String inscompany;
  21. @ExcelProperty(value = "交强保单号",index = 7)
  22. private String jqpolicyno;
  23. @ExcelProperty(value = "商业保单号",index = 8)
  24. private String sypolicyno;
  25. @ExcelProperty(value = "总保费",index = 9)
  26. private String sumpremium;
  27. @ExcelProperty(value = "交强险费用",index = 10)
  28. private String jqpremium;
  29. @ExcelProperty(value = "商业险费用",index = 11)
  30. private String sypremium;
  31. @ExcelProperty(value = "驾意险费用",index = 12)
  32. private String jypremium;
  33. @ExcelProperty(value = "录单日期",index = 13)
  34. private String createtime;
  35. @ExcelProperty(value = "签单日期",index = 14)
  36. private String signingTime;
  37. @ExcelProperty(value = "是否是人工审核",index = 15)
  38. private String auditType;
  39. @ExcelProperty(value = "机构来源",index = 16)
  40. private String managementSource;
  41. @ExcelIgnore
  42. private String auditstatus;
  43. }