simpanBill(); if (!$last_nonota) { $msg = "Tindakan gagal ditambahkan"; $type = "error"; } else { $tmp_get_last_bill = $db->query("SELECT br.idxbill,r.kode_tarif,r.uraian_tarif,br.idxdaftar from t_billranap br join m_tarif_rs r on br.kodetarif = r.kode_tarif where nonota = $last_nonota limit 1"); // var_dump($tmp_get_last_bill->fetchFirst()); // exit(); if ($tmp_get_last_bill->numRows() > 0) { $data_last_bill = $tmp_get_last_bill->fetchFirst(); if ($data_last_bill['uraian_tarif'] == 'PEMBULATAN') { $bill = $data_last_bill['idxbill']; $arr_update_bill['status_verifikasi'] = 1; $arr_update_bill['user_verifikasi'] = $_SESSION['NIP']; $arr_update_bill['tgl_verifikasi'] = $tanggal_sekarang; $v_billranap = "UPDATE t_billranap " . bind_sql($arr_update_bill, 1) . " where IDXBILL = " . $bill; $st_verif_bill = execute($v_billranap); // get 1 bill sebelum terakhi // $tmp_last_bayar = $db->query("SELECT carabayar from t_bayarranap where idxbill in (select idxbill from t_billranap where nonota = ".($last_nonota-1)." limit 1)"); // if($tmp_last_bayar->numRows() > 0) { // $data_last_bayar = $tmp_last_bayar->fetchFirst(); // $tunai_piutang = ($data_last_bayar['carabayar'] > 1) ? 2 : 1; $tunai_piutang = (array_key_exists('piutang', $_REQUEST) && $_REQUEST['piutang'] == 1) ? 2 : 1; $v_bayarrajal = "UPDATE t_bayarranap SET st_carabayar = $tunai_piutang WHERE IDXBILL=" . $bill; $st_verif_bayar = execute($v_bayarrajal); // } } elseif (preg_match("/ADMKL/", $data_last_bill['kode_tarif'])) { $tgl_krs = $tanggal_sekarang . date(' H:i:s'); $save_pj = execute("UPDATE t_admission set keluarrs = '$tgl_krs' where id_admission = {$data_last_bill['idxdaftar']}"); $data_rawat = $db->query("SELECT noruang,nott from t_admission where id_admission = {$data_last_bill['idxdaftar']}"); $data_rawat = !empty($data_rawat->fetchFirst()) ? $data_rawat->fetchFirst() : ''; execute("UPDATE m_detail_tempat_tidur SET status = 2 WHERE no_tt='{$data_rawat['nott']}' AND idxruang='{$data_rawat['noruang']}'"); } elseif (preg_match("/.AKO/", $data_last_bill['kode_tarif'])) { $tgl_krs = $tanggal_sekarang . date(' H:i:s'); $save_pj = execute("UPDATE t_admission set keluarrs = '$tgl_krs' where id_admission = {$data_last_bill['idxdaftar']}"); $data_rawat = $db->query("SELECT noruang,nott from t_admission where id_admission = {$data_last_bill['idxdaftar']}"); $data_rawat = !empty($data_rawat->fetchFirst()) ? $data_rawat->fetchFirst() : ''; execute("UPDATE m_detail_tempat_tidur SET status = 2 WHERE no_tt='{$data_rawat['nott']}' AND idxruang='{$data_rawat['noruang']}'"); } } $msg = "Tindakan berhasil ditambahkan"; $type = "success"; } echo json_encode(['message' => $msg, 'type' => $type, 'nonota' => $last_nonota]); exit;