magic_admin/model/biz_modules/daytask/dt_finance.go

package daytask

// DtRechargeOrder 充值订单表
type DtRechargeOrder struct {
	Id             int64   `json:"id" gorm:"column:id;type:bigint;primarykey;comment:订单ID"`
	OrderNo        string  `json:"orderNo" gorm:"column:order_no;type:varchar(32);not null;uniqueIndex:uk_order_no;comment:订单编号"`
	UserId         int64   `json:"userId" gorm:"column:user_id;type:bigint;not null;index:idx_user_id;comment:用户ID"`
	UserUid        string  `json:"userUid" gorm:"column:user_uid;type:varchar(32);comment:用户UID"`
	Channel        string  `json:"channel" gorm:"column:channel;type:varchar(32);not null;index:idx_channel;comment:充值渠道: usdt/momo/zalopay/bank"`
	Amount         float64 `json:"amount" gorm:"column:amount;type:decimal(18,2);default:0.00;comment:充值金额(USDT)"`
	ActualAmount   float64 `json:"actualAmount" gorm:"column:actual_amount;type:decimal(18,2);default:0.00;comment:实际到账"`
	Fee            float64 `json:"fee" gorm:"column:fee;type:decimal(18,2);default:0.00;comment:手续费"`
	ExchangeRate   float64 `json:"exchangeRate" gorm:"column:exchange_rate;type:decimal(18,6);default:1.000000;comment:汇率"`
	PayAmount      float64 `json:"payAmount" gorm:"column:pay_amount;type:decimal(18,2);default:0.00;comment:支付金额(原币种)"`
	PayCurrency    string  `json:"payCurrency" gorm:"column:pay_currency;type:varchar(16);default:USDT;comment:支付币种"`
	Txid           string  `json:"txid" gorm:"column:txid;type:varchar(128);comment:交易哈希/流水号"`
	FromAddress    string  `json:"fromAddress" gorm:"column:from_address;type:varchar(128);comment:付款地址"`
	ToAddress      string  `json:"toAddress" gorm:"column:to_address;type:varchar(128);comment:收款地址"`
	Screenshot     string  `json:"screenshot" gorm:"column:screenshot;type:varchar(255);comment:付款截图"`
	PayTime        int64   `json:"payTime" gorm:"column:pay_time;type:bigint;comment:支付时间"`
	ConfirmTime    int64   `json:"confirmTime" gorm:"column:confirm_time;type:bigint;comment:确认时间"`
	ConfirmAdminId int64   `json:"confirmAdminId" gorm:"column:confirm_admin_id;type:bigint;comment:确认管理员ID"`
	Remark         string  `json:"remark" gorm:"column:remark;type:varchar(255);comment:备注"`
	Status         int8    `json:"status" gorm:"column:status;type:tinyint;default:0;index:idx_status;comment:状态: 0=待支付 1=待确认 2=已完成 3=已取消 4=已退款"`
	CreatedAt      int64   `json:"createdAt" gorm:"column:created_at;type:bigint;autoCreateTime;index:idx_created_at;comment:创建时间"`
	UpdatedAt      int64   `json:"updatedAt" gorm:"column:updated_at;type:bigint;autoUpdateTime;comment:更新时间"`
}

func (*DtRechargeOrder) TableName() string {
	return "dt_recharge_order"
}

func NewDtRechargeOrder() *DtRechargeOrder {
	return &DtRechargeOrder{}
}

// DtWithdrawOrder 提现订单表
type DtWithdrawOrder struct {
	Id              int64   `json:"id" gorm:"column:id;type:bigint;primarykey;comment:订单ID"`
	OrderNo         string  `json:"orderNo" gorm:"column:order_no;type:varchar(32);not null;uniqueIndex:uk_order_no;comment:订单编号"`
	UserId          int64   `json:"userId" gorm:"column:user_id;type:bigint;not null;index:idx_user_id;comment:用户ID"`
	UserUid         string  `json:"userUid" gorm:"column:user_uid;type:varchar(32);comment:用户UID"`
	Channel         string  `json:"channel" gorm:"column:channel;type:varchar(32);not null;index:idx_channel;comment:提现渠道: usdt/momo/zalopay/bank"`
	Amount          float64 `json:"amount" gorm:"column:amount;type:decimal(18,2);default:0.00;comment:提现金额(USDT)"`
	ActualAmount    float64 `json:"actualAmount" gorm:"column:actual_amount;type:decimal(18,2);default:0.00;comment:实际到账"`
	Fee             float64 `json:"fee" gorm:"column:fee;type:decimal(18,2);default:0.00;comment:手续费"`
	ExchangeRate    float64 `json:"exchangeRate" gorm:"column:exchange_rate;type:decimal(18,6);default:1.000000;comment:汇率"`
	ReceiveAmount   float64 `json:"receiveAmount" gorm:"column:receive_amount;type:decimal(18,2);default:0.00;comment:收款金额(原币种)"`
	ReceiveCurrency string  `json:"receiveCurrency" gorm:"column:receive_currency;type:varchar(16);default:USDT;comment:收款币种"`
	PaymentId       int64   `json:"paymentId" gorm:"column:payment_id;type:bigint;comment:收款方式ID"`
	ReceiveAccount  string  `json:"receiveAccount" gorm:"column:receive_account;type:varchar(128);comment:收款账号"`
	ReceiveName     string  `json:"receiveName" gorm:"column:receive_name;type:varchar(64);comment:收款人姓名"`
	BankName        string  `json:"bankName" gorm:"column:bank_name;type:varchar(64);comment:银行名称"`
	Txid            string  `json:"txid" gorm:"column:txid;type:varchar(128);comment:交易哈希/流水号"`
	PayScreenshot   string  `json:"payScreenshot" gorm:"column:pay_screenshot;type:varchar(255);comment:打款截图"`
	ApplyTime       int64   `json:"applyTime" gorm:"column:apply_time;type:bigint;comment:申请时间"`
	AuditTime       int64   `json:"auditTime" gorm:"column:audit_time;type:bigint;comment:审核时间"`
	AuditAdminId    int64   `json:"auditAdminId" gorm:"column:audit_admin_id;type:bigint;comment:审核管理员ID"`
	PayTime         int64   `json:"payTime" gorm:"column:pay_time;type:bigint;comment:打款时间"`
	PayAdminId      int64   `json:"payAdminId" gorm:"column:pay_admin_id;type:bigint;comment:打款管理员ID"`
	RejectReason    string  `json:"rejectReason" gorm:"column:reject_reason;type:varchar(255);comment:拒绝原因"`
	Remark          string  `json:"remark" gorm:"column:remark;type:varchar(255);comment:备注"`
	Status          int8    `json:"status" gorm:"column:status;type:tinyint;default:0;index:idx_status;comment:状态: 0=待审核 1=审核通过 2=已打款 3=已完成 4=已拒绝 5=已取消"`
	CreatedAt       int64   `json:"createdAt" gorm:"column:created_at;type:bigint;autoCreateTime;index:idx_created_at;comment:创建时间"`
	UpdatedAt       int64   `json:"updatedAt" gorm:"column:updated_at;type:bigint;autoUpdateTime;comment:更新时间"`
}

func (*DtWithdrawOrder) TableName() string {
	return "dt_withdraw_order"
}

func NewDtWithdrawOrder() *DtWithdrawOrder {
	return &DtWithdrawOrder{}
}

// DtBalanceLog 资金流水表
type DtBalanceLog struct {
	Id            int64   `json:"id" gorm:"column:id;type:bigint;primarykey;comment:流水ID"`
	UserId        int64   `json:"userId" gorm:"column:user_id;type:bigint;not null;index:idx_user_id;comment:用户ID"`
	UserUid       string  `json:"userUid" gorm:"column:user_uid;type:varchar(32);comment:用户UID"`
	Type          string  `json:"type" gorm:"column:type;type:varchar(32);not null;index:idx_type;comment:类型: recharge/withdraw/task_reward/invite_reward/level_purchase/refund/adjust"`
	Amount        float64 `json:"amount" gorm:"column:amount;type:decimal(18,2);default:0.00;comment:变动金额"`
	BalanceBefore float64 `json:"balanceBefore" gorm:"column:balance_before;type:decimal(18,2);default:0.00;comment:变动前余额"`
	BalanceAfter  float64 `json:"balanceAfter" gorm:"column:balance_after;type:decimal(18,2);default:0.00;comment:变动后余额"`
	RelatedId     int64   `json:"relatedId" gorm:"column:related_id;type:bigint;comment:关联ID"`
	RelatedNo     string  `json:"relatedNo" gorm:"column:related_no;type:varchar(32);comment:关联单号"`
	Title         string  `json:"title" gorm:"column:title;type:varchar(128);comment:流水标题"`
	Remark        string  `json:"remark" gorm:"column:remark;type:varchar(255);comment:备注"`
	CreatedAt     int64   `json:"createdAt" gorm:"column:created_at;type:bigint;autoCreateTime;index:idx_created_at;comment:创建时间"`
}

func (*DtBalanceLog) TableName() string {
	return "dt_balance_log"
}

func NewDtBalanceLog() *DtBalanceLog {
	return &DtBalanceLog{}
}

// DtPaymentChannel 支付渠道配置表
type DtPaymentChannel struct {
	Id             int64   `json:"id" gorm:"column:id;type:bigint;primarykey;comment:渠道ID"`
	Code           string  `json:"code" gorm:"column:code;type:varchar(32);not null;uniqueIndex:uk_code;comment:渠道编码: usdt/momo/zalopay/bank"`
	Name           string  `json:"name" gorm:"column:name;type:varchar(64);not null;comment:渠道名称"`
	NameVi         string  `json:"nameVi" gorm:"column:name_vi;type:varchar(64);comment:渠道名称(越南语)"`
	Icon           string  `json:"icon" gorm:"column:icon;type:varchar(255);comment:渠道图标"`
	Type           int8    `json:"type" gorm:"column:type;type:tinyint;default:1;comment:类型: 1=充值 2=提现 3=双向"`
	MinAmount      float64 `json:"minAmount" gorm:"column:min_amount;type:decimal(18,2);default:0.00;comment:最小金额"`
	MaxAmount      float64 `json:"maxAmount" gorm:"column:max_amount;type:decimal(18,2);default:0.00;comment:最大金额"`
	FeeType        int8    `json:"feeType" gorm:"column:fee_type;type:tinyint;default:1;comment:手续费类型: 1=固定 2=比例"`
	FeeValue       float64 `json:"feeValue" gorm:"column:fee_value;type:decimal(18,4);default:0.0000;comment:手续费值"`
	ExchangeRate   float64 `json:"exchangeRate" gorm:"column:exchange_rate;type:decimal(18,6);default:1.000000;comment:汇率"`
	Config         string  `json:"config" gorm:"column:config;type:json;comment:渠道配置(API密钥等)"`
	ReceiveAddress string  `json:"receiveAddress" gorm:"column:receive_address;type:varchar(128);comment:收款地址(USDT)"`
	ReceiveQrcode  string  `json:"receiveQrcode" gorm:"column:receive_qrcode;type:varchar(255);comment:收款二维码"`
	Description    string  `json:"description" gorm:"column:description;type:varchar(512);comment:说明"`
	Status         int8    `json:"status" gorm:"column:status;type:tinyint;default:1;comment:状态: 0=禁用 1=启用"`
	Sort           int     `json:"sort" gorm:"column:sort;type:int;default:0;comment:排序"`
	CreatedAt      int64   `json:"createdAt" gorm:"column:created_at;type:bigint;autoCreateTime;comment:创建时间"`
	UpdatedAt      int64   `json:"updatedAt" gorm:"column:updated_at;type:bigint;autoUpdateTime;comment:更新时间"`
}

func (*DtPaymentChannel) TableName() string {
	return "dt_payment_channel"
}

func NewDtPaymentChannel() *DtPaymentChannel {
	return &DtPaymentChannel{}
}