package com.platform.model.entity; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.fasterxml.jackson.annotation.JsonFormat; import com.fasterxml.jackson.annotation.JsonInclude; import com.platform.annotation.NumericValue; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.Date; /** * @author : wujipeng * @date : 2025/7/30 14:06 * @Version: 1.0 * @Desc : 描述信息 */ @Data @TableName("excel_data") @JsonInclude(JsonInclude.Include.NON_NULL) public class ExcelDataEntity { @TableId(type = IdType.ASSIGN_ID) private String id; @TableField("case_id") @ApiModelProperty("案件id") private int caseId; @TableField("directory_id") @ApiModelProperty("目录id") private String directoryId; @NumericValue(0) @ApiModelProperty("交易类型") private String type; @NumericValue(1) @ApiModelProperty("交易主体的出入") private String direction; @NumericValue(2) @ApiModelProperty("交易时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date time; @NumericValue(3) @ApiModelProperty("交易金额") private double amount; @NumericValue(4) @ApiModelProperty("交易流水号") private String serial; @NumericValue(5) @ApiModelProperty("收款方银行卡所属银行卡号") @TableField("payee_bank_card") private String payeeBankCard; @NumericValue(6) @ApiModelProperty("收款方支付账号") @TableField("payee_account") private String payeeAccount; @NumericValue(7) @ApiModelProperty("收款方商户号") @TableField("payee_merchant") private String payeeMerchant; @NumericValue(8) @ApiModelProperty("收款方商户名称") @TableField("payee_name") private String payeeName; @NumericValue(9) @ApiModelProperty("付款方银行卡所属银行名称") @TableField("payment_bank_name") private String paymentBankName; @NumericValue(10) @ApiModelProperty("付款方银行卡所属银行卡号") @TableField("payment_bank_card") private String paymentBankCard; @NumericValue(11) @ApiModelProperty("付款方支付账号") @TableField("payment_account") private String paymentAccount; @NumericValue(12) @ApiModelProperty("交易支付设备ip") private String ip; @NumericValue(13) @ApiModelProperty("mac地址") private String mac; @NumericValue(14) @ApiModelProperty("银行外部渠道交易流水号") @TableField("external_channel") private String externalChannel; @NumericValue(15) @ApiModelProperty("支付账号") @TableField("pay_account") private String payAccount; @NumericValue(16) @ApiModelProperty("备注") private String remark; @TableField("pay_user_name") private String payUserName; @TableField("file_id") private String fileId; @TableField("use_flag") private Boolean useFlag; @TableField("user_flag") private Boolean userFlag; @ApiModelProperty("本人账户") @TableField(exist = false) private String selfAccount; @ApiModelProperty("关联账户") @TableField(exist = false) private String associationAccount; }