File: /home/bibuzptr/elearning.bibu-edu.us/old 20th oct/openuni/dashboard/unit-learning.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["OpenUniS^###DHSG"])){
$email = $_SESSION["OpenUniS^###DHSG"];
$chkuser = mysqli_query($con,"SELECT * FROM students WHERE email='$email'");
while($row = mysqli_fetch_assoc($chkuser)){
$studentid = $row["id"];
$name = $row["name"];
$admno = $row["admno"];
$icon = $row["icon"];
}
if(isset($_GET["unitid"])){
$unitid=$_GET["unitid"];
$unitdetails=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM units WHERE id='$unitid'"));
$courseid=$unitdetails["courseid"];
$unittitle=$unitdetails["unittitle"];
//$course
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM mycourses WHERE courseid='$courseid' AND studentid='$studentid'"))>0){
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM unitlearning WHERE unitid='$unitid' AND studentid='$studentid'"))<1){
mysqli_query($con,"INSERT INTO unitlearning(unitid,studentid,courseid) VALUES('$unitid','$studentid','$courseid')");
}
}else{
header("Location:dashboard/");
}
}else{
header("Location:dashboard/");
}
}
else{
header("Location:../login.php");
}
?>
<!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><?php echo $unittitle ?> - Student 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="../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>
<style>
#dash{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
.nav-link{
color:#fff;
}
@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 id="myDiv" class="main-wrapper">
<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="student-profile.php"><img src="../student-images/<?php echo $icon ?>" alt class="img-fluid"></a>
<div class="d-flex align-items-center">
<div class="course-name">
<h4><a href="student-profile.php"><?php echo $name ?></a><span><?php echo $admno ?></span></h4>
</div>
</div>
</div>
<!--<div class="course-share ">-->
<!--<a href="javascript:void(0);" class="btn btn-primary">Account Settings</a>-->
<!--</div>-->
</div>
</div>
<!--<div class="my-student-list">-->
<!--<ul>-->
<!--<li><a href="../">Home</a></li>-->
<!--<li><a href="index.php">Dashboard</a></li>-->
<!--<li><a class="active" href="index.php">My Courses</a></li>-->
<!--<li><a href="messages.php">Messages</a></li>-->
<!--<li><a href="profile.php">Profile</a></li>-->
<!--<li class="mb-0"><a href="logout.php">Logout</a></li>-->
<!--</ul>-->
<!--</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="logout.php">Logout</a>
</div>
</div>
</div>
</nav>
</div>
</div>
<section id="pgc" class="page-content1 course-sec course-lesson">
<div class="container">
<div class="row">
<div class="col-md-12">
<h3><?php echo $unittitle ?></h3>
<?php
$lessonsdone=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) as theprogress FROM learningprogress WHERE studentid='$studentid' AND unitid='$unitid'"))["theprogress"];
$listlessons=mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid'");
$nooflessons=mysqli_num_rows($listlessons);
$percentdone=number_format($lessonsdone/$nooflessons*100,2);
?>
<div class="progress-stip">
<div class="progress-bar bg-success progress-bar-striped active-stip1" role="progressbar" aria-valuenow="<?php echo $percentdone ?>"
aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $percentdone ?>%"></div><?php echo $percentdone ?>%
</div>
<hr>
</div>
<div class="col-lg-4">
<div class="lesson-group">
<?php
$listlessons=mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid'");
$nooflessons=mysqli_num_rows($listlessons);
while($ll=mysqli_fetch_assoc($listlessons)){
?>
<div class="course-card">
<h6 class="cou-title">
<a class="collapsed" data-bs-toggle="collapse1" aria-expanded="false"><?php echo $ll["lessontitle"] ?> <span><?php echo $ll["hours"] ?></span> </a>
</h6>
</div>
<?php } ?>
</div>
</div>
<div class="col-lg-8">
<?php
$lastunit=mysqli_query($con,"SELECT * FROM learningprogress WHERE studentid='$studentid' AND unitid='$unitid' ORDER BY id DESC LIMIT 1");
$queryforallunits=mysqli_query($con,"SELECT * FROM learningprogress WHERE studentid='$studentid' AND unitid='$unitid' ORDER BY id DESC");
$allunits=mysqli_num_rows($queryforallunits);
if(mysqli_num_rows($lastunit)>0){
while($lu=mysqli_fetch_assoc($lastunit)){
$lessonid=$lu["lessonid"];
}
if($allunits>1){
$previous="1";
}else{
$previous="0";
}
$nextid=mysqli_fetch_assoc(mysqli_query($con,"SELECT MIN(id) AS nextid FROM lessons WHERE id>'$lessonid' AND unitid='$unitid'"))["nextid"];
//$nextid=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid' LIMIT 1, $lessonid"))["id"];
}else{
//get first id
$lessonid=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid' ORDER BY id ASC LIMIT 1"))["id"];
$previous="0";
$nextid=mysqli_fetch_assoc(mysqli_query($con,"SELECT MIN(id) AS nextid FROM lessons WHERE id>'$lessonid' AND unitid='$unitid'"))["nextid"];
}
if(mysqli_num_rows($lastunit)<1){
$currentlesson=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lessons WHERE id='$lessonid'"));;
$currentlessonid=$currentlesson["id"];
}else{
$currentlesson=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lessons WHERE id='$nextid'"));
$currentlessonid=$currentlesson["id"];
}
$nextid1=mysqli_fetch_assoc(mysqli_query($con,"SELECT MIN(id) AS nextid FROM lessons WHERE id>'$currentlessonid' AND unitid='$unitid'"))["nextid"];
if($nooflessons==$allunits){
$next="0";
}else{
$next="1";
}
$previousid1=mysqli_fetch_assoc(mysqli_query($con,"SELECT MAX(id) AS previousid FROM lessons WHERE id<'$currentlessonid' AND unitid='$unitid'"))["previousid"];
if($nooflessons>$allunits){
$previous="1";
}else{
$previous="0";
}
?>
<div class="student-widget lesson-introduction">
<div class="lesson-widget-group">
<h4 class="tittle">
<?php
echo $currentlesson["lessontitle"]
?>
</h4>
<div style="max-height: 250px; overflow-y: scroll;" class="introduct-video">
<p><?php echo $currentlesson["lessonnotes"] ?></p>
</div>
</div>
</div>
<ul class="pager">
<?php if($previous=="1"){ ?>
<li class="previous"><a style="cursor:pointer" id="<?php echo $currentlessonid ?>" data-previous="<?php echo $previousid1?>" class="previousid">Previous</a></li>
<?php } ?>
<?php if($next=="1"){ ?>
<li class="next"><a style="cursor:pointer" id="<?php echo $currentlessonid ?>" data-next="<?php echo $nextid1?>" class="nextid">Next</a></li>
<?php } ?>
<p id="status11"></p>
</ul>
</div>
</div>
</div>
</section>
<?php include_once("../includes/footer-course.php") ?>
<script>
$(".nextid").click(function(){
var lessonid=$(this).attr("id");
var nextid=$(this).attr("data-next");
var unitid="<?php echo $unitid ?>"
var studentid="<?php echo $studentid ?>"
$("#status11").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Updating. Please wait...</p>");
$.ajax({
url : "app/unitprogress",
type: "POST",
data : {lessonid:lessonid,nextid:nextid,studentid:studentid,unitid:unitid}
}).done(function(data){
if(data.status == "200"){
$("#status11").html("");
$('#myDiv').delay(1).load('unit-learning?unitid='+unitid);
//$("#status11").html("<p class=' bg-success'><i class='fa fa-check'></i> quiz saved successfully.</p>");
// window.location.replace("lesson-config?id=<?php echo $lessonid ?>");
}
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>");
}
});
})
$(".previousid").click(function(){
var lessonid=$(this).attr("id");
var previousid=$(this).attr("data-previous");
var unitid="<?php echo $unitid ?>"
var studentid="<?php echo $studentid ?>"
$("#status11").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Updating. Please wait...</p>");
$.ajax({
url : "app/unitprogress",
type: "POST",
data : {lessonid:lessonid,previousid:previousid,studentid:studentid,unitid:unitid}
}).done(function(data){
if(data.status == "200"){
$("#status11").html("");
$('#myDiv').delay(1).load('unit-learning?unitid='+unitid);
//$("#status11").html("<p class=' bg-success'><i class='fa fa-check'></i> quiz saved successfully.</p>");
// window.location.replace("lesson-config?id=<?php echo $lessonid ?>");
}
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>
</html>