package com.doumee.dao.business.model;

import com.baomidou.mybatisplus.annotation.TableField;
import com.doumee.core.annotation.excel.ExcelColumn;
import com.fasterxml.jackson.annotation.JsonFormat;
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 java.math.BigDecimal;
import java.util.Date;

/**
 * 
 * @author 江蹄蹄
 * @date 2023/09/27 18:08
 */
@Data
@ApiModel("")
@TableName("\"wx_bill\"")
public class WxBill {

    @ApiModelProperty(value = "")
    @ExcelColumn(name="主键，按照日期yyyyMMDD格式存储，防止重复")
    private String id;

    @ApiModelProperty(value = "总交易单数", example = "1")
    @ExcelColumn(name="收款交易单数")
    private Integer sumBill;

    @ApiModelProperty(value = "退款笔数", example = "1")
    @ExcelColumn(name="退款笔数")
    private Integer sumRefundBill;

    @ApiModelProperty(value = "应结订单总金额（交易金额）", example = "1")
    @ExcelColumn(name="交易金额")
    private BigDecimal sumSuccessFee;

    @ApiModelProperty(value = "退款金额", example = "1")
    @ExcelColumn(name="退款金额")
    private BigDecimal sumRefundFee;

    @ApiModelProperty(value = "充值券退款总金额", example = "1")
    @ExcelColumn(name="充值券退款总金额")
    private BigDecimal sumCouponRefundFee;

    @ApiModelProperty(value = "收款手续费总金额", example = "1")
    @ExcelColumn(name="收款手续费总金额")
    private BigDecimal sumCmmsAmt;

    @ApiModelProperty(value = "订单总金额", example = "1")
    @ExcelColumn(name="订单总金额")
    private BigDecimal sumTotalFee;

    @ApiModelProperty(value = "申请退款金额", example = "1")
    @ExcelColumn(name="申请退款金额")
    private BigDecimal sumApplyRefundFee;

    @ApiModelProperty(value = "退款手续费", example = "1")
    @ExcelColumn(name="退款手续费")
    private BigDecimal sumRefundCmmsAmt;

    @ApiModelProperty(value = "结算金额", example = "1")
    @ExcelColumn(name="结算金额")
    private BigDecimal total;

    @ApiModelProperty(value = "自行车收入", example = "1")
    @ExcelColumn(name="自行车收入")
    private BigDecimal bikeFee;
    @ApiModelProperty(value = "套餐收入", example = "1")
    @ExcelColumn(name="套餐收入")
    private BigDecimal discountFee;
    @ApiModelProperty(value = "骑行订单退款", example = "1")
    @ExcelColumn(name="骑行订单退款")
    private BigDecimal bikeRefundFee;
    @ApiModelProperty(value = "套餐卡退款总金额", example = "1")
    @ExcelColumn(name="套餐卡退款总金额")
    private BigDecimal discountRefundFee;
    @ApiModelProperty(value = "骑行订单退款手续费", example = "1")
    @ExcelColumn(name="骑行订单退款手续费")
    private BigDecimal bikeRefundCmmsAmt;
    @ApiModelProperty(value = "套餐卡退款总金额手续费", example = "1")
    @ExcelColumn(name="套餐卡退款总金额手续费")
    private BigDecimal discountRefundCmmsAmt;

    @ApiModelProperty(value = "同步微信账单日期", example = "2023-10-08")
    @TableField(exist = false)
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date createDate;
    @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;

}