query("stock", "SELECT stock_no, item_name, type, size, unit_of_measure, status FROM stock WHERE status <= 1 ORDER BY status ASC, item_name ASC" ); $low_stock = []; while ($row = $low_res->fetch_assoc()) $low_stock[] = $row; // Booked out stock // ⚠️ Change 'BOOKED' to match your actual status value if different $booked_res = $db->query("stock_trans", "SELECT st.stock_no, st.item_name, st.quantity, st.order_no, st.datetime_created, st.status, s.type, s.size, s.unit_of_measure FROM stock_trans st LEFT JOIN stock s ON s.stock_no = st.stock_no WHERE st.status = 'BOOKED' ORDER BY st.datetime_created DESC" ); $booked_stock = []; while ($row = $booked_res->fetch_assoc()) $booked_stock[] = $row; function d_esc($s) { return htmlspecialchars($s ?? '', ENT_QUOTES, 'UTF-8'); } ?> Dispatch Dashboard
DISPATCH DASHBOARD
Dispatch
Refresh
⚠ Critical Stock (≤ 1) item
OUT' : '1'; ?>
Stock No Item Type Size Qty
All stock levels are fine ✓
Booked Out Stock item
Stock No Item Qty Order No Date
No items currently booked out