You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

27 lines
1.7 KiB

6 months ago
package model
import "shop-api/global"
type DtStatisticOrder struct { // 数据统计-订单
global.MG_MODEL
Value string `gorm:"size:20" json:"value"` // 统计对象 eg:20231020(按天统计)
Unit string `gorm:"size:10" json:"unit"` // 单位 hour/day/month/all
Type int `gorm:"type:tinyint(1)" json:"type"` // 关联类型 0:无 1:用户 2:任务领取id 3:店铺id 4:spu_no
RelationId string `gorm:"size:60" json:"relation_id"` // 关联id 用户id/任务领取id/店铺id
NewOrderNum int64 `gorm:"type:int" json:"new_order_num"` // 创建订单数
NewOrderMoney float64 `gorm:"type:decimal(10,2)" json:"new_order_money"` // 创建订单金额
OrderNum int64 `gorm:"type:int" json:"order_num"` // 订单数
OrderMoney float64 `gorm:"type:decimal(10,2)" json:"order_money"` // 订单金额
OrderDoneNum int64 `gorm:"type:int" json:"order_done_num"` // 订单完成数
SaleVolume int64 `gorm:"type:int" json:"sale_volume"` // 销售量
SettleReward float64 `gorm:"type:decimal(10,2)" json:"settle_reward"` // 结算佣金
TransitReward float64 `gorm:"type:decimal(10,2)" json:"transit_reward"` // 在途佣金
OrderCancelNum int64 `gorm:"type:int" json:"order_cancel_num"` // 订单取消数
OrderCancelMoney float64 `gorm:"type:decimal(10,2)" json:"order_cancel_money"` // 订单取消金额
//Income float64 `gorm:"type:decimal(10,2)" json:"income"` // 收入
}
func (DtStatisticOrder) TableName() string {
return "dt_statistic_order"
}