<div class='col-sm-12'>
  
      <div class="container">
        <div class="row">
            <div class="col-sm-12">
                
                
                 <table class="table" style="width:100%;">
                    <tr>
                        
                      <td>
        
        <img class="nav-user-photo1" src="../../uploads/<?php echo $Rowhco['Logo'] ?>" />
        
        
        </td>   
                        
                        
                    <td>
         <?php
        
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql = mysqli_query($con,$sql);
		$rs = mysqli_fetch_array($qsql);
	
$hco ="SELECT * FROM hco WHERE adminid='$rs[entered_by]'";
$Qhco = mysqli_query($con,$hco);
$Rowhco = mysqli_fetch_array($Qhco);
$usertype=$Rowhco['adminid'];

	 $sql ="SELECT * FROM admin WHERE id='$Rowhco[adminid]'";
		$qsql = mysqli_query($con,$sql);
		$ra = mysqli_fetch_array($qsql);
         ?>              
                       
        <span style="font-size:18px; float:right;">
             <h4><b><?php echo $ra['hsname'] ?></b></h4>
        <?php echo $Rowhco['Street'] ?> &nbsp;|&nbsp;<?php echo $Rowhco['Locality'] ?></br>
        <?php echo $ra['EmailID'] ?>&nbsp;|&nbsp; <?php echo $ra['numbers'] ?></p>
        
        </span></td>
    
    
   </tr>
        
        
        
        </table>
        
        
        </div>
        
        </div>
        </div>
    <hr>
						
             	 <?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">
         Glass Advices Near 
 </strong></h4>            
               <br>
             
 
  <table id="example2" class="table table-bordered table-hover">
                  <thead>
         
						<tr>
						    	<th>Glass Advices Near</th>
							<th>Right Eye</th>
							<th>Left Eye</th>
						</tr>
				
      
                  </thead><tbody>
<?php

$sql ="SELECT * FROM Glass_Advices WHERE  patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND  Examination_type='near'";
$qsql = mysqli_query($con,$sql);
$rs = mysqli_fetch_array($qsql);

     echo " 
            <tr>
                      <td>&nbsp;$rs[SPH]</td>
                     <td>&nbsp;$rs[SPH_right]</td>
               		<td>&nbsp; $rs[SPH_left]</td>
          </tr> 
          <tr>
                      <td>&nbsp;$rs[CYL]</td>
                     <td>&nbsp;$rs[CYL_right]</td>
               		<td>&nbsp; $rs[CYL_left]</td>
          </tr>
          <tr>
                      <td>&nbsp;$rs[AXIS]</td>
                     <td>&nbsp;$rs[AXIS_right]</td>
               		<td>&nbsp; $rs[AXIS_left]</td>
          </tr>
          <tr>
                      <td>&nbsp;$rs[VISION]</td>
                     <td>&nbsp;$rs[VISION_right]</td>
               		<td>&nbsp; $rs[VISION_left]</td>
          </tr>
          
          ";


?>    </tbody>
          </table>										
										
    <div style="page-break-before:always">&nbsp;</div>
    
</div>					
					
					
				   	</div>
					
					</div>