<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("dbconnection.php");
include("header.php");
include("dashboarddocument.php");
?>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
                     		<?php 
		session_start();
$DisplayForm=True;
include("dbconnection.php");
$sql12 ="SELECT * FROM occutracker WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql12 = mysqli_query($con,$sql12);
		while($rh12 = mysqli_fetch_array($qsql12))
		{
	$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo "<script>window.location='occuadd.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'</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[occuid]))
{
	$sql ="DELETE FROM occutracker WHERE occuid='$_GET[occuid]' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
	//$sql1 ="DELETE FROM discharge WHERE  prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script>";
	}
}
		 $narayan=LoginManager::currentUser();
        $hari=LoginManager::getUserTypeByuname("$narayan");
        	$sql ="SELECT * FROM occutracker WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		$count=1;
		while($re = mysqli_fetch_array($qsql))
		{
		  $a=$count++;
     echo"
     
       <tbody>
      <tr>
        <td>$re[occuid]</td>
        <td>	<a style='color:blue;'  target='_blank' href='occumenu.php?prescriptionid=$re[prescriptionid]&patientid=$re[patientid]&occuid=$re[occuid]'> - $re[occu]<u><h4></td>
        "; ?>
     
        <td><a href='occularshow.php?occuid=<?php echo $re[occuid] ?>&prescriptionid=<?php echo $re[prescriptionid] ?>&patientid=<?php echo $re[patientid] ?>' 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;margin-bottom:12px;' class='btn btn-primary'   target='_blank' href='occuadd.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'><u><h4 align='center'>Add New Exam Sheet</h4></u></a>
</table>	";
		?>
	<br>
    <br>
      </div>
    <?php
}
?>
<style>
    .a1{ text-decoration: none; }
</style>