@php $agent = []; @endphp @foreach($bookings as $index=>$booking) @php $agent[$booking->agent->name]['name'] = $booking->agent->name; $agent[$booking->agent->name]['address'] = $booking->agent->address; $agent[$booking->agent->name]['amount'] = isset($agent[$booking->agent->name]['amount']) ? $agent[$booking->agent->name]['amount']+$booking->fare : $booking->fare; @endphp @endforeach

SN	Agent	Agent #	Route#:	Sub Route#:	booking_date:	Trip Date:	Passenger:	Passenger#:	reference#:	fare:
{{++$index}}	{{$booking->agent->name}}	{{$booking->agent->msisdn}}	{{$booking->sub_route->r->startPointCity->city}} - {{$booking->sub_route->r->endPointCity->city}}	{{$booking->sub_route->pointA}} - {{$booking->sub_route->pointB}}	{{$booking->booking_date}}	{{$booking->schedule->trip_date}}	{{$booking->fullname}}	{{$booking->msisdn}}	{{$booking->reference}}	{{$booking->fare}}

@php($i =1) @foreach(collect($agent)->sortByDesc('amount')->all() as $index=>$agent) @php(++$i) @endforeach

SN	Agent	Address	Amount
{{$i}}	{{$agent['name']}}	{{$agent['address']}}	{{number_format($agent['amount'])}}