@php $Count = 0; $gtOpeningBalance = 0 ; $gtPrincipleAddition = 0; $gtInterestAddition = 0; $gtBankChargeAddition = 0; $gtPrinciplePayment = 0; $gtInterestPayment = 0; $gtBankChargePayment = 0; $gtClosingBalance = 0; @endphp @foreach ($loanRegisterAccountInfoArr as $bankId => $loanRegisterInfoBankIdArrs) @php $countBankRow = count($loanRegisterInfoBankIdArrs); $donarName = 0; $subOpening = 0 ; $subPrincipleAddition = 0; $subInterestAddition = 0; $subBankChargeAddition = 0; $subPrinciplePayment = 0; $subInterestPayment = 0; $subBankChargePayment = 0; $subClosingBalance = 0; @endphp @foreach ($loanRegisterInfoBankIdArrs as $accNo => $loanRegisterInfoBankIdAccnoArr) @php $donarName++; //Opening Balance Addition Balance $openigBalanceView = isset($loanRegisterOpeningBalanceArr[$bankId][$accNo]["openignBalance"]) ? $loanRegisterOpeningBalanceArr[$bankId][$accNo]["openignBalance"] : 0.00; $additionPrincipleAmt = isset($loanRegisterInfoBankIdAdditionArr[$bankId][$accNo]["loanAmountAddition"]) ? $loanRegisterInfoBankIdAdditionArr[$bankId][$accNo]["loanAmountAddition"] : 0.00; $additionInterestAmt = isset($loanInterestInfoBankIdAdditionArr[$bankId][$accNo]["loanInterestAmtAddition"]) ? $loanInterestInfoBankIdAdditionArr[$bankId][$accNo]["loanInterestAmtAddition"] : 0.00; $additionBankChargeAmt = isset($loanInterestInfoBankIdAdditionArr[$bankId][$accNo]["loanBankChargeAddition"]) ? $loanInterestInfoBankIdAdditionArr[$bankId][$accNo]["loanBankChargeAddition"] : 0.00; //Payment And Closing Balance $paymentPrincipleAmt = isset($loanPaymentInfoBankIdAdditonArr[$bankId][$accNo]["paymentPrincipalAmountAdditoin"]) ? $loanPaymentInfoBankIdAdditonArr[$bankId][$accNo]["paymentPrincipalAmountAdditoin"] : 0.00; $paymentInterestAmt = isset($loanPaymentInfoBankIdAdditonArr[$bankId][$accNo]["paymentInterestAmountAdditoin"]) ? $loanPaymentInfoBankIdAdditonArr[$bankId][$accNo]["paymentInterestAmountAdditoin"] : 0.00; $paymentBankChargeAmt = isset($loanPaymentInfoBankIdAdditonArr[$bankId][$accNo]["bankChargeAdditoin"]) ? $loanPaymentInfoBankIdAdditonArr[$bankId][$accNo]["bankChargeAdditoin"] : 0.00; $closingBalanceView = ($openigBalanceView + $additionPrincipleAmt + $additionInterestAmt) - ($paymentPrincipleAmt + $paymentInterestAmt + $paymentBankChargeAmt); //Sub Opening And Addition Balance $subOpening += $openigBalanceView; $subPrincipleAddition += $additionPrincipleAmt ; $subInterestAddition += $additionInterestAmt; $subBankChargeAddition += $additionBankChargeAmt; //Sub Payment And Closing Balance $subPrinciplePayment += $paymentPrincipleAmt; $subInterestPayment += $paymentInterestAmt; $subBankChargePayment += $paymentBankChargeAmt; $subClosingBalance += $closingBalanceView; @endphp @if ($donarName == 1) @endif @endforeach @php //Grand Total Opening And Addition Balance $gtOpeningBalance += $openigBalanceView; $gtPrincipleAddition += $additionPrincipleAmt ; $gtInterestAddition += $additionInterestAmt; $gtBankChargeAddition += $additionBankChargeAmt; //Grand Total Payment And Closing Balance $gtPrinciplePayment += $paymentPrincipleAmt; $gtInterestPayment += $paymentInterestAmt; $gtBankChargePayment += $paymentBankChargeAmt; $gtClosingBalance += $closingBalanceView; @endphp @endforeach

Donor Name	Loan Received Date	Account NO.	Account Name	Loan Duration	Interest Rate	Loan Amount	Opening Balance	Addition			Payment			Closing Balance
								Pinciple	Interest	Bank Charge	Pinciple	Interest	Bank Charge
{{$donarInfoNameArr[$bankId]}}	{{ $loanRegisterInfoBankIdAccnoArr["agreementDate"] }}	{{ $loanRegisterInfoBankIdAccnoArr["accNo"] }}	Ambala Foundation	{{ number_format($loanRegisterInfoBankIdAccnoArr["LoanDuration"],2) }}	{{ number_format($loanRegisterInfoBankIdAccnoArr["interestRate"],2) }}	{{ number_format($loanRegisterInfoBankIdAccnoArr["loanAmount"],2) }}	{{number_format($openigBalanceView,2)}}	{{number_format($additionPrincipleAmt,2)}}	{{number_format($additionInterestAmt,2)}}	{{number_format($additionBankChargeAmt,2)}}	{{number_format($paymentPrincipleAmt,2)}}	{{number_format($paymentInterestAmt,2)}}	{{number_format($paymentBankChargeAmt,2)}}	{{number_format($closingBalanceView,2)}}
Sub Total							{{number_format($subOpening,2)}}	{{number_format($subPrincipleAddition,2)}}	{{number_format($subInterestAddition,2)}}	{{number_format($subBankChargeAddition,2)}}	{{number_format($subPrinciplePayment,2)}}	{{number_format($subInterestPayment,2)}}	{{number_format($subBankChargePayment,2)}}	{{number_format($subClosingBalance,2)}}
Grand Total							{{number_format($gtOpeningBalance,2)}}	{{number_format($gtPrincipleAddition,2)}}	{{number_format($gtInterestAddition,2)}}	{{number_format($gtBankChargeAddition,2)}}	{{number_format($gtPrinciplePayment,2)}}	{{number_format($gtInterestPayment,2)}}	{{number_format($gtBankChargePayment,2)}}	{{number_format($gtClosingBalance,2)}}