@php $sno = 1; @endphp @foreach($order as $row) @foreach ($row->billProducts as $k => $product) @php $total = $product->qty * $product->selling_price ; @endphp @endforeach @endforeach

S.No.	Order Id	store	BILL	Date	HSN	Section	Sub Section	Color	Size	Qty	Article	Name	Telephone	SPS	SPS On	MRP	SPS MRP	Discount	SPS Discount	Offer	Rate	CGST (%)	CGST Amt	SGST (%)	SGST Amt	Tax (%)	Tax Amt	Total (₹)
{{ $sno }}	{{ $row->id }}	{{ $row->store_name }}	{{ $row->bill_number }}	{{ \Helper::humanDate($row->bill_date) }}	{{ !empty($product->hsn) ? $product->hsn : 'N/A' }}	{{ !empty($product->warehouseProd) ? $product->warehouseProd->section : 'N/A' }}	{{ !empty($product->warehouseProd) ? $product->warehouseProd->subsection : 'N/A' }}	{{ $product->color }}	{{ $product->size }}	{{ $product->qty }}	{{ $product->article }}	{{ $row->firstname }} {{$row->lastname}}	{{ $row->telephone }}	{{ $row->sps_plan }}	{{ $row->sps_status }}	{{ $product->base_mrp }}	{{ $product->sps_mrp }}	{{ $product->discount_amt }}	{{ $product->sps_discount + $product->bday_discount + $product->ann_discount + $product->apt_discount }}	{{ $product->clearance_amt }}	{{ $product->selling_price }}	{{ $product->tax_per / 2 }}	{{ $product->cgst }}	{{ $product->tax_per / 2 }}	{{ $product->sgst }}	{{ $product->tax_per }}	{{ $product->tax_amt }}	{{ $total }}