<?php session_start();
include 'dbconnection.php';
require_once("../patientmanager.php");
require_once("../DBManager.php");
include 'dashboarddocument.php';
include 'header.php';
if(isset($_POST['post_Confirmation_Sheet'])) 
{
   date_default_timezone_set("Asia/Calcutta");   //India time (GMT+5:30)
$updated_at= date('d-m-Y H:i:s');
$sql ="UPDATE post_Confirmation_Sheet SET  verify_pt_identity='$_POST[verify_pt_identity]',name_tag='$_POST[name_tag]',consent_form_signed='$_POST[consent_form_signed]',Operation_consent='$_POST[Operation_consent]',operative_assessment='$_POST[operative_assessment]',Medical_fitness='$_POST[Medical_fitness]',Last_meal='$_POST[Last_meal]',Allergy_noted='$_POST[Allergy_noted]',reports_checked='$_POST[reports_checked]',updated_at='$_POST[created_at]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
$sql1 ="UPDATE save_activity SET created_at='$_POST[created_at]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND userno='$_GET[patientid]' ";
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 post_Confirmation_Sheet 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="post_Confirmation_Sheet" method="post" >
               <h2 align="center">Post Confirmation Sheet </h2>
<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 post_Confirmation_Sheet WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    echo"
 <tr>
    <td width='25%'>";
      if($rs[verify_pt_identity] == 'on'){
    echo "<input type='checkbox' name='verify_pt_identity' checked>";
} else{
    echo "<input type='checkbox' name='verify_pt_identity' >";
} 
echo"</td> <td width='25%'><span style='font-size: 17px;'>Verify Patient Identity	</span></td>
 
     <td width='25%'>    ";
     if($rs[name_tag] == 'on'){
    echo "<input type='checkbox' name='name_tag' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='name_tag'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Name Tag	</span></td>
     </tr>
     
       <tr>
       <td width='25%'>    ";
     if($rs[consent_form_signed] == 'on'){
    echo "<input type='checkbox' name='consent_form_signed' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='consent_form_signed'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Consent Form Signed</span>
     </td> <td width='25%'>    ";
     if($rs[Operation_consent] == 'on'){
    echo "<input type='checkbox' name='Operation_consent' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Operation_consent'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Operation Consent</span></td>
     </tr>
     <tr>
      
      <td width='25%'>    ";
     if($rs[operative_assessment] == 'on'){
    echo "<input type='checkbox' name='operative_assessment' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='operative_assessment'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Operative Assessment</span></td>
       
   <td width='25%'>    ";
     
     if($rs[Medical_fitness] == 'on'){
    echo "<input type='checkbox' name='Medical_fitness' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Medical_fitness'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Medical Fitness</span></td>
       </tr> 
          <tr>
       <td width='25%'>    ";
     if($rs[Last_meal] == 'on'){
    echo "<input type='checkbox' name='Last_meal' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Last_meal'>";
        }
        echo"</td><td width='25%'><span style='font-size: 17px;'>Last Meal</span></td>
 <td width='25%'>    ";
     if($rs[Allergy_noted] == 'on'){
    echo "<input type='checkbox' name='Allergy_noted' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='Allergy_noted'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Allergy Noted</span></td>
       </tr> 
         <tr>
  <td width='25%'>    ";
     if($rs[reports_checked] == 'on'){
    echo "<input type='checkbox' name='reports_checked' checked>";
    }
    else
    {
         echo "<input type='checkbox' name='reports_checked'>";
        }
        echo"</td> <td width='25%'><span style='font-size: 17px;'>Reports Checked</span></td>
         ";
     echo"
</tr>
";
}
?>
</table>

<input type='submit' name='post_Confirmation_Sheet' value='Submit' class="btn btn-info">
    </form>