| | |
| | | import com.alibaba.fastjson2.annotation.JSONField; |
| | | import com.alibaba.fastjson2.writer.ObjectWriterImplToString; |
| | | import com.dy.common.po.BaseEntity; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.fasterxml.jackson.annotation.JsonPropertyOrder; |
| | | import lombok.Data; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | |
| | | /** |
| | | * 订单号 |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "订单号"}) |
| | | @ColumnWidth(25) |
| | | private String orderNumber; |
| | | |
| | |
| | | * 水卡编号 |
| | | */ |
| | | @JSONField(serializeUsing= ObjectWriterImplToString.class) |
| | | @ColumnWidth(15) |
| | | private Long cardNum; |
| | | @ExcelProperty(value = {"${title}", "水卡编号"}) |
| | | @ColumnWidth(20) |
| | | private String cardNum; |
| | | |
| | | /** |
| | | * 身份证号 |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "身份证号"}) |
| | | @ColumnWidth(15) |
| | | private String idCard; |
| | | |
| | | /** |
| | | * 农户编号 |
| | | */ |
| | | //@ExcelIgnore |
| | | @ExcelProperty(value = {"${title}", "农户编号"}) |
| | | @ColumnWidth(15) |
| | | private String clientNum; |
| | | |
| | |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "交易金额"}) |
| | | @ColumnWidth(15) |
| | | @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) |
| | | private Double tradeAmount; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "购水金额"}) |
| | | @ColumnWidth(15) |
| | | @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) |
| | | private Double waterCost; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "购卡金额"}) |
| | | @ColumnWidth(15) |
| | | @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) |
| | | private Double cardCost; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "赠送金额"}) |
| | | @ColumnWidth(15) |
| | | @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) |
| | | private Double gift; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "返还金额"}) |
| | | @ColumnWidth(15) |
| | | @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) |
| | | private Double refundAmount; |
| | | |
| | | /** |
| | | * 余额 |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "余额"}) |
| | | @ColumnWidth(15) |
| | | @JsonFormat(shape = JsonFormat.Shape.NUMBER_FLOAT, pattern="0.00" ) |
| | | private Double money; |
| | | |
| | | /** |
| | |
| | | /** |
| | | * 收银员姓名 |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "收银员姓名"}) |
| | | @ColumnWidth(15) |
| | | private String cashierName; |
| | | |
| | | /** |
| | | * 卡片状态 |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "卡片状态"}) |
| | | @ColumnWidth(15) |
| | | private String cardState; |
| | | |
| | |
| | | * 村庄名称 |
| | | */ |
| | | @ExcelProperty(value = {"${title}", "村庄名称"}) |
| | | @ColumnWidth(20) |
| | | @ColumnWidth(35) |
| | | private String districtTitle; |
| | | |
| | | /** |