Files
semakin-imut/ex_ambulan/data_dashboard_ambulan.php
2025-10-09 11:03:05 +07:00

58 lines
2.2 KiB
PHP

<?php
include "model/koneksi.php";
// db settings
date_default_timezone_set('Asia/Jakarta'); //Menyesuaikan waktu dengan tempat kita tinggal
// db connection
// $con = mysqli_connect($hostname, $username, $password, $database) or die("Error " . mysqli_error($con));
// fetch records
$sql = "SELECT * FROM tb_px_ambulan ";
$result = mysqli_query($open, $sql);
$array = array();
$no = 0;
while ($data = mysqli_fetch_assoc($result)) {
$no++;
// $awal = date_create($data['amb_jam_input']);
// $akhir = date_create(); // waktu sekarang
// $diff = date_diff($awal, $akhir);
// $jam_daftar = date('d-m-Y H:i', strtotime($data['amb_jam_input']));
// $hour = $diff->h < 6;
// $day = $diff->d == 0;
// if ($hour && $day) {
// $btnprolong = "btn btn-success btn-sm";
// } else {
// $btnprolong = "btn btn-danger btn-sm";
// }
$sub_array['no'] = "<p class='btn btn-light position-relative'style='font-size: 10pt;' href='' >$no</p>";
$sub_array['nama'] = "<p onclick='warning()'class=''style='font-size: 8pt;font-weight:bold;'title='Detail pasien'>$data[amb_nama]</p>
<p style='font-size: 8pt;'>No.RM : $data[amb_register]</p>";
$sub_array['prioritas'] = "<a onclick='warning()'class='btn btn-light position-relative' style='font-size: 8pt; font-weight:bold;' ><span class='position-absolute top-0 start-100 translate-middle badge rounded-pill bg-danger'>$data[amb_kriteria]</span></a>";
$sub_array['diagnosa_medis'] = "<p style='font-size: 8pt;'>$data[amb_alamat]</p>";
$sub_array['rencana'] = "<p style='font-size: 8pt;'>$data[amb_tujuan]</p>";
$sub_array['operator'] = "<select class='form-select' style='font-size: 8pt; font-weight: bold;'>
<option value=''style='font-weight: bold;' >-</option>
<option value='' >-</option>
<option><li role='divider'>-</li></option>
</select>";
$sub_array['waktu_tunggu'] = "<a class= '' href='' style='font-size: 10pt;' data-bs-toggle='modal' data-bs-target=''>Action</a>";
$array[] = $sub_array;
}
$dataset = array(
"echo" => 1,
"totalrecords" => count($array),
"totaldisplayrecords" => count($array),
"data" => $array
);
echo json_encode($dataset);