@php $totalAmount = 0; $totalBill = 0; $third_party_cost = 0; $bandwidth_cost = 0; $entertainment_cost = 0; $bandwith = 0; $facebook = 0; $youtube = 0; $bdix = 0; $dataMB = 0; $totalBandwithG = 0; @endphp @foreach ($result as $key => $data) @php $cost = $data->third_party_cost + $data->bandwidth_cost + $data->entertainment_cost; $totalAmount += $data->total_amount - $cost; $third_party_cost += $data->third_party_cost; $bandwidth_cost += $data->bandwidth_cost; $entertainment_cost += $data->entertainment_cost; $totalBill += $data->total_amount; $totalBandwith = $data->bandwith + $data->facebook + $data->youtube + $data->bdix + $data->data; $bandwith += $data->bandwith; $facebook += $data->facebook; $youtube += $data->youtube; $bdix += $data->bdix; $dataMB += $data->data; $totalBandwithG += $totalBandwith; @endphp @endforeach

SL	Month	Customer	Address	KAM	Internet	Facebook	Youtube	BDIX	Data	Total Bandwidth	Bill	Third Party Cost	Bandwidth Cost	Commission Cost	Profit
{{ $key+1 }}	{{ date('M',strtotime($data->billing_starting_date)) }}	{{ $data->company_name }}	{{ $data->billing_address }}	{{ $data->name }}	{{ $data->bandwith != "" ? $data->bandwith : "0" }} MB	{{ $data->facebook != "" ? $data->facebook : "0" }} MB	{{ $data->youtube != "" ? $data->youtube : "0" }} MB	{{ $data->bdix != "" ? $data->bdix : "0" }} MB	{{ $data->data != "" ? $data->data : "0" }} MB	{{ $totalBandwith }} MB	{{ number_format($data->total_amount) }}	{{ number_format($data->third_party_cost) }}	{{ number_format($data->bandwidth_cost) }}	{{ number_format($data->entertainment_cost) }}	{{ number_format($data->total_amount - $cost) }}
Total :					{{ $bandwith }} MB	{{ $facebook }} MB	{{ $youtube }} MB	{{ $bdix }} MB	{{ $dataMB }} MB	{{ $totalBandwithG }} MB	{{ number_format($totalBill) }}	{{ number_format($third_party_cost) }}	{{ number_format($bandwidth_cost) }}	{{ number_format($entertainment_cost) }}	{{ number_format($totalAmount) }}