<?php session_start();
require_once("../patientmanager.php");
require_once("../DBManager.php");
include 'header.php';
include 'dashboarddocument.php';
?>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
<div class="card-body">

                  <?php
	$sql1 ="SELECT * FROM transferreferal WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rt = mysqli_fetch_array($qsql1))
		{
if(on==$rt[Transfer_IPD])
{
?>  <div id="mmenu">
    <?php
    $sql ="SELECT * FROM transferreferal WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rst = mysqli_fetch_array($qsql))
		{
		    echo "
<h3 align='center'>Transfer to IPD</h3>
 <table id='example2' class='table table-bordered table-hover'>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Word No: </td>
<td width='50%'>$rst[Word]</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Bed No. : </td>
<td width='50%'>$rst[Bed]</td>
</tr>
</table>
";
}
?>
	  <?php
}
}
?>
            <?php
	$sql2 ="SELECT * FROM transferreferal WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql2 = mysqli_query($con,$sql2);
		if($rtr = mysqli_fetch_array($qsql2))
		{
if(on==$rtr[Referred_To])
{
?>  <div id="mmenu">
    <?php
    $sql ="SELECT * FROM transferreferal WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rstr = mysqli_fetch_array($qsql))
		{
		    echo "
<h3 align='center'>Referred To</h3>
 <table id='example2' class='table table-bordered table-hover'>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Name Hospital: </td>
<td width='50%'>$rstr[Name_Hospital]</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Name of Consultant : </td>
<td width='50%'>$rstr[Name_of_Consultant]</td>
</tr>
</table>
";
}
?>
	  <?php
}
}
?>
      </div>
      </div>
      </div>
      </div>
<?php
include("footer.php");
?>