@php $totalDue = 0; $totalPaid = 0; $totalBill = 0; $client_count = 0; @endphp @foreach ($clients as $client) @if (($client->generatedBill->sum('bill_amount') - ($client->paymentBill->sum('paid_amount') + $client->paymentBill->sum('discount_amount'))) > 0) @php $totalDue += $client->generatedBill->sum('bill_amount') - ($client->paymentBill->sum('paid_amount') + $client->paymentBill->sum('discount_amount')); $totalPaid += $client->paymentBill->sum('paid_amount') + $client->paymentBill->sum('discount_amount'); $totalBill += $client->generatedBill->sum('bill_amount'); $client_count++; @endphp @endif @endforeach

ID	Name	Pop	Due Amount	Paid Amount (With Discount)	Bill amount
CID: {{ $client->id }}	Name: {{ $client->clientsinfo->clients_name ?? '' }} User Name: {{ $client->userid ?? '' }}	{{ $client->pop->popname ?? '' }}	{{$client->generatedBill->sum('bill_amount') - ($client->paymentBill->sum('paid_amount') + $client->paymentBill->sum('discount_amount') )}}	{{ $client->paymentBill->sum('paid_amount') + $client->paymentBill->sum('discount_amount') }}	{{ $client->generatedBill->sum('bill_amount') ?? "0" }}
Total		{{ $client_count }}	{{ $totalDue }}	{{ $totalPaid }}	{{ $totalBill }}