package com.doumee.dao.business.model;
|
|
import com.baomidou.mybatisplus.annotation.TableField;
|
import com.doumee.core.annotation.excel.ExcelColumn;
|
import io.swagger.annotations.ApiModel;
|
import io.swagger.annotations.ApiModelProperty;
|
import com.baomidou.mybatisplus.annotation.TableName;
|
import lombok.Data;
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import org.apache.poi.ss.usermodel.HorizontalAlignment;
|
|
import java.util.Date;
|
import java.math.BigDecimal;
|
|
/**
|
*
|
* @author 江蹄蹄
|
* @date 2023/09/27 18:08
|
*/
|
@Data
|
@ApiModel("")
|
@TableName("\"wx_bill_detail\"")
|
public class WxBillDetail {
|
|
@ApiModelProperty(value = "")
|
private String id;
|
|
@ApiModelProperty(value = "对账单ID")
|
private String pid;
|
|
@ApiModelProperty(value = "交易时间")
|
@ExcelColumn(name="支付时间",index = 4,width = 10,align = HorizontalAlignment.CENTER, dateFormat = "yyyy-MM-dd HH:mm:ss")
|
//@JsonFormat(pattern = "yyyy-MM-dd")
|
private Date billDate;
|
|
@ApiModelProperty(value = "公众账号ID")
|
private String appid;
|
|
@ApiModelProperty(value = "商户号")
|
private String mchId;
|
|
@ApiModelProperty(value = "特约商户号")
|
private String subMchid;
|
|
@ApiModelProperty(value = "设备号")
|
private String deviceInfo;
|
|
@ApiModelProperty(value = "微信交易号")
|
@ExcelColumn(name="微信交易号",index = 3, width = 10,align = HorizontalAlignment.CENTER)
|
private String transactionId;
|
|
@ApiModelProperty(value = "商户订单号")
|
@ExcelColumn(name="订单编号", index = 2,width = 10,align = HorizontalAlignment.CENTER)
|
private String outTradeNo;
|
|
@ApiModelProperty(value = "用户标识")
|
@ExcelColumn(name="用户",index = 1,width = 10,align = HorizontalAlignment.CENTER)
|
private String openid;
|
|
@ApiModelProperty(value = "交易类型")
|
private String billType;
|
|
@ApiModelProperty(value = "交易状态")
|
private String billStatus;
|
|
@ApiModelProperty(value = "付款银行")
|
private String bankType;
|
|
@ApiModelProperty(value = "货币种类")
|
private String feeType;
|
|
@ApiModelProperty(value = "应结订单金额", example = "1")
|
@ExcelColumn(name="支付金额",index = 5, width = 10,align = HorizontalAlignment.CENTER)
|
private BigDecimal settlementTotalFee;
|
|
@ApiModelProperty(value = "代金券金额", example = "1")
|
private BigDecimal couponFee;
|
|
@ApiModelProperty(value = "微信退款单号")
|
private String refundId;
|
|
@ApiModelProperty(value = "商户退款单号")
|
private String outRefundNo;
|
|
@ApiModelProperty(value = "退款金额", example = "1")
|
@ExcelColumn(name="退款金额",index = 7, width = 10,align = HorizontalAlignment.CENTER,dateFormat = "yyyy-MM-dd HH:mm:ss")
|
private BigDecimal refundFee;
|
|
@ApiModelProperty(value = "充值券退款金额", example = "1")
|
private BigDecimal couponRefundFee;
|
|
@ApiModelProperty(value = "退款类型")
|
private String refundType;
|
|
@ApiModelProperty(value = "退款申请时间")
|
private Date refundApplyDate;
|
|
@ApiModelProperty(value = "退款成功时间")
|
@ExcelColumn(name="退款时间",index = 6, width = 10,align = HorizontalAlignment.CENTER,dateFormat = "yyyy-MM-dd HH:mm:ss")
|
private Date refundSuccessDate;
|
|
@ApiModelProperty(value = "退款状态")
|
private String refundSuccessStatus;
|
|
@ApiModelProperty(value = "商品名称")
|
private String body;
|
|
@ApiModelProperty(value = "商户数据包")
|
private String attach;
|
|
@ApiModelProperty(value = "手续费", example = "1")
|
private BigDecimal cmmsAmt;
|
|
@ApiModelProperty(value = "费率", example = "1")
|
private BigDecimal rate;
|
|
@ApiModelProperty(value = "订单金额", example = "1")
|
private BigDecimal totalFee;
|
|
@ApiModelProperty(value = "申请退款金额", example = "1")
|
private BigDecimal applyRefundFee;
|
|
@ApiModelProperty(value = "费率备注")
|
private String rateRemark;
|
@ApiModelProperty(value = "查询开始日期（包含）", example = "20231008")
|
@TableField(exist = false)
|
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:sss")
|
private Date startDate;
|
@ApiModelProperty(value = "查询截止日期（包含）", example = "20231008")
|
@TableField(exist = false)
|
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:sss")
|
private Date endDate;
|
@ApiModelProperty(value = "总交易单数", example = "1")
|
@TableField(exist = false)
|
private Integer sumBill;
|
|
@ApiModelProperty(value = "是否非自行车交易明细 0自行车交易 1非自行车交易,null表示所有", example = "0")
|
@TableField(exist = false)
|
private Integer isBikeFee;
|
|
}
|
