<?php session_start();
include("dbconnection.php");
require_once("../patientmanager.php");
require_once("../DBManager.php");
include 'header.php';
include 'dashboarddocument.php';
if(isset($_POST[drnote]))
{
        	$updated_at=date("F d, Y / h:i:s A");
$sql ="UPDATE drnote SET TypeOfVisit='$_POST[TypeOfVisit]',Status_of_Patient='$_POST[Status_of_Patient]',Response_to_Treatment='$_POST[Response_to_Treatment]',Expected_Outcome='$_POST[Expected_Outcome]',Risk_Involved='$_POST[Risk_Involved]',Detail_Note='$_POST[Detail_Note]',Nursing_Instruction='$_POST[Nursing_Instruction]',Schedule_Operative_procedure='$_POST[Schedule_Operative_procedure]'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$sql1 ="UPDATE save_activity SET created_at='$_POST[created_at]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND userno='$_GET[patientid]' AND discription='Intial Assessment<br>Covid 19 Checklist<br>Doc.no-'";
if($qsql = mysqli_query($con,$sql))
		{
		    if($qsql = mysqli_query($con,$sql1))
		    {
    echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } 
  }else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>
     <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
        <title>PHP - Sending multiple forms data through jQuery Ajax</title>  
		<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
        <link rel="stylesheet" href="bootstrap.min.css" />
		<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
		<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h3 style='text-align:center;'>Dr Note</h3>
                <form name="drnote" method="post">
 <?php
    $sql ="SELECT * FROM drnote WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
		$qsql = mysqli_query($con,$sql);
	while($rst = mysqli_fetch_array($qsql))
		{
		   
	echo"


      
       
			    
               <table id='example2' class='table table-bordered table-hover'> 
        <tr><td>
            <span style='font-size: 20px'>Type of visit  </span></h3></td><td>
                <select name='TypeOfVisit'>
    
     <option value='$rst[TypeOfVisit]'>$rst[TypeOfVisit] </option>
  <option value='schedule'>schedule</option>
  <option value='un-schedule'>un-schedule</option>

</select>
</td>
</tr>


     <tr><td>
            <span style='font-size: 20px'>Patient Status  </span></h3></td><td>
                <select name='Status_of_Patient'>
    
     <option value='$rst[Status_of_Patient]'>$rst[Status_of_Patient] </option>
  <option value='Good'>Good</option>
  <option value='Better'>Better</option>
  <option value='Fair'>Fair </option>
  <option value='Poor'>Poor </option>
  <option value='Critical'>Critical </option>
</select>
</td>
</tr>




 <tr><td>
            <span style='font-size: 20px'>Response to Treatment   </span></h3></td><td>
                <select name='Response_to_Treatment'>
     <option value='$rst[Response_to_Treatment]'>$rst[Response_to_Treatment]  </option>
  <option value='Visible Improvement '>Visible Improvement </option>
  <option value='Responsive to Treatment'>Responsive to Treatment  </option>
  <option value='No Change'>No Change </option>
  <option value='Need Attention'>Need Attention  </option>
  <option value='Critical Condition'>Critical Condition </option>
</select>
</td>
</tr>

  <tr><td>
      
            <span style='font-size: 20px'>Expected Outcome </span></h3></td><td>
                <select name='Expected_Outcome'>
    
     <option value='$rst[Expected_Outcome]'>$rst[Expected_Outcome]</option>
  <option value='Good'>Good</option>
  <option value='Better'>Better</option>
  <option value='Fair'>Fair </option>
  <option value='Poor'>Poor </option>
  <option value='Critical'>Critical </option>
</select>
</td>
</tr>
 <tr><td>
            <span style='font-size: 20px'>Risk Involved</span></h3></td><td>
                <select name='Risk_Involved'>
    
     <option value='$rst[Risk_Involved]'>$rst[Risk_Involved]</option>
  <option value='None'>None</option>
  <option value='Mild'>Mild</option>
  <option value='Moderate'>Moderate </option>
  <option value='Severe'>Severe </option>
</select>
</td>
</tr>





</table>

<br>
<table id='example2' class='table table-bordered table-hover'>

</table>
  <label>Clinical Note</label>
  <textarea name='Detail_Note' rows='3' cols='110'>$rst[Detail_Note]</textarea>
  
  
  
   <label>Nursing Instruction  :</label>
	<textarea rows='3' cols='110' name='Nursing_Instruction'>$rst[Nursing_Instruction]</textarea>
	
	
	
  <label>Schedule Operative procedure </label>
  <input type='date' value='$rst[Schedule_Operative_procedure]' name='Schedule_Operative_procedure'>
  <br>
  <br>
";
}

?>
<br><br>
	 <td colspan="2" align="center"><input type="submit" name="drnote" id="drnote" value="Submit" /></td>
    </form>
    <p>&nbsp;</p>

  </div></div>
</section>
 <div class="clear"></div>
  </div>
</div>

<script>
function loaddoctor(deptid)
{
	    if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("divdoc").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET","departmentDoctor.php?deptid="+deptid,true);
        xmlhttp.send();
}
</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>