@extends('layouts.main')
@section('content')
@php
use App\Models\User;

if (!empty($_GET['search'])) 
{
   $neenoe = request()->query('search');
   
   $users = User::withCount('referrals')
    ->having('referrals_count', '>', 5)
    ->where('status', 'active')->where('name','like','%'.$neenoe.'%')->orWhere('email','like','%'.$neenoe.'%')
    ->orderByDesc('referrals_count')
    ->get();

}else 
{
    $users =  User::withCount('referrals')
    ->having('referrals_count', '>', 5)
    ->orderByDesc('referrals_count')
    ->get();
    
}


@endphp

    <div class="col-lg-7">
        <div class="page-header-title">
            <div class="d-inline">
                <div class="card-header">
                    <h5>List of Top Team Builders</h5>
                </div>
            </div>
        </div>
    </div>


    <div class="col-xl-12 col-md-12">
        <!-- DOM/Jquery table start -->
        <div class="card">
            <div class="card-block">
                <div class="table-responsive dt-responsive">
                    <table class="table table-hover table-borderless">
                        <thead>
                            <tr>
                                <th>Name</th>
                                <th>Users Invited</th>
                                <th>Username</th>
                                <th>Phone</th>
                                <th>Referrered by</th>
                                <th>Referer Phone</th>
                                <th>Commision Earned</th>
                            </tr>
                        </thead>
                        <tbody>

                         @if ($users->count() > 0)
                            @foreach ($users as $user)
                            <tr>
                                <td>{{ $user->name }}
                                </td>
                                <td>