package com.dy.pipIrrGlobal.voSe;
|
|
import com.alibaba.excel.annotation.ExcelIgnore;
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.write.style.ColumnWidth;
|
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
|
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
|
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;
|
|
import java.util.Date;
|
|
/**
|
* @author ZhuBaoMin
|
* @date 2024-02-01 20:38
|
* @LastEditTime 2024-02-01 20:38
|
* @Description
|
*/
|
|
@Data
|
@JsonPropertyOrder({"orderNumber", "clientName", "cardNum", "idCard", "clientNum", "phone", "operateType", "tradeAmount", "waterCost", "cardCost", "gift", "refundAmount", "money", "paymentName", "tradeTime", "cashierId", "cashierName", "cardState", "districtTitle", "villageId"})
|
@HeadRowHeight(30)
|
@ContentRowHeight(20)
|
public class VoTradeDetails implements BaseEntity {
|
private static final long serialVersionUID = 202402012040001L;
|
|
/**
|
* 订单号
|
*/
|
@ExcelProperty(value = {"${title}", "订单号"})
|
@ColumnWidth(25)
|
private String orderNumber;
|
|
/**
|
* 农户姓名
|
*/
|
@ExcelProperty(value = {"${title}", "农户姓名"})
|
@ColumnWidth(15)
|
private String clientName;
|
|
/**
|
* 水卡编号
|
*/
|
@JSONField(serializeUsing= ObjectWriterImplToString.class)
|
@ExcelProperty(value = {"${title}", "水卡编号"})
|
@ColumnWidth(20)
|
private String cardNum;
|
|
/**
|
* 身份证号
|
*/
|
@ExcelProperty(value = {"${title}", "身份证号"})
|
@ColumnWidth(15)
|
private String idCard;
|
|
/**
|
* 农户编号
|
*/
|
@ExcelProperty(value = {"${title}", "农户编号"})
|
@ColumnWidth(15)
|
private String clientNum;
|
|
/**
|
* 联系电话
|
*/
|
@ExcelProperty(value = {"${title}", "联系电话"})
|
@ColumnWidth(15)
|
private String phone;
|
|
/**
|
* 业务类型
|
*/
|
@ExcelProperty(value = {"${title}", "业务类型"})
|
@ColumnWidth(15)
|
private String operateType;
|
|
/**
|
* 交易金额
|
*/
|
@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 paymentName;
|
|
/**
|
* 交易时间
|
*/
|
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
|
@ExcelProperty(value = {"${title}", "交易时间"})
|
@ColumnWidth(20)
|
private Date tradeTime;
|
|
/**
|
* 收银员ID
|
*/
|
@JSONField(serializeUsing= ObjectWriterImplToString.class)
|
@ExcelIgnore
|
private Long cashierId;
|
|
/**
|
* 收银员姓名
|
*/
|
@ExcelProperty(value = {"${title}", "收银员姓名"})
|
@ColumnWidth(15)
|
private String cashierName;
|
|
/**
|
* 卡片状态
|
*/
|
@ExcelProperty(value = {"${title}", "卡片状态"})
|
@ColumnWidth(15)
|
private String cardState;
|
|
/**
|
* 村庄名称
|
*/
|
@ExcelProperty(value = {"${title}", "村庄名称"})
|
@ColumnWidth(35)
|
private String districtTitle;
|
|
/**
|
* 村庄ID
|
*/
|
@JSONField(serializeUsing= ObjectWriterImplToString.class)
|
@ExcelIgnore
|
private Long villageId;
|
}
|
