<!DOCTYPE html>
<?php 
session_start(); // Ensure this is called only once
require ("_common/global.php");
require ("_common/conn.php");
require ("_common/check_session.php");

// Check user role
if ($_SESSION["role"] != "Administrator") {
    header('Location: expired.php');
    exit();
}

// Connect to the database using MySQLi
$conn = mysqli_connect("localhost", "dvsvigov_vacc", "DVSvacdos123", "dvsvigov_vacdos");
if (!$conn) {
    die('Could not connect: ' . mysqli_connect_error());
}

// Fetch user details
$email = $_SESSION['email'];
$result = mysqli_query($conn, "SELECT * FROM user WHERE email='$email'");
if (!$result) {
    die("Error: Data not found.. " . mysqli_error($conn));
}
$test = mysqli_fetch_array($result);
$name = htmlspecialchars($test['name']);
$post = htmlspecialchars($test['post']);
$role = htmlspecialchars($test['role']);

// Fetch counts for administrators and evaluators
$resultAdmin = mysqli_query($conn, "SELECT COUNT(*) AS total FROM user WHERE role='Administrator'");
$dataAdmin = mysqli_fetch_assoc($resultAdmin);

$resultEvaluator = mysqli_query($conn, "SELECT COUNT(*) AS total2 FROM user WHERE role='Evaluator'");
$dataEvaluator = mysqli_fetch_assoc($resultEvaluator);

// Close the database connection
mysqli_close($conn);
?>

<html lang="en">
<head>
    <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=0, minimal-ui">
    <title>VAC-DOS | Vaccine Dossier Mapping Tool</title>
    <link rel="shortcut icon" href="assets/images/favicon.ico">
    <link rel="stylesheet" href="assets/plugins/morris/morris.css">
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css">
    <link href="assets/css/icons.css" rel="stylesheet" type="text/css">
    <link href="assets/css/style.css" rel="stylesheet" type="text/css">
</head>

<body>

<!-- Loader -->


<!-- Navigation Bar-->
    <header id="topnav">
        <div class="topbar-main">
            <div class="container-fluid">
                <div class="logo">
                    <a href="index.html" class="logo">
                        <img src="assets/images/logo-sm.png" alt="" height="32" class="logo-small">
                        <img src="assets/images/logo.png" alt="" height="20" class="logo-large">
                    </a>
                </div>
                <div class="menu-extras topbar-custom">
                    <ul class="list-inline float-right mb-0">
                        <li class="list-inline-item dropdown notification-list">
                            <a class="nav-link dropdown-toggle arrow-none waves-effect nav-user" data-toggle="dropdown" href="#" role="button" aria-haspopup="false" aria-expanded="false">
                                <img src="assets/images/users/user-1.jpg" alt="user" class="rounded-circle">
                            </a>
                            <div class="dropdown-menu dropdown-menu-right dropdown-menu-animated profile-dropdown ">
                                <a class="dropdown-item" href="profile.php"><i class="mdi mdi-account-circle m-r-5 text-muted"></i> Profile</a>
                                <a class="dropdown-item" href="logout.php"><i class="mdi mdi-logout m-r-5 text-muted"></i> Logout</a>
                            </div>
                        </li>
                    </ul>
                </div>
                <div class="clearfix"></div>
            </div>
        </div>

        <div class="navbar-custom">
            <div class="container-fluid">
                <div id="navigation">
                    <ul class="navigation-menu">
                        <li class="has-submenu"><a href="dashboard.php"><i class="dripicons-meter"></i>Dashboard</a></li>
                        <li class="has-submenu"><a href="#"><i class="dripicons-user"></i>User</a>
                            <ul class="submenu megamenu">
                                <li>
                                    <ul>
                                        <li><a href="addnewuser.php">Add New User</a></li>
                                        <li><a href="usermanage.php">User  Management</a></li>
                                    </ul>
                                </li>
                            </ul>
                        </li>
                        <li class="has-submenu"><a href="#"><i class="ion-eye"></i>Pre-screen</a>
                            <ul class="submenu">
                                <li><a href="pre/addnewPS.php">New Pre-Screen Dossier</a></li>
                                <li><a href="pre/pendinglist.php">All List</a></li>
                                <li><a href="pre/kivlist.php">KIV List</a></li>
                                <li><a href="pre/passlist.php">Accepted List</a></li>
                                <li><a href="pre/rejectlist.php">Rejected List</a></li>
                                <li class="has-submenu">
                                    <a href="#">Add Data</a>
                                    <ul class="submenu">
                                        <li><a href="pre/pre-applicantcompany.php">Applicant Company</a></li>
                                        <li><a href="pre/pre-disease.php">Disease</a></li>
                                        <li><a href="pre/pre-strain.php">Strain</a></li>
                                        <li><a href="pre/pre-species.php">Target Species</a></li>
                                        <li><a href="pre/pre-vaccine.php">Nature of Vaccine</a></li>
                                        <li><a href="pre/pre-manu.php">Approved Manufacturer</a></li>
                                        <li><a href="pre/pre-refcount.php">Ref. Country (Certificate)</a></li>
                                        <li><a href="pre/pre-asian.php">Asian Country (Certificate)</a></li>
                                        <li><a href="pre/pre-source.php">Approved Source SPF Eggs</a></li>
                                    </ul>
                                </li>
                            </ul>
                        </li>
                        <li class="has-submenu"><a href="#"><i class="dripicons-copy"></i>Dossier</a>
                            <ul class="submenu">
                                <li><a href="addnewtask0.php">Assign New Dossier</a></li>
                                <li><a href="assignevaluator.php">Assign Evaluator</a></li>
                                <li><a href="assigned.php">View List</a></li>
                            </ul>
                        </li>
                        <li class="has-submenu"><a href="#"><i class="ion-folder"></i>Records</a>
                            <ul class="submenu">
                                <li class="has-submenu">
                                    <a href="#">By Individual</a>
                                    <ul class="submenu">
                                        <li><a href="viewall.php">View All</a></li>
                                        <li><a href="viewcomplete.php">Complete</a></li>
                                        <li><a href="viewpending.php">Pending</a></li>
                                    </ul>
                                </li>
                                <li class="has-submenu">
                                    <a href="#">By Group</a>
                                    <ul class="submenu">
                                        <li><a href="groupview.php">View All</a></li>
                                        <li><a href="groupcomplete.php">Complete</a></li>
                                        <li><a href="grouppending.php">Pending</a></li>
                                    </ul>
                                </li>
                            </ul>
                        </li>
                        <li class="has-submenu"><a href="#"><i class="dripicons-archive"></i>Documents</a>
                            <ul class="submenu">
                                <li class="has-submenu">
                                    <a href="#">System Manual</a>
                                    <ul class="submenu">
                                        <li><a href="#.php">Administrator Manual</a></li>
                                        <li><a href="#.php">Evaluator Manual</a></li>
                                    </ul>
                                </li>
                                <li class="has-submenu">
                                    <a href="#">Other Documents</a>
                                    <ul class="submenu">
                                        <li><a href="#.php">Add New Document</a></li>
                                        <li><a href="#.php">Document Category</a></li>
                                        <li><a href="#.php">View All Documents</a></li>
                                    </ul>
                                </li>
                            </ul>
                        </li>
                        <li class="has-submenu"><a href="#"><i class="ion-information-circled"></i>About</a>
                            <ul class="submenu">
                                <li><a href="#">About VACDOS</a></li>
                            </ul>
                        </li>
                    </ul>
                </div>
            </div>
        </div>
    </header>
    <!-- End Navigation Bar-->

<div class="wrapper">
    <div class="container-fluid">

        <!-- Page-Title -->
        <div class="row">
            <div class="col-sm-12">
                <h4 class="page-title">Dashboard</h4>
            </div>
        </div>

        <!-- User Welcome Card -->
        <div class="row">
            <div class="col-xl-4">
                <div class="card m-b-30 text-white bg-primary">
                    <div class="card-body">
                        <p>Welcome to VACDOS!</p>
                        <p><?php echo $name; ?><br><?php echo $post; ?><br><?php echo $email; ?><br><br>System Role: <?php echo $role; ?></p>
                    </div>
                </div>
            </div>
        </div>

        <!-- Statistics Cards -->
        <div class="row">
            <div class="col-xl-3 col-md-6">
                <div class="card mini-stat m-b-30">
                    <div class="p-3 bg-primary text-white">
                        <h6 class="text-uppercase mb-0">ADMINISTRATOR</h6>
                    </div>
                    <div class="card-body">
                        <?php 
                        echo '<h1>' . $dataAdmin['total'] . '</h1>';
                        ?>
                        <span class="">Registered VACDOS Administrator</span>
                    </div>
                </div>
            </div>

            <div class="col-xl-3 col-md-6">
                <div class="card mini-stat m-b-30">
                    <div class="p-3 bg-primary text-white">
                        <h6 class="">DOSSIER READER/EVALUATOR</h6>
                    </div>
                    <div class="">
                        <?php 
                        echo '<h1>' . $dataEvaluator['total2'] . '</h1>';
                        ?>
                        Registered Dossier Reader / Evaluator
                    </div>
                </div>
            </div>

        </div>

    </div> <!-- end container -->
</body>

<script src='assets/js/jquery.min.js'></script>
<script src='assets/js/bootstrap.bundle.min.js'></script>

</html>
