File: /home/bibuzptr/elearning.bibu-edu.us/admin/campus-students.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 users WHERE email='$email'");
while($row = mysqli_fetch_assoc($chkuser)){
$id = $row["id"];
$name = $row["first_name"];
}
$campusid=$_GET["cid"];
if($campusid!=""){
}else{
header("Location:campuses");
}
}else{
header("Location:../adminlogin.php");
}
?>
<!DOCTYPE php>
<php lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
<title>Campuses | 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">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/css/bootstrap-select.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>
#cmpst{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
#catmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#catmodal h2{
text-align: left;
}
#completemodal #login{
width: 90%;
margin: 10px;
display: block;
}
#completemodal h2{
text-align: left;
}
#edtcampusmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#edtcampusmodal 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;
}
#emailmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#emailmodal h2{
text-align: left;
}
</style>
</head>
<body>
<div class="main-wrapper">
<?php include_once("../includes/header-course.php") ?>
<div style="margin-top:5%" 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-6">
<h3> Campuses </h3>
<p>Listing of all campus students and courses</p>
</div>
<div class="col-md-6">
<div class="go-dashboard text-center">
<!--<a class="btn btn-primary item item1" data-bs-toggle="modal" data-bs-target="#catmodal">Create New Campus</a>-->
<a class="btn btn-success btn-sm item item1" data-bs-toggle="modal" data-bs-target="#catmodal">Enroll Student to Course</a>
|
<a class="btn btn-warning btn-sm item item1" data-bs-toggle="modal" data-bs-target="#emailmodal">Send Email to Students</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>Campus Name</th>
<th>Student Name</th>
<th>Adm No</th>
<th>Course Title</th>
<th>Enroll Date</th>
<th>Graduation Date</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$chkplanners = mysqli_query($con,"SELECT mycourses.*,courses.title,students.admno,students.name,campuses.campusname FROM mycourses, courses,students,campuses WHERE mycourses.courseid=courses.id AND mycourses.studentid=students.id AND students.campus=campuses.id AND campuses.id='$campusid' ORDER BY mycourses.id DESC");
while($row = mysqli_fetch_assoc($chkplanners)){
$enrollid = $row["id"];
$countryid = $row["countryid"];
$status = $row["status"];
?>
<tr>
<td><?php echo $row["campusname"];?></td>
<td><?php echo $row["name"] ?></td>
<td><?php echo $row["admno"];?></td>
<td><?php echo $row["title"];?></td>
<td><?php echo date("d/m/Y",strtotime($row["enrolldate"]));?></td>
<td><?php if($row["graddate"]!=""){ echo date("d/m/Y",strtotime($row["graddate"])); };?></td>
<td>
<?php
if($status=="0"){
?>
<button class="btn btn-sm btn-success markascomplete" id="<?php echo $enrollid;?>" data-toggle="tooltip" data-placement="bottom" title=""><i class="fa fa-check"> </i>Mark as graduated</button>
<?php }else if($status=="1"){ ?>
<button class="btn btn-sm btn-info"><i class="fa fa-check"> </i>Graduated</button>
<?php } ?>
<button class="btn btn-sm btn-danger delcourse" id="<?php echo $enrollid;?>" data-toggle="tooltip" data-placement="bottom" title="Delete Program"><i class="fa fa-trash"></i></button>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Modal -->
<div class="modal fade" id="campusstudents-modal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg" role="document" style="overflow-y: initial !important">
<div class="modal-content">
<div class="modal-header">
<!--<button type="button" class="close" data-dismiss="modal" aria-label="Close">-->
<!-- <span aria-hidden="true">×</span>-->
<!--</button>-->
</div>
<div class="modal-body" style="height: 600px; overflow-y: auto;">
<center>
<small style="color:#3b6598"><span><img src="https://img.icons8.com/color/48/000000/purchase-order.png"> <u>Campus Students <small>as of </small><?php echo date('d M Y h:i A') ?> </u></span></small>
</center>
<form method="post" id="addstudentfrm">
<label>Add Student</label>
<input type="hidden" id="campusid" name="campusid">
<select class="form-control selectpicker1" name="studentid2" id="studentid2" data-live-search="true" required>
<option value="">Select Student</option>
<?php
$liststudents=mysqli_query($con,"SELECT * FROM students WHERE status='1' ORDER BY name ASC");
while($ls=mysqli_fetch_assoc($liststudents)){
?>
<option value="<?php echo $ls['id'] ?>"><?php echo $ls['name'] ?></option>
<?php } ?>
</select>
<button style="margin:5px" type="submit" class="btn btn-sm btn-success">Add Student to Campus</button>
<p id="status12"></p>
</form>
<table id="dataTable23" class="table table-striped">
<thead>
<tr>
<th>#</th>
<th>Adm No</th>
<th>Student Name</th>
<th>Student Email</th>
<th>Student Phone</th>
<th>Join Date</th>
<td></td>
</tr>
</thead>
<tbody style="font-weight:400 !important;font-size:12px;" id="loadcust">
</tbody>
</table>
</div>
<!--<div class="modal-footer">-->
<!-- <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>-->
<!--</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 a course</span></h6>
</div>
<form role="form" id="catfrm1" 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 $campusid ?>" name="campusid" id="campusid">
<select class="form-control" name="studentid" id="studentid" required>
<option value="">Select student</option>
<?php
$listcountr=mysqli_query($con,"SELECT * FROM students WHERE campus='$campusid' 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>Course Name <span>*</span></label>
<select class="form-control" name="courseid1" id="courseid1" required>
<option value="">Select course</option>
<?php
$listcountr=mysqli_query($con,"SELECT * FROM courses ORDER BY title ASC");
while($ls=mysqli_fetch_assoc($listcountr)){ ?>
<option value="<?php echo $ls['id'] ?>"><?php echo $ls['title'] ?></option>
<?}
?>
</select>
</div>
<div class="form-group">
<label>Enrollment Date <span>*</span></label>
<input type="date" class="form-control" 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="status111"></div>
</div>
</div>
</form>
</div>
</div>
</div>
<div id="completemodal" class="completemodal modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h2><i class="fa fa-list-alt"></i> <span id="addcat">Add graduation date</span></h2>
</div>
<form role="form" id="completefrm" method="post" enctype="multipart/form-data">
<div class="row" id="login">
<div class="form-group">
<label>Graduation Date<span>*</span></label>
<input type="hidden" name="completeid" id="completeid" value="">
<input type="date" class="form-control" name="completedate" id="completedate" 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> Save Date</button>
<div id="status112"></div>
</div>
</div>
</form>
</div>
</div>
</div>
<!--send email -->
<div id="emailmodal" 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">Send Email Communication Campus Students</span></h6>
</div>
<form role="form" id="emailfrm" method="post" enctype="multipart/form-data">
<div class="row" id="login">
<div class="form-group">
<label>Message Title<span>*</span></label>
<input type="hidden" value="<?php echo $campusid ?>" name="campuside" id="campuside">
<input class="form-control" type="text" name="title" id="title" required>
</div>
<div class="form-group">
<label>Message Body<span>*</span></label>
<textarea class="form-control" type="text" name="content" id="content" required></textarea>
</div>
<div class="form-group">
<label>Attachment</label>
<input class="form-control" type="file" name="attachment" id="attachment">
</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> Send Message to Students</button>
<div id="status13"></div>
</div>
</div>
</form>
</div>
</div>
</div>
<?php include_once("../includes/footer-course.php") ?>
<script src="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/js/bootstrap-select.min.js"></script>
<script>
$('#dataTable').DataTable({"aaSorting" : []});
$('#dataTable2').DataTable({"aaSorting" : []});
$("#emailfrm").submit(function(e){
e.preventDefault();
var formdata= new FormData(this);
$("#status13").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> sending message...</p>");
$.ajax({
method: "POST",
url: "app/enrollstudent",
data: new FormData(this),
contentType: false,
processData: false,
cache:false
}).done(function(data){
if(data.status == "200"){
$("#status13").html("<p class=' bg-success'><i class='fa fa-check'></i> message sent successfully.</p>");
window.location.replace("campus-students?cid=<?php echo $campusid ?>");
}
if(data.message == "ERROR"){
$("#status13").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later.</p>");
}
});
});
//Delete a course
// $(".delcourse").click(function(){
$('#dataTable').on('click', '.delcourse', function(){
var courseid3 = $(this).attr("id");
var d = confirm('Are you sure you want to remove student from this course?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/enrollstudent",
data:{courseid3:courseid3},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("student removed successfully");
window.location.replace("campus-students?cid=<?php echo $campusid ?>");
}else{
alert("error deleting course");
}
});
}
});
//campus students
// $(".viewstudents").click(function(){
$('#dataTable').on('click', '.viewstudents', function(){
var campusid = $(this).attr("id");
$.ajax({
url:"app/campus-students",
method:"POST",
data:{campusid:campusid},
success:
function(returnhtmls){
$('#loadcust').html(returnhtmls);
$("#campusid").val(campusid)
$('#campusstudents-modal').modal('show');
}
})
});
$("#catfrm").submit(function(e){
e.preventDefault();
var id = $("#campusid").val();
var formdata= new FormData(this);
$("#status11").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Saving the campus...</p>");
$.ajax({
method: "POST",
url: "app/campuses",
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> campus saved successfully.</p>");
window.location.replace("campuses");
}
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>");
}
});
});
$("#catfrm1").submit(function(e){
e.preventDefault();
// var formdata= new FormData(this);
// var courseid = $("#courseid").val();
// var courseid = $("#studentid").val();
$("#status111").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"){
$("#status111").html("<p class=' bg-success'><i class='fa fa-check'></i> student enrolled successfully.</p>");
window.location.replace("campus-students?cid=<?php echo $campusid ?>");
}
if(data.message == "ERROR"){
$("#status111").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later / Student already enrolled in the course.</p>");
}
});
});
$("#addstudentfrm").submit(function(e){
e.preventDefault();
var formdata= new FormData(this);
$("#status12").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> adding student to campus...</p>");
$.ajax({
method: "POST",
url: "app/campuses",
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> student added successfully.</p>");
window.location.replace("campuses");
}
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 campus
//$(".activate").click(function(){
$("#dataTable").on('click', '.activate', function(){
var campusid = $(this).attr("id");
var d = confirm('Are you sure you want to activate this campus?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-campus",
data:{campusid:campusid},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("campus activated successfully");
window.location.replace("campuses");
}else{
alert("error activating campus");
}
});
}
});
//DeActivate a campus
// $(".deactivate").click(function(){
$("#dataTable").on('click', '.deactivate', function(){
var campusid2 = $(this).attr("id");
var d = confirm('Are you sure you want to deactivate this campus?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-campus",
data:{campusid2:campusid2},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("campus deactivated successfully");
window.location.replace("campuses");
}else{
alert("error deactivating campus");
}
});
}
});
$("#completefrm").submit(function(e){
e.preventDefault();
var formdata= new FormData(this);
$("#status112").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> submitting details...</p>");
$.ajax({
method: "POST",
url: "app/enrollstudent",
data: new FormData(this),
contentType: false,
processData: false,
cache:false
}).done(function(data){
if(data.status == "200"){
$("#status112").html("<p class=' bg-success'><i class='fa fa-check'></i> date saved successfully.</p>");
window.location.replace("campus-students?cid=<?php echo $campusid ?>");
}
if(data.message == "ERROR"){
$("#status112").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later.</p>");
}
});
});
//Delete a campus
//$(".delcampus").click(function(){
$("#dataTable").on('click', '.markascomplete', function(){
var enrollid = $(this).attr("id");
var d = confirm('Are you sure you want to mark this student as completed the course?');
if(d == false){
return false;
}
else{
$("#completeid").val($(this).attr("id"));
$("#completemodal").modal('show')
// $.ajax({
// method:"post",
// url:"app/enrollstudent",
// data:{enrollid:enrollid},
// cache:false
// }).done(function(data){
// if(data.status == "200"){
// alert("marked as complete successfully");
// window.location.replace("campus-students?cid=<?php echo $campusid ?>");
// }else{
// alert("error");
// }
// });
}
});
// //remove student from campus
// $(".removestudent").click(function(){
// var studentid = $(this).attr("id");
// var d = confirm('Are you sure you want to remove student from campus?');
// if(d == false){
// return false;
// }
// else{
// $.ajax({
// method:"post",
// url:"app/student-campuses",
// data:{studentid:studentid},
// cache:false
// }).done(function(data){
// if(data.status == "200"){
// alert("student removed successfully");
// window.location.replace("campuses");
// }else{
// alert("error removing student");
// }
// });
// }
// });
//edit campus
// $(".edtcampus").click(function(){
$("#dataTable").on('click', '.edtcampus', function(){
$("#campusid").val($(this).attr("id"));
$("#campusname").val($(this).attr("data-campusname"));
$("#countryid").val($(this).attr("data-countryid"));
$("#county").val($(this).attr("data-county"));
$("#lecturer").val($(this).attr("data-lecturer"));
$("#addcat").html("Edit Campus")
$("#catimg").hide()
$('.catmodal').modal('show');
});
</script>
</div>
</php>