StatisticsClientIdTarget.java 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. package com.szwl.model.excel;
  2. import com.alibaba.excel.annotation.ExcelProperty;
  3. import com.alibaba.excel.annotation.write.style.ColumnWidth;
  4. import com.alibaba.excel.annotation.write.style.ContentFontStyle;
  5. import com.alibaba.excel.annotation.write.style.HeadFontStyle;
  6. import com.alibaba.excel.annotation.write.style.HeadRowHeight;
  7. import lombok.EqualsAndHashCode;
  8. import lombok.Getter;
  9. import lombok.Setter;
  10. import java.math.BigDecimal;
  11. @Getter
  12. @Setter
  13. @EqualsAndHashCode
  14. @HeadFontStyle(fontHeightInPoints = 14)
  15. @HeadRowHeight(20)
  16. @ContentFontStyle(fontHeightInPoints = 12)
  17. public class StatisticsClientIdTarget {
  18. @ColumnWidth(25)
  19. @ExcelProperty("账号")
  20. private String username;
  21. @ColumnWidth(30)
  22. @ExcelProperty("商家")
  23. private String name;
  24. @ColumnWidth(30)
  25. @ExcelProperty("电话")
  26. private String phone;
  27. @ColumnWidth(25)
  28. @ExcelProperty("地址")
  29. private String address;
  30. @ColumnWidth(30)
  31. @ExcelProperty("设备编号")
  32. private String clientId;
  33. @ColumnWidth(20)
  34. @ExcelProperty("机型")
  35. private String equipmentType;
  36. @ColumnWidth(25)
  37. @ExcelProperty("销售量")
  38. private Integer salesVolume;
  39. @ColumnWidth(30)
  40. @ExcelProperty("销售总金额")
  41. private BigDecimal priceTotal;
  42. }