@forelse($data as $key => $val) @php $onRoadPrice = $val->on_road_price ?? 0; $less_discount = ($val->finance_discount ?? 0) + ($val->way_off ?? 0) + ($val->foc_accessories ?? 0) + ($val->offer_ib_amount ?? 0) + ($val->offer_kin_amount ?? 0); $after_dis_road_price = $onRoadPrice - $less_discount; $booking_amount = $val->booking_amount ?? 0; $dp_amount = $val->dp_amount ?? 0; $net_disbursement = $val->net_disbusment ?? 0; $exchange_amount = $val->total_exchange_amount ?? 0; $total = $booking_amount + $dp_amount + $net_disbursement + $exchange_amount; $receivable_amt = $after_dis_road_price - $total; // Grand Totals $grand_on_road_price += $onRoadPrice; $grand_less_discount += $less_discount; $grand_after_discount_price += $after_dis_road_price; $grand_booking_amount += $booking_amount; $grand_dp_amount += $dp_amount; $grand_net_disbursement += $net_disbursement; $grand_exchange_amount += $exchange_amount; $grand_total_received += $total; $grand_receivable_amt += $receivable_amt; @endphp @empty @endforelse

ID	Booking Date	Branch	Team Leader	KEC Name	Customer Name	Model	Varient	Fuel Type	Exterior Color	Interior Color	MFG. Year	VIN No.	On Road Price (A)	Less Discount (B)	After Disc On Road Price (A-B = C)	Booking Amount	DP Amount	Fin. Disbusement Amt	Exchange	Total (D)	Net Receivable Amt. (C - D)
{{ $key+1 }}	{{ \Carbon\Carbon::parse($val->booking_date)->format('d-m-Y H:i:s') ?? '' }}	{{ $val->branch_name ?? '' }}	{{ $val->team_name ?? '' }}	{{ $val->sales_person_name ?? '' }}	{{ $val->customer_name ?? '' }}	{{ $val->product ?? '' }}	{{ $val->car_varient_name ?? '' }}	{{ $val->fuel_type_name ?? '' }}	{{ $val->exterior_color ?? '' }}	{{ $val->interior_color ?? '' }}	{{ $val->manufacturing_year ?? '' }}	{{ $val->vin_number ?? '' }}	{{ $onRoadPrice }}	{{ $less_discount }}	{{ $after_dis_road_price }}	{{ $booking_amount }}	{{ $dp_amount }}	{{ $net_disbursement }}	{{ $exchange_amount }}	{{ $total }}	{{ $receivable_amt }}
No booking found
Total													{{ $grand_on_road_price }}	{{ $grand_less_discount }}	{{ $grand_after_discount_price }}	{{ $grand_booking_amount }}	{{ $grand_dp_amount }}	{{ $grand_net_disbursement }}	{{ $grand_exchange_amount }}	{{ $grand_total_received }}	{{ $grand_receivable_amt }}