Work Order Report

@foreach($woVouchers as $wo) @endforeach @foreach($doVouchers as $do) @endforeach @php $totalSO = $totalWO = $totalDO = $totalPendingWO = $totalPendingDO = 0; @endphp @foreach($reportData as $r) @php $totalSO += $r['so_qty']; $totalWO += $r['total_wo']; $totalDO += $r['total_do']; $totalPendingWO += $r['pending_wo']; $totalPendingDO += $r['pending_do']; // 👉 Conditional formatting classes $woClass = ($r['total_wo'] > $r['so_qty']) ? 'red-text' : ''; $doClass = ($r['total_do'] > $r['so_qty']) ? 'red-text' : ''; $pendingWOClass = ($r['pending_wo'] < 0) ? 'red-text' : ''; $pendingDOClass = ($r['pending_do'] < 0) ? 'red-text' : ''; @endphp {{-- Work Order Columns --}} @foreach($woVouchers as $wo) @endforeach {{-- Total WO Qty --}} {{-- Delivery Order Columns --}} @foreach($doVouchers as $do) @endforeach {{-- Total DO Qty --}} {{-- Pending Columns --}} @endforeach {{-- Final Totals --}} @foreach($woVouchers as $wo) @endforeach @foreach($doVouchers as $do) @endforeach
Item Code Item Name SO Qty{{ $wo }} (WO Qty)Total WO Qty{{ $do }} (DO Qty)Total DO Qty Pending WO Pending DO
{{ $r['item_code'] }} {{ $r['item_name'] }} {{ number_format($r['so_qty'], 2) }}{{ number_format($r['wo_details'][$wo] ?? 0, 2) }}{{ number_format($r['total_wo'], 2) }}{{ number_format($r['do_details'][$do] ?? 0, 2) }}{{ number_format($r['total_do'], 2) }}{{ number_format($r['pending_wo'], 2) }} {{ number_format($r['pending_do'], 2) }}
Total {{ number_format($totalSO,2) }}{{ number_format($totalWO,2) }}{{ number_format($totalDO,2) }} {{ number_format($totalPendingWO,2) }} {{ number_format($totalPendingDO,2) }}