@forelse ($membersWithoutPrimaryProduct as $item) @php $primaryProductArr = DB::table('mfn_loans_product') ->where('id', $item->primaryProductId) ->select( DB::raw("CONCAT ( LPAD(mfn_loans_product.code,3,0) ,' - ', mfn_loans_product.shortName ) AS productName")) ->value('productName'); @endphp @empty @endforelse

#	Member name	Member Code	Product Name	Product Name
{{$loop->iteration}}	{{$item->name}}	{{$item->code}}	{{$primaryProductArr}}	@if ($item->closingDate == "0000-00-00") Open @else Close @endif
No data found

Member name

Member Code

Product Name

@if ($item->closingDate == "0000-00-00")

Open

@else

@endif

No data found