@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; $i= 1; @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 @if(!empty($clearenceRequest)) @if(in_array(1, $clearenceRequest)) @php $colorc= 0; $clearenceArticle = \App\Scheme::where('article',$row['article'])->where('activated',1)->where(function ($query) use ($pos_id) { $query->whereIn('store',$pos_id); $query->Orwhere('store',9999); return $query; })->orderby('id','DESC')->first(); if(!empty($clearenceArticle)) { if($clearenceArticle->color === 'any') { $colorc= 1; } if($clearenceArticle->color === $row['color']) { $colorc= 1; } } @endphp @if(!empty($clearenceArticle)) @if($colorc === 1) @endif @endif @endif @endif @php $i++; @endphp @endforeach @php } @endphp

	Article	Color	Subsection	{{$size}}	Total	Mrp	Clearance Discount	Net Sales
{{ $i }}	{{ $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['discount']}}	{{$row['sales']}}
{{ $i }}	{{$clearenceArticle->article}}	{{$clearenceArticle->color}}	{{ !empty($article->category) ? $article->category->name : '' }}	{{$xs}}(%)	{{$s}}(%)	{{$l}}(%)	{{$m}}(%)	{{$xl}}(%)	{{$xl2}}(%)	{{$xl3}}(%)	{{$xl4}}(%)	{{$xl5}}(%)	{{$xl6}}(%)	{{$xl7}}(%)	{{$free}}(%)
				{{$gtotalXS}}	{{$gtotalS}}	{{$gtotalM}}	{{$gtotalL}}	{{$gtotalXL}}	{{$gtotal2XL}}	{{$gtotal3XL}}	{{$gtotal4XL}}	{{$gtotal5XL}}	{{$gtotal6XL}}	{{$gtotal7XL}}	{{$gtotalFREE}}	{{$gtotalTotal - $exchangeCounts}}		{{$gtotaldiscount}}	{{$gtotalsales - $totalExchangeAmt}}