<?php
 
 ?>
 
 	<div class="clearfix">
											<div class="pull-right tableTools-container6"></div>
										</div>
										<div class="table-header">
											Cardio Thoracic Surgery
										</div>

										<!-- div.table-responsive -->

										<!-- div.dataTables_borderWrap -->
										<div>
<!-- PAGE CONTENT BEGINS -->




<table id="dynamic-table6" class="table table-striped table-bordered table-hover">
                  <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
$a='0';
$sqlpatient1 = "SELECT * FROM list_tretment where labdepartmentid='40'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    $a++;
	    echo"<tr><td>$a</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>
	  ";
	  
	   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"<a href='list/Add/AddTreatment.php?trid=$rsn[trid]&menu=Workdesk'> <i class='fa fa-plus-square-o' style='font-size:20px; color:#990000;'></i> </a>";

echo"<a href='ProcedureSurgery.php?ivid=$rsn[trid]&menu=Workdesk'> <i class='fa fa-trash' style='font-size:20px; color:red;'></i> </a>";
}
else
{
    echo"<a href='list/update/TreatmentScope.php?ivid=$rsn[trid]&menu=Workdesk'> <i class='fa fa-pencil-square-o' style='font-size:20px; color:#330000;'></i> </a> ";
    echo"<a href='ProcedureSurgery.php?ivid=$rsn[trid]&menu=Workdesk'> <i class='fa fa-trash' style='font-size:20px; color:red;'></i> </a>";
    }  
	  	 echo"
	 
             </td>
          </tr>                   
          
          ";
	
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>



                   <form name="CardioThoracicSurgery" method="post">
<div class='row'>
    <div class='col-sm-6'><br>
			<label>Treatment and Surgery</label>
					<input type='text' placeholder='Treatment and Surgery' name='tratment'class='form-control' />
	 <br>
	   	 
	   	 <input type='hidden' value='40' name='labdepartmentid'>
	    </div>
    <div class='col-sm-6'>	 <br>	 <br>   
       <input type="submit" value="Submit" name="CardioThoracicSurgery" class='btn btn-success' /></div>
    
</div>
      </form>
      
      </div>