$JmlTerima = 0;
$oList_bulan = mysql_query("SELECT bulan,kdunitkerja,kdjabatan, grade, jml_hari, tunker, pajak_tunker, nil_terima FROM mst_tk WHERE tahun = '{$th}' and kdsatker = '{$kdsatker}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and nib = '{$nib}' order BY bulan, grade desc");
while ($row_bulan = mysql_fetch_array($oList_bulan)) {
$max = 0;
if (substr($row_bulan['bulan'], 0, 1) == '0') {
$kdbl = substr($row_bulan['bulan'], 1, 1);
} else {
$kdbl = $row_bulan['bulan'];
}
$arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
$arrBulan = $pdf->SplitToArray($w1[1], $ln, nama_bulan($kdbl));
if ($row_bulan['jml_hari'] == 0) {
$arrJabatan = $pdf->SplitToArray($w1[2], $ln, nm_info_jabatan($row_bulan['kdunitkerja'], $row_bulan['kdjabatan']));
}
if ($row_bulan['jml_hari'] != 0) {
$arrJabatan = $pdf->SplitToArray($w1[2], $ln, nm_info_jabatan($row_bulan['kdunitkerja'], $row_bulan['kdjabatan']) . "\n" . ' (' . $row_bulan['jml_hari'] . ' hari dari ' . hari_bulan($th, $kdbl) . ' hari kerja)');
}
$arrGrade = $pdf->SplitToArray($w1[3], $ln, $row_bulan['grade']);
$arrPajak = $pdf->SplitToArray($w1[4], $ln, number_format($row_bulan['pajak_tunker'], "0", ",", "."));
$arrTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row_bulan['tunker'], "0", ",", "."));
$arrPotongan = $pdf->SplitToArray($w1[6], $ln, number_format($row_bulan['tunker'] - $row_bulan['nil_terima'], "0", ",", "."));
$arrTerima = $pdf->SplitToArray($w1[7], $ln, number_format($row_bulan['nil_terima'], "0", ",", "."));
$JmlPajak += $row_bulan['pajak_tunker'];
$JmlTunker += $row_bulan['tunker'];
$JmlPotongan += $row_bulan['tunker'] - $row_bulan['nil_terima'];
$JmlTerima += $row_bulan['nil_terima'];
if ($max < count($arrJabatan)) {
$max = count($arrJabatan);
}
for ($i = 0; $i < $max; $i++) {
$pdf->SetX($margin);
?>
</td>
<td align="center" valign="top"><?php
echo nm_pangkat(substr($col[7][$k], 0, 1) . hurufkeangka(substr($col[7][$k], 1, 1))) . '(' . nm_gol(substr($col[7][$k], 0, 1) . hurufkeangka(substr($col[7][$k], 1, 1))) . ')';
?>
</td>
<td align="center" valign="top"><?php
echo status_peg($col[22][$k]);
?>
</td>
<td align="left" valign="top"><?php
echo nm_info_jabatan($col[6][$k], $col[8][$k]);
?>
<?php
if ($col[21][$k] != 0) {
echo '<br>' . '( ' . $col[21][$k] . ' hari dari ' . hari_bulan($th, $kdbulan) . ' hari kerja )';
}
?>
<br /><?php
echo reformat_tgl($col[24][$k]);
?>
</td>
<td align="center" valign="top"><?php
echo $col[9][$k];
?>
</td>
<td align="right" valign="top"><?php
echo number_format($col[11][$k], "0", ",", ".");
?>
</td>
<td align="right" valign="top"><?php
$xmenu_p = xmenu_id($p);
$p_next = $xmenu_p->parent;
if (isset($form)) {
if ($err != true) {
$tahun = $_REQUEST['tahun'];
$bulan = bulan_data($_REQUEST['bulan']);
$tgl_status = date('Y-m-d');
$sql = "SELECT id,nib,grade,gaji,kdunitkerja,kdkawin,iwp,pajak_gaji,kdpeg,jml_hari,tfungsi FROM mst_tk WHERE tahun = '{$tahun}' AND bulan = '{$bulan}' AND kdsatker = '{$xusername}'";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
$id = $row['id'];
if ($row['jml_hari'] == 0) {
$tunker = rp_grade(substr($row['kdunitkerja'], 0, 2), $row['grade'], $row['kdpeg']);
}
if ($row['jml_hari'] != 0) {
$tunker = rp_grade(substr($row['kdunitkerja'], 0, 2), $row['grade'], $row['kdpeg']) * ($row['jml_hari'] / hari_bulan($tahun, $bulan));
}
if ($xusename = '524334') {
$tunker = $tunker - $row['tfungsi'];
}
$gaji_bruto = $row['gaji'] + $tunker;
$pajak_total = nil_pajak($gaji_bruto, $row['kdkawin'], $row['iwp']);
$pajak_gaji = $row['pajak_gaji'];
$pajak_tunker = $pajak_total - $pajak_gaji;
$sql_inp = "UPDATE mst_tk SET tunker = '{$tunker}' , pajak_tunker = '{$pajak_tunker}' WHERE id = '{$id}' ";
mysql_query($sql_inp);
#}
}
?>
<meta http-equiv="refresh" content="0;URL=index.php?p=<?php
?> <tr class="<?php echo $class; ?> "> <td align="center" valign="top"><?php echo ''; ?> </td> <td align="center" valign="top"><?php echo $List_rekap['jumlah']; ?> </td> <td align="center" valign="top"><?php echo hari_bulan($th, $kdbulan); ?> </td> <td align="right" valign="top"><?php echo number_format($List_rekap['jml_tunker'], "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($List_rekap['jml_pajak'], "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($List_rekap['jml_tunker'] + $List_rekap['jml_pajak'], "0", ",", "."); ?> </td> </tr>
<td align="center" valign="top"><?php
echo nm_pangkat(substr($List_bulan['kdgol'], 0, 1) . hurufkeangka(substr($List_bulan['kdgol'], 1, 1))) . ' (' . nm_gol(substr($List_bulan['kdgol'], 0, 1) . hurufkeangka(substr($List_bulan['kdgol'], 1, 1))) . ')';
?>
<br /><?php
echo '(' . status_peg($List_bulan['kdpeg']) . ')';
?>
</td>
<td align="left" valign="top"><?php
echo nm_info_jabatan($List_bulan['kdunitkerja'], $List_bulan['kdjabatan']) . ' (' . reformat_tgl($List_bulan['tmtjabatan']) . ')';
?>
<br /><?php
echo 'Kelas Jabatan ' . $List_bulan['grade'];
if ($List_bulan['jml_hari'] != 0) {
?>
<br /><?php
echo '(' . $List_bulan['jml_hari'] . ' hari dari .' . hari_bulan($th, $kdbl) . ' hari kerja)';
}
?>
</td>
<td align="right" valign="top"><?php
echo $List_bulan['pajak_tunker'];
?>
</td>
<td align="right" valign="top"><?php
echo $List_bulan['tunker'];
?>
</td>
<td align="right" valign="top"><?php
echo $List_bulan['tunker'] - $List_bulan['nil_terima'];
?>
</td>