echo nama_peg($col[2][$k]); ?> <br /><?php echo 'NIP. ' . reformat_nipbaru(nip_peg($col[2][$k])); } ?> </td> <td align="center" valign="top"><?php if ($col[3][$k] != $kdunitkerja) { ?> <font color="#0033FF"><strong><?php echo nm_pangkat($col[5][$k]) . '(' . nm_gol($col[5][$k]) . ')<br>' . reformat_tanggal(tmtgol_peg($col[2][$k])); ?> </strong></font><?php } else { echo nm_pangkat($col[5][$k]) . '(' . nm_gol($col[5][$k]) . ')<br>' . reformat_tanggal(tmtgol_peg($col[2][$k])); } ?> </td> <td align="left" valign="top"><?php if ($col[3][$k] != $kdunitkerja) { ?> <font color="#0033FF"><strong><?php echo nm_info_jabatan($col[3][$k], $col[4][$k]); ?> </strong></font><?php } else { echo nm_info_jabatan($col[3][$k], $col[4][$k]); } ?> <?php
} for ($i = 0; $i < $max; $i++) { $pdf->SetX($margin + $w[0]); $pdf->Cell($w[1], $ln, $arrNomor[$i], '', 0, 'L'); $pdf->SetX($margin + $w[0] + $w[1]); $pdf->Cell($w[2], $ln, $arrLabel[$i], '', 0, 'L'); $pdf->SetX($margin + $w[0] + $w[1] + $w[2]); $pdf->Cell($w[3], $ln, $arrTitik[$i], '', 0, 'L'); $pdf->SetX($margin + $w[0] + $w[1] + $w[2] + $w[3]); $pdf->Cell($w[4], $ln, $arrUraian[$i], '', 1, 'L'); } $max = 0; $arrNomor = $pdf->SplitToArray($w[1], $ln, 'g.'); $arrLabel = $pdf->SplitToArray($w[2], $ln, 'Jangka waktu penilaian'); $arrTitik = $pdf->SplitToArray($w[3], $ln, ':'); $arrUraian = $pdf->SplitToArray($w[4], $ln, reformat_tanggal($row['tgl_kemajuan_awal']) . ' s.d. ' . reformat_tanggal($row['tgl_kemajuan_akhir'])); if ($max < count($arrUraian)) { $max = count($arrUraian); } for ($i = 0; $i < $max; $i++) { $pdf->SetX($margin + $w[0]); $pdf->Cell($w[1], $ln, $arrNomor[$i], '', 0, 'L'); $pdf->SetX($margin + $w[0] + $w[1]); $pdf->Cell($w[2], $ln, $arrLabel[$i], '', 0, 'L'); $pdf->SetX($margin + $w[0] + $w[1] + $w[2]); $pdf->Cell($w[3], $ln, $arrTitik[$i], '', 0, 'L'); $pdf->SetX($margin + $w[0] + $w[1] + $w[2] + $w[3]); $pdf->Cell($w[4], $ln, $arrUraian[$i], '', 1, 'L'); } $w = array(7, 180); $max = 0;
$pdf->SetX($margin + $w2[0] + $w2[1] + $w2[2] * 2 + $w2[3] * 2 + $w2[4] * 2 + $w2[5] * 2 + $w2[6] * 2 + $w2[7]); $pdf->Cell($w2[8], $ln, '', 'LR', 1, 'C'); $pdf->Line($margin, $pdf->GetY(), $margin + $w2[0] + $w2[1] + $w2[2] * 2 + $w2[3] * 2 + $w2[4] * 2 + $w2[5] * 2 + $w2[6] * 2 + $w2[7] + $w2[8], $pdf->GetY()); # AKHIR WHILE if ($pdf->GetY() >= 240) { $pdf->AddPage(); } //------------------ Tanda Tangan $w3 = array(50, 80, 50); $pdf->Ln(); if ($row['is_approved_akhir'] == '1') { $tanggal = $row['tahun'] . '-01-01'; $pdf->SetX($margin); $pdf->Cell($w3[0], $ln, '', '', 0, 'C'); $pdf->SetX($margin + $w3[0] + $w3[1]); $pdf->Cell($w3[2], $ln, kota_unit(substr($row['kdunitkerja'], 0, 2)) . ', ' . reformat_tanggal(date("Y-m-d")), '', 1, 'C'); } $pdf->SetX($margin); $pdf->Cell($w3[0], $ln, 'Pejabat Penilai', '', 0, 'C'); $pdf->SetX($margin + $w3[0] + $w3[1]); $pdf->Cell($w3[2], $ln, 'Pegawai Negeri Sipil yang dinilai,', '', 1, 'C'); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $ln = 4; $pdf->SetX($margin); $pdf->Cell($w3[0], $ln, trim(nama_peg($row_penilai['nib_penilai'])), '', 0, 'C'); $pdf->SetX($margin + $w3[0] + $w3[1]); $pdf->Cell($w3[2], $ln, trim(nama_peg($row['nib'])), '', 1, 'C'); $pdf->SetX($margin); $pdf->Cell($w3[0], $ln, 'NIP. ' . reformat_nipbaru(nip_peg($row_penilai['nib_penilai'])), '', 0, 'C');
header("Content-type: application/octet-stream"); $filename = "laporan_aktifitas_" . $nib . "_" . $tgl1 . "_" . $tgl2 . ".xls"; header("Content-Disposition: attachment; filename=\"{$filename}\""); header("Pragma: no-cache"); header("Expires: 0"); print "<b>"; ?> <table width="755" cellspacing="1"> <tr> <td colspan="2" align="center"><strong>BUKU HARIAN CATATAN PELAKSANAAN TUGAS</strong></td> </tr> <tr> <td colspan="2" align="center"><strong>Tanggal <?php echo reformat_tanggal($tgl1) . ' s/d ' . reformat_tanggal($tgl2); ?> </strong></td> </tr> <tr> <td colspan="2" align="left"><strong>PEJABAT YANG DINILAI</strong></td> </tr> <tr> <td width="140" class="key">Nama</td> <td width="606"><?php echo nama_peg($row['nip']); ?> </td> </tr> <tr> <td class="key">NIP</td>
<td class="key"> </td> <td class="key">Unit Kerja</td> <td><?php echo skt_unitkerja(substr($row['kdunitkerja'], 0, 2)) . ' - BATAN'; ?> </td> </tr> <tr> <td colspan="4" align="center" class="row7"><strong>Penilaian Kemajuan Capaian SKP Detil </strong></td> </tr> <tr> <td colspan="4" align="center" class="row7"><strong>Dari tanggal <?php echo reformat_tanggal($row['tgl_kemajuan_awal']); ?> s/d tanggal <?php echo reformat_tanggal($row['tgl_kemajuan_akhir']); ?> </td> </tr> <tr> <td colspan="4" class="key"> <table width="88%" cellpadding="1" class="adminlist"> <thead> <?php $sql = "SELECT * FROM dtl_skp WHERE id_skp = '{$id_skp}' order by no_tugas"; $qu_3 = mysql_query($sql); ?> <tr> <th width="3%" rowspan="2">No.</th> <th width="10%" rowspan="2">Tugas Jabatan </th>
$pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]); $pdf->Cell($w1[6], $ln * 2, number_format($total_pajak, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6]); $pdf->Cell($w1[7], $ln * 2, number_format($total_tunker - $total_terima, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7]); $pdf->Cell($w1[8], $ln * 2, number_format($total_tunker - $total_terima + $total_pajak, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8]); $pdf->Cell($w1[9], $ln * 2, number_format($total_terima, "0", ",", "."), 'LR', 1, 'R'); $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8] + $w1[9], $pdf->GetY()); //------------ Tanda Tangan ---- $ln = 3.5; $pdf->Ln() + 10; $w1 = array(20, 60, 25, 60, 25, 60, 10); $pdf->SetFont($font, '', $size); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]); $pdf->Cell($w1[5], $ln, kota_satker($xusername) . ', ' . reformat_tanggal(date('Y-m-d')), '', 1, 'C'); $max = 0; $arrJabatan_1 = $pdf->SplitToArray($w1[1], $ln, 'Kuasa Pengguna Anggaran'); $arrJabatan_2 = $pdf->SplitToArray($w1[3], $ln, 'Pejabat Pembuat Komitmen'); $arrJabatan_3 = $pdf->SplitToArray($w1[5], $ln, 'Bendahara Pengeluaran'); if ($max < count($arrJabatan_1)) { $max = count($arrJabatan_1); } if ($max < count($arrJabatan_2)) { $max = count($arrJabatan_2); } if ($max < count($arrJabatan_3)) { $max = count($arrJabatan_3); } for ($i = 0; $i < $max; $i++) { $pdf->SetX($margin + $w1[0]);
$kdmenteri = setup_kddept_unit() . '1000'; $th = $_SESSION['xth']; $sql = "select THANG, KDSATKER, sum(NILMAK) as real_satker from {$table} WHERE THANG='{$th}' AND left(KDAKUN,1) = '5' group by KDSATKER"; $aSatker = mysql_query($sql); $count = mysql_num_rows($aSatker); $jmlh = 0; while ($Satker = mysql_fetch_array($aSatker)) { $col[0][] = $Satker['THANG']; $col[1][] = $Satker['KDSATKER']; $col[2][] = $Satker['real_satker']; $jmlh += $Satker['real_satker']; } $sql = "select tgl_upload from dt_fileupload_keu WHERE kdfile = 'M_SPMIND' "; $aUpload = mysql_query($sql); $Upload = mysql_fetch_array($aUpload); echo "<strong> Upload SAKPA terakhir pada panggal : " . reformat_tanggal(substr($Upload['tgl_upload'], 0, 10)) . "</strong><br>"; echo "<strong> Pukul : " . substr($Upload['tgl_upload'], 10, 9) . "</strong><br>"; ?> <br /> <table width="787" cellpadding="1" class="adminlist"> <thead> <tr> <th rowspan="2">Kode APBN</th> <th rowspan="2">Nama Satuan Kerja / <br> <font color="#0000FF">Nama Kegiatan</font> / <br /><font color="#993333">Output</font></th> <th rowspan="2">Pagu<br />Anggaran</th> <th colspan="2">Realisasi<br />Anggaran</th> <th width="10%" rowspan="2">Data Detil</th> </tr> <tr> <th>Rupiah</th>
$ln = 5; $margin = 15; $tinggi = 275; $w = array(0, 180); $pdf->Ln(); $pdf->SetFont($font, 'B', $size + 2); $pdf->SetX($margin + $w[0]); $pdf->Cell($w[1], $ln, 'KEMAJUAN SASARAN KERJA', '', 1, 'C'); $pdf->SetX($margin + $w[0]); $pdf->Cell($w[1], $ln, 'PEGAWAI NEGERI SIPIL', '', 1, 'C'); $sql = "SELECT * FROM mst_skp WHERE id = '{$id_skp}'"; $qu = mysql_query($sql); $row = mysql_fetch_array($qu); $pdf->SetFont($font, 'B', $size + 1); $pdf->SetX($margin + $w[0]); $pdf->Cell($w[1], $ln, 'Jangka waktu penilaian : ' . reformat_tanggal($row['tgl_kemajuan_awal']) . ' s/d ' . reformat_tanggal($row['tgl_kemajuan_akhir']), '', 1, 'C'); $pdf->Ln() * 2; $pdf->SetFont($font, 'B', $size); $pdf->SetX($margin + $w[0]); $pdf->Cell($w[1], $ln, 'A. DATA UMUM', '', 1, 'L'); $w1 = array(10, 30, 45, 15, 30, 50); $pdf->SetFont($font, 'B', $size); $pdf->SetX($margin); $pdf->Cell($w1[0], $ln, 'NO.', $border, 0, 'C'); $pdf->SetX($margin + $w1[0]); $pdf->Cell($w1[1] + $w1[2], $ln, 'I. PEJABAT PENILAI', $border, 0, 'L'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]); $pdf->Cell($w1[3], $ln, 'NO.', $border, 0, 'C'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]); $pdf->Cell($w1[4] + $w1[5], $ln, 'II. PEGAWAI NEGERI SIPIL YANG DINILAI', $border, 1, 'L'); $pdf->SetFont($font, '', $size);
?> </td> <td align="center"><a href="file_dipa/<?php echo $col[0][$k] . "/" . $Satker['nama_file']; ?> " title="Download ADK"><font size="1"> <?php echo $Satker['nama_file']; ?> </font></a></td> <td align="center"><?php echo $Satker['user_upload']; ?> </td> <td align="center"><?php echo reformat_tanggal(substr($Satker['tgl_upload'], 0, 10)); ?> <br><?php echo substr($Satker['tgl_upload'], 10, 9); ?> </td> <td align="center"> <a href="index.php?p=563&kdsatker=<?php echo $col[0][$k]; ?> &th=<?php echo $th; ?> " title="Data ADK SP2D Detil"><font size="1"> ADK>></font></a> </td> </tr>
$pdf->Cell($w1[5], $ln * 2, number_format($total_tgrade, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]); $pdf->Cell($w1[5], $ln * 2, number_format($total_fpot, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2); $pdf->Cell($w1[5], $ln * 2, number_format($total_tunker, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 3); $pdf->Cell($w1[5], $ln * 2, number_format($total_pajak, "0", ",", "."), 'LR', 0, 'R'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 4); $pdf->Cell($w1[5], $ln * 2, number_format($total_tunker + $total_pajak, "0", ",", "."), 'LR', 1, 'R'); $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 5, $pdf->GetY()); } $pdf->Ln() + 20; $w1 = array(15, 60, 30, 60, 30, 60, 10); $pdf->SetFont($font, '', $size); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]); $pdf->Cell($w1[5], $ln, kota_satker($kdsatker) . ', ' . reformat_tanggal($tgl), '', 1, 'C'); $max = 0; $arrJabatan_1 = $pdf->SplitToArray($w1[1], $ln, 'Kuasa Pengguna Anggaran'); $arrJabatan_2 = $pdf->SplitToArray($w1[3], $ln, 'Pejabat Pembuat Komitmen'); $arrJabatan_3 = $pdf->SplitToArray($w1[5], $ln, 'Bendahara Pengeluaran'); if ($max < count($arrJabatan_1)) { $max = count($arrJabatan_1); } if ($max < count($arrJabatan_2)) { $max = count($arrJabatan_2); } if ($max < count($arrJabatan_3)) { $max = count($arrJabatan_3); } for ($i = 0; $i < $max; $i++) { $pdf->SetX($margin + $w1[0]);