@usercan('stocks.price') @endusercan @foreach ($products as $product) @php $total_stock = $product->stocks->sum('productStock'); $firstStock = $product->stocks->first(); $total_value = $product->stocks->sum(function ($stock) { return $stock->productPurchasePrice * $stock->productStock; }); @endphp @usercan('stocks.price') @endusercan @endforeach @if ($products->count() > 0) @endif

{{ __('SL') }}.	{{ __('Product') }}	{{ __('Code') }}	{{ __('Category') }}	{{ __('Cost') }}	{{ __('Qty') }}	{{ __('Sale') }}	{{ __('Stock Value') }}
{{ ($products->currentPage() - 1) * $products->perPage() + $loop->iteration }}	@php $stocks = $product->stocks->map(function ($batch) use ($product) { return [ 'batch_no' => $batch->batch_no, 'expire_date' => $batch->expire_date ? formatted_date($batch->expire_date) : 'N/A', 'productStock' => $batch->productStock ?? 0, 'productSalePrice' => $batch->productSalePrice ?? 0, 'productDealerPrice' => $batch->productDealerPrice ?? 0, 'productPurchasePrice' => $batch->productPurchasePrice ?? 0, 'productWholeSalePrice' => $batch->productWholeSalePrice ?? 0, 'warehouse' => $batch->warehouse?->name ?? ($product->warehouse?->name ?? ''), 'rack' => $product->rack?->name ?? '', 'shelf' => $product->shelf?->name ?? '', ]; }); @endphp {{ $product->productName }}	{{ $product->productCode }}	{{ $product->category->categoryName ?? '' }}	{{ currency_format(optional($firstStock)->productPurchasePrice, currency: business_currency()) }}	{{ $total_stock }}	{{ currency_format(optional($firstStock)->productSalePrice, currency: business_currency()) }}	{{ currency_format($total_value, currency: business_currency()) }}
{{ __('Total Stock Value:') }}	{{ currency_format($total_stock_value, currency: business_currency()) }}