-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
147 lines (138 loc) · 5.46 KB
/
index.php
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
<?php
session_start();
if (!isset($_SESSION['Admin-name'])) {
header("location: login.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Users</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="icon" type="image/png" href="icons/atte1.jpg">
<script type="text/javascript" src="js/jquery-2.2.3.min.js"></script>
<script type="text/javascript" src="js/bootstrap.js"></script>
<link rel="stylesheet" type="text/css" href="css/Users.css">
<script>
$(window).on("load resize ", function() {
var scrollWidth = $('.tbl-content').width() - $('.tbl-content table').width();
$('.tbl-header').css({'padding-right':scrollWidth});
}).resize();
</script>
</head>
<body>
<?php include'header.php'; ?>
<main>
<section>
<h1 class="slideInDown animated">Here are all the Users</h1>
<!--User table-->
<div class="table-responsive slideInRight animated" style="max-height: 400px;">
<table class="table">
<thead class="table-primary">
<tr>
<th>Name</th>
<th>User Number</th>
<th>Gender</th>
<th>Email</th>
<th>Finger ID</th>
<th>Dept</th>
<th>Action</th>
</tr>
</thead>
<tbody class="table-secondary">
<?php
//Connect to database
require'connectDB.php';
$sql = "SELECT * FROM users WHERE fingerprint_id ORDER BY id DESC";
$result = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($result, $sql)) {
echo '<p class="error">SQL Error</p>';
}
else{
mysqli_stmt_execute($result);
$resultl = mysqli_stmt_get_result($result);
if (mysqli_num_rows($resultl) > 0){
while ($row = mysqli_fetch_assoc($resultl)){
?>
<TR>
<TD><?php echo $row['username'];?></TD>
<TD><?php echo $row['serialnumber'];?></TD>
<TD><?php echo $row['gender'];?></TD>
<TD><?php echo $row['email'];?></TD>
<TD><?php echo $row['fingerprint_id'];?></TD>
<TD><?php echo $row['user_dept'];?></TD>
<TD><?php echo "<button class='btn btn-info' data-toggle='modal' data-target='#userInfoModal' onclick='showUserInfo(" . $row['id'] . ")'>Info</button> <button class='btn btn-danger' onclick='deleteAdmin(" . $row['id'] . ")'>Delete</button>"; ?></TD>
</TR>
<?php
}
}
}
?>
</tbody>
</table>
</div>
</section>
</main>
<script>
function deleteAdmin(userId) {
if (confirm('Are you sure you want to delete this user?')) {
var xhr = new XMLHttpRequest();
xhr.open("POST", "delete_user.php", true);
xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.onreadystatechange = function () {
if (xhr.readyState === 4 && xhr.status === 200) {
alert('User deleted successfully');
window.location.reload(); // Reload the page to see the change
}
};
xhr.send("id=" + userId);
}
}
function showUserInfo(userId) {
var xhr = new XMLHttpRequest();
xhr.open("POST", "get_user_info.php", true);
xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.onreadystatechange = function () {
if (xhr.readyState === 4 && xhr.status === 200) {
var response = JSON.parse(xhr.responseText);
var projectsHTML = '<h4>Projects:</h4><ul>';
response.projects.forEach(function (project) {
projectsHTML += '<li>' + project + '</li>';
});
projectsHTML += '</ul>';
var borrowedComponentsHTML = '<h4>Borrowed Components:</h4><ul>';
response.borrowedComponents.forEach(function (component) {
borrowedComponentsHTML += '<li>' + component + '</li>';
});
borrowedComponentsHTML += '</ul>';
document.getElementById('userProjects').innerHTML = projectsHTML;
document.getElementById('userBorrowedComponents').innerHTML = borrowedComponentsHTML;
$('#userInfoModal').modal('show');
}
};
xhr.send("id=" + userId);
}
</script>
<!-- User Info Modal -->
<div class="modal fade" id="userInfoModal" tabindex="-1" role="dialog" aria-labelledby="userInfoModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg" role="document">
<div class="modal-content">
<div class="modal-header">
<h2 class="modal-title" id="userInfoModalLabel">User Information</h2>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div id="userProjects"></div>
<div id="userBorrowedComponents"></div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</body>
</html>