query("stock", "SELECT s.record_id, s.stock_no, s.item_name, s.type, s.size, s.unit_of_measure, s.status AS qty, s.serial_number, st.name AS type_name FROM stock s LEFT JOIN stock_types st ON st.record_id = s.stock_type_id ORDER BY s.item_name ASC" ); $all_stock = []; while ($row = $stock_res->fetch_assoc()) $all_stock[] = $row; // ── RECENT TRANSACTIONS (last 50) ──────────────────────── $trans_res = $db->query("stock_trans", "SELECT record_id, stock_no, item_name, quantity, status, order_no, datetime_created FROM stock_trans ORDER BY record_id DESC LIMIT 50" ); $transactions = []; while ($row = $trans_res->fetch_assoc()) $transactions[] = $row; // ── STATS ───────────────────────────────────────────────── $total_items = count($all_stock); $low_count = count(array_filter($all_stock, fn($s) => (int)$s['qty'] <= 1)); $out_count = count(array_filter($all_stock, fn($s) => (int)$s['qty'] <= 0)); // Transactions today $today_res = $db->query("stock_trans", "SELECT COUNT(*) AS cnt FROM stock_trans WHERE DATE(datetime_created) = CURDATE()" ); $today_count = (int)($today_res->fetch_assoc()['cnt'] ?? 0); function w_esc($s) { return htmlspecialchars($s ?? '', ENT_QUOTES, 'UTF-8'); } ?> Workshop — Stock
WORKSHOP STOCK
Workshop
Refresh
Total Items
Transactions Today
Low Stock (≤1)
Out of Stock
Stock Items items
Stock No Item Name Type Size Qty Actions
No stock items found
Recent Transactions
No transactions yet
· Order