Stock Report

Kalyani's Solvex Pvt. Ltd.

Kalyani's Solvex Pvt. Ltd.:
Kolkata
support@kalyani.com

@foreach($allData as $key => $item) @php $buying_total = App\Models\Purchase::where('category_id',$item->category_id)->where('product_id',$item->id)->where('status','1')->sum('buying_qty'); $selling_total = App\Models\InvoiceDetail::where('category_id',$item->category_id)->where('product_id',$item->id)->where('status','1')->sum('selling_qty'); @endphp @endforeach

Sl	Supplier Name	Unit	Category	Product Name	In Qty	Out Qty	Stock
{{ $key+1}}	{{ $item['supplier']['name'] }}	{{ $item['unit']['name'] }}	{{ $item['category']['name'] }}	{{ $item->name }}	{{ $buying_total }}	{{ $selling_total }}	{{ $item->quantity }}

@php $date = new DateTime('now', new DateTimeZone('Asia/Dhaka')); @endphp Printing Time : {{ $date->format('F j, Y, g:i a') }}

Download