<?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'>Assessment</h3>
<?php
include("dbconnection.php");
	$sqlpatient = "SELECT * FROM save_activity WHERE  prescriptionid='$_GET[prescriptionid]' AND discription='Opd Slip<br>Assessment<br>Doc.no-'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    if($rsp[discription]== 'Opd Slip<br>Assessment<br>Doc.no-'){
	        echo"<h4>Doc.no : $rsp[srno]</h4>";

} else{
    echo "";
}
       
	}
?>  


<table id='example2' class='table table-bordered table-hover'>
    
    
<?php
  	$sql ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
if($rs[treatment_Facility] == 'Available'){
    echo "<tr><td width='50%'>Treatment Facility Option: </td>
    <td width='50%'>Available </td></tr>
";
if($rs[Mode_Treatment] == 'Explained-Accepted-to-Continue'){
    echo "<tr><td width='50%'>Mode of Treatment: </td>
    <td width='50%'>Explained Accepted to Continue </td></tr>
    <tr><td width='50%'>Plan Of Care: </td>
    <td width='50%'>$rs[Plan_Of_Care] </td></tr>
     <tr><td width='50%'>Operative procedure date : </td>
    <td width='50%'>$rs[operative_date] </td></tr>
";
}
else{
    echo"<tr><td width='50%'>Mode of Treatment: </td>
    <td width='50%'>$rs[Mode_Treatment] </td></tr>";
}
} else{
    echo " <tr><td width='50%'>Treatment Facility Option: </td>
    <td width='50%'> Unable</td></tr>";
}
}
?>

</table>

<?php
  	$sql ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$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);
		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>