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

<?php
	if($_SESSION ["role"]=="Administrator")
	{
		
		$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="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>
                            <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-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>
                        <!-- 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><br>System Role: <?php echo $role ?></p>
                                
                            </div>
                        </div>
                    </div>
				</div>
                <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">
                                <div class="mini-stat-icon">
                                    <i class="mdi mdi-account-network float-right mb-0"></i>
                                </div>
                                <h6 class="text-uppercase mb-0">ADMINISTRATOR</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 user where role='Administrator'");
$data=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                    <span class="badge badge-success"></span> <a href="usermanage.php"><h1><?php echo $data['total']; ?></h1></a><span class="ml-2 text-muted">Registered VACDOS Administrator</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">DOSSIER READER/EVALUATOR</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 user where role='Evaluator'");
$data2=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                    <span class="badge badge-success"></span><a href="usermanage.php"> <h1><?php echo $data2['total2']; ?></h1></a><span class="ml-2 text-muted">Registered Dossier Reader / Evaluator</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">PRE-SCREEN NEW DOSSIER</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 total3 from prescreen");
$data3=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
								<span class="badge badge-success"></span><a href="pre/pendinglist.php"><h1><?php echo $data3['total3']; ?></h1></a> <span class="ml-2 text-muted">Pre-Screen Dossier Screening</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">DOSSIER EVALUATION</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 total4 from dossierform WHERE Assess!=''");
$data4=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                    <span class="badge badge-success"></span><a href="viewall.php"> <h1><?php echo $data4['total4']; ?></h1></a><span class="ml-2 text-muted">Dossier Evaluation</span>
                                </div>
                            </div>
                        </div>
					</div>
                </div>
                <!-- end row -->
				<div class="row">
						<div class="col-xl-6">
                        <div class="card m-b-30">
                            <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 count(*) as total5 from prescreen WHERE submission='Pending'");
$data5=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                <h4 class="mt-0 header-title mb-4">Pending Pre-Screen Dossier : <?php echo $data5['total5']; ?></h4>
                                <div class="table-responsive">
                                    <table class="table table-hover mb-0">
                                       <?php
										// connect to the database
										include('connect-db.php');
										
										// get the records from the database
										if ($result = $mysqli->query("SELECT * FROM prescreen WHERE submission='Pending' "))
										{
										// display records if there are records to display
										if ($result->num_rows > 0)
										{
										  
																				
										echo"
												<thead>
													<tr>
														<th><center>Dossier<br>Tradename</center></th>
														<th><center>Vaccine<br>Nature</center></th>
														<th><center>Applicant<br>Company</center></th>
														<th><center>Pre-screen<br>Date</center></th>
														<th><center>Due<br>Date</center></th>
														<th><center>Pre-Screen<br>By</center></th>
														<th><center>View</center></th>
													</tr>
												</thead>";
												
												while ($row = $result->fetch_object())
												
										{
									
									 echo "<tr>";
                                        echo    "<td>" . $row->tradename . "</td>";
                               			echo    "<td>" . $row->nature . "</td>";
										echo    "<td>" . $row->appcomp . "</td>";
                                        echo    "<td>" . $row->prescreendate . "</td>";
										echo    "<td>" . $row->duedate . "</td>";
										echo    "<td>" . $row->prescreenby . "</td>";
										echo    "<td><a href='pre/PS-edit.php?id=" . $row->id . "'><center><i class='fa fa-edit fa-2x'></center></a></td>";
                                         echo "</tr>";
 } 
                                        // if there are no records in the database, display an alert message
										
										}
										else 
										{
										echo "No Pending Pre-Screen Dossier";
										}
										}
										// show an error if there is an issue with the database query
										else
										{
										echo "Error: " . $mysqli->error;
										}

										// close database connection
										$mysqli->close();

										?> 	
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
					<div class="col-xl-6">
                        <div class="card m-b-30">
                            <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 count(*) as total6 from dossierform WHERE statusform='Draft' AND Assess!=''");
$data6=mysql_fetch_assoc($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
							
				
mysql_close($conn);

?>
                                <h4 class="mt-0 header-title mb-4">Pending Dossier Evaluation : <?php echo $data6['total6']; ?></h4>
                                <div class="table-responsive">
                                    <table class="table table-hover mb-0">
                                       <?php
										// connect to the database
										include('connect-db.php');
										
										// get the records from the database
										if ($result = $mysqli->query("SELECT * FROM dossierform WHERE statusform='Draft' AND Assess!=''"))
										{
										// display records if there are records to display
										if ($result->num_rows > 0)
										{
										  
																				
										echo"
												<thead>
													<tr>
														<th><center>Dossier<br>Tradename</center></th>
														<th><center>Vaccine<br>Nature</center></th>
														<th><center>Applicant<br>Company</center></th>
														<th><center>Assessor</center></th>
														
														<th><center>View</center></th>
													</tr>
												</thead>";
												
												while ($row = $result->fetch_object())
												
										{
									
									 echo "<tr>";
                                        echo    "<td><center>" . $row->tradename . "</center></td>";
                               			echo    "<td><center>" . $row->vacctype . "</center></td>";
										echo    "<td><center>" . $row->manufacturername . "</center></td>";
                                        echo    "<td><center>" . $row->Assess . "</center></td>";
										
										echo    "<td><center><a href='vacdosform.php?idvac=" . $row->idvac . "&&Assess=".$row->Assess."' target='_blank'><center><i class='fa fa-edit fa-2x'></center></a></center></td>";
                                         echo "</tr>";
 } 
                                        // if there are no records in the database, display an alert message
										
										}
										else 
										{
										echo "No results to display!";
										}
										}
										// show an error if there is an issue with the database query
										else
										{
										echo "Error: " . $mysqli->error;
										}

										// close database connection
										$mysqli->close();

										?> 	
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
					
					
				</div>
                <!-- 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>VACDOS </b>V1.0 <span class="d-none d-sm-inline-block"> Crafted by <b>Veterinary Research Division</b> (BPVV), 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>