<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once('../patientmanager.php');
include 'workdeskmenu.php';
include 'header.php';
include("dbconnection.php");
if(isset($_POST[signup]))
{ 
      PatientManager::frequencyiv("$_POST[type]","$_POST[typeid]","$_POST[frq]","$_POST[route]","$_POST[duration]","$_POST[potential]","$_POST[adminid]","$_GET[drid]","$_GET[surgeryid]","$_POST[entered_by]");
      
}
?>


<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
	$sql ="DELETE FROM frequency WHERE surgeryid='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('Deleted successfully..');</script><script>window.location='frqsurgeryadd.php?drid=$_GET[drid]&surgeryid=$rh12[surgeryid]'</script>;";
	}
}
?>

    <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>

<form name='signup' method='post'>
<

		    <div class='content-wrapper'>
    <!-- Content Header (Page header) -->
    <section class='content-header'>
    <div class='center'>
    
    <table id='example2' width='100%' class='table table-bordered table-hover'>
        <?php 
include("dbconnection.php");
$username = "ventexint@gmail.com";
    $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
    $sendername = "EASNUP";
		 $narayan=LoginManager::currentUser();
        $hari=LoginManager::getUserTypeByuname("$narayan");
        	$sql ="SELECT * FROM site_users WHERE userno='$hari'";
		$qsql = mysqli_query($con,$sql);
		if($re = mysqli_fetch_array($qsql))
		{
		$sql ="SELECT * FROM admin WHERE id='$re[entered_by]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    echo"
<input type='hidden' name='adminid' value='$rs[id]'>
<input type='hidden' name='entered_by' value='$hari'>
<input type='hidden' name='type' value='inv'>
";
}
}
?>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Investigation Name:  </td>
<td width='50%'><select name='typeid' required>
    	<?php
				session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM list_Investigation";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
	    echo "<option value='$rs[ivid]'>$rs[Investigation]</option>";
				}
	
		  ?>
    
</select></td>
</tr>

</div>
</table>

 <table id='example2' class='table table-bordered table-hover'>
<tr>

<td><button type="submit" name="signup">Proceed</butoon>
</tr>
</table>




</form>


    <table id="example2"  class="order-table table table-bordered table-hover css-serial">
                  <thead>
         
						<tr>
						    <th>SR No</th>
						    <th>Investigation Details</th>
							<th>Action</th>
						</tr>
				
      
                  </thead>
<?php
include("dbconnection.php");

		    $sql12 ="SELECT * FROM frequency WHERE drid='$_GET[drid]' AND surgeryid='$_GET[surgeryid]' AND type='inv'";
$qsql12 = mysqli_query($con,$sql12);
while($rs12 = mysqli_fetch_array($qsql12))
{
    echo"<td></td>
    <td>
    ";
    $sql13 ="SELECT * FROM list_Investigation WHERE ivid='$rs12[typeid]'";
$qsql13 = mysqli_query($con,$sql13);
while($rs13 = mysqli_fetch_array($qsql13))
{
if (is_numeric($rs13[ivid]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs13[labdepartmentid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
if (is_numeric($rs13[radiobodypartid]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs13[radiobodypartid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[bodypart]";
}
   if (is_numeric($rs13[radiobodypartid]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs12[typeid]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[Investigation]";
}
else
{
            $sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs12[typeid]' OR ivid='$rs12[typeid]' AND labdepartmentid='Unspecified'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo"
	    $rsn[Investigation]"; }
}
echo"</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'>
	      <li><a href='frequencyinvestigation_add.php?delid=$rs[medicine_id]')'> <i class='glyphicon glyphicon-save'></i> Remove</a></li>
	  </ul>
	</div></td>
              					
          </tr>                   
          
          ";

}
}

?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
        
        </div>
<html>
 <head>
               <style>
                    
       .center {
   border: 1px solid grey;
   text-align:;
}
h2 {
  color: #4287f5;
}
</style>
               
           </head>
   


 <head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/js/standalone/selectize.min.js" integrity="sha256-+C0A5Ilqmu4QcSPxrlGpaZxJ04VjsRjKu+G82kl5UJk=" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.6/css/selectize.bootstrap3.min.css" integrity="sha256-ze/OEYGcFbPRmvCnrSeKbRTtjG4vGLHXgOqsyLFTRjg=" crossorigin="anonymous" />
</head>
  <script>

  $(document).ready(function () {
      $('select').selectize({
          sortField: 'text'
      });
  });
  </script>