File: /home/bibuzptr/tvetelearning.bibu-edu.us/admin/lesson-config.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["OpenUni^###DHSG"])){
$email = $_SESSION["OpenUni^###DHSG"];
$chkuser = mysqli_query($con,"SELECT * FROM admins WHERE admin_email='$email'");
while($row = mysqli_fetch_assoc($chkuser)){
$id = $row["id"];
$name = $row["admin_name"];
}
$lessonid=$_GET['id'];
$query=mysqli_query($con,"SELECT * FROM lessons WHERE id='$lessonid'");
if(mysqli_num_rows($query)>0){
$lessondet=mysqli_fetch_assoc($query);
$lessonid=$lessondet["courseid"];
$lessonid=$lessondet["id"];
}else{
header("Location:courses.php");
}
}
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 $lessondet['lessontitle'] ?> | 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" href="../assets/css/dashboard2.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>
<script src="https://cdn.ckeditor.com/4.14.0/standard/ckeditor.js"></script>
<style>
#cour{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
#quizmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#quizmodal h2{
text-align: left;
}
#edtquizmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#edtquizmodal h2{
text-align: left;
}
.menu{
background: #fff;
margin-top: -20px;
margin-bottom: 5px;
padding: 10px 0px 10px 20px;
border-bottom: 1px solid #ddd;
}
.menu .item{
background: #1e8c70;
font-size: 13px;
color: #fff;
padding: 5px 10px 5px 10px;
cursor: pointer;
}
</style>
</head>
<body>
<div class="main-wrapper">
<?php include_once("../includes/header-courses.php") ?>
<div class="page-content">
<div class="container">
<div class="row">
<div class="col-xl-3 col-lg-4 col-md-12 theiaStickySidebar">
<?php include_once("includes/aside.php") ?>
</div>
<div class="col-xl-9 col-lg-8 col-md-12">
<div class="row">
<div class="col-md-12">
<div class="settings-widget">
<div class="settings-inner-blk p-0">
<div class="sell-course-head comman-space">
<div class="row">
<div class="col-md-3">
<h3>Configure <?php echo $lessondet['lessontitle'] ?> </h3>
<p></p>
</div>
<div class="col-md-9">
<div class="go-dashboard text-center">
<a data-bs-toggle="modal" data-bs-target="#quizmodal" class="btn btn-primary btn-sm">Multiple Choice Exam</a> |
<a data-bs-toggle="modal" data-bs-target="#docquizmodal" class="btn btn-primary btn-sm">Essay Exam</a>
</div>
</div>
</div>
</div>
<div class="comman-space pb-0">
<div class="settings-tickets-blk course-instruct-blk table-responsive">
<table id="dataTable" class="table table-striped table-nowrap mb-2">
<thead>
<tr>
<th>Exam Title</th>
<th>A</th>
<th>B</th>
<th>C</th>
<th>D</th>
<th>Correct</th>
<th style="display:none">Course</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$chkplanners = mysqli_query($con,"SELECT * FROM quizs WHERE lessonid='$lessonid' ORDER BY id DESC");
while($row = mysqli_fetch_assoc($chkplanners)){
$quizid = $row["id"];
$status = $row["status"];
$lessonid=$row["lessonid"];
?>
<tr>
<td><?php echo $row["title"];?></td>
<td><?php echo $row["answera"];?></td>
<td><?php echo $row["answerb"];?></td>
<td><?php echo $row["answerc"];?></td>
<td><?php echo $row["answerd"];?></td>
<td><?php echo $row["correctanswer"];?></td>
<td style="display:none"><?php echo mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lessons WHERE id='$lessonid'"))['lessontitle'] ?></td>
<td>
<a data-toggle="tooltip" data-placement="bottom" title="Edit Exam">
<button class="btn btn-sm btn-primary edtquiz" id="<?php echo $quizid;?>" data-title="<?php echo $row["title"];?>" data-answera="<?php echo $row["answera"];?>" data-answerb="<?php echo $row["answerb"];?>" data-answerc="<?php echo $row["answerc"];?>" data-answerd="<?php echo $row["answerd"];?>" data-correctanswer="<?php echo $row["correctanswer"];?>"><i class="fa fa-edit"></i></button>
</a>
<button class="btn btn-sm btn-danger delquiz" id="<?php echo $quizid;?>" data-toggle="tooltip" data-placement="bottom" title="Delete Exam"><i class="fa fa-trash"></i></button>
<?php
if($status=="1"){ ?>
<a id="<?php echo $quizid ?>" title="deActivate" class="deactivate btn btn-sm btn-success"><i class="fa fa-toggle-on"> </i></a>
<?php }else{?>
<a id="<?php echo $quizid ?>" title="Activate" class="activate btn btn-sm btn-warning"><i class="fa fa-toggle-off"> </i></a>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
<div class="comman-space pb-0">
<h3>Document Exams</h3>
<div class="settings-tickets-blk course-instruct-blk table-responsive">
<table id="dataTable2" class="table table-striped table-nowrap mb-2">
<thead>
<tr>
<th>Exam</th>
<th>Total Weight</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$chkplanners = mysqli_query($con,"SELECT * FROM docquizs WHERE doclessonid='$lessonid' ORDER BY id DESC");
while($row = mysqli_fetch_assoc($chkplanners)){
$quizid = $row["id"];
$status = $row["status"];
$lessonid=$row["lessonid"];
?>
<tr>
<td><?php echo $row["docessay"];?><a style="display:none" target="_blank" href="../docquizs/<?php echo $row["docfile"];?>"><i class="fa fa-file fa-2x"></i></a></td>
<td><?php echo $row["docmarks"];?></td>
<td>
<a style="display:none" data-toggle="tooltip" data-placement="bottom" title="Edit Exam">
<button class="btn btn-sm btn-primary edtquiz" id="<?php echo $quizid;?>" data-title="<?php echo $row["title"];?>" data-answera="<?php echo $row["answera"];?>" data-answerb="<?php echo $row["answerb"];?>" data-answerc="<?php echo $row["answerc"];?>" data-answerd="<?php echo $row["answerd"];?>" data-correctanswer="<?php echo $row["correctanswer"];?>"><i class="fa fa-edit"></i></button>
</a>
<button class="btn btn-sm btn-danger delquiz1" id="<?php echo $quizid;?>" data-toggle="tooltip" data-placement="bottom" title="Delete Exam"><i class="fa fa-trash"></i></button>
<?php
if($status=="1"){ ?>
<a style="display:none" id="<?php echo $quizid ?>" title="deActivate" class="deactivate btn btn-sm btn-success"><i class="fa fa-toggle-on"> </i></a>
<?php }else{?>
<a style="display:none" id="<?php echo $quizid ?>" title="Activate" class="activate btn btn-sm btn-warning"><i class="fa fa-toggle-off"> </i></a>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="quizmodal" class="quizmodal modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4><i class="fa fa-list-alt"></i> <span id="addcourse">Add Exam</span></h4>
</div>
<div class="add-course-form">
<form method="post" role="form" id="quizfrm" enctype="multipart/form-data">
<div class="add-course-inner-header">
<h4></h4>
</div>
<div class="input-block">
<label class="add-course-label">Exam Title</label>
<input type="hidden" name="lessonid" id="lessonid" value="<?php echo $lessondet['id'] ?>">
<input type="hidden" name="id" id="id">
<input type="text" class="form-control" placeholder="Exam Title" name="title" id="title" required>
</div>
<div class="input-block mb-0">
<label class="add-course-label">Answer A</label>
<input type="text" class="form-control" placeholder="" name="answera" id="answera" required>
</div>
<div class="input-block mb-0">
<label class="add-course-label">Answer B</label>
<input type="text" class="form-control" placeholder="" name="answerb" id="answerb" required>
</div>
<div class="input-block mb-0">
<label class="add-course-label">Answer C</label>
<input type="text" class="form-control" placeholder="" name="answerc" id="answerc">
</div>
<div class="input-block mb-0">
<label class="add-course-label">Answer D</label>
<input type="text" class="form-control" placeholder="" name="answerd" id="answerd">
</div>
<div class="input-block mb-0">
<label class="add-course-label">Correct Answer</label>
<input type="text" class="form-control" placeholder="Enter A,B,C or D" name="correctanswer" id="correctanswer" required>
</div>
<button type="submit" class="btn btn-success btn-lg"><i class="fa fa-save"> </i>Save</button>
<p id="status11"></p>
</form>
</div>
</div>
</div>
</div>
<div id="docquizmodal" class="quizmodal modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4><i class="fa fa-list-alt"></i> <span id="addcourse">Add Exam</span></h4>
</div>
<div class="add-course-form">
<form method="post" role="form" id="docquizfrm" enctype="multipart/form-data">
<div class="add-course-inner-header">
<h4></h4>
</div>
<div class="input-block">
<label class="add-course-label">Write Exam</label>
<input type="hidden" name="doclessonid" id="doclessonid" value="<?php echo $lessondet['id'] ?>">
<input type="hidden" name="docid" id="docid">
<input style="display:none" type="file" class="form-control" name="docfile" id="docfile">
<textarea class="form-control" name="docessay" id="docessay" required></textarea>
</div>
<div class="input-block mb-0">
<label class="add-course-label">Weight (total marks of quiz)</label>
<input type="number" class="form-control" placeholder="eg. 20" name="docmarks" id="docmarks" required>
</div>
<button type="submit" class="btn btn-success btn-lg"><i class="fa fa-save"> </i>Save</button>
<p id="status12"></p>
</form>
</div>
</div>
</div>
</div>
<?php include_once("../includes/footer-course.php") ?>
<script>
$('#dataTable').DataTable({"aaSorting" : []});
$('#dataTable2').DataTable({"aaSorting" : []});
$("#quizfrm").submit(function(e){
e.preventDefault();
$("#status11").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Saving the quiz...</p>");
$.ajax({
method: "POST",
url: "app/quizs",
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> 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>");
}
});
});
$("#docquizfrm").submit(function(e){
e.preventDefault();
$("#status12").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Saving the quiz...</p>");
$.ajax({
method: "POST",
url: "app/quizs",
data: new FormData(this),
contentType: false,
processData: false,
cache:false
}).done(function(data){
if(data.status == "200"){
$("#status12").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"){
$("#status12").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later.</p>");
}
});
});
//Activate a course
$(".activate").click(function(){
var quizid = $(this).attr("id");
var d = confirm('Are you sure you want to activate this quiz?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-quiz",
data:{quizid:quizid},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("quiz activated successfully");
window.location.replace("lesson-config?id=<?php echo $lessonid ?>");
}else{
alert("error activating quiz");
}
});
}
});
//DeActivate a course
$(".deactivate").click(function(){
var quizid2 = $(this).attr("id");
var d = confirm('Are you sure you want to deactivate this quiz?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-quiz",
data:{quizid2:quizid2},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("quiz deactivated successfully");
window.location.replace("lesson-config?id=<?php echo $lessonid ?>");
}else{
alert("error deactivating quiz");
}
});
}
});
//Delete a course
$(".delquiz").click(function(){
var quizid3 = $(this).attr("id");
var d = confirm('Are you sure you want to delete this quiz?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-quiz",
data:{quizid3:quizid3},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("quiz deleted successfully");
window.location.replace("lesson-config?id=<?php echo $lessonid ?>");
}else{
alert("error deleting quiz");
}
});
}
});
//Delete a course
$(".delquiz1").click(function(){
var quizid4 = $(this).attr("id");
var d = confirm('Are you sure you want to delete this quiz?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-quiz",
data:{quizid4:quizid4},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("quiz deleted successfully");
window.location.replace("lesson-config?id=<?php echo $lessonid ?>");
}else{
alert("error deleting quiz");
}
});
}
});
//edit course
$(".edtquiz").click(function(){
$("#id").val($(this).attr("id"));
$("#title").val($(this).attr("data-title"));
$("#answera").val($(this).attr("data-answera"));
// CKEDITOR.instances['description'].setData($(this).attr("data-quiznotes"));
$("#answerb").val($(this).attr("data-answerb"));
$("#answerc").val($(this).attr("data-answerc"));
$("#answerd").val($(this).attr("data-answerd"));
$("#correctanswer").val($(this).attr("data-correctanswer"));
$("#addcourse").html("Edit Exam")
$("#img").hide()
$("#img1").hide()
$("#img11").hide()
$('.quizmodal').modal('show');
});
</script>
</div>
</html>