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

        <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="#"><span class="badge badge-success mt-1 float-right">5</span><i class="mdi mdi-settings m-r-5 text-muted"></i> Settings</a>
                                    <a class="dropdown-item" href="#"><i class="mdi mdi-lock-open-outline m-r-5 text-muted"></i> Lock screen</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="groupview.php">Groupview</a></li>
                                    
                                    <li class="breadcrumb-item active">Summary</li>
                                </ol>
                            </div>
                            <h4 class="page-title">Summary</h4>
                        </div>
                    </div>
                </div>
                <!-- end page title end breadcrumb -->
				<div class="row">
 <?php
$idvac =$_REQUEST['idvac'];
$Assess =$_REQUEST['Assess'];
//$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 name='$Assess'");
$test = mysql_fetch_array($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
				$email=$test['email'] ;	
mysql_close($conn);

?>
  <?php
//$idvac =$_REQUEST['idvac'];
//$name =$_REQUEST['name'];
//$email =$_SESSION['email'];
$Assess =$_REQUEST['Assess'];
	$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 dossierform WHERE idvac='$idvac' AND Assess='$Assess'");
$test = mysql_fetch_array($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
				$Assess=$test['Assess'] ;
				$sumA=$test['sumA'] ;
				$sumB=$test['sumB'] ;
				$sumC=$test['sumC'] ;
				$sumD=$test['sumD'] ;
				$sumE=$test['sumE'] ;
				$sumF=$test['sumF'] ;
				$sumG=$test['sumG'] ;
				$sumH=$test['sumH'] ;
				
				
mysql_close($conn);

?>  
             

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

                                <h4 class="mt-0 header-title">RADAR CHART</h4>
                                <p class="text-muted m-b-30 font-14 d-inline-block text-truncate w-100"></p>
								<canvas id="radar2" height="100"></canvas>
                                

                                

                            </div>
                        </div>
                    </div> 
					
					
					<!-- end col -->
                </div> 
				<div class="row">
				<div class="col-xl-6">
                        <div class="card m-b-30">
                            <div class="card-body">

                                <h4 class="mt-0 header-title">Result by Area</h4>
                                <p class="text-muted m-b-30 font-14 d-inline-block text-truncate w-100">A bar chart is a way of showing data as
                                    bars. It is sometimes used to show trend data, and the comparison of
                                    multiple data sets side by side.</p>
									
                                <canvas id="bar3" height="100"></canvas>

                            </div>
                        </div>
                </div>
				<div class="col-xl-6">
                        <div class="card m-b-30">
                            <div class="card-body">

                                <h4 class="mt-0 header-title">Result by Category</h4>
                                <p class="text-muted m-b-30 font-14 d-inline-block text-truncate w-100">A bar chart is a way of showing data as
                                    bars. It is sometimes used to show trend data, and the comparison of
                                    multiple data sets side by side.</p>
									
                                <canvas id="bar2" height="100"></canvas>

                            </div>
                        </div>
                </div>
				</div>
             
				<div class="row">
                     <!-- end col -->
                
                    <div class="col-6">
                        <div class="card m-b-30">
                            <div class="card-body">

                                <h4 class="mt-0 header-title">Result by Category</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 idvac='".$idvac. "'AND Assess='".$Assess."'"))
										//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>LMT Category</center></th>
													<th><center>Assessment by ".$Assess." (%)</center></th>
													</tr></thead>
														<tr><th>License</th><th><center> ". $sumA . "</center></th></tr>
														<tr><th>Other Information and Supporting Documents</th><th><center> ". $sumB . "</center></th></tr>
														<tr><th>Vaccination Regime</th><th><center> ". $sumC . "</center></th></tr>
														<tr><th>Dosage</th><th><center> ". $sumD . "</center></th></tr>
														<tr><th>Labels and Packaging</th><th><center> ". $sumE . "</center></th></tr>												
														<tr><th>Vaccine Production Capability</th><th><center> ". $sumF . "</center></th></tr>
														<tr><th>Quality Control and Finished Product</th><th><center> ". $sumG . "</center></th></tr>
														<tr><th>Vaccine Efficacy</th><th><center> ". $sumH . "</center></th></tr>
														<tr><th>Overall Level of Functionality</th><th><center> ". ($sumA+$sumB+$sumC+$sumD+$sumE+$sumF+$sumG+$sumH)/8 . "</center></th></tr>
													";
												
												while ($row = $result->fetch_object())
												
										{
									
									
 } 
                                        // 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> <!-- end col -->
					<div class="col-6">
                        <div class="card m-b-30">
                            <div class="card-body">
					<?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..");
		}
				$Assess=$test['name'] ;		
							
mysql_close($conn);

?>
<?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 dossierform WHERE idvac  = '$idvac'");
$test = mysql_fetch_array($result);
if (!$result)
		{
		die("Error: Data not found..");
		}
				$gencomm=$test['gencomm'] ;	
				$recomm=$test['recomm'] ;		
							
mysql_close($conn);

?>
                                <h4 class="mt-0 header-title">Comments and Recommendation</h4>
                                <div class="form-group row">
                                <table class="table table-bordered mb-0">    
									<thead>
                                            <tr>
												<th colspan="3" width="55%"><center>General Comments </center></th>
                                                <th colspan="1" width="10%"><center>Recommendation </center></th>								
											</tr>
                                    </thead>
									<tbody>
											<td colspan="3"><?php echo $gencomm ?></td>
											<td><center><?php if($recomm=='Accept'){ echo "Proposed to be APPROVED" ;} else if($recomm=='Reject') { echo "Proposed to be REJECTED";} else if($recomm=='KIV') { echo "Proposed to be KIV";} else {echo "";}?></center></td>
									
									</tbody>
								</table>

                                
									                                    
                                </div>
								

                            </div>
                        </div>
                    </div> 
					
					
					
					
                </div> 


                 <!-- 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>

        <!-- Chart JS -->
        <script src="assets/plugins/chart.js/chart.min.js"></script>
        <script src="assets/pages/chartjs.init.js"></script>

        <!-- App js -->
        <script src="assets/js/app.js"></script>
		<script>
		//radar
var ctxR = document.getElementById("radar2").getContext('2d');
var myRadarChart = new Chart(ctxR, {
type: 'radar',
data: {
labels: ["License", "Other Information and Supporting Documents", "Vaccination Regime", "Dosage", "Labels and Packaging", "Vaccine Production Capability", "Quality Control on Finished Product", "Vaccine Efficacy"],
datasets: [{
label: "<?php echo $Assess ?>",
data: [<?php echo $sumA ?>, <?php echo $sumB ?>, <?php echo $sumC ?>, <?php echo $sumD ?>, <?php echo $sumE ?>, <?php echo $sumF ?>, <?php echo $sumG ?>, <?php echo $sumH ?>],

backgroundColor: [
'rgba(105, 0, 132, .2)',
],
borderColor: [
'rgba(200, 99, 132, 1)',
],
borderWidth: 3,

},


]

},

options: {
responsive: true

}
});


//bar3
var ctxR = document.getElementById("bar3").getContext('2d');
var myBarChart = new Chart(ctxR, {
type: 'horizontalBar',
data: {
labels: ["General Plant Profile", "Overall Quality: Safety", "Overall Quality: Potency"],
datasets: [{
label: "<?php echo $Assess ?>",
data: [<?php echo ($sumA+$sumB+$sumC+$sumD)/4 ?>, <?php echo ($sumE+$sumF+$sumG)/3 ?>, <?php echo $sumH ?>],
backgroundColor: [
'rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)',
],
borderColor: [
'rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)',
],
borderWidth: 2,
barPercentage: 1.0
},
//data2

//data3


]
},
options: {
responsive: true
}

});

//bar2
var ctxR = document.getElementById("bar2").getContext('2d');
var myBarChart = new Chart(ctxR, {
type: 'horizontalBar',
data: {
labels: ["License", "Other Information and Supporting Documents", "Vaccination Regime", "Dosage", "Labels and Packaging", "Vaccine Production Capability", "Quality Control on Finished Product", "Vaccine Efficacy"],
datasets: [{
label: "<?php echo $Assess ?>",
data: [<?php echo $sumA ?>, <?php echo $sumB ?>, <?php echo $sumC ?>, <?php echo $sumD ?>, <?php echo $sumE ?>, <?php echo $sumF ?>, <?php echo $sumG ?>, <?php echo $sumH ?>],
backgroundColor: [
'rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)','rgba(105, 0, 132, .2)'
],
borderColor: [
'rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)','rgba(200, 99, 132, .7)'
],
borderWidth: 2
},

//data3


]
},
options: {
responsive: true
}
});

</script>
		
		
		

    