79 lines
3.5 KiB
Go
79 lines
3.5 KiB
Go
package attribution
|
|
|
|
import (
|
|
"gitea.redpowerfuture.com/red-future/common/beans"
|
|
)
|
|
|
|
// ConversionOrder 转化订单实体（电商平台回传的订单/转化）
|
|
type ConversionOrder struct {
|
|
beans.SQLBaseDO `orm:",inherit"`
|
|
// 业务字段
|
|
ConversionID string `orm:"conversion_id" json:"conversionId" description:"转化事件ID(幂等键)"`
|
|
OrderID string `orm:"order_id" json:"orderId" description:"电商平台订单号"`
|
|
CommercePlatform string `orm:"commerce_platform" json:"commercePlatform" description:"电商平台 jd/taobao"`
|
|
ClickID string `orm:"click_id" json:"clickId" description:"关联点击CID"`
|
|
LocalCampaignID int64 `orm:"local_campaign_id" json:"localCampaignId" description:"本地计划ID(回传路由)"`
|
|
AdAccountID int64 `orm:"ad_account_id" json:"adAccountId" description:"广告账户ID(回传凭据)"`
|
|
DeviceID string `orm:"device_id" json:"deviceId" description:"设备ID(无click_id时兜底归因)"`
|
|
ItemID string `orm:"item_id" json:"itemId" description:"商品ID"`
|
|
ItemName string `orm:"item_name" json:"itemName" description:"商品名称"`
|
|
SkuID string `orm:"sku_id" json:"skuId" description:"SKU ID"`
|
|
ConversionType string `orm:"conversion_type" json:"conversionType" description:"转化类型 order/pay/refund/cart"`
|
|
OrderAmount int64 `orm:"order_amount" json:"orderAmount" description:"订单金额(分)"`
|
|
PayAmount int64 `orm:"pay_amount" json:"payAmount" description:"实付金额(分)"`
|
|
Quantity int `orm:"quantity" json:"quantity" description:"商品数量"`
|
|
OrderStatus string `orm:"order_status" json:"orderStatus" description:"订单状态 paid/refunded/canceled"`
|
|
AttributedBy string `orm:"attributed_by" json:"attributedBy" description:"归因方式 click_id/device/manual"`
|
|
ReportStatus int `orm:"report_status" json:"reportStatus" description:"回传状态 0待回传 1已回传 2失败"`
|
|
ReportCount int `orm:"report_count" json:"reportCount" description:"回传次数"`
|
|
FirstClickTime int64 `orm:"first_click_time" json:"firstClickTime" description:"首次点击时间戳"`
|
|
}
|
|
|
|
// ConversionOrderCol 转化订单表字段定义
|
|
type ConversionOrderCol struct {
|
|
beans.SQLBaseCol
|
|
ConversionID string
|
|
OrderID string
|
|
CommercePlatform string
|
|
ClickID string
|
|
LocalCampaignID string
|
|
AdAccountID string
|
|
DeviceID string
|
|
ItemID string
|
|
ItemName string
|
|
SkuID string
|
|
ConversionType string
|
|
OrderAmount string
|
|
PayAmount string
|
|
Quantity string
|
|
OrderStatus string
|
|
AttributedBy string
|
|
ReportStatus string
|
|
ReportCount string
|
|
FirstClickTime string
|
|
}
|
|
|
|
// ConversionOrderCols 转化订单表字段常量
|
|
var ConversionOrderCols = ConversionOrderCol{
|
|
SQLBaseCol: beans.DefSQLBaseCol,
|
|
ConversionID: "conversion_id",
|
|
OrderID: "order_id",
|
|
CommercePlatform: "commerce_platform",
|
|
ClickID: "click_id",
|
|
LocalCampaignID: "local_campaign_id",
|
|
AdAccountID: "ad_account_id",
|
|
DeviceID: "device_id",
|
|
ItemID: "item_id",
|
|
ItemName: "item_name",
|
|
SkuID: "sku_id",
|
|
ConversionType: "conversion_type",
|
|
OrderAmount: "order_amount",
|
|
PayAmount: "pay_amount",
|
|
Quantity: "quantity",
|
|
OrderStatus: "order_status",
|
|
AttributedBy: "attributed_by",
|
|
ReportStatus: "report_status",
|
|
ReportCount: "report_count",
|
|
FirstClickTime: "first_click_time",
|
|
}
|