<?php
session_start();
include("headers.php");
include("menu.php");
include("dbconnection.php");
require_once("../patientmanager.php");
require_once("../DBManager.php");
if(isset($_POST[submit]))
{
PatientManager::updateaddbedward("$_POST[wardid]","$_POST[bedname]","$_POST[price]","$_POST[status]","$_POST[prescriptionid]");
}

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('Delete Successfully..');</script><script>window.location='addbedindex.php?wardid=$_GET[wardid]'</script>";
	}
}
?>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

    <ul>
      <li class="first">Ward</li></ul>
  </div>
</div>
<div class="wrapper col4">
  <div id="container">
  
 
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
 <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
                  
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
          <th><strong>Ward</strong></th> 
          <th><strong>Type</strong></th>
                <th><strong>Bed Details </strong></th>
                  <th><strong>Action</strong></th> 
                       </tr>
                  </thead>
                 
<?php
		$sql ="SELECT * FROM ward WHERE wardid='$_GET[wardid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    	$sql1 ="SELECT * FROM bedindex WHERE wardid='$rs[wardid]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rs1 = mysqli_fetch_array($qsql1))
		{
            
            echo " <tbody>                                        
     <tr>  
           ";
           if($rs[ward_department]=='1')
{
    echo"<td>&nbsp;Incentive Unit</td>";
    
}else{
    
    echo"<td>Ward</td>";
    
}
	    echo"<td>
           $rs[ward_type]</td>
           <td>
           $rs[ward_name]-";
           if(3==$rs[ward_department])
    {
    echo"
          Table no: ";
        
    }
    else{
        echo"Bed no :";
    }
              echo"$rs1[bedname]</td>
          <td> <a href='addbedindex.php?wardid=$rs[wardid]&delid=$rs1[bedid]'> <i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a></td>";
           }
           }
         
?>          </tr>
                  </thead>
                  


                   </tbody>
  <tfoot>
          </tfoot>
        </table>
   <form method="post" action="" name="submit">
    <table width="532" border="3">
	<table id="example2" class="table table-bordered table-hover">  
      <tbody>
          
              <?php
		  	$sqlpatient= "SELECT * FROM ward WHERE wardid='$_GET[wardid]'";
			$qsqlpatient = mysqli_query($con,$sqlpatient);
			while($rspatient=mysqli_fetch_array($qsqlpatient))
			{
			   
			    echo"
			      <input type='hidden' name='status' value='Active'>
       <input type='hidden' name='wardid' value='$rspatient[wardid]'>
       ";
       }
       ?>
	      <?php
	      $sql="SELECT  count('wardid') FROM bedindex  WHERE wardid='$_GET[wardid]'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_array($result);
		  {
			    $bedtry=$row[0];
			    $Bedno=$bedtry+1;
			    echo"
       <input type='hidden' name='bedname' value='$Bedno'>
       ";
       }
       ?>
       <?PHP
       $sql ="select * from ward where wardid='$_GET[wardid]'";
$qsql = mysqli_query($con,$sql);
if($qsql2=mysqli_fetch_array($qsql))
{
    if(3==$qsql2[ward_department])
    {
    echo"

        <tr>
          <td colspan='2' align='center'><input type='submit' name='submit' id='submit' value='Add-Table' /></td>
        </tr>";
        }
        else
        {
            echo"

        <tr>
          <td colspan='2' align='center'><input type='submit' name='submit' id='submit' value='Add-Bed' /></td>
        </tr>"; 
        }
}
  ?>
      </tbody>
    </table>
    </form>
    <p>&nbsp;</p>

  </div>
</div>
</div>
 <div class="clear"></div>
  </div>
</div>
<?php
include("footer.php");
?>