dms-web/src/views/v1/gameLog/ltv/index.vue

<template>
  <div class="ma-content-block">
    <sa-table ref="crudRef" :options="options" :columns="columns" :searchForm="searchForm">
      <!-- 搜索区 tableSearch -->
      <template #tableSearch>
        <a-col :sm="8" :xs="24">
          <a-form-item label="游戏" field="game_id">
            <game-select v-model="searchForm.game_id" multiple />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="注册日期" field="reg_date">
            <a-range-picker class="w-full" v-model="searchForm.reg_date" :show-time="false" mode="date" />
          </a-form-item>
        </a-col>

        <a-col :sm="8" :xs="24">
          <a-form-item label="渠道ID" field="agent_id">
            <a-input v-model="searchForm.agent_id" placeholder="请输入渠道ID" allow-clear />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="渠道名称" field="agent_name">
            <a-input v-model="searchForm.agent_name" placeholder="请输入渠道名称" allow-clear />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="广告位ID" field="site_id">
            <a-input v-model="searchForm.site_id" placeholder="请输入广告位ID" allow-clear />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="广告名称" field="site_name">
            <a-input v-model="searchForm.site_name" placeholder="请输入广告名称" allow-clear />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="负责人" field="auth_id">
            <auth-select v-model="searchForm.auth_id" />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="媒体类型" field="media_id">
            <media-select v-model="searchForm.media_id" />
          </a-form-item>
        </a-col>
        <a-col :sm="8" :xs="24">
          <a-form-item label="展示类型" field="data_type">
            <a-select v-model="searchForm.data_type" placeholder="请选择展示类型" :allow-clear="false">
              <a-option value="recovery">回本率</a-option>
              <a-option value="remount">实际回本率</a-option>
              <a-option value="ltv">LTV</a-option>
              <a-option value="ltvbs">LTV倍数</a-option>
              <a-option value="pay_num">付费人数</a-option>
              <a-option value="pay_total">付费总额</a-option>
              <a-option value="pay_rate">付费率</a-option>
              <a-option value="arpu"> 付费ARPU </a-option>
            </a-select>
          </a-form-item>
        </a-col>
      </template>

      <!-- Table 自定义渲染 -->
    </sa-table>
  </div>
</template>

<script setup>
import { onMounted, ref, reactive } from 'vue'
import api from '../../api/gameLog/channelAnalysis'
import dayjs from 'dayjs'
import GameSelect from '@/components/game-select/index.vue'
import MediaSelect from '@/components/media-select/index.vue'

import AuthSelect from '@/components/auth-select/index.vue'

// 引用定义
const crudRef = ref()
const gameList = ref([])

// 搜索表单
const searchForm = ref({
  game_id: '',
  media_id: '',
  auth_id: '',
  agent_id: '',
  agent_name: '',
  site_name: '',
  site_id: '',
  reg_date: [],
  data_type: 'recovery',
})

// SaTable 基础配置
const options = reactive({
  api: api.getLtvDataList,
  pk: 'tdate',
  rowSelection: { showCheckedAll: true },
  showSort: false,
  showSummary: true,
  summary: [
    {
      action: 'totalRow',
      dataIndex: 'tdate',
    },
    {
      suffixText: '元',
      action: 'totalRow',
      dataIndex: 'cost',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_total',
    },

    {
      action: 'totalRow',
      dataIndex: 'reg_cost',
    },
    {
      action: 'totalRow',
      dataIndex: 'd0',
    },
    {
      action: 'totalRow',
      dataIndex: 'd1',
    },
    {
      action: 'totalRow',
      dataIndex: 'd2',
    },
    {
      action: 'totalRow',
      dataIndex: 'd3',
    },
    {
      action: 'totalRow',
      dataIndex: 'd4',
    },
    {
      action: 'totalRow',
      dataIndex: 'd5',
    },
    {
      action: 'totalRow',
      dataIndex: 'd6',
    },
    {
      action: 'totalRow',
      dataIndex: 'd7',
    },
    {
      action: 'totalRow',
      dataIndex: 'd8',
    },
    {
      action: 'totalRow',
      dataIndex: 'd9',
    },
    {
      action: 'totalRow',
      dataIndex: 'd10',
    },
    {
      action: 'totalRow',
      dataIndex: 'd11',
    },
    {
      action: 'totalRow',
      dataIndex: 'd12',
    },
    {
      action: 'totalRow',
      dataIndex: 'd13',
    },
    {
      action: 'totalRow',
      dataIndex: 'd14',
    },
    {
      action: 'totalRow',
      dataIndex: 'd15',
    },
    {
      action: 'totalRow',
      dataIndex: 'd16',
    },
    {
      action: 'totalRow',
      dataIndex: 'd17',
    },
    {
      action: 'totalRow',
      dataIndex: 'd18',
    },
    {
      action: 'totalRow',
      dataIndex: 'd19',
    },
    {
      action: 'totalRow',
      dataIndex: 'd20',
    },
    {
      action: 'totalRow',
      dataIndex: 'd21',
    },
    {
      action: 'totalRow',
      dataIndex: 'd22',
    },
    {
      action: 'totalRow',
      dataIndex: 'd23',
    },
    {
      action: 'totalRow',
      dataIndex: 'd24',
    },
    {
      action: 'totalRow',
      dataIndex: 'd25',
    },
    {
      action: 'totalRow',
      dataIndex: 'd26',
    },
    {
      action: 'totalRow',
      dataIndex: 'd27',
    },
    {
      action: 'totalRow',
      dataIndex: 'd28',
    },
    {
      action: 'totalRow',
      dataIndex: 'd29',
    },
    {
      action: 'totalRow',
      dataIndex: 'd30',
    },
    {
      action: 'totalRow',
      dataIndex: 'd35',
    },
    {
      action: 'totalRow',
      dataIndex: 'd40',
    },
    {
      action: 'totalRow',
      dataIndex: 'd45',
    },
    {
      action: 'totalRow',
      dataIndex: 'd50',
    },
    {
      action: 'totalRow',
      dataIndex: 'd55',
    },
    {
      action: 'totalRow',
      dataIndex: 'd60',
    },
    {
      action: 'totalRow',
      dataIndex: 'd65',
    },
    {
      action: 'totalRow',
      dataIndex: 'd70',
    },
    {
      action: 'totalRow',
      dataIndex: 'd75',
    },
    {
      action: 'totalRow',
      dataIndex: 'd80',
    },
    {
      action: 'totalRow',
      dataIndex: 'd85',
    },
    {
      action: 'totalRow',
      dataIndex: 'd90',
    },
    {
      action: 'totalRow',
      dataIndex: 'd95',
    },
    {
      action: 'totalRow',
      dataIndex: 'd100',
    },
    {
      action: 'totalRow',
      dataIndex: 'd105',
    },
    {
      action: 'totalRow',
      dataIndex: 'd110',
    },
    {
      action: 'totalRow',
      dataIndex: 'd115',
    },
    {
      action: 'totalRow',
      dataIndex: 'd120',
    },
  ],

  operationColumn: false,
})

// SaTable 列配置
const columns = reactive([
  { title: '日期', dataIndex: 'tdate', width: 130, fixed: 'left' },
  { title: '消耗金额', dataIndex: 'cost', width: 100 },

  { title: '注册数', dataIndex: 'reg_total', width: 80 },
  { title: '注册成本', dataIndex: 'reg_cost', width: 100 },
  { title: '累计', dataIndex: 'd0', width: 80 },
  { title: '1', dataIndex: 'd1', width: 80 },
  { title: '2', dataIndex: 'd2', width: 80 },
  { title: '3', dataIndex: 'd3', width: 80 },
  { title: '4', dataIndex: 'd4', width: 80 },
  { title: '5', dataIndex: 'd5', width: 80 },
  { title: '6', dataIndex: 'd6', width: 80 },
  { title: '7', dataIndex: 'd7', width: 80 },
  { title: '8', dataIndex: 'd8', width: 80 },
  { title: '9', dataIndex: 'd9', width: 80 },
  { title: '10', dataIndex: 'd10', width: 80 },
  { title: '11', dataIndex: 'd11', width: 80 },
  { title: '12', dataIndex: 'd12', width: 80 },
  { title: '13', dataIndex: 'd13', width: 80 },
  { title: '14', dataIndex: 'd14', width: 80 },
  { title: '15', dataIndex: 'd15', width: 80 },
  { title: '16', dataIndex: 'd16', width: 80 },
  { title: '17', dataIndex: 'd17', width: 80 },
  { title: '18', dataIndex: 'd18', width: 80 },
  { title: '19', dataIndex: 'd19', width: 80 },
  { title: '20', dataIndex: 'd20', width: 80 },
  { title: '21', dataIndex: 'd21', width: 80 },
  { title: '22', dataIndex: 'd22', width: 80 },
  { title: '23', dataIndex: 'd23', width: 80 },
  { title: '24', dataIndex: 'd24', width: 80 },
  { title: '25', dataIndex: 'd25', width: 80 },
  { title: '26', dataIndex: 'd26', width: 80 },
  { title: '27', dataIndex: 'd27', width: 80 },
  { title: '28', dataIndex: 'd28', width: 80 },
  { title: '29', dataIndex: 'd29', width: 80 },
  { title: '30', dataIndex: 'd30', width: 80 },
  { title: '35', dataIndex: 'd35', width: 80 },
  { title: '40', dataIndex: 'd40', width: 80 },
  { title: '45', dataIndex: 'd45', width: 80 },
  { title: '50', dataIndex: 'd50', width: 80 },
  { title: '55', dataIndex: 'd55', width: 80 },
  { title: '60', dataIndex: 'd60', width: 80 },
  { title: '65', dataIndex: 'd65', width: 80 },
  { title: '70', dataIndex: 'd70', width: 80 },
  { title: '75', dataIndex: 'd75', width: 80 },
  { title: '80', dataIndex: 'd80', width: 80 },
  { title: '85', dataIndex: 'd85', width: 80 },
  { title: '90', dataIndex: 'd90', width: 80 },
  { title: '95', dataIndex: 'd95', width: 80 },
  { title: '100', dataIndex: 'd100', width: 80 },
  { title: '105', dataIndex: 'd105', width: 80 },
  { title: '110', dataIndex: 'd110', width: 80 },
  { title: '115', dataIndex: 'd115', width: 80 },
  { title: '120', dataIndex: 'd120', width: 80 },
])

// 页面数据初始化
const initPage = () => {
  searchForm.value.reg_date = [dayjs().format('YYYY-MM-DD'), dayjs().format('YYYY-MM-DD')]
}

// SaTable 数据请求
const refresh = async () => {
  crudRef.value?.refresh()
}

// 页面加载完成执行
onMounted(async () => {
  initPage()
  refresh()
})
</script>