<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
include("dbconnection.php");
if(isset($_POST['signup'])) 
?>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h3 align='center'>Ventilator</h3>
   	<table id="example2" class="table table-bordered table-hover"> 

      <tbody>
                  <tr>
          <th><div align="center">Start At <br>
          (YYYY-MM-DD)</div></th>
          <th><div align="center">Stop At <br>
          (YYYY-MM-DD)</div></th>
            <th><div align="center">Duration </div></th>
          <th><div align="center">Created By</div></th> 
          

               </tr>
        </tbody>
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
	  $narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
	$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
		$qsql1 = mysqli_query($con,$sql1);
		while($re = mysqli_fetch_array($qsql1))
		{
$sql4 ="SELECT * FROM Ventilator WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND id='$_GET[id]'";
		$qsql4 = mysqli_query($con,$sql4);
		while($rpn = mysqli_fetch_array($qsql4))
		{
		    
		    $date1 =$rpn[Ventilator_start]; 

$date2 =$rpn[Ventilator_stop]; 
$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);
$hour = abs($timestamp2 - $timestamp1)/(60*60);

$d8=round($hour);
echo " <tbody>
	                <tr>
             <td>&nbsp;$rpn[Ventilator_start]</td>
                   <td>&nbsp;$rpn[Ventilator_stop]</td>
                 
                    <td>";
if ($rpn[Ventilator_stop]=='') {
if ($d8 < "1") {
}
} 

else
{
    echo"$d8";
}


    echo"</td>
       <td>&nbsp;$re[name]</td>
         </tr>                   
          
          ";


}

}

?>   
</tbody>
  <tfoot>
          </tfoot>
        </table>