-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathadmin_dashboard.php
More file actions
255 lines (240 loc) · 13.4 KB
/
Copy pathadmin_dashboard.php
File metadata and controls
255 lines (240 loc) · 13.4 KB
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
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
<?php
include 'config.php';
$hotels_query = "SELECT COUNT(*) as count FROM hotels";
$bookings_query = "SELECT COUNT(*) as count FROM bookings";
$feedback_query = "SELECT COUNT(*) as count FROM feedback";
$contacts_query = "SELECT COUNT(*) as count FROM contacts";
$hotels_count = $conn->query($hotels_query)->fetch_assoc()['count'];
$bookings_count = $conn->query($bookings_query)->fetch_assoc()['count'];
$feedback_count = $conn->query($feedback_query)->fetch_assoc()['count'];
$contacts_count = $conn->query($contacts_query)->fetch_assoc()['count'];
$recent_bookings = $conn->query("SELECT * FROM bookings ORDER BY created_at DESC LIMIT 5");
$recent_feedback = $conn->query("SELECT * FROM feedback ORDER BY created_at DESC LIMIT 5");
$recent_contacts = $conn->query("SELECT * FROM contacts ORDER BY created_at DESC LIMIT 5");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Admin Dashboard - Booklify</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.1/font/bootstrap-icons.css">
<style>
.stat-card {
border-left: 4px solid;
transition: transform 0.3s ease;
}
.stat-card:hover {
transform: translateY(-5px);
box-shadow: 0 10px 20px rgba(0,0,0,0.1);
}
.stat-card-hotels { border-left-color: #0d6efd; }
.stat-card-bookings { border-left-color: #198754; }
.stat-card-feedback { border-left-color: #ffc107; }
.stat-card-contacts { border-left-color: #0dcaf0; }
</style>
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark sticky-top">
<div class="container-fluid">
<a class="navbar-brand fw-bold" href="admin_dashboard.php">
<i class="bi bi-speedometer2 me-2"></i>Booklify Admin
</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav ms-auto">
<li class="nav-item"><a class="nav-link" href="search_hotels.php">Hotels</a></li>
<li class="nav-item"><a class="nav-link" href="search_bookings.php">Bookings</a></li>
<li class="nav-item"><a class="nav-link" href="index.html">Public Site</a></li>
</ul>
</div>
</div>
</nav>
<main>
<div class="container-fluid py-5 bg-light">
<div class="container">
<!-- Statistics Cards -->
<div class="row g-4 mb-5">
<div class="col-md-6 col-lg-3">
<div class="card stat-card stat-card-hotels shadow-sm">
<div class="card-body">
<div class="d-flex justify-content-between align-items-start">
<div>
<p class="text-muted small mb-1">Total Hotels</p>
<h3 class="mb-0"><?php echo $hotels_count; ?></h3>
</div>
<i class="bi bi-hotel text-primary fs-3"></i>
</div>
</div>
<a href="search_hotels.php" class="card-footer bg-white text-decoration-none text-primary small">
View Details <i class="bi bi-arrow-right ms-1"></i>
</a>
</div>
</div>
<div class="col-md-6 col-lg-3">
<div class="card stat-card stat-card-bookings shadow-sm">
<div class="card-body">
<div class="d-flex justify-content-between align-items-start">
<div>
<p class="text-muted small mb-1">Total Bookings</p>
<h3 class="mb-0"><?php echo $bookings_count; ?></h3>
</div>
<i class="bi bi-calendar-check text-success fs-3"></i>
</div>
</div>
<a href="search_bookings.php" class="card-footer bg-white text-decoration-none text-success small">
Manage Bookings <i class="bi bi-arrow-right ms-1"></i>
</a>
</div>
</div>
<div class="col-md-6 col-lg-3">
<div class="card stat-card stat-card-feedback shadow-sm">
<div class="card-body">
<div class="d-flex justify-content-between align-items-start">
<div>
<p class="text-muted small mb-1">Feedback Records</p>
<h3 class="mb-0"><?php echo $feedback_count; ?></h3>
</div>
<i class="bi bi-chat-left-heart text-warning fs-3"></i>
</div>
</div>
<a href="#" class="card-footer bg-white text-decoration-none text-warning small">
View Feedback <i class="bi bi-arrow-right ms-1"></i>
</a>
</div>
</div>
<div class="col-md-6 col-lg-3">
<div class="card stat-card stat-card-contacts shadow-sm">
<div class="card-body">
<div class="d-flex justify-content-between align-items-start">
<div>
<p class="text-muted small mb-1">Contact Messages</p>
<h3 class="mb-0"><?php echo $contacts_count; ?></h3>
</div>
<i class="bi bi-envelope-check text-info fs-3"></i>
</div>
</div>
<a href="process_contact.php" class="card-footer bg-white text-decoration-none text-info small">
View Messages <i class="bi bi-arrow-right ms-1"></i>
</a>
</div>
</div>
<!-- Quick Actions -->
<div class="row g-4 mb-5">
<div class="col-lg-8">
<div class="card shadow-sm">
<div class="card-header bg-light">
<h5 class="mb-0"><i class="bi bi-lightning-charge me-2"></i>Quick Actions</h5>
</div>
<div class="card-body">
<div class="row g-3">
<div class="col-md-6">
<a href="insert_booking.php" class="btn btn-success btn-lg w-100">
<i class="bi bi-plus-circle me-2"></i>Add New Booking
</a>
</div>
<div class="col-md-6">
<a href="search_bookings.php" class="btn btn-primary btn-lg w-100">
<i class="bi bi-search me-2"></i>Search Bookings
</a>
</div>
<div class="col-md-6">
<a href="update_booking.php" class="btn btn-warning btn-lg w-100">
<i class="bi bi-pencil-square me-2"></i>Update Booking
</a>
</div>
<div class="col-md-6">
<a href="delete_booking.php" class="btn btn-danger btn-lg w-100">
<i class="bi bi-trash me-2"></i>Delete Booking
</a>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-4">
<div class="card shadow-sm">
<div class="card-header bg-light">
<h5 class="mb-0"><i class="bi bi-info-circle me-2"></i>System Info</h5>
</div>
<div class="card-body">
<ul class="list-unstyled">
<li class="mb-3">
<strong>Database:</strong><br>
<small class="text-muted">booklify</small>
</li>
<li class="mb-3">
<strong>Tables:</strong><br>
<small class="text-muted">4 (hotels, bookings, feedback, contacts)</small>
</li>
<li class="mb-3">
<strong>Last Updated:</strong><br>
<small class="text-muted" id="update-time">Just now</small>
</li>
<li>
<strong>Status:</strong><br>
<span class="badge bg-success">Online</span>
</li>
</ul>
</div>
</div>
</div>
</div>
<!-- Recent Bookings -->
<div class="row g-4 mb-5">
<div class="col-lg-12">
<div class="card shadow-sm">
<div class="card-header bg-light">
<div class="d-flex justify-content-between align-items-center">
<h5 class="mb-0"><i class="bi bi-calendar-check me-2"></i>Recent Bookings</h5>
<a href="search_bookings.php" class="btn btn-sm btn-primary">View All</a>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table table-sm table-striped">
<thead class="table-light">
<tr>
<th>ID</th>
<th>Guest</th>
<th>Email</th>
<th>Check-in</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
if ($recent_bookings->num_rows > 0) {
while ($row = $recent_bookings->fetch_assoc()) {
echo "<tr>";
echo "<td>" . $row['booking_id'] . "</td>";
echo "<td>" . htmlspecialchars($row['first_name'] . ' ' . $row['last_name']) . "</td>";
echo "<td>" . htmlspecialchars($row['email']) . "</td>";
echo "<td>" . $row['check_in_date'] . "</td>";
echo "<td><span class='badge bg-" . ($row['booking_status'] === 'confirmed' ? 'success' : 'warning') . "'>" . $row['booking_status'] . "</span></td>";
echo "</tr>";
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
<footer class="bg-dark text-white text-center py-4 mt-5">
<p class="mb-0">© 2025 booklify.com. All rights reserved.</p>
</footer>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>
<?php
$conn->close();
?>