<div> <h3>JABATAN DAN KEPANGKATAN</h3> <div> <h4>Riwayat Jabatan</h4> <table border="1"> <tr> <th>No</th> <th>Jabatan</th> <th>TMT</th> <th>Gol.</th> <th>Eselon</th> <th>Keterangan</th> <th>View</th> </tr> <?php $jabatans = getJabatan($nip_peg); $n = 0; foreach ($jabatans as $jab) { $n++; ?> <tr> <td><?php echo $n; ?> </td> <td><?php if (isset($_SESSION['username'])) { ?> <a href="<?php echo $base_url; ?>
function listTembusan($dbh, $string) { if ($string != "") { $arr = explode("@+id/", $string); $tempArr = array(); for ($i = 0; $i < count($arr); $i++) { if (!empty($arr[$i])) { array_push($tempArr, getJabatan($dbh, $arr[$i])); } } $join = implode(", ", $tempArr); } else { $join = "Tidak Ada"; } return $join; }
function viewSurat($id, $token) { global $app; $app->response->headers->set("Content-Type", "application/pdf"); //include header include 'headerpdf.php'; $req = json_decode($app->request->getBody(), true); // $token = $req['token']; Jika menggunakan method POST // $id = $req['id']; $decode = JWT::decode($token, TK); $account = $decode->account; $id_jabatan = $decode->id_jabatan; $dbh = getDB(); // setReads($dbh, $id); $query = "SELECT surat.*, surat_terdistribusi.penerima, surat_kode_hal.deskripsi, users.nama, jabatan.jabatan from surat, surat_terdistribusi, surat_kode_hal, users, jabatan WHERE surat_terdistribusi.id=:id_surat AND surat_terdistribusi.id_surat = surat.id_surat AND (surat_terdistribusi.penerima = :id_jabatan OR surat_terdistribusi.penerima = :account) AND surat.kode_hal = surat_kode_hal.kode_hal AND ((surat_terdistribusi.penerima = users.account) OR (surat_terdistribusi.penerima = users.id_jabatan AND users.id_jabatan = jabatan.id_jabatan))"; $stmt = $dbh->prepare($query); $stmt->bindValue(':id_surat', (int) $id, PDO::PARAM_INT); $stmt->bindValue(':id_jabatan', $id_jabatan); $stmt->bindValue(':account', $account); try { $stmt->execute(); $row = $stmt->fetch(); $hal = $row['deskripsi']; // Mendapatkan deskripsi dari HAL $input = $row['isi']; // Mendapatkan isi dari surat // $tjb = $row['jabatan']; // $nama_pejabat = $row['nama']; $nosurat = $row['no_surat']; $lam = $row['lampiran']; $tanggal = convertDate($row['tanggal_surat']); $tjb = getJabatan($dbh, $row['penandatangan']); $nama_pejabat = getAccountName($dbh, $row['penandatangan']); $tembusan = explode("@+id/", $row['tembusan']); // Cari nama user berdasarkan jabatan parameter 'tujuan' // $query2 = "SELECT users.nama FROM users WHERE users.id_jabatan = :tujuan OR users.account = :tujuan"; $stmt2 = $dbh->prepare($query2); $stmt2->bindValue(":tujuan", $row['penerima']); try { $stmt2->execute(); if ($stmt2->rowCount() > 0) { // Jika ditemukan $row2 = $stmt2->fetch(); $tujuan2 = $row2['nama']; } else { // Jika tidak ditemukan, berarti suratnya ditujukan kepada pejabat. Cari di tabel pejabat $tujuan2 = getJabatan($dbh, $row['penerima']); } } catch (PDOException $ex) { echo $ex->getMessage(); } } catch (PDOException $e) { echo $e->getMessage(); } // add a page $pdf->AddPage(); //content PDF setlocale(LC_ALL, 'IND'); //$nosurat = '999/UN.39.18/TU/15'; //$tanggal = strftime("%d %B %Y"); $lam = '2'; //$hal = 'Pengajuan Peminjaman Scanner'; $tujuan = 'KEPALA BIRO ADM. UMUM dan KEUANGAN (BAUK)'; //$tujuan2 = 'KEPALA BIRO PERENCANAAN & SISTEM INFORMASI (BAPSI)'; $tujuan3 = 'KA. UPT PERPUSTAKAAN'; //$tjb = 'Ka. Pustikom'; $nip = '197408242005011001'; //$nama_pejabat = 'Hamidillah Adjie, ST'; //a. first //$pdf->Cell(0, 0, 'Nomor : '.$tes.' '.$tanggal.'', 0, false, 'L', 0, '', 0, false, 'M', 'M'); //$pdf->Ln(6); //$pdf->Cell(0, 0, 'Lamp :', 0, false, 'L', 0, '', 0, false, 'M', 'M'); //$pdf->Ln(6); //$pdf->Cell(0, 0, 'Hal :', 0, false, 'L', 0, '', 0, false, 'M', 'M'); //$pdf->Ln(6); $pdf->Ln(55); $pdf->SetFont('times', '', 12); //first $pdf->MultiCell(0, 0, '' . $tanggal . '', 0, 'L', 0, 0, 160, 53, true, 0, false, true, 0, 'M', true); //selisih turun cell 9 $pdf->MultiCell(0, 0, 'No', 0, 'L', 0, 0, 25, 53, true, 0, false, true, 0, 'M', true); //25 : margin dari kiri 53: margin dari atas $pdf->MultiCell(0, 0, ':', 0, 'L', 0, 0, 50, 53, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(0, 0, 'Lampiran', 0, 'L', 0, 0, 25, 61, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(0, 0, ':', 0, 'L', 0, 0, 50, 61, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(0, 0, 'Hal', 0, 'L', 0, 0, 25, 69, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(0, 0, ':', 0, 'L', 0, 0, 50, 69, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(0, 0, '' . $nosurat . '', 0, 'L', 0, 0, 53, 53, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(0, 0, '' . $lam . '', 0, 'L', 0, 0, 53, 61, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(90, 17, '' . $hal . '', 0, 'L', 0, 0, 53, 69, true, 0, false, true, 0, 'T', true); //second $pdf->MultiCell(0, 0, 'Yth.', 0, 'L', 0, 0, 25, 88, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(90, 6, '' . $tujuan2 . '', 0, 'L', 0, 0, 33, 88, true, 0, false, true, 0, 'M', true); $pdf->MultiCell(90, 6, 'Universitas Negeri Jakarta', 0, 'L', 0, 0, 33, 93, true, 0, false, true, 0, 'M', true); //third //$input = str_replace('<br />', '\n', $_POST['isi']); $html = $input; $pdf->MultiCell(170, 0, '' . $input . '' . "\n", 0, 'J', 0, 1, 25, 105, true, 0, true, true, 0, 'T', true); //nilai 1 setelah J adalah posisi cell default berada dibawah //$pdf->MultiCell($w, $h, $txt, $border, $align, $fill, $ln, $x, $y, $reseth, $stretch, $ishtml, $autopadding, $maxh); ////$pdf->writeHTML($html); // $pdf->setCellMargins(0, 7, 0, 0); $pdf->MultiCell(170, 0, '' . $tjb . '', 0, 'L', 0, 1, 140, '', true, 0, false, true, 0, 'T', true); $pdf->setCellMargins(0, 23, 0, 0); $pdf->MultiCell(170, 0, '' . $nama_pejabat . '', 0, 'L', 0, 1, 140, '', true, 0, false, true, 0, 'T', true); $pdf->setCellMargins(0, 0, 0, 0); $pdf->MultiCell(170, 0, 'NIP' . ".{$nip}.", 0, 'L', 0, 1, 140, '', true, 0, false, true, 0, 'T', true); //Tembusan $pdf->setCellMargins(0, 10, 0, 0); $pdf->MultiCell(170, 0, 'Tembusan :', 0, 'L', 0, 1, 25, '', true, 0, false, true, 0, 'T', true); $pdf->setCellMargins(0, 0, 0, 0); for ($i = 0; $i < count($tembusan); $i++) { if ($tembusan[$i] != '') { $pdf->MultiCell(170, 0, $i + 1 . '. ' . getJabatan($dbh, $tembusan[$i]), 0, 'L', 0, 1, 25, '', true, 0, false, true, 0, 'T', true); } } // create some HTMNomor : L content //$html = '<span style="text-align:justify;">a <u>abc</u> abcdefghijkl (abcdef) abcdefg <b>abcdefghi</b> a ((abc)) abcd <img src="images/logo_example.png" border="0" height="41" width="41" /> <img src="images/tcpdf_box.svg" alt="test alt attribute" width="80" height="60" border="0" /> abcdef abcdefg <b>abcdefghi</b> a abc abcd abcdef abcdefg <b>abcdefghi</b> a abc abcd abcdef abcdefg <b>abcdefghi</b> a <u>abc</u> abcd abcdef abcdefg <b>abcdefghi</b> a abc \(abcd\) abcdef abcdefg <b>abcdefghi</b> a abc \\\(abcd\\\) abcdef abcdefg <b>abcdefghi</b> a abc abcd abcdef abcdefg <b>abcdefghi</b> a abc abcd abcdef abcdefg <b>abcdefghi</b> a abc abcd abcdef abcdefg abcdefghi a abc abcd <a href="http://tcpdf.org">abcdef abcdefg</a> start a abc before <span style="background-color:yellow">yellow color</span> after a abc abcd abcdef abcdefg abcdefghi a abc abcd end abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi a abc abcd abcdef abcdefg abcdefghi<br />abcd abcdef abcdefg abcdefghi<br />abcd abcde abcdef</span>'; //$html = "<span>Much playing will only make you happy temporarily</span>"; //$input = $_POST['isi']; // set core font $pdf->SetFont('helvetica', '', 10); // output the HTML content //$pdf->writeHTML($html, true, 0, true, true); $pdf->Ln(); // set UTF-8 Unicode font $pdf->SetFont('dejavusans', '', 10); // output the HTML content //$pdf->writeHTML($html, true, 0, true, true,'J'); //$pdf->Write(0, $input); // reset pointer to the last page $pdf->lastPage(); // --------------------------------------------------------- //Close and output PDF document $nama_pengirim = $_POST['sender']; $nama_file = $nosurat . '.pdf'; $output = $pdf->Output('', 'S'); $savePdf = addslashes($output); $pdf->Output($nama_file, 'I'); }
</script> <?php include "sidebar.php"; ?> <div class="col-md-9"> <h3>DAFTAR RIWAYAT HIDUP</h3> <?php $search = $_GET['search']; $pegawais = getSearchPegawai($search); foreach ($pegawais as $row) { $jabatandisplays = getJabatanDisplay($row['nip_peg']); $pangkatdisplays = getKepangkatanDisplay($row['nip_peg']); $pendidikandisplays = getPendidikanDisplay($row['nip_peg']); $diks = getDiklat($row['nip_peg']); $kepangkatans = getKepangkatan($row['nip_peg']); $jabatans = getJabatan($row['nip_peg']); $pendidikans = getPendidikan($row['nip_peg']); $keluargas = getKeluargaPegawai($row['nip_peg']); // var_dump($row); ?> <div> <div> <h4>IDENTITAS PEGAWAI</h4> <div class="tbl-no-border data-diri" style="width:450px;"> <table id="left" border="0"> <tr> <td>1.</td> <td>Nama </td> <td>:</td> <td><?php if (isset($_SESSION['username'])) {