<?php
include "koneksi.php";

$yesterday = new Datetime('yesterday');
$awal = $yesterday->format('Y-m-d H:i:s'); // waktu sekarang
$akhir = date('Y-m-d H:i:s');
//view data datapasien di dalam database

$Lihat = "SELECT * FROM datapasien WHERE status_tunggu='menunggu' ";
$pasiencount = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE tanggal BETWEEN'$awal' AND '$akhir'"));
$pasienregcount = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE ruang='reguler' AND tanggal BETWEEN'$awal' AND '$akhir'"));
$pasiencovcount = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE ruang='covid' AND tanggal BETWEEN'$awal' AND '$akhir'"));
$Tampil = mysqli_query($open, $Lihat);
$p1count = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'covid'AND status_tunggu='menunggu' AND triage='p1'"));
$p2count = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'covid'AND status_tunggu='menunggu' AND triage='p2'"));
$p3count = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'covid'AND status_tunggu='menunggu' AND triage='p3'"));
$p0count = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'covid'AND status_tunggu='menunggu' AND triage='p0'"));
$p1regcount = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'reguler'AND status_tunggu='menunggu' AND triage='p1'"));
$p2regcount = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'reguler'AND status_tunggu='menunggu' AND triage='p2'"));
$p3regcount = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'reguler'AND status_tunggu='menunggu' AND triage='p3'"));
$p0regcount = mysqli_num_rows(mysqli_query($open,  "SELECT * FROM datapasien WHERE ruang= 'reguler'AND status_tunggu='menunggu' AND triage='p0'"));


while ($hasil              = mysqli_fetch_array($Tampil)) {
    // $nama               = stripslashes($hasil['nama']);
    // $register           = stripslashes($hasil['register']);
    $triage             = stripslashes($hasil['triage']);
    $ruang              = stripslashes($hasil['ruang']);
    $alamat             = stripslashes($hasil['alamat']);
    $telepon            = stripslashes($hasil['telp']);
    $tanggal            = stripcslashes($hasil['tanggal']);
    $status_keluar      = stripcslashes($hasil['status_keluar']);
    $file               = stripcslashes($hasil['file_text']);
    $smf                = stripcslashes($hasil['smf']);
    $status_tunggu      = stripslashes($hasil['status_tunggu']);

    // table nama perawat
    $sql = " SELECT nama_perawat FROM tb_perawat ORDER BY nama_perawat ASC";


    //selisih tanggal waktu

    // call the function

    {
?>
                 <?php
                }
            }


                    ?>