<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
require_once('../patientmanager.php');
?>
 <div class="">
    <!-- Content Header (Page header) -->
    <section class="content-header">
<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
if(isset($_POST[handover]))
{
 PatientManager::dis_diagnosistimilinetest("$_GET[prescriptionid]","$_GET[patientid]","$_POST[diagnosis]","$_POST[Surgery]","$_POST[entered_by]");	
}
		
?>

 
    	<table id="example2" class="table table-bordered table-hover">  
            
              <tr>
             <th>Date & Time</th>    
          <th>Diagnosis</th>
             <th>Treatment & Surgery</th>
            </tr>
            
          <?php
		$sql ="SELECT * FROM diagnosis_timiline WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs4 = mysqli_fetch_array($qsql))
		{
           echo" <td>$rs4[created_at]</td>
           <td>&nbsp;$rs4[diagnosis]</td>
           
           
           <td>&nbsp;";
       
	$sqlpatient1 = "SELECT * FROM list_tretment Where trid='$rs4[Surgery]'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo"
           $rsn[tratment]";
           }
           echo"</td>
          </tr>                   
          
          ";
}
?>




            </table>
  <p>&nbsp;</p>
  <form name='handover' method='POST'>
      	<table id="example2" class="table table-bordered table-hover">
      <td width='50%'><b>Diagnosis :</b></td>
      <td>
<input type="text" class="form-control" id="diagnosis" autocomplete="off"  name="diagnosis" list="results" required>
                                <datalist id="results">
                                <?php
include("dbconnection.php");

$sql ="SELECT * FROM `daignosist_icd`";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
     echo " 
     <option value='$rs[Description] ($rs[ICD])'></option>
                   
          
          ";
}

?> 
                                </datalist>    
          
</td>
</tr><tr>
<td width='50%'><b>Proposed Treatment/ Surgery:</b></td>
                    <td width='50%'>
                        <select name='Surgery' required>
        	<option value=''>Proposed Treatment/ Surgery</option>
                  <?php
	$sqlpatient1 = "SELECT * FROM list_tretment";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo "<option value='$rsn[trid]'>$rsn[tratment]</option>";
				}
?>
</td>
</select>
        </tr>
        </table>

<input type='submit' name='handover' value='Submit'>


  </form>
  

</div>