@foreach($branch as $b) @php $sl = 1; $branch_accounts = $accounts->where('branchIdFk', $b->id); $branchBalance = 0; $branchBalanceInterest = 0; $branchInterest = 0; $branchRefundable = 0; @endphp @foreach($branch_accounts as $v) @php $acc_interest = $interest[$v->id]; $openingBalance = $acc_interest['openingBalance']; $softBalance = $acc_interest['softBalance']; $disburseInterest = $acc_interest['disburseInterest']; $balance = $acc_interest['balance']; $depositNumber = $acc_interest['depositNumber']; $balanceInterest = $acc_interest['balanceInterest']; $interest_amount = $acc_interest['interest_amount']; $refundable = $balance+$balanceInterest+$interest_amount; $branchBalance += $balance; $branchBalanceInterest += $balanceInterest; $branchInterest += $interest_amount; $branchRefundable += $refundable; @endphp @endforeach @if(sizeof($branch_accounts) > 1) @endif @endforeach

SL	Member Name	Savings Code	Period	Acc. Opening Date	Acc. Matured Date	Auto Process Amount	Balance					Deposit Number	Provision		Total Refundable	Area Manager Passbook & Software Deposit Checked & Approve	Approve By
							Opening Balance (Up to {{date('M-Y',strtotime($softwareStartDate))}})	{{date('M-Y',strtotime("+1 month", strtotime(date('Y-m', strtotime($softwareStartDate))))) }} to {{date('M-Y',strtotime($filDate))}}	Total Deposit	Interest	Total		Present Provision	Provisionable
{{sprintf("%03d", $b->branchCode)}} - {{$b->name}}
{{ $sl++ }}	{{ $member[$v->memberIdFk]->member_name }}	{{ $acc_interest['account']->savingsCode }}	{{ $acc_interest['period'] }}	{{ date('d-m-Y', strtotime($acc_interest['account']->accountOpeningDate)) }}	{{ date('d-m-Y', strtotime($acc_interest['account']->accountMatureDate)) }}	@if($v->depositTypeIdFk == 4) {{$acc_interest['account']->fixedDepositAmount }} @else {{ $acc_interest['account']->autoProcessAmount }} @endif	{{ number_format($openingBalance,2) }}	{{ number_format($softBalance,2) }}	{{ number_format($softBalance+$openingBalance,2) }}	{{ number_format($disburseInterest,2) }}	{{ number_format($balance,2) }}	{{ $depositNumber }}	{{ number_format($balanceInterest,2) }}	{{ number_format($interest_amount,2) }}	{{ number_format($refundable,2) }}	@if($product[$acc_interest['account']->savingsProductIdFk]->isNeedApproveToClose && $v->authorizeUserId == null) @endif @if($product[$acc_interest['account']->savingsProductIdFk]->isNeedApproveToClose && $v->authorizeUserId != null && $userBranchId == 1 && $v->closingDate == "0000-00-00") @endif	@if($product[$acc_interest['account']->savingsProductIdFk]->isNeedApproveToClose && $v->authorizeUserId != null) {{$v->approve_by}} @endif
Total											{{ number_format($branchBalance,2) }}		{{ number_format($branchBalanceInterest,2) }}	{{ number_format($branchInterest,2) }}	{{ number_format($branchRefundable,2) }}