@foreach($purchase->details as $key => $product) @php //dd($product); $total_goods_in = App\GoodsinProduct::query()->where('purchase_id', $purchase->id)->where('product_id',$product->product_id)->sum('qty'); $received_qty = $total_goods_in; $balanced_qty = $product->qty - $total_goods_in; //$requisition_qty= $product->calculate_requisition_qty($product); $receivable_qty= $product->calculate_receivable_qty($product); @endphp