import React from "react"
import style from './index.less'
import { Statistic } from "antd"
import { gameClassifyEnum } from "@/components/QueryForm/const"
import { version } from "../../components/TableData"
import moment from "moment"
function columnsNature12(rechargeTrendHandle: (data: any) => void): { label: string, fieldSHow?: { label: string, saveField: string, defaultValue: any[], data: any[] }, data: any[] }[] {
const getFieldDta = () => {
let defaultValue = [ // 默认展示字段
{ label: '充值人数', key: 'rechargeUserCount', type: '付费趋势' },
{ label: '充值金额', key: 'rechargeMoney', type: '付费趋势' },
{ label: '增', key: 'increase', type: '付费趋势' },
{ label: '回', key: 'back', type: '付费趋势' },
{ label: '倍', key: 'multiples', type: '付费趋势' },
]
let mySelectFieldData = localStorage.getItem(`myAdFieldConfig${version}_游戏每日数据`)
let newSelectFieldData: any = {}
if (mySelectFieldData) {
newSelectFieldData = JSON.parse(mySelectFieldData).date_field
} else {
newSelectFieldData = defaultValue
}
return newSelectFieldData
}
// 买量付费趋势
const buyC = Array(90).fill('').map((_item: string, index: number) => {
let field = `buyAmountD${index + 1}Trend`
let data = {
title: `D${index + 1}(买)`,
dataIndex: `D${index + 1}Buy`,
label: "买量付费趋势",
align: "center",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.costDate === '总计') {
if (b?.beginDay) {
date1 = moment(b?.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.costDate)
}
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('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
return data
})
const buyM = [4, 5, 6, 7, 8, 9, 10, 11, 12].map((index, num) => {
let field = `buyAmountM${index}Trend`
let data = {
title: `M${index}(买)`,
dataIndex: `M${index}Buy`,
label: "买量付费趋势",
align: "center",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.costDate === '总计') {
if (b?.beginDay) {
date1 = moment(b?.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.costDate)
}
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('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
return data
})
let natureDefaultStart = 14
// 自然量
const natureC = Array(90).fill('').map((_item: string, index: number) => {
let field = `natureAmountD${index + 1}Trend`
let data = {
title: `D${index + 1}(自)`,
dataIndex: `D${index + 1}Nature`,
label: "自然量付费趋势",
align: "center",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.costDate === '总计') {
if (b?.beginDay) {
date1 = moment(b?.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.costDate)
}
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('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
data['default'] = natureDefaultStart + index
return data
})
const natureM = [4, 5, 6, 7, 8, 9, 10, 11, 12].map((index, num) => {
let field = `natureAmountM${index}Trend`
let data = {
title: `M${index}(自)`,
dataIndex: `M${index}Nature`,
label: "自然量付费趋势",
align: "center",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.costDate === '总计') {
if (b?.beginDay) {
date1 = moment(b?.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.costDate)
}
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('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
data['default'] = natureDefaultStart + 90 + num
return data
})
// 总付费趋势
const zC = Array(90).fill('').map((_item: string, index: number) => {
let field = `amountD${index + 1}Trend`
let data = {
title: `D${index + 1}(总)`,
dataIndex: `D${index + 1}`,
label: "总付费趋势",
align: "center",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.costDate === '总计') {
if (b?.beginDay) {
date1 = moment(b?.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.costDate)
}
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('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
return data
})
const zM = [4, 5, 6, 7, 8, 9, 10, 11, 12].map((index, num) => {
let field = `amountM${index}Trend`
let data = {
title: `M${index}(总)`,
dataIndex: `M${index}`,
label: "总付费趋势",
align: "center",
width: 110,
render: (a: any, b: any) => {
let date1 = moment()
if (b?.costDate === '总计') {
if (b?.beginDay) {
date1 = moment(b?.beginDay)
} else {
date1 = moment()
}
} else {
date1 = moment(b.costDate)
}
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('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}
return data
})
return [
{
label: '游戏信息',
data: [
{ title: '推广游戏名称', dataIndex: 'gameName', label: '游戏信息', align: 'center', width: 70, default: 2 },
{
title: '推广游戏应用类型', dataIndex: 'gameClassify', label: '游戏信息', align: 'center', width: 80,
render: (a: string) => ({gameClassifyEnum[a]})
}
]
},
{
label: '时间',
data: [
{ title: '日期', dataIndex: 'costDate', label: '时间', align: 'center', width: 90, default: 1 },
]
},
{
label: '消耗',
data: [
{
title: '消耗', dataIndex: 'cost', label: '消耗', align: 'center', width: 90, sorter: true, default: 3,
render: (a: string) =>
}
]
},
{
label: '买量用户数据',
data: [
{ title: '买量注册人数', dataIndex: 'buyRegNum', label: '买量用户数据', align: 'center', width: 70, sorter: true },
{ title: '买量注册成本', dataIndex: 'buyRegCost', label: '买量用户数据', align: 'center', width: 70, sorter: true }
]
},
{
label: '自然量用户数据',
data: [
{ title: '自然量注册人数', dataIndex: 'natureRegNum', label: '自然量用户数据', align: 'center', width: 70, default: 4, sorter: true },
{ title: '自然量注册成本', dataIndex: 'natureRegCost', label: '自然量用户数据', align: 'center', width: 70, default: 5, sorter: true }
]
},
{
label: '总用户数据',
data: [
{ title: '注册人数', dataIndex: 'regNum', label: '总用户数据', align: 'center', width: 70, sorter: true },
{ title: '注册成本', dataIndex: 'regCost', label: '总用户数据', align: 'center', width: 70, sorter: true }
]
},
{
label: '买量付费数据',
data: [
{ title: '买量首日新用户充值次数', dataIndex: 'buyFirstNewUserAmountCount', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{ title: '买量首日新用户充值人数', dataIndex: 'buyFirstNewUserAmountNum', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{
title: '买量首日新用户充值金额', dataIndex: 'buyFirstNewUserAmount', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '买量老用户充值次数', dataIndex: 'buyOldUserCount', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{ title: '买量老用户充值人数', dataIndex: 'buyOldUserNum', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{
title: '买量老用户充值金额', dataIndex: 'buyOldUserAmount', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '买量账面充值次数', dataIndex: 'buyAmountCount', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{ title: '买量账面充值人数', dataIndex: 'buyAmountNum', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{
title: '买量账面充值金额', dataIndex: 'buyAmount', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '买量新用户累计充值次数', dataIndex: 'buyNewUserTotalAmountCount', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{ title: '买量新用户累计充值人数', dataIndex: 'buyNewUserTotalAmountNum', label: '买量付费数据', align: 'center', width: 70, sorter: true },
{
title: '买量新用户累计充值金额', dataIndex: 'buyNewUserTotalAmount', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量首日ROI', dataIndex: 'buyFirstRoi', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量总ROI', dataIndex: 'buyTotalRoi', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量首日付费率', dataIndex: 'buyFirstAmountRate', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量至今付费率', tips: '买量至今付费率=新用户累计充值人数/注册人数', dataIndex: 'buyTodayAmountRate', label: '买量付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量新用户付费比', dataIndex: 'buyNewUserRate', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量首日客单价', dataIndex: 'buyFirstAvgAmount', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量首日充值成本', dataIndex: 'buyFirstNewUserRechargeCost', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量总充值成本', dataIndex: 'buyTotalRechargeCost', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量至今客单价', tips: '买量至今客单价=新用户累计充值金额/新用户累计充值次数', dataIndex: 'buyTodayAvgAmount', label: '买量付费数据', align: 'center', width: 80, sorter: true,
render: (a: string) =>
},
{
title: '买量账面客单价', dataIndex: 'buyAvgAmount', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量复充率', tips: '买量复充率=新用户复充人数/新用户累计充值人数(新用户复充人数为累计充值次数n≥2)', dataIndex: 'buyUserAgainRate', label: '买量付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量单日付费100+人数', dataIndex: 'buyHundredUserNum', label: '买量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '买量单日付费100+成本', dataIndex: 'buyHundredUserNumCost', label: '买量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '买量首日创角人数', dataIndex: 'buyFirstRoleNum', label: '买量付费数据', align: 'center', width: 80, sorter: true,
render: (a: string) =>
},
{
title: '买量创角人数', dataIndex: 'buyRoleNum', label: '买量付费数据', align: 'center', width: 75, sorter: true,
render: (a: string) =>
},
{
title: '买量新用户累计创角人数', dataIndex: 'buyNewUserTotalRoleNum', label: '买量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '买量首日创角人数成本', dataIndex: 'buyFirstRoleNumCost', label: '买量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '买量创角人数成本', dataIndex: 'buyRoleNumCost', label: '买量付费数据', align: 'center', width: 75, sorter: true,
render: (a: string) =>
},
{
title: '买量新用户累计创角人数成本', dataIndex: 'buyNewUserTotalRoleNumCost', label: '买量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '买量首日创角率', dataIndex: 'buyFirstRoleNumRate', label: '买量付费数据', align: 'center', width: 75, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量创角率', dataIndex: 'buyRoleNumRate', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量新用户累计创角率', dataIndex: 'buyNewUserTotalRoleNumRate', label: '买量付费数据', align: 'center', width: 90, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '买量新增注册ARPPU', dataIndex: 'buyRegUserArpu', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量首日付费ARPPU', dataIndex: 'buyFirstAmountArpu', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量至今付费ARPPU', dataIndex: 'buyTodayAmountArpu', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '买量账面ARPPU', dataIndex: 'buyAmountArpu', label: '买量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
]
},
{
label: '自然量付费数据',
data: [
{ title: '自然量首日新用户充值次数', dataIndex: 'natureFirstNewUserAmountCount', label: '自然量付费数据', align: 'center', width: 70, sorter: true },
{ title: '自然量首日新用户充值人数', dataIndex: 'natureFirstNewUserAmountNum', label: '自然量付费数据', align: 'center', width: 70, default: 6, sorter: true },
{
title: '自然量首日新用户充值金额', dataIndex: 'natureFirstNewUserAmount', label: '自然量付费数据', align: 'center', width: 70, default: 7, sorter: true,
render: (a: string) =>
},
{ title: '自然量老用户充值次数', dataIndex: 'natureOldUserCount', label: '自然量付费数据', align: 'center', width: 70, sorter: true },
{ title: '自然量老用户充值人数', dataIndex: 'natureOldUserNum', label: '自然量付费数据', align: 'center', width: 70, sorter: true },
{
title: '自然量老用户充值金额', dataIndex: 'natureOldUserAmount', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '自然量账面充值次数', dataIndex: 'natureAmountCount', label: '自然量付费数据', align: 'center', width: 70, sorter: true },
{ title: '自然量账面充值人数', dataIndex: 'natureAmountNum', label: '自然量付费数据', align: 'center', width: 70, sorter: true },
{
title: '自然量账面充值金额', dataIndex: 'natureAmount', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '自然量新用户累计充值次数', dataIndex: 'natureNewUserTotalAmountCount', label: '自然量付费数据', align: 'center', width: 70, sorter: true },
{ title: '自然量新用户累计充值人数', dataIndex: 'natureNewUserTotalAmountNum', label: '自然量付费数据', align: 'center', width: 70, default: 8, sorter: true },
{
title: '自然量新用户累计充值金额', dataIndex: 'natureNewUserTotalAmount', label: '自然量付费数据', align: 'center', width: 70, default: 9, sorter: true,
render: (a: string) =>
},
{
title: '自然量首日ROI', dataIndex: 'natureFirstRoi', label: '自然量付费数据', align: 'center', width: 70, sorter: true, default: 10,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量总ROI', dataIndex: 'natureTotalRoi', label: '自然量付费数据', align: 'center', width: 70, sorter: true, default: 11,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量首日付费率', dataIndex: 'natureFirstAmountRate', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量至今付费率', tips: '自然量至今付费率=新用户累计充值人数/注册人数', dataIndex: 'natureTodayAmountRate', label: '自然量付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量新用户付费比', dataIndex: 'natureNewUserRate', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量首日客单价', dataIndex: 'natureFirstAvgAmount', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '自然量首日充值成本', dataIndex: 'natureFirstNewUserRechargeCost', label: '自然量付费数据', align: 'center', width: 70, default: 12, sorter: true,
render: (a: string) =>
},
{
title: '自然量总充值成本', dataIndex: 'natureTotalRechargeCost', label: '自然量付费数据', align: 'center', width: 70, default: 13, sorter: true,
render: (a: string) =>
},
{
title: '自然量至今客单价', tips: '自然量至今客单价=新用户累计充值金额/新用户累计充值次数', dataIndex: 'natureTodayAvgAmount', label: '自然量付费数据', align: 'center', width: 80, sorter: true,
render: (a: string) =>
},
{
title: '自然量账面客单价', dataIndex: 'natureAvgAmount', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '自然量复充率', tips: '自然量复充率=新用户复充人数/新用户累计充值人数(新用户复充人数为累计充值次数n≥2)', dataIndex: 'natureUserAgainRate', label: '自然量付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量单日付费100+人数', dataIndex: 'natureHundredUserNum', label: '自然量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '自然量单日付费100+成本', dataIndex: 'natureHundredUserNumCost', label: '自然量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '自然量首日创角人数', dataIndex: 'natureFirstRoleNum', label: '自然量付费数据', align: 'center', width: 80, sorter: true,
},
{
title: '自然量创角人数', dataIndex: 'natureRoleNum', label: '自然量付费数据', align: 'center', width: 75, sorter: true,
render: (a: string) =>
},
{
title: '自然量新用户累计创角人数', dataIndex: 'natureNewUserTotalRoleNum', label: '自然量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '自然量首日创角人数成本', dataIndex: 'natureFirstRoleNumCost', label: '自然量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '自然量创角人数成本', dataIndex: 'natureRoleNumCost', label: '自然量付费数据', align: 'center', width: 85, sorter: true,
render: (a: string) =>
},
{
title: '自然量新用户累计创角人数成本', dataIndex: 'natureNewUserTotalRoleNumCost', label: '自然量付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '自然量首日创角率', dataIndex: 'natureFirstRoleNumRate', label: '自然量付费数据', align: 'center', width: 75, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量创角率', dataIndex: 'natureRoleNumRate', label: '自然量付费数据', align: 'center', width: 75, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量新用户累计创角率', dataIndex: 'natureNewUserTotalRoleNumRate', label: '自然量付费数据', align: 'center', width: 90, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '自然量新增注册ARPPU', dataIndex: 'natureRegUserArpu', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '自然量首日付费ARPPU', dataIndex: 'natureFirstAmountArpu', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '自然量至今付费ARPPU', dataIndex: 'natureTodayAmountArpu', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '自然量账面ARPPU', dataIndex: 'natureAmountArpu', label: '自然量付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
}
]
},
{
label: '总付费数据',
data: [
{ title: '总首日新用户充值次数', dataIndex: 'firstNewUserAmountCount', label: '总付费数据', align: 'center', width: 70, sorter: true },
{ title: '总首日新用户充值人数', dataIndex: 'firstNewUserAmountNum', label: '总付费数据', align: 'center', width: 70, sorter: true },
{
title: '总首日新用户充值金额', dataIndex: 'firstNewUserAmount', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '总老用户充值次数', dataIndex: 'oldUserCount', label: '总付费数据', align: 'center', width: 70, sorter: true },
{ title: '总老用户充值人数', dataIndex: 'oldUserNum', label: '总付费数据', align: 'center', width: 70, sorter: true },
{
title: '总老用户充值金额', dataIndex: 'oldUserAmount', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '总账面充值次数', dataIndex: 'amountCount', label: '总付费数据', align: 'center', width: 70, sorter: true },
{ title: '总账面充值人数', dataIndex: 'amountNum', label: '总付费数据', align: 'center', width: 70, sorter: true },
{
title: '总账面充值金额', dataIndex: 'amount', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{ title: '总新用户累计充值次数', dataIndex: 'newUserTotalAmountCount', label: '总付费数据', align: 'center', width: 70, sorter: true },
{ title: '总新用户累计充值人数', dataIndex: 'newUserTotalAmountNum', label: '总付费数据', align: 'center', width: 70, sorter: true },
{
title: '总新用户累计充值金额', dataIndex: 'newUserTotalAmount', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总首日ROI', dataIndex: 'firstRoi', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总总ROI', dataIndex: 'totalRoi', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总首日付费率', dataIndex: 'firstAmountRate', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总至今付费率', tips: '至今付费率(总)=新用户累计充值人数/注册人数', dataIndex: 'todayAmountRate', label: '总付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总新用户付费比', dataIndex: 'newUserRate', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总首日客单价', dataIndex: 'firstAvgAmount', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总首日充值成本', dataIndex: 'firstNewUserRechargeCost', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总总充值成本', dataIndex: 'totalRechargeCost', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总至今客单价', tips: '至今客单价(总)=新用户累计充值金额/新用户累计充值次数', dataIndex: 'todayAvgAmount', label: '总付费数据', align: 'center', width: 80, sorter: true,
render: (a: string) =>
},
{
title: '总账面客单价', dataIndex: 'avgAmount', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总复充率', tips: '复充率(总)=新用户复充人数/新用户累计充值人数(新用户复充人数为累计充值次数n≥2)', dataIndex: 'userAgainRate', label: '总付费数据', align: 'center', width: 80, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总单日付费100+人数', dataIndex: 'hundredUserNum', label: '总付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '总单日付费100+成本', dataIndex: 'hundredUserNumCost', label: '总付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '总首日创角人数', dataIndex: 'firstRoleNum', label: '总付费数据', align: 'center', width: 80, sorter: true,
render: (a: string) =>
},
{
title: '总创角人数', dataIndex: 'roleNum', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总新用户累计创角人数', dataIndex: 'newUserTotalRoleNum', label: '总付费数据', align: 'center', width: 85, sorter: true,
render: (a: string) =>
},
{
title: '总首日创角人数成本', dataIndex: 'firstRoleNumCost', label: '总付费数据', align: 'center', width: 80, sorter: true,
render: (a: string) =>
},
{
title: '总创角人数成本', dataIndex: 'roleNumCost', label: '总付费数据', align: 'center', width: 75, sorter: true,
render: (a: string) =>
},
{
title: '总新用户累计创角人数成本', dataIndex: 'newUserTotalRoleNumCost', label: '总付费数据', align: 'center', width: 90, sorter: true,
render: (a: string) =>
},
{
title: '总首日创角率', dataIndex: 'firstRoleNumRate', label: '总付费数据', align: 'center', width: 75, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总创角率', dataIndex: 'roleNumRate', label: '总付费数据', align: 'center', width: 75, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总新用户累计创角率', dataIndex: 'newUserTotalRoleNumRate', label: '总付费数据', align: 'center', width: 90, sorter: true,
render: (a: number) => = 1 ? { color: 'red' } : { color: '#0f990f' }} suffix="%" />
},
{
title: '总新增注册ARPPU', dataIndex: 'regUserArpu', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总首日付费ARPPU', dataIndex: 'firstAmountArpu', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总至今付费ARPPU', dataIndex: 'todayAmountArpu', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
},
{
title: '总账面ARPPU', dataIndex: 'amountArpu', label: '总付费数据', align: 'center', width: 70, sorter: true,
render: (a: string) =>
}
]
},
{
fieldSHow: {
label: '付费趋势区间字段展示',
saveField: 'date_field',
defaultValue: [ // 默认展示字段
{ label: '充值人数', key: 'rechargeUserCount', type: '付费趋势' },
{ label: '充值金额', key: 'rechargeMoney', type: '付费趋势' },
{ label: '增', key: 'increase', type: '付费趋势' },
{ label: '回', key: 'back', type: '付费趋势' },
{ label: '倍', key: 'multiples', type: '付费趋势' },
],
data: [
{
label: '付费趋势',
data: [
{ label: '充值人数', key: 'rechargeUserCount', type: '付费趋势' },
{ label: '充值金额', key: 'rechargeMoney', type: '付费趋势' },
{ label: '增', key: 'increase', type: '付费趋势' },
{ label: '回', key: 'back', type: '付费趋势' },
{ label: '倍', key: 'multiples', type: '付费趋势' },
]
}
]
},
label: '买量付费趋势',
data: [
...buyC,
...buyM,
{
title: "总(买)",
dataIndex: "totalBuy",
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?.buyAmountSumTrend) {
data = b?.buyAmountSumTrend
return
{keyS?.includes('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}]
},
{
label: '自然量付费趋势',
data: [
...natureC,
...natureM,
{
title: "总(自)",
dataIndex: "totalNature",
label: "自然量付费趋势",
align: "center",
width: 110,
default: 113,
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?.natureAmountSumTrend) {
data = b?.natureAmountSumTrend
return
{keyS?.includes('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}]
},
{
label: '总付费趋势',
data: [
...zC,
...zM,
{
title: "总(总)",
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?.amountSumTrend) {
data = b?.amountSumTrend
return
{keyS?.includes('rechargeUserCount') && 充人:{data?.rechargeUserCount}}
{keyS?.includes('rechargeMoney') && 充金:}
{keyS?.includes('increase') && 增:{(data?.increase * 100)?.toFixed(2)}%}
{keyS?.includes('back') && 回:{(data?.back * 100)?.toFixed(2)}%}
{keyS?.includes('multiples') && 倍:{data?.multiples?.toFixed(2)}}
}
return '--'
}
}
return '--'
},
}]
},
{
label: '操作',
data: [
{
title: '操作',
dataIndex: 'cz',
label: '操作',
default: 114,
align: 'center',
width: 75,
render: (a: number, b: any) => {
if (b?.costDate === '总计') {
return '--'
}
return rechargeTrendHandle(b)}>复充趋势
},
}
]
}
]
}
export default columnsNature12