<?php
session_start();
$username = "ventexint@gmail.com";
    $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
    $sendername = "EASNUP";
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once('../patientmanager.php');
include 'patient_menu.php';
include 'header.php';
include("dbconnection.php");
if(isset($_POST[signup]))
{ 
      PatientManager::Addaspatient("$_POST[patientid]","$_POST[hospitalid]","$_POST[typevisit]","$_POST[casetype]","$_POST[Admitted_Under]","$_POST[entered_by]");
      
}
$DisplayForm=True;
$today = date('Y-m-d');
 $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rh1 = mysqli_fetch_array($qsql1))
		{
		$sql ="SELECT * FROM discharge WHERE hospital_id='$rh1[entered_by]' AND patientid='$_GET[patientid]' AND status='Admission' AND date(admissiondate) = '$today'";
		$qsql = mysqli_query($con,$sql);
		if($rh = mysqli_fetch_array($qsql))
		{
$DisplayForm=False;
echo "<script>window.location='treatment_timline.php?prescriptionid=$rh[prescriptionid]&patientid=$rh[patientid]'</script>";
}
}
if($DisplayForm)
{
?>

<?php 
include("dbconnection.php");
$username = "ventexint@gmail.com";
    $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
    $sendername = "EASNUP";
		 $narayan=LoginManager::currentUser();
        $hari=LoginManager::getUserTypeByuname("$narayan");
        	$sql ="SELECT * FROM site_users WHERE userno='$hari'";
		$qsql = mysqli_query($con,$sql);
		if($re = mysqli_fetch_array($qsql))
		{
		$sql ="SELECT * FROM admin WHERE id='$re[entered_by]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
	    $sql ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rp = mysqli_fetch_array($qsql))
		{
		      $user_otp=$rp['user_otp'];
		      	$hsname=$rs['hsname'];
	    	$name=$rp['patientname'];
	    	$numbers=$rp['numbers'];
	    	$password=$rp['password'];
		$message="Hello $name, Kindly share OTP $user_otp with $hsname to grant permission to access medical records Regards, HAND Corp";
	$message=urlencode($message);
$sms ="http://login.aquasms.com/sendSMS?username=ventexint@gmail.com&message=$message&sendername=EASNUP&smstype=TRANS&numbers=$numbers&apikey=eebcced9-0ca1-4a6f-940b-c616276e2ec9";
	//$sms=urlencode($sms);
	$result=file_get_contents($sms);
	if(mysqli_query($con, $sql)){
 echo '';
 }
		    
		     $narayan1=LoginManager::currentUser();
        $hari2=LoginManager::getUserTypeByuname("$narayan1");
        	$entered_by="$hari2";
		    echo "
<form name='signup' method='post'>


		    <div class='content-wrapper'>
    <!-- Content Header (Page header) -->
    <section class='content-header'>
    <div class='center'>
    
    <table id='example2' width='100%' class='table table-bordered table-hover'>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Name of Hospital: </td>
<td width='50%'>$rs[hsname]</td>
</tr>
<input type='hidden' name='patientid' value='$rp[patientid]'>
<input type='hidden' name='hospitalid' value='$rs[id]'>
<input type='hidden' name='entered_by' value='$entered_by'>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Type of visit :  </td>
<td width='50%'><select name='typevisit'>
    
     <option value='' disabled selected>Type of visit </option>
     <option value='Opd_Emergency'>OPD Emergency</option>
  <option value='OPD'>OPD</option>
   ";
$acs=$rs['ipdacs'];
if($acs == 'on'){
    echo "<option value='IPD'>IPD</option>
      <option value='Ipd_Emergency'>IPD Emergency</option>";
} else{
    echo "";
}
echo"
  
</select></td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Case Type:  </td>
<td width='50%'><select name='casetype'>
    ";
		}
		}
		}
		?>
		
     <option value='' disabled selected>Case Type </option>
 
    <option value='Eye_Care'>Eye Care</option>
      <option value='General'>General</option>
     <?php
     include("dbconnection.php");
	  $sql1 ="SELECT * FROM patient WHERE patientid='$_GET[patientid]'";
		$qsql1 = mysqli_query($con,$sql1);
		while($rspi1 = mysqli_fetch_array($qsql1))
		{
		    $sex=$rspi1['gendor'];
		      if($sex == 'female'){
		          echo"
		          	<option value='Pregnancy'>Pregnancy</option>";
		          	}else
		          	{
		          	    echo"";
		          	}
		    
		}
		          	?>
</select></td>
</tr>

<tr>

<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Admitted Under</td>
<td width='50%'>
<select name='Admitted_Under' id='select2'>
          <option value='' disabled selected>Admitted Under</option>
";
<?php
include("dbconnection.php");
$username = "ventexint@gmail.com";
    $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9";
    $sendername = "EASNUP";
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
		$qsql1 = mysqli_query($con,$sql1);
		if($re = mysqli_fetch_array($qsql1))
		{
          	$sqldoctor= "SELECT * FROM site_users WHERE usertype='Doctor' and entered_by='$re[entered_by]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
				
				echo "<option value='$rsdoctor[userno]'>$rsdoctor[name]</option>";
				}
		}
		?>
		echo"
		  </td>
		  </select>

</div>
</table>

 <table id='example2' class='table table-bordered table-hover'>
<tr>

<td><button type="submit" name="signup">Proceed</butoon>
</tr>
</table>
</div>
</form>
<html>
           <head>
               <style>
                     
       .center {
   border: 1px solid grey;
   text-align:;
}
h2 {
  color: #4287f5;
}
</style>
               
           </head>
   
<?php
}
?>