?> </b></td> </tr> <tr> <td width='20%'>Tanggal Terima</td> <td width='10px'>:</td> <td><b><?php echo tglindonesia($ds_sm["tgl_terima"]); ?> </b></td> </tr> <tr> <td width='20%'>Tanggal Selesai</td> <td width='10px'>:</td> <td><b><?php echo tglindonesia($ds_sm["harus_selesai"]); ?> </b></td> </tr> <tr> <td width='20%'>Perihal</td> <td width='10px'>:</td> <td><b><?php echo $ds_sm["perihal_surat"]; ?> </td> </tr> <tr> <td width='20%'>Deskripsi</td> <td width='10px'>:</td> <td><b><?php
<!-- CONTROLLER --> <script type="text/javascript"> <?php $data = array(); $sql_data = "SELECT\n \ta.*, b.pangkat, b.gol_ruang\n FROM\n \ttbl_usulan_pi a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd_usulan = b.id_pangkat\n WHERE\n \ta.kode_skpd LIKE '" . $_SESSION["simpeg_kode_skpd"] . "%'\n ORDER BY\n \ta.id_usulan DESC"; $res_data = mysql_query($sql_data); while ($ds_data = mysql_fetch_array($res_data)) { $row_data["id_usulan"] = $ds_data["id_usulan"]; $row_data["no_usulan"] = $ds_data["no_usulan"]; $row_data["tgl_usulan"] = tglindonesia($ds_data["tgl_usulan"]); $row_data["jabatan_ttd_usulan"] = $ds_data["jabatan_ttd_usulan"]; $row_data["nama_ttd_usulan"] = $ds_data["nama_ttd_usulan"]; $row_data["nip_ttd_usulan"] = $ds_data["nip_ttd_usulan"]; $row_data["status"] = $ds_data["status"]; $row_data["stats"] = status_supervisi($ds_data["status"]); $row_data["pangkat"] = $ds_data["pangkat"]; $row_data["gol_ruang"] = $ds_data["gol_ruang"]; array_push($data, $row_data); } echo "var data = " . json_encode($data) . ";\n"; ?> </script> <!-- END OF CONTROLLER --> <!-- JAVASCRIPT PAGE --> <script type="text/javascript"> function edit(id_usulan){ document.location.href = "?mod=pi_daftar_usulan_edit&id_usulan=" + id_usulan; }
<div class="bodypanel"> <table border="0px" cellspacing='0' cellpadding='0' width='100%' class="listingtable"> <thead> <tr class="headertable"> <th width='40px'>No.</th> <th>Periode</th> <th width='450px'>Pejabat Penilai</th> <th width='450px'>Atasan Pejabat Penilai</th> <th width='20px'> </th> </tr> </thead> <tbody> <?php $res = mysql_query("SELECT\n \ta.*, b.nama_pegawai AS nama_pegawai_penilai, b.nip AS nip_penilai, \n\t c.nama_pegawai AS nama_pegawai_atasan_penilai, c.nip AS nip_atasan_penilai\n FROM\n \ttbl_skp a\n \tLEFT JOIN tbl_pegawai b ON a.id_pegawai_penilai = b.id_pegawai\n \tLEFT JOIN tbl_pegawai c ON a.id_atasan_pegawai_penilai = c.id_pegawai\n LEFT JOIN tbl_skp_perilaku d ON a.id_skp = d.id_skp\n WHERE\n \ta.id_pegawai = '" . $_GET["id_pegawai"] . "' AND (d.status_supervisi = 1 OR d.id_skp IS NULL)\n ORDER BY\n \ta.dari ASC\n "); $no = 0; while ($ds = mysql_fetch_array($res)) { $no++; echo "<tr>"; echo "<td align='center'>" . $no . "</td>"; //echo("<td align='center'>" . $ds["dari"] . "<br/>S/D<br/>" . $ds["dari"] . "</td>"); echo "<td align='center'>" . tglindonesia($ds["dari"]) . " S/D " . tglindonesia($ds["sampai"]) . "</td>"; echo "<td align='center'>" . $ds["nama_pegawai_penilai"] . " (NIP : " . $ds["nip_penilai"] . ")</td>"; echo "<td align='center'>" . $ds["nama_pegawai_atasan_penilai"] . " (NIP : " . $ds["nip_atasan_penilai"] . ")</td>"; echo "<td>\n <img src='image/Text-Signature-32.png' width='18px' class='linkimage' title='Lanjut Untuk Mengisikan Data Hasil Penilaian Perilaku' onclick='lanjut(" . $ds["id_skp"] . ")' />\n </td>"; echo "</tr>"; } ?> </tbody> </table> </div> </div>
echo strtoupper(detail_pegawai($_SESSION["simpeg_id_pegawai"], "nama_pegawai")); ?> (NIP : <?php echo strtoupper(detail_pegawai($_SESSION["simpeg_id_pegawai"], "nip")); ?> )</h3> <div class="bodypanel bodyfilter" id="bodyfilter"> <?php $ds = mysql_fetch_array(mysql_query("SELECT\n\t\t\t\t\t\t\t\t\t\t\t\t\ta.*, b.nama_pegawai AS nama_pegawai_penilai, b.nip AS nip_penilai, \n\t\t\t\t\t\t\t\t\t\t\t\t\tc.nama_pegawai AS nama_pegawai_atasan_penilai, c.nip AS nip_atasan_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\td.pangkat AS pangkat_penilai, d.gol_ruang AS gol_ruang_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\te.pangkat AS pangkat_atasan_penilai, e.gol_ruang AS gol_ruang_atasan_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\tf.skpd AS skpd_penilai, g.skpd AS skpd_atasan_penilai,\n\t\t\t\t\t\t\t\t\t\t\t\t\th.jabatan AS jabatan_penilai, i.jabatan AS jabatan_atasan_penilai\n\t\t\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\t\t\ttbl_skp a\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai_penilai = b.id_pegawai\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_pegawai c ON a.id_atasan_pegawai_penilai = c.id_pegawai\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_pangkat e ON c.id_pangkat = e.id_pangkat\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_skpd f ON b.id_satuan_organisasi = f.id_skpd\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_skpd g ON c.id_satuan_organisasi = g.id_skpd\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_jabatan h ON b.id_jabatan = h.id_jabatan\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN ref_jabatan i ON c.id_jabatan = i.id_jabatan\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\ta.id_skp='" . $_GET["id"] . "'\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t\t\ta.dari ASC\n\t\t\t\t\t\t\t\t\t\t\t\t")); ?> <table border="0px" cellspacing='0' cellpadding='0' width='100%'> <tr> <td width='150px'>Periode</td> <td width='5px'>:</td> <td style="text-transform: uppercase;"><b><?php echo tglindonesia($ds["dari"]) . " S/D " . tglindonesia($ds["sampai"]); ?> </b></td> <td width='150px'> </td> <td width='5px'> </td> <td> </td> </tr> <tr> <td>Pejabat Penilai</td> <td>:</td> <td style="text-transform: uppercase;"> <b> <?php echo $ds["nama_pegawai_penilai"]; ?> <br />
$rnmpri = mysql_fetch_array($nmpri); $dari_nama = $rnmpri["nama"]; $dari_lev = $d1["dari_level"]; $nmpri = mysql_query("select nama_level from tbl_ket_level where id_level='" . $dari_lev . "'"); $rnmpri = mysql_fetch_array($nmpri); $dari_level = $rnmpri["nama_level"]; $tujuan = $d1["tujuan"]; $nmpri = mysql_query("select nama from user where id_user='******'"); $rnmpri = mysql_fetch_array($nmpri); $tujuan_nama = $rnmpri["nama"]; $tujuan_lev = $d1["tujuan_level"]; $nmpri = mysql_query("select nama_level from tbl_ket_level where id_level='" . $tujuan_lev . "'"); $rnmpri = mysql_fetch_array($nmpri); $tujuan_level = $rnmpri["nama_level"]; //$nmpri=mysql_query("select level from user where id_user='******'"); //$rnmpri = mysql_fetch_array($nmpri); //$tujuan_level=$rnmpri["level"]; $pesan = $d1["pesan"]; $atas .= " \n\t\t\t<tr>\n\t\t\t\t<td>" . $i . "</td> \n\t\t\t\t<td>" . tglindonesia($d1["tgl"]) . "</td> \n\t\t\t\t<td>" . $dari_nama . "</td> \n\t\t\t\t<td>" . $tujuan_nama . "</td> \n\t\t\t\t<td>" . $pesan . "</td> \n\t\t\t</tr><br/>\t\n\t\t"; $i++; } $atas .= "</table>"; $html = $atas; // output the HTML content $tes = '<b>hai</b>'; $pdf->writeHTML($html, true, false, true, false, ''); // reset pointer to the last page $pdf->lastPage(); // --------------------------------------------------------- //Close and output PDF document $pdf->Output('print_lembar_disposisi.pdf', 'I');
$("#lihat").click(function(){ jAlert("TEST"); }); }); </script> <!-- CONTROLLER --> <script type="text/javascript"> <?php $data = array(); $sql_data = "SELECT\n \ta.*, b.pangkat, b.gol_ruang\n FROM\n \ttbl_sk_kenpang a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd_sk = b.id_pangkat\n\t\t\t\tWHERE \n\t\t\t\t\ta.status_supervisi = '3'\n ORDER BY\n \ta.id_data DESC"; $res_data = mysql_query($sql_data); while ($ds_data = mysql_fetch_array($res_data)) { $row_data["id_sk"] = $ds_data["id_data"]; $row_data["no_sk"] = $ds_data["no_sk"]; $row_data["tgl_sk"] = tglindonesia($ds_data["tgl_sk"]); $row_data["jabatan_ttd_sk"] = $ds_data["jabatan_ttd_sk"]; $row_data["nama_ttd_sk"] = $ds_data["nama_ttd_sk"]; $row_data["nip_ttd_sk"] = $ds_data["nip_ttd_sk"]; $row_data["status"] = $ds_data["status_supervisi"]; $row_data["stats"] = status_supervisi($ds_data["status_supervisi"]); $row_data["no_usul"] = $ds_data["no_usulan_naik_pangkat"]; $row_data["pangkat"] = $ds_data["pangkat"]; $row_data["gol_ruang"] = $ds_data["gol_ruang"]; $row_data["scan_sk"] = $ds_data["scan_sk"]; array_push($data, $row_data); } echo "var data = " . json_encode($data) . ";\n"; ?> </script> <!-- END OF CONTROLLER -->
</td> </tr> </table> <table border="0px" cellspacing='0' cellpadding='0' width='100%'> <tr> <td> <label>Nomor SK. :</label> <div class="label_caption"><?php echo $ds["no_sk"]; ?> </div> </td> <td width='300px'> <label>Tgl SK. :</label> <div class="label_caption"><?php echo tglindonesia($ds["tgl_sk"]); ?> </div> </td> </tr> </table> <table border="0px" cellspacing='0' cellpadding='0' width='100%'> <tr> <td> <label>Pejabat Penetapan :</label> <div class="label_caption"><?php echo $ds["pejabat_penetapan"]; ?> </div> </td> </tr>
<th colspan="2">AKTIFITAS</th> </tr> <?php if (mysql_num_rows($query) == '') { echo "<tr >\n\t\t\t\t\t\t\t<td colspan='9'>DATA TIDAK DITEMUKAN</td>\n\t\t\t\t\t\t </tr>"; } $i = 1; while ($set = mysql_fetch_array($query)) { $onc = "tampil('" . $set['no_resi'] . "','" . $_SESSION["id_user"] . "')"; $onc1 = "simpan('" . $set['no_resi'] . "','" . $_SESSION["id_user"] . "')"; $no = 0; if ($halaman > 1) { $no = ($halaman - 1) * 20; } echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>", $no + $i, "</td>\n\t\t\t\t\t\t\t\t<td> " . $set['no_resi'] . "</td>"; echo "<td>" . tglindonesia($set['tgl_masuk']) . "</td>"; echo "<td>" . $set['jenis'] . "</td>"; echo "<td>" . $set['nama'] . "</td>"; echo "<td>" . $set['pemohon'] . "</td>"; echo "<td>" . $set['alamat_usaha'] . "</td>"; echo "<td>" . $set['alamat_pemohon'] . "</td>"; echo "\n\t\t\t\t\t\t\t\t<td width='35px'> <input type='button' value='SURAT TUGAS' onClick={$onc1}></td>\n\t\t\t\t\t\t\t\t<td> <input type='button' value='PROSES' onClick={$onc}></td>\n\t\t\t\t\t\t\t\t</tr>"; $i++; echo "\n\t\t\t\t\t<tr id='div_if'>\n\t\t\t\t\t\t<td colspan='10'> <div id='div_cek_" . $set['no_resi'] . "'></div>\n\t\t\t\t\t</tr>\n\t\t\t\t\t"; } ?> </table> </fieldset></div> </td> </tr>
<!-- CONTROLLER --> <?php /* Hasil filter data pegawai */ $pegawai = array(); $sql_pegawai = "SELECT\n \taa.id_lhkpn, aa.no_nhk, aa.tgl_lapor, aa.jenis_form, a.id_pegawai, a.nama_pegawai, a.nip,\n \tb.pangkat, b.gol_ruang,\n \tc.jabatan, d.skpd\n FROM\n \ttbl_pegawai a\n \tLEFT JOIN tbl_lhkpn aa ON a.id_pegawai = aa.id_pegawai\n \tLEFT JOIN ref_pangkat b ON aa.id_pangkat = b.id_pangkat\n \tLEFT JOIN ref_jabatan c ON aa.id_jabatan = c.id_jabatan\n \tLEFT JOIN ref_skpd d ON aa.id_skpd = d.id_skpd\n WHERE\n \taa.id_pegawai = '" . $_GET["id_pegawai"] . "'\n ORDER BY\n \t\taa.id_lhkpn ASC"; //echo($sql_pegawai); $res_pegawai = mysql_query($sql_pegawai) or die(mysql_error()); $no_pegawai = 0; while ($ds_pegawai = mysql_fetch_array($res_pegawai)) { $no_pegawai++; $row_pegawai["no"] = $no_pegawai; $row_pegawai["id_lhkpn"] = $ds_pegawai["id_lhkpn"]; $row_pegawai["no_nhk"] = $ds_pegawai["no_nhk"]; $row_pegawai["tgl_lapor"] = tglindonesia($ds_pegawai["tgl_lapor"]); $row_pegawai["jenis_form"] = $ds_pegawai["jenis_form"]; $row_pegawai["id_pegawai"] = $ds_pegawai["id_pegawai"]; $row_pegawai["nama_pegawai"] = $ds_pegawai["nama_pegawai"]; $row_pegawai["nip"] = $ds_pegawai["nip"]; $row_pegawai["pangkat"] = $ds_pegawai["pangkat"]; $row_pegawai["gol_ruang"] = $ds_pegawai["gol_ruang"]; $row_pegawai["jabatan"] = $ds_pegawai["jabatan"]; $row_pegawai["skpd"] = $ds_pegawai["skpd"]; array_push($pegawai, $row_pegawai); } ?> <script type="text/javascript"> var pegawai = <?php echo json_encode($pegawai); ?>
<tr> <td>JENIS KELAMIN</td> <td> : </td> <td> <span><b><?php echo $ds["jenis_kelamin"] == "" ? "-" : $ds["jenis_kelamin"]; ?> </b></span> </td> </tr> <tr> <td>TEMPAT / TANGGAL LAHIR</td> <td> : </td> <td> <span><b><?php echo $ds["tempat_lahir"] . ", " . tglindonesia($ds["tanggal_lahir"]); ?> </b></span> </td> </tr><br/> <tr> <td colspan="3"><center><span>|<a href="?mod=ganti_password"> GANTI PASSWORD AKUN </a>|</span></center></td> </tr> </table> </div> </div> </div> </td> </tr> <tr>
ob_start(); session_start(); require_once "../php/dompdf_config.inc.php"; require_once "../php/koneksi.php"; require_once "../php/fungsi.php"; date_default_timezone_set("America/New_York"); ?> <?php $html = ""; $html .= "<html>"; $html .= "<head>"; $html .= "</head>"; $html .= "<body>"; $html .= "<h3 style='text-align: center;'>REKAP KEGIATAN VERIFIKASI UPLOAD PER TANGGAL " . tglindonesia($_POST["dari"]) . " SAMPAI " . tglindonesia($_POST["sampai"]) . "</h3>"; $html .= "<table width='100%' border='1px' cellspacing='0' cellpadding='5' style='border-collapse: collapse; font-family: sans-serif; font-size: 9pt;'>"; $html .= "<thead>"; $html .= "<tr>"; $html .= "<th width='40px'>NO.</th>"; $html .= "<th>NAMA PENGGUNA</th>"; $html .= "<th width='20%'>TOTAL</th>"; $html .= "</tr>"; $html .= "</thead>"; $html .= "<tbody>"; $no = 0; $sql = "SELECT\n \ta.nama, a.id_user,\n \tCASE\n \t\tWHEN rekap.jumlah IS NOT NULL THEN rekap.jumlah\n \t\tELSE 0\n \tEND AS jumlah\n FROM\n \ttbl_pengguna a\n \tLEFT JOIN (\n \t\tSELECT\n \t\t\tid_pemeriksa, COUNT(*) AS jumlah\n \t\tFROM\n \t\t\ttbl_skp_dp3_upload_pemeriksaan\n \t\tWHERE\n \t\t\ttgl_periksa BETWEEN '" . $_POST["dari"] . " 00:00:00' AND '" . $_POST["sampai"] . " 23:59:59'\n \t\tGROUP BY\n \t\t\tid_pemeriksa\n \t) rekap ON a.id_user = rekap.id_pemeriksa\n WHERE\n \ta.modul = 12 OR a.modul = 14"; $res = mysql_query($sql); while ($ds = mysql_fetch_array($res)) { $no++; $html .= "<tr>";
* $html .= "</tr>"; * $html .= "<tr>"; * $html .= "<td style='border: solid 1px #CCC;'>Unit Kerja</td>"; * $html .= "<td style='border: solid 1px #CCC;'>:</td>"; * $html .= "<td style='border: solid 1px #CCC;'>" . $ds_header["skpd_penilai"] . "</td>"; * * $html .= "<td style='border: solid 1px #CCC;'>Unit Kerja</td>"; * $html .= "<td style='border: solid 1px #CCC;'>:</td>"; * $html .= "<td style='border: solid 1px #CCC;'>" . $ds_header["skpd_atasan_penilai"] . "</td>"; * $html .= "</tr>"; * $html .= "</table>"; */ $html .= "<div style='height: 10px;'></div>"; $html .= "<table width='100%' cellspacing='0' cellpadding='5' border='0px' style='font-family: sans-serif; font-size: 10pt;'>"; $html .= "<tr>"; $html .= "<td><b>Periode Penilaian : " . tglindonesia($ds_header["dari"]) . " S/D " . tglindonesia($ds_header["sampai"]) . "</b></td>"; $html .= "</tr>"; $html .= "</table>"; $html .= "<table width='100%' cellspacing='0' cellpadding='5' border='0px' style='font-family: sans-serif; font-size: 9.5pt;'>"; $html .= "<thead>"; $html .= "<tr>"; $html .= "<td rowspan='2' width='3%' style='text-align: center; border: solid 1px #000000;'>NO.</td>"; $html .= "<td rowspan='2' width='20%' style='text-align: center; border: solid 1px #000000;'>I. KEGIATAN TUGAS JABATAN</td>"; $html .= "<td rowspan='2' width='5%' style='text-align: center; border: solid 1px #000000;'>AK</td>"; $html .= "<td colspan='4' style='text-align: center; border: solid 1px #000000;'>TARGET</td>"; $html .= "<td rowspan='2' width='5%' style='text-align: center; border: solid 1px #000000;'>AK</td>"; $html .= "<td colspan='4' style='text-align: center; border: solid 1px #000000;'>REALISASI</td>"; $html .= "<td rowspan='2' width='7%' style='text-align: center; border: solid 1px #000000;'>PENG<br/>HITUNGAN</td>"; $html .= "<td rowspan='2' width='8%' style='text-align: center; border: solid 1px #000000;'>CAPAIAN</td>"; $html .= "</tr>"; $html .= "<tr>";
<?php include "../php/koneksi.php"; include "../php/fungsi.php"; $id_usulan = mysql_real_escape_string($_GET['id_usulan']); $no_usul = getNoUsulFromUsulanCuti($id_usulan); $sql = "SELECT * FROM tbl_usulan_cuti WHERE id_usulan = '" . $id_usulan . "'"; $query = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_array($query); echo "<table border='0' cellspacing='4' cellpadding='4' style='font-size:12px;'>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NO USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $no_usul . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>TGL USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . tglindonesia($row['tgl_usulan']) . "</td>\t\n\t\t\t</tr>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>PEJABATAN PENANDATANGAN USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['pejabat_usulan'] . "</td>\t\n\t\t\t</tr>\n\t\t</table><br/>\t\t\n\t"; echo "<center><span style='font-size:14px; font-weight:bold;' >DAFTAR NAMA PEGAWAI YANG DIUSULKAN</span></center>"; echo "<center><table border='1' cellspacing='4' cellpadding='4' style='font-size:12px;'>"; echo "\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'><center>No</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>NIP Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold; width='100px;'><center>Nama Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='120px;'><center>Pangkat (Gol.Ruang)</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='100px;'><center>Unit Kerja/SKPD</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='80px;'><center>Lama Cuti (hari)</center></td>\n\t\t\t\t<td style='font-weight:bold;' width='100px;'><center>Jenis Cuti</center></td>\n\t\t\t</tr>\n\t"; $no = 1; echo "<tbody>"; // hardcode cuy untuk string sql kedua $ql = "SELECT \n\t\t\t\ta.*, b.nip, b.nama_pegawai, c.skpd, d.pangkat, d.gol_ruang, e.jenis_cuti\n\t\t\tFROM\n\t\t\t\ttbl_usulan_cuti a\n\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n\t\t\t\tLEFT JOIN ref_skpd c ON b.id_satuan_organisasi = c.id_skpd\n\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\tLEFT JOIN ref_jenis_cuti e ON a.id_jenis_cuti = e.id_jenis_cuti\n\t\t\tWHERE\n\t\t\t\ta.no_usulan = '" . $no_usul . "' AND a.diproses = '0' \n\t\t\tORDER BY\n\t\t\t b.nama_pegawai ASC\n\t\t "; $qr = mysql_query($ql) or die(mysql_error()); while ($data = mysql_fetch_array($qr)) { // normalisasi data $skpd = $data['skpd'] == '' ? '-' : $data['skpd']; $panggol = $data['pangkat'] == '' && $data['gol_ruang'] == '' ? '-' : $data['pangkat'] . " (" . $data['gol_ruang'] . ") "; $nnip = $data['nip'] == '' ? 'NIHIL' : $data['nip']; $fullname = $data['nama_pegawai'] == '' ? 'NIHIL' : $data['nama_pegawai']; echo "<tr>\n\t\t\t<td><center>" . $no . "</center></td>\n\t\t\t<td><center>" . $nnip . "</center></td>\n\t\t\t<td><center>" . $fullname . "</center></td>\n\t\t\t<td><center>" . $panggol . "</center></td>\n\t\t\t<td><center>" . $skpd . "</center></td>\n\t\t\t<td><center>" . $data['lama'] . "</center></td>\n\t\t\t<td><center>" . $data['jenis_cuti'] . "</center></td>\n\t\t</tr>"; $no++; } echo "</tbody>"; echo "</table></center>"; // tutup koneksi mysql_close();
$res = $con->query($sql); $ctr = 0; $res->data_seek(0); while ($ds = $res->fetch_assoc()) { $nosur = explode("/", $ds["no_surat"]); $ctr++; echo "<tr>"; $kondisi = "belumdibaca"; if ($ds["kondisi"] == 2) { $kondisi = "telahdibaca"; } echo "<td align='center'>" . $ctr . "</td>"; echo "<td align='center'>" . no_register($ds["id"]) . "</td>"; echo "<td>" . $ds["no_surat"] . "</td>"; echo "<td>" . tglindonesia($ds["tgl_surat"]) . "</td>"; echo "<td>" . tglindonesia($ds["tgl_kirim"]) . "</td>"; echo "<td>" . $ds["perihal_surat"] . "</td>"; echo "<td>" . $ds["unit_kerja"] . "</td>"; echo "<td>" . $ds["asal"] . "</td>"; echo "<td>" . konversiKeadaanSK($ds["keadaan"]) . "</td>"; echo "<td align='center'>"; echo "<img src='image/Info-32.png' width='18px' class='linkimage' title='Detail Surat Keluar' onclick='lihat_detail_sk(" . $ds["id"] . ", " . $ds["id_disposisi"] . ");'>"; 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"] . ", " . $ds["id_disposisi"] . ");'>"; echo "</td>"; echo "<td align='center'>"; echo "<a href='./?mod=file_final_surat_keluar&id=" . $ds["id"] . "' id='uploadBerkas_" . $ds["id"] . "'>\n\t\t\t\t\t\t\t<img src='image/upload.png' width='18px' class='linkimage' title='Upload File Final' ></a>"; 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"] . ", " . $ds["id_disposisi"] . ");'>";
<?php include "../php/koneksi.php"; include "../php/fungsi.php"; $id_usulan = mysql_real_escape_string($_GET['id_usulan']); //$no_usulan = get_no_usulan_pangkat($id_usulan); $sql = "SELECT \n\t\t\t\ta.*,d.pangkat, d.gol_ruang\n\t\t\tFROM\n\t\t\t\ttbl_usulan_pangkat a\n\t\t\t\tLEFT JOIN ref_pangkat d ON a.id_pangkat_ttd = d.id_pangkat\n\t\t\tWHERE\n\t\t\t\ta.id_usulan = '" . $id_usulan . "'\n\t\t "; $query = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_array($query); $tgl_usul = $row['tgl_usulan'] == "" ? "-" : $row['tgl_usulan']; echo "<table border='0' cellspacing='4' cellpadding='4' style='font-size:12px;'>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NO USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['no_usulan'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>TGL USULAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . tglindonesia($tgl_usul) . "</td>\t\n\t\t\t</tr>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NAMA PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['nama_pejabat_ttd'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NIP PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['nip_pejabat_ttd'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>PANGKAT PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['pangkat'] . " ( " . $row['gol_ruang'] . " )</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>JABATAN PEJABAT PENGUSUL </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['jabatan_ttd'] . "</td>\t\n\t\t\t</tr>\n\t\t</table><br/>\t\t\n\t"; echo "<center><span style='font-size:14px; font-weight:bold;' >DAFTAR NAMA PEGAWAI YANG DIUSULKAN</span></center>"; echo "<table border='1' cellspacing='4' cellpadding='4' style='font-size:12px;'>"; echo "\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'><center>No</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>NIP Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Nama Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Unit Kerja/SKPD</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Pangkat Lama</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Pangkat Baru</center></td>\n\t\t\t</tr>\n\t"; $no = 1; echo "<tbody>"; // hardcode cuy untuk string sql kedua $ql = "SELECT \n\t\t\t\ta.id_pegawai, b.nip, b.nama_pegawai, c.skpd, d.pangkat, d.gol_ruang ,\n\t\t\t\te.pangkat as 'PANGKAT_BARU', e.gol_ruang as 'GOLBAR'\n\t\t\tFROM\n\t\t\t\ttbl_detail_usulan_pangkat a\n\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n\t\t\t\tLEFT JOIN ref_skpd c ON b.id_satuan_organisasi = c.id_skpd\n\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\tLEFT JOIN ref_pangkat e ON a.id_pangkat_baru = e.id_pangkat\n\t\t\tWHERE\n\t\t\t\ta.id_usulan = '" . $id_usulan . "'\n\t\t\tORDER BY\n\t\t\t b.nama_pegawai ASC\n\t\t "; $qr = mysql_query($ql); while ($data = mysql_fetch_array($qr)) { // normalisasi data $skpd = $data['skpd'] == '' ? '-' : $data['skpd']; $panggol = $data['pangkat'] == '' && $data['gol_ruang'] == '' ? '-' : $data['pangkat'] . " (" . $data['gol_ruang'] . ") "; $nnip = $data['nip'] == '' ? 'NIHIL' : $data['nip']; $fullname = $data['nama_pegawai'] == '' ? 'NIHIL' : $data['nama_pegawai']; $p_baru = $data['PANGKAT_BARU'] == '' && $data['GOLBAR'] == '' ? '-' : $data['PANGKAT_BARU'] . " (" . $data['GOLBAR'] . ") "; echo "<tr>\n\t\t\t<td><center> " . $no . " </center></td>\n\t\t\t<td><center> " . $nnip . " </center></td>\n\t\t\t<td><center> " . $fullname . " </center></td>\n\t\t\t<td><center> " . $skpd . " </center></td>\n\t\t\t<td><center> " . $panggol . " </center></td>\n\t\t\t<td><center> " . $p_baru . " </center></td>\n\t\t</tr>"; $no++; } echo "</tbody>"; echo "</table>";
<th width='200px'>TMT</th> <th width='200px'>No. SK</th> <th width='200px'>Tanggal SK</th> <th>Pejabat Penetapan</th> <th width='20px'> </th> <th width='20px'> </th> </tr> </thead> <tbody> <?php $res = mysql_query("SELECT\n \ta.*, b.pangkat, b.gol_ruang, MD5(a.id_riwayat_pangkat) AS id_hash\n FROM\n \ttbl_riwayat_pangkat a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat = b.id_pangkat\n WHERE\n \ta.id_pegawai='" . $_SESSION["simpeg_id_pegawai"] . "'\n ORDER BY\n \ta.tmt ASC"); $no = 0; while ($ds = mysql_fetch_array($res)) { $no++; echo "<tr>"; echo "<td align='center'>" . $no . "</td>"; echo "<td align='center'>" . $ds["pangkat"] . "</td>"; echo "<td align='center'>" . $ds["gol_ruang"] . "</td>"; echo "<td align='center'>" . tglindonesia($ds["tmt"]) . "</td>"; echo "<td align='center'>" . $ds["no_sk"] . "</td>"; echo "<td align='center'>" . tglindonesia($ds["tgl_sk"]) . "</td>"; echo "<td align='center'>" . $ds["pejabat_penetapan"] . "</td>"; echo "<td>\n <img src='image/Edit-32.png' width='18px' class='linkimage' title='Edit' onclick='edit(\"" . $ds["id_hash"] . "\");' />\n </td>"; echo "<td>\n <img src='image/Delete-32.png' width='18px' class='linkimage' title='Hapus' onclick='hapus(" . $ds["id_riwayat_pangkat"] . ");' />\n </td>"; echo "</tr>"; } ?> </tbody> </table> </div> </div>
<tr> <td> <div id='content' style='padding-top:10px;'> <br> <div class="panelcontainer" style="width: 100%;"> <h3 style="text-align: left;">Daftar Ucapan Ulang Tahun Masuk Buat <?php echo $username; ?> </h3> <div class="bodypanel"> <?php $sql = "SELECT a.* , b.nama_pegawai as 'dari' \n\t\t\t\t\t\n\t\t\t\t\t\t\tFROM tbl_ucapan_ultah_pegawai a\n\t\t\t\t\t\t\tLEFT JOIN tbl_pegawai b ON a.dari = b.id_pegawai\n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\ta.tujuan = '" . $_SESSION['id_pegawai'] . "' \n\t\t\t\t\t\t\t\tORDER BY tgl_post DESC"; $res = mysql_query($sql); $no = 1; while ($ds = mysql_fetch_array($res)) { echo "<div class='judul_berita'>Ucapan ke - " . $no . "</div>"; echo "<div class='tgl_berita'>Dikirim oleh " . ($ds["dari"] == "" ? "Admin Simpeg /SKPD" : $ds["dari"]) . " pada : " . tglindonesia($ds["tgl_submit"]) . "</div>"; echo "<div class='intro_berita'>" . $ds["pesan"] . "</div>"; echo "<div class='kelang_border'></div><br/>"; $no++; } ?> </div> </div> </div> </td> </tr> <tr> <td><br><div id='footer'></div></td> </tr> </table>
<?php include "../php/koneksi.php"; include "../php/fungsi.php"; $id_data = mysql_real_escape_string($_GET['id_data']); $nip = get_nip_riwayat_pendidikan($id_data); $sql = "SELECT\n a.id_data_rp as 'id_data', a.nip, b.nama_pegawai, c.tingkat_pendidikan , a.tempat_pendidikan, \n a.k_a_tempat_pendidikan as 'kepala' ,a.nilai, a.no_ijazah, a.tgl_ijazah\n FROM\n \ttbl_riwayat_pendidikan a\n \tLEFT JOIN tbl_pegawai b ON a.nip = b.nip\n \tLEFT JOIN ref_tingkat_pendidikan c ON a.id_tingkat_pendidikan = c.id_tingkat_pendidikan\n WHERE\n \ta.nip = '" . $nip . "' \n ORDER BY\n \tc.id_tingkat_pendidikan ASC\n "; $res = mysql_query($sql); echo "<div class='judullist'>Daftar Riwayat Pendidikan " . detail_pegawai_by_nip($nip, "nama_pegawai") . " (NIP : " . $nip . ")</div><br/>"; echo "<table border='1' cellspacing='0' cellpadding='3'>"; echo "<tr>\n\t\t\t <td><center><b>No</center></b></td>\n\t\t\t <td><center><b>Tingkat Pendidikan</center></b></td>\t\n\t\t\t <td><center><b>Tempat Pendidikan</center></b></td>\n\t\t\t <td><center><b>Nama Kepala Tempat Pendidikan</center></b></td>\n\t\t\t <td><center><b>Nilai/Index</center></b></td>\n\t\t\t <td><center><b>No. Ijazah</center></b></td>\n\t\t\t <td width='100px;'><center><b>Tgl. Ijazah</center></b></td>\n\t\t </tr>\t\n\t"; $no = 1; while ($row = mysql_fetch_array($res)) { echo "<tr>\n\t\t\t <td><center>" . $no . "</center></td>\n\t\t\t <td><center>" . $row['tingkat_pendidikan'] . "</center></td>\t\n\t\t\t <td><center>" . $row['tempat_pendidikan'] . "</center></td>\n\t\t\t <td><center>" . ($row['kepala'] == "" ? "-" : $row['kepala']) . "</center></td>\n\t\t\t <td><center>" . $row['nilai'] . "</center></td>\n\t\t\t <td><center>" . $row['no_ijazah'] . "</center></td>\n\t\t\t <td><center>" . tglindonesia($row['tgl_ijazah']) . "</center></td>\n\t\t </tr>\t\n\t\t"; $no++; } echo "</table>";
<!-- CONTROLLER --> <script type="text/javascript"> <?php $list_norut = array(); $sql_list_norut = "SELECT * FROM tbl_usulan_cuti WHERE diproses = '0' ORDER BY id_usulan ASC"; $res_list_norut = mysql_query($sql_list_norut); $nomor = 0; while ($ds_list_norut = mysql_fetch_array($res_list_norut)) { $nomor++; $row_norut["nomor"] = $nomor; $row_norut["id_usulan"] = $ds_list_norut["id_usulan"]; $row_norut["no_usulan"] = $ds_list_norut["no_usulan"]; $row_norut["tgl_usulan"] = tglindonesia($ds_list_norut["tgl_usulan"]); $row_norut["pejabat_usulan"] = $ds_list_norut["pejabat_usulan"]; array_push($list_norut, $row_norut); } echo "var usulan = " . json_encode($list_norut) . ";"; ?> </script> <!-- END OF CONTROLLER --> <!-- JAVASCRIPT PAGE --> <script type="text/javascript"> function edit_pegawai(no_usulan){ document.location.href="?mod=cuti_daftar_usulan_edit&no_usulan=" + no_usulan; } function acc(id_usulan){ jConfirm("Anda yakin akan memproses data usulan ini ?", "PERHATIAN", function(r){ if(r){ document.location.href="?mod=acc_usulan_cuti&id_usulan=" + id_usulan;
<!-- CONTROLLER --> <script type="text/javascript"> <?php $daftar = array(); $sql_daftar = "SELECT\n \ti.id_cerai, i.no_sp, i.tgl_sp, a.nama_pegawai, a.nip, g.pangkat, g.gol_ruang, h.jabatan, f.skpd,\n i.status\n FROM\n \ttbl_pegawai a\n \tLEFT JOIN ref_status_kepegawaian b ON a.id_status_kepegawaian = b.id_status_kepegawaian\n \tLEFT JOIN ref_jenis_kepegawaian c ON a.id_jenis_kepegawaian = c.id_jenis_kepegawaian\n \tLEFT JOIN ref_kedudukan_kepegawaian d ON a.id_kedudukan_kepegawaian = d.id_kedudukan_kepegawaian\n \tLEFT JOIN ref_jenis_kelamin e ON a.id_jenis_kelamin = e.id_jenis_kelamin\n \tLEFT JOIN ref_skpd f ON a.id_satuan_organisasi = f.id_skpd\n \tLEFT JOIN ref_pangkat g ON a.id_pangkat = g.id_pangkat\n \tLEFT JOIN ref_jabatan h ON a.id_jabatan = h.id_jabatan\n \tINNER JOIN tbl_ijin_cerai i ON a.id_pegawai = i.id_pegawai\n WHERE\n \t(a.id_status_kepegawaian = 1 OR a.id_status_kepegawaian = 4 OR a.id_status_kepegawaian = 3)\n \tAND f.kode_skpd LIKE '" . $_SESSION["simpeg_kode_skpd"] . "%'\n ORDER BY\n \ti.id_cerai DESC"; $res_daftar = mysql_query($sql_daftar); while ($ds_daftar = mysql_fetch_array($res_daftar)) { $row_daftar["id_cerai"] = $ds_daftar["id_cerai"]; $row_daftar["no_sp"] = $ds_daftar["no_sp"]; $row_daftar["tgl_sp"] = tglindonesia($ds_daftar["tgl_sp"]); $row_daftar["nama_pegawai"] = $ds_daftar["nama_pegawai"]; $row_daftar["nip"] = $ds_daftar["nip"]; $row_daftar["pangkat"] = $ds_daftar["pangkat"]; $row_daftar["gol_ruang"] = $ds_daftar["gol_ruang"]; $row_daftar["jabatan"] = $ds_daftar["jabatan"]; $row_daftar["skpd"] = $ds_daftar["skpd"]; $row_daftar["status"] = $ds_daftar["status"]; array_push($daftar, $row_daftar); } echo "var daftar = " . json_encode($daftar) . ";\n"; ?> </script> <!-- END OF CONTROLLER --> <!-- JAVASCRIPT PAGE --> <script type="text/javascript"> function edit(id_cerai){ document.location.href="?mod=cerai_daftar_usulan_edit&id_cerai=" + id_cerai; }
<br> </td> </tr> <tr> <td> <div id='content' style='padding-top:10px;'> <br> <div class="panelcontainer" style="width: 100%;"> <h3 style="text-align: left;">BERITA DAN INFORMASI</h3> <div class="bodypanel"> <?php $sql = "SELECT * FROM tbl_berita_informasi ORDER BY id_berita_informasi DESC"; $res = mysql_query($sql); while ($ds = mysql_fetch_array($res)) { echo "<div class='judul_berita'>" . $ds["judul"] . "</div>"; echo "<div class='tgl_berita'>Dipost pada : " . tglindonesia($ds["tgl_post"]) . "</div>"; echo "<div class='intro_berita'>" . $ds["intro"] . "</div>"; echo "<div class='selengkapnya_berita'><a href='?mod=berita_dan_informasi_detail&id_berita_informasi=" . $ds["id_berita_informasi"] . "'>Berita Selengkapnya</a></div>"; echo "<div class='kelang_border'></div>"; } ?> </div> </div> </div> </td> </tr> <tr> <td><br><div id='footer'></div></td> </tr> </table>
} $res = mysql_query("SELECT \n \ta.*, b.unit_kerja, c.status AS kondisi, d.level AS asal, c.id AS id_disposisi,\n c.keadaan, e.id_surat_masuk\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_disptable_suratkeluar c ON a.id = c.id_surat_keluar\n \tLEFT JOIN myapp_reftable_levelpengguna d ON c.id_level_asal = d.id\n LEFT JOIN myapp_maintable_balasan e ON a.id = e.id_surat_keluar\n WHERE\n \tc.id_level_tujuan = '" . $_SESSION["id_level"] . "' AND c.status < 3 " . $whr . "\n GROUP BY\n a.id\n ORDER BY \n \tid ASC"); $ctr = 0; while ($ds = mysql_fetch_array($res)) { $ctr++; echo "<tr>"; $kondisi = "belumdibaca"; if ($ds["kondisi"] == 2) { $kondisi = "telahdibaca"; } echo "<td align='center'><div class='lampu " . $kondisi . "' id='kondisi_" . $ds["id"] . "'> </div></td>"; echo "<td align='center'>" . $ctr . "</td>"; echo "<td align='center'>" . no_register($ds["id"]) . "</td>"; echo "<td>" . $ds["no_surat"] . "</td>"; echo "<td>" . tglindonesia($ds["tgl_surat"]) . "</td>"; echo "<td>" . tglindonesia($ds["tgl_terima"]) . "</td>"; echo "<td>" . $ds["perihal_surat"] . "</td>"; echo "<td>" . $ds["unit_kerja"] . "</td>"; echo "<td>" . $ds["asal"] . "</td>"; echo "<td>" . konversiKeadaanSK($ds["keadaan"]) . "</td>"; echo "<td align='center'>"; echo "<img src='image/mail_replay-48.png' width='18px' class='linkimage' title='Data Surat Masuk Yang Dibalas' onclick='lihat_data_yg_dibalas(" . $ds["id_surat_masuk"] . ", " . $ds["id_disposisi"] . ");'>"; echo "</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"] . ", " . $ds["id_disposisi"] . ");'>"; 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"] . ", " . $ds["id_disposisi"] . ");'>"; 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"] . ", " . $ds["id_disposisi"] . ");'>";
<?php session_start(); include "../php/koneksi.php"; include "../php/fungsi.php"; $res = mysql_query("SELECT\n \tb.nip AS nip_asal, b.nama_pegawai AS nama_asal,\n \tc.catatan, c.tgl_catatan\n FROM\n \ttbl_riwayat_pangkat a\n \tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n \tLEFT JOIN catatan_riwayat_pangkat c ON a.id_data = c.id_riwayat_pangkat\n WHERE\n \tc.id_riwayat_pangkat = '" . $_GET['id_riwayat_pangkat'] . "' \n ORDER BY\n \ta.id_data ASC\n ") or die(mysql_error()); while ($ds = mysql_fetch_array($res)) { echo "<div class='judullist'>" . $ds["nama_asal"] . " (NIP : " . $ds["nip_asal"] . "),<br/> Tanggal Supervisi : \n\t\t " . tglindonesia($ds["tgl_catatan"]) . "</div>"; echo "<div class='isilist'>"; echo "<div>" . $ds["catatan"] . "</div>"; echo "</div>"; }
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'>"; echo "<img src='image/Edit-32.png' width='15px' class='linkimage' title='Edit' onclick='edit(" . $ds["id"] . ");'>"; echo "</td>"; echo "<td align='center'>";
echo "<table border='0' cellspacing='0' cellpadding='3' width='50%'>\n\t<tr>\n\t\t \n\t</tr>\n</table>\n<table border='0' cellspacing='0' cellpadding='3' width='50%' style='font-size:14px; font-weight:bold;float:right;margin-bottom:15px;'>\n\t<tr>\n\t\t<td>DAFTAR</td>\n\t\t<td> : </td>\n\t\t<td>LAMPIRAN KEPUTUSAN WALIKOTA MEDAN</td>\n\t</tr>\n\t<tr>\n\t\t<td>NOMOR</td>\n\t\t<td> : </td>\n\t\t<td>" . $row['no_sk'] . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>TANGGAL</td>\n\t\t<td> : </td>\n\t\t<td>" . tglindonesia($row['tgl_surat']) . "</td>\n\t</tr>\n</table>\n\n<table border='1' cellspacing='0' cellpadding='2' width='100%'>\n\t<tr>\n\t\t<td rowspan='2'><center>No.</center></td>\n\t\t<td rowspan='2'><center>Persetujuan Kepala Kantor Reg. VI BKN</center></td>\n\t\t<td rowspan='2'><center>Nama, Tempat dan Tanggal Lahir</center></td>\n\t\t<td rowspan='2'><center>NIP</center></td>\n\t\t<td rowspan='2'><center>Pangkat/Gol.Ruang dan TMT</center></td>\n\t\t<td colspan='2'><center>MK Gol Lama</center></td>\n\t\t<td rowspan='2'><center>Gaji Pokok Lama (Rp.)</center></td>\n\t\t<td rowspan='2'><center>Pengalaman Bekerja</center></td>\n\t\t<td colspan='2'><center>Penambahan Masa Kerja</center></td>\n\t\t<td colspan='2'><center>MK Gol Baru</center></td>\n\t\t<td rowspan='2'><center>Gaji Pokok Baru (Rp.)</center></td>\n\t\t<td rowspan='2'><center>Unit Kerja</center></td>\n\t\t<td rowspan='2'><center>TMT</center></td>\n\t</tr>\n\t<tr>\n\t\t<td>Thn</td>\n\t\t<td>Bln</td>\n\t\t<td>Thn</td>\n\t\t<td>Bln</td>\n\t\t<td>Thn</td>\n\t\t<td>Bln</td>\n\t</tr>\n\t<tr>\n\t\t<td><center>1</center></td>\n\t\t<td><center>2</center></td>\n\t\t<td><center>3</center></td>\n\t\t<td><center>4</center></td>\n\t\t<td><center>5</center></td>\n\t\t<td><center>6</center></td>\n\t\t<td><center>7</center></td>\n\t\t<td><center>8</center></td>\n\t\t<td><center>9</center></td>\n\t\t<td><center>10</center></td>\n\t\t<td><center>11</center></td>\n\t\t<td><center>12</center></td>\n\t\t<td><center>13</center></td>\n\t\t<td><center>14</center></td>\n\t\t<td><center>15</center></td>\n\t\t<td><center>16</center></td>\n\t</tr>"; $q = "SELECT \n\t\t\t\ta.*, b.*, c.nama_pegawai, c.nip, c.tempat_lahir, c.tanggal_lahir,\n\t\t\t\tc.gelar_depan, c.gelar_belakang, d.skpd, e.pangkat, e.gol_ruang, f.*, g.gapok, g.terbilang \n\t\t\t\tFROM \n\t\t\t\t\ttbl_sk_pmk a\n\t\t\t\t\tLEFT JOIN tbl_sk_pmk_detail b ON a.id_surat = b.id_sk\n\t\t\t\t\tLEFT JOIN tbl_pegawai c ON b.id_pegawai = c.id_pegawai\n\t\t\t\t\tLEFT JOIN ref_skpd d ON c.id_satuan_organisasi = d.id_skpd\n\t\t\t\t\tLEFT JOIN ref_pangkat e ON c.id_pangkat = e.id_pangkat\n\t\t\t\t\tLEFT JOIN tbl_detail_usul_pmk f ON c.nip = f.nip\n\t\t\t\t\tLEFT JOIN ref_gapok g ON (c.id_pangkat = g.id_pangkat AND g.mkg = (SELECT MAX(mkg) FROM ref_gapok WHERE id_pangkat = 1))\n\t\t\t\tWHERE\n\t\t\t\t\ta.id_surat = '" . $id_surat . "' \n\t\t\t\tORDER BY\n\t\t\t\t\tc.nama_pegawai ASC"; $ex = mysql_query($q) or die(mysql_error()); $no = 1; while ($data = mysql_fetch_array($ex)) { $gd = $data['gelar_depan'] == "" ? " " : $data['gelar_depan'] . " "; $gb = $data['gelar_belakang'] == "" ? " " : " " . $data['gelar_belakang']; $nama = $data['nama_pegawai'] == "" ? "-" : $data['nama_pegawai']; $fullname = $gd . $nama . $gb; $p = $data['pangkat'] . "(" . $data['gol_ruang'] . ")"; echo "<tr>"; echo "<td><center>" . $no . "</center></td>"; echo "<td><center>" . $data['no_persetujuan'] . "</center></td>"; echo "<td><center>" . $fullname . "<br/>" . $data['tempat_lahir'] . "<br/>" . tglindonesia($data['tanggal_lahir']) . "</center></td>"; echo "<td><center>" . $data['nip'] . "</center></td>"; echo "<td><center>" . $p . "<br/>" . tglindonesia($data['tmt']) . "</center></td>"; echo "<td><center>-</center></td>"; echo "<td><center>-</center></td>"; echo "<td><center>" . $data['gapok'] . "</center></td>"; echo "<td><center>" . $data['pengalaman'] . "</center></td>"; echo "<td><center>" . $data['tambah_mk_tahun'] . "</center></td>"; echo "<td><center>" . $data['tambah_mk_bulan'] . "</center></td>"; echo "<td><center>-</center></td>"; echo "<td><center>-</center></td>"; echo "<td><center>-</center></td>"; echo "<td><center>" . $data['skpd'] . "</center></td>"; echo "<td><center>" . tglindonesia($data['tmt']) . "</center></td>"; echo "</tr>"; $no++; } echo "</table>";
$html .= "<tr>"; $html .= "<td style='border: solid 1px #000000;' colspan='4' align='left'>\n <div style='text-align:right;'><b>11. DITERIMA TANGGAL, </b></div>\n <div style='text-align:right;'><b>ATASAN PEJABAT YANG MENILAI</b></div>\n <div style='text-align:right; height:100px;'></div>\n <div style='text-align:right;'>(" . $gelar_depan_atasan_penilai . $ds_header["nama_pegawai_atasan_penilai"] . $gelar_belakang_atasan_penilai . ")</div>\n <div style='text-align:right;'>NIP : " . $ds_header["nip_atasan_penilai"] . "</div>\n </td>"; $html .= "</tr>"; $html .= "</table>"; // AKHIR ISI KIRI $html .= "</td>"; $html .= "<td width='50%' valign='top'>"; // ISI KANAN $html .= "<div style='text-align: center;'>"; $html .= "<img src='../image/garuda.png' width='70px' style='border: solid 0px black;' />"; $html .= "</div>"; $html .= "<div style='text-align: center'><h3>PENILAIAN PRESTASI KERJA<br />PEGAWAI NEGERI SIPIL</h3></div>"; $html .= "<table width='100%' cellspacing='0' cellpadding='5' border='0px' style='font-family: sans-serif; font-size: 9pt;'>"; $html .= "<tr>"; $html .= "<td width='50%' align='left'>" . strtoupper($ds_header["skpd"]) . "</td>"; $html .= "<td width='50%' align='right'>JANGKA WAKTU PENILAIAN<br />" . tglindonesia($ds_header["dari"]) . " S/D " . tglindonesia($ds_header["sampai"]) . "</td>"; $html .= "</tr>"; $html .= "</table>"; $html .= "<table width='100%' cellspacing='0' cellpadding='5' border='0px' style='font-family: sans-serif; font-size: 9pt;'>"; $html .= "<tr>"; $html .= "<td width='5%' style='border: solid 1px #000000;' align='center' rowspan='6'>1</td>"; $html .= "<td style='border: solid 1px #000000;' colspan='2'><b>YANG DINILAI</b></td>"; $html .= "</tr>"; $html .= "<tr>"; $html .= "<td style='border: solid 1px #000000;' width='30%'>Nama</td>"; $html .= "<td style='border: solid 1px #000000;'>" . $gelar_depan_pegawai . $ds_header["nama_pegawai"] . $gelar_belakang_pegawai . "</td>"; $html .= "</tr>"; $html .= "<tr>"; $html .= "<td style='border: solid 1px #000000;'>NIP</td>"; $html .= "<td style='border: solid 1px #000000;'>" . $ds_header["nip"] . "</td>"; $html .= "</tr>";
<?php include "../php/koneksi.php"; include "../php/fungsi.php"; $id_data = mysql_real_escape_string($_GET['id_data']); $sql = "SELECT \n\t\t\t\ta.*,d.pangkat, d.gol_ruang\n\t\t\tFROM\n\t\t\t\ttbl_sk_kenpang a\n\t\t\t\tLEFT JOIN ref_pangkat d ON a.id_pangkat_ttd_sk = d.id_pangkat\n\t\t\tWHERE\n\t\t\t\ta.id_data = '" . $id_data . "'\n\t\t "; $query = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_array($query); echo "<table border='0' cellspacing='4' cellpadding='4' style='font-size:12px;'>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NO SK </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['no_sk'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>TGL SK </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . tglindonesia($row['tgl_sk']) . "</td>\t\n\t\t\t</tr>\t\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NAMA PEJABAT PENANDATANGAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['nama_ttd_sk'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>NIP PEJABAT PENANDATANGAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['nip_ttd_sk'] . "</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>PANGKAT PEJABAT PENANDATANGAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['pangkat'] . " ( " . $row['gol_ruang'] . " )</td>\t\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'>JABATAN PEJABAT PENANDATANGAN </td>\n\t\t\t\t<td>\t:\t </td>\n\t\t\t\t<td> " . $row['jabatan_ttd_sk'] . "</td>\t\n\t\t\t</tr>\n\t\t</table><br/>\t\t\n\t"; echo "<center><span style='font-size:14px; font-weight:bold;' >DAFTAR NAMA PEGAWAI YANG DIUSULKAN</span></center>"; echo "<table border='1' cellspacing='4' cellpadding='4' style='font-size:12px;'>"; echo "\n\t\t\t<tr>\n\t\t\t\t<td style='font-weight:bold;'><center>No</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>NIP Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Nama Pegawai</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Unit Kerja/SKPD</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Pangkat Lama</center></td>\n\t\t\t\t<td style='font-weight:bold;'><center>Pangkat Baru</center></td>\n\t\t\t</tr>\n\t"; $no = 1; echo "<tbody>"; // hardcode cuy untuk string sql kedua $ql = "SELECT \n\t\t\t\ta.id_pegawai, b.nip, b.nama_pegawai, c.skpd, d.pangkat, d.gol_ruang ,\n\t\t\t\te.pangkat as 'PANGKAT_BARU', e.gol_ruang as 'GOLBAR'\n\t\t\tFROM\n\t\t\t\ttbl_sk_kenpang_detail a\n\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n\t\t\t\tLEFT JOIN ref_skpd c ON b.id_satuan_organisasi = c.id_skpd\n\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\tLEFT JOIN ref_pangkat e ON a.id_pangkat_baru = e.id_pangkat\n\t\t\tWHERE\n\t\t\t\ta.id_sk = '" . $id_data . "'\n\t\t\tORDER BY\n\t\t\t b.nama_pegawai ASC\n\t\t "; $qr = mysql_query($ql); while ($data = mysql_fetch_array($qr)) { // normalisasi data $skpd = $data['skpd'] == '' ? '-' : $data['skpd']; $panggol = $data['pangkat'] == '' && $data['gol_ruang'] == '' ? '-' : $data['pangkat'] . " (" . $data['gol_ruang'] . ") "; $nnip = $data['nip'] == '' ? 'NIHIL' : $data['nip']; $fullname = $data['nama_pegawai'] == '' ? 'NIHIL' : $data['nama_pegawai']; $p_baru = $data['PANGKAT_BARU'] == '' && $data['GOLBAR'] == '' ? '-' : $data['PANGKAT_BARU'] . " (" . $data['GOLBAR'] . ") "; echo "<tr>\n\t\t\t<td><center> " . $no . " </center></td>\n\t\t\t<td><center> " . $nnip . " </center></td>\n\t\t\t<td><center> " . $fullname . " </center></td>\n\t\t\t<td><center> " . $skpd . " </center></td>\n\t\t\t<td><center> " . $panggol . " </center></td>\n\t\t\t<td><center> " . $p_baru . " </center></td>\n\t\t</tr>"; $no++; } echo "</tbody>"; echo "</table>"; // tutup koneksi mysql_close();