{{-- table for product transfer --}} @if($reportType == 'Product Transfer') @foreach($savingsProducts as $product) @endforeach @php $Count = 0; $totalWS = 0; $totalMS = 0; $totalSS = 0; $totalOTS = 0; @endphp @if (sizeof($allTransferredProducts)>0) @foreach($allTransferredProducts as $transferredProduct) @php $Count = $Count + 1; $branchInfo = $branchInfos->where('id', $transferredProduct->branchIdFk)->first(); $samityInfo = $samityInfos->where('id', $transferredProduct->samityIdFk)->first(); $memberInfo = $memberInfos->where('id', $transferredProduct->memberIdFk)->first(); $savingsInfoStr = $transferredProduct->savingsRecord; $savingsRecordArr = collect(json_decode($savingsInfoStr)); $weeklySavingsBalance = $savingsRecordArr->where('savingsProductId', 1)->sum('balance'); $monthlySavingsBalance = $savingsRecordArr->where('savingsProductId', 2)->sum('balance'); $sommridhySavingsBalance = $savingsRecordArr->where('savingsProductId', 3)->sum('balance'); $oneTimeSavingsBalance = $savingsRecordArr->where('savingsProductId', 4)->sum('balance'); @endphp @php $totalWS += $weeklySavingsBalance; $totalMS += $monthlySavingsBalance; $totalSS += $sommridhySavingsBalance; $totalOTS += $oneTimeSavingsBalance; @endphp @endforeach @else @endif {{-- table for samity transfer --}} @elseif($reportType == 'Samity Transfer') @foreach($savingsProducts as $product) @endforeach @php $Count = 0; $totalWS = 0; $totalMS = 0; $totalSS = 0; $totalOTS = 0; @endphp @if (sizeof($allSamityTransferred)>0) @foreach($allSamityTransferred as $samityTransferred) @php $Count = $Count + 1; $branchInfo = $branchInfos->where('id', $samityTransferred->branchIdFk)->first(); $oldSamityInfo = $oldSamityInfos->where('id', $samityTransferred->previousSamityIdFk)->first(); $newSamityInfo = $newSamityInfos->where('id', $samityTransferred->newSamityIdFk)->first(); $memberInfo = $memberInfos->where('id', $samityTransferred->memberIdFk)->first(); $savingsInfoStr = $samityTransferred->savingsRecord; $savingsRecordArr = collect(json_decode($savingsInfoStr)); $weeklySavingsBalance = $savingsRecordArr->where('savingsProductId', 1)->sum('balance'); $monthlySavingsBalance = $savingsRecordArr->where('savingsProductId', 2)->sum('balance'); $sommridhySavingsBalance = $savingsRecordArr->where('savingsProductId', 3)->sum('balance'); $oneTimeSavingsBalance = $savingsRecordArr->where('savingsProductId', 4)->sum('balance'); @endphp @php $totalWS += $weeklySavingsBalance; $totalMS += $monthlySavingsBalance; $totalSS += $sommridhySavingsBalance; $totalOTS += $oneTimeSavingsBalance; @endphp @endforeach @else @endif {{-- table for Branch transfer --}} @elseif($reportType == 'Branch Transfer') @foreach($savingsProducts as $product) @endforeach @php $Count = 0; $totalWS = 0; $totalMS = 0; $totalSS = 0; $totalOTS = 0; @endphp @if (sizeof($allBranchTransferred)>0) @foreach($allBranchTransferred as $branchTransferred) @php $Count = $Count + 1; $oldBranchInfo = $oldBranchInfos->where('id', $branchTransferred->previousBranchIdFk)->first(); $newBranchInfo = $newBranchInfos->where('id', $branchTransferred->newBranchIdFk)->first(); $oldSamityInfo = $oldSamityInfos->where('id', $branchTransferred->previousSamityIdFk)->first(); $newSamityInfo = $newSamityInfos->where('id', $branchTransferred->newSamityIdFk)->first(); $memberInfo = $memberInfos->where('id', $branchTransferred->memberIdFk)->first(); $savingsInfoStr = $branchTransferred->savingsRecord; $savingsRecordArr = collect(json_decode($savingsInfoStr)); $weeklySavingsBalance = $savingsRecordArr->where('savingsProductId', 1)->sum('balance'); $monthlySavingsBalance = $savingsRecordArr->where('savingsProductId', 2)->sum('balance'); $sommridhySavingsBalance = $savingsRecordArr->where('savingsProductId', 3)->sum('balance'); $oneTimeSavingsBalance = $savingsRecordArr->where('savingsProductId', 4)->sum('balance'); @endphp @php $totalWS += $weeklySavingsBalance; $totalMS += $monthlySavingsBalance; $totalSS += $sommridhySavingsBalance; $totalOTS += $oneTimeSavingsBalance; @endphp @endforeach @else @endif @endif {{-- report type condition closed --}}

SL. No.	Date	Branch Name	Samity Name	Member Name	Member Code	Savings Balance				Remarks
						{{ $product->code }} - {{ $product->shortName }}
{{ $Count }}	{{ $transferredProduct->transferDate }}	{{ str_pad($branchInfo->branchCode, 3, '0', STR_PAD_LEFT) }} - {{ $branchInfo->name }}	{{ $samityInfo->code }} - {{ $samityInfo->name }}	{{ $memberInfo->name }}	{{ $memberInfo->code }}	{{ number_format($weeklySavingsBalance, 2) }}	{{ number_format($monthlySavingsBalance, 2) }}	{{ number_format($sommridhySavingsBalance, 2) }}	{{ number_format($oneTimeSavingsBalance, 2) }}
Total						{{ number_format($totalWS, 2) }}	{{ number_format($totalMS, 2) }}	{{ number_format($totalSS, 2) }}	{{ number_format($totalOTS, 2) }}
											NO DATA FOUND !
SL. No.	Date	Branch Name	Previous Samity	Current Samity	Member Name	Previous Member Code	Current Member Code	Savings Balance				Remarks
								{{ $product->code }} - {{ $product->shortName }}
{{$Count}}	{{ $samityTransferred->transferDate }}	{{ str_pad($branchInfo->branchCode, 3, '0', STR_PAD_LEFT) }} - {{ $branchInfo->name }}	{{ $oldSamityInfo->code }} - {{ $oldSamityInfo->name }}	{{ $newSamityInfo->code }} - {{ $newSamityInfo->name }}	{{ $memberInfo->name }}	{{ $samityTransferred->previousMemberCodeFk }}	{{ $samityTransferred->newMemberCodeFk }}	{{ number_format($weeklySavingsBalance, 2) }}	{{ number_format($monthlySavingsBalance, 2) }}	{{ number_format($sommridhySavingsBalance, 2) }}	{{ number_format($oneTimeSavingsBalance, 2) }}
Total								{{ number_format($totalWS, 2) }}	{{ number_format($totalMS, 2) }}	{{ number_format($totalSS, 2) }}	{{ number_format($totalOTS, 2) }}
													NO DATA FOUND !
SL. No.	Date	Current Branch	Previous Branch	Previous Samity	Current Samity	Member Name	Previous Member Code	Current Member Code	Savings Balance				Remarks
									{{ $product->code }} - {{ $product->shortName }}
{{$Count}}	{{ $branchTransferred->transferDate }}	{{ str_pad($oldBranchInfo->branchCode, 3, '0', STR_PAD_LEFT) }} - {{ $oldBranchInfo->name }}	{{ str_pad($newBranchInfo->branchCode, 3, '0', STR_PAD_LEFT) }} - {{ $newBranchInfo->name }}	{{ $oldSamityInfo->code }} - {{ $oldSamityInfo->name }}	{{ $newSamityInfo->code }} - {{ $newSamityInfo->name }}	{{ $memberInfo->name }}	{{ $branchTransferred->previousMemberCodeFk }}	{{ $branchTransferred->newMemberCodeFk }}	{{ number_format($weeklySavingsBalance, 2) }}	{{ number_format($monthlySavingsBalance, 2) }}	{{ number_format($sommridhySavingsBalance, 2) }}	{{ number_format($oneTimeSavingsBalance, 2) }}
Total									{{ number_format($totalWS, 2) }}	{{ number_format($totalMS, 2) }}	{{ number_format($totalSS, 2) }}	{{ number_format($totalOTS, 2) }}
														NO DATA FOUND !