@php $currentDate=\Illuminate\Support\Carbon::now()->format('d M,Y - H:i A'); @endphp Wancom Report
logo
info@wancom.net.pk
+92-21-34891371-4
Suit#205 2nd Floor Mashriq Centre,
Block#14 Gulshan-e-Iqbal, Stadium Road Karachi.
Stock In Hand Report

Date # {{$currentDate}}


Report Details
Start Date: {{\Illuminate\Support\Carbon::parse($start_date)->format('d, M-Y')}}
End Date: {{\Illuminate\Support\Carbon::parse($end_date)->format('d, M-Y')}}

Note: Report is generated from system with
the available stock quantity and valuation both
item wise and total.


Stock in Hand Details Item Wise
@php $a=1; $totalPrice=0; @endphp @foreach ($checkout as $checkouts) @php $productData=App\Models\Product::find($checkouts->product_id); $totalIn=DB::table('purchase_order_product')->where('product_id',$checkouts->product_id)->where('type','in')->sum('quantity'); $totalOut=DB::table('purchase_order_product')->where('product_id',$checkouts->product_id)->where('type','out')->sum('quantity'); $totalSum=DB::table('purchase_order_product')->where('product_id',$checkouts->product_id)->where('type','in')->sum('price'); $totalCount=DB::table('purchase_order_product')->where('product_id',$checkouts->product_id)->where('type','in')->count(); $averagePrice=$totalSum/$totalCount; $amount=($totalIn - $totalOut)*$averagePrice; $totalPrice = $totalPrice + $amount; @endphp @php $a++; @endphp @endforeach
S.No Products Unit TQ-IN TQ-OUT TQ-BALANCE Avg. Price Amount
{{$a}} {{$productData->name}} {{$productData->units}} {{$totalIn}} {{$totalOut}} {{$totalIn - $totalOut}} {{$averagePrice}} {{$amount}}
Total Value of Available Inventory In-hand :
  Rs {{$totalPrice ?? ""}}





TQ-IN = Total Quantity In
TQ-Out= Total Quantity Out
TQ-Balance = Total Quantity Balance

This is a system generated report
Generated By: {{Auth::user()->name}} on {{$currentDate}}