<?php session_start();
include 'dbconnection.php';
require_once("../patientmanager.php");
require_once("../DBManager.php");
include 'dashboarddocument.php';
include 'header.php';
if(isset($_POST['Before_Conduction'])) 
{
   date_default_timezone_set("Asia/Calcutta");   //India time (GMT+5:30)
$updated_at= date('d-m-Y H:i:s');
$sql ="UPDATE Before_Conduction SET  Anesthesia_Safety='$_POST[Anesthesia_Safety]',Pulse_Oximeter='$_POST[Pulse_Oximeter]',Known_Allergy='$_POST[Known_Allergy]',Difficult_Airways='$_POST[Difficult_Airways]',Risk_500='$_POST[Risk_500]',updated_at='$_POST[created_at]' 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='Pre-Assessment Sheet<br>Routine Examination<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.";
  } 
   
  
}
$sql ="SELECT * FROM Before_Conduction WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		$row=$qsql->fetch_assoc();
?>

  <div class="content-wrapper">
        <section class="content-header">
    <form name="Before_Conduction" method="post" >
        <fieldset>
             <legend align="center">Before Conduction Of Sign In:</legend>
               <h3 > </h3>
<table id='example2' class='table table-bordered table-hover'>
 <input  type='text' value='<?php echo $row[updated_at] ?>' name='created_at' >
                        	<?php
$sql ="SELECT * FROM Before_Conduction WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND  surgeryid='$_GET[surgeryid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{

		    echo"
 <tr>
    <td width='25%'>";
   if($rs[Anesthesia_Safety]=='on')
{
    echo "<input type='checkbox' name='Anesthesia_Safety' checked>";
} else{
    echo "<input type='checkbox' name='Anesthesia_Safety' >";
} 
echo"</td> <td width='25%'><span style='font-size: 17px;'>Anesthesia Safety Check Completed	</span></td>
 
     <td width='25%'>    ";
     if($rs[Pulse_Oximeter] == 'on'){
    echo "<input type='checkbox' name='Pulse_Oximeter' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Pulse_Oximeter'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Pulse Oximeter On And Functioning</span></td>
     </tr>
     
       <tr>
       <td width='25%'>    ";
     if($rs[Known_Allergy] == 'on'){
    echo "<input type='checkbox' name='Known_Allergy' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Known_Allergy'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Does Patient Have A Known Allergy</span>
     </td> <td width='25%'>    ";
     if($rs[Difficult_Airways] == 'on'){
    echo "<input type='checkbox' name='Difficult_Airways' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Difficult_Airways'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Difficult Airways/Aspiration Risk?	</span></td>
     </tr>
     <tr>
      
      <td width='25%'>    ";
     if($rs[Risk_500] == 'on'){
    echo "<input type='checkbox' name='Risk_500' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Risk_500'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Risk of> 500 Ml Blood Loss (7ml/Kg In Children)</span></td>
       </tr> ";
}


?>
</table>

<input type='submit' name='Before_Conduction' value='Submit'>
</fieldset>
</form>