package com.doumee.dao.business.model; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; 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 = "") @ExcelColumn(name="") private String id; @ApiModelProperty(value = "对账单ID") @ExcelColumn(name="对账单ID") private String pid; @ApiModelProperty(value = "交易时间") @ExcelColumn(name="交易时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date billDate; @ApiModelProperty(value = "公众账号ID") @ExcelColumn(name="公众账号ID") private String appid; @ApiModelProperty(value = "商户号") @ExcelColumn(name="商户号") private String mchId; @ApiModelProperty(value = "特约商户号") @ExcelColumn(name="特约商户号") private String subMchid; @ApiModelProperty(value = "设备号") @ExcelColumn(name="设备号") private String deviceInfo; @ApiModelProperty(value = "微信订单号") @ExcelColumn(name="微信订单号") private String transactionId; @ApiModelProperty(value = "商户订单号") @ExcelColumn(name="商户订单号") private String outTradeNo; @ApiModelProperty(value = "用户标识") @ExcelColumn(name="用户标识") private String openid; @ApiModelProperty(value = "交易类型") @ExcelColumn(name="交易类型") private String billType; @ApiModelProperty(value = "交易状态") @ExcelColumn(name="交易状态") private String billStatus; @ApiModelProperty(value = "付款银行") @ExcelColumn(name="付款银行") private String bankType; @ApiModelProperty(value = "货币种类") @ExcelColumn(name="货币种类") private String feeType; @ApiModelProperty(value = "应结订单金额", example = "1") @ExcelColumn(name="应结订单金额") private BigDecimal settlementTotalFee; @ApiModelProperty(value = "代金券金额", example = "1") @ExcelColumn(name="代金券金额") private BigDecimal couponFee; @ApiModelProperty(value = "微信退款单号") @ExcelColumn(name="微信退款单号") private String refundId; @ApiModelProperty(value = "商户退款单号") @ExcelColumn(name="商户退款单号") private String outRefundNo; @ApiModelProperty(value = "退款金额", example = "1") @ExcelColumn(name="退款金额") private BigDecimal refundFee; @ApiModelProperty(value = "充值券退款金额", example = "1") @ExcelColumn(name="充值券退款金额") private BigDecimal couponRefundFee; @ApiModelProperty(value = "退款类型") @ExcelColumn(name="退款类型") private String refundType; @ApiModelProperty(value = "退款申请时间") @ExcelColumn(name="退款申请时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date refundApplyDate; @ApiModelProperty(value = "退款成功时间") @ExcelColumn(name="退款成功时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date refundSuccessDate; @ApiModelProperty(value = "退款状态") @ExcelColumn(name="退款状态") private String refundSuccessStatus; @ApiModelProperty(value = "商品名称") @ExcelColumn(name="商品名称") private String body; @ApiModelProperty(value = "商户数据包") @ExcelColumn(name="商户数据包") private String attach; @ApiModelProperty(value = "手续费", example = "1") @ExcelColumn(name="手续费") private BigDecimal cmmsAmt; @ApiModelProperty(value = "费率", example = "1") @ExcelColumn(name="费率") private BigDecimal rate; @ApiModelProperty(value = "订单金额", example = "1") @ExcelColumn(name="订单金额") private BigDecimal totalFee; @ApiModelProperty(value = "申请退款金额", example = "1") @ExcelColumn(name="申请退款金额") private BigDecimal applyRefundFee; @ApiModelProperty(value = "费率备注") @ExcelColumn(name="费率备注") private String rateRemark; }