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

    
?>
	  




<?php
include("dbconnection.php");
	$sqlpatient = "SELECT * FROM save_activity WHERE  prescriptionid='$_GET[prescriptionid]' AND discription='Intial Assessment<br>GENERAL CONSENT<br>Doc.no-'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    if($rsp[discription]== 'Intial Assessment<br>GENERAL CONSENT<br>Doc.no-'){
	        echo"<h4 align='right'>Doc.no : $rsp[srno]</h4>";

} else{
    echo "";
}
       
	}
?>  
<div class="container">
    <div class="row">
        <div class="col-sm-6"></div>
        <div class="col-sm-4"></div>
        <div class="col-sm-2">
            <a href="edit_oprative_note.php?prescriptionid=<?php echo $_GET['prescriptionid'] ?>&patientid=<?php echo $_GET['patientid'] ?>&surgeryid=<?php echo $_GET['surgeryid'] ?>"><i class="fa fa-pencil-square-o" aria-hidden="true" style="font-size:30px;"></i>
</a>
        </div>
    </div>
</div>
  
    <?php
    $sql ="SELECT * FROM Anesthesia_note WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo "

      <table class='table table-bordered table-hover'>
     
   <tr>
<td>Procedure Executed : </td><td>$rs[Procedure_Executed]
</td>
</tr>

  <tr>
<td>Detail of Emergency procedure performed:  </h3></td><td>$rs[Procedure_performed]
</td>
</tr>

  <tr>
<td>Surgeon Note :  </h3></td><td>$rs[Surgeon_Note]
</td>
</tr>

 <tr>
<td>Anesthetic Note :  </h3></td><td>$rs[Anesthetic_Note]
</td>
</tr>
 <tr>

  <tr>
 <td style='width:50%'>Patient Status:  
 </td>
 <td style='width:50%'>
 $rs[Patient_Status]
 </td>
 </tr>
 
  <tr>
 <td style='width:50%'>Expected Outcome:  
 </td>
 <td style='width:50%'>
$rs[Expected_Outcome]
 </td>
 </tr>
 
  <tr>
<td>Record time of Death : </h3></td><td>$rs[Record_time_Death]
</td>
</tr>


  <tr>
<td>Reversal : </h3></td><td>$rs[Revesalr]

</td>
</tr>


  <tr>
<td>Post Op. advice:  </h3></td><td>$rs[Post_Op_advice]
</td>
</tr>


<tr>
<td>Sign In : </h3></td><td>$rs[SignIn]

</td>
</tr>


  <tr>
<td>Sign Out:  </h3></td><td>$rs[SignOut]
</td>
</tr>
";
}
?>

</table>



		</table>
</div>