StatisticsAdminTarget.java 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  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 StatisticsAdminTarget {
  18. @ColumnWidth(30)
  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(30)
  28. @ExcelProperty("地址")
  29. private String address;
  30. @ColumnWidth(30)
  31. @ExcelProperty("机器总数")
  32. private String equipmentTotal;
  33. @ColumnWidth(30)
  34. @ExcelProperty("销售量")
  35. private Integer salesVolume;
  36. @ColumnWidth(30)
  37. @ExcelProperty("销售总金额")
  38. private BigDecimal priceTotal;
  39. }