@if(!empty($ordersdata)) @php $gtotalCash = $gtotalQty = $gtotalbill = $gtotalmrp = $gtotalsps = $gtotalOffer = $gtotalvocher = $gotherOffer = $gtotalreward = $gtotal = $gtotalbill5 = $gtotalbill7 = $gtotalbill10 = $gtotalSuits = $gtotalBottom = $gtotalacceess = $gtotaljewelery = $averaguabv = $averagasp = $averagupt = $gtotalSPS = 0.00; @endphp @foreach($ordersdata as $key => $order) @php $totalTotal = $otherOffer = $clearence = 0; $totalTotal += $order['totalCash'] + $order['totalCard'] + $order['totalUpi'] + $order['totalWallet'] + $order['totalCn'] + $order['totalGv'] ; $gtotalQty += $order['totalQty']; $gtotalSPS += $order['spscount']; $gtotalbill += $order['totalBill']; $gotherOffer += $order['otherOffer']; $gtotalOffer += $order['clearence']; $averagupt += $order['upt']; $abv= $totalTotal/ $order['totalBill']; $averaguabv += $abv; $asp = $totalTotal/ $order['totalQty']; $averagasp += $asp; $gtotalmrp += $order['totalMrp']; $gtotalsps += $order['totalSpsDiscount']; $gtotalvocher += $order['voucher']; $gtotalreward += $order['totalreward']; $gtotal += $totalTotal; $gtotalbill5 += $order['bill5']; $gtotalbill7 += $order['bill7']; $gtotalbill10 += $order['bill10']; $gtotalSuits += $order['Suits']; $gtotalBottom += $order['Bottom']; $gtotalacceess += $order['acceess']; $gtotaljewelery += $order['jewelery']; @endphp @endforeach @php $aupt=$averagupt/$order['totalstore']; $aabv=$averaguabv/$order['totalstore']; $aasp=$averagasp/$order['totalstore']; @endphp @endif

Date	Day	Store Location	Foot fall	Repeat	New	Total NOB	QTY	UPT	ABV	ASP	Target	SPS	MRP	SPS Discount	Clearence Discount	Other Offer Discount	Gift Vouchers	Reward Points	Realised sale	ACH%	CONV%	4999 - 7499	7500 - 9999	10000 above	Upper	Suit Sets	Bottom	Home	Accessory	Jewellery
{{$order['date']}}	{{date('l', strtotime($order['date']))}}	{{$order['store']}}	0	0	0	{{$order['totalBill']}}	{{$order['totalQty']}}	{{number_format($order['upt'],3)}}	{{number_format($abv,3)}}	{{number_format($asp,3)}}	0	{{$order['spscount']}}	{{$order['totalMrp']}}	{{$order['totalSpsDiscount']}}	{{$order['clearence']}}	{{$order['otherOffer']}}	{{$order['voucher']}}	{{$order['totalreward']}}	{{$totalTotal}}	0	0	{{$order['bill5']}}	{{$order['bill7']}}	{{$order['bill10']}}	0	{{!empty($order['Suits']) ? $order['Suits'] : 0 }}	{{ !empty($order['Bottom']) ? $order['Bottom'] : 0 }}	0	{{!empty($order['acceess']) ? $order['acceess'] :0 }}	{{ !empty($order['jewelery']) ? $order['jewelery'] : 0 }}
			0	0	0	{{$gtotalbill}}	{{$gtotalQty}}	{{number_format($aupt,3)}}	{{number_format($aabv,3)}}	{{number_format($aasp,3)}}	0	{{$gtotalSPS }}	{{$gtotalmrp}}	{{$gtotalsps}}	{{$gtotalOffer}}	{{$gotherOffer}}	{{$gtotalvocher}}	{{$gtotalreward}}	{{$gtotal}}	0	0	{{$gtotalbill5}}	{{$gtotalbill7}}	{{$gtotalbill10}}	0	{{$gtotalSuits}}	{{$gtotalBottom}}	0	{{$gtotalacceess}}	{{$gtotaljewelery}}