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]);
