while ($ds_pangkat = mysql_fetch_array($res_pangkat)) { $row_pangkat["id_pangkat"] = $ds_pangkat["id_pangkat"]; $row_pangkat["gol_ruang"] = $ds_pangkat["gol_ruang"]; $row_pangkat["pangkat"] = $ds_pangkat["pangkat"]; array_push($pangkat, $row_pangkat); } echo "var pangkat = " . json_encode($pangkat) . ";\n"; // DATA : ref_peraturan_gaji $peraturan_gaji = array(); $sql_peraturan_gaji = "SELECT * FROM ref_peraturan_gaji ORDER BY tgl_berlaku DESC"; $res_peraturan_gaji = mysql_query($sql_peraturan_gaji); while ($ds_peraturan_gaji = mysql_fetch_array($res_peraturan_gaji)) { $row_peraturan_gaji["id_peraturan_gaji"] = $ds_peraturan_gaji["id_peraturan_gaji"]; $row_peraturan_gaji["nama_daftar_gaji"] = $ds_peraturan_gaji["nama_daftar_gaji"]; $row_peraturan_gaji["peraturan"] = $ds_peraturan_gaji["peraturan"]; $row_peraturan_gaji["tgl_berlaku"] = tglpjgindonesia($ds_peraturan_gaji["tgl_berlaku"]); array_push($peraturan_gaji, $row_peraturan_gaji); } echo "var peraturan_gaji = " . json_encode($peraturan_gaji) . ";\n"; // DATA : usulan_gaji_berkala_detail $ugbd = array(); $sql_ugbd = "SELECT\n \ta.*, b.id_pangkat\n FROM\n \ttbl_usulan_gaji_berkala_detail a\n \tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n WHERE\n \tid_detail_gaji_berkala='" . $_GET["id_detail_gaji_berkala"] . "'"; $res_ugbd = mysql_query($sql_ugbd); $ds_ugbd = mysql_fetch_array($res_ugbd); $ugbd["id_detail_gaji_berkala"] = $ds_ugbd["id_detail_gaji_berkala"]; $ugbd["id_usulan"] = $ds_ugbd["id_usulan"]; $ugbd["id_sk"] = $ds_ugbd["id_sk"]; $ugbd["id_pegawai"] = $ds_ugbd["id_pegawai"]; $ugbd["status"] = $ds_ugbd["status"]; $ugbd["id_pangkat"] = $ds_ugbd["id_pangkat"]; $ugbd["pangkat"] = apa_pangkat($ds_ugbd["id_pangkat"]);
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"); /* CONTROLLER */ // data surat $ds_usulan = mysql_fetch_array(mysql_query("SELECT\n \ta.*, pp.pangkat AS pgkps, pp.gol_ruang AS grps, b.jenis_disiplin, c.sub_jenis_disiplin, d.nama_pegawai, d.nip, e.pangkat, e.gol_ruang,\n \tf.jabatan, g.skpd\n FROM\n \ttbl_usulan_hukuman_disiplin a\n LEFT JOIN ref_pangkat pp ON a.pangkat_pejabat_sk = pp.id_pangkat\n \tLEFT JOIN ref_jenis_disiplin b ON a.id_jenis_disiplin = b.id_jenis_disiplin\n \tLEFT JOIN ref_sub_jenis_disiplin c ON a.id_sub_jenis_disiplin = c.id_sub_jenis_disiplin\n \tLEFT JOIN tbl_pegawai d ON a.id_pegawai = d.id_pegawai\n \tLEFT JOIN ref_pangkat e ON d.id_pangkat = e.id_pangkat\n \tLEFT JOIN ref_jabatan f ON d.id_jabatan = f.id_jabatan\n \tLEFT JOIN ref_skpd g ON d.id_satuan_organisasi = g.id_skpd\n WHERE\n \ta.id_usulan = '" . $_GET["id_usulan"] . "'")); $tmt = tglpjgindonesia($ds_usulan["tmt"]); $keterangan = $ds_usulan["keterangan"]; $jabatan_pejabat_sk = $ds_usulan["jabatan_pejabat_sk"]; $nama_pejabat_sk = $ds_usulan["nama_pejabat_sk"]; $nip_pejabat_sk = $ds_usulan["nip_pejabat_sk"]; $pangkat_pejabat_sk = $ds_usulan["pgkps"]; $gol_ruang_pejabat_sk = $ds_usulan["grps"]; $tgl_sk = $ds_usulan["tgl_sk"] == "0000-00-00" ? " " : tglpjgindonesia($ds_usulan["tgl_sk"]); $no_sk = $ds_usulan["no_sk"] == "" ? " " : $ds_usulan["no_sk"]; $membaca = explode("{}", $ds_usulan["membaca"]); $menimbang = explode("{}", $ds_usulan["menimbang"]); $mengingat = explode("{}", $ds_usulan["mengingat"]); $menetapkan = explode("{}", $ds_usulan["menetapkan"]); $tembusan = explode("{}", $ds_usulan["tembusan"]); $jenis_disiplin = $ds_usulan["jenis_disiplin"]; $sub_jenis_disiplin = $ds_usulan["sub_jenis_disiplin"]; $nama_pegawai = $ds_usulan["nama_pegawai"]; $nip = $ds_usulan["nip"]; $pangkat = $ds_usulan["pangkat"]; $gol_ruang = $ds_usulan["gol_ruang"]; $jabatan = $ds_usulan["jabatan"]; $skpd = $ds_usulan["skpd"]; $arr_memutuskan = array("KESATU", "KEDUA", "KETIGA", "KEEMPAT", "KELIMA", "KEENAM", "KETUJUH", "KEDELAPAN", "KESEMBILAN", "KESEPULUH");
$nama_peneken = $ds_surat["nama_surat"]; $pangkat_peneken = $ds_surat["pangkat"]; $nip_peneken = $ds_surat["nip_surat"]; // data pegawai yang diusulkan $list_pegawai = array(); $sql_list_pegawai = "SELECT\n \te.id_riwayat_cuti, f.jenis_cuti, e.lama, e.dari, e.sampai, a.id_pegawai, a.nama_pegawai, a.nip,\n \tb.pangkat, b.gol_ruang,\n \tc.jabatan, d.skpd, e.keterangan\n FROM\n \ttbl_pegawai a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat = b.id_pangkat\n \tLEFT JOIN ref_jabatan c ON a.id_jabatan = c.id_jabatan\n \tLEFT JOIN ref_skpd d ON a.id_satuan_organisasi = d.id_skpd\n \tINNER JOIN tbl_riwayat_cuti e ON (a.id_pegawai = e.id_pegawai AND e.id_surat = '" . $_GET["id_surat"] . "')\n \tLEFT JOIN ref_jenis_cuti f ON e.id_jenis_cuti = f.id_jenis_cuti\n ORDER BY\n \t\ta.nama_pegawai ASC"; $res_list_pegawai = mysql_query($sql_list_pegawai); $norut_list_pegawai = 0; while ($ds_list_pegawai = mysql_fetch_array($res_list_pegawai)) { $norut_list_pegawai++; $row_list_pegawai["no"] = $norut_list_pegawai; $row_list_pegawai["id_riwayat_cuti"] = $ds_list_pegawai["id_riwayat_cuti"]; $row_list_pegawai["jenis_cuti"] = $ds_list_pegawai["jenis_cuti"]; $row_list_pegawai["lama"] = $ds_list_pegawai["lama"]; $row_list_pegawai["dari"] = tglpjgindonesia($ds_list_pegawai["dari"]); $row_list_pegawai["sampai"] = tglpjgindonesia($ds_list_pegawai["sampai"]); $row_list_pegawai["id_pegawai"] = $ds_list_pegawai["id_pegawai"]; $row_list_pegawai["nama_pegawai"] = $ds_list_pegawai["nama_pegawai"]; $row_list_pegawai["nip"] = $ds_list_pegawai["nip"]; $row_list_pegawai["pangkat"] = $ds_list_pegawai["pangkat"]; $row_list_pegawai["gol_ruang"] = $ds_list_pegawai["gol_ruang"]; $row_list_pegawai["jabatan"] = $ds_list_pegawai["jabatan"]; $row_list_pegawai["skpd"] = $ds_list_pegawai["skpd"]; $row_list_pegawai["keterangan"] = ""; if ($ds_list_pegawai["keterangan"] != "") { $row_list_pegawai["keterangan"] = "(" . $ds_list_pegawai["keterangan"] . ")"; } array_push($list_pegawai, $row_list_pegawai); } $html = ""; $html .= "<div style='text-align: left; font-family: serif; font-size: 11pt; margin-left: 700px;'>";
<?php ob_start(); session_start(); require_once "../../../php/dompdf_config.inc.php"; require_once "../../../php/koneksi.php"; require_once "../../../php/fungsi.php"; require_once "../../../php/model/sk_kenpang_model.php"; date_default_timezone_set("America/New_York"); /* CONTROLLER */ $id_sk = mysql_real_escape_string($_GET['id_sk']); $sk = new SKKenpang_Model(); $sk->Record($id_sk); $no_sk = $sk->no_sk == "" ? " " : $sk->no_sk; $tgl_sk = $sk->tgl_sk == "0000-00-00" ? " " : tglpjgindonesia($sk->tgl_sk); $daftar = array(); $sql_daftar = "SELECT\n \tb.id_pegawai, b.nama_pegawai, b.nip,\n \tCASE\n \t\tWHEN b.gelar_depan <> '' THEN CONCAT(b.gelar_depan, '. ')\n \t\tELSE ''\n \tEND AS gelar_depan,\n \tCASE\n \t\tWHEN b.gelar_belakang <> '' THEN CONCAT(', ', b.gelar_belakang)\n \t\tELSE ''\n \tEND AS gelar_belakang,\n \tc.skpd, d.pangkat, d.gol_ruang ,\n\t\t\t\t\t\te.pangkat as 'PANGKAT_BARU', e.gol_ruang as 'GOLBAR'\n FROM\n \ttbl_sk_kenpang_detail a\n\t\t\t\t\t\tLEFT JOIN tbl_pegawai b ON a.id_pegawai = b.id_pegawai\n\t\t\t\t\t\tLEFT JOIN ref_skpd c ON b.id_satuan_organisasi = c.id_skpd\n\t\t\t\t\t\tLEFT JOIN ref_pangkat d ON b.id_pangkat = d.id_pangkat\n\t\t\t\t\t\tLEFT JOIN ref_pangkat e ON a.id_pangkat_baru = e.id_pangkat\n\t\t\t\t\tWHERE\n\t\t\t\t\t\ta.id_sk = '" . $id_sk . "' \n\t\t\t\t\tORDER BY\n\t\t\t\t\t\tb.nama_pegawai ASC"; $res_daftar = mysql_query($sql_daftar) or die(mysql_error()); while ($ds_daftar = mysql_fetch_array($res_daftar)) { $row_daftar["nama_pegawai"] = $ds_daftar["nama_pegawai"]; $row_daftar["gelar_depan"] = $ds_daftar["gelar_depan"]; $row_daftar["gelar_belakang"] = $ds_daftar["gelar_belakang"]; $row_daftar["nip"] = $ds_daftar["nip"]; $row_daftar["pangkat"] = $ds_daftar["pangkat"]; $row_daftar["gol_ruang"] = $ds_daftar["gol_ruang"]; $row_daftar["PANGBARU"] = $ds_daftar["PANGKAT_BARU"]; $row_daftar["GOLBAR"] = $ds_daftar["GOLBAR"]; //$row_daftar["jabatan"] = $ds_daftar["jabatan"]; array_push($daftar, $row_daftar); } /* END OF CONTROLLER */
<?php ob_start(); session_start(); require_once "../../../php/dompdf_config.inc.php"; require_once "../../../php/koneksi.php"; require_once "../../../php/fungsi.php"; require_once "../../../php/model/ijin_cerai_model.php"; date_default_timezone_set("America/New_York"); /* CONTROLLER */ $cerai = new IjinCerai_Model(); $cerai->Record($_GET["id_cerai"]); $pegawai_cerai = all_detail_pegawai($cerai->id_pegawai); $no_surat_panggilan = $cerai->no_sk == "" ? " " : $cerai->no_sk; $tgl_surat_panggilan = $cerai->tgl_sk == "0000-00-00" ? " " : tglpjgindonesia($cerai->tgl_sk); $membaca = explode("\n", $cerai->membaca_sk); $menimbang = explode("\n", $cerai->menimbang_sk); $mengingat = explode("\n", $cerai->mengingat_sk); $memperhatikan = explode("\n", $cerai->memperhatikan_sk); $tembusan = explode("\n", $cerai->tembusan_sk); $ds_agama = mysql_fetch_array(mysql_query("SELECT * FROM ref_agama WHERE id_agama='" . $cerai->id_agama_pasangan . "'")); $agama = $ds_agama["agama"]; /* END OF CONTROLLER */ $html = "<div style='font-family: sans-serif; font-size: 11pt;'>"; $html .= "<div style='height: 4cm;'> </div>"; $html .= "<div style='text-align: center; font-weight: bold;'>RAHASIA</div>"; $html .= "<div style='text-align: center; font-weight: bold;'>KEPUTUSAN PEMBERIAN IJIN PERCERAIAN</div>"; $html .= "<div style='text-align: center; text-transform: uppercase; font-weight: bold;'>NOMOR : " . $no_surat_panggilan . "</div>"; $html .= "<div style='text-align: center; font-weight: bold; text-transform: uppercase;'>" . $cerai->jabatan_pejabat_sk . "</div>"; $html .= "<div style='height: 1cm;'> </div>"; $html .= "<table cellspacing='0' cellpadding='0' style='width: 100%;'>";
$ds_surat = mysql_fetch_array(mysql_query("SELECT a.*, b.pangkat FROM tbl_sk_cuti a LEFT JOIN ref_pangkat b ON a.pangkat_surat = b.id_pangkat WHERE id_surat='" . $_GET["id_surat"] . "'")); $no_surat = $ds_surat["no_surat"] == "" ? " " : $ds_surat["no_surat"]; $tgl_surat = $ds_surat["tgl_surat"] == "0000-00-00" ? " " : tglpjgindonesia($ds_surat["tgl_surat"]); $pecah_tgl_surat = explode("-", $ds_surat["tgl_surat"]); $tahun_surat = $ds_surat["tgl_surat"] == "0000-00-00" ? " " : $pecah_tgl_surat[0]; $jabatan_peneken = $ds_surat["pejabat_surat"]; $nama_peneken = $ds_surat["nama_surat"]; $pangkat_peneken = $ds_surat["pangkat"]; $nip_peneken = $ds_surat["nip_surat"]; // data peneken usulan $peneken_usulan = array(); $sql_peneken_usulan = "SELECT\n \tb.no_usulan, b.tgl_usulan, b.pejabat_usulan\n FROM\n \ttbl_riwayat_cuti a\n \tINNER JOIN tbl_usulan_cuti b ON a.id_usulan = b.id_usulan\n WHERE\n \tid_surat = '" . $_GET["id_surat"] . "'\n GROUP BY\n \tb.no_usulan"; $res_peneken_usulan = mysql_query($sql_peneken_usulan); while ($ds_peneken_usulan = mysql_fetch_array($res_peneken_usulan)) { $row_peneken_usulan["no_usulan"] = $ds_peneken_usulan["no_usulan"]; $row_peneken_usulan["tgl_usulan"] = tglpjgindonesia($ds_peneken_usulan["tgl_usulan"]); $row_peneken_usulan["pejabat_usulan"] = $ds_peneken_usulan["pejabat_usulan"]; array_push($peneken_usulan, $row_peneken_usulan); } $html = ""; $html .= "<div style='height: 5cm;'> </div>"; $html .= "<div style='text-align: center; font-family: serif; font-size: 11pt;'>"; $html .= "<b>SURAT WALIKOTA MEDAN</b><br />"; $html .= "<b>NOMOR : " . $no_surat . " TAHUN " . $tahun_surat . "</b><br />"; $html .= "<b>T E N T A N G</b><br />"; $html .= "<b>CUTI PEGAWAI NEGERI SIPIL</b><br />"; $html .= "<b>WALIKOTA MEDAN</b>"; $html .= "</div>"; $html .= "<div style='height: 20px;'> </div>"; $html .= "<div style='font-family: serif; font-size: 11pt;'>"; $html .= "<table width='100%' border='0'>";
$html .= "<td style='text-transform: uppercase;'>" . $pegawai_cerai["skpd"] . "</td>"; $html .= "</tr>"; $html .= "</table>"; $html .= "<div style='height: 0.2cm;'> </div>"; $html .= "<div>Pada</div>"; $html .= "<div style='height: 0.2cm;'> </div>"; $html .= "<table style='width: 100%; margin-left: 30px;' cellspacing='0' cellpadding='2'>"; $html .= "<tr>"; $html .= "<td style='width: 20%;'>Hari</td>"; $html .= "<td style='width: 5%;'>:</td>"; $html .= "<td style='text-transform: uppercase;'>" . $cerai->hari_h_spgl . "</td>"; $html .= "</tr>"; $html .= "<tr>"; $html .= "<td style='width: 20%;'>Tanggal</td>"; $html .= "<td style='width: 5%;'>:</td>"; $html .= "<td style='text-transform: uppercase;'>" . tglpjgindonesia($cerai->tgl_h_spgl) . "</td>"; $html .= "</tr>"; $html .= "<tr>"; $html .= "<td style='width: 20%;'>Jam</td>"; $html .= "<td style='width: 5%;'>:</td>"; $html .= "<td style='text-transform: uppercase;'>" . $cerai->jam_h_spgl . "</td>"; $html .= "</tr>"; $html .= "<tr>"; $html .= "<td style='width: 20%;'>Tempat</td>"; $html .= "<td style='width: 5%;'>:</td>"; $html .= "<td style='text-transform: uppercase;'>" . $cerai->tempat_h_spgl . "</td>"; $html .= "</tr>"; $html .= "</table>"; $html .= "<div style='height: 0.2cm;'> </div>"; $html .= "<div>\n Karena Sdr/i. " . $pegawai_cerai["nama_pegawai"] . " mengajukan permohonan ijin cerai terhadap\n pasangannya Sdr/i. " . $cerai->nama_pasangan . "\n </div>"; $html .= "<div style='height: 0.2cm;'> </div>";
<?php ob_start(); session_start(); require_once "../../../php/dompdf_config.inc.php"; require_once "../../../php/koneksi.php"; require_once "../../../php/fungsi.php"; require_once "../../../php/model/sk_satya_lancana_model.php"; date_default_timezone_set("America/New_York"); /* CONTROLLER */ $sk = new SKSatyaLancana_Model(); $sk->Record($_GET["id_usulan"]); $no_sk = $sk->no_usulan == "" ? " " : $sk->no_usulan; $tgl_sk = $sk->tgl_usulan == "0000-00-00" ? " " : tglpjgindonesia($sk->tgl_usulan); $daftar = array(); $sql_daftar = "SELECT\n \ta.id_pegawai, a.nama_pegawai, a.nip,\n \tCASE\n \t\tWHEN a.gelar_depan <> '' THEN CONCAT(a.gelar_depan, '. ')\n \t\tELSE ''\n \tEND AS gelar_depan,\n \tCASE\n \t\tWHEN a.gelar_belakang <> '' THEN CONCAT(', ', a.gelar_belakang)\n \t\tELSE ''\n \tEND AS gelar_belakang,\n \tb.status_kepegawaian, c.jenis_kepegawaian, d.kedudukan_kepegawaian,\n \te.jenis_kelamin, a.alamat, a.tanggal_lahir, f.skpd, g.pangkat, g.gol_ruang, h.jabatan,\n \ti.id_detail_satya_lencana, i.jenis_satya, 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_usulan_satya_lancana_detail i ON (a.id_pegawai = i.id_pegawai AND i.id_sk = '" . $_GET["id_usulan"] . "')\n ORDER BY\n \ti.id_detail_satya_lencana ASC"; $res_daftar = mysql_query($sql_daftar); while ($ds_daftar = mysql_fetch_array($res_daftar)) { $row_daftar["nama_pegawai"] = $ds_daftar["nama_pegawai"]; $row_daftar["gelar_depan"] = $ds_daftar["gelar_depan"]; $row_daftar["gelar_belakang"] = $ds_daftar["gelar_belakang"]; $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["jenis_satya"] = $ds_daftar["jenis_satya"]; array_push($daftar, $row_daftar); } /* END OF CONTROLLER */ $html = "<div style='font-family: sans-serif; font-size: 9pt;'>"; $html .= "<div style='height: 1cm;'> </div>";