-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathteacherDashboard.php
73 lines (62 loc) · 3.74 KB
/
teacherDashboard.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
<?php
include 'config.php';
session_start();
if (isset($_SESSION['user_name']) && isset($_SESSION['COO_id'])) {
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="styleOthers.css">
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-+0n0xVW2eSR5OomGNYDnhzAbDsOXxcvSN1TPprVMTNDbiYZCxYbOOl7+AMvyTG2x" crossorigin="anonymous">
<title>teacherDashboard</title>
</head>
<body>
<div class="section ">
<h1 class="fs-5"><?php echo "User Name : " . $_SESSION['user_name'] . " <br>COO id : " . $_SESSION['COO_id']; ?></h1>
<a href="logout.php">Logout</a>
</div>
<h1 class="fw-bold">Subjects</h1>
<!-- show subjects -->
<?php
$COO_id = $_SESSION['COO_id'];
$query = "SELECT * FROM subject WHERE (subject_id) IN (SELECT subject_id FROM subject WHERE (subject_id) IN (select subject_id from subject_manager WHERE COO_id=(SELECT COO_id FROM co_ordinator_co_ordinator_type WHERE co_ordinator_type='Subject_Co_Ordinator' AND COO_id='$COO_id'))) OR (subject_id) IN ( SELECT subject_id FROM subject WHERE (subject_id) IN (SELECT subject_id FROM subject WHERE class_number=(SELECT class_number FROM class WHERE COO_id=(SELECT COO_id FROM co_ordinator_co_ordinator_type WHERE co_ordinator_type='Class_Co_Ordinator'AND COO_id= '$COO_id' )))) ORDER BY class_number;";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
$temp = $row["subject_id"]; ?>
<div class="section">
<h3 class="fs-2"><a href="weeks.php?data=<?= $temp ?>"> <?php echo $row["subject_id"] ?></a></h3>
<h3 class="h3"><a href="weeks.php?data=<?= $temp ?>"> <?php echo $row["subject_name"] ?></a></h3>
</div>
<?php }
} else {
echo "<h2> you have no allocated subject </h2>";
}
?>
<!-- end subject showing-->
<h1 class="fw-bold">GRADING</h1>
<!-- show subjects for grading -->
<?php
$COO_id = $_SESSION['COO_id'];
$query = "SELECT * FROM subject WHERE (subject_id) IN (SELECT subject_id FROM subject WHERE (subject_id) IN (select subject_id from subject_manager WHERE COO_id=(SELECT COO_id FROM co_ordinator_co_ordinator_type WHERE co_ordinator_type='Subject_Co_Ordinator' AND COO_id='$COO_id'))) OR (subject_id) IN ( SELECT subject_id FROM subject WHERE (subject_id) IN (SELECT subject_id FROM subject WHERE class_number=(SELECT class_number FROM class WHERE COO_id=(SELECT COO_id FROM co_ordinator_co_ordinator_type WHERE co_ordinator_type='Class_Co_Ordinator'AND COO_id= '$COO_id' )))) ORDER BY class_number;";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
$temp = $row["subject_id"]; ?>
<div class="section">
<h3 class="h3"><a href="grading.php?grading=<?= $temp ?>"> <?php echo $row["subject_id"] ?></a></h3>
</div>
<?php }
} else {
echo "<h2> you have no allocated subject </h2>";
}
?>
<!-- end subject showing for grading -->
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js" integrity="sha384-gtEjrD/SeCtmISkJkNUaaKMoLD0//ElJ19smozuHV6z3Iehds+3Ulb9Bn9Plx0x4" crossorigin="anonymous"></script>
</body>
</html>
<?php } else {
header("Location: teacherLogin.php");
} ?>