query("SELECT COUNT(*) FROM orders")->fetchColumn();
$pending_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'Pending'")->fetchColumn();
$processing_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'Processing'")->fetchColumn();
$completed_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'Completed'")->fetchColumn();
// Today's orders
$today_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE DATE(created_at) = CURDATE()")->fetchColumn();
// Monthly orders
$monthly_orders = $pdo->query("SELECT COUNT(*) FROM orders WHERE MONTH(created_at) = MONTH(CURDATE()) AND YEAR(created_at) = YEAR(CURDATE())")->fetchColumn();
// Fetch 5 most recent orders
$recent_stmt = $pdo->prepare("SELECT * FROM orders ORDER BY created_at DESC LIMIT 5");
$recent_stmt->execute();
$recent_orders = $recent_stmt->fetchAll();
} catch (PDOException $e) {
die("Error retrieving dashboard statistics: " . $e->getMessage());
}
include '../includes/admin_header.php';
?>
| Order No |
Customer |
Curtain Specs |
Dimensions |
Order Date |
Status |
Actions |
|
No orders received yet.
|
|
|
|
Type:
Fabric:
|
"W × "H
Qty:
|
|
|
|