Project_PHP/admin_stats.php at main · Ali-Codingg/Project_PHP · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
<?php
session_start();
include('config.php');

// Ensure the user is an admin
if (!isset($_SESSION['user_role']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: products.php");
    exit();
}

// Query 1: Total Orders
$sql_total_orders = "SELECT COUNT(*) AS total_orders FROM orders";
$result_total_orders = mysqli_query($conn, $sql_total_orders);
$row_total_orders = mysqli_fetch_assoc($result_total_orders);
$total_orders = $row_total_orders['total_orders'];

// Query 2: Total Revenue
$sql_total_revenue = "SELECT SUM(total_amount) AS total_revenue FROM orders";
$result_total_revenue = mysqli_query($conn, $sql_total_revenue);
$row_total_revenue = mysqli_fetch_assoc($result_total_revenue);
$total_revenue = $row_total_revenue['total_revenue'];

// Query 3: Total Users
$sql_total_users = "SELECT COUNT(*) AS total_users FROM users";
$result_total_users = mysqli_query($conn, $sql_total_users);
$row_total_users = mysqli_fetch_assoc($result_total_users);
$total_users = $row_total_users['total_users'];

// Query 4: Total Products Sold (sum of quantity in order_items)
$sql_total_products_sold = "SELECT SUM(quantity) AS total_products_sold FROM order_items";
$result_total_products_sold = mysqli_query($conn, $sql_total_products_sold);
$row_total_products_sold = mysqli_fetch_assoc($result_total_products_sold);
$total_products_sold = $row_total_products_sold['total_products_sold'];

// Query 5: Most Popular Product (by quantity sold)
$sql_popular_product = "SELECT p.name, SUM(oi.quantity) AS total_sold
                        FROM order_items oi
                        JOIN products p ON oi.product_id = p.id
                        GROUP BY p.id
                        ORDER BY total_sold DESC
                        LIMIT 1";
$result_popular_product = mysqli_query($conn, $sql_popular_product);
$popular_product = mysqli_fetch_assoc($result_popular_product);

mysqli_close($conn);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Admin Statistics - Honey E-Commerce</title>
    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <style>
        body {
            background-color: #f8f9fa;
        }
        .card {
            margin-bottom: 20px;
        }
        .dashboard-header {
            margin-top: 20px;
            margin-bottom: 30px;
        }
    </style>
</head>
<body>
    <!-- Navigation Bar -->
    <nav class="navbar navbar-expand-lg navbar-light bg-white shadow-sm">
        <div class="container">
            <a class="navbar-brand" href="index.php">Honey E-Commerce</a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav"
                    aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse justify-content-end" id="navbarNav">
                <ul class="navbar-nav">
                <li class="nav-item">
                        <a class="nav-link" href="products.php">Home</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="manage_orders.php">Manage Orders</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="logout.php">Logout (<?php echo htmlspecialchars($_SESSION['name']); ?>)</a>
                    </li>
                </ul>
            </div>
        </div>
    </nav>

    <!-- Main Container -->
    <div class="container">
        <div class="dashboard-header text-center">
            <h2>Admin Dashboard</h2>
            <p>Overview of key metrics and statistics</p>
        </div>

        <!-- Top Stats Cards -->
        <div class="row">
            <div class="col-md-3">
                <div class="card text-white bg-primary">
                    <div class="card-body">
                        <h5 class="card-title">Total Orders</h5>
                        <p class="card-text"><?php echo $total_orders; ?></p>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card text-white bg-success">
                    <div class="card-body">
                        <h5 class="card-title">Total Revenue</h5>
                        <p class="card-text">$<?php echo number_format($total_revenue, 2); ?></p>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card text-white bg-info">
                    <div class="card-body">
                        <h5 class="card-title">Total Users</h5>
                        <p class="card-text"><?php echo $total_users; ?></p>
                    </div>
                </div>
            </div>
            <div class="col-md-3">
                <div class="card text-white bg-warning">
                    <div class="card-body">
                        <h5 class="card-title">Products Sold</h5>
                        <p class="card-text"><?php echo $total_products_sold; ?></p>
                    </div>
                </div>
            </div>
        </div>

        <!-- Detailed Stats: Most Popular Product -->
        <div class="row mt-4">
            <div class="col-md-6">
                <div class="card">
                    <div class="card-header">
                        Most Popular Product
                    </div>
                    <div class="card-body">
                        <?php if ($popular_product): ?>
                            <h5 class="card-title"><?php echo htmlspecialchars($popular_product['name']); ?></h5>
                            <p class="card-text">Total Sold: <?php echo $popular_product['total_sold']; ?></p>
                        <?php else: ?>
                            <p>No sales data available.</p>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Bootstrap JS Bundle -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>