Division Deliveries Report

Generated on {{ $generated_at }}

@if($filters['division_id'] || $filters['category_id'] || $filters['search'])

Applied Filters:

@if($filters['division_id'])
Division: {{ \App\Models\Department::find($filters['division_id'])->name ?? 'Unknown' }}
@endif @if($filters['category_id'])
Category: {{ \App\Models\Warehouse\ItemCategory::find($filters['category_id'])->category_name ?? 'Unknown' }}
@endif @if($filters['search'])
Search: {{ $filters['search'] }}
@endif
@endif
Total Items
{{ number_format($deliveries->count()) }}
Total Delivered
{{ number_format($deliveries->sum('total_quantity_delivered'), 2) }}
Total Value
AED {{ number_format($deliveries->sum('total_value'), 2) }}
@forelse($deliveries as $delivery) @php $utilizationRate = $delivery->total_quantity_delivered > 0 ? ($delivery->total_quantity_issued / $delivery->total_quantity_delivered) * 100 : 0; $utilizationClass = ''; if ($utilizationRate >= 70) { $utilizationClass = 'utilization-high'; } elseif ($utilizationRate >= 30) { $utilizationClass = 'utilization-medium'; } else { $utilizationClass = 'utilization-low'; } @endphp @empty @endforelse
Item Code Description Division Total Delivered Available Total Issued Utilization % Total Value (AED)
{{ $delivery->item->item_code }} {{ $delivery->item->item_description }} {{ $delivery->division->division_name }} {{ number_format($delivery->total_quantity_delivered, 2) }} {{ number_format($delivery->current_available_quantity, 2) }} {{ number_format($delivery->total_quantity_issued, 2) }} {{ number_format($utilizationRate, 1) }}% {{ number_format($delivery->total_value, 2) }}
No division deliveries found