@foreach($transactions as $transaction)
@php
// Calculate the balance based on transaction type
if ($transaction->transaction_type === 'Debit') {
$balance -= $transaction->transaction_amount; // Subtract debit amount
$totalDebit += $transaction->transaction_amount; // Add debit amount to total
} elseif ($transaction->transaction_type === 'Credit') {
$balance += $transaction->transaction_amount; // Add credit amount
$totalCredit += $transaction->transaction_amount; // Add credit amount to total
}
@endphp
@php
$transactionDate = strtotime($transaction->transaction_date);
$minDateFilter = strtotime($minDate);
$maxDateFilter = strtotime($maxDate);
$isWithinDateRange = ($minDateFilter <= $transactionDate) && ($transactionDate <= $maxDateFilter);
@endphp
@if ($isWithinDateRange)
{{ $transaction->transaction_date }} |
{{ $transaction->transaction_type === 'Debit' ? number_format($transaction->transaction_amount) : '' }} |
{{ $transaction->transaction_type === 'Credit' ? number_format($transaction->transaction_amount) : '' }} |
{{ number_format($balance) }} |
@endif
@endforeach
Totals |
{{ number_format($totalDebit) }} |
{{ number_format($totalCredit) }} |
{{ number_format($balance) }} |