@php $total_qty=0; $total_price=0; @endphp @foreach($cats as $cat => $category_id) @php $rows=DB::table('purchase_lines as pl') ->join('products as p','p.id','=','pl.product_id') ->join('variations as v','v.id','=','pl.variation_id') ->where('pl.transaction_id',$row->id) ->where('p.category_id', $cat) ->select('p.name','p.sku','pl.*','v.sell_price_inc_tax','v.default_purchase_price', DB::raw("(pl.quantity - pl.quantity_sold) as remain_qty"), DB::raw("((pl.quantity) * v.default_purchase_price) as sub_total"), DB::raw("((pl.quantity - pl.quantity_sold) * v.sell_price_inc_tax) as remain_price") ) ->get(); @endphp @foreach($rows as $item) @php $total_qty +=$rows->sum('remain_qty'); $total_price +=$rows->sum('remain_price'); @endphp @endforeach @endforeach

Challan No	{{$row->ref_no}}	Suppllier	{{$row->contact->name}}	Challan Date	{{ date('d/m/Y', strtotime($row->transaction_date))}}
Barcode	Product Information	Total Receive	Sold To Customer	CPU	RPU	Balance Qty	Balance Value at Cost
category :	{{$category_id}}
{{$item->sku}}	{{$item->name}}	{{$item->quantity}}	{{$item->quantity_sold}}	{{$item->default_purchase_price}}	{{$item->sell_price_inc_tax}}	{{number_format($item->remain_qty,1)}}	{{number_format($item->remain_price,1)}}
	Total Of	{{$category_id}}					{{ number_format($rows->sum('remain_price'),2) }}
	Total					{{ number_format($total_qty,1) }}	{{ number_format($total_price,1) }}