@php
$balances = collect($partnerBalances);
$totalPartners = $balances->count();
$totalAllocated = $balances->sum('total_allocated');
$totalWithdrawn = $balances->sum('total_withdrawn');
$totalOutstanding = $balances->sum('closing_balance');
// Count partners with positive balance (Creditors)
$creditors = $balances->filter(function($balance) {
return $balance->closing_balance > 0;
})->count();
// Count partners with negative balance (Debtors)
$debtors = $balances->filter(function($balance) {
return $balance->closing_balance < 0;
})->count();
// Count partners with zero balance
$zeroBalance = $balances->filter(function($balance) {
return $balance->closing_balance == 0;
})->count();
@endphp
Total Partners
{{ $totalPartners }}
Total Withdrawn
${{ number_format($totalWithdrawn, 2) }}
Total amount withdrawn by partners
Total Outstanding
${{ number_format(abs($totalOutstanding), 2) }}
Total balance outstanding
Average Withdrawal per Partner
${{ number_format($totalPartners > 0 ? $totalWithdrawn / $totalPartners : 0, 2) }}
Average amount withdrawn per partner
Net Position
${{ number_format(abs($totalAllocated - $totalWithdrawn), 2) }}
@if(($totalAllocated - $totalWithdrawn) > 0)
More Allocated
@elseif(($totalAllocated - $totalWithdrawn) < 0)
More Withdrawn
@else
Balanced
@endif
| # | Partner Name | Opening Balance | Total Withdrawn | Closing Balance | Action | |
|---|---|---|---|---|---|---|
| {{ $index + 1 }} |
{{ $balance->partner->full_name }}
@if($balance->partner->partner_code)
({{ $balance->partner->partner_code }})
@endif
@if($percentageUsed > 0)
|
${{ number_format(abs($balance->opening_balance), 2) }} @if($balance->opening_balance < 0) (Dr) @endif | ${{ number_format($balance->total_withdrawn, 2) }} @if($balance->total_withdrawn > 0) @endif | @php $closingBalance = $balance->closing_balance; $balanceClass = $closingBalance > 0 ? 'amount-positive' : ($closingBalance < 0 ? 'amount-negative' : 'amount-neutral'); @endphp ${{ number_format(abs($closingBalance), 2) }} | View | |
No Partner Data FoundThere are no partner balances to display at the moment. |
||||||
| Grand Totals: | ${{ number_format(collect($partnerBalances)->sum('opening_balance'), 2) }} | ${{ number_format($totalWithdrawn, 2) }} | ${{ number_format($totalOutstanding, 2) }} | |||
Report generated on {{ now()->format('d-m-Y H:i:s') }}