@if(count($perchaselist) > 0) @foreach($perchaselist as $key => $row) @php $article = \App\Article::with('category')->with('subcategory')->where('code',$row->article)->first(); if(!empty($report) && ($report === 'party')) { $pos = \App\PartyVendor::where('id',$row->saleorder2->to_party)->first(); }else{ $pos = \App\Warehouse::where('id',$row->saleorder2->to_pos)->first(); } @endphp @endforeach @endif

Invoice	Order date	Pos	GST No.	Code	Article	Color	Size	Sub Category	Category	Barcode	MRP	Final price	Qty	Outward On	Telly Invoice	Telly Date
{{$row->saleorder2->in_ref_no}}	{{$row->saleorder2->order_date}}	{{$pos->name}}	{{$pos->gstin}}	{{$pos->warehouse_code}}	{{ $row->article }}	{{ $row->color }}	{{ $row->size }}	{{!empty($article->subcategory->name) ? $article->subcategory->name : ''}}	{{!empty($article->category->name) ? $article->category->name : ''}}	{{ $row->barcode }}	{{ $row->mrp }}	{{ $row->finalprc }}	{{ $row->qty }}	{{ $row->outwardon }}	{{ $row->account_inv_no }}	{{ $row->account_inv_date }}