nongchang
/
kknongchang_2506


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
							<?php

namespace App\Module\UrsPromotion\AdminControllers\Metrics;

use App\Module\UrsPromotion\Models\UrsUserMapping;
use App\Module\UrsPromotion\Models\UrsUserReferral;
use App\Module\User\Models\User;
use Dcat\Admin\Widgets\Metrics\Card;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

/**
 * URS推广用户排名卡片
 * 显示直推、间推、三推、团队推广用户数量排名
 */
class UrsPromotionRankingCard extends Card
{
    /**
     * 卡片高度
     */
    protected $height = 400;
    
    /**
     * 卡片标题
     */
    protected $title = 'URS推广排行榜';

    /**
     * 初始化卡片
     */
    public function __construct()
    {
        if ($options = $this->defaultChartOptions()) {
            $this->chartOptions = $options;
        }

        $this->init();
    }

    /**
     * 处理请求
     *
     * @param Request $request
     * @return mixed|void
     */
    public function handle(Request $request)
    {
        $rankings = $this->getPromotionRankings();
        $this->withContent($rankings);
    }

    /**
     * 获取推广排名数据
     *
     * @return array
     */
    private function getPromotionRankings(): array
    {
        // 获取直推排名前10
        $directRanking = $this->getDirectRanking();
        
        // 获取间推排名前10
        $indirectRanking = $this->getIndirectRanking();
        
        // 获取三推排名前10
        $thirdRanking = $this->getThirdRanking();
        
        // 获取团队总数排名前10
        $teamRanking = $this->getTeamRanking();

        return [
            'direct' => $directRanking,
            'indirect' => $indirectRanking,
            'third' => $thirdRanking,
            'team' => $teamRanking,
        ];
    }

    /**
     * 获取直推排名
     * 统计每个推荐人的直接推荐数量
     *
     * @return array
     */
    private function getDirectRanking(): array
    {
        return UrsUserReferral::select([
                'urs_promotion_user_referrals.urs_referrer_id',
                'urs_promotion_user_referrals.referrer_id',
                'users.username as nickname',
                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()
            ->toArray();
    }

    /**
     * 获取间推排名
     * 统计每个推荐人的间接推荐数量（二级推荐）
     *
     * @return array
     */
    private function getIndirectRanking(): array
    {
        // 暂时返回空数组，间推统计比较复杂
        return [];
    }

    /**
     * 获取三推排名
     * 统计每个推荐人的三级推荐数量
     *
     * @return array
     */
    private function getThirdRanking(): array
    {
        // 暂时返回空数组，三推统计比较复杂
        return [];
    }

    /**
     * 获取团队总数排名
     * 统计每个推荐人的团队总人数（直推+间推+三推）
     *
     * @return array
     */
    private function getTeamRanking(): array
    {
        // 团队排名与直推排名相同，统计直推数量
        return $this->getDirectRanking();
    }

    /**
     * 设置卡片内容
     *
     * @param array $rankings 排名数据
     * @return $this
     */
    public function withContent(array $rankings)
    {
        $directHtml = $this->buildRankingHtml($rankings['direct'], 'direct_count', '直推');
        $indirectHtml = $this->buildRankingHtml($rankings['indirect'], 'indirect_count', '间推');
        $thirdHtml = $this->buildRankingHtml($rankings['third'], 'third_count', '三推');
        $teamHtml = $this->buildRankingHtml($rankings['team'], 'team_count', '团队');

        return $this->content(
            <<<HTML
<div class="row">
    <div class="col-6">
        <h6 class="text-primary">直推排行榜</h6>
        {$directHtml}
    </div>
    <div class="col-6">
        <h6 class="text-success">间推排行榜</h6>
        {$indirectHtml}
    </div>
</div>
<div class="row mt-3">
    <div class="col-6">
        <h6 class="text-warning">三推排行榜</h6>
        {$thirdHtml}
    </div>
    <div class="col-6">
        <h6 class="text-info">团队排行榜</h6>
        {$teamHtml}
    </div>
</div>
HTML
        );
    }

    /**
     * 构建排名HTML
     *
     * @param array $data 排名数据
     * @param string $countField 数量字段
     * @param string $type 类型名称
     * @return string
     */
    private function buildRankingHtml(array $data, string $countField, string $type): string
    {
        if (empty($data)) {
            return '<small class="text-muted">暂无数据</small>';
        }

        $html = '<div class="ranking-list">';
        foreach ($data as $index => $item) {
            $rank = $index + 1;
            // 处理数组和对象两种数据格式
            $itemArray = is_object($item) ? (array)$item : $item;
            $nickname = $itemArray['nickname'] ?? 'URS用户' . ($itemArray['urs_referrer_id'] ?? $itemArray['urs_user_id'] ?? '');
            $count = $itemArray[$countField] ?? 0;

            $badgeClass = $rank <= 3 ? 'badge-warning' : 'badge-secondary';

            $html .= <<<HTML
<div class="d-flex justify-content-between align-items-center mb-1">
    <span class="badge {$badgeClass}">{$rank}</span>
    <span class="text-truncate mx-2" style="max-width: 80px;" title="{$nickname}">{$nickname}</span>
    <span class="font-weight-bold">{$count}</span>
</div>
HTML;
        }
        $html .= '</div>';

        return $html;
    }
}