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

?>
	  

  <?php

include 'fileheader.php';
?>



<h2 align="center">Investigation</h2>


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

} else{
    echo "";
}
       
	}
?>  



<table id="example2"  id ="demo" class="table table-bordered table-hover">
                  <thead>
                  <tr>
                  <div id="listingTable">
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
         <th><strong>Date Time</strong></th>
         <th><strong>Investigation</strong></th>
          <th><strong>Result</strong></th> 
                                </tr>
                  </thead>
                  
               
                 
<?php
			$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                                                                                                                                                
     <tr>   <td>&nbsp;$rs[created_at]</td>     
            <td>&nbsp;";
	   if (is_numeric($rs[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs[Category]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
   if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs[Sub_Category]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[bodypart]";
}
   if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs[Investigation]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[Investigation]";
}
            $sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs[ivid]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo"
	    $rsn[Investigation]"; }
	    echo"</b></td>
	    
	    ";
	    if($rs[Investigation_type] == 'Pathology'){
	        
	      if (is_numeric($rs[Result]))
{

echo"<td>Pending</td>
        ";
        }else
{
    echo"<td><a href='show_upate_report.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]'>$rs[Result]</a></td>";
}
}
else
{
	        
	      if (is_numeric($rs[Result]))
{

echo"<td>Pending</td>
        ";
        }else
{
    echo"<td><a href='show_upatediagostic_report.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]'>$rs[Result]</a></td>";
}
}
echo"
	          </tr>                   
          
     ";
}
?>  
   </tbody>
</table>  
</div>
<table id="example2"  id ="demo" class="table table-bordered table-hover">
<?php
			$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                              
                     
          
     ";
}
?>  
   </tbody>
</table>