@foreach ($expired_products as $product) @php $nonEmptyStock = $product->stocks->firstWhere('productStock', '>', 0); $fallbackStock = $product->stocks->first(); // fallback if no stock > 0 $stock = $nonEmptyStock ?? $fallbackStock; $latestPurchasePrice = $stock?->productPurchasePrice ?? 0; $latestSalePrice = $stock?->productSalePrice ?? 0; @endphp @endforeach

{{ __('SL') }}.	{{ __('Image') }}	{{ __('Product Name') }}	{{ __('Code') }}	{{ __('Brand') }}	{{ __('Category') }}	{{ __('Unit') }}	{{ __('Purchase price') }}	{{ __('Sale price') }}	{{ __('Stock') }}	{{ __('Expired Date') }}
{{ $loop->index + 1 }}		{{ $product->productName }}	{{ $product->productCode }}	{{ $product->brand->brandName ?? '' }}	{{ $product->category->categoryName ?? '' }}	{{ $product->unit->unitName ?? '' }}	{{ currency_format($latestPurchasePrice, currency: business_currency()) }}	{{ currency_format($latestSalePrice, currency: business_currency()) }}	{{ $product->stocks_sum_product_stock }}	@if ($product->stocks->isNotEmpty() && $product->stocks->first()->expire_date) {{ formatted_date($product->stocks->first()->expire_date) }} @else N/A @endif