@if($migration) @endif @if($migration) @endif @foreach($savingsProductSegments as $savingsProductSegment) @endforeach @if($migration) @foreach($savingsProductSegments as $savingsProductSegment) @endforeach @endif @php $sl = 1; $othersFund_interestPaid = 0; $mig_othersFund_interestPaid = 0; foreach($savingsProductSegments as $savingsProductSegment){ ${'pksfFund_'.$savingsProductSegment['field'].'_interestPaid'} = 0; ${'mig_pksfFund_'.$savingsProductSegment['field'].'_interestPaid'} = 0; } $totalPksf_interestPaid = 0; $mig_totalPksf_interestPaid = 0; @endphp @foreach($savInterestRates as $savInterestRate) @php $interestAmount = $provisions ->where('interestRate', $savInterestRate) ->whereIn('primaryProductIdFk', $othersFundLoanProductIds) ->sum('interestAmount'); $remaing_provision = $provisionAdjusts ->where('interestRate', $savInterestRate) ->whereIn('primaryProductIdFk', $othersFundLoanProductIds) ->sum('remaing_provision'); $interestPaid = $interestAmount - $remaing_provision; $othersFund_interestPaid += $interestPaid; $totalPaidRateWise = 0; @endphp @foreach($savingsProductSegments as $savingsType => $savingsProductSegment) @php $interestAmount = $provisions->where('savingsType', $savingsType) ->where('interestRate', $savInterestRate) ->whereIn('primaryProductIdFk', $pfksFundLoanProductIds) ->sum('interestAmount'); $remaing_provision = $provisionAdjusts->where('savingsType', $savingsType) ->where('interestRate', $savInterestRate) ->whereIn('primaryProductIdFk', $pfksFundLoanProductIds) ->sum('remaing_provision'); $interestPaid = $interestAmount - $remaing_provision; $totalPaidRateWise += $interestPaid; ${'pksfFund_'.$savingsProductSegment['field'].'_interestPaid'} += $interestPaid; $totalPksf_interestPaid += $interestPaid; @endphp @endforeach @if($migration) @php $mig_othersFund_interestPaid += @$migSavingsInterest[$savInterestRate]->npk; $mig_totalPksf_interestPaid += @$migSavingsInterest[$savInterestRate]->total_pksf; @endphp @foreach($savingsProductSegments as $savingsType => $savingsProductSegment) @php ${'mig_pksfFund_'.$savingsProductSegment['field'].'_interestPaid'} += @$migSavingsInterest[$savInterestRate]->{$savingsProductSegment['field']}; @endphp @endforeach @endif @endforeach @foreach($savingsProductSegments as $savingsProductSegment) @endforeach @if($migration) @foreach($savingsProductSegments as $savingsProductSegment) @endforeach @endif
Amount of interest paid on savings in this financial year
SL Rate of Interest on savings Process Data Migrated Data
Amount of interest paid on savings (Other Fund) Amount of interest paid on savings (PKSF Fund)Amount of interest paid on savings (Other Fund) Amount of interest paid on savings (PKSF Fund)
{{ $savingsProductSegment['label']}}Total{{ $savingsProductSegment['label']}}Total
{{ $sl++ }} {{ $savInterestRate }} {{ Form::hidden('int_rate[]', $savInterestRate) }} {{ number_format($interestPaid,$round) }} {{ Form::hidden('npk[]', round($interestPaid, $round)) }}{{ number_format($interestPaid,$round) }} {{ Form::hidden($savingsProductSegment['field'].'[]', round($interestPaid, $round)) }}{{ number_format($totalPaidRateWise, $round)}} {{ Form::hidden('total_pksf[]', round($totalPaidRateWise, $round)) }} {{number_format(@$migSavingsInterest[$savInterestRate]->npk)}}{{number_format(@$migSavingsInterest[$savInterestRate]->{$savingsProductSegment['field']})}}{{number_format(@$migSavingsInterest[$savInterestRate]->total_pksf)}}
Grand Total {{ number_format($othersFund_interestPaid,$round)}}{{ number_format(${'pksfFund_'.$savingsProductSegment['field'].'_interestPaid'}, $round)}}{{ number_format($totalPksf_interestPaid, $round)}} {{ number_format($mig_othersFund_interestPaid,$round)}}{{ number_format(${'mig_pksfFund_'.$savingsProductSegment['field'].'_interestPaid'}, $round)}}{{ number_format($mig_totalPksf_interestPaid, $round)}}