package report

import (
	"github.com/gogf/gf/v2/os/gtime"

	"gitea.redpowerfuture.com/red-future/common/beans"
)

// DailyReport 日报表实体（统一消耗/效果汇总：外投拉平台报表，DSP聚合auction_log）
type DailyReport struct {
	beans.SQLBaseDO `orm:",inherit"`
	// 业务字段
	ReportDate  *gtime.Time `orm:"report_date" json:"reportDate" description:"报表日期"`
	Channel     string      `orm:"channel" json:"channel" description:"投放通道 external外投/self_dsp自有"`
	AdAccountID int64       `orm:"ad_account_id" json:"adAccountId" description:"广告账户ID"`
	CampaignID  int64       `orm:"campaign_id" json:"campaignId" description:"本地计划ID"`
	Platform    string      `orm:"platform" json:"platform" description:"广告平台 douyin/xiaohongshu/kuaishou"`
	Impressions int64       `orm:"impressions" json:"impressions" description:"展示数"`
	Clicks      int64       `orm:"clicks" json:"clicks" description:"点击数"`
	Cost        int64       `orm:"cost" json:"cost" description:"消耗(分)"`
	Conversions int64       `orm:"conversions" json:"conversions" description:"转化数"`
	Extra       string      `orm:"extra" json:"extra" description:"平台报表原始快照(JSON)，对账用"`
}

// DailyReportCol 日报表字段定义
type DailyReportCol struct {
	beans.SQLBaseCol
	ReportDate  string
	Channel     string
	AdAccountID string
	CampaignID  string
	Platform    string
	Impressions string
	Clicks      string
	Cost        string
	Conversions string
	Extra       string
}

// DailyReportCols 日报表字段常量
var DailyReportCols = DailyReportCol{
	SQLBaseCol:  beans.DefSQLBaseCol,
	ReportDate:  "report_date",
	Channel:     "channel",
	AdAccountID: "ad_account_id",
	CampaignID:  "campaign_id",
	Platform:    "platform",
	Impressions: "impressions",
	Clicks:      "clicks",
	Cost:        "cost",
	Conversions: "conversions",
	Extra:       "extra",
}