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);