--}} @php // if (sizeof($MemberLists)>0) { // $a = sizeof($MemberLists); // $SizeOfMemberList = $a; // } // else { // $SizeOfMemberList = 1; // } $SizeOfRow = 0; // foreach ($MemberAdvDueListArrays as $key1 => $MemberAdvDueListArray){ // $SizeOfRow = sizeof($MemberAdvDueListArray); // echo $SizeOfRow; // foreach ($MemberAdvDueListArray as $key2 => $MemberAdvDueListArrayss){ // } // } $SizeOfRow = sizeof($MemberAdvDueListArrays); // echo $SizeOfRow; $MemberName = ''; $MemberName1 = ''; $MemberName2 = ''; // echo $SizeOfMemberList; $SamityLoopCount = 0; $MemberLoopTracker = 0; $MemberSamityCount = 0; $BRowSpan = 0; $X = 0; $Z1 = 0; $MemberKeyRecoverable = 0; $MemberKeyRecovery = 0; $SamityNameTracker = ''; $MemberKeyRecoverable1 = 0; $MemberKeyRecovery1 = 0; $SubTotal1 = 0; $SubTotal2 = 0; $SubTotal3 = 0; $SubTotal4 = 0; $SubTotal5 = 0; $SubTotal6 = 0; $SubTotal7 = 0; $SubTotal8 = 0; $Total1 = 0; $Total2 = 0; $Total3 = 0; $Total4 = 0; $Total5 = 0; $Total6 = 0; $Total7 = 0; $Total8 = 0; $SubTotalCounter = 0; @endphp {{-- If User is not requested for all samity information --}} @if ($RequestSamity != 'all') @if ($SizeOfRow > 0) @foreach ($SamityInfos as $key => $SamityInfo) @endforeach @foreach ($MemberAdvDueListArrays as $key1 => $MemberAdvDueListArray) @foreach ($MemberAdvDueListArray as $key2 => $MemberAdvDueListArrayss) @foreach ($MemberLists as $key3 => $MemberList) @if ($MemberList->memberId == $key1) @if ($MemberName != $MemberList->memberId) @php $MemberName = $MemberList->memberId; @endphp @foreach ($MemberLoanInstallmentAmounts as $key4 => $MemberLoanInstallmentAmount) @php // opening balance collection $loanOpeningBalanceAmount = 0; if ($loanOpeningBalance->count() > 0) { $loanOpeningBalanceAmount = $loanOpeningBalance ->where('samityIdFk', $SamityInfo->id) ->where('memberIdFk', $MemberList->memberId) ->where('loanIdFk', $MemberList->id) ->first(); if($loanOpeningBalanceAmount){ $loanOpeningBalanceAmount = $loanOpeningBalanceAmount->paidLoanAmountOB; } } @endphp @if ($key1 == $key4) @php $SubTotal1 = $SubTotal1 + $MemberLoanInstallmentAmount - $loanOpeningBalanceAmount; @endphp @endif @endforeach @foreach ($MemberLoanCollectionAmounts as $key5 => $MemberLoanCollectionAmount) @if ($key1 == $key5) @php $SubTotal2 = $SubTotal2 + $MemberLoanCollectionAmount; @endphp @endif @endforeach @if ($key2 == 'Due') @php $SubTotal3 = $SubTotal3 + $MemberAdvDueListArrayss; @endphp @elseif ($key2 == 'Adv') @php $SubTotal4 = $SubTotal4 + $MemberAdvDueListArrayss; @endphp @endif @endif @if ($MemberName1 != $MemberList->memberId) @php $MemberName1 = $MemberList->memberId; @endphp @foreach ($MemberLoanInstallmentAmountsOnlyPrincipals as $key6 => $MemberLoanInstallmentAmountsOnlyPrincipal) @php // opening balance collection $loanOpeningPrincipalAmount = 0; if ($loanOpeningBalance->count() > 0) { $loanOpeningPrincipalAmount = $loanOpeningBalance ->where('samityIdFk', $SamityInfo->id) ->where('memberIdFk', $MemberList->memberId) ->where('loanIdFk', $MemberList->id) ->first(); if($loanOpeningPrincipalAmount){ $loanOpeningPrincipalAmount = $loanOpeningPrincipalAmount->principalAmountOB; } } @endphp @if ($key1 == $key6) @php $SubTotal5 = $SubTotal5 + $MemberLoanInstallmentAmountsOnlyPrincipal - $loanOpeningPrincipalAmount; @endphp @endif @endforeach @foreach ($MemberLoanCollectionAmountsOnlyPrincipals as $key7 => $MemberLoanCollectionAmountsOnlyPrincipal) @if ($key1 == $key7) @php $SubTotal6 = $SubTotal6 + $MemberLoanCollectionAmountsOnlyPrincipal; @endphp @endif @endforeach @endif @if ($MemberName2 != $MemberList->memberId) @php $MemberName2 = $MemberList->memberId; @endphp @foreach ($MargedAdvDueListArrays as $key8 => $MargedAdvDueListArray) @foreach ($MargedAdvDueListArray as $key9 => $MargedAdvDueListArrayss) @if ($key1 == $key8) @if ($key9 == 'Due') @php $SubTotal7 = $SubTotal7 + $MargedAdvDueListArrayss; @endphp @break @elseif ($key9 == 'Adv') @php $SubTotal8 = $SubTotal8 + $MargedAdvDueListArrayss; // echo $SubTotal8; @endphp @break @endif @endif @endforeach @endforeach @endif @endif @endforeach @endforeach @endforeach @php $Total1 = $Total1 + $SubTotal1; $Total2 = $Total2 + $SubTotal2; $Total3 = $Total3 + $SubTotal3; $Total4 = $Total4 + $SubTotal4; $Total5 = $Total5 + $SubTotal5; $Total6 = $Total6 + $SubTotal6; $Total7 = $Total7 + $SubTotal7; $Total8 = $Total8 + $SubTotal8; $SubTotal1 = 0; $SubTotal2 = 0; $SubTotal3 = 0; $SubTotal4 = 0; $SubTotal5 = 0; $SubTotal6 = 0; $SubTotal7 = 0; $SubTotal8 = 0; @endphp @endif {{-- If User is requested for all samity information --}} @elseif ($RequestSamity == 'all') @foreach ($MemberLists as $key => $MemberList1) @foreach ($MemberList1 as $key => $MemberList) @php $BRowSpan = sizeof($MemberList1); // echo $B; @endphp @endforeach @endforeach @foreach ($SamityInfos as $key => $SamityInfo) @foreach ($MemberLists as $keyX => $MemberList1) @foreach ($MemberList1 as $keyY => $MemberList) @if ($SamityLoopCount == $MemberSamityCount and $keyX == $SamityInfo->id) @php // $BRowSpan = sizeof($MemberList1); // $MemberList // echo $B; @endphp {{-- --}} @php $SamityLoopCount = $SamityLoopCount + 1; $MemberLoopTracker = 1; @endphp @endif @endforeach @endforeach @foreach ($MemberAdvDueListArrays as $key1 => $MemberAdvDueListArray) @foreach ($MemberAdvDueListArray as $key2 => $MemberAdvDueListArrayss) @if ($SamityInfo->id == $key1 and $SamityNameTracker != $SamityInfo->name) @php $BRowSpan = sizeof($MemberAdvDueListArray); $SamityNameTracker = $SamityInfo->name; $SubTotalCounter = 1; @endphp {{-- --}} {{-- --}} @endif {{-- @foreach ($MemberAdvDueListArrays1 as $keyA => $MemberAdvDueListArrayss) --}} {{-- @if ($SamityInfo->id == $key1) --}} @foreach ($MemberLists as $key3 => $MemberList1) @foreach ($MemberList1 as $keyZ => $MemberList) @php // echo $MemberList->name; // $YY = strlen($key2); // $ZZ = $MemberList->memberId; $YY = explode('/', $key2); $ZZ = end($YY); @endphp {{-- @if ($SamityInfo->id == $key3 and substr_compare($key2,$ZZ,4) and $X < $BRowSpan) --}} @if ($SamityInfo->id == $key3 and $ZZ == $MemberList->memberId) {{-- {{$MemberList->name}} --}} {{-- --}} @if ($MemberName != $MemberList->memberId) @php $MemberName = $MemberList->memberId; @endphp @if ($MemberLoopTracker == 1) @php $MemberSamityCount = $MemberSamityCount + 1; $MemberLoopTracker = 0; @endphp @endif @foreach ($MemberLoanInstallmentAmounts as $key4 => $MemberLoanInstallmentAmount1) @foreach ($MemberLoanInstallmentAmount1 as $keyB => $MemberLoanInstallmentAmount) @php // opening balance collection $loanOpeningBalanceAmount = 0; if ($loanOpeningBalance->count() > 0) { $loanOpeningBalanceAmount = $loanOpeningBalance ->where('samityIdFk', $SamityInfo->id) ->where('memberIdFk', $MemberList->memberId) ->where('loanIdFk', $MemberList->id) ->first(); if($loanOpeningBalanceAmount){ $loanOpeningBalanceAmount->paidLoanAmountOB; } } @endphp @if ($key1 == $key4 and $ZZ == $keyB and $MemberKeyRecoverable != $keyB) @php $SubTotal1 = $SubTotal1 + $MemberLoanInstallmentAmount - $loanOpeningBalanceAmount; $MemberKeyRecoverable = $keyB; @endphp @break; @endif @endforeach @endforeach @foreach ($MemberLoanCollectionAmounts as $key5 => $MemberLoanCollectionAmount1) @foreach ($MemberLoanCollectionAmount1 as $keyC => $MemberLoanCollectionAmount) @if ($key1 == $key5 and $ZZ == $keyC and $MemberKeyRecovery != $keyC) @php $SubTotal2 = $SubTotal2 + $MemberLoanCollectionAmount; $MemberKeyRecovery = $keyC; @endphp @break; @endif @endforeach @endforeach @endif {{-- --}} @php $Comp = explode('/', $key2); list($first, $last) = $Comp; // $Comp1 = current($Comp); // echo $first; @endphp @if ($first == 'Due') @php $SubTotal3 = $SubTotal3 + $MemberAdvDueListArrayss; @endphp @elseif ($first == 'Adv') @php $SubTotal4 = $SubTotal4 + $MemberAdvDueListArrayss; @endphp @endif @if ($MemberName1 != $MemberList->memberId) @php $MemberName1 = $MemberList->memberId; @endphp @foreach ($MemberLoanInstallmentAmountsOnlyPrincipals as $key6 => $MemberLoanInstallmentAmountsOnlyPrincipalss) @foreach ($MemberLoanInstallmentAmountsOnlyPrincipalss as $keyD => $MemberLoanInstallmentAmountsOnlyPrincipal) @php // opening balance collection $loanOpeningPrincipalAmount = 0; if ($loanOpeningBalance->count() > 0) { $loanOpeningPrincipalAmount = $loanOpeningBalance ->where('samityIdFk', $SamityInfo->id) ->where('memberIdFk', $MemberList->memberId) ->where('loanIdFk', $MemberList->id) ->first(); if($loanOpeningPrincipalAmount){ $loanOpeningPrincipalAmount = $loanOpeningPrincipalAmount->principalAmountOB; } } @endphp @if ($key1 == $key6 and $ZZ == $keyD and $MemberKeyRecoverable1 != $keyD) @php $SubTotal5 = $SubTotal5 + $MemberLoanInstallmentAmountsOnlyPrincipal - $loanOpeningPrincipalAmount; $MemberKeyRecoverable1 = $keyD; @endphp @endif @endforeach @endforeach @foreach ($MemberLoanCollectionAmountsOnlyPrincipals as $key7 => $MemberLoanCollectionAmountsOnlyPrincipalss) @foreach ($MemberLoanCollectionAmountsOnlyPrincipalss as $keyE => $MemberLoanCollectionAmountsOnlyPrincipal) @if ($key1 == $key7 and $ZZ == $keyE and $MemberKeyRecovery1 != $keyE) @php $SubTotal6 = $SubTotal6 + $MemberLoanCollectionAmountsOnlyPrincipal; $MemberKeyRecovery1 = $keyE; @endphp @endif @endforeach @endforeach @endif @if ($MemberName2 != $MemberList->memberId) @php $MemberName2 = $MemberList->memberId; @endphp @foreach ($MargedAdvDueListArrays as $key8 => $MargedAdvDueListArray) @foreach ($MargedAdvDueListArray as $key9 => $MargedAdvDueListArrayss) @php $Comp = explode('/', $key9); list($first, $last) = $Comp; // $Comp1 = current($Comp); // echo $first; @endphp @if ($key1 == $key8 and $key2 == $key9) @if ($first == 'Due') @php $SubTotal7 = $SubTotal7 + $MargedAdvDueListArrayss; @endphp @break @elseif ($first == 'Adv') @php $SubTotal8 = $SubTotal8 + $MargedAdvDueListArrayss; @endphp @break @endif @endif @endforeach @endforeach @endif @endif @endforeach @endforeach {{-- $MemberLists --}} {{-- @endif --}} {{-- @endforeach --}} @endforeach @endforeach {{-- $MemberAdvDueListArrays --}} @php $X = 0; @endphp @if ($SubTotalCounter == 1) @php $SubTotalCounter = $SubTotalCounter + 1; @endphp @endif @php $Total1 = $Total1 + $SubTotal1; $Total2 = $Total2 + $SubTotal2; $Total3 = $Total3 + $SubTotal3; $Total4 = $Total4 + $SubTotal4; $Total5 = $Total5 + $SubTotal5; $Total6 = $Total6 + $SubTotal6; $Total7 = $Total7 + $SubTotal7; $Total8 = $Total8 + $SubTotal8; $SubTotal1 = 0; $SubTotal2 = 0; $SubTotal3 = 0; $SubTotal4 = 0; $SubTotal5 = 0; $SubTotal6 = 0; $SubTotal7 = 0; $SubTotal8 = 0; @endphp @endforeach @endif

Samity	Member	Loan Code	Principle + Interest				Principle
			Recoverable	Recovery	Due	Advance	Recoverable	Recovery	Due	Advance
{{$SamityInfo->name}}
{{$MemberList->name}}	{{$MemberList->loanCode}}	{{number_format($MemberLoanInstallmentAmount - $loanOpeningBalanceAmount,2)}}	{{number_format($MemberLoanCollectionAmount,2)}}	{{number_format($MemberAdvDueListArrayss,2)}}	0.008888	0.002222	{{number_format($MemberAdvDueListArrayss,2)}}	{{number_format($MemberLoanInstallmentAmountsOnlyPrincipal - $loanOpeningPrincipalAmount,2)}}	{{number_format($MemberLoanCollectionAmountsOnlyPrincipal,2)}}	{{number_format($MargedAdvDueListArrayss,2)}}	0.00	0.00	{{number_format($MargedAdvDueListArrayss,2)}}
SubTotal			{{number_format($SubTotal1,2)}}	{{number_format($SubTotal2,2)}}	{{number_format($SubTotal3,2)}}	{{number_format($SubTotal4,2)}}	{{number_format($SubTotal5,2)}}	{{number_format($SubTotal6,2)}}	{{number_format($SubTotal7,2)}}	{{number_format($SubTotal8,2)}}
Total			{{number_format($Total1,2)}}	{{number_format($Total2,2)}}	{{number_format($Total3,2)}}	{{number_format($Total4,2)}}	{{number_format($Total5,2)}}	{{number_format($Total6,2)}}	{{number_format($Total7,2)}}	{{number_format($Total8,2)}}
{{$SamityInfo->name}}-{{$SamityInfo->id}}
{{$SamityInfo->name}}
{{$MemberList->name}}	{{$MemberList->loanCode}}	{{number_format($MemberLoanInstallmentAmount - $loanOpeningBalanceAmount,2)}}	{{number_format($MemberLoanCollectionAmount,2)}}
{{number_format($MemberAdvDueListArrayss,2)}}	0.00	0.00	{{number_format($MemberAdvDueListArrayss,2)}}	{{number_format($MemberLoanInstallmentAmountsOnlyPrincipal - $loanOpeningPrincipalAmount,2)}}	{{number_format($MemberLoanCollectionAmountsOnlyPrincipal,2)}}	{{number_format($MargedAdvDueListArrayss,2)}}	0.00	0.00	{{number_format($MargedAdvDueListArrayss,2)}}
SubTotal			{{number_format($SubTotal1,2)}}	{{number_format($SubTotal2,2)}}	{{number_format($SubTotal3,2)}}	{{number_format($SubTotal4,2)}}	{{number_format($SubTotal5,2)}}	{{number_format($SubTotal6,2)}}	{{number_format($SubTotal7,2)}}	{{number_format($SubTotal8,2)}}
Total			{{number_format($Total1,2)}}	{{number_format($Total2,2)}}	{{number_format($Total3,2)}}	{{number_format($Total4,2)}}	{{number_format($Total5,2)}}	{{number_format($Total6,2)}}	{{number_format($Total7,2)}}	{{number_format($Total8,2)}}