50 lines
2.2 KiB
PHP
50 lines
2.2 KiB
PHP
<?php
|
|
date_default_timezone_set('Asia/Jakarta'); //Menyesuaikan waktu dengan tempat kita tinggal
|
|
include "model/koneksi.php";
|
|
session_start();
|
|
$nama_login = $_SESSION['nama'];
|
|
|
|
$query = $open->query("SELECT id_pasien, nama, register, smf, ruang, triage,nik,tanggal FROM datapasien WHERE status_tunggu= 'menunggu'");
|
|
$no = 0;
|
|
$total_row = mysqli_num_rows($query);
|
|
|
|
if ($total_row > 0) {
|
|
while ($data = mysqli_fetch_assoc($query)) {
|
|
$no++;
|
|
$tsql = "SELECT * FROM tb_tindakan WHERE id_pasien='$data[id_pasien]' AND masalah='belum'";
|
|
$sqlcount = mysqli_num_rows(mysqli_query($open, $tsql));
|
|
if ($sqlcount > 0) {
|
|
$count = $sqlcount;
|
|
} else {
|
|
$count = '';
|
|
}
|
|
|
|
$awal = date_create($data['tanggal']);
|
|
$akhir = date_create(); // waktu sekarang
|
|
$diff = date_diff($awal, $akhir);
|
|
$hour = $diff->h < 6;
|
|
$day = $diff->d == 0;
|
|
|
|
if ($hour && $day) {
|
|
$btnprolong = "btn btn-success";
|
|
} else {
|
|
$btnprolong = "btn btn-danger";
|
|
}
|
|
|
|
echo "<tr style='font-size: 10pt;'>
|
|
<td><a class=btn btn-light href='index.php?link=dataview.php&id_pasien=$data[id_pasien]' >$no</a></td>
|
|
<td>$data[triage]-$data[ruang] | $data[nik]</td>
|
|
<td><a class='btn btn-light position-relative' style='font-size: 10pt;'href='index.php?link=dataview.php&id_pasien=$data[id_pasien]' >$data[nama]</a></td>
|
|
<td>$data[register]</td>
|
|
<td>$data[smf]</td>
|
|
<td><a class='btn btn-light position-relative' style='font-size: 10pt;' onclick='warning()'>Pengkajian</a></td>
|
|
<td><a class='btn btn-light position-relative' style='font-size: 10pt;' onclick='warning()'>Tindakan<span class='position-absolute top-0 start-100 translate-middle badge rounded-pill bg-danger'>$count</span></a></td>
|
|
<td><a class='btn btn-light'style='font-size: 10pt;' onclick='warning()'>keluar</a></td>
|
|
<td><a class= '$btnprolong' style='font-size: 10pt;' data-bs-toggle='modal' data-bs-target='#prolong$data[id_pasien]'> $diff->d hari- $diff->h jam- $diff->i menit</a></td>
|
|
</tr>";
|
|
}
|
|
} else {
|
|
|
|
echo '<tr><td colspan="10" align="center">Data tidak ditemukan</td></tr>';
|
|
}
|