<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
//Code for Registration 
if(isset($_POST['signup'])) 
{ 
$sql ="UPDATE Request_Transport SET Type_Ambulance='$_POST[Type_Ambulance]',Departure='$_POST[Departure]',Arrival='$_POST[Arrival]',EN_Route='$_POST[EN_Route]',Loading_Startup='$_POST[Loading_Startup]',Duration='$_POST[Duration]',Inspection_Report='$_POST[Inspection_Report]',Duration2='$_POST[Duration2]'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";

if($qsql = mysqli_query($con,$sql))
	{
    echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } 
  else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>
<style>
    
.center {
   border: 1px solid grey;
   text-align:;
}

</style>
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">


    <form name='signup' method='POST'>
        <div class='center'>
<table id='example2' class='table table-bordered table-hover'>

<?php 
		$sql ="SELECT * FROM Request_Transport WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo "
 <tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Type of Ambulance: </td>
<td width='50%'><select name='Type_Ambulance'>
        <option value='$rs[Type_Ambulance]'>$rs[Type_Ambulance]</option>
       <option value='Basic Life Support Ambulance'>Basic Life Support Ambulance</option>
    <option value='Advanced Life Support Ambulance'>Advanced Life Support Ambulance</option>
     <option value='Air Ambulance'>Air Ambulance</option>
           </select></td>
</tr>

<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Scheduled Departure :  </td>
<td width='50%'><input name='Departure' value='$rs[Departure]' type='datetime-local'></td>
</tr>

<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  EN Route :  </td>
<td width='50%'><input name='EN_Route' value='$rs[EN_Route]' type='text'></td>
</tr>

<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Expected Drop At :  </td>
<td width='50%'><input name='Loading_Startup' value='$rs[Loading_Startup]' type='datetime-local'></td>
</tr>

<tr><td><div><h5>Inspection Report    : </h5> </td></div><td><div><select name='Inspection_Report'>";?>
        <option value='' >Inspection Report</option>
       <option value='Self Inspected' <?php  echo ($rs[Inspection_Report] == 'Self Inspected') ? 'selected' : '';?>>Self Inspected</option>
    <option value='Third Party Inspection Report' <?php  echo ($rs[Inspection_Report] == 'Third Party Inspection Report') ? 'selected' : '';?>>Third Party Inspection Report</option>
     <option value='Missing' <?php  echo ($rs[Inspection_Report] == 'Missing') ? 'selected' : '';?>>Missing</option>
       <?php echo "</select></div></td></tr>
</div>
</tr>

";
}
?>
</table>

<input type='submit' name='signup' value='Update'>
</div>
</form>