new_sdk_wu/www/new_sdk/application/admin/controller/RetainePlatform.php

<?php
/**
 * 平台数据统计 - 平台
 */

namespace app\admin\controller;


use app\service\RetaineService;
use think\Controller;

class RetainePlatform extends Controller
{
    /**
     * 玩家总数
     * @return string
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function reg_total()
    {
        $day = input('day', '');
        if (!$day) {
            $day = date('Y-m-d', strtotime('-1 day'));
        }

        $retaineService = new RetaineService();
        $list = $retaineService->regNumV2($day, 0,1, 'reg_total');
        $retaineService->insertOrUpdatePlatform($list, 1, $day, 'reg_total');
        return 'ok';
    }

    /**
     * 留存表-游戏-新增玩家
     * @return string
     */
    public function reg_num()
    {
        $day = input('day', '');
        if (!$day) {
            $day = date('Y-m-d', strtotime('-1 day'));
        }

        $retaineService = new RetaineService();
        // 获取当天注册账号
        // $mebmers = $retaineService->getMembers($day);
        // $list = $retaineService->regNumNew($day, $mebmers,0,0,1);

        $list = $retaineService->regNumV2($day, 0,1, 'reg_num');
        $retaineService->insertOrUpdatePlatformv2($list, 1, $day, 'reg_num');
        return 'ok';
    }

    /**
     * 留存表-游戏-新增角色
     * @return string
     */
    public function role_num()
    {
        $day = input('day', '');
        if (!$day) {
            $day = date('Y-m-d', strtotime('-1 day'));
        }

        $retaineService = new RetaineService();
        //当天新增角色
        $list = $retaineService->getFirstRoleMember($day,0,0,1);
        $retaineService->insertOrUpdatePlatform($list, 1, $day, 'role_num');
        return 'ok';
    }

    /**
     * 留存表-游戏-活跃玩家
     * @return string
     */
    public function act_num()
    {

        $day = input('day', '');
        if (!$day) {
            $day = date('Y-m-d', strtotime('-1 day'));
        }

        $retaineService = new RetaineService();

        //当天活跃玩家
        // $list = $retaineService->activeMember($day, 'act_num',0,0, [],1);
        $list = $retaineService->activeMemberV2($day, 'act_num',0,[], 1);

        $retaineService->insertOrUpdatePlatform($list, 1, $day, 'act_num');

        return 'ok';

    }

    /**
     * 留存表-游戏-充值金额-付费人数
     * @return string
     */
    public function recharge_num()
    {

        $day = input('day', '');
        if (!$day) {
            $day = date('Y-m-d', strtotime('-1 day'));
        }

        $retaineService = new RetaineService();

        //充值金额
        $list = $retaineService->rechargeMoney($day,0,0,1);
        $retaineService->insertOrUpdatePlatform($list, 1, $day, 'recharge_num');
        $retaineService->insertOrUpdatePlatform($list, 1, $day, 'pay_num');

        return 'ok';

    }

    private function getTime($day, $num)
    {
        return date('Y-m-d', strtotime($day) - 86400 * $num);
    }
}