<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once('../patientmanager.php');
include 'workdeskmenu.php';
include 'header.php';
include("dbconnection.php");
$DisplayForm=True;
$today = date('Y-m-d');
 $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal' AND usertype='Doctor'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rh1 = mysqli_fetch_array($qsql1))
		{
$DisplayForm=False;
echo "<script>window.location='frequency_add.php?drid=$rh1[userno]'</script>";
}
if($DisplayForm)
{
?>
 <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'>
        <tr><th>Doctor</th>
        <th>Action</th>
        </tr>
<?php
include("dbconnection.php");
$username = "ventexint@gmail.com";
    $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
    $sendername = "EASNUP";
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
          	$sqldoctor= "SELECT * FROM site_users WHERE usertype='Doctor' and entered_by='$re[entered_by]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
				
				echo "<tr><td>$rsdoctor[name]</td><td><a href='fresurgeryshow.php?drid=$rsdoctor[userno]'>View</a></td></tr>";
				}
		}
		?>
</table>
</div>
<?php
}
?>