<?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 {
