<div class='col-sm-12'>
	     <?php
     session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');

    include("../dbconnection.php");
		$sql2 ="SELECT * FROM save_activity WHERE srno='$_GET[srno]'";
		$qsql2 = mysqli_query($con,$sql2);
		if($re1 = mysqli_fetch_array($qsql2))
		{
		    
		   	include 'dashboarddocument.php';
}
?>
	  

  <?php

include 'fileheader.php';
?>			
             	 <?php

      

	    	$sqlpatient2 = "SELECT * FROM site_users WHERE userno='$rpatient[Admitted_Under]'";
	$qsqlpatient2 = mysqli_query($con,$sqlpatient2);
	if($rsn2 = mysqli_fetch_array($qsqlpatient2))
	{
	    echo"
<div class='checkbox'><span style='float: left;'><b>Admission On  :</b> $rpatient[created_at]<br>
<b>Consultant :</b>$rsn2[name]($rpatient[casetype])

</span>

<span style='float: right;'><B>File No.</B> :$rpatient[prescriptionid] <br>";

$sqlpatient = "SELECT * FROM save_activity WHERE  prescriptionid='$_GET[prescriptionid]' AND discription='Intial Assessment<br>GENERAL CONSENT<br>Doc.no-'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    if($rsp[discription]== 'Intial Assessment<br>GENERAL CONSENT<br>Doc.no-'){
	        echo"<b>Doc.no </b>: $rsp[srno]";

} else{
    echo "";
}
       
	}


echo "</span></div><br>



<br><br>
<div class='checkbox'><span style='float: left;'><b>UHID :</b> $rspi1[patientid]</span><span style='float: right;'><b>Name</b> :$rspi1[patientname]</span></div>
     <br>
     <div class='checkbox'><span style='float: left;'><b>Age:</b> $rspi1[dob]</span><span style='float: right;'><b>SEX :</b>$rspi1[gendor]</span></div>
              <div class='card-body'>
             
      
      ";
	}


	?> 
      <br>   
             
 <div class="panel panel-primary">
               
    <div class="panel-body">
      <h4 class="text-on-pannel text-primary"><strong class="text-uppercase">
       Examination
 </strong></h4>            
               <br>
             
 
   <table id="example2" class="table table-bordered table-hover" style='width:100%;' border='1'>
                  <thead>
         
						<tr>
						    <th>Examination</th>
							<th>Right Eye</th>
							<th>Left Eye</th>
							
						</tr>
				
      
                  </thead>
<?php
$sql12 ="SELECT * FROM onexamnation WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'   AND Examination!='Aided / Present Glass' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'   AND Examination!='Un-Aided'";
$qsql12 = mysqli_query($con,$sql12);
while($rs12 = mysqli_fetch_array($qsql12))
{
    
    if($rs12['Examination']!=='Aided / Present Glass')
{
       if($rs12['Examination']!=='Un-Aided')
{

 echo " <tbody>
            <tr>     <td>&nbsp;$rs12[Examination]</td>
                     <td>&nbsp;$rs12[Result]</td>
               		<td>&nbsp; $rs12[left_result]</td>
               	
          </tr>                   
          
          ";
}
}
}
?>    </tbody>
  <tfoot>
          </tfoot>
        </table>									
										
    <div style="page-break-before:always">&nbsp;</div>
    
</div>					
					
					
				   	</div>
					
					</div>