<?php
session_start();
include("header.php");
include("patient_menu.php");
include("dbconnection.php");
if(isset($_POST[submit]))
{
	{
		$sql ="INSERT INTO medication(patientid,drug,dose,Route,Frequency,duration,prescriptionid,poa) values('$_GET[patientid]','$_POST[drug]','$_POST[dose]','$_POST[Route]','$_POST[Frequency]','$_POST[duration]','$_POST[prescriptionid]','Regular_Medicine')";
		if($qsql = mysqli_query($con,$sql))
		{
		//	echo "<script>alert('Medicine  record inserted successfully...');</script></script>";
		}
		else
		{
			echo mysqli_error($con);
		}
	}
}
if(isset($_GET[editid]))
{
	$sql="SELECT * FROM immunization WHERE patientid='$_GET[editid]' ";
	$qsql = mysqli_query($con,$sql);
	$rsedit = mysqli_fetch_array($qsql);
}
if(isset($_SESSION[patientid]))
{
$sqlpatient = "SELECT * FROM patient WHERE patientid='$_SESSION[patientid]' ";
$qsqlpatient = mysqli_query($con,$sqlpatient);
$rspatient = mysqli_fetch_array($qsqlpatient);
$readonly = " readonly";
}
?>


<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
	$sql ="DELETE FROM medication WHERE id='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</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>Drug </strong></th>
          <th><strong>Dose in MG</strong></th> 
             <th><strong>Action</strong></th> 
                </tr>
                  </thead>
                 
<?php
 $sql1 ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rp = mysqli_fetch_array($qsql1))
	{	
		$sql ="SELECT * FROM medication WHERE patientid='$rp[patientid]' AND poa='Regular_Medicine' ";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                                                                                                                               
     <tr>   <td>&nbsp;$rs[drug]</td>     
            <td>&nbsp;$rs[dose]</td>
              <td><div class='btn-group'>
	  <button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
	    Action <span class='caret'></span>
	  </button>
	  <ul class='dropdown-menu'>
	 <li><a href='edit_regularmedicine.php?id=$rs[id]'> <i class='glyphicon glyphicon-save'></i> Edit</a></li> 
	      <li><a href='regularmedicine.php?patientid=$rs[patientid]&delid=$rs[id]'>Remove</a>
	      </li>
	  </ul>
	</div></td>
 </tr>                   
          
          ";
}
}
?>          </tr>
                  </thead>
                  


                   </tbody>
  <tfoot>
          </tfoot>
        </table>
        
        <style>
.container { 
  height: 200px;
  position: relative;
  border: 3px solid green; 
}

.center {
  margin: 0;
  position: absolute;
  

  left: 50%;
  -ms-transform: translate(-50%, -50%);
  transform: translate(-50%, -50%);
}
</style>
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>

     <script type="text/javascript">
$(document).ready(function(){
    $('#myForm').submit(function() {
     $('#loaderImg').show(); 
      return true;
    });
});
  </script>
<style>
      #loaderImg {
         position: absolute;
         top: 0;
         bottom: 0;
         left: 0;
         right: 0; 
         margin: auto;
         border: 10px solid grey;
         border-radius: 50%;
         border-top: 10px solid black;
         width: 100px;
         height: 100px;
         animation: spin 1s linear infinite;
      }
      @keyframes spin {
         0% {
            -webkit-transform: rotate(0deg);
            transform: rotate(0deg);
         }
         100% {
            -webkit-transform: rotate(360deg);
            transform: rotate(360deg);
         }
      }
   </style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<div class="wrapper col2">
</div>
 <div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div>

  <form method="post" name="submit" id="myForm">
	<table id="example2" class="table table-bordered table-hover">  
      <tbody>
	           
            <?php
		  	$sqlpatient= "SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
			$qsqlpatient = mysqli_query($con,$sqlpatient);
			while($rspatient=mysqli_fetch_array($qsqlpatient))
			{
				echo "<input type='hidden' name='patientid' id='patientid' value='$rspatient[patientid]'></td>";
			}
		  ?>
        </tr>
            <tr>
          <td height="62">Name of Medicine</td>
          <td><input type="text" name="drug" required></td>
        </tr>
		
		<tr>
          <td height="62">Dose (Mg)</td>
          <td><input type="text" placeholder="Dose in MG" name="dose" required></td>
        </tr>
        <tr>
          <td colspan="2" align="center"><button type="submit" name="submit"  id="btn" class='btn btn-info'/>Add</button></td>
        </tr></tbody>
    </table>
    </form>
     
    
 <button onclick="location.href='kindetails.php?<?php echo"patientid=$_GET[patientid]";?>'" type="button" > <span style="color:white">    Next Page</span></button>


<script>
document.getElementById('btn').addEventListener("click", function(){
    this.classList.add("loading");
    this.innerHTML = "Loading...";
});
</script>
<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>