@php use App\Models\Pop; $sumOfNewClients = 0; $sumOfUpdatedClients = 0; $total_resellers = 0; $sumOfNewClientsNotActive = 0; $sumOfUpdateClientsNotActive = 0; @endphp @foreach ($users as $user) @php $all_resellers_ids = $user->resellers()->count(); $new_resellers_ids = $user->resellers() ->whereBetween('resellers.created_at', [$start, $end]) ->pluck('resellers.id'); $new_pops = Pop::whereIn('reseller_id', $new_resellers_ids)->pluck('id'); $old_resellers_ids = $user->resellers() ->whereNotIn('resellers.id', $new_resellers_ids) ->pluck('resellers.id'); $old_pops = Pop::whereIn('reseller_id', $old_resellers_ids)->pluck('id'); $new_active_clients = $clients->whereIn('pop_id', $new_pops)->where('clients_status', 'active')->count(); $updated_active_clients = $clients->whereIn('pop_id', $old_pops)->where('clients_status', 'active')->count(); $new_not_active_clients = $clients->whereIn('pop_id', $new_pops)->where('clients_status', '!=', 'active')->count(); $updated_not_active_clients = $clients->whereIn('pop_id', $old_pops)->where('clients_status', '!=', 'active')->count(); $sumOfNewClientsNotActive += $new_not_active_clients; $sumOfUpdateClientsNotActive += $updated_not_active_clients; $sumOfNewClients += $new_active_clients; $sumOfUpdatedClients += $updated_active_clients; $total_resellers += $all_resellers_ids; @endphp @endforeach

Serial Number	KAM Name	New Id (Active)	Updated Id (Active)	New Id (Not Active)	Updated Id (Not Active)
{{ $loop->iteration }}	{{ $user->name }} ({{$all_resellers_ids}})	{{ $new_active_clients }}	{{ $updated_active_clients }}	{{ $new_not_active_clients }}	{{ $updated_not_active_clients }}
Total ({{$sumOfNewClients + $sumOfUpdatedClients}}) ({{$total_resellers}})		{{ $sumOfNewClients }}	{{ $sumOfUpdatedClients }}	{{ $sumOfNewClientsNotActive }}	{{ $sumOfUpdateClientsNotActive }}