kknongchang_2506/app/Module/UrsPromotion/AdminControllers/Metrics/UrsThirdRankingCard.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 UrsThirdRankingCard extends Ranking
{
    /**
     * 初始化卡片内容
     */
    protected function init()
    {
        parent::init();
        
        $this->title('三推排行榜');
    }

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

    /**
     * 获取三推排名数据
     * 统计每个推荐人的三级推荐数量
     *
     * @return array
     */
    protected function getThirdRankingData(): array
    {
        // 使用子查询统计三推数量
        $fullTableName = DB::getTablePrefix() . (new UrsUserReferral())->getTable();
        $rankings = UrsUserReferral::select([
                'urs_referrer_id',
                'referrer_id',
                'users.username',
                DB::raw('(
                    SELECT COUNT(*)
                    FROM ' . $fullTableName . ' r2
                    JOIN ' . $fullTableName . ' r3 ON r2.urs_user_id = r3.urs_referrer_id
                    WHERE r2.urs_referrer_id = ' . $fullTableName . '.urs_user_id
                    AND r2.status = 1 AND r3.status = 1
                ) as third_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', 'urs_promotion_user_referrals.urs_user_id', 'users.username')
            ->orderBy('third_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->third_count . ' 人',
            ];
        }

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

        return $result;
    }
}