<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("workdeskmenu.php");
include("opdtest2322.php");
?>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
    
     
      <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>

<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>Tarif Name</strong></th>
              <th><strong>Status</strong></th>
           <th><strong>Action</strong></th>
        </tr>
      
                  </thead>
<?php
include("dbconnection.php");

 $narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
 $sql ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
{
$sqlpatient1 = "SELECT * FROM tarif";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
 echo"<tr><td>&nbsp;</td><td>&nbsp;<b>$rsn[tarifname]</b> </td>";
	 if (is_numeric($rsn[tarifid]))
{
    $DisplayForm=True;
$sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
		$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<td>Pending</td>";
}
else
{
    $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rs1 = mysqli_fetch_array($qsql1))
    echo"   ";
    }
    
    
    if (is_numeric($rsn[tarifid]))
{
    $DisplayForm=True;
$sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'";
		$qsql1 = mysqli_query($con,$sql1);
	if($rh1 = mysqli_fetch_array($qsql1))
		$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"";
}
else
{
    $sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'";
		$qsql1 = mysqli_query($con,$sql1);
	if($rs1 = mysqli_fetch_array($qsql1))
    echo"  <td>Updated</td> ";
    }


	echo"
	   
<td>
	  ";
	  
	   if (is_numeric($rsn[tarifid]))
{
    $DisplayForm=True;
$sql1 ="SELECT * FROM tarifrate WHERE hospitalid='$rs[entered_by]' And tarifid='$rsn[tarifid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
		$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<a href='tarifrate.php?tarifid=$rsn[tarifid]'> <i class='fa fa-plus-square' aria-hidden='true' style='font-size:20px'></i></a>";
}
else
{
    echo"<a href='edit_tarifrate.php?tarifid=$rsn[tarifid]'> <i class='fa fa-pencil-square-o' aria-hidden='true' style='font-size:20px'></i></a> |
    
    <a href='view_tarifrate.php?tarifid=$rsn[tarifid]'> <i class='fa fa-eye' aria-hidden='true' style='font-size:20px'></i></a>
    ";
    }
	  	 echo"
	    
	 
             </td>
          </tr>                   
          
          ";
	}
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>