if ($k % 2 == 1) {
$class = "row0";
} else {
$class = "row1";
}
?>
<tr class="<?php
echo $class;
?>
">
<td width="8%" align="center"><strong><?php
echo $col[1][$k];
?>
</strong></td>
<td width="59%" align="left"><strong><?php
echo nm_satker($col[1][$k]);
?>
</strong></td>
<td width="10%" align="right"><strong><?php
echo number_format($col[2][$k], "0", ",", ".");
?>
</strong></td>
<td colspan="2" align="right"> </td>
</tr>
<?php
$kdsatker = $col[1][$k];
$sql = "select KDGIAT, sum(JUMLAH) as pagu_giat from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' group by KDGIAT";
$aGiat = mysql_query($sql);
while ($Giat = mysql_fetch_array($aGiat)) {
?>
<tr class="<?php
?>
&pagess=<?php
echo $pagess;
?>
" method="post">
<input type="hidden" name="p" value="<?php
echo $p;
?>
" />
Satker :
<select name="kdsatker">
<option value="<?php
echo $kdsatker;
?>
"><?php
echo substr(nm_satker($kdsatker), 0, 60);
?>
</option>
<option value="">- Pilih Satker -</option>
<?php
$query = mysql_query("select left(nmsatker,60) as nama_satker, kdsatker from kd_satker group by kdsatker order by kdsatker");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['kdsatker'];
?>
"><?php
echo $row['nama_satker'];
?>
</option>
<?php
?> " readonly/> Tahun <input type="text" name="<?php echo $field[1]; ?> " size="10" value="<?php echo $value[1]; ?> " readonly/></td> </tr> <tr> <td class="key">Satuan Kerja </td> <td><input type="text" name="<?php echo $field[5]; ?> " size="60" value="<?php echo nm_satker($value[5]); ?> " readonly/></td> </tr> <tr> <td class="key">Nama Pegawai </td> <td><input type="text" name="<?php echo $field[3]; ?> " size="60" value="<?php echo nama_peg($value[3]); ?> " readonly/></td> </tr> <tr> <td class="key">Unit Kerja </td>
echo $value[1];
}
?>
" readonly/></td>
</tr>
<tr>
<td class="key">Satker</td>
<td colspan="3"><input type="text" name="<?php
echo $field[2];
?>
" size="20" value="<?php
echo $value[2];
?>
" readonly/><br /><textarea rows="1" cols="70" readonly><?php
echo nm_satker($value[2]);
?>
</textarea></td>
</tr>
<tr>
<td class="key">Nama Pekerjaan </td>
<td colspan="3"><textarea name="<?php
echo $field[3];
?>
" rows="2" cols="70" readonly><?php
echo $value[3];
?>
</textarea> </td>
</tr>
<tr>
<td class="key">Pagu</td>
echo $class;
?>
">
<td align="center"><?php
echo ($pagess - 1) * $limit + ($k + 1);
?>
</td>
<td align="center"><?php
if ($col[2][$k] != $col[2][$k - 1]) {
echo $col[2][$k];
}
?>
</td>
<td align="left"><?php
if ($col[2][$k] != $col[2][$k - 1]) {
echo nm_satker($col[2][$k]);
}
?>
</td>
<td align="left"><?php
echo $col[3][$k];
?>
</td>
<td align="right"><?php
echo number_format($col[4][$k], "0", ",", ".");
?>
</td>
<td align="center"><?php
echo reformat_tgl($col[5][$k]) . '<strong> s/d </strong>' . reformat_tgl($col[48][$k]);
?>
</td>
}
$aSatker = mysql_query($sql);
while ($Satker = mysql_fetch_array($aSatker)) {
$kdsatker = $Satker['KDSATKER'];
$real_satker = realisasi_satker_tw($th, $kdsatker, $kdtriwulan);
?>
<tr class="<?php
echo $class;
?>
">
<td align="center" valign="top"><span class="style1"><?php
echo $kdsatker;
?>
</span></td>
<td align="left" valign="top"><span class="style1"><?php
echo nm_satker($kdsatker);
?>
</span></td>
<td align="right" valign="top"><span class="style1"><?php
echo number_format($Satker['pagu_satker'], "0", ",", ".");
?>
</span></td>
<td align="right" valign="top"><span class="style1"><?php
echo number_format($Satker['rencana_satker'], "0", ",", ".");
?>
</span></td>
<td align="center" valign="top"><span class="style1"><?php
echo number_format($Satker['rencana_satker'] / $Satker['pagu_satker'] * 100, "2", ",", ".");
?>
</span></td>
<td align="right" valign="top"><span class="style1"><?php
break;
case 11:
$sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4, $real_5, $real_6, $real_7, $real_8, $real_9, $real_10, $real_11);
break;
case 12:
$sbx_grafik_2 = array($real_1, $real_2, $real_3, $real_4, $real_5, $real_6, $real_7, $real_8, $real_9, $real_10, $real_11, $real_12);
break;
}
$sbx_grafik_1 = array($pagu_1, $pagu_2, $pagu_3, $pagu_4, $pagu_5, $pagu_6, $pagu_7, $pagu_8, $pagu_9, $pagu_10, $pagu_11, $pagu_12);
$leg = array("Jan", "Peb", "Mar", "Apr", "Mei", "Jun", "Jul", "Agt", "Sep", "Okt", "Nop", "Des");
$graph = new Graph(1500, 800, "auto");
$graph->SetScale('textint');
$graph->img->SetMargin(50, 50, 50, 50);
$graph->SetShadow();
$graph->title->Set("Realisasi Anggaran Tahun " . $th);
$graph->subtitle->Set('Satker : ' . trim(nm_satker($kdsatker)));
$graph->title->SetFont(FF_ARIAL, FS_BOLD, 20);
$graph->subtitle->SetFont(FF_ARIAL, FS_BOLD, 14);
$graph->xaxis->title->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->yaxis->title->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->xaxis->SetTickLabels($leg);
$graph->legend->Pos(0.1, 0.09);
$graph->legend->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->xaxis->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->xaxis->title->Set("Bulan");
$graph->yaxis->SetFont(FF_ARIAL, FS_BOLD, 15);
$graph->legend->Pos(0.8, 0.13, "right", "center");
$bplot1 = new LinePlot($sbx_grafik_1);
$bplot1->mark->SetType(MARK_FILLEDCIRCLE);
$bplot1->mark->SetFillColor("red");
$bplot1->mark->SetWidth(8);
" size="40" value="<?php
echo $value[3];
?>
" /></td>
</tr>
<tr>
<td class="key">Kode Satker</td>
<td><select name="<?php
echo $field[4];
?>
">
<option value="<?php
echo $value[4];
?>
"><?php
echo '[' . $value[4] . '] ' . substr(nm_satker($value[4]), 0, 70);
?>
</option>
<option value="">- Pilih Satker -</option>
<?php
switch ($xlevel) {
default:
$query = mysql_query("select KDSATKER, left(NMSATKER,70) as nama_satker from t_satker WHERE KDDEPT = '{$kddept}' AND KDUNIT = '{$kdunitx}' order by NMSATKER");
break;
}
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['KDSATKER'];
?>
"><?php
$kdsatker = kd_satker(substr($xusername, 3, 7));
$pagu = pagu_satker($th, $kdsatker);
$real_sp2d = real_satker_sp2d($th, $kdsatker);
$real_spm = real_satker_spm($th, $kdsatker);
break;
case 6:
$teks_1 = 'Operator Program';
$teks_2 = nm_satker(substr($xusername, 4, 6));
$kdsatker = substr($xusername, 4, 6);
$pagu = pagu_satker($th, $kdsatker);
$real_sp2d = real_satker_sp2d($th, $kdsatker);
$real_spm = real_satker_spm($th, $kdsatker);
break;
case 7:
$teks_1 = 'Operator Keuangan';
$teks_2 = nm_satker(substr($xusername, 4, 6));
$kdsatker = substr($xusername, 4, 6);
$pagu = pagu_satker($th, $kdsatker);
$real_sp2d = real_satker_sp2d($th, $kdsatker);
$real_spm = real_satker_spm($th, $kdsatker);
break;
case 8:
$teks_1 = 'Pimpinan';
$teks_2 = nm_unit(substr($xusername, 3, 7));
$kdsatker = kd_satker(substr($xusername, 3, 7));
$pagu = pagu_satker($th, $kdsatker);
$real_sp2d = real_satker_sp2d($th, $kdsatker);
$real_spm = real_satker_spm($th, $kdsatker);
break;
case 9:
$teks_1 = $xusername;
function Header()
{
$kdbulan1 = $_REQUEST['kdbulan1'];
$kdbulan2 = $_REQUEST['kdbulan2'];
$kdsatker = $_REQUEST['kdsatker'];
if (substr($kdbulan1, 0, 1) == '0') {
$kdbl1 = substr($kdbulan1, 1, 1);
} else {
$kdbl1 = $kdbulan1;
}
if (substr($kdbulan2, 0, 1) == '0') {
$kdbl2 = substr($kdbulan2, 1, 1);
} else {
$kdbl2 = $kdbulan2;
}
$th = $_REQUEST['th'];
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 5;
$margin = 10;
$tinggi = 275;
$w = array(0, 280);
$this->SetFont($font, 'B', $size + 3);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'BADAN TENAGA NUKLIR NASIONAL', '', 1, 'L');
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, strtoupper(trim(nm_satker($kdsatker))), '', 1, 'L');
$this->Ln();
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'REKAPITULASI PEMBAYARAN TUNJANGAN KINERJA PEGAWAI', '', 1, 'C');
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl1)) . ' S/D ' . strtoupper(nama_bulan($kdbl2)) . ' ' . $th, '', 1, 'C');
$this->SetX($margin);
$this->Cell($w1[0], $ln, '', $noborder, 1, 'C');
$ln = 4;
$w1 = array(10, 30, 25, 35, 30, 35, 25, 25, 25, 35);
$this->SetFont($font, 'B', $size);
$this->SetX($margin);
$this->Cell($w1[0], $ln * 3, 'No..', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$this->Cell($w1[1], $ln * 3, 'Bulan', $border, 0, 'C');
$y = $this->GetY();
$this->SetXY($margin + $w1[0] + $w1[1], $y + 2);
$this->Cell($w1[2], $ln, 'Jumlah', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y + 6);
$this->Cell($w1[2], $ln, 'Penerima', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y);
$this->Cell($w1[2], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 2);
$this->Cell($w1[3], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 6);
$this->Cell($w1[3], $ln, 'Sebelum Pajak', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y);
$this->Cell($w1[3], $ln * 3, '', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$this->Cell($w1[4], $ln * 3, 'Tunjangan Pajak', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]);
$this->Cell($w1[5], $ln * 3, 'Jumlah Bruto', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[6] + $w1[6] + $w1[6], $ln, 'POTONGAN', $border, 1, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[6], $ln * 2, 'Pajak', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6], $y + 4);
$this->Cell($w1[7], $ln, 'Faktor', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6], $y + 8);
$this->Cell($w1[7], $ln, 'Pengurang', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6], $y + 4);
$this->Cell($w1[7], $ln * 2, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7], $y + 4);
$this->Cell($w1[8], $ln, 'Jumlah', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7], $y + 8);
$this->Cell($w1[8], $ln, 'Potongan', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7], $y + 4);
$this->Cell($w1[8], $ln * 2, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8], $y + 2);
$this->Cell($w1[9], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8], $y + 6);
$this->Cell($w1[9], $ln, 'Yang Diterima', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8], $y);
$this->Cell($w1[9], $ln * 3, '', $border, 1, 'C');
$this->SetFont($font, 'B', $size - 2);
$this->SetX($margin);
$this->Cell($w1[0], $ln, '(1)', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$this->Cell($w1[1], $ln, '(2)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln, '(3)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$this->Cell($w1[3], $ln, '(4)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$this->Cell($w1[4], $ln, '(5)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]);
$this->Cell($w1[5], $ln, '(6=4+5)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[6], $ln, '(7)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6]);
$this->Cell($w1[7], $ln, '(8)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7]);
$this->Cell($w1[8], $ln, '(9=7+8)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7] + $w1[8]);
$this->Cell($w1[9], $ln, '(10=6-9)', $border, 1, 'C');
$this->SetX($margin);
$this->Cell($w1[0], $ln * 2, '', $noborder, 0, 'C');
}
function Header()
{
$kdunit = $_REQUEST['kdunit'];
$kdbulan = $_REQUEST['kdbulan'];
$kdsatker = $_REQUEST['kdsatker'];
$th = $_REQUEST['th'];
if (substr($kdbulan, 0, 1) == '0') {
$kdbl = substr($kdbulan, 1, 1);
}
if (substr($kdbulan, 0, 1) != '0') {
$kdbl = $kdbulan;
}
$th = $_REQUEST['th'];
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 5;
$margin = 10;
$tinggi = 275;
$w = array(0, 250);
$this->SetFont($font, 'B', $size + 3);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'BADAN TENAGA NUKLIR NASIONAL', '', 1, 'L');
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, strtoupper(trim(nm_satker($kdsatker))), '', 1, 'L');
$this->Ln();
$this->SetFont($font, 'B', $size + 2);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'REKAPITULASI DAFTAR PENERIMAAN TUNJANGAN KINERJA PEGAWAI', '', 1, 'C');
$this->SetX($margin + $w[0]);
if ($kdbl != 13) {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl)) . ' ' . $th, '', 1, 'C');
}
if ($kdbl == 13) {
$this->Cell($w[1], $ln, 'BULAN : ' . nama_bulan($kdbl) . ' TAHUN ' . $th, '', 1, 'C');
}
$this->Ln() + 5;
$ln = 4;
$w1 = array(10, 30, 20, 32, 22, 32);
$this->SetFont($font, 'B', $size - 1);
$this->SetX($margin);
$this->Cell($w1[0], $ln * 3, 'NO.', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$this->Cell($w1[1], $ln * 3, 'Kelas Jabatan', $border, 0, 'C');
$y = $this->GetY();
$this->SetXY($margin + $w1[0] + $w1[1], $y + 2);
$this->Cell($w1[2], $ln, 'Jumlah', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y + 6);
$this->Cell($w1[2], $ln, 'Penerima', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y);
$this->Cell($w1[2], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 2);
$this->Cell($w1[3], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 6);
$this->Cell($w1[3], $ln, 'Per Kelas Jabatan', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y);
$this->Cell($w1[3], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y + 2);
$this->Cell($w1[5], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y + 6);
$this->Cell($w1[5], $ln, 'Sebelum Pajak', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y);
$this->Cell($w1[5], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5], $y + 2);
$this->Cell($w1[4], $ln, 'Tunjangan', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5], $y + 6);
$this->Cell($w1[4], $ln, 'Pajak', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5], $y);
$this->Cell($w1[4], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y);
$this->Cell($w1[5], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 4);
$this->Cell($w1[5], $ln, 'Setelah Ditambah', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 8);
$this->Cell($w1[5], $ln, 'Tunjangan Pajak', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y);
$this->Cell($w1[5], $ln * 3, '', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2);
$this->Cell($w1[4] * 3, $ln, 'POTONGAN', $border, 1, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2);
$this->Cell($w1[4], $ln * 2, 'Pajak', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 2 + $w1[5] * 2);
$this->Cell($w1[4], $ln * 2, 'Pengurang', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 3 + $w1[5] * 2, $y + 4);
$this->Cell($w1[4], $ln, 'Jumlah', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 3 + $w1[5] * 2, $y + 8);
$this->Cell($w1[4], $ln, 'Potongan', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 3 + $w1[5] * 2, $y + 4);
$this->Cell($w1[4], $ln * 2, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 2, $y + 2);
$this->Cell($w1[5], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 2, $y + 6);
$this->Cell($w1[5], $ln, 'Yang Diterima', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 2, $y);
$this->Cell($w1[5], $ln * 3, '', $border, 1, 'C');
$this->SetFont($font, 'B', $size - 2);
$this->SetX($margin);
$this->Cell($w1[0], $ln, '(1)', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$this->Cell($w1[1], $ln, '(2)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln, '(3)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$this->Cell($w1[3], $ln, '(4)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$this->Cell($w1[5], $ln, '(5)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5]);
$this->Cell($w1[4], $ln, '(6)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[5], $ln, '(7=5+6)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2);
$this->Cell($w1[4], $ln, '(8)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 2 + $w1[5] * 2);
$this->Cell($w1[4], $ln, '(9)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 3 + $w1[5] * 2);
$this->Cell($w1[4], $ln, '(10=8+9)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] * 4 + $w1[5] * 2);
$this->Cell($w1[5], $ln, '(11=7-10)', $border, 1, 'C');
}
$oList_kak_output = mysql_query("SELECT kdunitkerja FROM thbp_kak_output WHERE th = '{$th}' and kdsatker = '{$kdsatker}' AND kdgiat = '{$kdgiat}' and kdoutput = '{$kdoutput}' ");
$List_kak_output = mysql_fetch_array($oList_kak_output);
?>
<div class="button2-right">
<div class="prev"><a onclick="Back('index.php?p=<?php
echo $p_next;
?>
&pagess=<?php
echo $pagess;
?>
')">Kembali</a></div>
</div><br><br>
<?php
echo "<strong> Tahun Anggaran : " . $th . "</strong><br>";
echo "<strong> Unit Kerja : [" . $List_kak_output['kdunitkerja'] . '] ' . nm_unit($List_kak_output['kdunitkerja']) . "</strong><br>";
echo "<strong> Satker : [" . $kdsatker . '] ' . nm_satker($kdsatker) . "</strong><br>";
echo "<strong> Kegiatan : [" . $kdgiat . '] ' . nm_giat($kdgiat) . "</strong>";
?>
<br />
<table width="738" cellpadding="1" class="adminlist">
<thead>
<tr>
<th width="10%">Kode APBN</th>
<th colspan="4">Ooutput / Sub Output <br>
Komponen / Sub Komponen <br>
Akun / Uraian </th>
<th width="14%">Anggaran</th>
</tr>
</thead>
<tbody>
function Header()
{
$kdunit = $_REQUEST['kdunit'];
$kdbulan = $_REQUEST['kdbulan'];
$kdsatker = $_REQUEST['kdsatker'];
if (substr($kdbulan, 0, 1) == '0') {
$kdbl = substr($kdbulan, 1, 1);
}
if (substr($kdbulan, 0, 1) != '0') {
$kdbl = $kdbulan;
}
$th = $_REQUEST['th'];
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 4;
$margin = 15;
$tinggi = 275;
$w = array(0, 280);
$this->SetFont($font, 'B', $size + 3);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln + 1, 'BADAN TENAGA NUKLIR NASIONAL', '', 1, 'L');
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln + 1, strtoupper(trim(nm_satker($kdsatker))), '', 1, 'L');
$this->SetFont($font, 'B', $size + 2);
$this->Ln() + 5;
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln + 1, 'DAFTAR NOMINATIF PEMBAYARAN TUNJANGAN KINERJA PEGAWAI', '', 1, 'C');
$this->SetX($margin + $w[0]);
if ($kdbl != 13) {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl)) . ' ' . $th, '', 1, 'C');
}
if ($kdbl == 13) {
$this->Cell($w[1], $ln, 'BULAN : ' . nama_bulan($kdbl) . ' TAHUN ' . $th, '', 1, 'C');
}
$this->SetY(28);
$this->SetFont($font, '', $size - 3);
$this->Cell(0, 8, 'Hal. ' . $this->PageNo(), 0, 1, 'R');
$w1 = array(10, 50, 12, 40, 10, 30);
$this->SetFont($font, 'B', $size);
$this->SetX($margin);
$this->Cell($w1[0], $ln * 3, 'NO.', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$y = $this->GetY();
$this->Cell($w1[1], $ln, 'Nama Pegawai', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0], $y + 4);
$this->Cell($w1[1], $ln, 'NIP', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0], $y);
$this->Cell($w1[1], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y + 2);
$this->Cell($w1[2], $ln, 'Gol /', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y + 6);
$this->Cell($w1[2], $ln, 'Status', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1], $y);
$this->Cell($w1[2], $ln * 3, '', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$this->Cell($w1[3], $ln * 3, 'Nama Jabatan / TMT', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y + 2);
$this->Cell($w1[4], $ln, 'Kls.', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y + 6);
$this->Cell($w1[4], $ln, 'Jab.', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y);
$this->Cell($w1[4], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4], $y + 4);
$this->Cell($w1[5], $ln, 'Tunj. Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4], $y);
$this->Cell($w1[5], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 4);
$this->Cell($w1[5], $ln, 'Fakt. Pengurang', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y);
$this->Cell($w1[5], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2, $y);
$this->Cell($w1[5], $ln, 'Tunj. Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2, $y + 4);
$this->Cell($w1[5], $ln, 'Dikurangi', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2, $y + 8);
$this->Cell($w1[5], $ln, 'Fakt.Pengurang', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2, $y);
$this->Cell($w1[5], $ln * 3, '', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 3);
$this->Cell($w1[5], $ln * 3, 'Tunj. Pajak', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 4, $y);
$this->Cell($w1[5], $ln, 'Tunj. Kinerja', $noborder, 1, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 4, $y + 4);
$this->Cell($w1[5], $ln, 'Ditambah', $noborder, 1, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 4, $y + 8);
$this->Cell($w1[5], $ln, 'Tunjangan Pajak', $noborder, 1, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 4, $y);
$this->Cell($w1[5], $ln * 3, '', $border, 1, 'C');
$this->SetFont($font, 'B', $size - 2);
$this->SetX($margin);
$this->Cell($w1[0], $ln, '(1)', $border, 0, 'C');
$this->Cell($w1[1], $ln, '(2)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln, '(3)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$this->Cell($w1[3], $ln, '(4)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$this->Cell($w1[4], $ln, '(5)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]);
$this->Cell($w1[5], $ln, '(6)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[5], $ln, '(7)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 2);
$this->Cell($w1[5], $ln, '(8=6-7)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 3);
$this->Cell($w1[5], $ln, '(9)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] * 4);
$this->Cell($w1[5], $ln, '(10=8+9)', $border, 1, 'C');
}
function Header()
{
$th = $_REQUEST['th'];
$kdbulan1 = $_REQUEST['kdbulan1'];
$kdbulan2 = $_REQUEST['kdbulan2'];
$kdsatker = $_REQUEST['kdsatker'];
if (substr($kdbulan1, 0, 1) == '0') {
$kdbl1 = substr($kdbulan1, 1, 1);
} else {
$kdbl1 = $kdbulan1;
}
if (substr($kdbulan2, 0, 1) == '0') {
$kdbl2 = substr($kdbulan2, 1, 1);
} else {
$kdbl2 = $kdbulan2;
}
$th = $_REQUEST['th'];
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 4;
$margin = 5;
$tinggi = 275;
$w = array(0, 180);
$this->SetFont($font, 'B', $size + 3);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln + 1, 'BADAN TENAGA NUKLIR NASIONAL', '', 1, 'L');
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln + 1, strtoupper(trim(nm_satker($kdsatker))), '', 1, 'L');
$this->SetFont($font, 'B', $size);
$this->Ln() + 5;
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln + 1, 'SLIP PENERIMAAN TUNJANGAN KINERJA PEGAWAI', '', 1, 'C');
$this->SetX($margin + $w[0]);
if ($kdbl1 != $kdbl2) {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl1)) . ' S/D ' . strtoupper(nama_bulan($kdbl2)) . ' ' . $th, '', 1, 'C');
} elseif ($kdbl1 == 13) {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl1)) . ' TAHUN ' . $th, '', 1, 'C');
} else {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl1)) . ' ' . $th, '', 1, 'C');
}
$this->SetY(28);
$this->SetFont($font, '', $size - 3);
$this->Cell(0, 8, 'Hal. ' . $this->PageNo(), 0, 1, 'R');
$w1 = array(10, 27, 50, 15, 18, 18, 18, 18, 28);
$this->SetFont($font, 'B', $size - 1);
$this->SetX($margin);
$this->Cell($w1[0], $ln * 2, 'NO.', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$y = $this->GetY();
$this->Cell($w1[1], $ln, 'Nama Pegawai', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0], $y + 4);
$this->Cell($w1[1], $ln, 'NIP', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0], $y);
$this->Cell($w1[1], $ln * 2, '', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln * 2, 'Jabatan', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y);
$this->Cell($w1[3], $ln, 'Kelas', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 4);
$this->Cell($w1[3], $ln, 'Jabatan', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y);
$this->Cell($w1[3], $ln * 2, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y);
$this->Cell($w1[4], $ln, 'Pajak', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y + 4);
$this->Cell($w1[4], $ln, 'Tunkin', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y);
$this->Cell($w1[4], $ln * 2, '', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]);
$this->Cell($w1[5], $ln * 2, 'Tunkin', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[6], $ln * 2, 'Potongan', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6]);
$this->Cell($w1[7], $ln * 2, 'Diterima', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7]);
$this->Cell($w1[8], $ln * 2, 'Rekening', $border, 1, 'C');
$this->SetFont($font, 'B', $size - 2);
$this->SetX($margin);
$this->Cell($w1[0], $ln, '(1)', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$this->Cell($w1[1], $ln, '(2)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln, '(3)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$this->Cell($w1[3], $ln, '(4)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$this->Cell($w1[4], $ln, '(5)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]);
$this->Cell($w1[5], $ln, '(6)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5]);
$this->Cell($w1[6], $ln, '(7)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6]);
$this->Cell($w1[7], $ln, '(8=6-7)', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] + $w1[7]);
$this->Cell($w1[8], $ln, '(9)', $border, 1, 'C');
}
$filename = "rekap_penerima_" . $kdsatker . "_" . $kdbulan . ".xls";
header("Content-Disposition: attachment; filename=\"{$filename}\"");
header("Pragma: no-cache");
header("Expires: 0");
print "<b>";
print "<b>";
print "REKAP PENERIMA TUNJANGAN KINERJA PEGAWAI<br>";
print "BADAN TENAGA NUKLIR NASIONAL<br>";
$b = (int) $kdbulan;
if ($b != 13) {
print "BULAN " . strtoupper(nama_bulan($b)) . " {$th}<br><br>";
}
if ($b == 13) {
print "BULAN " . strtoupper(nama_bulan($b)) . "TAHUN " . " {$th}<br><br>";
}
print "SATUAN KERJA : " . strtoupper(nm_satker($kdsatker)) . "<br><br>";
?>
<table width="70%" cellpadding="1" border="1">
<thead>
<tr>
<th width="7%" rowspan="2">No.</th>
<th width="37%" rowspan="2">Kelas Jabatan </th>
<th width="10%" rowspan="2">Jumlah<br />Penerima</th>
<th width="12%" rowspan="2">Tunjangan Kinerja<br />Per Kelas Jabatan</th>
<th width="11%" rowspan="2">Tunjangan<br />Kinerja<br />Sebelum Pajak</th>
<th width="11%" rowspan="2">Tunjangan<br />Pajak</th>
<th width="12%" rowspan="2">Jumlah Bruto</th>
<th colspan="3">Potongan</th>
<th width="12%" rowspan="2">Tunjangan Kinerja<br />Dibayarkan</th>
</tr>
<tr>
-->
</style>
<form action="" method="post" name="form" enctype="multipart/form-data">
<table width="656" cellspacing="1" class="admintable">
<tr>
<td class="key">Tahun Anggaran</td>
<td><?php
echo $th;
?>
</td>
</tr>
<tr>
<td class="key">Satker</td>
<td><?php
echo '[' . $kdsatker . '] ' . nm_satker($kdsatker);
?>
</td>
</tr>
<tr>
<td class="key"> </td>
<td> </td>
</tr>
<tr>
<td class="key"> </td>
<td><strong>Lokasi file pada folder //RKAKL</strong></td>
</tr>
<tr>
<td class="key">File ADK RKAKL </td>
<td> <input type="file" name="adk" size="60" /></td>
</tr>
function Header()
{
$kdunit = $_REQUEST['kdunit'];
$kdsatker = $_REQUEST['kdsatker'];
$kdbulan = $_REQUEST['kdbulan'];
if (substr($kdbulan, 0, 1) == '0') {
$kdbl = substr($kdbulan, 1, 1);
}
if (substr($kdbulan, 0, 1) != '0') {
$kdbl = $kdbulan;
}
$th = $_REQUEST['th'];
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 4;
$margin = 5;
$tinggi = 275;
$w = array(0, 280);
$this->Ln();
$this->SetFont($font, 'B', $size + 2);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'REKAPITULASI KEHADIRAN PEGAWAI', '', 1, 'C');
$this->SetX($margin + $w[0]);
if ($kdunit != '') {
$this->Cell($w[1], $ln, trim(strtoupper(nm_unitkerja($kdunit . '00'))), '', 1, 'C');
}
if ($kdsatker != '') {
$this->Cell($w[1], $ln, 'SATKER : ' . trim(strtoupper(nm_satker($kdsatker))), '', 1, 'C');
}
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'Bulan : ' . nama_bulan($kdbl) . ' ' . $th, '', 1, 'C');
// $this->Ln();
$this->SetY(20);
$this->SetFont($font, '', $size - 3);
$this->Cell(0, 10, 'Hal. ' . $this->PageNo(), 0, 1, 'R');
// if ($this->PageNo() != 1) $this->Line($margin, $this->GetY(), $margin+180,$this->GetY());
// $this->Ln();
$w1 = array(10, 45, 45, 15, 15, 20, 10, 15);
$this->SetFont($font, 'B', $size);
$this->SetX($margin);
$this->Cell($w1[0], $ln * 3, 'NO.', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$ya = $this->GetY();
$y = $this->GetY();
$this->Cell($w1[1], $ln * 3, 'Jabatan', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln * 3, 'Nama / NIP', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2]);
$this->Cell($w1[3], $ln * 3, 'Grade', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3]);
$this->Cell($w1[4], $ln * 3, 'Gol', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4]);
$y = $this->GetY();
$this->Cell($w1[5], $ln, 'Tanpa', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4], $y + 4);
$this->Cell($w1[5], $ln, 'Ket.(TK)', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4], $y);
$this->Cell($w1[5], $ln * 2, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4], $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[6], $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y);
// $y = $this->GetY();
$this->Cell($w1[6] * 12, $ln, 'CUTI', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 4);
$this->Cell($w1[6] * 2, $ln, 'CT', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 2, $y + 4);
$this->Cell($w1[6] * 2, $ln, 'CB', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 4, $y + 4);
$this->Cell($w1[6] * 2, $ln, 'CSRI', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 6, $y + 4);
$this->Cell($w1[6] * 2, $ln, 'CSRJ', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 8, $y + 4);
$this->Cell($w1[6] * 2, $ln, 'CM', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 10, $y + 4);
$this->Cell($w1[6] * 2, $ln, 'CP', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6], $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 2, $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 3, $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 4, $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 5, $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 6, $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 7, $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 8, $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 9, $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 10, $y + 8);
$this->Cell($w1[6], $ln, 'Hari', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 11, $y + 8);
$this->Cell($w1[6], $ln, '(%)', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 12, $ya + 2);
$this->Cell($w1[7], $ln, 'Jumlah', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 12, $ya + 6);
$this->Cell($w1[7], $ln, 'Pot.', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5] + $w1[6] * 12, $ya);
$this->Cell($w1[7], $ln * 3, '', $border, 1, 'C');
}
$field = get_field($table);
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$sql = "select sum(TOTNILMAK) as real_output from {$table} WHERE THANG='{$th}' AND KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' and KDOUTPUT = '{$kdoutput}' group by KDOUTPUT";
$aGiat = mysql_query($sql);
$Giat = mysql_fetch_array($aGiat);
?>
<div class="button2-right">
<div class="prev"><a onclick="Back('index.php?p=<?php
echo $p_next;
?>
')">Kembali</a></div>
</div><br><br>
<?php
echo "<strong> Tahun Anggaran : " . $th . "</strong><br>";
echo "<strong> Satker : " . nm_satker($kdsatker) . "</strong><br>";
echo "<strong> Kegiatan : " . nm_giat($kdgiat) . "</strong>";
?>
<br />
<table width="738" cellpadding="1" class="adminlist">
<thead>
<tr>
<th width="6%">Kode APBN</th>
<th colspan="5"><font color="#FF0000">Output</font> / Akun / <font color="#3333FF">SPM & SP2D</font></th>
<th width="12%">Anggaran</th>
</tr>
</thead>
<tbody>
<?php
$sql = "select KDOUTPUT, sum(TOTNILMAK) as real_output from {$table} WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' and KDOUTPUT = '{$kdoutput}' group by KDOUTPUT order by KDOUTPUT";
$field = get_field($table);
$ed_link = "index.php?p=" . get_edit_link($p);
$del_link = "index.php?p=" . get_delete_link($p);
$sql = "select sum(JUMLAH) as pagu_giat, sum(RPHBLOKIR) as blokir_giat from {$table} WHERE THANG='{$th}' AND KDSATKER='{$kdsatker}' and KDGIAT='{$kdgiat}' group by KDGIAT";
$aGiat = mysql_query($sql);
$Giat = mysql_fetch_array($aGiat);
?>
<div class="button2-right">
<div class="prev"><a onclick="Back('index.php?p=<?php
echo $p_next;
?>
')">Kembali</a></div>
</div><br><br>
<?php
echo "<strong> Tahun Anggaran : " . $th . "</strong><br>";
echo "<strong> Satker : [" . $kdsatker . "] " . nm_satker($kdsatker) . "</strong>";
?>
<br />
<table width="738" cellpadding="1" class="adminlist">
<thead>
<tr>
<th>Kode APBN</th>
<th colspan="2"><strong>Nama Kegiatan</strong> / <font color="#FF0000">Output</font><br>
<font color="#339900">Sub Output</font> / <font color="#3333FF">Komponen</font><br>
<font color="#660066">Sub Komponen</font> / Akun</th>
<th>Anggaran</th>
<th>Blokir</th>
</tr>
</thead>
<tbody>
<tr class="<?php
}
?>
<tr class="<?php
echo $class;
?>
">
<?php
$real_satker_triwulan = real_satker_triwulan($th, $col[0][$k], $kdtriwulan);
$real_satker_sdtriwulan = real_satker_sdtriwulan($th, $col[0][$k], $kdtriwulan);
?>
<td width="6%" align="center" valign="top"><strong><?php
echo $col[0][$k];
?>
</strong></td>
<td width="54%" align="left"><strong><?php
echo nm_satker($col[0][$k]);
?>
</strong></td>
<td width="12%" align="right" valign="top"><strong><?php
echo number_format($col[1][$k], "0", ",", ".");
?>
</strong></td>
<td width="11%" align="right" valign="top"><strong><?php
echo number_format($real_satker_triwulan, "0", ",", ".");
?>
</strong></td>
<td width="11%" align="right" valign="top"><strong><?php
echo number_format($real_satker_sdtriwulan, "0", ",", ".");
?>
</strong></td>
<td width="7%" align="center" valign="top"><?php
" size="10" value="<?php
echo $value[1];
?>
" /> ( Misal : 01 Tahun 2012, 02 Tahun 2012, ...)</td>
</tr>
<tr>
<td class="key">Satuan Kerja </td>
<td><select name="<?php
echo $field[5];
?>
">
<option value="<?php
echo $value[5];
?>
"><?php
echo $value[5] . ' ' . nm_satker($value[5]);
?>
</option>
<option value="">- Pilih Satuan Kerja -</option>
<?php
$query = mysql_query("select kdsatker,left(nmsatker,60) as namasatker from kd_satker where kdunitkerja = '{$xkdunit}' order by kdunitkerja");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['kdsatker'];
?>
"><?php
echo $row['kdsatker'] . ' ' . $row['namasatker'];
?>
</option>
<?php
}
?>
" readonly/></td>
</tr>
<tr>
<td class="key">Satker</td>
<td colspan="3"><select name="<?php
echo $field[2];
?>
">
<option value="<?php
echo $value[2];
?>
"><?php
echo '[' . $value[2] . '] ' . nm_satker($value[2]);
?>
</option>
<option value="">- Pilih Satker -</option>
<?php
$query = mysql_query("select KDSATKER,left(NMSATKER,60) as namasatker from t_satker ");
while ($row = mysql_fetch_array($query)) {
?>
<option value="<?php
echo $row['KDSATKER'];
?>
"><?php
echo $row['namasatker'];
?>
</option>
<?php
function Header()
{
$th = $_REQUEST['th'];
$kdbulan1 = $_REQUEST['kdbulan1'];
$kdbulan2 = $_REQUEST['kdbulan2'];
$kdsatker = $_REQUEST['kdsatker'];
if (substr($kdbulan1, 0, 1) == '0') {
$kdbl1 = substr($kdbulan1, 1, 1);
} else {
$kdbl1 = $kdbulan1;
}
if (substr($kdbulan2, 0, 1) == '0') {
$kdbl2 = substr($kdbulan2, 1, 1);
} else {
$kdbl2 = $kdbulan2;
}
$font = 'Arial';
$noborder = 0;
$border = 1;
$size = 10;
$ln = 5;
$margin = 30;
$tinggi = 275;
$w = array(0, 220);
$this->SetFont($font, 'B', $size + 2);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'BADAN TENAGA NUKLIR NASIONAL', '', 1, 'L');
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, strtoupper(trim(nm_satker($kdsatker))), '', 1, 'L');
$this->Ln();
$this->SetFont($font, 'B', $size + 1);
$this->SetX($margin + $w[0]);
$this->Cell($w[1], $ln, 'REKAPITULASI DAFTAR PEMBAYARAN TUNJANGAN KINERJA PEGAWAI', '', 1, 'C');
// bagian lampiran
$pos_x = $this->GetX();
$pos_y = $this->GetY();
$this->SetXY(245, 4);
$this->SetFont($font, 'B', $size - 2);
$this->Cell(75, $ln - 2, 'LAMPIRAN III', '', 1, 'L');
$this->SetX(158);
$this->Cell(150, $ln - 2, 'PERATURAN DIREKTUR JENDERAL PERBENDAHARAAN NO. PER.52/PB/2012', '', 1, 'L');
$this->SetX(158);
$this->Cell(150, $ln - 2, 'TENTANG PETUNJUK PELAKSANAAN PEMBAYARAN TUNJANGAN KINERJA', '', 1, 'L');
$this->SetX(158);
$this->Cell(150, $ln - 2, 'PADA 20 (DUA PULUH) KEMENTRIAN NEGARA/LEMBAGA', '', 1, 'L');
$this->SetXY($pos_x, $pos_y);
//
$this->SetX($margin + $w[0]);
if ($kdbulan2 != 13) {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl1)) . ' S/D ' . strtoupper(nama_bulan($kdbl2)) . ' ' . $th, '', 1, 'C');
} else {
$this->Cell($w[1], $ln, 'BULAN : ' . strtoupper(nama_bulan($kdbl1)) . ' DAN BULAN ' . strtoupper(nama_bulan($kdbl2)) . ' TAHUN ' . $th, '', 1, 'C');
}
$ln = 4;
$w1 = array(10, 50, 35, 40, 50, 5);
$this->SetFont($font, 'B', $size);
$this->SetX($margin);
$this->Cell($w1[0], $ln * 3, 'NO.', $border, 0, 'C');
$this->SetX($margin + $w1[0]);
$this->Cell($w1[1], $ln * 3, 'Uraian Kelas Jabatan', $border, 0, 'C');
$this->SetX($margin + $w1[0] + $w1[1]);
$this->Cell($w1[2], $ln * 3, 'Jumlah Penerima', $border, 0, 'C');
$y = $this->GetY();
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 2);
$this->Cell($w1[3], $ln, 'Tunjangan Kinerja', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y + 6);
$this->Cell($w1[3], $ln, 'Per Kelas Jabatan', $noborder, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2], $y);
$this->Cell($w1[3], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5], $y);
$this->Cell($w1[4], $ln, '1. Jumlah Tunjangan', $noborder, 0, 'L');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5], $y + 4);
$this->Cell($w1[4], $ln, '2. Pajak', $noborder, 0, 'L');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[5], $y + 8);
$this->Cell($w1[4], $ln, '3. Jumlah', $noborder, 0, 'L');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3], $y);
$this->Cell($w1[4], $ln * 3, '', $border, 0, 'C');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y);
$this->Cell($w1[4], $ln, '1. Faktor Pengurang', $noborder, 1, 'L');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 4);
$this->Cell($w1[4], $ln, '2. Potongan Pajak', $noborder, 1, 'L');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $y + 8);
$this->Cell($w1[4], $ln, '3. Jumlah Netto', $noborder, 1, 'L');
$this->SetXY($margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4], $y);
$this->Cell($w1[4], $ln * 3, '', $border, 1, 'C');
$this->SetFont($font, 'B', $size - 2);
}
