<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['alogin'])=="")

{

header("Location: index.php");

}

else{

?>

<?php include('includes/header.php');?>

<?php include('includes/topbar.php');?>

<div class="content-wrapper">

<div class="content-container">

<?php include('includes/leftbar.php');?>

<div class="main-page">

<div class="container-fluid">

<div class="row page-title-div">

<div class="col-sm-6">

<h2 class="title">Dashboard</h2>

</div>

<!-- /.col-sm-6 -->

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

<section class="section">

<div class="container-fluid">

<div class="row">

<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">

<a class="dashboard-stat bg-primary" href="manage-students.php">

<?php

if (isset($_SESSION["teacher"])) {

$tcid = $_SESSION["teachercid"];

$sql1 ="SELECT StudentId from tblstudents WHERE ClassId = '$tcid' ";

}else{

$sql1 ="SELECT StudentId from tblstudents ";

}

$query1 = $dbh -> prepare($sql1);

$query1->execute();

$results1=$query1->fetchAll(PDO::FETCH_OBJ);

$totalstudents=$query1->rowCount();

?>

<span class="number counter"><?php echo htmlentities($totalstudents);?></span>

<span class="name">Registered Student</span>

<span class="bg-icon"><i class="fa fa-users"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<?php

if (!isset($_SESSION["teacher"])) {

?>

<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">

<a class="dashboard-stat bg-danger" href="manage-subjects.php">

<?php

$sql ="SELECT id from tblsubjects ";

$query = $dbh -> prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$totalsubjects=$query->rowCount();

?>

<span class="number counter"><?php echo htmlentities($totalsubjects);?></span>

<span class="name">Subjects Listed</span>

<span class="bg-icon"><i class="fa fa-ticket"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">

<a class="dashboard-stat bg-warning" href="manage-classes.php">

<?php

$sql2 ="SELECT id from tblclasses ";

$query2 = $dbh -> prepare($sql2);

$query2->execute();

$results2=$query2->fetchAll(PDO::FETCH_OBJ);

$totalclasses=$query2->rowCount();

?>

<span class="number counter"><?php echo htmlentities($totalclasses);?></span>

<span class="name">Total classes listed</span>

<span class="bg-icon"><i class="fa fa-bank"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<!-- /.col-lg-3 col-md-3 col-sm-6 col-xs-12 -->

<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">

<a class="dashboard-stat bg-success" href="manage-department.php">

<?php

$sql ="SELECT id from tbldepartments ";

$query = $dbh -> prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$tbldepartments=$query->rowCount();

?>

<span class="number counter"><?php echo htmlentities($tbldepartments);?></span>

<span class="name">Total Departments</span>

<span class="bg-icon"><i class="fa fa-file"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

<?php

}

?>

<div class="col-lg-3 col-md-3 col-sm-6 col-xs-12" <?php if (!isset($_SESSION['teacher'])) {

?> style="margin-top:20px;" <?php

} ?>>

<a class="dashboard-stat bg-success" href="manage-results.php">

<?php

$admint = $adminresult->term;

$admins = $adminresult->session;

if (isset($_SESSION["teacher"])) {

$tcid = $_SESSION["teachercid"];

$sql3="SELECT distinct StudentId from tblresult WHERE ClassId = '$tcid' AND term = '$admint' AND year = '$admins' ";

}else{

$sql3="SELECT distinct StudentId from tblresult WHERE term = '$admint' AND year = '$admins'";

}

$query3 = $dbh -> prepare($sql3);

$query3->execute();

$results3=$query3->fetchAll(PDO::FETCH_OBJ);

$totalresults=$query3->rowCount();

?>

<span class="number counter"><?php echo htmlentities($totalresults);?></span>

<span class="name">Results Declared</span>

<span class="bg-icon"><i class="fa fa-file-text"></i></span>

</a>

<!-- /.dashboard-stat -->

</div>

</div>

<!-- /.row -->

</div>

<!-- /.container-fluid -->

</section>

<!-- /.section -->

</div>

<!-- /.main-page -->

</div>

<!-- /.content-container -->

</div>

<!-- /.content-wrapper -->

</div>

<!-- /.main-wrapper -->

<?php include 'includes/credit.php'; ?>

<!-- ========== COMMON JS FILES ========== -->

<script src="js/jquery-ui/jquery-ui.min.js"></script>

<script src="js/bootstrap/bootstrap.min.js"></script>

<script src="js/pace/pace.min.js"></script>

<script src="js/lobipanel/lobipanel.min.js"></script>

<script src="js/iscroll/iscroll.js"></script>

<!-- ========== PAGE JS FILES ========== -->

<script src="js/prism/prism.js"></script>

<script src="js/waypoint/waypoints.min.js"></script>

<script src="js/counterUp/jquery.counterup.min.js"></script>

<script src="js/amcharts/amcharts.js"></script>

<script src="js/amcharts/serial.js"></script>

<script src="js/amcharts/plugins/export/export.min.js"></script>

<link rel="stylesheet" href="js/amcharts/plugins/export/export.css" type="text/css" media="all" />

<script src="js/amcharts/themes/light.js"></script>

<script src="js/toastr/toastr.min.js"></script>

<script src="js/icheck/icheck.min.js"></script>

<!-- ========== THEME JS ========== -->

<script src="js/main.js"></script>

<script src="js/production-chart.js"></script>

<script src="js/traffic-chart.js"></script>

<script src="js/task-list.js"></script>

<script>

/*

$(function(){

// Counter for dashboard stats

$('.counter').counterUp({

delay: 10,

time: 1000

});

// Welcome notification

toastr.options = {

"closeButton": true,

"debug": false,

"newestOnTop": false,

"progressBar": false,

"positionClass": "toast-top-right",

"preventDuplicates": false,

"onclick": null,

"showDuration": "300",

"hideDuration": "1000",

"timeOut": "5000",

"extendedTimeOut": "10000",

"showEasing": "swing",

"hideEasing": "linear",

"showMethod": "fadeIn",

"hideMethod": "fadeOut"

}

toastr["success"]( "Welcome Admin");

});

*/

</script>

</body>

</html>

<?php } ?>