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

        
  <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>
    <table class="table table-hover table-bordered">
        <thead>
            <th>Date Time</th>
            
            <th>Assisted By</th><th>Action</th>
        </thead>
        <tbody>
           <?php 
include("dbconnection.php");
		 $narayan=LoginManager::currentUser();
        $hari=LoginManager::getUserTypeByuname("$narayan");
        	$sql ="SELECT * FROM drnote WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' ORDER BY `id` DESC";
		$qsql = mysqli_query($con,$sql);
		while($re = mysqli_fetch_array($qsql))
		{
                 
		  
     echo" <tr><td>
	<a style='color:blue'  target='_blank' href='casesummery.php?prescriptionid=$re[prescriptionid]&patientid=$re[patientid]&created_at=$re[updated_at]'><u><h4>$re[updated_at]</h4></u></a>
	
	
	</td>
                
                ";	    
                $sql1 ="SELECT * FROM site_users WHERE userno='$re[entered_by]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rs1 = mysqli_fetch_array($qsql1))
	echo"	<td><b></b>$rs1[name] </b> </td>";
		
	
		echo "<td><a href=''>View</a></td> </tr>";
		}	?>
           
        </tbody>
    </table>
       
	<br>
    <br>