kknongchang_2506/app/Module/UrsPromotion/AdminControllers/Metrics/UrsDirectRankingCard.php

<?php

namespace App\Module\UrsPromotion\AdminControllers\Metrics;

use App\Module\UrsPromotion\Models\UrsUserReferral;
use UCore\DcatAdmin\Metrics\Examples\Ranking;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

/**
 * URS直推排名卡片
 * 显示直推用户数量排名前10名
 */
class UrsDirectRankingCard extends Ranking
{
    /**
     * 初始化卡片内容
     */
    protected function init()
    {
        parent::init();
        
        $this->title('直推排行榜');
    }

    /**
     * 处理请求
     *
     * @param Request $request
     * @return mixed|void
     */
    public function handle(Request $request)
    {
        $data = $this->getDirectRankingData();
        
        // 卡片内容
        $this->withContent($data);
    }

    /**
     * 获取直推排名数据
     *
     * @return array
     */
    protected function getDirectRankingData(): array
    {
        // 查询直推排名数据
        $rankings = UrsUserReferral::select([
                'urs_promotion_user_referrals.urs_referrer_id',
                'urs_promotion_user_referrals.referrer_id',
                'users.username',
                DB::raw('COUNT(*) as direct_count')
            ])
            ->leftJoin('users', 'urs_promotion_user_referrals.referrer_id', '=', 'users.id')
            ->where('urs_promotion_user_referrals.status', UrsUserReferral::STATUS_VALID)
            ->groupBy('urs_promotion_user_referrals.urs_referrer_id', 'urs_promotion_user_referrals.referrer_id', 'users.username')
            ->orderBy('direct_count', 'desc')
            ->limit(10)
            ->get();

        $result = [];
        foreach ($rankings as $index => $ranking) {
            $username = $ranking->username ?: 'URS用户' . $ranking->urs_referrer_id;
            $result[] = [
                'rank' => $index + 1,
                'title' => $username,
                'number' => $ranking->direct_count . ' 人',
            ];
        }

        // 如果没有数据，返回空排名提示
        if (empty($result)) {
            $result[] = [
                'rank' => '-',
                'title' => '暂无直推数据',
                'number' => '0 人',
            ];
        }

        return $result;
    }
}