yml2213
f3c5235b81
- 数据库升级：新增 pickup_shop_mappings 映射别名表，并在 admin_pickups 增加 raw_shop_name 永久保留原始店铺录入值 - 后端映射能力：提供历史店铺聚合统计、单条/批量映射至目标标准店铺、映射规则撤销与提号单还原接口；新建提号时若录入已映射别名自动归一化 - 前端管理升级：PickupShopDialog 升级为双 Tab 结构，Tab 2「历史店铺映射与清洗」支持总览统计卡片、状态筛选、单条/批量映射清洗、一键设为标准店铺及撤销还原 - 验证方式：执行并通过全套代码门禁（scripts/check.sh：SQL约束、go vet/build/test、MySQL测试库覆盖率、vue大小、eslint、prettier、vue-tsc及vite构建）
52 lines
3.4 KiB
Go
52 lines
3.4 KiB
Go
package model
|
|
|
|
import (
|
|
"time"
|
|
|
|
"gorm.io/datatypes"
|
|
)
|
|
|
|
// AdminPickup 管理员线下提号记录。
|
|
// 独立于 rental_orders 和正常订单状态机；完成后进入线下提号财务统计。
|
|
// 站内上传完成时入卖家钱包；平台代管完成后进入线下结算。
|
|
type AdminPickup struct {
|
|
ID uint64 `gorm:"primaryKey" json:"id"`
|
|
PickupNo string `gorm:"size:64;not null;uniqueIndex" json:"pickup_no"`
|
|
ListingID uint64 `gorm:"not null;index" json:"listing_id"`
|
|
AccountID uint64 `gorm:"not null;index" json:"account_id"`
|
|
OwnerID uint64 `gorm:"not null;index" json:"owner_id"`
|
|
AdminID uint64 `gorm:"not null" json:"admin_id"`
|
|
Operator string `gorm:"size:64;not null;default:'';index" json:"operator"`
|
|
Platform string `gorm:"size:32;not null;default:''" json:"platform"`
|
|
ThirdPartyOrderNo string `gorm:"size:128;not null;default:'';index" json:"third_party_order_no"`
|
|
ShopName string `gorm:"size:100;not null;default:'';index" json:"shop_name"`
|
|
RawShopName string `gorm:"size:100;not null;default:''" json:"raw_shop_name"`
|
|
AccountSource string `gorm:"size:32;not null;default:'internal';index" json:"account_source"`
|
|
SourceChannel string `gorm:"size:32;not null;default:''" json:"source_channel"`
|
|
SettlementMode string `gorm:"size:32;not null;default:'owner_wallet'" json:"settlement_mode"`
|
|
ListingPriceCent int64 `gorm:"not null;default:0" json:"listing_price_cent"`
|
|
OrderAmountCent int64 `gorm:"not null;default:0" json:"order_amount_cent"`
|
|
DepositAmountCent int64 `gorm:"not null;default:0" json:"deposit_amount_cent"`
|
|
OwnerPriceCent int64 `gorm:"not null;default:0" json:"owner_price_cent"`
|
|
WebsiteProfitCent int64 `gorm:"not null;default:0" json:"website_profit_cent"`
|
|
ProfitAmountCent int64 `gorm:"not null;default:0" json:"profit_amount_cent"`
|
|
SellerRatio float64 `gorm:"type:decimal(10,2);not null;default:0" json:"seller_ratio"`
|
|
BuyerRatio float64 `gorm:"type:decimal(10,2);not null;default:0" json:"buyer_ratio"`
|
|
AccountSnapshot datatypes.JSON `json:"account_snapshot,omitempty"`
|
|
SettleAmountCent int64 `gorm:"not null;default:0" json:"settle_amount_cent"`
|
|
Status string `gorm:"size:20;not null;default:'picking_up';index" json:"status"`
|
|
OfflineSettlementStatus string `gorm:"size:16;not null;default:'none';index" json:"offline_settlement_status"`
|
|
OfflineSettlementRemark string `gorm:"size:255;not null;default:''" json:"offline_settlement_remark"`
|
|
OfflineSettledBy *uint64 `json:"offline_settled_by,omitempty"`
|
|
OfflineSettledAt *time.Time `json:"offline_settled_at,omitempty"`
|
|
Remark string `gorm:"size:255;not null;default:''" json:"remark"`
|
|
CompleteRemark string `gorm:"size:255;not null;default:''" json:"complete_remark"`
|
|
CreatedAt time.Time `json:"created_at"`
|
|
CompletedAt *time.Time `json:"completed_at,omitempty"`
|
|
CancelledAt *time.Time `json:"cancelled_at,omitempty"`
|
|
}
|
|
|
|
func (AdminPickup) TableName() string {
|
|
return "admin_pickups"
|
|
}
|