<?php
session_start();
include("dbconnection.php");

require_once('../DBManager.php');
require_once("../LoginManager.php");
require_once('../patientmanager.php');
if(isset($_POST[submit]))
{
    PatientManager::discharge("$_GET[prescriptionid]","$_GET[patientid]","$_POST[status]","$_POST[COdischarge]","$_POST[Advice_Discharge]","$_POST[created_by]","$_POST[entered_by]");
}
 if(isset($_POST[statusva]))
{ 
$sql ="UPDATE site_users SET status='$_POST[status]' WHERE  userno='$_GET[userno]'";
if($qsql = mysqli_query($con,$sql))
		{
    echo "<script>
 window.history.go(-1)</script>";
     } 
    
}
?>
   
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Name</strong></th>
          <th><strong>Username</strong></th>
            <th><strong>Password </strong></th>
          <th><strong>Action</strong></th>              
        </tr>
      
                  </thead>
<?php
include("dbconnection.php");
 $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sqlpatient1 = "SELECT * FROM site_users WHERE entered_by='$harilal' AND status='Active' AND usertype='FrontOffice' OR entered_by='$harilal' AND status='Active' AND usertype='DP_reception'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    
            echo " <tbody>
          
            <tr>   <td>&nbsp;$rsn[name] ($rsn[usertype])</td>
              		<td>&nbsp;$rsn[uname]</td>
              		 <td>&nbsp;$rsn[password]</td>
<td>&nbsp;<form method='post' name='statusva' action='playerset.php?userno=$rsn[userno]' >
<input type='submit' name='status' Value='Deactivate'>
</form>
";
}
?> 


    </tr> 

</tbody>
  <tfoot>
          </tfoot>
        </table>