<?php include "../php/koneksi.php"; include "../php/fungsi.php"; $id_surat = anti_injection($_GET["id"]); $id_disposisi = anti_injection($_GET["id_disposisi"]); bacaDispSK($id_disposisi); $ds = mysql_fetch_array(mysql_query("SELECT \n \ta.*, b.unit_kerja, CONCAT('(', c.kode_masalah, ') ', c.masalah) AS masalah,\n \tCONCAT('(', d.kode, ') ', d.jenis_surat) AS jenis_surat\n FROM \n \tmyapp_maintable_suratkeluar a\n \tLEFT JOIN myapp_reftable_unitkerja b ON a.id_skpd_tujuan = b.id_unit_kerja\n \tLEFT JOIN myapp_reftable_masalah c ON a.id_masalah = c.id_masalah\n \tLEFT JOIN myapp_reftable_jenissurat d ON a.id_jenis_surat = d.id_jenis_surat\n WHERE \n \ta.id='" . $id_surat . "'")); ?> <fieldset> <legend><h3>EDIT SURAT KELUAR</h3></legend> <form name="frm" action="../php/edit_surat_keluar.php" method="POST"> <input type="hidden" name="id" value="<?php echo $_GET["id"]; ?> " /> <table border="0px" cellspacing='0' cellpadding='0' width='100%'> <tr> <td width='20%'>Nomor Surat</td> <td width='10px'>:</td> <td><b><?php echo $ds["no_surat"]; ?> </b></td> </tr> <tr> <td width='20%'>Tanggal Surat</td> <td width='10px'>:</td> <td><b><?php echo $ds["tgl_surat"];
<div> <?php include "../php/koneksi.php"; include "../php/fungsi.php"; bacaDispSK($_GET["id_disposisi"]); $sql = "SELECT\n \tb.level AS level_asal, c.level AS level_tujuan, a.catatan, a.tgl_disposisi, \n c.urutan AS urutan_tujuan, d.nama AS nama_tujuan,\n \te.urutan AS urutan_asal, f.nama AS nama_asal, a.keadaan\n FROM\n \tmyapp_disptable_suratkeluar a\n \tLEFT JOIN myapp_reftable_levelpengguna b ON a.id_level_asal = b.id\n \tLEFT JOIN myapp_reftable_levelpengguna c ON a.id_level_tujuan = c.id\n \tLEFT JOIN myapp_maintable_pengguna d ON a.id_pengguna_tujuan = d.id\n \tLEFT JOIN myapp_reftable_levelpengguna e ON a.id_level_asal = e.id\n \tLEFT JOIN myapp_maintable_pengguna f ON a.id_pengguna_asal = f.id\n WHERE\n \ta.id_surat_keluar = '" . $_GET["id"] . "'"; $res = mysql_query($sql); while ($ds = mysql_fetch_array($res)) { $nama_asal = ""; if ($ds["urutan_asal"] == 4) { $nama_asal = " [[ " . $ds["nama_asal"] . " ]]"; } $nama_tujuan = ""; if ($ds["urutan_tujuan"] == 4) { $nama_tujuan = " [[ " . $ds["nama_tujuan"] . " ]]"; } ?> <div style='color:green;font-size:14px;font-family:verdana;'> <?php echo $ds["level_asal"] . $nama_asal; ?> ==> <?php echo $ds["level_tujuan"] . $nama_tujuan; ?> </div> <div class="isilist" style='margin-top:5px;margin-bottom:5px;'> <div><?php if ($ds["catatan"] != "") { echo $ds["catatan"]; } else {