dms-web/src/views/v1/gameLog/totalMonth/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="os">
            <a-select v-model="searchForm.os" :options="osOptions" placeholder="请选择系统" />
          </a-form-item>
        </a-col> -->
        <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" />
          </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="请输入渠道名称" />
          </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" multiple />
          </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" placeholder="请选择媒体类型" />
          </a-form-item>
        </a-col>
      </template>

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

<script setup>
import { onMounted, ref, reactive } from 'vue'
import api from '../../api/gameLog/analyse'
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 osOptions = ref([
  {
    label: 'IOS',
    value: '1',
  },
  {
    label: 'Android',
    value: '2',
  },
  {
    label: '小程序',
    value: '3',
  },
])

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

// SaTable 基础配置
const options = reactive({
  api: api.getDataOverviewByMonth,
  pk: 'mdate',
  showSort: false,
  showSummary: true,
  operationColumn: false,
  summary: [
    {
      action: 'totalRow',
      dataIndex: 'mdate',
    },
    {
      action: 'totalRow',
      dataIndex: 'login_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'pay_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'pay_num',
    },
    {
      action: 'totalRow',
      dataIndex: 'pay_rate',
    },
    {
      action: 'totalRow',
      dataIndex: 'arpu',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_login_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'act_rate',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_pay_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_pay_num',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_pay_rate',
    },
    {
      action: 'totalRow',
      dataIndex: 'reg_arpu',
    },
    {
      action: 'totalRow',
      dataIndex: 'old_login_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'old_pay_total',
    },
    {
      action: 'totalRow',
      dataIndex: 'old_pay_num',
    },
    {
      action: 'totalRow',
      dataIndex: 'old_pay_rate',
    },
    {
      action: 'totalRow',
      dataIndex: 'old_arpu',
    },
  ],
})

// SaTable 列配置
const columns = reactive([
  { title: '日期', dataIndex: 'mdate', width: 120, fixed: 'left' },
  {
    title: '总用户',
    children: [
      {
        title: 'DAU',
        dataIndex: 'login_total',
        width: 90,
      },
      {
        title: '付费金额',
        dataIndex: 'pay_total',
        width: 90,
      },
      {
        title: '付费人数',
        dataIndex: 'pay_num',
        width: 90,
      },
      {
        title: '付费率',
        dataIndex: 'pay_rate',
        width: 90,
      },
      {
        title: 'ARPU',
        dataIndex: 'arpu',
        width: 90,
      },
    ],
  },
  {
    title: '新用户',
    children: [
      {
        title: '注册数',
        dataIndex: 'reg_total',
        width: 90,
      },
      {
        title: '登录',
        dataIndex: 'reg_login_total',
        width: 90,
      },
      {
        title: '次留率',
        dataIndex: 'act_rate',
        width: 90,
      },
      {
        title: '付费金额',
        dataIndex: 'reg_pay_total',
        width: 90,
      },
      {
        title: '付费人数',
        dataIndex: 'reg_pay_num',
        width: 90,
      },
      {
        title: '付费率',
        dataIndex: 'reg_pay_rate',
        width: 90,
      },
      {
        title: 'ARPU',
        dataIndex: 'reg_arpu',
        width: 90,
      },
    ],
  },
  {
    title: '老用户',
    children: [
      {
        title: '登录',
        dataIndex: 'old_login_total',
        width: 90,
      },
      {
        title: '付费金额',
        dataIndex: 'old_pay_total',
        width: 90,
      },
      {
        title: '付费人数',
        dataIndex: 'old_pay_num',
        width: 90,
      },
      {
        title: '付费率',
        dataIndex: 'old_pay_rate',
        width: 90,
      },
      {
        title: 'ARPU',
        dataIndex: 'old_arpu',
        width: 90,
      },
    ],
  },
])

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

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

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