@php $currentMemberId = isset($savings[0]) ? $savings[0]->memberIdFk : 0; $isMemberChanged = 0; $memberIndex = 1; $totalBalance = 0; @endphp @foreach($savings as $key => $saving) @php if ($currentMemberId != $saving->memberIdFk) { $currentMemberId = $saving->memberIdFk; $isMemberChanged = 1; } else{ $isMemberChanged = 0; } if ($key==0 || $isMemberChanged==1) { $memberCode = $members->where('id',$saving->memberIdFk)->first()->code; $memberName = $members->where('id',$saving->memberIdFk)->first()->name; $rowSpan = $savings->where('memberIdFk',$saving->memberIdFk)->count(); } /// get info $depositAmount = $balanceInfo->where('accountId', $saving->id)->sum('depositAmount'); $interestAmount = $balanceInfo->where('accountId', $saving->id)->sum('interestAmount'); $withdrawAmount = $balanceInfo->where('accountId', $saving->id)->sum('withdrawAmount'); $totalBalance += $depositAmount + $interestAmount - $withdrawAmount; @endphp @if($key==0 || $isMemberChanged==1) @php $memberIndex++; @endphp @endif @endforeach

SL#	Member Code	Member Name	Savings Code	Deposit	Interest Amount	Refund	Balance	Action
{{$memberIndex}}	{{$memberCode}}	{{$memberName}}	{{$saving->savingsCode}}	{{number_format($depositAmount,2)}}	{{number_format($interestAmount,2)}}	{{number_format($withdrawAmount,2)}}	{{number_format($depositAmount + $interestAmount - $withdrawAmount,2)}}
Total							{{number_format($totalBalance,2)}}