Order Planning Dashboard

@php use Carbon\Carbon; $months = collect(range(0, 11))->map(fn($i) => Carbon::now()->startOfMonth()->addMonths($i)->format('M-y'))->toArray(); // Group raw data by Unit and Month $factories = []; foreach ($capdata as $row) { $unit = strtoupper($row['Unit']); $month = Carbon::parse('1 ' . $row['Ship_Month'])->format('M-y'); // match format with $months $factories[$unit][$month]['month']= $row['Ship_Month']; $factories[$unit][$month]['used'] = ($factories[$unit][$month]['used'] ?? 0) + $row['Booked_Mins']; $factories[$unit][$month]['avail'] = ($factories[$unit][$month]['avail'] ?? 0) + $row['Unit_Capacity']; $factories[$unit][$month]['unit'] = $row['Unit_Code'] ?? 0; } @endphp

@foreach($months as $m) @endforeach @foreach($factories as $factory => $data) @foreach($months as $m) @php $used1 = $data[$m]['used'] ?? 0; $avail1 = $data[$m]['avail'] ?? 0; $util = $avail1 > 0 ? round(($used1 / $avail1) * 100, 1) : 0; $color = $util < 75 ? 'danger' : ($util < 90 ? 'warning' : ($util < 120 ? 'success' : 'purple')); $UnitCode = $data[$m]['unit'] ?? 0; $MonthCode = $data[$m]['month'] ?? 0; $used_lakhs = $used1 / 100000; $avail_lakhs = $avail1 / 100000; $used = $used_lakhs == 0 ? '0' : number_format($used_lakhs, 2) . ' L'; $avail = $avail_lakhs == 0 ? '0' : number_format($avail_lakhs, 2) . ' L'; @endphp @endforeach @endforeach {{-- Total Row --}} @foreach($months as $m) @php $used1 = $avail1 = 0; foreach($factories as $data) { $used1 += $data[$m]['used'] ?? 0; $avail1 += $data[$m]['avail'] ?? 0; } $util = $avail1 > 0 ? round(($used1 / $avail1) * 100, 1) : 0; $color = $util < 75 ? 'danger' : ($util < 90 ? 'warning' : ($util < 120 ? 'success' : 'purple')); $UnitCode = null; $MonthCode = $data[$m]['month'] ?? 0; $used_lakhs = $used1 / 100000; $avail_lakhs = $avail1 / 100000; $used = $used_lakhs == 0 ? '0' : number_format($used_lakhs, 2) . ' L'; $avail = $avail_lakhs == 0 ? '0' : number_format($avail_lakhs, 2) . ' L'; @endphp @endforeach

Factory	{{ $m }}
{{ $factory }}	{{ $used }} / {{ $avail }} min {{ $util }}%
Total	{{ ($used) }} / {{ ($avail) }} min {{ $util }}%

🗓️ Monthly Capacity Overview

Order Planning Dashboard