<?php
include("dbconnection.php");
include("menu.php");
include("header.php");

if(isset($_GET['del'])){
    $Medi_Condition=$con->query("DELETE FROM `immunization` WHERE Immuni_id='$_GET[del]'");
    if($Medi_Condition==1){
        echo "<script>alert('Immunization  Record Delete Successfully...');</script><script>window.location='hosImmunization.php';</script>;</script>";
    }
}
?>
    <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        
<div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
                  
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
      
              <th><strong>Vaccine </strong></th>
          <th><strong>Date Given </strong></th> 
           <th><strong>Due Date</strong></th>
          <th><strong>Note </strong></th>   
            <th><strong>Action </strong></th>  
        </tr>
                  </thead>
                 
<?php
include("dbconnection.php");

 $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$harilal'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	$rsn = mysqli_fetch_array($qsqlpatient1);
	
	
		$sql ="SELECT * FROM immunization WHERE patientid='$rsn[userno]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                                                                                                                                                
     <tr>   <td>&nbsp;$rs[Vaccine]</td>     
            <td>&nbsp;$rs[DateGiven]</td>
             <td>&nbsp;$rs[duedate]</td>
            <td>&nbsp;$rs[Note]</td>
				  <td>
	 

	      
	      
	       <a href='view_RMO_immuni.php?Immuni_id=$rs[Immuni_id]'> <i class='fa fa-eye' style='color:green;font-size:20px;'></i> </a>
            
            <a href='edit_RMO_immuni.php?Immuni_id=$rs[Immuni_id]'> <i class='fa fa-pencil' style='color:orange;font-size:20px;'></i> </a> 
            
            <a href='hosImmunization.php?del=$rs[Immuni_id]'> <i class='fa fa-trash' style='color:red;font-size:20px;'></i> </a>
	      
	 </td>
          </tr>                   
          
          ";
}
?>          </tr>
                  </thead>
                  


                   </tbody>
  <tfoot>
          </tfoot>
        </table>
        
             <p align='right'><a  href='Add_hos_Immuni.php'>
          <button style='height:40px;width:200px'> Add New Recods</button><span class='caret'></span></p>
          </a>
          
          <br> <br> <br>
          
        
          
     
        
    </td></tr>
     
      <a  href='BasicProfile.php' class='btn btn-info' style='width:100%;'>
           Go Dashboard
          </a>
             
      </div>
<?php
if(isset($_SESSION[doctorid]))
{
?>  
<hr>
	<table>
		<tr>
			<td>
			<div align="center"><strong><a href="prescription.php?patientid=<?php echo $_GET[patientid]; ?>&appid=<?php echo $rsappointment[appointmentid]; ?>">Add Prescription records</a></strong></div>
			</td>
		</tr>
	</table>
	<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true,
      "autoWidth": false,
    });
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>

<?php
}
?>