<?php 
session_start();
require_once 'config.php';
require_once 'auth.php';
$MainPage="Dashboard";
$Page = "Dashboard";
?>
<!DOCTYPE html>
<html lang="en" class="default-style">
<head>
    <title><?php echo $Proj_Title; ?></title>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no, minimum-scale=1.0, maximum-scale=1.0">
    <meta name="description" content="" />
    <meta name="keywords" content="">
    <meta name="author" content="Codedthemes" />
    <?php include_once 'header_script.php'; ?>

</head>
<body>
      <div class="layout-wrapper layout-1 layout-without-sidenav">
        <div class="layout-inner">
         
         <?php include 'sidenavi.php'; ?>

<div class="layout-container">
                <div class="layout-content">

                    <!-- [ content ] Start -->
                    <div class="container-fluid flex-grow-1 container-p-y">
                        <h4 class="font-weight-bold py-3 mb-0">Hospital Dashboard</h4>
                        <div class="text-muted small mt-0 mb-4 d-block breadcrumb">
                            <ol class="breadcrumb">
                                <li class="breadcrumb-item"><a href="#"><i class="feather icon-home"></i></a></li>
                                <li class="breadcrumb-item"><a href="#!">Hospital</a></li>
                                <li class="breadcrumb-item active"><a href="#!">Dashboard</a></li>
                            </ol>
                        </div>
                        <div class="row">
                            <!-- customar project  start -->
                       <div class="col-xl-4 col-md-6">
                                <div class="card mb-4">
                                    <div class="card-body">
                                        <div class="row align-items-center m-l-0">
                                            <div class="col-auto">
                                                <i class="fas fa-user-md f-36 text-info"></i>
                                            </div>
                                            <div class="col-auto">
                                                <h6 class="text-muted m-b-10">Doctor</h6>
                                                <h2 class="m-b-0">
                                                    <?php 
                                                        $sql = "SELECT * FROM tbl_users WHERE Type='Consultant'";
                                                        $rncnt = getRow($sql);
                                                        echo $rncnt;
                                                    ?></h2>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                           <div class="col-xl-4 col-md-6">
                                <div class="card mb-4">
                                    <div class="card-body">
                                        <div class="row align-items-center m-l-0">
                                            <div class="col-auto">
                                                <i class="fas fa-user-injured f-36 text-danger"></i>
                                            </div>
                                            <div class="col-auto">
                                                <h6 class="text-muted m-b-10">Patient</h6>
                                                <h2 class="m-b-0">
                                                    <?php 
                                                        $sql2 = "SELECT * FROM tbl_patients";
                                                        $rncnt2 = getRow($sql2);
                                                        echo $rncnt2;
                                                    ?></h2>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            
                          
                          
                        </div>
                            
                          
                </div>
                <!-- [ Layout content ] Start -->
            </div>
            <!-- [ Layout container ] End -->
        </div>
        <!-- Overlay -->
        <div class="layout-overlay layout-sidenav-toggle"></div>
    </div>
    <!-- [ Layout wrapper] End -->

    <!-- Modal -->
    
    <?php include_once 'footer_script.php'; ?>
<script type="text/javascript">
      $(document).ready(function() {
      $('#example').DataTable( {
        responsive: true
      });
      });

     
    </script>
</body>

</html>
