46 lines
1.4 KiB
PHP
46 lines
1.4 KiB
PHP
<?php
|
|
include("../core/main.php");
|
|
// var_dump($_POST);
|
|
$id_admission = $_POST['id_admission'];
|
|
$get_datakamar = $db->query("SELECT *,r.nama as namaruang FROM t_admission_ruanghist a
|
|
JOIN t_admission reg ON a.idx_admission = reg.id_admission
|
|
JOIN m_ruang r ON a.no_ruang_asal = r.no
|
|
WHERE idx_admission = $id_admission ORDER BY a.id_ruanghist DESC");
|
|
$get_datakamar = !empty($get_datakamar->fetchAll()) ? $get_datakamar->fetchAll() : '';
|
|
$data = array();
|
|
$array_data = array();
|
|
if (!empty($get_datakamar)) {
|
|
foreach ($get_datakamar as $key => $value) {
|
|
if ($key == 1) {
|
|
$nama_ruang = $value['namaruang'];
|
|
$ruang_asal = $value['no_ruang_asal'];
|
|
$nobed_asal = $value['no_tt_asal'];
|
|
}
|
|
}
|
|
}
|
|
|
|
$chek_datakamar = $db->query("SELECT * FROM t_admission
|
|
WHERE keluarrs IS NULL AND noruang ={$ruang_asal} AND nott ='{$nobed_asal}' ");
|
|
$chek_datakamar = $chek_datakamar->fetchFirst();
|
|
|
|
if (empty($chek_datakamar)) {
|
|
$response_array = [
|
|
'status' => FALSE,
|
|
'response' => [
|
|
'namaruang' => $nama_ruang,
|
|
'ruang' => $ruang_asal,
|
|
'bed' => $nobed_asal
|
|
]
|
|
];
|
|
} else {
|
|
$response_array = [
|
|
'status' => TRUE,
|
|
'response' => [
|
|
'namaruang' => $nama_ruang,
|
|
'ruang' => $ruang_asal,
|
|
'bed' => $nobed_asal
|
|
]
|
|
];
|
|
}
|
|
echo json_encode($response_array);
|