Viewing file:  index.php (9.14 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php require_once('auth.php') ?>
<!DOCTYPE php>
<php>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title><?php include('title.php') ?></title>
<!-- Fav Icon Link -->
<link rel="shortcut icon" type="image/png" href="images/fav.png">
<!-- Bootstrap core CSS -->
<link rel="stylesheet" href="css/bootstrap.min.css">
<!-- themify icons CSS -->
<link rel="stylesheet" href="css/themify-icons.css">
<!-- Animations CSS -->
<link rel="stylesheet" href="css/animate.css">
<!-- Main CSS -->
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" href="css/red.css" id="style_theme">
<link rel="stylesheet" href="css/responsive.css">
<!-- morris charts -->
<link rel="stylesheet" href="charts/css/morris.css">
<!-- jvectormap -->
<link rel="stylesheet" href="css/jquery-jvectormap.css">
<script src="js/modernizr.min.js"></script>
</head>
<body>
<!-- Pre Loader -->
<div class="loading">
<div class="spinner">
<div class="double-bounce1"></div>
<div class="double-bounce2"></div>
</div>
</div>
<!--/Pre Loader -->
<!-- Color Changer -->
<!-- /Color Changer -->
<div class="wrapper">
<!-- Sidebar -->
<?php include "sidebar.php"; ?>
<!-- /Sidebar -->
<!-- Page Content -->
<div id="content">
<!-- Top Navigation -->
<?php include('topbar.php') ?>
<!-- /Top Navigation -->
<!-- Breadcrumb -->
<!-- Page Title -->
<div class="row no-margin-padding">
<div class="col-md-6">
<h3 class="block-title">Quick Statistics</h3>
</div>
<div class="col-md-6">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<a href="index.php">
<span class="ti-home"></span>
</a>
</li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
</div>
</div>
<!-- /Page Title -->
<!-- /Breadcrumb -->
<!-- Main Content -->
<?php
include('conn.php');
$user_result = mysqli_query($con, "SELECT * FROM users");
$user_count = mysqli_num_rows($user_result);
$appo_result = mysqli_query($con, "SELECT * FROM appointments");
$appo_count = mysqli_num_rows($appo_result);
$doc_result = mysqli_query($con, "SELECT * FROM doctor");
$doc_count = mysqli_num_rows($doc_result);
$blog_result = mysqli_query($con, "SELECT * FROM blog");
$blog_count = mysqli_num_rows($blog_result);
$count_appo_result = mysqli_query($con, "SELECT * FROM count_appo");
$count_appo_row = mysqli_fetch_array($count_appo_result);
$appo_result = mysqli_query($con, "SELECT * FROM appointments");
?>
<div class="container-fluid home">
<div class="row">
<!-- Widget Item -->
<div class="col-md-4">
<div class="widget-area proclinic-box-shadow color-red">
<div class="widget-left">
<span class="ti-user"></span>
</div>
<div class="widget-right">
<h4 class="wiget-title">Users</h4>
<span class="numeric color-red"><?php echo $user_count; ?></span>
</div>
</div>
</div>
<!-- /Widget Item -->
<!-- Widget Item -->
<div class="col-md-4">
<div class="widget-area proclinic-box-shadow color-blue">
<div class="widget-left">
<span class="ti-bar-chart"></span>
</div>
<div class="widget-right">
<h4 class="wiget-title">Appointments</h4>
<span class="numeric color-blue"><?php echo $appo_count; ?></span>
</div>
</div>
</div>
<!-- /Widget Item -->
<!-- Widget Item -->
<div class="col-md-4">
<div class="widget-area proclinic-box-shadow color-yellow">
<div class="widget-left">
<span class="ti-heart"></span>
</div>
<div class="widget-right">
<h4 class="wiget-title">Total Doctors</h4>
<span class="numeric color-yellow"><?php echo $doc_count; ?></span>
</div>
</div>
</div>
<div class="col-md-4">
<div class="widget-area proclinic-box-shadow color-green">
<div class="widget-left">
<span class="ti-thumb-up"></span>
</div>
<div class="widget-right">
<h4 class="wiget-title">Approved Appointments</h4>
<span class="numeric color-green"><?php echo $count_appo_row['count_approve']; ?></span>
</div>
</div>
</div>
<div class="col-md-4">
<div class="widget-area proclinic-box-shadow" style="color: red;">
<div class="widget-left">
<span class="ti-thumb-down"></span>
</div>
<div class="widget-right">
<h4 class="wiget-title">Rejected Appointments</h4>
<span class="numeric"style="color: red;"><?php echo $count_appo_row['count_reject']; ?></span>
</div>
</div>
</div>
<div class="col-md-4">
<div class="widget-area proclinic-box-shadow"style="color: black;">
<div class="widget-left">
<span class="ti-book"></span>
</div>
<div class="widget-right">
<h4 class="wiget-title">Total Trainings</h4>
<span class="numeric" style="color: black;"><?php echo $blog_count; ?></span>
</div>
</div>
</div>
<!-- /Widget Item -->
</div>
<div class="row">
<!-- Widget Item -->
<div class="col-md-6">
<div class="widget-area-2 proclinic-box-shadow">
<h3 class="widget-title">Appointments Year by Year</h3>
<div id="lineMorris" class="chart-home"></div>
</div>
</div>
<!-- /Widget Item -->
<!-- Widget Item -->
<div class="col-md-6">
<div class="widget-area-2 proclinic-box-shadow">
<h3 class="widget-title"> Patients Year by Year</h3>
<div id="barMorris" class="chart-home"></div>
</div>
</div>
<!-- /Widget Item -->
</div>
<div class="row">
<!-- Widget Item -->
<div class="col-md-12">
<div class="widget-area-2 proclinic-box-shadow">
<h3 class="widget-title">Appointments</h3>
<div class="table-responsive">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th>Patient Name</th>
<th>Doctor</th>
<th>Department</th>
<th>Date</th>
<th>Time</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
while($appo_row = mysqli_fetch_array($appo_result)){
?>
<tr>
<td><?php echo $appo_row['name']; ?></td>
<td><?php echo $appo_row['doctor_name']; ?></td>
<td><?php echo $appo_row['department']; ?></td>
<td><?php echo $appo_row['date']; ?></td>
<td><?php echo $appo_row['time']; ?></td>
<td>
<?php if($appo_row['status'] == "Approved") { ?>
<span class="badge badge-success">Approved</span>
<?php } elseif ($appo_row['status'] == "Rejected") { ?>
<span class="badge badge-warning">Rejected</span>
<?php } else { ?>
<span class="badge badge-secondary">Pending</span>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<!-- /Widget Item -->
</div>
<div class="row">
<!-- Widget Item -->
<div class="col-sm-6">
<div class="widget-area-2 proclinic-box-shadow">
<h3 class="widget-title">Appointments Status</h3>
<div id="donutMorris" class="chart-home"></div>
</div>
</div>
<!-- /Widget Item -->
<!-- Widget Item -->
<div class="col-md-6">
<div class="widget-area-2 progress-status proclinic-box-shadow">
<h3 class="widget-title">Doctors Availability</h3>
<div class="table-responsive">
<table class="table table-bordered">
<thead>
<tr>
<th>Doctor</th>
<th>Speciality</th>
<th>Availability</th>
</tr>
</thead>
<tbody>
<?php while($doc_row = mysqli_fetch_array($doc_result)){
?>
<tr>
<td><?php echo $doc_row['name'] ?></td>
<td><?php echo $doc_row['speciallity'] ?></td>
<td>
<?php
$doc_name = $doc_row['name'];
$awail = mysqli_query($con, "SELECT * FROM schedule where d_name = '$doc_name'");
$awail_row = mysqli_fetch_array($awail);
echo $awail_row['status'];
?>
<span class="badge badge-success"></span>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<!-- /Widget Item -->
</div>
</div>
<!-- /Main Content -->
</div>
<!-- /Page Content -->
</div>
<!-- Back to Top -->
<a id="back-to-top" href="#" class="back-to-top">
<span class="ti-angle-up"></span>
</a>
<!-- /Back to Top -->
<!-- Jquery Library-->
<script src="js/jquery-3.2.1.min.js"></script>
<!-- Popper Library-->
<script src="js/popper.min.js"></script>
<!-- Bootstrap Library-->
<script src="js/bootstrap.min.js"></script>
<!-- morris charts -->
<script src="charts/js/raphael-min.js"></script>
<script src="charts/js/morris.min.js"></script>
<script src="js/custom-morris.js"></script>
<!-- Custom Script-->
<script src="js/custom.js"></script>
</body>
</php>
|