@php $grandDebit = 0; $grandCredit = 0; $grandBalance = 0; @endphp @forelse($advances as $key => $advance) @php $debitSum = $advance->lines->sum('debit'); $creditSum = $advance->lines->sum('credit'); $balance = $debitSum - $creditSum; $grandDebit += $debitSum; $grandCredit += $creditSum; $grandBalance += $balance; $entity = $advance->accountEntity?->entity; if ($entity instanceof \App\Models\Farmer) { $entityName = trim(($entity->farmer_fname ?? '') . ' ' . ($entity->farmer_lname ?? '')) ?: $advance->name; $entityNumber = $entity->farmer_number ?? $advance->code; } elseif ($entity instanceof \App\Models\Buyer) { $entityName = $entity->buyer_name ?? $advance->name; $entityNumber = $entity->buyer_number ?? $advance->code; } elseif ($entity instanceof \App\Models\Employee) { $entityName = trim(($entity->first_name ?? '') . ' ' . ($entity->last_name ?? '')) ?: $advance->name; $entityNumber = $entity->employee_code ?? $advance->code; } else { $entityName = $advance->name; $entityNumber = $advance->code; } @endphp @empty @endforelse

#	Account / Entity	Code	Total Debit	Total Credit	Balance	Action
{{ $key + 1 }}	{{ $entityName }}	{{ $entityNumber }}	{{ number_format($debitSum, 0) }}	{{ number_format($creditSum, 0) }}	{{ number_format($balance, 0) }}	View
@php $runningBalance = 0; @endphp @foreach($advance->lines as $line) @php $runningBalance += ($line->debit - $line->credit); @endphp @endforeach Reference Date Debit Credit Balance {{ $line->entry->reference ?? 'No Ref' }} {{ $line->entry->entry_date ? \Carbon\Carbon::parse($line->entry->entry_date)->format('Y-m-d') : '' }} {{ number_format($line->debit, 0) }} {{ number_format($line->credit, 0) }} {{ number_format($runningBalance, 0) }}
No records found.
Totals:			{{ number_format($grandDebit, 0) }}	{{ number_format($grandCredit, 0) }}	{{ number_format($grandBalance, 0) }}