50 lines
2.5 KiB
Go
50 lines
2.5 KiB
Go
package model
|
|
|
|
import "time"
|
|
|
|
// MatchStatus 匹配状态
|
|
type MatchStatus string
|
|
|
|
const (
|
|
MatchStatusMatched MatchStatus = "MATCHED"
|
|
MatchStatusPendingManual MatchStatus = "PENDING_MANUAL"
|
|
MatchStatusNameDiff MatchStatus = "NAME_DIFF" // 匹配成功但名称不一致
|
|
)
|
|
|
|
// SubMerchantAccount 子商户固定收款账户
|
|
type SubMerchantAccount struct {
|
|
ID uint64 `gorm:"column:id;primaryKey;autoIncrement"`
|
|
AppID string `gorm:"column:app_id;size:32;not null;index:idx_app_merchant"`
|
|
SubMerchantID string `gorm:"column:sub_merchant_id;size:64;not null;index:idx_app_merchant"`
|
|
ChannelCode string `gorm:"column:channel_code;size:32;not null"`
|
|
AccountType string `gorm:"column:account_type;size:20;not null"` // BANK_CARD
|
|
AccountNo string `gorm:"column:account_no;size:64;not null;index"` // 脱敏
|
|
AccountNoEnc string `gorm:"column:account_no_enc;type:text"` // AES 加密完整账号
|
|
AccountName string `gorm:"column:account_name;size:128;not null"`
|
|
BankName string `gorm:"column:bank_name;size:64"`
|
|
Status int8 `gorm:"column:status;not null;default:1"`
|
|
CreatedAt time.Time `gorm:"column:created_at;autoCreateTime:milli"`
|
|
UpdatedAt time.Time `gorm:"column:updated_at;autoUpdateTime:milli"`
|
|
}
|
|
|
|
func (SubMerchantAccount) TableName() string { return "sub_merchant_account" }
|
|
|
|
// PaymentMatchLog 收款匹配记录
|
|
type PaymentMatchLog struct {
|
|
ID uint64 `gorm:"column:id;primaryKey;autoIncrement"`
|
|
AccountID uint64 `gorm:"column:account_id;not null;index:idx_account_status"`
|
|
TradeNo string `gorm:"column:trade_no;size:32;index"`
|
|
IncomingAmount int64 `gorm:"column:incoming_amount;not null"`
|
|
IncomingRemark string `gorm:"column:incoming_remark;size:256"`
|
|
PayerName string `gorm:"column:payer_name;size:128"`
|
|
ChannelBillNo string `gorm:"column:channel_bill_no;size:64;index"`
|
|
MatchStatus MatchStatus `gorm:"column:match_status;size:20;not null;index:idx_account_status"`
|
|
NameDiff int8 `gorm:"column:name_diff;not null;default:0"` // 1=名称不一致
|
|
MatchTime *time.Time `gorm:"column:match_time"`
|
|
Operator string `gorm:"column:operator;size:64"` // 人工操作者
|
|
CreatedAt time.Time `gorm:"column:created_at;autoCreateTime:milli"`
|
|
UpdatedAt time.Time `gorm:"column:updated_at;autoUpdateTime:milli"`
|
|
}
|
|
|
|
func (PaymentMatchLog) TableName() string { return "payment_match_log" }
|