forked from iam-abbas/Campus-Maintenance-System
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcomps.php
99 lines (90 loc) · 2.16 KB
/
comps.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
<?php
session_start();
require_once 'inc.php';
require_once 'config.php';
if(!isset($_SESSION['name'])) {
header("Location: login.php");
die();
}
if(isset($_GET['cid'])) {
include('html.php');
$id = $_SESSION['id'];
sethead("View Complaint");
$adminhtml = '';
$cid = $_GET['cid'];
$sql_query2 = "SELECT * FROM `complaints` WHERE `id` = '{$cid}' LIMIT 1 ";
$result2 = mysqli_query($con, $sql_query2);
$row2 = mysqli_fetch_assoc($result2);
if(!isAdmin($id, $con)) {
if($id != $row2['comp_by']) {
header("Location: dashboard.php");
die();
}
}
$sql_query = "SELECT * FROM `users` WHERE `id` = '{$row2['comp_by']}'";
$result = mysqli_query($con,$sql_query);
$row = mysqli_fetch_assoc($result);
if(isAdmin($id, $con)) {
$adminhtml = "
<tr>
<th>Degree</th>
<td>".$row['deg']."</td>
</tr>
<tr>
<th>Course</th>
<td>".$row['crs']."</td>
</tr>
";
}
if(isset($_POST['submit'])) {
$sql_query3 = mysqli_query($con, "UPDATE `complaints` SET `completed` = '1' WHERE `id` = {$cid}");
header("Location: dashboard.php");
die();
}
if($row2['completed'] == 1) {
$status = "Completed";
} else {
$status = "Pending";
}
?>
<table class="table">
<thead class="thead-dark">
<tr>
<th>Name</th>
<td><?=$row['name']?></td>
</tr>
<?=$adminhtml?>
<tr>
<th>Rollnumber</th>
<td><?=$row['roll']?></td>
</tr>
<tr>
<th>Department</th>
<td><?=$row2['dept']?></td>
</tr>
<tr>
<th>Complaint</th>
<td><?=$row2['complaint']?></td>
</tr>
<tr>
<th>Status</th>
<td><?=$status?></td>
</tr>
<tr>
<th>Room and Tower</th>
<td><?=$row['room']?> / T<?=$row['tower']?></td>
</tr>
</thead>
</table>
<center>
<form method="post" name="done">
<button type="submit" name="submit" class="btn btn-default">Mark as done</button>
</form>
<a href="dashboard.php"><buttonclass="btn btn-default">Go Back</button></a>
</center>
<?php
} else {
header("Location: dashboard.php");
die();
}
?>