<?php
include("dbconnection.php");
include("patient_menu.php");
?>
     <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
              <!-- /.card-header -->
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Date</strong></th>
          <th><strong>Organization Name</strong></th>
            <th><strong>Document Type  </strong></th>
          <th><strong>View</strong></th>              
        </tr>
      
                  </thead>
<?php
$sql ="SELECT * FROM patient_document WHERE patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
	$sqlpatient = "SELECT * FROM patient WHERE patientid='$rs[patientid]'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	$rspatient = mysqli_fetch_array($qsqlpatient);
	
	$sqldoctor = "SELECT * FROM admin WHERE adminid='$rs[adminid]'";
	$qsqldoctor = mysqli_query($con,$sqldoctor);
	$rsdoctor = mysqli_fetch_array($qsqldoctor);

            echo " <tbody>
            <tr>   <td>&nbsp;$rs[dateofissue]</td>
              		<td>&nbsp;$rs[issueby]</td>
              		<td>&nbsp;$rs[typedocument]</td>
              							<td><a href='uploads/$rs[fileToUpload]' ><i class='fa fa-eye' aria-hidden='true' style='font-size:20px; color:black;'></i></td>
          </tr>                   
          
          ";
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>
          
                    <?php
		$sql ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
  echo "
             <p align='right'><a  href='upload_document.php?patientid=$rs[patientid]'>
          <button style='height:40px;width:200px'> Add Document</button><span class='caret'></span></p>
          </a>
          ";

        
        echo "</td></tr>";
      }
     
      ?>
      </div>
      <?php
if(isset($_SESSION[doctorid]))
{
?>  

         
<hr>
	<table>
		<tr>
			<td>
			<div align="center"><strong><a href="prescription.php?patientid=<?php echo $_GET[patientid]; ?>&appid=<?php echo $rsappointment[appointmentid]; ?>">Add Prescription records</a></strong></div>
			</td>
		</tr>
	</table>
	<script>
  $(function () {
    $("#example1").DataTable({
      "responsive": true,
      "autoWidth": false,
    });
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>

<?php
}
?>