tglindonesia PHP Code Examples

Example #1

0

Show file

File: file_surat_masuk.php Project: ibnoe/dinsosnaker2014

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

Example #2

0

Show file

File: pi_daftar_usulan.php Project: suryamanik15/sistem_2014

<!-- 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;
    }

Example #3

0

Show file

File: perilaku_isi_pilih_periode.php Project: suryamanik15/sistem_2014

    <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'>&nbsp;</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>

Example #4

0

Show file

File: skp_output_isi.php Project: ibnoe/dinsosnaker2014

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'>&nbsp;</td>
								<td width='5px'>&nbsp;</td>
								<td>&nbsp;</td>
							</tr>
							<tr>
								<td>Pejabat Penilai</td>
								<td>:</td>
								<td style="text-transform: uppercase;">
									<b>
										<?php 
echo $ds["nama_pegawai_penilai"];
?>
<br />

Example #5

0

Show file

File: cetak_disposisi.php Project: ibnoe/dinsosnaker2014

    $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');

Example #6

0

Show file

File: kenpang_sk_telah_diproses.php Project: suryamanik15/sistem_2014

	$("#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 -->

Example #7

0

Show file

File: spv_riwayat_pangkat_proses.php Project: suryamanik15/sistem_2014

                </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>

Example #8

0

Show file

File: cek_berkas.php Project: ibnoe/dinsosnaker2014

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

Example #9

0

Show file

File: lhkpn_proses_riwayat.php Project: suryamanik15/sistem_2014

<!-- 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);
?>

Example #10

0

Show file

File: profile.php Project: ibnoe/dinsosnaker2014

							<tr>
								<td>JENIS KELAMIN</td>
								<td>&nbsp;&nbsp; : &nbsp;&nbsp; </td>
								<td>
									  <span><b><?php 
echo $ds["jenis_kelamin"] == "" ? "-" : $ds["jenis_kelamin"];
?>
</b></span>
								</td>
							</tr>
							<tr>
								<td>TEMPAT / TANGGAL LAHIR</td>
								<td>&nbsp;&nbsp; : &nbsp;&nbsp; </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>

Example #11

0

Show file

File: cetak_laporan_kegiatan_verifikasi_upload_rekap.php Project: ibnoe/dinsosnaker2014

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>";

Example #12

0

Show file

File: cetak_realisasi_skp.php Project: ibnoe/dinsosnaker2014

 *         $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>";

Example #13

0

Show file

File: usulan_cuti_daftar_diusulkan.php Project: suryamanik15/sistem_2014

<?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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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();

Example #14

0

Show file

File: finalisasi_surat_keluar.php Project: ibnoe/dinsosnaker2014

$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"] . ");'>";

Example #15

0

Show file

File: pangkat_daftar_diusulkan.php Project: suryamanik15/sistem_2014

<?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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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>";

Example #16

0

Show file

File: riwayat_pangkat.php Project: ibnoe/dinsosnaker2014

                <th width='200px'>TMT</th>
                <th width='200px'>No. SK</th>
                <th width='200px'>Tanggal SK</th>
                <th>Pejabat Penetapan</th>
                <th width='20px'>&nbsp;</th>
                <th width='20px'>&nbsp;</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>

Example #17

0

Show file

File: ucapan_ultah_personal.php Project: ibnoe/dinsosnaker2014

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

Example #18

0

Show file

File: spv_riwayat_pendidikan.php Project: suryamanik15/sistem_2014

<?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>";

Example #19

0

Show file

File: cuti_daftar_usulan_proses.php Project: ibnoe/dinsosnaker2014

<!-- 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;

Example #20

0

Show file

File: cerai_daftar_usulan.php Project: suryamanik15/sistem_2014

<!-- 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;
    }

Example #21

0

Show file

File: berita_dan_informasi_list.php Project: ibnoe/dinsosnaker2014

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

Example #22

0

Show file

File: posisi_surat_keluar_kaban.php Project: ibnoe/dinsosnaker2014

}
$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"] . "'>&nbsp;</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"] . ");'>";

Example #23

0

Show file

File: cadis_spv_riwayat_pangkat.php Project: suryamanik15/sistem_2014

<?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>";
}

Example #24

0

Show file

File: manajemen_surat_keluar_1.php Project: ibnoe/dinsosnaker2014

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'>";

Example #25

0

Show file

File: lampiran_sk_pmk.php Project: suryamanik15/sistem_2014

echo "<table border='0' cellspacing='0' cellpadding='3' width='50%'>\n\t<tr>\n\t\t&nbsp;&nbsp;&nbsp;\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&nbsp;&nbsp;&nbsp;KEPUTUSAN&nbsp;&nbsp;&nbsp;WALIKOTA&nbsp;&nbsp;&nbsp;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'] == "" ? "&nbsp;" : $data['gelar_depan'] . "&nbsp;";
    $gb = $data['gelar_belakang'] == "" ? "&nbsp;" : "&nbsp;" . $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>";

Example #26

0

Show file

File: cetak_dp3_baru.php Project: ibnoe/dinsosnaker2014

$html .= "<tr>";
$html .= "<td style='border: solid 1px #000000;' colspan='4' align='left'>\n                            <div style='text-align:right;'><b>11. DITERIMA TANGGAL,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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>";

Example #27

0

Show file

File: sk_pangkat_daftar_diusulkan.php Project: suryamanik15/sistem_2014

<?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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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 &nbsp;&nbsp;</td>\n\t\t\t\t<td>\t:\t&nbsp;&nbsp;</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();

PHP tglindonesia Examples