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

	 if(isset($_POST[PEDIATRIC_CANCER]))

	{
		PatientManager::listtreatment("$_POST[tratment]","$_POST[labdepartmentid]");
	 }
?>

      <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>Treatment/Surgery</strong></th>
             <th><strong>Scope </strong></th>
            <th><strong>Rate </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 list_tretment where labdepartmentid='37'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo"<tr><td>&nbsp;</td><td>&nbsp;<b>$rsn[tratment]</b> </td>";
	 if (is_numeric($rsn[trid]))
{
    $DisplayForm=True;
$sql1 ="SELECT * FROM create_inhouse WHERE hospitalid='$rs[entered_by]' And ivid='$rsn[trid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
		$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<td></td>";
}
else
{
    $sql1 ="SELECT * FROM create_inhouse WHERE hospitalid='$rs[entered_by]' And ivid='$rsn[trid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rs1 = mysqli_fetch_array($qsql1))
    echo"  <td>$rs1[scope]</td> ";
    }
    
    
    if (is_numeric($rsn[trid]))
{
    $DisplayForm=True;
$sql1 ="SELECT * FROM create_inhouse WHERE hospitalid='$rs[entered_by]' And ivid='$rsn[trid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
		$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<td></td>";
}
else
{
    $sql1 ="SELECT * FROM create_inhouse WHERE hospitalid='$rs[entered_by]' And ivid='$rsn[trid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rs1 = mysqli_fetch_array($qsql1))
    echo"  <td>$rs1[rate]</td> ";
    }


	echo"
	   
<td><div class='btn-group'>
	  <button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
	    Action <span class='caret'></span>
	  </button>
	  <ul class='dropdown-menu'>
	  ";
	  
	   if (is_numeric($rsn[trid]))
{
    $DisplayForm=True;
$sql1 ="SELECT * FROM create_inhouse WHERE hospitalid='$rs[entered_by]' And ivid='$rsn[trid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
		$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<li><a href='createtreatment.php?trid=$rsn[trid]'> <i class='glyphicon glyphicon-edit'></i> Create</a></li>";
}
else
{
    echo"<li><a href='update_treatmentscope.php?ivid=$rsn[trid]'> <i class='glyphicon glyphicon-save'></i> Update</a></li> ";
    }
	  	 echo"
	  </ul>
	</div>
             </td>
          </tr>                   
          
          ";
	}
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>



                   <form name="PEDIATRIC_CANCER" method="post">

			<label>Treatment and Surgery</label>
					<input type='text' placeholder='Treatment and Surgery' name='tratment'>
	 <br>
	   	 <br>
	   	 <input type='hidden' value='37' name='labdepartmentid'>
	    	 	    
       <center><input type="submit" value="Submit" name="PEDIATRIC_CANCER"></center>
      </form>