@@ -9,6 +9,7 @@ import {
Card ,
Col ,
DatePicker ,
Descriptions ,
Divider ,
InputNumber ,
Modal ,
@@ -42,8 +43,6 @@ import type {
import UserAdRevenueDrawer from './UserAdRevenueDrawer' ;
const { RangePicker } = DatePicker ;
const DEFAULT_PAGE_SIZE = 50 ;
const ALL_FILTER_VALUE = '__all__' ;
// 广告类型标签
const TYPE_TAG : Record < string , { color : string ; label : string } > = {
@@ -191,76 +190,11 @@ const LT_FACTOR_ROWS = [
{ key : '5' , lt : '第 11 条及以后' , factor : 1.0 } ,
] ;
type AdRevenueDetailRow = AdRevenueRecord & {
source_adn? : string | null ;
is_impression_only? : boolean ;
} ;
const FORMULA_EMPTY_STATUS_LABEL : Record < string , string > = {
capped : '次数超限' ,
ecpm_missing : 'eCPM 缺失' ,
too_short : '观看时长不足' ,
closed_early : '提前关闭' ,
impression_only : '仅展示' ,
} ;
// 未发奖记录用可读状态代替空值，避免误认为数据丢失；悬停时说明为何没有计算因子。
function renderFormulaValue ( value : string | number , row : AdRevenueDetailRow ) {
if ( value !== '-' ) return value ;
const isGrantedButMissing = row . status === 'granted' ;
const reason = isGrantedButMissing
? '该记录标记为已发奖，但计算因子缺失，需要进一步排查'
: row . is_impression_only
? '该记录只有广告展示，没有对应发奖记录'
: REWARD_STATUS_HINT [ row . status ] ? ? ` 发奖状态为 ${ row . status || '未知' } ` ;
const statusLabel = isGrantedButMissing
? '计算数据缺失'
: ( FORMULA_EMPTY_STATUS_LABEL [ row . status ] ? ? row . status ) || '未进入计算' ;
return (
< Tooltip
title = { isGrantedButMissing
? reason
: ` ${ reason } ；未进入金币计算，不占用 LT 累计条数，因此不展示因子。 ` }
>
< span > { statusLabel } < / span >
< / Tooltip >
) ;
}
function impressionOnlyDetail ( row : AdRevenueRow ) : AdRevenueDetailRow {
return {
record_id : 0 ,
created_at : row.created_at ,
status : 'impression_only' ,
ecpm : row.ecpm ,
ecpm_factor : null ,
units : 0 ,
lt_index_start : null ,
lt_index_end : null ,
lt_factor_start : null ,
lt_factor_end : null ,
expected_coin : 0 ,
actual_coin : 0 ,
matched : true ,
adn : row.adn ,
slot_id : row.slot_id ,
source_adn : row.adn ,
is_impression_only : true ,
} ;
}
type AdRevenueDetailRow = AdRevenueRecord & { source_adn? : string | null } ;
// 展开行(逐条事件展开)- 该条的发奖复算明细(还原金币审计的 eCPM/因子1/份数/LT/因子2 等列)
const DETAIL_COLUMNS : ColumnsType < AdRevenueDetailRow > = [
{
title : '来源广告网络' ,
dataIndex : 'source_adn' ,
width : 110 ,
render : ( value : string | null ) = > value ? . trim ( ) || (
< Tooltip title = "该历史记录没有可唯一确认的 SDK 广告来源，未猜测填充。" >
< span > 未 上 报 < / span >
< / Tooltip >
) ,
} ,
{ title : '来源广告网络' , dataIndex : 'source_adn' , width : 110 , render : ( value : string | null ) = > value || '-' } ,
{
title : 'eCPM（元）' ,
dataIndex : 'ecpm' ,
@@ -274,25 +208,18 @@ const DETAIL_COLUMNS: ColumnsType<AdRevenueDetailRow> = [
render : ( v : string | null ) = > ( v == null || Number . isNaN ( Number ( v ) ) ? '-' : ( Number ( v ) / 100 / 1000 ) . toFixed ( 4 ) ) ,
} ,
{ title : '实发金币数' , dataIndex : 'actual_coin' , width : 100 } ,
{
title : '因子1' ,
dataIndex : 'ecpm_factor' ,
width : 70 ,
render : ( v : number | null , row : AdRevenueDetailRow ) = > renderFormulaValue ( v ? ? '-' , row ) ,
} ,
{ title : '因子1' , dataIndex : 'ecpm_factor' , width : 70 , render : ( v : number | null ) = > v ? ? '-' } ,
{
title : '因子2' ,
key : 'lt_factor' ,
width : 90 ,
render : ( _ : unknown , row AdRevenueDetailRow ) = >
renderFormulaValue ( fmtFactorRange ( row . lt_factor_start , row . lt_factor_end ) , row ) ,
render : ( _ : unknown , r AdRevenueDetailRow ) = > fmtFactorRange ( r . lt_factor_start , r . lt_factor_end ) ,
} ,
{
title : 'LT累计条数' ,
key : 'lt_index' ,
width : 100 ,
render : ( _ : unknown , row AdRevenueDetailRow ) = >
renderFormulaValue ( fmtIndexRange ( row . lt_index_start , row . lt_index_end ) , row ) ,
render : ( _ : unknown , r AdRevenueDetailRow ) = > fmtIndexRange ( r . lt_index_start , r . lt_index_end ) ,
} ,
] ;
@@ -460,13 +387,13 @@ export default function AdRevenueReportPage() {
const [ scene , setScene ] = useState < string | undefined > ( ) ;
const [ granularity , setGranularity ] = useState < 'day' | 'hour' > ( 'day' ) ;
const [ sortBy , setSortBy ] = useState < 'time' | 'ecpm' > ( 'time' ) ; // 明细排序:time=时间倒序 / ecpm=eCPM 倒序
const [ limit , setLimit ] = useState < number > ( DEFAULT_PAGE_SIZE ) ;
const [ limit , setLimit ] = useState < number > ( 1000 ) ; // 默认拉满接口单页上限，供单次流程广告数分位统计
const [ page , setPage ] = useState < number > ( 1 ) ; // 当前页码(后端分页;1 起)
const [ queriedGranularity , setQueriedGranularity ] = useState < 'day' | 'hour' > ( 'day' ) ; // 本次结果对应的粒度,决定是否显示「小时」列
const [ queriedMultiDay , setQueriedMultiDay ] = useState ( false ) ; // 本次结果是否跨多天,决定显示「日期」列 + 按天/按小时图
const [ data , setData ] = useState < AdRevenueReport | null > ( null ) ;
const [ allFlowItems , setAllFlowItems ] = useState < AdRevenueRow [ ] > ( [ ] ) ;
const [ queriedLimit , setQueriedLimit ] = useState < number > ( DEFAULT_PAGE_SIZE ) ;
const [ queriedLimit , setQueriedLimit ] = useState < number > ( 1000 ) ;
const [ loading , setLoading ] = useState ( false ) ;
const [ formulaOpen , setFormulaOpen ] = useState ( false ) ;
// 点用户手机号弹出的「用户广告收益详情」半屏抽屉(userId + 手机号;null=关闭)
@@ -734,17 +661,9 @@ export default function AdRevenueReportPage() {
: data . date_from
: ` ${ data . date_from } ~ ${ data . date_to } ` ;
// 第二行大盘「分广告类型」：看视频包含福利视频与提现视频；
// eCPM 使用合并后的总收益 ÷ 总展示数 × 1000，避免只读取 reward_video 而漏算提现视频。
// 第二行大盘「分广告类型」:draw / 激励视频 各自 收益 / eCPM / 展示条数;eCPM = 收益÷展示×1000。
const drawStat = data ? . type_stats ? . draw ;
const rewardVideoStat = data ? . type_stats ? . reward_video ;
const withdrawalVideoStat = data ? . type_stats ? . withdrawal_video ;
const videoStat : AdRevenueTypeStat = {
impressions :
( rewardVideoStat ? . impressions ? ? 0 ) + ( withdrawalVideoStat ? . impressions ? ? 0 ) ,
revenue_yuan :
( rewardVideoStat ? . revenue_yuan ? ? 0 ) + ( withdrawalVideoStat ? . revenue_yuan ? ? 0 ) ,
} ;
const rvStat = data ? . type_stats ? . reward_video ;
const ecpmOf = ( s? : AdRevenueTypeStat ) = >
s && s . impressions > 0 ? ( s . revenue_yuan / s . impressions ) * 1000 : 0 ;
@@ -856,11 +775,12 @@ export default function AdRevenueReportPage() {
< Space size = { 6 } >
< Typography.Text type = "secondary" > 类 型 < / Typography.Text >
< Select
value = { adType ? ? ALL_FILTER_VALUE }
onChange = { ( value ) = > setAdType ( value === ALL_FILTER_VALUE ? undefined : value ) }
placeholder = "全部"
value = { adType }
onChange = { setAdType }
allowClear
style = { { width : 150 } }
options = { [
{ value : ALL_FILTER_VALUE , label : '全部' } ,
{ value : 'reward_video' , label : '看视频' } ,
{ value : 'draw' , label : 'Draw 信息流' } ,
{ value : 'withdrawal_video' , label : '提现看视频' } ,
@@ -870,11 +790,12 @@ export default function AdRevenueReportPage() {
< Space size = { 6 } >
< Typography.Text type = "secondary" > 场 景 < / Typography.Text >
< Select
value = { scene ? ? ALL_FILTER_VALUE }
onChange = { ( value ) = > setScene ( value === ALL_FILTER_VALUE ? undefined : value ) }
placeholder = "全部"
value = { scene }
onChange = { setScene }
allowClear
style = { { width : 130 } }
options = { [
{ value : ALL_FILTER_VALUE , label : '全部' } ,
{ value : 'comparison' , label : '比价' } ,
{ value : 'coupon' , label : '领券' } ,
{ value : 'welfare' , label : '福利' } ,
@@ -1066,13 +987,13 @@ export default function AdRevenueReportPage() {
< Statistic title = "Draw 信息流条数" value = { drawStat ? . impressions ? ? 0 } / >
< / Col >
< Col span = { 4 } >
< Statistic title = "看视频收益(元)" value = { videoStat . revenue_yuan } precision = { 4 } / >
< Statistic title = "看视频收益(元)" value = { rvStat ? . revenue_yuan ? ? 0 } precision = { 4 } / >
< / Col >
< Col span = { 4 } >
< Statistic title = "看视频 eCPM(元/千次)" value = { ecpmOf ( videoStat ) } precision = { 2 } / >
< Statistic title = "看视频 eCPM(元/千次)" value = { ecpmOf ( rvStat ) } precision = { 2 } / >
< / Col >
< Col span = { 4 } >
< Statistic title = "看视频条数" value = { videoStat . impressions } / >
< Statistic title = "看视频条数" value = { rvStat ? . impressions ? ? 0 } / >
< / Col >
< / Row >
< Divider orientation = "left" plain style = { { marginTop : 20 , marginBottom : 16 } } >
@@ -1181,11 +1102,7 @@ export default function AdRevenueReportPage() {
style = { { marginTop : 8 } }
rowKey = "record_id"
columns = { DETAIL_COLUMNS }
dataSource = { r . sub_rewards . map ( ( detail ) = > ( {
. . . detail ,
// 一次比价/领券可能由不同 ADN 连续填充，优先显示本条发奖记录的来源。
source_adn : detail.adn ? ? r . adn ,
} ) ) }
dataSource = { r . sub_rewards . map ( ( detail ) = > ( { . . . detail , source_adn : r.adn } ) ) }
pagination = { false }
size = "small"
scroll = { { x : 900 } }
@@ -1201,10 +1118,7 @@ export default function AdRevenueReportPage() {
style = { { marginTop : 8 } }
rowKey = "record_id"
columns = { DETAIL_COLUMNS }
dataSource = { [ {
. . . r . reward_detail ,
source_adn : r.reward_detail.adn ? ? r . adn ,
} ] }
dataSource = { [ { . . . r . reward_detail , source_adn : r.adn } ] }
pagination = { false }
size = "small"
scroll = { { x : 900 } }
@@ -1212,19 +1126,24 @@ export default function AdRevenueReportPage() {
< / div >
) : (
< div >
< Typography.Text strong > 本 次 广 告 逐 条 明 细 < / Typography.Text > { ' ' }
< Typography.Text type = "secondary" >
( 共 1 条 · 应 发 0 / 实 发 0 ； 仅 展 示 ， 未 单 独 发 奖 )
< / Typography.Text >
< Table < AdRevenueDetailRow >
style = { { marginTop : 8 } }
rowKey = "record_id"
columns = { DETAIL_COLUMNS }
dataSource = { [ impressionOnlyDetail ( r ) ] }
pagination = { false }
size = "small"
scroll = { { x : 900 } }
/ >
< Typography.Text strong > 展 示 明 细 < / Typography.Text > { ' ' }
< Typography.Text type = "secondary" > ( 纯 展 示 事 件 , 未 单 独 发 奖 , 无 金 币 复 算 ) < / Typography.Text >
< Descriptions size = "small" column = { 3 } bordered style = { { marginTop : 8 } } >
< Descriptions.Item label = "时间" > { formatUtcTime ( r . created_at ) } < / Descriptions.Item >
< Descriptions.Item label = "eCPM（分）" > { r . ecpm ? ? '-' } < / Descriptions.Item >
< Descriptions.Item label = "eCPM（元）" >
{ r . ecpm != null && ! Number . isNaN ( Number ( r . ecpm ) )
? ( Number ( r . ecpm ) / 100 ) . toFixed ( 2 )
: '-' }
< / Descriptions.Item >
< Descriptions.Item label = "预估收益(元)" >
{ r . has_impression ? r . revenue_yuan . toFixed ( 4 ) : '-' }
< / Descriptions.Item >
< Descriptions.Item label = "底层 ADN" > { r . adn ? ? '-' } < / Descriptions.Item >
< Descriptions.Item label = "底层代码位(rit)" > { r . slot_id ? ? '-' } < / Descriptions.Item >
< Descriptions.Item label = "我方代码位" > { r . our_code_id ? ? '-' } < / Descriptions.Item >
< Descriptions.Item label = "来源应用" > { r . app_env ? ? '-' } < / Descriptions.Item >
< / Descriptions >
< / div >
) ,
} }
linkeyu