@extends('layout.app')
@section('content')
    <div class="card">
        <div class="card-body">
            <div class="table-responsive">
                <table class="table">
                    <thead class="bg-gray-50 thead-dark">
                        <tr>
                            <th>Manager Name</th>
                            <th>POP Name</th>
                            <th>Active User</th>
                            <th>Expire User</th>
                            <th>Disable User</th>
                            <th>Deactive User</th>
                            <th>Total Without Close</th>
                            <th>Close User</th>
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $totalActive = 0;
                            $totalExpire = 0;
                            $totalDisable = 0;
                            $totalDeactive = 0;
                            $totalWithoutClose = 0;
                            $totalClose = 0;
                            $total = 0;
                        @endphp
                        @foreach ($pops as $pop)
                        <tr>
                            <td>{{ $pop->reseller->name }}</td>
                            @foreach ($resellers as $reseller)
                                @if ($reseller->id == $pop->reseller_id)
                                    @php
                                        $totalActive += $clientCount->where('clients_status', 'active')->where('pop_id', $pop->id)->first()->total ?? 0;
                                        $totalExpire += $clientCount->where('clients_status', 'expired')->where('pop_id', $pop->id)->first()->total ?? 0;
                                        $totalDisable += $clientCount->where('clients_status', 'disable')->where('pop_id', $pop->id)->first()->total ?? 0;
                                        $totalDeactive += $clientCount->where('clients_status', 'deactive')->where('pop_id', $pop->id)->first()->total ?? 0;
                                        $totalWithoutClose += ($clientCount->where('clients_status', 'active')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'expired')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'disable')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'deactive')->where('pop_id', $pop->id)->first()->total ?? 0);
                                        $totalClose += $closeClientCount->where('pop_id', $pop->id)->first()->total ?? 0;
                                        $total += ($clientCount->where('clients_status', 'active')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'expired')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'disable')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'deactive')->where('pop_id', $pop->id)->first()->total ?? 0) + ($closeClientCount->where('pop_id', $pop->id)->first()->total ?? 0);
                                    @endphp

                                        <td>{{ $pop->popname }}{{ ($pop->subreseller == "yes") ? '(Sub POP)' : '' }}</td>
                                        {{-- <th>{{ $clientCount->where('clients_status', 'active')->where('pop_id', '$pop->id')->first()->total }}</th> --}}
                                        <td>
                                            {{ $clientCount->where('clients_status', 'active')->where('pop_id', $pop->id)->first()->total ?? 0 }}
                                        </td>
                                        <td>
                                            {{ $clientCount->where('clients_status', 'expired')->where('pop_id', $pop->id)->first()->total ?? 0 }}
                                        </td>
                                        <td>
                                            {{ $clientCount->where('clients_status', 'disable')->where('pop_id', $pop->id)->first()->total ?? 0 }}
                                        </td>
                                        <td>
                                            {{ $clientCount->where('clients_status', 'deactive')->where('pop_id', $pop->id)->first()->total ?? 0 }}
                                        </td>
                                        <td>
                                            @php
                                                $total = ($clientCount->where('clients_status', 'active')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'expired')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'disable')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'deactive')->where('pop_id', $pop->id)->first()->total ?? 0);
                                            @endphp
                                            {{ $total ?? 0 }}
                                        </td>
                                        <td>
                                            {{ $closeClientCount->where('pop_id', $pop->id)->first()->total ?? 0 }}
                                        </td>
                                        <td>
                                            @php
                                                $total = ($clientCount->where('clients_status', 'active')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'expired')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'disable')->where('pop_id', $pop->id)->first()->total ?? 0) + ($clientCount->where('clients_status', 'deactive')->where('pop_id', $pop->id)->first()->total ?? 0) + ($closeClientCount->where('pop_id', $pop->id)->first()->total ?? 0);
                                            @endphp
                                            {{ $total ?? 0 }}
                                        </td>

                                @endif
                            @endforeach
                        </tr>
                        @endforeach
                        <tr>
                            <td>Total</td>
                            <td></td>
                            <td>{{ $totalActive }}</td>
                            <td>{{ $totalExpire }}</td>
                            <td>{{ $totalDisable }}</td>
                            <td>{{ $totalDeactive }}</td>
                            <td>{{ $totalWithoutClose }}</td>
                            <td>{{ $totalClose }}</td>
                            <td>{{ $total }}</td>
                        </tr>

                    </tbody>
                </table>
            </div>
        </div>

    </div>
    </div>
@endsection