-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupload1.php
152 lines (141 loc) · 6.72 KB
/
upload1.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
148
149
150
151
152
<?php
include('src/config.php');
include('src/functions.php');
// Check if an appointment is approved or rejected
if(isset($_GET['id'])) {
$appointment_id = $_GET['id'];
// Assuming you have a 'status' column in your database table
$status = $_GET['status'];
if($status == 'approved') {
$query = "INSERT INTO approved_appointments (appointment_id) VALUES ('$appointment_id')";
} elseif($status == 'rejected') {
$query = "INSERT INTO rejected_appointments (appointment_id) VALUES ('$appointment_id')";
}
$result = mysqli_query($con, $query);
if($result) {
header('Location: upload.php');
exit();
} else {
echo "Error: Unable to save the appointment.";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Non-stop Healthcare : Upload</title>
<?php include('src/head.php') ?>
<style>
.table thead th {
background-color: #d4edda;
border-bottom: 2px solid #28a745;
}
.table-bordered {
border: 1px solid #d4edda;
}
.table-bordered td, .table-bordered th {
border: 1px solid #d4edda;
}
.btn-success {
background-color: #28a745;
border-color: #28a745;
}
.btn-danger {
background-color: #dc3545;
border-color: #dc3545;
}
.appointments-heading {
text-align: center;
font-weight: bold;
}
</style>
</head>
<body>
<?php include('src/preload.php') ?>
<?php include('src/header.php') ?>
<?php include('src/session_check.php'); ?>
<section id="service">
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="service-area">
<div class="section-heading">
<h2>Test Appointments</h2>
</div>
<div class="service-content">
<div class="row">
<div class="col-lg-12 col-md-12">
<h4 class="appointments-heading">Approved Appointments</h4>
<table class="table table-hover table-bordered">
<thead>
<tr>
<th>Test</th>
<th>Name</th>
<th>Date</th>
<th>Time</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
$sql = mysqli_query($con, "SELECT * FROM test_appointment JOIN client ON test_appointment.users_id=client.id WHERE status = 'approved' ORDER BY Test_date, Test_time");
while ($row = mysqli_fetch_array($sql)) {
$test = $row['Test_id'];
$sql2 = mysqli_query($con, "SELECT * FROM test WHERE id='$test'");
$row2 = mysqli_fetch_array($sql2);
?>
<tr>
<td><?= $row2['test_name'] ?></td>
<td><?= $row['Name'] ?></td>
<td><?= $row['Test_date'] ?></td>
<td><?= $row['Test_time'] ?></td>
<td><?= $row['status'] ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
<h4 class="appointments-heading">Rejected Appointments</h4>
<table class="table table-hover table-bordered">
<thead>
<tr>
<th>Test</th>
<th>Name</th>
<th>Date</th>
<th>Time</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
$sql = mysqli_query($con, "SELECT * FROM test_appointment JOIN client ON test_appointment.users_id=client.id WHERE status = 'rejected' ORDER BY Test_date, Test_time");
while ($row = mysqli_fetch_array($sql)) {
$test = $row['Test_id'];
$sql2 = mysqli_query($con, "SELECT * FROM test WHERE id='$test'");
$row2 = mysqli_fetch_array($sql2);
?>
<tr>
<td><?= $row2['test_name'] ?></td>
<td><?= $row['Name'] ?></td>
<td><?= $row['Test_date'] ?></td>
<td><?= $row['Test_time'] ?></td>
<td><?= $row['status'] ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<?php include('src/footer.php') ?>
<?php include('src/incfooter.php') ?>
</body>
</html>