Junction Forex Bureau Money Transfer Report

Date range	{{$startDate}} - {{$endDate}}
Printed By	{{Auth::user()->name}}
Amount Sent	KES. {{number_format($totalSent)}}
Amount received	KES. {{number_format($totalPayout)}}

@foreach($sent as $tellerId => $transactions)

@foreach($transactions as $transaction) @endforeach {{-- Subtotal row --}}

Date	Transaction number	Customer	Recipient	Status		Gross		Customer charge		Tax		Amount sent	CountryTo
{{$transaction->created_at}}	{{$transaction->jfb_number}}	{{$transaction->customer->name??''}}	{{$transaction->recipient->name??''}}	{{$transaction->status??''}}	{{$transaction->currencyFrom->swiftcode??''}}	{{$transaction->amount_from}}	{{$transaction->commissionCurrency->swiftcode??''}}	{{$transaction->commission}}	{{$transaction->currencyFrom->swiftcode??''}}	{{$transaction->outbound_tax}}	{{$transaction->currencyFrom->swiftcode??''}}	{{$transaction->gross}}	{{$transaction->countryTo->name??''}}
Subtotal					{{ $transactions->first()->currencyFrom->swiftcode ?? '' }}	{{ number_format($transactions->sum('amount_from')) }}	{{ $transactions->first()->commissionCurrency->swiftcode ?? '' }}	{{ number_format($transactions->sum('commission')) }}	{{ $transactions->first()->currencyFrom->swiftcode ?? '' }}	{{ number_format($transactions->sum('outbound_tax')) }}	{{ $transactions->first()->currencyFrom->swiftcode ?? '' }}	{{ number_format($transactions->sum('gross')) }}

@endforeach

@foreach($payout as $tellerId => $transactions)

@foreach($transactions as $transaction) @endforeach {{-- Subtotal row --}}

Date	Transaction number	Customer	Recipient	Currency	Payout
{{$transaction->paid_at}}	{{$transaction->jfb_number}}	{{$transaction->customer->name??''}}	{{$transaction->recipient->name??''}}	{{$transaction->currencyTo->swiftcode??''}}	{{$transaction->amount_to}}
Subtotal				{{ $transactions->first()->currencyTo->swiftcode ?? '' }}	{{ number_format($transactions->sum('amount_to')) }}

@endforeach