<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("dbconnection.php");
include("header.php");
include("workdeskmenu.php");
?>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
                     		<?php 
		session_start();
$DisplayForm=True;
include("dbconnection.php");
$sql12 ="SELECT * FROM frquencytracker WHERE drid='$_GET[drid]'";
		$qsql12 = mysqli_query($con,$sql12);
		while($rh12 = mysqli_fetch_array($qsql12))
		{
	$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo "<script>window.location='frqsurgeryadd.php?drid=$_GET[drid]&surgeryid=$rh12[surgeryid]'</script>;</script>";
} else{
 
?> 

        
  <script src='http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script>

    <script src="../dist/js/price.js"></script>
    <br>
    <br>
    <div class='table-responsive'>  
    <table class='table'>
    <thead>
      <tr>
        <th>#</th>
        <th>Name of Procedure</th>
        <th>Action</th>
      
      </tr>
    </thead>
        <?php 
include("dbconnection.php");
if(isset($_GET[surgeryid]))
{
	$sql ="DELETE FROM frquencytracker WHERE surgeryid='$_GET[surgeryid]' AND drid='$_GET[drid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script>";
	}
}
$count=1;
		 $narayan=LoginManager::currentUser();
        $hari=LoginManager::getUserTypeByuname("$narayan");
       
        	$sql ="SELECT * FROM frquencytracker WHERE drid='$_GET[drid]'";
        	
		$qsql = mysqli_query($con,$sql);
		while($re = mysqli_fetch_array($qsql))
		{
		    	$sql1 ="SELECT * FROM list_tretment WHERE trid='$re[surgery]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re2 = mysqli_fetch_array($qsql1))
		{
		$sql12 ="SELECT * FROM frquencytracker WHERE drid='$_GET[drid]'";
		$qsql12 = mysqli_query($con,$sql12);
		$rh12 = mysqli_fetch_array($qsql12);
		
		    $a=$count++;
		    	$sql1 ="SELECT * FROM site_users WHERE userno='$re[drid]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re1 = mysqli_fetch_array($qsql1))
		{
		 
      	
		
     echo"         
 
    <tbody>
      <tr>
        <td>$a</td>
        <td><a style='color:blue;text-decoration: none;' class='a1'  target='_blank' href='frequency_add.php?drid=$re[drid]&surgeryid=$re[surgeryid]'><u><h4>$re2[tratment]</h4></u></a></td>
        "; ?>
     
        <td><a href='fresurgeryshow.php?drid=<?php echo $_GET[drid] ?>&surgeryid=<?php echo $re[surgeryid] ?>' style='color:red;font-size:20px;' onclick="return confirm('Are you sure?')"><i class='fa fa-trash-o'></i></a></td>
       <?php echo "
      </tr>
    </tbody>
   
	
	
	
	";
		}
		}
		}
		
		echo"<br>	<a style='color:#ffffff; float:right;text-decoration: none;margin-bottom:12px;'  target='_blank' href='frqsurgeryadd.php?drid=$_GET[drid]' class='btn btn-primary mb-1 a1'><u><h4 align='center'>Add New</h4></u></a>
</table>	";
		}?>
	<br>
    <br>
   
  </div>
    <?php

?><style>
    .a1{ text-decoration: none; }
</style>