-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathview_logs.php
More file actions
189 lines (167 loc) · 7.72 KB
/
Copy pathview_logs.php
File metadata and controls
189 lines (167 loc) · 7.72 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
<?php
require_once 'db.php';
session_start();
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit;
}
// By default, sort by date (timestamp)
$sort_by = isset($_GET['sort_by']) ? $_GET['sort_by'] : 'timestamp';
$sort_order = isset($_GET['sort_order']) ? $_GET['sort_order'] : 'DESC';
// We check if the selected criteria are valid to prevent SQL Injection
$allowed_sort_columns = ['timestamp', 'severity', 'project_name'];
$allowed_sort_orders = ['ASC', 'DESC'];
if (!in_array($sort_by, $allowed_sort_columns)) {
$sort_by = 'timestamp'; // Set default if invalid column
}
if (!in_array($sort_order, $allowed_sort_orders)) {
$sort_order = 'DESC'; // Set default if invalid order
}
// Defining the number of logs per page
$logs_per_page = 10;
// Retrieving the current page from GET parameters (default is 1)
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) {
$page = 1; // Default to the first page if the page number is invalid
}
// Calculate how many records to skip before starting to fetch the data
$offset = ($page - 1) * $logs_per_page;
$query = "
SELECT logs.*, projects.name AS project_name
FROM logs
JOIN projects ON logs.project_id = projects.id
WHERE logs.user_id = :user_id
ORDER BY $sort_by $sort_order
LIMIT $logs_per_page OFFSET $offset
";
$stmt = $pdo->prepare($query);
$stmt->execute(['user_id' => $_SESSION['user_id']]);
$logs = $stmt->fetchAll(PDO::FETCH_ASSOC);
$stmt = $pdo->prepare("SELECT COUNT(*) AS total_logs FROM logs WHERE user_id = :user_id");
$stmt->execute(['user_id' => $_SESSION['user_id']]);
$total_logs = $stmt->fetch(PDO::FETCH_ASSOC)['total_logs'];
$total_pages = ceil($total_logs / $logs_per_page);
?>
<!DOCTYPE html>
<html lang="pl">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Your Logs</title>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
<style>
body {
padding-top: 20px;
}
.container {
max-width: 1200px;
}
</style>
</head>
<body>
<div class="container">
<h1>Your Logs</h1>
<form method="GET" action="view_logs.php">
<div class="form-row">
<div class="col">
<label for="sort_by">Sort by:</label>
<select class="form-control" id="sort_by" name="sort_by">
<option value="timestamp" <?= ($sort_by == 'timestamp') ? 'selected' : '' ?>>Data</option>
<option value="severity" <?= ($sort_by == 'severity') ? 'selected' : '' ?>>Level of importance</option>
<option value="project_name" <?= ($sort_by == 'project_name') ? 'selected' : '' ?>>Project Name</option>
</select>
</div>
<div class="col">
<label for="sort_order">Sort Order:</label>
<select class="form-control" id="sort_order" name="sort_order">
<option value="ASC" <?= ($sort_order == 'ASC') ? 'selected' : '' ?>>Ascending</option>
<option value="DESC" <?= ($sort_order == 'DESC') ? 'selected' : '' ?>>Descending</option>
</select>
</div>
<div class="col">
<button type="submit" class="btn btn-primary mt-4">Sort</button>
</div>
</div>
</form>
<!-- Excel Export logs (CSV) -->
<a href="export_logs.php" class="btn btn-success mb-4">Export Logs to Excel</a>
<table class="table table-striped table-bordered mt-4">
<thead>
<tr>
<th scope="col">Timestamp</th>
<th scope="col">Project</th>
<th scope="col">Severity</th>
<th scope="col">Message</th>
</tr>
</thead>
<tbody>
<?php foreach ($logs as $log): ?>
<tr>
<td><?= htmlspecialchars($log['timestamp']) ?></td>
<td><?= htmlspecialchars($log['project_name']) ?></td>
<td>
<?php
switch ($log['severity']) {
case 'Emergency':
echo '<span class="badge badge-danger">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Alert':
echo '<span class="badge badge-warning">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Critical':
echo '<span class="badge badge-danger">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Error':
echo '<span class="badge badge-danger">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Warning':
echo '<span class="badge badge-warning">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Notice':
echo '<span class="badge badge-info">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Informational':
echo '<span class="badge badge-secondary">' . htmlspecialchars($log['severity']) . '</span>';
break;
case 'Debug':
echo '<span class="badge badge-light">' . htmlspecialchars($log['severity']) . '</span>';
break;
}
?>
</td>
<td><?= htmlspecialchars($log['message']) ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
<nav aria-label="Page navigation example">
<ul class="pagination justify-content-center">
<!-- Button Previous Page -->
<li class="page-item <?= ($page == 1) ? 'disabled' : '' ?>">
<a class="page-link" href="?page=<?= $page - 1 ?>&sort_by=<?= $sort_by ?>&sort_order=<?= $sort_order ?>" aria-label="Previous">
<span aria-hidden="true">«</span>
</a>
</li>
<!-- Number of Page -->
<?php for ($i = 1; $i <= $total_pages; $i++): ?>
<li class="page-item <?= ($i == $page) ? 'active' : '' ?>">
<a class="page-link" href="?page=<?= $i ?>&sort_by=<?= $sort_by ?>&sort_order=<?= $sort_order ?>"><?= $i ?></a>
</li>
<?php endfor; ?>
<!-- Button Next Page -->
<li class="page-item <?= ($page == $total_pages) ? 'disabled' : '' ?>">
<a class="page-link" href="?page=<?= $page + 1 ?>&sort_by=<?= $sort_by ?>&sort_order=<?= $sort_order ?>" aria-label="Next">
<span aria-hidden="true">»</span>
</a>
</li>
</ul>
</nav>
<br>
<a href="index.php" class="btn btn-secondary">Back to Dashboard</a>
</div>
<!-- Bootstrap JS and dependencies -->
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.2/dist/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>
</html>