File: /home/bibuzptr/elearning.bibu-edu.us/backup/admin/index.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"];
}
}
else{
header("Location:../adminlogin.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>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">
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<style>
#dash{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
</style>
</head>
<body>
<div class="main-wrapper">
<?php include_once("../includes/header-course.php") ?>
<div style="margin-top:5%" class="page-content instructor-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 style="display:none" class="col-md-4 d-flex1">
<div class="card instructor-card w-100">
<div class="card-body">
<div class="instructor-inner">
<h6>REVENUE</h6>
<h4 class="instructor-text-success">Ksh. 1,000</h4>
<p>Earning this month</p>
</div>
</div>
</div>
</div>
<div class="col-md-4 d-flex">
<div class="card instructor-card w-100">
<div class="card-body">
<div class="instructor-inner">
<h6>Total Signups</h6>
<h4 class="instructor-text-info">
<?php echo mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) AS signups FROM students"))["signups"] ?>
</h4>
</div>
</div>
</div>
</div>
<div class="col-md-4 d-flex">
<div class="card instructor-card w-100">
<div class="card-body">
<div class="instructor-inner">
<h6>CURRENT STUDENTS WITH COURSES</h6>
<h4 class="instructor-text-warning">
<?php echo mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(DISTINCT studentid) AS progress FROM mycourses"))["progress"] ?>
</h4>
</div>
</div>
</div>
</div>
<div class="col-md-4 d-flex">
<div class="card instructor-card w-100">
<div class="card-body">
<div class="instructor-inner">
<h6>COURSES IN PROGRESS</h6>
<h4 class="instructor-text-warning">
<?php echo mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) AS progress FROM mycourses"))["progress"] ?>
</h4>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="card instructor-card">
<div class="card-header">
<h4>Students Courses Enrollment</h4>
</div>
<div class="card-body">
<div class="card-body" id="salecard">
<div class="chart-area">
<?php
$chkanalytics = mysqli_query($con,"SELECT MONTH(createdon) AS themonth, COUNT(*) AS enrol FROM unitlearning WHERE YEAR(createdon)='$year' GROUP BY themonth");?>
<script type="text/javascript">
google.charts.load('current', {'packages':['bar']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Month','No of Enrollments'],
<?php
while($row=mysqli_fetch_assoc($chkanalytics)){
if($row["themonth"]==1){
$name='January';
}
else if($row["themonth"]==2){
$name='February';
}
else if($row["themonth"]==3){
$name='March';
}
else if($row["themonth"]==4){
$name='April';
}
else if($row["themonth"]==5){
$name='May';
}
else if($row["themonth"]==6){
$name='June';
}
else if($row["themonth"]==7){
$name='July';
}
else if($row["themonth"]==8){
$name='August';
}
else if($row["themonth"]==9){
$name='September';
}
else if($row["themonth"]==10){
$name='October';
}
else if($row["themonth"]==11){
$name='November';
}
else
$name='December';
echo "['".$name."',".$row["enrol"]."],";
}
?>
]);
var options = {
chart: {
title: '',
},
bars: 'vertical',
vAxis: {format: 'decimal'},
height: 300,
colors: ['#ffcc00']
};
var chart = new google.charts.Bar(document.getElementById('instructor_chart'));
chart.draw(data, google.charts.Bar.convertOptions(options));
}
</script>
<div id="instructor_chart"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<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">
<h3>Most Enrolled Courses</h3>
</div>
<div class="comman-space pb-0">
<div class="settings-tickets-blk course-instruct-blk table-responsive">
<table class="table table-striped table-nowrap mb-0">
<thead>
<tr>
<th>Course</th>
<th>No of Enrollments</th>
</tr>
</thead>
<tbody>
<?php
$moste=mysqli_query($con,"SELECT COUNT(*) AS bestcourse,courseid, courses.title FROM unitlearning,courses WHERE unitlearning.courseid=courses.id GROUP BY courseid ORDER BY bestcourse DESC LIMIT 20");
while($me=mysqli_fetch_assoc($moste)){
?>
<tr>
<td><?php echo $me["title"] ?></td>
<td><?php echo $me["bestcourse"] ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include_once("../includes/footer-course.php") ?>
<script src="https://www.suredeals.co.ke/admin/vendor/chart.js/Chart.min.js"></script>
</div>
</html>