package com.crm.manager.dto.export;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.BaseRowModel;
import lombok.Data;

import java.math.BigDecimal;

/**
 *
 * @author gao
 * @date 2025/11/12 16:41
 */
@Data
public class GlobalOrderListExportDto extends BaseRowModel{

    @ExcelProperty(value = "CID 账户", index = 0)
    private Long CID;

    @ExcelProperty(value = "姓名", index = 1)
    private String name;

    @ExcelProperty(value = "邮箱", index = 2)
    private String email;

    @ExcelProperty(value = "手机号", index = 3)
    private String mobile;

    @ExcelProperty(value = "订单号", index = 4)
    private String merchantOrderNo;

    @ExcelProperty(value = "扣款退款状态", index = 5)
    private String deductionAccountStatus;

    @ExcelProperty(value = "扣款金额", index = 6)
    private BigDecimal deductionAmount;

    @ExcelProperty(value = "扣款手续费", index = 7)
    private BigDecimal deductionFee;

    @ExcelProperty(value = "交易状态", index = 8)
    private String status;

    @ExcelProperty(value = "审核状态", index = 9)
    private String approveStatus;

    @ExcelProperty(value = "审核描述", index = 10)
    private String approveDescCn;

    @ExcelProperty(value = "付款币种", index = 11)
    private String sendCurrency;

    @ExcelProperty(value = "付款金额", index = 12)
    private BigDecimal sendAmount;

    @ExcelProperty(value = "平台手续费金额", index = 13)
    private BigDecimal fee;

    @ExcelProperty(value = "汇率", index = 14)
    private String exchangeRate;

    @ExcelProperty(value = "转账币种", index = 15)
    private String payoutCurrency;

    @ExcelProperty(value = "转账类型", index = 16)
    private String transferType;

    @ExcelProperty(value = "支付方式", index = 17)
    private String payoutMethod;

    @ExcelProperty(value = "收款金额", index = 18)
    private BigDecimal transferAmount;

    @ExcelProperty(value = "交易状态描述", index = 19)
    private String statusStr;

    @ExcelProperty(value = "交易失败原因", index = 20)
    private String error;

    @ExcelProperty(value = "汇款目的", index = 21)
    private String purposeOfRemittanceValue;

    @ExcelProperty(value = "付款人的资金来源", index = 22)
    private String senderSourceOfFundValue;

    @ExcelProperty(value = "付款人和收款人之间的关系", index = 23)
    private String senderBeneficiaryRelationshipValue;

    @ExcelProperty(value = "交易备注", index = 24)
    private String senderRemark;

    @ExcelProperty(value = "付款人的名字", index = 25)
    private String senderFirstName;

    @ExcelProperty(value = "付款人的姓氏", index = 26)
    private String senderLastName;

    @ExcelProperty(value = "付款人的性别", index = 27)
    private String senderGenderValue;

    @ExcelProperty(value = "付款人的身份证件类型", index = 28)
    private String senderIdTypeValue;

    @ExcelProperty(value = "付款人的身份号码", index = 29)
    private String senderIdNumber;

    @ExcelProperty(value = "付款人的国籍", index = 30)
    private String senderNationalityValue;

    @ExcelProperty(value = "付款人的身份证明文件的签发国家/地区", index = 30)
    private String senderIdIssueCountryValue;

    @ExcelProperty(value = "付款人的出生日期", index = 32)
    private String senderDateOfBirth;

    @ExcelProperty(value = "付款人居住国家", index = 33)
    private String senderCountryValue;

    @ExcelProperty(value = "付款人居住省份/州", index = 34)
    private String senderStateValue;

    @ExcelProperty(value = "付款人的地址区域", index = 35)
    private String senderRegionValue;

    @ExcelProperty(value = "付款人居住城市", index = 36)
    private String senderCity;

    @ExcelProperty(value = "付款人居住详细地址", index = 37)
    private String senderAddress;

    @ExcelProperty(value = "付款人邮编", index = 38)
    private String senderZipCode;

    @ExcelProperty(value = "付款人的手机区号", index = 39)
    private String senderMobileAreaCode;

    @ExcelProperty(value = "付款人的手机号", index = 46)
    private String senderMobileNumber;

    @ExcelProperty(value = "付款人的邮箱", index = 41)
    private String senderEmail;

    @ExcelProperty(value = "付款人的职业", index = 42)
    private String senderOccupationValue;

    @ExcelProperty(value = "收款人的银行ID", index = 43)
    private String receiverBankIdValue;

    @ExcelProperty(value = "收款人的银行账号", index = 44)
    private String receiverBankAccountNumber;

    @ExcelProperty(value = "收款人持有的银行账户类型", index = 45)
    private String receiverBankAccountTypeValue;

    @ExcelProperty(value = "收款人的银行分行代码", index = 46)
    private String receiverBankBranchCode;

    @ExcelProperty(value = "收款银行帐户所在的区域", index = 47)
    private String receiverBankStateValue;

    @ExcelProperty(value = "收款银行所在城市", index = 48)
    private String receiverBankCityValue;

    @ExcelProperty(value = "收款人的账户持有人姓名", index = 49)
    private String receiverAccountHolderName;

    @ExcelProperty(value = "收款人的名字", index = 50)
    private String receiverFirstName;

    @ExcelProperty(value = "收款人的姓氏", index = 51)
    private String receiverLastName;

    @ExcelProperty(value = "收款人的性别", index = 52)
    private String receiverGenderValue;

    @ExcelProperty(value = "收款人的身份号码", index = 53)
    private String receiverIdNumber;

    @ExcelProperty(value = "收款人的身份号码类型", index = 54)
    private String receiverIdTypeValue;

    @ExcelProperty(value = "收款人的出生日期", index = 55)
    private String receiverDateOfBirth;

    @ExcelProperty(value = "收款人的手机号码区号", index = 56)
    private String receiverMobileAreaCode;

    @ExcelProperty(value = "收款人的手机号码", index = 57)
    private String receiverMobileNumber;

    @ExcelProperty(value = "收款人的国籍", index = 58)
    private String receiverNationalityValue;

    @ExcelProperty(value = "收款人的母语地址", index = 59)
    private String receiverNativeAddress;

    @ExcelProperty(value = "收款人的母语名字", index = 60)
    private String receiverNativeFirstName;

    @ExcelProperty(value = "收款人的母语姓氏", index = 61)
    private String receiverNativeLastName;

    @ExcelProperty(value = "收款人的职业", index = 62)
    private String receiverOccupationValue;

    @ExcelProperty(value = "收款人所在地区", index = 63)
    private String receiverRegionValue;

    @ExcelProperty(value = "收款人所在省份/州", index = 64)
    private String receiverStateValue;

    @ExcelProperty(value = "收款人所在城市", index = 65)
    private String receiverCity;

    @ExcelProperty(value = "收款人的地址", index = 66)
    private String receiverAddress;

    @ExcelProperty(value = "收款人所在地区邮编", index = 67)
    private String receiverZipCode;

    @ExcelProperty(value = "交易时间", index = 68)
    private String transactionTime;

}
