@foreach($directLines as $line) @php $catId = DB::connection('mysql2')->table('subitem')->where('id', $line->item_id)->value('main_ic_id'); $uomName = CommonHelper::get_uom($line->item_id); $instock = DB::connection('mysql2')->table('stock') ->where('status', 1)->where('sub_item_id', $line->item_id) ->where('warehouse_id', $line->warehouse_id)->sum('qty'); @endphp @php $lineNo++; @endphp @endforeach @if($directLines->isEmpty()) @endif

Category	Item	From Date	To Date	UOM	Qty	Warehouse	In Stock	Rate	Amount
Select @foreach(CommonHelper::get_all_category() as $category) id) selected @endif>{{ $category->main_ic }} @endforeach	Select @if($catId) @foreach(DB::connection('mysql2')->table('subitem')->where('status', 1)->where('main_ic_id', $catId)->get() as $sub) item_id == $sub->id) selected @endif>{{ $sub->item_code ? $sub->item_code.' -- ' : '' }}{{ $sub->sub_ic }} @endforeach @endif					Select @foreach(CommonHelper::get_all_warehouse() as $wh) warehouse_id == $wh->id) selected @endif>{{ $wh->name }} @endforeach
Select @foreach(CommonHelper::get_all_category() as $category) {{ $category->main_ic }} @endforeach	Select					Select @foreach(CommonHelper::get_all_warehouse() as $wh) {{ $wh->name }} @endforeach
Line Subtotal