query("SELECT * from m_ppa"); if ($m_ppa->numRows() > 0) { $arr_ppa = array('' => 'Pilih PPA'); foreach ($m_ppa->fetchAll() as $ds) { if ($ds['nama_ppa'] == 'Petugas Lab') continue; $arr_ppa[$ds['id_ppa']] = $ds['nama_ppa']; } } if (array_key_exists('edit_cprj', $_REQUEST) && $_REQUEST['edit_cprj'] == 1) { // var_dump("EDIT_CPRJ"); $cprj = "SELECT a.*,case when (a.perawat <> 0 ) then b.nama when a.kddokter is not null then c.namadokter end as nama_ppa,d.nama_ppa as jenis_ppa from t_detail_diagnosakep a left join m_perawat b on a.perawat = b.idperawat left join m_dokter c on a.kddokter = c.kddokter left join m_ppa d on a.kategori = d.id_ppa where id_detail_diagnosakep = {$_REQUEST['id']}"; $tmp_cprj = $db->query($cprj); if ($tmp_cprj->numRows() > 0) { $form_cprj = 'edit'; $data = $tmp_cprj->fetchFirst(); $hidden_form = ''; } } else { $data['kategori'] = $data['nama_ppa'] = $data['evaluasi_a'] = $data['evaluasi_o'] = $data['evaluasi_p'] = $data['evaluasi_s'] = $data['review'] = ''; $form_cprj = 'daftar'; $hidden_form = ''; } $is_ppa = ''; $txt_ppa = ''; $user_id = ''; $user_name = ''; if (!empty($_SESSION['KDDOKTER'])){ $sql_user = "select namadokter as nama, kddokter as user_id, 'Dokter' as nama_ppa, 1 as id_ppa from m_dokter where kddokter = '".$_SESSION['KDDOKTER']."'"; $user = $db->query($sql_user)->fetchAll()[0]; if (!empty($user)){ $user_id = $user['user_id']; $is_ppa = $user['id_ppa']; $txt_ppa = $user['nama_ppa']; $user_name = $user['nama']; } } if (!empty($_SESSION['KDPERAWAT'])){ $sql_user = "select a.nama, a.idperawat as user_id, b.nama_ppa, b.id_ppa from m_perawat a join m_ppa b on b.id_ppa = a.ppa where idperawat = '".$_SESSION['KDPERAWAT']."'"; $user = $db->query($sql_user)->fetchAll()[0]; if (!empty($user)){ $user_id = $user['user_id']; $is_ppa = $user['id_ppa']; $txt_ppa = $user['nama_ppa']; $user_name = $user['nama']; } } ?>