File: /home/bibuzptr/elearning.bibu-edu.us/current/lecturers/course-grades.php
<?php
ob_start();
session_start();
include_once('../includes/db_connect.php');
$today = date('Y-m-d');
$now = date('Y-m-d H:i:s');
$year = date("Y");
if(isset($_SESSION["OpenUniL^###DHSG"])){
$email = $_SESSION["OpenUniL^###DHSG"];
$chkuser = mysqli_query($con,"SELECT * FROM lecturers WHERE email='$email'");
while($row = mysqli_fetch_assoc($chkuser)){
$name = $row["fullname"];
$icon = $row["profilepic"];
$campus=$row["campus"];
}
}
else{
header("Location:../../staff-login.php");
}
$expld_url = $_SERVER["REQUEST_URI"];//explode("/", $_SERVER["REQUEST_URI"]);
if($_GET['fbclid']){
$url= $expld_url;
$pos = strpos($url, "?");
$url = substr($url, 0, $pos);
}else{
$url= $expld_url;
}
$expld_url = explode("/", $url);
$url = end($expld_url);
if(!empty($url)){
$lb=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM courses WHERE url='$url'"));
$courseid=$lb["id"];
$catid=$lb["category"];
$title=$lb["title"];
$catdetails=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM categories WHERE id='$catid'"));
}else{
header("Location:../../");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
<title>Lecturer Dashboard | Breakthrough Open University</title>
<link rel="shortcut icon" type="image/x-icon" href="../../assets/img/logo.png">
<!--<link rel="stylesheet" href="../../assets/css/bootstrap.min.css">-->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css">
<link rel="stylesheet" href="../../assets/plugins/fontawesome/css/fontawesome.min.css">
<link rel="stylesheet" href="../../assets/plugins/fontawesome/css/all.min.css">
<link rel="stylesheet" href="../../assets/css/feather.css">
<link rel="stylesheet" href="../../assets/css/style.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.3/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
<style>
#dash{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
.nav-link{
color:#fff;
}
#catmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#catmodal h2{
text-align: left;
}
@media (max-width: 392.98px) {
#pgc{
margin-top:50%;
background: #fafafa;
}
}
@media (max-width: 767.98px) {
#pgc{
margin-top:42%;
background: #fafafa;
}
}
@media (max-width: 992.98px) {
#pgc{
margin-top:20%;
background: #fafafa;
}
}
@media (min-width: 992.98px) {
#pgc{
margin-top:11%;
background: #fafafa;
}
}
</style>
</head>
<body>
<div class="main-wrapper">
<?php //include_once("../includes/header-course.php") ?>
<div style="margin-top:0%;" class="course-student-header header-fixed">
<div class="container">
<div class="student-group">
<div class="course-group ">
<div class="course-group-img d-flex">
<a href="../#"><img src="../../lecturer-images/<?php echo $icon ?>" alt class="img-fluid"></a>
<div class="d-flex align-items-center">
<div class="course-name">
<h4><a href="../#"><?php echo $name ?></a></h4>
</div>
</div>
</div>
<!--<div class="course-share ">-->
<!--<a href="javascript:void(0);" class="btn btn-primary">Account Settings</a>-->
<!--</div>-->
</div>
</div>
<nav class="navbar navbar-expand-lg navbar-dark bg-dark1">
<div class="container-fluid">
<a class="navbar-brand" href="#"></a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup" aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNavAltMarkup">
<div class="navbar-nav">
<a class="nav-link" href="../../">Home</a>
<a class="nav-link" href="../../courses">All Courses</a>
<a class="nav-link active" href="../index.php">Dashboard</a>
<a class="nav-link " href="../my-students.php">My Students</a>
<a class="nav-link" href="../logout.php">Logout</a>
</div>
</div>
</div>
</nav>
</div>
</div>
<div id="pgc" class="page-content1">
<div class="container1" style="margin-left:2%; margin-right:2%">
<div class="row">
<div class="col-xl-12 col-md-12">
<div class="settings-widget">
<div class="settings-inner-blk p-0">
<div class="comman-space pb-0">
<div class="filter-grp ticket-grp d-flex align-items-center justify-content-between">
<h3><?php echo $lb['title'] ?></h3>
</div>
<div class="settings-tickets-blk table-responsive">
<div class="course-feature">
<div class="row1">
<table id="dataTable" class="table table-nowrap mb-0 table-striped">
<thead>
<tr>
<th>Pic</th>
<th>Name</th>
<th>Adm No</th>
<th>Marks</th>
<th>Out of</th>
</tr>
</thead>
<tbody>
<?php
$listcat=mysqli_query($con,"SELECT quizanswer.*,docquizs.docessay,SUM(quizanswer.marks) AS markstotal,SUM(docquizs.docmarks) AS doctotal FROM quizanswer,docquizs WHERE quizanswer.marks!='' AND quizanswer.quizid=docquizs.id AND lessonid IN (SELECT lessons.id FROM lessons, units WHERE lessons.unitid=units.id AND units.courseid='$courseid') GROUP BY quizanswer.studentid");
while($lc=mysqli_fetch_assoc($listcat)){
$unitid=$lc["id"];
$stdid=$lc["id"];
$studentid = $lc["studentid"];
$student=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM students WHERE id='$studentid'"));
?>
<tr>
<td style="width:100px; height:auto">
<img style="width:50%; height:auto; max-height:100px" src="../../student-images/<?php echo $student["icon"];?>" class="img-fluid " alt='<?php echo $student["name"];?>'>
</td>
<td><a target="_blank" href="#"><?php echo $student["name"];?></a></td>
<td><?php echo $student["admno"];?></td>
<td><?php echo $lc["markstotal"] ?></td>
<td><?php echo $lc["doctotal"] ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="catmodal" class="catmodal modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h6><i class="fa fa-list-alt"></i> <span id="addcat">Enroll Student to <?php echo $title ?></span></h6>
</div>
<form role="form" id="catfrm" method="post" enctype="multipart/form-data">
<div class="row" id="login">
<div class="form-group">
<label>Student Name <span>*</span></label>
<input type="hidden" value="<?php echo $courseid ?>" name="courseid" id="courseid">
<select class="form-control" name="studentid" id="studentid" required>
<option value="">Select student</option>
<?php
$listcountr=mysqli_query($con,"SELECT * FROM students WHERE campus='$campus' AND id NOT IN(SELECT studentid FROM mycourses WHERE courseid='$courseid') ORDER BY name ASC");
while($ls=mysqli_fetch_assoc($listcountr)){ ?>
<option value="<?php echo $ls['id'] ?>"><?php echo $ls['name'] ?></option>
<?}
?>
</select>
</div>
<div class="form-group">
<label>Enrollment Date<span>*</span></label>
<input class="form-control" type="date" name="today" id="today" required>
</div>
<div class="form-group" style="border-top: 1px solid #ddd;padding-top: 5px;">
<button class="btn btn-primary" type="submit"> <i class="fa fa-save"></i> Enroll Student</button>
<div id="status11"></div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<script src="../../assets/js/jquery-3.7.1.min.js" type="6e5e9f9c9777ea4d37f1a68a-text/javascript"></script>
<script src="../../assets/js/bootstrap.bundle.min.js" type="6e5e9f9c9777ea4d37f1a68a-text/javascript"></script>
<?php include_once("../includes/footer-course2.php") ?>
<script>
$('#dataTable').DataTable({"aaSorting" : []});
$("#catfrm").submit(function(e){
e.preventDefault();
var formdata= new FormData(this);
var courseid = $("#courseid").val();
var courseid = $("#studentid").val();
$("#status11").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Enrolling student to course...</p>");
$.ajax({
method: "POST",
url: "../app/enrollstudent",
data: new FormData(this),
contentType: false,
processData: false,
cache:false
}).done(function(data){
if(data.status == "200"){
$("#status11").html("<p class=' bg-success'><i class='fa fa-check'></i> student enrolled successfully.</p>");
window.location.replace("../course-students/<?php echo $url ?>");
}
if(data.message == "ERROR"){
$("#status11").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later.</p>");
}
});
});
</script>
</body>
</html>