query("SELECT a.tgl_pelimpahan,d.kddokter as kddokter_utama,d.namadokter as dpjp_utama,smf_utama,e.kddokter as kddokter_pengganti,e.namadokter as dpjp_pengganti,smf_pengganti from t_pelimpahan_dpjp a join m_dokter d on a.dpjp_utama = d.kddokter join m_dokter e on a.dpjp_pengganti = e.kddokter where id_admission = $id_admission order by id_pelimpahan"); if ($cek_pelimpahan->numRows() > 0) { $st_input_pelimpahan = false; $data_pelimpahan_dpjp = $cek_pelimpahan->fetchAll(); $arr_pelimpahan = $data_pelimpahan_dpjp[$cek_pelimpahan->numRows() - 1]; // $nama_dpjp = $arr_pelimpahan['dpjp_utama']; // $smf_dpjp = $arr_pelimpahan['smf_utama']; $nama_dpjp = $arr_pelimpahan['dpjp_pengganti']; $smf_dpjp = $arr_pelimpahan['smf_pengganti']; $dpjp_pengganti = $arr_pelimpahan['kddokter_pengganti']; $smf_pengganti = $arr_pelimpahan['smf_pengganti']; $tgl_pelimpahan = $arr_pelimpahan['tgl_pelimpahan']; } else { $st_input_pelimpahan = false; $data_pelimpahan_dpjp = []; $nama_dpjp = $arr_dokter[$kddokter]; $smf_dpjp = $arr_smf[$kddokter]; $dpjp_pengganti = $kddokter; $tgl_pelimpahan = date('Y-m-d'); $smf_pengganti = ''; } ?>
| No. | Tanggal Pelimpahan | DPJP Asal | Dilimpahkan Ke DPJP | ||
|---|---|---|---|---|---|
| Nama DPJP | SMF DPJP | Nama DPJP | SMF DPJP | ' . $no . ' | ' . $row['tgl_pelimpahan'] . ' | ' . $row['dpjp_utama'] . ' | ' . $row['smf_utama'] . ' | ' . $row['dpjp_pengganti'] . ' | ' . $row['smf_pengganti'] . ' | '; $no++; } } ?>