@foreach($items as $item) @php $stockLocation = App\Models\StockItemLocation::where('stock_item_id', $item->id) ->where('unit_id', $item->baseStockItemUnit->unit_id)->first(); @endphp @endforeach

Product Name	Product Code	Group Name	Sub Group Name	Unit	HSN Code	GST %	CESS %	MRP	Opening Stock	Opening Stock Rate	Opening Stock Value
{{ $item->name }}	{{ $item->item_code }}	{{$item->stockGroup->name ?? '--' }}		{{ $item->baseStockItemUnit->unit->name }}	{{ $item->hsn_code }}	{{ $item->gst }}	{{ $item->cess }}	{{ $item->mrp }}	{{ $stockLocation->opening_stock ?? 0 }}	{{ $stockLocation->rate ?? 0 }}	{{ $stockLocation->value ?? 0 }}