if ($_POST["perihal_surat"] != "") {
$whr .= " AND a.perihal_surat LIKE '%" . $_POST["perihal_surat"] . "%'";
}
if ($_POST["deskripsi_surat"] != "") {
$whr .= " AND a.deskripsi_surat LIKE '%" . $_POST["deskripsi_surat"] . "%'";
}
if ($_POST["id_skpd_pengirim"] != 0) {
$whr .= " AND a.id_skpd_tujuan = '" . $_POST["id_skpd_pengirim"] . "'";
}
$res = mysql_query("SELECT \n \ta.*, b.unit_kerja,\n CASE\n \t\tWHEN a.no_surat = '' THEN '[[ Belum ditentukan ]]'\n \t\tELSE a.no_surat\n \tEND AS nomor_surat,\n CASE\n \t\tWHEN a.tgl_kirim = '0000-00-00' THEN '[[ Belum ditentukan ]]'\n \t\tELSE\ta.tgl_kirim\n \tEND AS tgl_pengiriman\n FROM \n \tmyapp_maintable_suratkeluar a\n \tLEFT JOIN myapp_reftable_unitkerja b ON a.id_skpd_tujuan = b.id_unit_kerja\n WHERE\n a.id_pengguna_pembuat = '{$_SESSION['id_pengguna']}' " . $whr . "\n ORDER BY \n \tid ASC");
$ctr = 0;
while ($ds = mysql_fetch_array($res)) {
$ctr++;
echo "<tr>";
echo "<td align='center'>" . $ctr . "</td>";
echo "<td align='center'>" . no_register($ds["noreg"]) . "</td>";
echo "<td>" . $ds["nomor_surat"] . "</td>";
echo "<td>" . tglindonesia($ds["tgl_surat"]) . "</td>";
echo "<td>" . tglindonesia($ds["tgl_pengiriman"]) . "</td>";
echo "<td>" . $ds["perihal_surat"] . "</td>";
echo "<td>" . $ds["unit_kerja"] . "</td>";
echo "<td align='center'>";
echo "<img src='image/information_32.png' width='18px' class='linkimage' title='Detail Surat Keluar' onclick='lihat_detail_sk(" . $ds["id"] . ");'>";
echo "</td>";
echo "<td align='center'>";
echo "<img src='image/icon-disposisi.png' width='18px' class='linkimage' title='Daftar catatan disposisi' onclick='lihat_cadis_sk(" . $ds["id"] . ");'>";
echo "</td>";
echo "<td align='center'>";
echo "<img src='image/Attachment-32.png' width='18px' class='linkimage' title='File yang dilampirkan' onclick='lihat_file_sk(" . $ds["id"] . ");'>";
echo "</td>";
echo "<td align='center'>";
</style>
</head>
<body onload="window.print();">
<?php
include "koneksi.php";
include "fungsi.php";
$res_sm = 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_suratmasuk a\n \tLEFT JOIN myapp_reftable_unitkerja b ON a.id_skpd_pengirim = 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='" . $_GET["id"] . "'");
$ds_sm = mysql_fetch_array($res_sm);
for ($i = 1; $i <= $_GET["rangkap"]; $i++) {
?>
<table border="0px" cellspacing='0' cellpadding='0' width='100%'>
<tr>
<td width='15%'>Nomor Register</td>
<td width='10px'>:</td>
<td style="text-transform: uppercase;"><b><?php
echo no_register($ds_sm["noreg"]);
?>
</b></td>
</tr>
<tr>
<td width='15%'>Nomor Surat</td>
<td width='10px'>:</td>
<td style="text-transform: uppercase;"><b><?php
echo $ds_sm["no_surat"];
?>
</b></td>
</tr>
<tr>
<td width='15%'>Tanggal Surat</td>
<td width='10px'>:</td>
<td style="text-transform: uppercase;"><b><?php
