@php
$sl = 1;
$totalDebit = $totalCredit = $totalDebitCash = $totaDebitBank = $totalCreditCash = $totalCreditBank = 0;
$opCashDebitAmount = $openingBalanceInfo['cashDebitAmount'];
$opBankDebitAmount = $openingBalanceInfo['bankDebitAmount'];
$opCashCreditAmount = $openingBalanceInfo['cashCreditAmount'];
$opBankCreditAmount = $openingBalanceInfo['bankCreditAmount'];
$cashBalanceAmount = $openingBalanceInfo['openingCashBalance'];
$bankBalanceAmount = $openingBalanceInfo['openingBankBalance'];
$balanceAmount = $openingBalanceInfo['openingBalance'];
@endphp
{{-- opening balance row --}}
|
|
|
Opening Balance |
{{ number_format(abs($opCashDebitAmount), 2, '.', ',') }} |
{{ number_format(abs($opBankDebitAmount), 2, '.', ',') }} |
{{ number_format(abs($opCashCreditAmount), 2, '.', ',') }} |
{{ number_format(abs($opBankCreditAmount), 2, '.', ',') }} |
{{ number_format(abs($openingBalanceInfo['openingCashBalance']), 2, '.', ',') }} |
{{ number_format(abs($openingBalanceInfo['openingBankBalance']), 2, '.', ',') }} |
@foreach ($voucherInfos as $voucherInfo)
@php
$ledgerInfo = in_array($voucherInfo->debitAcc, $ledgerIdArr) ? $ledgersInfo[$voucherInfo->creditAcc] : $ledgersInfo[$voucherInfo->debitAcc];
$debitAmountCash = 0;
$debitAmountBank = 0;
$creditAmountCash = 0;
$creditAmountBank = 0;
@endphp
{{-- if both 'debitAcc' and 'creditAcc' are in '$ledgerIdArr' then we need to print twice --}}
@if (in_array($voucherInfo->debitAcc, $ledgerIdArr) && in_array($voucherInfo->creditAcc, $ledgerIdArr) && $voucherInfo->voucherCode != 'Opening Transaction')
@for ($i = 0; $i < 2; $i++)
@php
// let '$i = 0' for debit
if ($i == 0) {
$ledgerInfo = $ledgersInfo[$voucherInfo->creditAcc];
$debitAmount = 0;
$creditAmount = $voucherInfo->amount;
$totalCredit += $creditAmount;
$balanceAmount -= $creditAmount;
$debitAmountCash = 0;
$debitAmountBank = 0;
if (isCashAccount($cashBankLedgers[$voucherInfo->creditAcc] ?? null)) {
$creditAmountCash = $creditAmount;
$creditAmountBank = 0;
$cashBalanceAmount -= $creditAmount;
$totalCreditCash += $creditAmount;
} elseif (isBankAccount($cashBankLedgers[$voucherInfo->creditAcc] ?? null)) {
$creditAmountBank = $creditAmount;
$creditAmountCash = 0;
$bankBalanceAmount -= $creditAmount;
$totalCreditBank += $creditAmount;
}
} else {
$ledgerInfo = $ledgersInfo[$voucherInfo->debitAcc];
$debitAmount = $voucherInfo->amount;
$creditAmount = 0;
$totalDebit += $debitAmount;
$balanceAmount += $debitAmount;
$creditAmountCash = 0;
$creditAmountBank = 0;
if (isCashAccount($cashBankLedgers[$voucherInfo->debitAcc] ?? null)) {
$debitAmountCash = $debitAmount;
$debitAmountBank = 0;
$cashBalanceAmount += $debitAmount;
$totalDebitCash += $debitAmount;
} elseif (isBankAccount($cashBankLedgers[$voucherInfo->debitAcc] ?? null)) {
$debitAmountBank = $debitAmount;
$debitAmountCash = 0;
$bankBalanceAmount += $debitAmount;
$totaDebitBank += $debitAmount;
}
}
@endphp
| {{ $sl++ }} |
{{ Carbon\Carbon::parse($voucherInfo->voucherDate)->format('d-m-Y') }} |
{{ $voucherInfo->voucherCode }} |
{{ @$ledgerInfo->name . ' [' . @$ledgerInfo->code . ']' }} |
{{ number_format($debitAmountCash, 2) }} |
{{ number_format($debitAmountBank, 2) }} |
{{ number_format($creditAmountCash, 2) }} |
{{ number_format($creditAmountBank, 2) }} |
{{ number_format($cashBalanceAmount, 2) }} |
{{ number_format($bankBalanceAmount, 2) }} |
@endfor
@else
@php
if ($voucherInfo->voucherCode == 'Opening Transaction') {
$balanceAmount = $voucherInfo->amount;
$debitAmount = 0;
$creditAmount = 0;
} else {
// debit and credit amount
if (in_array($voucherInfo->debitAcc, $ledgerIdArr) && $voucherInfo->debitAcc != $voucherInfo->creditAcc) {
$debitAmount = $voucherInfo->amount;
$creditAmount = 0;
$totalDebit += $debitAmount;
$balanceAmount += $debitAmount;
if (isCashAccount($cashBankLedgers[$voucherInfo->debitAcc] ?? null)) {
$debitAmountCash = $debitAmount;
$debitAmountBank = 0;
$cashBalanceAmount += $debitAmount;
$totalDebitCash += $debitAmount;
} elseif (isBankAccount($cashBankLedgers[$voucherInfo->debitAcc] ?? null)) {
$debitAmountBank = $debitAmount;
$debitAmountCash = 0;
$bankBalanceAmount += $debitAmount;
$totaDebitBank += $debitAmount;
}
}
if (in_array($voucherInfo->creditAcc, $ledgerIdArr) && $voucherInfo->debitAcc != $voucherInfo->creditAcc) {
$debitAmount = 0;
$creditAmount = $voucherInfo->amount;
$totalCredit += $creditAmount;
$balanceAmount -= $creditAmount;
if (isCashAccount($cashBankLedgers[$voucherInfo->creditAcc] ?? null)) {
$creditAmountCash = $creditAmount;
$creditAmountBank = 0;
$cashBalanceAmount -= $creditAmount;
$totalCreditCash += $creditAmount;
} elseif (isBankAccount($cashBankLedgers[$voucherInfo->creditAcc] ?? null)) {
$creditAmountBank = $creditAmount;
$creditAmountCash = 0;
$bankBalanceAmount -= $creditAmount;
$totalCreditBank += $creditAmount;
}
}
if ($voucherInfo->debitAcc == $voucherInfo->creditAcc) {
$debitAmount = $voucherInfo->amount;
$creditAmount = $voucherInfo->amount;
$totalDebit += $voucherInfo->amount;
$totalCredit += $voucherInfo->amount;
if (isCashAccount($cashBankLedgers[$voucherInfo->debitAcc] ?? null)) {
$debitAmountCash = $debitAmount;
$creditAmountCash = $creditAmount;
$debitAmountBank = 0;
$creditAmountBank = 0;
$cashBalanceAmount += $voucherInfo->amount;
$totalDebitCash += $debitAmount;
$totalCreditCash += $creditAmount;
} elseif (isBankAccount($cashBankLedgers[$voucherInfo->debitAcc] ?? null)) {
$debitAmountBank = $debitAmount;
$creditAmountBank = $creditAmount;
$debitAmountCash = 0;
$creditAmountCash = 0;
$bankBalanceAmount += $voucherInfo->amount;
$totaDebitBank += $debitAmount;
$totalCreditBank += $creditAmount;
}
}
}
@endphp
| {{ $sl++ }} |
{{ Carbon\Carbon::parse($voucherInfo->voucherDate)->format('d-m-Y') }} |
{{ $voucherInfo->voucherCode }} |
{{ @$ledgerInfo->name . ' [' . @$ledgerInfo->code . ']' }} |
{{ number_format($debitAmountCash, 2) }} |
{{ number_format($debitAmountBank, 2) }} |
{{ number_format($creditAmountCash, 2) }} |
{{ number_format($creditAmountBank, 2) }} |
{{ number_format($cashBalanceAmount, 2) }} |
{{ number_format($bankBalanceAmount, 2) }} |
@endif
@endforeach
{{-- Sub Total --}}
| Total (During this period) |
{{ number_format($totalDebitCash, 2) }} |
{{ number_format($totaDebitBank, 2) }} |
{{ number_format($totalCreditCash, 2) }} |
{{ number_format($totalCreditBank, 2) }} |
{{ number_format($cashBalanceAmount, 2) }} |
{{ number_format($bankBalanceAmount, 2) }} |
{{-- Total / CLosing Balance --}}
| Closing Balance |
{{ number_format($totalDebitCash + $opCashDebitAmount, 2) }} |
{{ number_format($totaDebitBank + $opBankDebitAmount, 2) }} |
{{ number_format($totalCreditCash + $opCashCreditAmount, 2) }} |
{{ number_format($totalCreditBank + $opBankCreditAmount, 2) }} |
{{ number_format($cashBalanceAmount, 2) }} |
{{ number_format($bankBalanceAmount, 2) }} |