<?php
session_start();
require_once("../dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
include("header.php");
?>

<style>

#topright {
    position: absolute;
    right: 0;
    top: 0;
     margin-top: 73px;
       margin-right: 30px;
    display: block;
    height: 70px;
    width: 70px;
    background: url(TRbanner.gif) no-repeat;
    text-indent: -999em;
    text-decoration: none;
}
#toprightj {
    position: absolute;
    right: 0;
    top: 0;
     margin-top: 73px;
       margin-right: 120px;
    display: block;
    height: 70px;
    width: 70px;
    background: url(TRbanner.gif) no-repeat;
    text-indent: -999em;
    text-decoration: none;
}


#toprightb {
   
    position: absolute;
    right: 0;
    top: 0;
     margin-top: 73px;
       margin-right: 200px;
    display: block;
    height: 70px;
    width: 70px;
    background: url(TRbanner.gif) no-repeat;
    text-indent: -999em;
    text-decoration: none;
}

       .center {
   border: 1px solid grey;
   text-align:;
}
    .center2 {
   border: 5px solid grey;
   text-align:;
}
</style>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
               <style>
 
h2 {
  color: #4287f5;
}
a img {
  border: none;
}

#memo {
  padding-top: 50px;
  margin: 0 20px 0 60px;
  border-bottom: 1px solid #ddd;
  height: 200px;
}
#memo .logo {
  float: left;
  margin-right: 20px;
}
#memo .logo img {
  width: 150px;
  height: 100px;
}
#memo .company-info {
  float: right;
  text-align: right;
}
#memo .company-info > div:first-child {

  font-weight: bold;
  font-size: 22px;
  color: #1e73be;
}
#memo .company-info span {
  font-size: 11px;
  min-width: 20px;
}

</style>
 <div class="content-wrapper">

<section id="memo">

        <div class="logo">
            <?php
            $narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
 $sql ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
{
            $sql ="SELECT * FROM hco WHERE adminid='$rs[entered_by]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
			{
		 $sql ="SELECT * FROM admin WHERE id='$rs[adminid]'";
		$qsql = mysqli_query($con,$sql);
		if($ra = mysqli_fetch_array($qsql))
		{
		      $services ="SELECT * FROM `services` Where adminid='$ra[id]'";
		$qservices = mysqli_query($con,$services);
		if($rservices = mysqli_fetch_array($qservices))
		{
			    echo"
			         <img data-logo='' src='uploads/$rs[Logo]' />
     </div>
               <div class='company-info'>
          <div>$rservices[pharmacyName]</div>
           <div>
        <span style='font-size:18px'>GST No:&nbsp; $rservices[GSTNo]&nbsp;|&nbsp;Lic NO:&nbsp; $rservices[LicNO]</br>
           &nbsp; <i class='fa fa-map-marker' aria-hidden='true'></i>&nbsp;
       $rs[Street]&nbsp;|&nbsp;$rs[Locality]</br>&nbsp;<i class='fa fa-envelope' aria-hidden='true'></i>&nbsp;$ra[EmailID]&nbsp;|&nbsp;<i class='fa fa-phone-square' aria-hidden='true'></i>&nbsp; $ra[numbers]</p></span>
            </div>
   ";           
		}
			}  
		}}
          ?>
    <br>
      </section>
      <br>
      <?php
include("dbconnection.php");
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
         $sql1 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'";
		$qsql1 = mysqli_query($con,$sql1);
		if($rspi1 = mysqli_fetch_array($qsql1))
		{
	$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rs[entered_by]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
if($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    	$sqlpatient = "SELECT * FROM medicine_slot WHERE prescriptionid='$_GET[prescriptionid]'";
	$qsqlpatient = mysqli_query($con,$sqlpatient);
	if($rsp = mysqli_fetch_array($qsqlpatient))
	{
	    	$sqlpatient2 = "SELECT * FROM site_users WHERE userno='$rs[Admitted_Under]'";
	$qsqlpatient2 = mysqli_query($con,$sqlpatient2);
	if($rsn2 = mysqli_fetch_array($qsqlpatient2))
	{
	     
	    echo"
<div class='checkbox'><span style='float: left; font-size:19px;'><b>Admission Date/Time  :</b> $rs[created_at]</span><span style='float: right; font-size:19px;'><B>IP.no</B> :$rsp[srno]</span></div>
<br>
<div class='checkbox'><span style='float: left; font-size:19px;'><b>Department:</b> $rs[casetype]</span><span style='float: right; font-size:19px;'><b>Consultant :</b>$rsn2[name]</span></div>
<br>
<div class='checkbox'><span style='float: left; font-size:19px;'><b>UHID :</b> $rspi1[patientid]</span><span style='float: right; font-size:19px;'><b>Name</b> :$rspi1[patientname]</span></div>
     <br>
     <div class='checkbox'><span style='float: left; font-size:19px;'><b>Age:</b> $rspi1[dob]</span><span style='float: right; font-size:19px;'><b>SEX :</b>$rspi1[gendor]</span></div>
              <div class='card-body'>
             
      
      ";
	}}}
}
}
	?>