<input type="search" class="light-table-filter" data-table="order-table" placeholder="Search" />
 <table id="example2"  class="order-table table table-bordered table-hover css-serial">
     
                  <tr>
                      <th>SR No</th>
                      <th>Patient Details</th>
             <th>Admitted_Under</th>
                <th>Details </th>
               </tr>
   

<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$today = date('Y-m-d');
		       	$sql91 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql91 = mysqli_query($con,$sql91);
		if($re91 = mysqli_fetch_array($qsql91))
		{
		$sql21 ="SELECT * FROM discharge  WHERE hospital_id='$re91[entered_by]'  AND typevisit='IPD' AND 	status='Admission' ORDER BY id DESC";
		$qsql21 = mysqli_query($con,$sql21);
		while($rs1 = mysqli_fetch_array($qsql21))
		{
	   $sql31 ="SELECT * FROM addaspatient WHERE prescriptionid='$rs1[prescriptionid]'  AND casetype='$_GET[depaid]'";
		$qsql31 = mysqli_query($con,$sql31);
		while($rsr1 = mysqli_fetch_array($qsql31))
		{
		          	$sql91 ="SELECT * FROM site_users WHERE userno='$rsr1[Admitted_Under]'";
		$qsql91 = mysqli_query($con,$sql91);
		if($re91 = mysqli_fetch_array($qsql91))
		{
		 		    	$sql41 ="SELECT * FROM patient WHERE patientid='$rsr1[patientid]'";
		$qsql41 = mysqli_query($con,$sql41);
		while($rp1 = mysqli_fetch_array($qsql41))
		{
        echo " <div id='depadr'>";
	           	if($rsr1[triage] == 'Normal_care'){
        echo "
        <tr style='background-color:#05f76a'>
               <td>&nbsp;</td>
             
                 <td>UHID :$rp1[patientid]
                 <br>
            Patient Name<br>$rp1[patientname]</td>
             <td> $re91[name] <br> ($rsr1[casetype])</td>
                                      						<td><a href='showpathlogy.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]'>View</td>
                					  
          </tr>                   
    
          ";
	}
	
	elseif($rsr1[triage] == 'Urgent_Care'){
        echo "
        <tr style='background-color:#eef202'>
               <td>&nbsp;</td>
            
                 <td>UHID :$rp1[patientid]
                 <br>
            Patient Name<br>$rp1[patientname]</td>
              <td> $re91[name]<br> ($rsr1[casetype])</td>
                                      						<td><a href='showpathlogy.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]'>View</td>
                					  
          </tr>       
        ";
	}
	else
	{
	      echo "
	       <tr  style='background-color:#eb020e'>
               <td>&nbsp;</td>
             
                 <td>UHID :$rp1[patientid]
                 <br>
            Patient Name<br>$rp1[patientname]</td>
             <td> $re91[name]<br> ($rsr1[casetype])</td>
                                      						<td><a href='showpathlogy.php?prescriptionid=$rs1[prescriptionid]&patientid=$rs1[patientid]'>View</td>
                					  
          </tr>                        
          </div>
          ";


}
		    
		}
		    
		}
	
}
}
}
?>