query("SELECT SUM(net_amount) as total_sales FROM orders"); $total_sales = $stmt_sales->fetch()['total_sales'] ?? 0; // Total Orders $stmt_orders = $pdo->query("SELECT COUNT(*) as total_orders FROM orders"); $total_orders = $stmt_orders->fetch()['total_orders'] ?? 0; // Total Customers $stmt_users = $pdo->query("SELECT COUNT(*) as total_customers FROM users WHERE role = 'customer'"); $total_customers = $stmt_users->fetch()['total_customers'] ?? 0; // Low Stock Alert (quantity < 5) $stmt_stock = $pdo->query("SELECT COUNT(*) as low_stock FROM products WHERE stock < 5"); $low_stock = $stmt_stock->fetch()['low_stock'] ?? 0; // 2. Fetch Low Stock Items $low_stock_items = $pdo->query("SELECT p.*, c.name as category_name FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.stock < 5 ORDER BY p.stock ASC LIMIT 5")->fetchAll(); // 3. Fetch Recent Orders $recent_orders = $pdo->query("SELECT o.*, u.full_name FROM orders o JOIN users u ON o.user_id = u.id ORDER BY o.id DESC LIMIT 5")->fetchAll(); ?>
Admin Control Panel Overview

Total Revenue

฿

Total Orders

Customers

Low Stock Items

0): ?>
⚠️ Attention: You have items running low on stock! Restock Now

Low Stock Outfits Alert

Image Outfit Name Category Price Stock Left Action
฿ Edit Stock

Recent Orders

No orders recorded yet.

Order ID Customer Net Total Status Order Date Action
#ORD- ฿ Manage