import { Statistic } from "antd"
import React from "react"
import style from './index.less'
import { gameClassifyEnum } from "@/components/QueryForm/const"
import { version } from "../../components/TableData"
import moment from 'moment';
function columns12(rechargeTrendHandle: (data: any) => void): { label: string, fieldSHow?: { label: string, saveField: string, defaultValue: any[], data: any[] }, data: any[] }[] {
let defaultValue = [ // 默认展示字段
{ label: '充值人数', key: 'rechargeCount', type: '付费趋势' },
{ label: '充值金额', key: 'rechargeMoney', type: '付费趋势' },
{ label: '增', key: 'addPayBack', type: '付费趋势' },
{ label: '回', key: 'payBack', type: '付费趋势' },
{ label: '倍', key: 'newUserRechargeRate', type: '付费趋势' },
]
const getFieldDta = () => {
let mySelectFieldData = localStorage.getItem(`myAdFieldConfig${version}_推广每日数据`)
let newSelectFieldData: any = {}
if (mySelectFieldData) {
newSelectFieldData = JSON.parse(mySelectFieldData).date_field
} else {
newSelectFieldData = defaultValue
}
return newSelectFieldData
}
// 总付费趋势
let defaultStart = 21
const zC = Array(90).fill('').map((_item: string, index: number) => {
let field = `rechargeTrendDay${index + 1}`
let data = {
title: `D${index + 1}`,
dataIndex: `D${index + 1}`,
label: "时间区间跨度",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.dt === '总计') {
if (b?.beginDay) {
date1 = moment(b.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.dt)
}
let dt = moment()
let day = dt.diff(date1, 'day');
let fieldData = getFieldDta()
if (fieldData?.length > 0 && index <= day) {
let data: any = {}
let keyS: string[] = fieldData?.map((item: any) => item.key)
switch (fieldData[0].type) {
case '付费趋势':
if (b?.[field]) {
data = b?.[field]
return
{keyS?.includes('rechargeCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('addPayBack') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('payBack') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('newUserRechargeRate') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
data['default'] = defaultStart + index
return data
})
const Mc = [4, 5, 6, 7, 8, 9, 10, 11, 12].map((index, count) => {
let field = `rechargeTrendMonth${index}`
let data = {
title: `M${index}`,
dataIndex: `M${index}`,
label: "时间区间跨度",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.dt === '总计') {
if (b?.beginDay) {
date1 = moment(b.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.dt)
}
let dt = moment()
let day = dt.diff(date1, 'day');
let fieldData = getFieldDta()
if (fieldData?.length > 0 && index * 30 <= day) {
let data: any = {}
let keyS: string[] = fieldData?.map((item: any) => item.key)
switch (fieldData[0].type) {
case '付费趋势':
if (b?.[field]) {
data = b?.[field]
return
{keyS?.includes('rechargeCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('addPayBack') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('payBack') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('newUserRechargeRate') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
return data
})
let index = 1;
const roiC = Array(29).fill('').map((_item: string) => {
let data = {
title: `${index + 1}日ROI`,
dataIndex: `roiDay${index + 1}`,
label: '付费数据',
align: 'center',
width: 70,
sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
}
index++;
return data
})
return [
{
label: '时间',
data: [
{ title: '日期', dataIndex: 'dt', label: '时间', align: 'center', width: 90, default: 1 },
]
},
{
label: '推广账号信息',
data: [
{
title: '推广账号', dataIndex: 'accountId', key: 'accountId', label: '推广账号信息', align: 'center', width: 70, default: 2,
render: (a: any) => ({a || '--'}
)
},
{
title: '投放渠道', dataIndex: 'agentName', key: 'agentName', label: '推广账号信息', align: 'center', width: 130, default: 3,
render: (a: string, b: any) => ({a || '--'})
}
]
},
{
label: '业务人员信息',
data: [
{ title: '投手', dataIndex: 'sysUserName', key: 'sysUserName', label: '业务人员信息', align: 'center', width: 70, default: 4, render: (a: any) => ({a || '--'}) }
]
},
{
label: '推广内容信息',
data: [
{ title: '推广游戏CP名称', dataIndex: 'cpName', key: 'cpName', label: '推广内容信息', align: 'center', width: 70, default: 5, render: (a: any) => ({a || '--'}) },
{ title: '推广游戏名称', dataIndex: 'gameName', key: 'gameName', label: '推广内容信息', align: 'center', width: 70, default: 6, render: (a: any) => ({a || '--'}) },
{
title: '推广游戏应用类型', dataIndex: 'gameType', key: 'gameType', label: '推广内容信息', align: 'center', width: 80, default: 7,
render: (a: string) => ({gameClassifyEnum[a]})
},
]
},
{
label: '消耗',
data: [
{ title: '消耗', dataIndex: 'cost', key: 'cost', label: '消耗', align: 'center', width: 100, default: 8, sorter: true, render: (a: string) => },
{ title: '推广计划数量', dataIndex: 'adPlanCount', key: 'adPlanCount', label: '消耗', align: 'center', width: 70, default: 9, sorter: true, render: (a: any) => ({a || '--'}) }
]
},
{
label: '广告曝光数据',
data: [
{ title: '曝光量', dataIndex: 'viewCount', label: '广告曝光数据', align: 'center', width: 90, default: 10, sorter: true, render: (a: string) => },
{ title: '点击量', dataIndex: 'clickCount', label: '广告曝光数据', align: 'center', width: 80, default: 11, sorter: true, render: (a: string) => },
{
title: '点击率', dataIndex: 'clickRate', label: '广告曝光数据', align: 'center', width: 70, sorter: true, default: 12,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '转化量', dataIndex: 'convertCount', label: '广告曝光数据', align: 'center', width: 80, default: 13, sorter: true, render: (a: string) => },
{
title: '转化率', dataIndex: 'convertRate', label: '广告曝光数据', align: 'center', width: 70, default: 14, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '平均转化成本', dataIndex: 'avgConvertCost', label: '广告曝光数据', align: 'center', width: 70, default: 15, sorter: true, render: (a: string) => },
{ title: '深度转化量', dataIndex: 'deepConvertCount', label: '广告曝光数据', align: 'center', width: 70, default: 16, sorter: true, render: (a: string) => },
{ title: '深度转化成本', dataIndex: 'deepConvertCost', label: '广告曝光数据', align: 'center', width: 70, default: 17, sorter: true, render: (a: string) => },
{
title: '深度转化率', dataIndex: 'deepConvertRate', label: '广告曝光数据', align: 'center', width: 70, default: 18, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '千次曝光成本', dataIndex: 'thousandViewCost', label: '广告曝光数据', align: 'center', width: 70, default: 19, sorter: true, render: (a: string) => },
{ title: '平均点击均价', dataIndex: 'avgClickCost', label: '广告曝光数据', align: 'center', width: 70, default: 20, sorter: true, render: (a: string) => },
{ title: '应用下载开始量', dataIndex: 'appDownloadCount', label: '广告曝光数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '应用下载开始成本', dataIndex: 'appDownloadCost', label: '广告曝光数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
{
title: '应用下载开始率', dataIndex: 'appDownloadRate', label: '广告曝光数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '应用下载完成量', dataIndex: 'downloadFinish', label: '广告曝光数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '应用下载完成成本', dataIndex: 'downloadFinishCost', label: '广告曝光数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
{
title: '应用下载完成率', dataIndex: 'downloadFinishRate', label: '广告曝光数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '应用安装量', dataIndex: 'appInstallCount', label: '广告曝光数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '应用安装成本', dataIndex: 'appInstallCost', label: '广告曝光数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
{
title: '应用安装完成率', dataIndex: 'appInstallRate', label: '广告曝光数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '应用激活量', dataIndex: 'appActiveCount', label: '广告曝光数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '应用激活成本', dataIndex: 'appActiveCost', label: '广告曝光数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{
title: '应用激活率', dataIndex: 'appActiveRate', label: '广告曝光数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
]
},
{
label: '用户数据',
data: [
{ title: '注册成本', dataIndex: 'regCost', label: '用户数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '注册人数', dataIndex: 'regUserCount', label: '用户数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '首日创角人数', dataIndex: 'firstRoleNum', label: '付费数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
{ title: '新用户累计创角人数', dataIndex: 'newUserTotalRoleNum', label: '付费数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
{ title: '创角人数', dataIndex: 'roleNum', label: '付费数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
]
},
{
label: '付费数据',
data: [
{ title: '首日新用户充值次数', dataIndex: 'firstUserRechargeCount', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '首日新用户充值人数', dataIndex: 'firstUserRechargeUser', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '首日新用户充值金额', dataIndex: 'firstUserRechargeMoney', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '老用户充值次数', dataIndex: 'oldUserRechargeCount', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '老用户充值人数', dataIndex: 'oldUserRechargeUser', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '老用户充值金额', dataIndex: 'oldUserRechargeMoney', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '账面充值次数', dataIndex: 'showRechargeCount', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '账面充值人数', dataIndex: 'showRechargeUser', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '账面充值金额', dataIndex: 'showRechargeMoney', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '新用户累计充值次数', dataIndex: 'newUserRechargeCount', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '新用户累计充值人数', dataIndex: 'newUserRechargeUser', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '新用户累计充值金额', dataIndex: 'newUserRechargeMoney', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{
title: '首日回收率', dataIndex: 'firstRecoveryRate', label: '付费数据', align: 'center', width: 95, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '至今回收率', tips: '至今回收率=新用户累计充值金额/实际消耗', dataIndex: 'buyRecoveryRate', label: '付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '毛利额', dataIndex: 'grossMargin', label: '付费数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
...roiC,
{
title: '60日ROI', dataIndex: 'roiDay60', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '90日ROI', dataIndex: 'roiDay90', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '180日ROI', dataIndex: 'roiDay180', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '1年ROI', dataIndex: 'roiYear1', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总ROI', dataIndex: 'roiTotal', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '首日付费率', dataIndex: 'firstRechargeRate', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量用户付费率', dataIndex: 'buyUserRechargeRate', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '新用户付费比', dataIndex: 'newUserRechargeRate', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '首日客单价', dataIndex: 'avgFirstUserRecharge', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '买量客单价', dataIndex: 'avgBuyUserRecharge', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '账面客单价', dataIndex: 'avgShowUserRecharge', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '首日充值成本', dataIndex: 'firstRechargeCost', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '买量充值成本', dataIndex: 'buyUserRechargeCost', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '首日充值次数成本', dataIndex: 'firstRechargeCountCost', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '老用户充值次数成本', dataIndex: 'oldUserRechargeCountCost', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '账面充值次数成本', dataIndex: 'showRechargeCountCost', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{ title: '新用户累计充值次数成本', dataIndex: 'newUserRechargeCountCost', label: '付费数据', align: 'center', width: 80, sorter: true, render: (a: string) => },
{
title: '复充率', dataIndex: 'repeatRechargeRate', label: '付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{ title: '新增注册ARPPU', dataIndex: 'newRegArpu', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '首日付费ARPPU', dataIndex: 'firstRechargeArpu', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => },
{ title: '至今付费ARPPU', tips: '至今付费ARPPU=新用户累计充值金额/新用户累计充值人数', dataIndex: 'todayRechargeArpu', label: '付费数据', align: 'center', width: 90, sorter: true, render: (a: string) => },
{ title: '账面ARPPU', dataIndex: 'showRechargeArpu', label: '付费数据', align: 'center', width: 70, sorter: true, render: (a: string) => }
]
},
{
fieldSHow: {
label: '日期区间字段展示',
saveField: 'date_field',
defaultValue,
data: [
{
label: '付费趋势',
data: [
{ label: '充值人数', key: 'rechargeCount', type: '付费趋势' },
{ label: '充值金额', key: 'rechargeMoney', type: '付费趋势' },
{ label: '增', key: 'addPayBack', type: '付费趋势' },
{ label: '回', key: 'payBack', type: '付费趋势' },
{ label: '倍', key: 'newUserRechargeRate', type: '付费趋势' },
]
},
]
},
label: '时间区间跨度',
data: [
...zC,
...Mc,
{
title: "总",
default: 111,
dataIndex: "total",
label: "时间区间跨度",
align: "center",
width: 110,
render: (a: any, b: any) => {
let fieldData = getFieldDta()
if (fieldData?.length > 0) {
let data: any = {}
let keyS: string[] = fieldData?.map((item: any) => item.key)
switch (fieldData[0].type) {
case '付费趋势':
if (b?.rechargeTrendTotal) {
data = b?.rechargeTrendTotal
return
{keyS?.includes('rechargeCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('addPayBack') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('payBack') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('newUserRechargeRate') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}]
},
{
label: '操作',
data: [
{
default: 112,
title: '操作', dataIndex: 'cz', label: '操作', align: 'center', width: 70, render: (a: string, b: any) => {
if (b?.dt === '总计') {
return --
}
return rechargeTrendHandle(b)}>复充趋势
}
},
]
},
]
}
export default columns12