<!DOCTYPE html>
<?php session_start();?>

<?php
	if($_SESSION ["role"]=="Evaluator")
	{
		
		$role = $_SESSION["role"];
		$email = $_SESSION["email"];
		
		// header('location:form.php');
	}
	else
	{
		header('location:expired.php');
		// $userName = $_SESSION["userName"]; $userRole = $_SESSION["userRole"];
		}
?>
<?
require ("_common/global.php");
require ("_common/conn.php");
//require ("_common/function.php");
require ("_common/check_session.php");
?>

<html lang="en">
    <head><meta http-equiv="Content-Type" content="text/html; 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>
        <meta content="Admin Dashboard" name="description" />
        <meta content="ThemeDesign" name="author" />
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />

        <link rel="shortcut icon" href="assets/images/favicon.ico">

        <!--Morris Chart CSS -->
        <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 -->
        <div id="preloader"><div id="status"><div class="spinner"></div></div></div>

        <!-- Navigation Bar-->
        <header id="topnav">
            <div class="topbar-main">
                <div class="container-fluid">

                    <!-- Logo container-->
                    <div class="logo">
                        <!-- Image 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>
                    <!-- End Logo container-->


                    <div class="menu-extras topbar-custom">

                        
                        <ul class="list-inline float-right mb-0">
                            <!-- Search -->
                            
                            <!-- Messages-->
                            
                            <!-- notification-->
                            
                            <!-- User-->
                            <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="#"><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>
                            <li class="menu-item list-inline-item">
                                <!-- Mobile menu toggle-->
                                <a class="navbar-toggle nav-link">
                                    <div class="lines">
                                        <span></span>
                                        <span></span>
                                        <span></span>
                                    </div>
                                </a>
                                <!-- End mobile menu toggle-->
                            </li>

                        </ul>
                    </div>
                    <!-- end menu-extras -->

                    <div class="clearfix"></div>

                </div> <!-- end container -->
            </div>
            <!-- end topbar-main -->

            <!-- MENU Start -->
            <div class="navbar-custom">
                <div class="container-fluid">
                    <div id="navigation">
                        <!-- Navigation Menu-->
                        <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-broadcast"></i>Task</a>
                                <ul class="submenu">
									<li><a href="list.php">New</a></li>									
                                    <li><a href="listcomplete.php">Completed</a></li>
									
									
                                    
                                </ul>
                            </li>

                            

                            <li class="has-submenu">
                                <a href="#"><i class="dripicons-graph-bar"></i>About</a>
                                <ul class="submenu">
                                    <li><a href="#">About VAC-DOS</a></li>
                                    <li><a href="../VACDOS-USERMANUAL.PDF" target="_blank">User Manual</a></li>
                                    
                                </ul>
                            </li>

                            

                        </ul>
                        <!-- End navigation menu -->
                    </div> <!-- end #navigation -->
                </div> <!-- end container -->
            </div> <!-- end navbar-custom -->
        </header>
        <!-- End Navigation Bar-->


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

                <!-- Page-Title -->
                <div class="row">
                    <div class="col-sm-12">
                        <div class="page-title-box">
                            <div class="btn-group float-right">
                                <ol class="breadcrumb hide-phone p-0 m-0">
                                    <li class="breadcrumb-item"><a href="#">VACDOS</a></li>
                                    <li class="breadcrumb-item active">Dashboard</li>
                                </ol>
                            </div>
                            <h4 class="page-title">Dashboard</h4>
                        </div>
                    </div>
                </div>
                <!-- end page title end breadcrumb -->
<div class="row">
				<div class="col-xl-4">
                        <div class="card m-b-30 text-white bg-primary">
                            <div class="card-body">
                                
<?php 
//$id =$_REQUEST['id'];
$email =$_SESSION['email'];
	$conn = mysql_connect('localhost', 'dvsvigov_vacc', 'DVSvacdos123');
	 if (!$conn)
    {
	 die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("dvsvigov_vacdos", $conn);
$result = mysql_query("SELECT * FROM user WHERE email='$email' ");
$test = mysql_fetch_array($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
				$name=$test['name'] ;
				$post=$test['post'] ;
				$role=$test['role'] ;
				
				
mysql_close($conn);

?>
									<p>Welcome to VACDOS!</p>
									<p><?php echo $name ?><br><?php echo $post ?><br><?php echo $email ?><br>System Role: <?php echo $role ?><br><br>Click here for User Manual &nbsp&nbsp<a href="../VACDOS-USERMANUAL.pdf" target="_blank"><i class='fa fa-file-o fa-2x'></i></a></p>
									
                                
                            </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">
                                <div class="mini-stat-icon">
                                    <i class="mdi mdi-account-network float-right mb-0"></i>
                                </div>
                                <h6 class="text-uppercase mb-0">Pending Task</h6>
                            </div>
                            <div class="card-body">
                                <div class="border-bottom pb-4">
	<?php 
//$id =$_REQUEST['id'];
$email =$_SESSION['email'];
	$conn = mysql_connect('localhost', 'dvsvigov_vacc', 'DVSvacdos123');
	 if (!$conn)
    {
	 die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("dvsvigov_vacdos", $conn);
$result=mysql_query("SELECT count(*) as total from dossierform where Assess='$name' AND statusform='Draft'");
$data=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                    <span class="badge badge-success"></span> <a href="list.php"><h1><?php echo $data['total']; ?></h1></a><span class="ml-2 text-muted">Vaccine Dossier</span>
                                </div>
                            </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">
                                <div class="mini-stat-icon">
                                    <i class="mdi mdi-account-network float-right mb-0"></i>
                                </div>
                                <h6 class="text-uppercase mb-0">COMPLETED TASK</h6>
                            </div>
                            <div class="card-body">
                                <div class="border-bottom pb-4">
								
		<?php 
//$id =$_REQUEST['id'];
$email =$_SESSION['email'];
	$conn = mysql_connect('localhost', 'dvsvigov_vacc', 'DVSvacdos123');
	 if (!$conn)
    {
	 die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("dvsvigov_vacdos", $conn);
$result=mysql_query("SELECT count(*) as total2 from dossierform where Assess='$name' AND statusform='Complete'");
$data2=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                    <span class="badge badge-success"></span><a href="listcomplete.php"> <h1><?php echo $data2['total2']; ?></h1></a><span class="ml-2 text-muted">Vaccine Dossier</span>
                                </div>
                            </div>
                        </div>
                    </div>
					</div>
                   
					
                </div>
                <!-- end row -->

                <!-- end row -->
                
                <!-- end row -->
                
                <!-- end row -->

                
                <!-- end row -->
            </div> <!-- end container -->
        </div>
        <!-- end wrapper -->


        <!-- Footer -->
        <footer class="footer">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        © 2020 <b>VAC-DOS </b>V1.0<br><span class="d-none d-sm-inline-block">Crafted by <b>Research and Innovation</b> Division, DVS</span>
                    </div>
                </div>
            </div>
        </footer>
        <!-- End Footer -->
    

        <!-- jQuery  -->
        <script src="assets/js/jquery.min.js"></script>
        <script src="assets/js/bootstrap.bundle.min.js"></script>
        <script src="assets/js/modernizr.min.js"></script>
        <script src="assets/js/detect.js"></script>
        <script src="assets/js/fastclick.js"></script>
        <script src="assets/js/jquery.slimscroll.js"></script>
        <script src="assets/js/jquery.blockUI.js"></script>
        <script src="assets/js/waves.js"></script>
        <!-- skycons -->
        <script src="assets/plugins/skycons/skycons.min.js"></script>

        <!-- skycons -->
        <script src="assets/plugins/peity/jquery.peity.min.js"></script>

        <!--Morris Chart-->
        <script src="assets/plugins/morris/morris.min.js"></script>
        <script src="assets/plugins/raphael/raphael-min.js"></script>

        <!-- dashboard -->
        <script src="assets/pages/dashboard.js"></script>

        <!-- App js -->
        <script src="assets/js/app.js"></script>


    </body>
</html>