query("SELECT COUNT(*) FROM products")->fetchColumn(); $total_stock = (int)($pdo->query("SELECT COALESCE(SUM(current_stock), 0) FROM products")->fetchColumn()); $out_of_stock = (int) $pdo->query("SELECT COUNT(*) FROM products WHERE current_stock = 0")->fetchColumn(); $low_stock_count = (int) $pdo->query("SELECT COUNT(*) FROM products WHERE current_stock > 0 AND current_stock < 10")->fetchColumn(); // ---- Stock summary (all products, lowest stock first) ---- $products = $pdo->query( "SELECT name, unit, current_stock FROM products ORDER BY current_stock ASC" )->fetchAll(); // ---- Recent 6 transactions ---- $recent = $pdo->query(" SELECT st.quantity, st.type, st.created_at, p.name AS product_name FROM stock_transactions st JOIN products p ON p.id = st.product_id ORDER BY st.created_at DESC LIMIT 6 ")->fetchAll(); include 'includes/header.php'; ?>

Dashboard

Welcome back,

Total Products

Total Stock

Low Stock

Out of Stock

Current Stock Summary View All
$p): ?>
# Product Unit Stock Status
No products yet. Add your first product
Out of Stock Low Stock In Stock
Recent Transactions View All
No transactions yet.
  • + -
QUICK ACTIONS
Add Product Add Stock Deduct Stock View History