<?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");
?>

<!DOCTYPE html>
<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">

        <!-- DataTables -->
        <link href="assets/plugins/datatables/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
        <link href="assets/plugins/datatables/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
        <!-- Responsive datatable examples -->
        <link href="assets/plugins/datatables/responsive.bootstrap4.min.css" rel="stylesheet" type="text/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="#">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="#">Task</a></li>
                                    
                                    <li class="breadcrumb-item active">New</li>
                                </ol>
                            </div>
                            <h4 class="page-title">Task List</h4>
                        </div>
                    </div>
                </div>
                <!-- end page title end breadcrumb -->

                <!-- end row -->
<?php
$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'] ;
				
							
mysql_close($conn);

?>
                <div class="row">
                    <div class="col-12">
                        <div class="card m-b-30">
                            <div class="card-body">

                                <h4 class="mt-0 header-title">Dossier List</h4>
                                

                                <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                    <?php
										// connect to the database
										include('connect-db.php');
										
										// get the records from the database
										//if ($result = $mysqli->query("SELECT * FROM vacc WHERE AssessA='".$name. "' OR AssessB='".$name. "' OR AssessC='".$name. "'"))
										//if ($result = $mysqli->query("SELECT * FROM vacc WHERE AssessB='".$name."'"))
										if ($result = $mysqli->query("SELECT * FROM dossierform WHERE statusform='Draft' AND Assess='".$name. "'"))
										//if ($result = $mysqli->query("SELECT idvac FROM vacc UNION SELECT idvac FROM dossierform "))
										
										{
										// display records if there are records to display
										if ($result->num_rows > 0)
										{
										  
																				
										echo"
												<thead>
													<tr>
														<th><center>Dossier<br>ID</center></th>
														<th><center>Trade<br>Name</center></th>
														<th><center>Manufacturer<br>Name</center></th>
														<th><center>Vaccine<br>Type</center></th>
																											
														<th><center>Dossier<br>Form</center></th>
														<th><center>Submit</center></th>
													</tr>
												</thead>";
												
												while ($row = $result->fetch_object())
												
										{
									
									 echo "<tr>";
                                        echo    "<td>" . $row->idvac . "</td>";
                               			echo    "<td>" . $row->tradename . "</td>";
										echo    "<td>" . $row->manufacturername . "</td>";
                                        echo    "<td>" . $row->vacctype . "</td>";
										
										
										echo    "<td><a href='dossierform.php?idvac=" . $row->idvac . "'><center><i class='fa fa-edit fa-2x'></center></a></td>";
										echo    "<td><a href='submitform.php?idvac=" . $row->idvac . "'><center><i class='ion-ios7-cloud-upload fa-2x'></center></a></td>";
                                         echo "</tr>";
 } 
                                        // if there are no records in the database, display an alert message
										
										}
										else 
										{
										echo "No new task.";
										}
										}
										// 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> <!-- end col -->
                </div> <!-- 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>

        <!-- Required datatable js -->
        <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
        <script src="assets/plugins/datatables/dataTables.bootstrap4.min.js"></script>
        <!-- Buttons examples -->
        <script src="assets/plugins/datatables/dataTables.buttons.min.js"></script>
        <script src="assets/plugins/datatables/buttons.bootstrap4.min.js"></script>
        <script src="assets/plugins/datatables/jszip.min.js"></script>
        <script src="assets/plugins/datatables/pdfmake.min.js"></script>
        <script src="assets/plugins/datatables/vfs_fonts.js"></script>
        <script src="assets/plugins/datatables/buttons.html5.min.js"></script>
        <script src="assets/plugins/datatables/buttons.print.min.js"></script>
        <script src="assets/plugins/datatables/buttons.colVis.min.js"></script>
        <!-- Responsive examples -->
        <script src="assets/plugins/datatables/dataTables.responsive.min.js"></script>
        <script src="assets/plugins/datatables/responsive.bootstrap4.min.js"></script>

        <!-- Datatable init js -->
        <script src="assets/pages/datatables.init.js"></script>

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

    </body>
</html>