STOCK BALANCE

@if(isset($data->formValue->productCategoryType)) @endif

Product Category

:

{{$data->formValue->productCategoryType}}

@foreach($processedData as $branchIndex => $branchData)

Branch: {{$branchData['branch']->nameEn ?? $branchData['branch']->name ?? 'N/A'}}

@foreach($branchData['warehouses'] as $warehouseIndex => $warehouseData) @if($data->showBatchNumber ?? false) @endif @if($data->showReorderLevel ?? false) @endif @php $serialNumber = 0; @endphp @if($warehouseData['hasSubcategories']) {{-- Show with subcategory grouping --}} @foreach($warehouseData['subcategoryGroups'] as $subcategoryName => $logs) {{-- Subcategory Header Row --}} {{-- Product Rows --}} @foreach($logs as $log) @php $serialNumber++; $isLowStock = isset($log->productItem->reorderLevel) && $log->productItem->reorderLevel != null && $log->stockQuantity < $log->productItem->reorderLevel; $rowStyle = $isLowStock ? 'color: red' : ''; @endphp @if($data->showBatchNumber ?? false) @endif @if($data->showReorderLevel ?? false) @endif @endforeach @endforeach @else {{-- Show flat list without subcategory grouping --}} @foreach($warehouseData['allLogs'] as $log) @php $serialNumber++; $isLowStock = isset($log->productItem->reorderLevel) && $log->productItem->reorderLevel != null && $log->stockQuantity < $log->productItem->reorderLevel; $rowStyle = $isLowStock ? 'color: red' : ''; @endphp @if($data->showBatchNumber ?? false) @endif @if($data->showReorderLevel ?? false) @endif @endforeach @endif

SL	SKU	Product Name	Batch Number	UoM	Stock Qty	Reorder Level
{{$subcategoryName}}
{{$serialNumber}}	{{$log->productItem->productSKU ?? 'N/A'}}	{{$log->productItem->name ?? 'N/A'}}	{{$log->batchNumber ?? 'N/A'}}	{{$log->productItem->productUoM ?? 'N/A'}}	{{$log->stockQuantity ?? 0}}	@if($log->productItem->reorderLevel == null) N/A @else {{$log->productItem->reorderLevel}} @endif
{{$serialNumber}}	{{$log->productItem->productSKU ?? 'N/A'}}	{{$log->productItem->name ?? 'N/A'}}	{{$log->batchNumber ?? 'N/A'}}	{{$log->productItem->productUoM ?? 'N/A'}}	{{$log->stockQuantity ?? 0}}	@if($log->productItem->reorderLevel == null) N/A @else {{$log->productItem->reorderLevel}} @endif

@endforeach @endforeach