<?php session_start();
require_once("../patientmanager.php");
require_once("../DBManager.php");
?>

  
    <table id="example2" class="table table-bordered table-hover">
            <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
                        <tr>
         <th><strong>Investigation Details</strong></th>
         <th><strong>Category</strong></th>
         <th><strong>Result</strong></th> 
          <th><strong>Report</strong></th>
          </tr>
 <?php
		$sql ="SELECT * FROM investigation WHERE  prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' And Investigation_type='Radiology' AND Priority_slip='Urgent'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		?>
          <?php
		$sql ="SELECT * FROM investigation WHERE  prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' And Investigation_type='Radiology' AND Priority_slip='Urgent'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo "<tr style='background-color:#FFF2F2'>
    <td><b>Created At :</b>$rs[created_at]
    <br><b>Raised_at :</b> $rs[Raised_at]<br><b>Investigation type :</b>$rs[Investigation_type]-$rs[Investigation]</td> 
     <td>$rs[Category]</td> 
      <td>$rs[Result]</td>
      ";
      if($rs[Evidence] == ''){
      echo"
    <td>  <span style='font-color:tomato;' style='backgraund-color=red' class='button' data-modal='modalfour'><u> Create Report</u></span> <br><br> <span style='font-color:tomato;' style='backgraund-color=red' class='button' data-modal='modalfour'><u> Upload</u></span></td>
                      </tr>  ";
      }
      else{
          echo "<td>|Edit| |View| |Delete|</td></tr>  ";
}
}
?>  
<?php
}
?>

<?php
		$sql ="SELECT * FROM investigation WHERE  prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' And Investigation_type='Radiology' AND Priority_slip='Normal'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		?>
		<tr>
          <?php
		$sql ="SELECT * FROM investigation WHERE  prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' And Investigation_type='Radiology' AND Priority_slip='Normal'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo "
    <td><b>Created At :</b>$rs[created_at]
    <br><b>Raised_at :</b> $rs[Raised_at]<br><b>Investigation type :</b>$rs[Investigation_type]-$rs[Investigation]</td> 
     <td>$rs[Category]</td> 
      <td>$rs[Result]</td>
    ";
                     
      if($rs[Evidence] == ''){
      echo"
    <td>  <span style='font-color:tomato;' style='backgraund-color=red' class='button' data-modal='modalfour'><u> Create Report</u></span>
                  <br><br>  <span style='font-color:tomato;' style='backgraund-color=red' class='button' data-modal='modalfour'><u> Upload</u></span></td> ";
      }
      else{
          echo "<td>|Edit| |View| |Delete|</td>  ";
}
}
?>  
   </tr>  
<?php
}
?>
 
    </div>
     </table>