<?php
if(isset($_POST['Routine_Information'])) 
{
   PatientManager::RoutineInformation("$_GET[prescriptionid]","$_GET[patientid]","$_GET[surgeryid]","$_POST[Information_Obtained_from]","$_POST[Date_of_Operative_procedure]","$_POST[Time_of_Operative_procedure]","$_POST[name_Surgeon]","$_POST[Name_of_Anesthetist]","$_POST[Pre_Operative_Diagnosis]","$_POST[Systemic_Disease]","$_POST[Systemic_Disease_note]","$_POST[Anesthesia_Events]","$_POST[Anesthesia_Events_note]","$_POST[ho_Operations]","$_POST[ho_Operations_note]","$_POST[Adverse_Drugs_Reaction]","$_POST[Adverse_Drugs_Reaction_note]","$_POST[DRUG_THERAPY]","$_POST[DRUG_THERAPY_note]","$_POST[Duration_Surgery]","$_POST[WRITTEN_CONSENT]","$_POST[Ward]","$_POST[Bed]","$_POST[entered_by]");
}
?>

<form name="Routine_Information" method="post" id="myForm" >
  
               <h2 align="center">Routine Information </h2>
    
               <br>
      
		
      <table id="example2" class="table table-bordered table-hover"> 
                  
                  <tr>
                      
          
                  
            <tr><td style="width:29%">Operative Type :  </td><td  style="width:46%">
                <select name='Information_Obtained_from' class='form-control'>
        <option value='' >Operative Type</option>
       <option value='Routine'>Routine</option>
    <option value='Emergency'>Emergency</option>
           </select></td></tr>
           
           
           <?php

$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND typevisit='IPD' OR prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND typevisit='Ipd_Emergency' ";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{

?> 
<tr>
<td width='50%'> Operating Theater </td><td><select onchange="loadbedva(this.value)" name="Ward" class='form-control'>
          <option value="" disabled selected>Operating Theater</option>
<?php


$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rh1 = mysqli_fetch_array($qsql1))
		{
		    $sql2 ="SELECT * FROM ward WHERE adminid='$rh1[entered_by]' AND ward_department='3'";
		$qsql2 = mysqli_query($con,$sql2);
		while($rh2 = mysqli_fetch_array($qsql2))
		{
		    echo "<option value='$rh2[wardid]'>	$rh2[ward_type]-$rh2[ward_name]</option>";
}
				}
	
		  ?>
		  </select></td></tr>
<tr id="pavnid">
      <td width='50%'>Table</td>  
    <td width='50%'>
          <input type="text" placeholder="Table No." name="Bed" class='form-control'></td>
          </tr>
            <?php
}
		    
		
?>
    
<td>Date of Operative procedure :  </td><td><input name="Date_of_Operative_procedure" type="date" class='form-control'></td></tr>
<tr><td>Expected Sign in of Operative procedure: :  </td><td><input  name="Time_of_Operative_procedure" type="time" class='form-control'></td></tr>
<tr><td>Name of Surgeon:  </td><td><select name='name_Surgeon' id='select2' required class='form-control'>
          <option value='' disabled selected>Name of Surgeon</option>
";
<?php

	$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
          	$sqldoctor= "SELECT * FROM site_users WHERE usertype='Doctor' and entered_by='$re[entered_by]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
				
				echo "<option value='$rsdoctor[name]'>$rsdoctor[name]</option>";
				}
		}
		?>
		echo"
		  </td>
		  </select>
</tr>
<tr><td>Name of Anesthetist:  </td><td><select name='Name_of_Anesthetist' id='select2' required class='form-control'>
          <option value='' disabled selected>Name of Anesthetist</option>
";
<?php

	$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
          	$sqldoctor= "SELECT * FROM site_users WHERE usertype='Doctor' and entered_by='$re[entered_by]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
				
				echo "<option value='$rsdoctor[name]'>$rsdoctor[name]</option>";
				}
		}
		?>
		echo"
		  </td>
		  </select>
</td></tr>
<tr><td>Pre-Operative Diagnosis:  </td><td>
    <input type="text" placeholder="Pre-Operative Diagnosis" name="Pre_Operative_Diagnosis" class='form-control' onkeyup="this.value = this.value.toUpperCase();">
    </td></tr>

</tr>


<tr><td>Expected Sign out :  </td><td>
    <input placeholder="Duration Surgery" name="Duration_Surgery" type="time" class='form-control'></td></tr>

</tr>

<tr>
   <td width='50%'>WRITTEN CONSENT 
</td>
<td width='50%'><select name='WRITTEN_CONSENT' class='form-control'>
        <option value='Unknown' >Unknown</option>
       <option value='Present'>PRESENT</option>
    <option value='ABSENT'>ABSENT </option>
           </select></td>
</tr>   
              </tr>
              
            <tr><td colspan='2' align='right'><input type="submit" name="Routine_Information" value="Save" class='btn btn-success'></td></tr>
        </table>   
        


 <script>
 function  loadbedva(bedid)
{
	    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("pavnid").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET","loadbed.php?bedid="+bedid,true);
        xmlhttp.send();
}

</script>

</form>