@include('templates.pdf_header', [ 'organisation' => $organisation, 'asOfDate' => $asOfDate, 'currency' => $currency, 'title' => 'COMPARATIVE TRIAL BALANCE' ]) @php $currentTotalDebit = 0; $currentTotalCredit = 0; $previousTotalDebit = 0; $previousTotalCredit = 0; $differenceTotalDebit = 0; $differenceTotalCredit = 0; @endphp @foreach($data['data'] as $account) @php // Current Period $currentDebit = $account['current_debit'] > 0 ? $account['current_debit'] : 0; $currentCredit = $account['current_credit'] > 0 ? $account['current_credit'] : ( $account['current_debit'] < 0 ? abs($account['current_debit']) : 0 ); $currentBalance = $currentDebit - $currentCredit; // Previous Period $previousDebit = $account['previous_debit'] > 0 ? $account['previous_debit'] : 0; $previousCredit = $account['previous_credit'] > 0 ? $account['previous_credit'] : ( $account['previous_debit'] < 0 ? abs($account['previous_debit']) : 0 ); $previousBalance = $previousDebit - $previousCredit; // Differences $debitDiff = $account['debit_difference']; $creditDiff = $account['credit_difference']; $balanceDiff = $currentBalance - $previousBalance; // Update totals $currentTotalDebit += $currentDebit; $currentTotalCredit += $currentCredit; $previousTotalDebit += $previousDebit; $previousTotalCredit += $previousCredit; $differenceTotalDebit += $debitDiff; $differenceTotalCredit += $creditDiff; @endphp @endforeach
Account Code Account Name Current Period Previous Period
Debit Credit Debit Credit
{{ $account['account_code'] }} {{ $account['account_name'] }} {{ $currentDebit ? number_format($currentDebit, 2) : '-' }} {{ $currentCredit ? number_format($currentCredit, 2) : '-' }} {{ $previousDebit ? number_format($previousDebit, 2) : '-' }} {{ $previousCredit ? number_format($previousCredit, 2) : '-' }}
TOTAL {{ number_format($currentTotalDebit, 2) }} {{ number_format($currentTotalCredit, 2) }} {{ number_format($previousTotalDebit, 2) }} {{ number_format($previousTotalCredit, 2) }}