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