<?php
require_once('../../LoginManager.php');
require_once('../../DBManager.php');
include('menu.php');
include('header.php');
?>
     <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
              <!-- /.card-header -->
  <?php 
  session_start();
require_once('../../DBManager.php');
require_once('../../LoginManager.php');
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
  	$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql = mysqli_query($con,$sql);
		$re = mysqli_fetch_array($qsql);
		    
		  if($re['usertype']=='pharma'){            
              
              ?>
              <div class="card-body">
                <table id="example2" class="table table-bordered table-hover">
                  <thead>
                  <tr>
             <th><strong>Toward</strong></th>
          <th><strong>Document</strong></th>
            
          <th><strong>View</strong></th>              
        </tr>
      
                  </thead>
<?php
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql = mysqli_query($con,$sql);
		if($re = mysqli_fetch_array($qsql))
{
		$sql ="SELECT * FROM pharma_doc WHERE pharma_Id='$re[userno]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql)){
		
	
            echo " <tbody>
            <tr>   <td>
            &nbsp;<b>Date Of Issue</b>:-$rs[dateofissue]<br>
            &nbsp;<b>Issue By</b>:-$rs[issueby]
            
            
            </td>
              		<td>&nbsp;<b>Type Document</b>:- $rs[typedocument]<br>
              		<b>Specify</b>:- $rs[Specify]
              		</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>
          
               
             <p align='right'><a  href='Add_ProfessionalProfile.php?userno=<?php echo $_GET['userno']; ?>'>
          <button style='height:40px;width:200px'> Add Document</button><span class='caret'></span></p>
          </a>
          

        
       </td></tr>
      
    <center> <a  href='MedicalCondition_Emp.php?userno=<?php echo $_GET['userno']; ?>' class='btn btn-info' style='width:100%;'>
           Next
          </a></center>
      
      </div>
      <?php }  ?>
     
      <?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
}
?>