@if($filterby == 'bill') @endif @if($filterby == 'bill') @else @endif @php $gtotalorder = $gtotalamount = $gtotalamountlast = $gtotalmrp = $gclearence = $gdiscount = $gspsdiscount = $gtotalitms = 0 ; $i= 1;@endphp @if(!empty($orders)) @foreach($orders as $key => $order) @php $gtotalmrp = $gtotalmrp + $order['totalmrp']; $gtotalamount = $gtotalamount + $order['totalamount']; $gtotalitms = $gtotalitms + $order['totalitms']; $gclearence = $gclearence + $order['clearence']; $gdiscount = $gdiscount + $order['discount']; $gspsdiscount = $gspsdiscount + $order['SPSdiscount']; @endphp @if($filterby == 'bill') @endif @php $i++; @endphp @endforeach @if($filterby == 'bill') @else @endif @endif

S.No	Customer Name	Mobile Number	Store	Registration Date	SPS Plan	Bill Date	Total Bill	Total Mrp	Total Items	Total clearence	Total discount	Total SPSdiscount	Total Amount	200 Voucher	250 Voucher	400 Voucher	450 Voucher
{{ $i}}	{{$order['customer_name']}}	{{$order['mobile_number']}}	{{$order['store_id']}}	{{$order['plan_date']}}	{{$order['plan_name']}}	{{$order['bill_date']}}	{{ number_format((float)$order['totalmrp'], 2, '.', '') }}	{{$order['totalitms']}}	{{ number_format((float)$order['clearence'], 2, '.', '') }}	{{ number_format((float)$order['discount'], 2, '.', '') }}	{{ number_format((float)$order['SPSdiscount'], 2, '.', '') }}	{{ number_format((float)$order['totalamount'], 2, '.', '') }}	{{$order['coupon_200']}}	{{$order['coupon_250']}}	{{$order['coupon_400']}}	{{$order['coupon_450']}}
													{{round($gtotalmrp)}}	{{round($gtotalitms)}}	{{round($gclearence)}}	{{round($gdiscount)}}	{{round($gspsdiscount)}}	{{round($gtotalamount)}}