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

      <style>

 
/* Automatic Serial Number Row */
.css-serial {
 counter-reset: serial-number; /* Set the serial number counter to 0 */
}
.css-serial td:first-child:before {
 counter-increment: serial-number; /* Increment the serial number counter */
 content: counter(serial-number); /* Display the counter */
}
</style>
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
	$sql ="DELETE FROM bedindex  WHERE bedid='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script><script>
 window.history.go(-1)</script>";
	}
}
?>
<input type="search" class="light-table-filter" data-table="order-table" placeholder="Search" />
<br><br>
 <table id="example2"  class="order-table table table-bordered table-hover css-serial">
                  <thead>
                  <tr>
                    <th><strong>SR.NO</strong></th>    
             <th><strong>Bedno</strong></th>
            <th><strong>Rate </strong></th>
           <th><strong>Action</strong></th>
        </tr>
      
                  </thead>
<?php
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
 $sql ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql = mysqli_query($con,$sql);
	while($rs = mysqli_fetch_array($qsql))
{
$sqlpatient1 = "SELECT * FROM ward where adminid='$rs[entered_by]' AND ward_type='High-dependency care'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    $sqlpatient12 = "SELECT * FROM bedindex where wardid='$rsn[wardid]'";
	$qsqlpatient12 = mysqli_query($con,$sqlpatient12);
	while($rsn12 = mysqli_fetch_array($qsqlpatient12))
	{
	    echo"<tr><td>&nbsp;</td><td>&nbsp;<b>$rsn[ward_name]-$rsn12[bedname]</b> </td><td>$rsn12[price]</td>";

	echo"
	   
<td>
	  ";
	  
	   if (is_numeric($rsn12[price]))
{
echo "<a href='updatebedindex.php?bedid=$rsn12[bedid]'><i class='fa fa-inr' style='font-size:20px; color:blue'></i></a>";
}
else
{
    echo"<a href='updatebedindex.php?bedid=$rsn12[bedid]'> <i class='fa fa-inr' style='font-size:20px;color:red'></i></a> ";
    }
	  	 echo"<a href='bedset.php?delid=$rsn12[bedid]'> <i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
	  	  <a href='addbedindex.php?wardid=$rsn[wardid]'> <i class='fa fa-plus-square' style='font-size:20px;color:green'></i> </a>
	   </td>
          </tr>                   
          
          ";
	}
}

    }


?>    </tbody>
  <tfoot>
          </tfoot>
        </table>