query("SELECT SUM(total_price) FROM orders WHERE status != 'cancelled'")->fetchColumn() ?? 0;
$total_orders = $pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn() ?? 0;
$pending_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'pending'")->fetchColumn() ?? 0;
$shipping_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'shipping'")->fetchColumn() ?? 0;
$total_products = $pdo->query("SELECT COUNT(*) FROM products")->fetchColumn() ?? 0;
// 2. ดึงรายการคำสั่งซื้อล่าสุด 5 รายการ
$stmt = $pdo->prepare("
SELECT o.*, u.fullname
FROM orders o
JOIN users u ON o.user_id = u.id
ORDER BY o.id DESC LIMIT 5
");
$stmt->execute();
$recent_orders = $stmt->fetchAll();
// 3. ดึงสินค้าที่สต็อกต่ำกว่า 5 ชิ้น
$low_stock_products = $pdo->query("SELECT * FROM products WHERE stock <= 5 ORDER BY stock ASC")->fetchAll();
?>