@foreach ($voucherInfos as $date => $transactions)

@if (!$loop->first)

@endif

{{ $bankBookReportLoadTableArr['company']->name }}
{{ $bankBookReportLoadTableArr['company']->address }}
Cash & Bank Book Statement
Date - {{ \Carbon\Carbon::parse($date)->format('jS F, Y') }}

Project: {{ $bankBookReportLoadTableArr['projectName'] }} Branch: {{ $bankBookReportLoadTableArr['branchName'] }}

Project Type: {{ $bankBookReportLoadTableArr['projectType'] }} Print Date: {{ \Carbon\Carbon::now()->format('d-m-Y g:i A') }}

Date - {{ \Carbon\Carbon::parse($date)->format('jS F, Y') }}

@php // Initialize opening balances $tempOpeningCashBalance = $transactions['openingCashBalance']; $tempOpeningBankBalance = $transactions['openingBankBalance']; $rowsPerPage = 20; $rowCount = 0; $maxRows = max(count($transactions['debitTransactions']), count($transactions['creditTransactions'])); $maxCvRows = max(count($transactions['cvDebitTransactions']), count($transactions['cvCreditTransactions'])); @endphp @php $rowCount = $rowCount + 2; @endphp @if ($maxRows > 0 || $maxCvRows > 0) @for ($i = 0; $i < $maxRows; $i++) @php $debitTransaction = $transactions['debitTransactions'][$i] ?? null; $creditTransaction = $transactions['creditTransactions'][$i] ?? null; // Ensure proper calculation with fallback for missing values $debitAmountCash = $debitTransaction['debitAmountCash'] ?? 0; $debitAmountBank = $debitTransaction['debitAmountBank'] ?? 0; $creditAmountCash = $creditTransaction['creditAmountCash'] ?? 0; $creditAmountBank = $creditTransaction['creditAmountBank'] ?? 0; // Update temp opening balances for the next row $tempOpeningCashBalance = ($tempOpeningCashBalance + $debitAmountCash) - $creditAmountCash; $tempOpeningBankBalance = ($tempOpeningBankBalance + $debitAmountBank) - $creditAmountBank; @endphp @php $rowCount++; @endphp @if ($rowCount == $rowsPerPage) @php $rowCount = 0; @endphp @endif @endfor @php $rowCount++; @endphp @for ($i = 0; $i < $maxCvRows; $i++) @php $cvDebitTransactions = $transactions['cvDebitTransactions'][$i] ?? null; $cvCreditTransactions = $transactions['cvCreditTransactions'][$i] ?? null; // Ensure proper calculation with fallback for missing values $contraDebitAmountCash = $cvDebitTransactions['headDebitAmountCash'] ?? 0; $contraDebitAmountBank = $cvDebitTransactions['headDebitAmountBank'] ?? 0; $contraCreditAmountCash = $cvCreditTransactions['headCreditAmountCash'] ?? 0; $contraCreditAmountBank = $cvCreditTransactions['headCreditAmountBank'] ?? 0; // Update temp opening balances for the next row $tempOpeningCashBalance = ($tempOpeningCashBalance + $contraDebitAmountCash) - $contraCreditAmountCash; $tempOpeningBankBalance = ($tempOpeningBankBalance + $contraDebitAmountBank) - $contraCreditAmountBank; @endphp @php $rowCount++; @endphp @if ($rowCount == $rowsPerPage) @php $rowCount = 0; @endphp @endif @endfor @else @endif

Voucher Code	Particulars	Ledger Code	Debit Amount ({{ $currency }})		Voucher Code	Particulars	Ledger Code	Credit Amount ({{ $currency }})
Voucher Code	Particulars	Ledger Code	Cash	Bank	Voucher Code	Particulars	Ledger Code	Cash	Bank

Opening Balance			{{ number_format($transactions['openingCashBalance'], 2) }}	{{ number_format($transactions['openingBankBalance'], 2) }}
{{ $debitTransaction['voucherCode'] ?? '-' }}	{{ $debitTransaction['ledgerName'] ?? '-' }}	{{ $debitTransaction['ledgerCode'] ?? '-' }}	{{ number_format($debitAmountCash, 2) }}	{{ number_format($debitAmountBank, 2) }}	{{ $creditTransaction['voucherCode'] ?? '-' }}	{{ $creditTransaction['ledgerName'] ?? '-' }}	{{ $creditTransaction['ledgerCode'] ?? '-' }}	{{ number_format($creditAmountCash, 2) }}	{{ number_format($creditAmountBank, 2) }}

Opening Balance			{{ number_format($tempOpeningCashBalance, 2) }}	{{ number_format($tempOpeningBankBalance, 2) }}

{{ $cvDebitTransactions['voucherCode'] ?? '-' }}	{{ $cvDebitTransactions['transCreditledgerName'] ?? '-' }}	{{ $cvDebitTransactions['transCreditledgerCode'] ?? '-' }}	{{ number_format($contraDebitAmountCash, 2) }}	{{ number_format($contraDebitAmountBank, 2) }}	{{ $cvCreditTransactions['voucherCode'] ?? '-' }}	{{ $cvCreditTransactions['transDebitledgerName'] ?? '-' }}	{{ $cvCreditTransactions['transDebitledgerCode'] ?? '-' }}	{{ number_format($contraCreditAmountCash, 2) }}	{{ number_format($contraCreditAmountBank, 2) }}

Opening Balance			{{ number_format($tempOpeningCashBalance, 2) }}	{{ number_format($tempOpeningBankBalance, 2) }}
Sub Total			{{ number_format($transactions['totalDebitCash'], 2) }}	{{ number_format($transactions['totalDebitBank'], 2) }}	Sub Total			{{ number_format($transactions['totalCreditCash'], 2) }}	{{ number_format($transactions['totalCreditBank'], 2) }}
					Closing Balance			{{ number_format($transactions['closingCashBalance'], 2) }}	{{ number_format($transactions['closingBankBalance'], 2) }}
Total			{{ number_format($transactions['totalDebitCashWithOp'], 2) }}	{{ number_format($transactions['totalDebitBankWithOp'], 2) }}	Total			{{ number_format($transactions['totalCreditCashWithCl'], 2) }}	{{ number_format($transactions['totalCreditBankWithCl'], 2) }}
No transactions available for this date.

@endforeach