<?php
     session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');

    include("../dbconnection.php");
		$sql2 ="SELECT * FROM save_activity WHERE srno='$_GET[srno]'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    
		   	include 'dashboarddocument.php';
}
?>
	  

  <?php

include 'fileheader.php';

?>



<h3 align='center'>Before Patient Leaves</h3>
<?php
include("dbconnection.php");
	$sqlpatient = "SELECT * FROM save_activity WHERE  prescriptionid='$_GET[prescriptionid]' AND discription='Post-Operative Checklist<br>Patient Leaves<br>Doc.no-'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    if($rsp[discription]== 'Post-Operative Checklist<br>Patient Leaves<br>Doc.no-'){
	        echo"<h4>Doc.no : $rsp[srno]</h4>";

} else{
    echo "";
}
       
	}
		$sql2 ="SELECT * FROM surgerytracker WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND  surgeryid='$_GET[surgeryid]'";
		$qsql2 = mysqli_query($con,$sql2);
		while($rs2 = mysqli_fetch_array($qsql2))
		{

		    echo '<h4>Surgery Id :-'.$rs2[surgeryid].' / ';
		    
		    $sql1 ="SELECT * FROM list_tretment WHERE trid='$rs2[surgery]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re1 = mysqli_fetch_array($qsql1))
		{
		    echo $re1[tratment] .'</h4>';
		}
		}
?>  

<table id='example2' class='table table-bordered table-hover'>
<?php
  	$sql ="SELECT * FROM Patient_Leaves WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND  surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
if($rs[Verbally_Confirmed] == 'on'){
    echo " <tr><td width='50%'>Surgical Assistant Verbally Confirmed With the Team: </td>
<td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>";
} else{
    echo "<tr><td width='50%'>Surgical Assistant Verbally Confirmed With the Team: </td>
<td width='50%'><i class='fa fa-times' aria-hidden='true'></i></td></tr>";
}
if($rs[Procedure_Recorded] == 'on'){
    echo " <tr><td width='50%'>Name of the Procedure Recorded: </td>
<td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>";
} else{
    echo "<tr><td width='50%'>Name of the Procedure Recorded: </td>
<td width='50%'><i class='fa fa-times' aria-hidden='true'></i></td></tr>";
}
if($rs[Specimen_Labeled] == 'on'){
    echo " <tr><td width='50%'>Specimen Labeled (Including Patient Name): </td>
<td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>";
} else{
    echo "<tr><td width='50%'>Specimen Labeled (Including Patient Name): </td>
<td width='50%'><i class='fa fa-times' aria-hidden='true'></i></td></tr>";
}
if($rs[infection_present] == 'on'){
    echo " <tr><td width='50%'>Checked whether infection present in or around Surgery: </td>
<td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>";
} else{
    echo "<tr><td width='50%'>Checked whether infection present in or around Surgery: </td>
<td width='50%'><i class='fa fa-times' aria-hidden='true'></i></td></tr>";
}
if($rs[Equipment_Problems] == 'on'){
    echo " <tr><td width='50%'>Any Equipment Problems to Be Addressed By Surgeon/Anesthetist ?: </td>
<td width='50%'><i class='fa fa-check' aria-hidden='true'></i></td></tr>";
} else{
    echo "<tr><td width='50%'>Any Equipment Problems to Be Addressed By Surgeon/Anesthetist ?: </td>
<td width='50%'><i class='fa fa-times' aria-hidden='true'></i></td></tr>";
}

echo"
<tr><td width='50%'>Details:</td><td width='50%'>$rs[Detail]</td></tr>
<tr><td width='50%'>Review The Key Concerns For Recovery And Management Of The Patient:</td><td width='50%'>$rs[Review_Key]</td></tr>
<tr><td width='50%'>Prognosis Explained to patient Attendant:</td><td width='50%'>$rs[Prognosis_Explained]</td></tr>

";
}
?>

</table>


<?php
  	$sql ="SELECT * FROM Patient_Leaves WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND  surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
	    $sql1 ="SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rs1 = mysqli_fetch_array($qsql1))
		{
		    
		 echo"<h5><b> Created & Updated </b><h5>
		 <table id='example2' class='table table-bordered table-hover'>
		 <tr><td width=50%><b>By :</b>$rs1[name] </b><td width='50%'><b>At :</b> $rs[created_at] </tr>";   
		    
		}
		}
		?>
		</table>
</div>