File: /home/bibuzptr/elearning.bibu-edu.us/old 20th oct/openuni/admin/schools.php
<?php
ob_start();
session_start();
include_once('../includes/db_connect.php');
include_once("app/updateimage.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"];
}
}
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>Schools | 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>
#sch{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
#catmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#catmodal h2{
text-align: left;
}
#edtschoolmodal #login{
width: 90%;
margin: 10px;
display: block;
}
#edtschoolmodal 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-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>Schools </h3>
<p></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 School</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>School Image</th>
<th>School Name</th>
<th>Dean Name</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$chkplanners = mysqli_query($con,"SELECT * FROM schools ORDER BY id DESC");
while($row = mysqli_fetch_assoc($chkplanners)){
$schoolid = $row["id"];
$status = $row["status"];
?>
<tr>
<td>
<div class="sell-table-group d-flex align-items-center">
<div class="sell-group-img">
<a target="_blank" href="../course-details.php">
<img style="width:70%; height:auto" src="../school-images/<?php echo $row["icon"];?>" class="img-fluid " alt='<?php echo $row["name"];?>'>
</a>
</div>
</div>
</td>
<td><a href="course-details.php"><?php echo $row["name"];?></a></td>
<td><?php echo $row["deanname"];?></td>
<td>
<button title="update image" class="imagebutton btn btn-warning btn-sm" id="<?php echo $schoolid ?>">image</button>
<a data-toggle="tooltip" data-placement="bottom" title="Edit School"><button class="btn btn-sm btn-primary edtschool" id="<?php echo $schoolid;?>" data-description='<?php echo $row["description"];?>' data-name="<?php echo $row["name"];?>" data-deanname="<?php echo $row["deanname"];?>" data-deandescription="<?php echo $row["deandescription"];?>"><i class="fa fa-edit"></i></button></a>
<button class="btn btn-sm btn-danger delschool" id="<?php echo $schoolid;?>" data-toggle="tooltip" data-placement="bottom" title="Delete School"><i class="fa fa-trash"></i></button>
<?php
if($status=="1"){ ?>
<a id="<?php echo $schoolid ?>" title="deActivate" class="deactivate btn btn-sm btn-success"><i class="fa fa-toggle-on"> </i></a>
<?php }else{?>
<a id="<?php echo $schoolid ?>" 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="catmodal" class="catmodal 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 School</span></h2>
</div>
<form role="form" id="catfrm" method="post" enctype="multipart/form-data">
<div class="row" id="login">
<div class="form-group">
<label>School Name <span>*</span></label>
<input type="hidden" name="schoolid" id="schoolid" value="">
<input type="text" class="form-control" name="name" id="name" placeholder="Name" required>
</div>
<div class="input-block mb-0">
<label class="add-course-label">School Description</label>
<textarea type="text" class="form-control" name="description" id="description" required></textarea>
<script>
$(function(){
var $ckfield = CKEDITOR.replace( 'description' );
$ckfield.on('change', function() {
$ckfield.updateElement();
});
});
</script>
</div>
<div id="catimg" class="form-group">
<label>School Image <span>*</span></label>
<input type="file" class="form-control" name="image" id="image" placeholder="Image" accept="image/*">
</div>
<div class="form-group">
<label>Dean Name <span>*</span></label>
<input type="text" class="form-control" name="deanname" id="deanname" placeholder="Name" required>
</div>
<div id="catimg2" class="form-group">
<label>Dean Image <span>*</span></label>
<input type="file" class="form-control" name="deanimage" id="deanimage" placeholder="Image" accept="image/*">
</div>
<div class="input-block mb-0">
<label class="add-course-label">Dean Message</label>
<textarea type="text" class="form-control" name="deandescription" id="deandescription"></textarea>
<script>
$(function(){
var $ckfield = CKEDITOR.replace( 'deandescription' );
$ckfield.on('change', function() {
$ckfield.updateElement();
});
});
</script>
</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 School</button>
<div id="status11"></div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- upload product image -->
<div id="uploadimage" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><i class="fa fa-plus"> </i>Update Image</h4>
</div>
<div class="col-md-12">
<form method="post" enctype="multipart/form-data">
<div class="modal-body">
<label>Main Image</label>
<input type="hidden" name="pproductidschool" id="pproductidschool">
<input type="file" name="fileToUploadschool" id="fileToUploadschool" accept="image/*" required="required" placeholder="" class="form-control"><br>
<label>Dean Image</label>
<input type="file" name="fileToUploadschool1" id="fileToUploadschool1" accept="image/*" required="required" placeholder="" class="form-control"><br>
<button class="btn btn-success" name="update_imageschool" type="submit"><i class="fa fa-upload"> </i>upload</button>
</div>
</form>
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<?php include_once("../includes/footer-course.php") ?>
<script>
$('#dataTable').DataTable({"aaSorting" : []});
$("#catfrm").submit(function(e){
e.preventDefault();
var id = $("#schoolid").val();
var name = $("#name").val();
var formdata= new FormData(this);
if((name != "")){
$("#status11").html("<p class=' bg-success'><i class='fa fa-spinner fa-pulse'></i> Saving the school...</p>");
$.ajax({
method: "POST",
url: "app/schools",
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> school saved successfully.</p>");
window.location.replace("schools");
}
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>");
}
});
}
else{
$("#status11").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> Please fill in all fields.</p>");
}
});
//upload image
$('#dataTable').on('click', '.imagebutton', function(){
//$(".imagebutton").click(function () {
var schoolid=$(this).attr("id");
$('#pproductidschool').val(schoolid);
$('#uploadimage').modal('show');
});
//Activate a school
// $(".activate").click(function(){
$("#dataTable").on('click', '.activate', function(){
var schoolid = $(this).attr("id");
var d = confirm('Are you sure you want to activate this school?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-school",
data:{schoolid:schoolid},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("school activated successfully");
window.location.replace("schools");
}else{
alert("error activating school");
}
});
}
});
//DeActivate a school
// $(".deactivate").click(function(){
$("#dataTable").on('click', '.deactivate', function(){
var schoolid2 = $(this).attr("id");
var d = confirm('Are you sure you want to deactivate this school?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-school",
data:{schoolid2:schoolid2},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("school deactivated successfully");
window.location.replace("schools");
}else{
alert("error deactivating school");
}
});
}
});
//Delete a school
//$(".delschool").click(function(){
$("#dataTable").on('click', '.delschool', function(){
var schoolid3 = $(this).attr("id");
var d = confirm('Are you sure you want to delete this school?');
if(d == false){
return false;
}
else{
$.ajax({
method:"post",
url:"app/activate-school",
data:{schoolid3:schoolid3},
cache:false
}).done(function(data){
if(data.status == "200"){
alert("school deleted successfully");
window.location.replace("schools");
}else{
alert("error deleting school");
}
});
}
});
//edit school
//$(".edtschool").click(function(){
$("#dataTable").on('click', '.edtschool', function(){
var schoolid = $(this).attr("id");
var schoolname = $(this).attr("data-name");
$("#schoolid").val(schoolid);
$("#name").val(schoolname);
$("#deanname").val($(this).attr("data-deanname"));
CKEDITOR.instances['description'].setData($(this).attr("data-description"));
CKEDITOR.instances['deandescription'].setData($(this).attr("data-deandescription"));
$("#addcat").html("Edit School")
$("#catimg").hide()
$("#catimg2").hide()
$('.catmodal').modal('show');
});
</script>
</div>
</php>