@foreach($sizes as $size) @endforeach @php if(count($orders) > 0) { @endphp @php $gtotalTotal = $gtotalXS = $gtotalS = $gtotalL = $gtotalM = $gtotalXL = $gtotal2XL = $gtotal3XL = $gtotal4XL = $gtotal5XL = $gtotal6XL = $gtotal7XL = $gtotalFREE = $gtotalsales = $gtotaldiscount = 0.00; @endphp @foreach($orders as $key => $row) @php $totalTotal = 0; @endphp @php $article = \App\Article::select(['id','image','category_id','main_category_id'])->where('code',$row['article'])->first(); @endphp @php $totalTotal += $row['XS'] + $row['S'] + $row['L'] + $row['M'] + $row['XL'] + $row['2XL'] + $row['3XL'] + $row['4XL'] + $row['5XL'] + $row['6XL'] + $row['7XL'] + $row['FREE']; $gtotalTotal += $totalTotal; $gtotalXS += $row['XS']; $gtotalS += $row['S']; $gtotalL += $row['L']; $gtotalM += $row['M']; $gtotalXL += $row['XL']; $gtotal2XL += $row['2XL']; $gtotal3XL += $row['3XL']; $gtotal4XL += $row['4XL']; $gtotal5XL += $row['5XL']; $gtotal6XL += $row['6XL']; $gtotal7XL += $row['7XL']; $gtotalFREE += $row['FREE']; $gtotalsales += $row['sales']; $gtotaldiscount += $row['discount']; @endphp @endforeach @php } @endphp

Article	Color	Subsection	{{$size}}	Total	Mrp	Clearence (%)	Discount	Net Sales
{{ $row['article'] }}	{{ $row['color'] }}	{{ !empty($article->category) ? $article->category->name : '' }}	{{ $row['XS'] }}	{{ $row['S'] }}	{{ $row['M'] }}	{{ $row['L'] }}	{{ $row['XL'] }}	{{ $row['2XL'] }}	{{ $row['3XL'] }}	{{ $row['4XL'] }}	{{ $row['5XL'] }}	{{ $row['6XL'] }}	{{ $row['7XL'] }}	{{ $row['FREE'] }}	{{$totalTotal}}	{{ !empty($row['minmrp']) ? $row['minmrp'] : '' }} - {{ !empty($row['maxmrp']) ? $row['maxmrp'] : '' }}	{{$row['clearence']}}	{{$row['discount']}}	{{$row['sales']}}
			{{$gtotalXS}}	{{$gtotalS}}	{{$gtotalM}}	{{$gtotalL}}	{{$gtotalXL}}	{{$gtotal2XL}}	{{$gtotal3XL}}	{{$gtotal4XL}}	{{$gtotal5XL}}	{{$gtotal6XL}}	{{$gtotal7XL}}	{{$gtotalFREE}}	{{$gtotalTotal}}			{{$gtotaldiscount}}	{{$gtotalsales}}