merchant_admin/app/controller/RankList.php

<?php
declare (strict_types = 1);

namespace app\controller;

use app\BaseController;
use app\model\GameStatisModel;
use app\model\GameBetGameModel;
use app\common\CommonUtils;
use app\model\GameModel;
use think\facade\Request;

class RankList extends BaseController
{    
    /**
     * 赢钱榜
     */
    public function WinAmount()
    {
        $userInfo = $this->request->userInfo;
        
        // 获取查询参数
        $page = Request::get('page', 1, 'intval');
        $limit = Request::get('limit', 10, 'intval');
        $filters['date'] = Request::get('date', '', 'trim');
        
        try {
            // 获取赢钱榜数据
            $result = GameBetGameModel::getWinRanking(
                $userInfo['merchant_id'],
                $page, 
                $limit,
                $filters
            );
            
            // 格式化金额数据
            foreach ($result['list'] as &$item) {
                $item['total_win'] = CommonUtils::convertBalance($item['total_win'], false);
                $item['total_bet'] = CommonUtils::convertBalance($item['total_bet'], false);
                $item['balance'] = CommonUtils::convertBalance($item['balance'], false);
            }
            
            return json_success($result, '获取成功');
        } catch (\Exception $e) {
            return json_error([], '获取赢钱榜失败：' . $e->getMessage());
        }
    }  
    
    /**
     * 输钱榜
     */
    public function LoseAmount() {
        $userInfo = $this->request->userInfo;
        
        // 获取查询参数
        $page = Request::get('page', 1, 'intval');
        $limit = Request::get('limit', 10, 'intval');
        $filters['date'] = Request::get('date', '', 'trim');
        
        try {
            // 获取输钱榜数据
            $result = GameBetGameModel::getLoseRanking(
                $userInfo['merchant_id'],
                $page, 
                $limit,
                $filters
            );
            
            // 格式化金额数据
            foreach ($result['list'] as &$item) {
                $item['total_lose'] = CommonUtils::convertBalance($item['total_lose'], false);
                $item['total_bet'] = CommonUtils::convertBalance($item['total_bet'], false);
                $item['balance'] = CommonUtils::convertBalance($item['balance'], false);

            }
            
            return json_success($result, '获取成功');
        } catch (\Exception $e) {
            return json_error([], '获取输钱榜失败：' . $e->getMessage());
        }
    }

    /**
     * 注单榜
     */
    public function BetAmount() {
        $userInfo = $this->request->userInfo;
        
        // 获取查询参数
        $page = Request::get('page', 1, 'intval');
        $limit = Request::get('limit', 10, 'intval');

        // 筛选条件
        $filters = [
            'start_time' => Request::get('start_time', date('Y-m-d', strtotime('-7 days')), 'trim'),
            'end_time' => Request::get('end_time', date('Y-m-d'), 'trim'),
            'game_id' => Request::get('game_id', '', 'trim'),
        ];
        
        try {
            // 获取注单金额榜数据
            $result = GameBetGameModel::getBetAmountRanking(
                $userInfo['merchant_id'],
                $page, 
                $limit,
                $filters
            );
            
            // 格式化金额数据
            foreach ($result['list'] as &$item) {
                $item['total_bet_amount'] = CommonUtils::convertBalance($item['total_bet_amount'], false);
                $item['total_profit'] = CommonUtils::convertBalance($item['total_profit'], false);
                $item['max_bet'] = CommonUtils::convertBalance($item['max_bet'], false);
                $item['avg_bet'] = CommonUtils::convertBalance($item['avg_bet'], false);
            }
            
            return json_success($result, '获取成功');
        } catch (\Exception $e) {
            return json_error([], '获取注单金额榜失败：' . $e->getMessage());
        }
    }
    
}