134 lines
5.9 KiB
Go
134 lines
5.9 KiB
Go
package copydata
|
||
|
||
import "gitea.com/red-future/common/beans"
|
||
|
||
// TaskReport 调控任务数据实体
|
||
type TaskReport struct {
|
||
beans.SQLBaseDO `orm:",inherit"`
|
||
|
||
// 转化率相关字段
|
||
ItemOrderConversionRatio *float64 `orm:"item_order_conversion_ratio" json:"itemOrderConversionRatio" description:"转化率"`
|
||
ItemCardClickRatio *float64 `orm:"item_card_click_ratio" json:"itemCardClickRatio" description:"点击率"`
|
||
ItemCardClkCnt *int64 `orm:"item_card_clk_cnt" json:"itemCardClkCnt" description:"商品卡点击数"`
|
||
LivePlayCntCost *float64 `orm:"live_play_cnt_cost" json:"livePlayCntCost" description:"直播间观看成本"`
|
||
AdMerchantFollowCost *float64 `orm:"ad_merchant_follow_cost" json:"adMerchantFollowCost" description:"涨粉成本"`
|
||
AdMerchantFollow *int64 `orm:"ad_merchant_follow" json:"adMerchantFollow" description:"涨粉数"`
|
||
NetT0OrderCnt *int64 `orm:"net_t0_order_cnt" json:"netT0OrderCnt" description:"当日累计净成交订单数"`
|
||
NetT0Roi *float64 `orm:"net_t0_roi" json:"netT0Roi" description:"净成交 ROI"`
|
||
NetT0Gmv *float64 `orm:"net_t0_gmv" json:"netT0Gmv" description:"净成交 GMV"`
|
||
|
||
// 视频信息字段
|
||
PhotoName string `orm:"photo_name" json:"photoName" description:"视频名称"`
|
||
PhotoId string `orm:"photo_id" json:"photoId" description:"视频 id"`
|
||
|
||
// 核心指标字段
|
||
CostTotal *float64 `orm:"cost_total" json:"costTotal" description:"花费"`
|
||
T0Gmv *float64 `orm:"t0_gmv" json:"t0Gmv" description:"当日累计 GMV"`
|
||
T0Roi *float64 `orm:"t0_roi" json:"t0Roi" description:"当日累计 ROI"`
|
||
T0OrderCnt *int64 `orm:"t0_order_cnt" json:"t0OrderCnt" description:"当日累计订单数"`
|
||
T0OrderCntCost *float64 `orm:"t0_order_cnt_cost" json:"t0OrderCntCost" description:"当日累计订单成本"`
|
||
|
||
// 粉丝 GMV 字段
|
||
FansT0Gmv *float64 `orm:"fans_t0_gmv" json:"fansT0Gmv" description:"涨粉当日 GMV"`
|
||
FansT1Gmv *float64 `orm:"fans_t1_gmv" json:"fansT1Gmv" description:"涨粉次日 GMV"`
|
||
FansT7Gmv *float64 `orm:"fans_t7_gmv" json:"fansT7Gmv" description:"涨粉 7 日 GMV"`
|
||
FansT15Gmv *float64 `orm:"fans_t15_gmv" json:"fansT15Gmv" description:"涨粉 15 日 GMV"`
|
||
FansT30Gmv *float64 `orm:"fans_t30_gmv" json:"fansT30Gmv" description:"涨粉 30 日 GMV"`
|
||
|
||
// 粉丝 ROI 字段
|
||
FansT0Roi *float64 `orm:"fans_t0_roi" json:"fansT0Roi" description:"涨粉当日 ROI"`
|
||
FansT1Roi *float64 `orm:"fans_t1_roi" json:"fansT1Roi" description:"涨粉次日 ROI"`
|
||
FansT7Roi *float64 `orm:"fans_t7_roi" json:"fansT7Roi" description:"涨粉 7 日 ROI"`
|
||
FansT15Roi *float64 `orm:"fans_t15_roi" json:"fansT15Roi" description:"涨粉 15 日 ROI"`
|
||
FansT30Roi *float64 `orm:"fans_t30_roi" json:"fansT30Roi" description:"涨粉 30 日 ROI"`
|
||
|
||
// 全站数据字段
|
||
LivePlayCnt *int64 `orm:"live_play_cnt" json:"livePlayCnt" description:"全站直播观看数"`
|
||
ItemEntranceClkCnt *int64 `orm:"item_entrance_clk_cnt" json:"itemEntranceClkCnt" description:"小黄车点击数"`
|
||
ShowCnt *int64 `orm:"show_cnt" json:"showCnt" description:"全站曝光"`
|
||
|
||
// 时间字段
|
||
ReportDateStr string `orm:"report_date_str" json:"reportDateStr" description:"时间（格式：YYYY-MM-DD）"`
|
||
}
|
||
|
||
// TaskReportCol 调控任务数据表字段定义
|
||
type TaskReportCol struct {
|
||
beans.SQLBaseCol
|
||
ItemOrderConversionRatio string
|
||
ItemCardClickRatio string
|
||
ItemCardClkCnt string
|
||
LivePlayCntCost string
|
||
AdMerchantFollowCost string
|
||
AdMerchantFollow string
|
||
NetT0OrderCnt string
|
||
NetT0Roi string
|
||
NetT0Gmv string
|
||
PhotoName string
|
||
PhotoId string
|
||
CostTotal string
|
||
T0Gmv string
|
||
T0Roi string
|
||
T0OrderCnt string
|
||
T0OrderCntCost string
|
||
FansT0Gmv string
|
||
FansT1Gmv string
|
||
FansT7Gmv string
|
||
FansT15Gmv string
|
||
FansT30Gmv string
|
||
FansT0Roi string
|
||
FansT1Roi string
|
||
FansT7Roi string
|
||
FansT15Roi string
|
||
FansT30Roi string
|
||
LivePlayCnt string
|
||
ItemEntranceClkCnt string
|
||
ShowCnt string
|
||
ReportDateStr string
|
||
}
|
||
|
||
// TableName 返回表名
|
||
func (e *TaskReport) TableName() string {
|
||
return "task_report"
|
||
}
|
||
|
||
// GetCols 获取所有字段名
|
||
func (e *TaskReport) GetCols() *TaskReportCol {
|
||
return &TaskReportCol{
|
||
SQLBaseCol: beans.SQLBaseCol{
|
||
Id: "id",
|
||
CreatedAt: "created_at",
|
||
UpdatedAt: "updated_at",
|
||
},
|
||
ItemOrderConversionRatio: "item_order_conversion_ratio",
|
||
ItemCardClickRatio: "item_card_click_ratio",
|
||
ItemCardClkCnt: "item_card_clk_cnt",
|
||
LivePlayCntCost: "live_play_cnt_cost",
|
||
AdMerchantFollowCost: "ad_merchant_follow_cost",
|
||
AdMerchantFollow: "ad_merchant_follow",
|
||
NetT0OrderCnt: "net_t0_order_cnt",
|
||
NetT0Roi: "net_t0_roi",
|
||
NetT0Gmv: "net_t0_gmv",
|
||
PhotoName: "photo_name",
|
||
PhotoId: "photo_id",
|
||
CostTotal: "cost_total",
|
||
T0Gmv: "t0_gmv",
|
||
T0Roi: "t0_roi",
|
||
T0OrderCnt: "t0_order_cnt",
|
||
T0OrderCntCost: "t0_order_cnt_cost",
|
||
FansT0Gmv: "fans_t0_gmv",
|
||
FansT1Gmv: "fans_t1_gmv",
|
||
FansT7Gmv: "fans_t7_gmv",
|
||
FansT15Gmv: "fans_t15_gmv",
|
||
FansT30Gmv: "fans_t30_gmv",
|
||
FansT0Roi: "fans_t0_roi",
|
||
FansT1Roi: "fans_t1_roi",
|
||
FansT7Roi: "fans_t7_roi",
|
||
FansT15Roi: "fans_t15_roi",
|
||
FansT30Roi: "fans_t30_roi",
|
||
LivePlayCnt: "live_play_cnt",
|
||
ItemEntranceClkCnt: "item_entrance_clk_cnt",
|
||
ShowCnt: "show_cnt",
|
||
ReportDateStr: "report_date_str",
|
||
}
|
||
}
|