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

      <style>
       .center {
   border: 1px solid grey;
   text-align:;
}
    .center2 {
   border: 5px solid grey;
   text-align:;
}
</style>


<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
          <div class='center'>
              <?php
              include("dbconnection.php");
         $sql ="SELECT * FROM tarif WHERE tarifid='$_GET[tarifid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    echo"<h2 align='center'>$rs[tarifname]</h2>";
		}
		?>
        <form action="tarifaction.php" method="POST">
        
	<table id='example2' class='table table-bordered table-hover'>
					     <tr>
					 <th>Ward Name </th>
					 <th>Rate  </th>
					 	 	 </tr>	 
					 	 	 	 <?php
					 	 	 	 session_start();
				include("dbconnection.php");
				require_once('../DBManager.php');
require_once('../LoginManager.php');
date_default_timezone_set('Asia/Kolkata');
   $created_at=date("F d, Y / h:i:s A");
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re = mysqli_fetch_array($qsql1))
		{
					$sql ="SELECT * FROM tarif WHERE tarifid='$_GET[tarifid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		  	$sql ="SELECT * FROM ward WHERE  adminid='$re[entered_by]'";
		$qsql = mysqli_query($con,$sql);
		while($rspi = mysqli_fetch_array($qsql))
		{
		    $wrd=$rspi['ward_department'];
		     if($wrd == '1'){
		         echo"<tr> <td>Incentive Unit-";
		     }
		    else if($wrd == '2'){
		         echo"<tr> <td>Ward-";
		     }
		     else
		     {
		         echo"<tr><td>Operative room-";
		     }
		     echo"$rspi[ward_type]-$rspi[ward_name]</td>";
		   
			echo"<td><input type='hidden' name='tarifid[]' value='$_GET[tarifid]'>
			<input type='hidden' name='wardid[]' value='$rspi[wardid]'>
			<input size='2' name='hospitalid[]' value='$re[entered_by]' type='hidden'>
          	<input type='number' name='rate[]' size='2' value=''>";
          	echo" 
			     <input size='2' name='entered_by[]' value='$usertype' type='hidden'><input size='2' name='created_at[]' value='$created_at' type='hidden'>
			    
			     </td>
			      </tr>";
		}
		}
}
		?>
			
	</table>
	  <input type="submit" value="Submit"> 
      </form>
      

</div>