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

<!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-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="dashboard.php">Dashboard</a></li>
                                    <li class="breadcrumb-item"><a href="#">Task</a></li>
                                    
                                    <li class="breadcrumb-item active">Assign Evaluator</li>
                                </ol>
                            </div>
                            <h4 class="page-title">Assign Evaluator</h4>
                        </div>
                    </div>
                </div>
                <!-- end page title end breadcrumb -->

                <!-- end row -->

                <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 statusassign='No' ORDER BY idvac "))
										{
										// 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>Accessor<br>A</center></th>
														<th><center>Accessor<br>B</center></th>
														<th><center>Accessor<br>C</center></th>
														
														<th><center>Assign<br>Accessor</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>" . $row->AssessA . "</td>";
										echo    "<td>" . $row->AssessB . "</td>";
										echo    "<td>" . $row->AssessC . "</td>";
										
										echo    "<td><a href='assign.php?idvac=" . $row->idvac . "'><center><i class='fa fa-edit fa-1x'></center></a></td>";
                                         echo "</tr>";
 } 
                                        // if there are no records in the database, display an alert message
										
										}
										else 
										{
										echo "No task to assigned.";
										}
										}
										// 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, Department of Veterinary Services Malaysia</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>