52 lines
2.8 KiB
PHP
52 lines
2.8 KiB
PHP
<?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
|
|
}
|
|
}
|
|
|
|
|
|
?>
|