query("SELECT * from t_resumemedis where idxranap = {$_POST['IDADMISSION']}"); if ($tmp_cek->numRows() > 0) { $dirujuk = array_key_exists('alasan_rujuk', $_POST) ? $_POST['alasan_rujuk'] : 0; if ($_POST['idxpulang'] == '') { $boleh_pulang = TRUE; if ($_REQUEST['STATUSPULANG'] != "4") { // pasien kabur // $s = 'SELECT LUNAS from t_bayarranap where nomr = \''.$_REQUEST['NOMR'].'\' and idxdaftar = '.$_REQUEST['IDADMISSION']; // $s = $db->query($s); // $d = $s->fetchAll()[0]; // if( ($d['LUNAS'] != '1') and ($s->numRows() > 0) ){ // echo sprintf($msg_template,'alert-danger','Pasien belum melakukan pembayaran.'); // $boleh_pulang = FALSE; // exit; // } } $cek_resume = $db->query("SELECT * FROM t_resumepulang where idadmission = " . $_POST['IDADMISSION'] . " AND nomr = '" . $_POST['NOMR'] . "'"); if ($cek_resume->numRows() > 0) { // silent } else { if ($boleh_pulang == TRUE) { $sql = "INSERT INTO t_resumepulang (idadmission, nomr, jeniskelamin, kdruang, tglmasuk, tglkeluar,dirujuk, statuspulang, nip) VALUES ('{$_POST['IDADMISSION']}','{$_POST['NOMR']}','{$_POST['JK']}',{$_POST['KDRUANG']},'{$_POST['TGLMASUK']}','{$_REQUEST['TGLKELUAR']}',$dirujuk,{$_POST['STATUSPULANG']},'{$_SESSION['NIP']}')"; } } } else { $sql = "UPDATE t_resumepulang SET kdruang = '" . $_POST['KDRUANG'] . "', tglkeluar = '" . $_REQUEST['TGLKELUAR'] . "', statuspulang = '" . $_POST['STATUSPULANG'] . "', dirujuk = '" . $dirujuk . "', nip = '" . $_SESSION['NIP'] . "' WHERE idxpulang = " . $_POST['idxpulang']; } $qry = execute($sql); if ($qry) { // print_r($_REQUEST);exit; $data_rawat = $db->query("SELECT noruang,nott from t_admission where id_admission = {$_POST['IDADMISSION']}"); $data_rawat = !empty($data_rawat->fetchFirst()) ? $data_rawat->fetchFirst() : ''; $jam_keluar = date('H:i:s'); $st_meninggal = ($_REQUEST['STATUSPULANG'] == 8) ? 1 : 0; $dt_meninggal = (array_key_exists('dt_meninggal', $_REQUEST)) ? $_REQUEST['dt_meninggal'] : ''; $sebab_mati_1 = (array_key_exists('sebab_mati_1', $_REQUEST)) ? $_REQUEST['sebab_mati_1'] : ''; $sebab_mati_2 = (array_key_exists('sebab_mati_2', $_REQUEST)) ? $_REQUEST['sebab_mati_2'] : ''; $sebab_mati_3 = (array_key_exists('sebab_mati_3', $_REQUEST)) ? $_REQUEST['sebab_mati_3'] : ''; $icd_mati_1 = (array_key_exists('icd_mati0', $_REQUEST)) ? $_REQUEST['icd_mati0'] : ''; $icd_mati_2 = (array_key_exists('icd_mati1', $_REQUEST)) ? $_REQUEST['icd_mati1'] : ''; $icd_mati_3 = (array_key_exists('icd_mati2', $_REQUEST)) ? $_REQUEST['icd_mati2'] : ''; $arr_admission = [ 'rencana_pulang' => $_POST['TGLKELUAR'] . ' ' . $jam_keluar, 'st_meninggal' => ['value' => $st_meninggal, 'type' => 'number'], 'dt_meninggal' => $dt_meninggal, 'sebab_mati_1' => $sebab_mati_1, 'sebab_mati_2' => $sebab_mati_2, 'sebab_mati_3' => $sebab_mati_3, 'icd_mati_1' => $icd_mati_1, 'icd_mati_2' => $icd_mati_2, 'icd_mati_3' => $icd_mati_3 ]; if ($arr_admission['dt_meninggal'] == '') { unset($arr_admission['dt_meninggal']); } $sqls = "UPDATE t_admission " . bind_sql($arr_admission, 1) . " WHERE id_admission='" . $_POST['IDADMISSION'] . "'"; execute($sqls); execute("UPDATE m_detail_tempat_tidur SET status = 0, jenis_kelamin ='' WHERE no_tt='{$data_rawat['nott']}' AND idxruang='{$data_rawat['noruang']}'"); $msg = 'Simpan pulang berhasil.'; $type = 'success'; } else { $msg = 'Simpan pulang gagal.'; $type = 'error'; } } else { $msg = 'Maaf, Isikan terlebih dahulu Form Ringkasan Pasien Pulang(F8 Resume)'; $type = 'error'; } echo json_encode(['message' => $msg, 'type' => $type]);