<?PHP
session_start();
require_once("../dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
?>


<?php
session_start();
require_once('../DBManager.php');
require_once('../patientmanager.php');
include 'workdeskmenu.php';
include 'header.php';
include("dbconnection.php");
if(isset($_POST[signup]))
{ 
      PatientManager::createdailyinhouse("$_POST[reportid]","$_POST[admin_id]","$_POST[frq]","$_POST[report_to]","$_POST[report_by]","$_POST[entered_by]");
      
}
?>
 <link rel='stylesheet' href='assets/style.css'>                   
                      <center>	<h3 class='code'> Create Daily Report	</h3>
           	
          <a href='#' style='float:right;font-size:20px;margin-top:-23px;'><i class='fa fa-info-circle' aria-hidden='true' ></i></a></center>
          
<form name='signup' method='post'>
<?php 
include("dbconnection.php");
 $narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
 $sql ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
{
        	$sqlpatient1 = "SELECT * FROM dailyreport where reportid='$_GET[reportid]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
if($rsn = mysqli_fetch_array($qsqlpatient1))
		{
			    echo "



		    <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>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Name of Treatment/Surgery: </td>
<td width='50%'><input type='hidden' name='reportid' value='$rsn[reportid]'><input type='hidden' name='admin_id' value='$rs[entered_by]'>$rsn[description]</td>
";
}
}
?>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Frequency
 :  </td>
<td width='50%'><select name='frq'>
 <option value='' disabled selected>Frequency </option>
  <option value='Regular Interval'>Regular Interval
</option>
<option value='Daily at 9 am'>Daily at 9 am </option>
<option value='Daily at 5 pm'>Daily at 5 pm </option>
<option value='Daily'>Daily</option>
</select></td>
</tr>

<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Reported By: </td>
<td width='50%'><select name='report_by'>
 <option value='' disabled selected>Reported By </option><?php 
 require_once('../LoginManager.php');
include("dbconnection.php");
 $narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
 $sql ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
{
     $sql ="SELECT * FROM site_users WHERE entered_by='$rs[entered_by]' AND status='Active' AND usertype='Doctor' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='FrontOffice' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='pharma' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Nurse'  OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='RMO' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='HR' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Account' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='OT' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Lab' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Diagnostic' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Subadmin' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='lab_Doctor' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='lab_FrontOffice' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='lab_Account' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Biomed' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Maintenance' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Security' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='store' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Transport' OR entered_by='$rs[entered_by]' AND status='Active' AND usertype='Cleaning'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
{
    echo"<option value='$rs[userno]'>$rs[name]
</option>";
}
}
   ?>
    </select>
    

</table>

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

<td>
</tr>
</table>
</div>
<button type="submit" name="signup">Create</butoon>
</form>
<html>
           <head>
               <style>
                     
       .center {
   border: 1px solid grey;
   text-align:;
}
h2 {
  color: #4287f5;
}
</style>
               
           </head>
    <body>
     
  
		</body>
  </html>