<?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'>Brief History Patient</h3>
<?php
include("dbconnection.php");
	$sqlpatient = "SELECT * FROM save_activity WHERE  prescriptionid='$_GET[prescriptionid]' AND discription='Pre-Assessment Sheet<br>Brief History<br>Doc.no-'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    if($rsp[discription]== 'Pre-Assessment Sheet<br>Brief History<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>';
		}
		}
?>  
 <style>
                     
       .center {
   border: 1px solid grey;
   text-align:;
}
    .center2 {
   border: 5px solid grey;
   text-align:;
}
</style>
 
   <div class='center'>
       <table id='example2' class='table table-bordered table-hover'>
<?php 
		$sql ="SELECT * FROM Brief_History_Patient 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='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; 	Family History: </td>
<td width='50%'>$rs[Family_History]</td>
</tr>


";
}
?>

				</table>
</div>
<?php

  	$sql11 ="SELECT * FROM save_activity WHERE srno='$_GET[srno]' ";
		$qsql11 = mysqli_query($con,$sql11);
		while($rs11 = mysqli_fetch_array($qsql11))
		{
			$sql ="SELECT * FROM Brief_History_Patient WHERE prescriptionid='$rs11[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{  
	    $sql1 ="SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($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> $rs11[created_at] </tr>";   
		    
		}
		}
	}
		?>
		</table>