Files
2024-04-19 14:04:41 +07:00

23 lines
954 B
PHP

<?php
$id_admission = $_REQUEST['indeks'];
$no_ruang = $_REQUEST['no_ruang'];
$nott = $_REQUEST['nott'];
$sql_kondisi = "SELECT * FROM t_admission WHERE noruang='$no_ruang' AND nott='$nott' AND keluarrs IS NULL";
$kondisi = $db->query($sql_kondisi);
$jmlh_data = $kondisi->numRows();
if($jmlh_data >= 1){
echo '<script>alert("Kamar sebelumnya sudah terisi, pilih kamar kosong lainnya.")</script>';
echo '<script>window.location = "'._BASE_.'index.php?link=129y&indeks='.$id_admission.'&historyback=12"</script>';
}else{
$sql2 = "DELETE FROM t_resumepulang WHERE IDADMISSION='".$id_admission."'";
$sql1 = "DELETE FROM t_resumemedis WHERE IDXRANAP ='".$id_admission."'";
$sql = "UPDATE t_admission SET keluarrs=NULL, icd_keluar='' WHERE id_admission='".$id_admission."'";
$db->query($sql2);
$db->query($sql1);
$db->query($sql);
echo '<script>alert("Pasien kembali masuk sukses!");window.location = "'._BASE_.'index.php?link=12";</script>';
}
?>