?> "> <td rowspan="3" align="center" valign="top"><?php echo $limit * ($pagess - 1) + ($k + 1); ?> </td> <td rowspan="3" align="left" valign="top"><?php echo 'Kelas Jabatan ' . $col[0][$k]; ?> </td> <td rowspan="3" align="center" valign="top"><?php echo jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $col[0][$k]); ?> </td> <td rowspan="3" align="right" valign="top"><?php echo number_format(rp_grade($col[0][$k]), "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($col[2][$k], "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($col[3][$k], "0", ",", "."); ?> </td> </tr> <tr class="<?php echo $class; ?> ">
?> "> <td rowspan="3" align="center" valign="top"><?php echo $limit * ($pagess - 1) + ($k + 1); ?> </td> <td rowspan="3" align="left" valign="top"><?php echo 'GRADE ' . $col[0][$k]; ?> </td> <td rowspan="3" align="center" valign="top"><?php echo jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $col[0][$k]); ?> </td> <td rowspan="3" align="right" valign="top"><?php echo rp_grade($col[0][$k]); ?> </td> <td align="right" valign="top"><?php echo $col[4][$k]; ?> </td> <td align="right" valign="top"><?php echo $col[5][$k]; ?> </td> </tr> <tr class="<?php echo $class; ?> ">
?> "> <td align="center" valign="top"><?php echo $no . '.'; ?> </td> <td align="left" valign="top"><?php echo 'Kelas Jabatan ' . $col_1; ?> </td> <td align="center" valign="top"><?php echo $col_2 . ' ' . $col_10; ?> </td> <td align="right" valign="top"><?php echo rp_grade($col_4, $col_1, 1); ?> </td> <td align="right" valign="top"><?php echo $col_5; ?> </td> <td align="right" valign="top"><?php echo $col_6; ?> </td> <td align="right" valign="top"><?php echo $col_5 + $col_6; ?> </td> <td align="right" valign="top"><?php
"> <!-- cetak rekap masing-masing grade --> <!-- cetak nomer --> <td align="center" valign="top"><?php echo 18 - $k; ?> </td> <!-- cetak grade --> <td align="center" valign="top"><?php echo $k; ?> </td> <!-- cetak nominal --> <td align="right" valign="top"><?php echo number_format(rp_grade($cunit[$k], $k, 1), "0", ",", "."); ?> </td> <!-- cetak banyaknya penerima --> <!--td align="center" valign="top"><?php echo $cpenerima[1][$k]; ?> </td--> <?php // cetak jumlah tunjangan kinerja $tk = 0; for ($b = 1; $b <= 13; $b++) { echo "<td align=right valign=top>"; echo number_format($ctk[$b][$k], "0", ",", ".");
$w1 = array(10, 50, 35, 40, 50, 7); // $w1 = array(10,50,35,35,35); $pdf->SetFont($font, '', $size - 1); $xx = 0; $no = 0; $ln = 4; $xkdunit = substr($kdunit, 0, 5); if ($kdunit == '2320100') { $oList = mysql_query("SELECT grade, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak FROM mst_tk WHERE tahun = '{$th}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and ( kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000' ) GROUP BY grade ORDER BY grade desc"); } else { $oList = mysql_query("SELECT grade, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak FROM mst_tk WHERE tahun = '{$th}' and bulan >= '{$kdbulan1}' and bulan <= '{$kdbulan2}' and kdunitkerja LIKE '{$xkdunit}%' GROUP BY grade ORDER BY grade desc"); } while ($row = mysql_fetch_array($oList)) { $max = 0; $no += 1; $nilGrade = rp_grade($row['grade']); $total_tunker += $row['jml_tunker']; $total_pajak += $row['jml_pajak']; $total += jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $row['grade']); $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.'); $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'GRADE ' . $row['grade']); $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format(jmlpeg_bulan_grade($th, $kdbulan2, $kdunit, $row['grade']), "0", ",", ".")); $arrUrut = $pdf->SplitToArray($w1[5], $ln, '1.' . "\n" . '2.' . "\n" . '3.'); $arrUrut1 = $pdf->SplitToArray($w1[5], $ln, '' . "\n" . '1.' . "\n" . '2.'); $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", ".")); $arrJmlTunker = $pdf->SplitToArray($w1[4] - $w1[5], $ln, number_format($row['jml_tunker'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", ".")); // $arrJmlPajak = $pdf->SplitToArray($w1[4],$ln,number_format($row['jml_pajak'],"0",",",".")); $arrJumlah = $pdf->SplitToArray($w1[4], $ln, '' . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format($row['jml_tunker'], "0", ",", ".")); if ($max < count($arrJmlTunker)) { $max = count($arrJmlTunker); }
<td align="left" valign="top"><?php if ($col[7][$k] != $col[7][$k - 1]) { echo 'Kelas Jabatan ' . $col[7][$k]; } ?> </td> <td align="center" valign="top"><?php echo 1; ?> </td> <td align="center" valign="top"><?php echo $col[6][$k]; ?> </td> <td align="right" valign="top"><?php echo $col[4][$k] . '<br>' . '( ' . $col[6][$k] . '/' . hari_bulan($th, $kdbulan) . ' x ' . number_format(rp_grade($col[3][$k], $col[7][$k], $col[2][$k]), "0", ",", ".") . ' )'; ?> </td> <td align="right" valign="top"><?php echo $col[5][$k]; ?> </td> <td align="right" valign="top"><?php echo $col[4][$k] + $col[5][$k]; ?> </td> </tr> <?php $grade = $col[7][$k]; } }
$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
$font = 'Arial'; $noborder = 0; $border = 1; $size = 10; $ln = 6; $margin = 10; $tinggi = 275; $w1 = array(10, 30, 20, 32, 22, 32); $pdf->SetFont($font, '', $size - 1); $xx = 0; $no = 0; $oList = mysql_query("SELECT grade, count(nib) as jumlah, sum(tunker) as jml_tunker, sum(pajak_tunker) as jml_pajak, sum(nil_terima) as jml_terima FROM mst_tk WHERE tahun = '{$th}' and kdsatker = '{$kdsatker}' and bulan = '{$kdbulan}' GROUP BY grade ORDER BY grade desc"); while ($row = mysql_fetch_array($oList)) { $max = 0; $no += 1; $nilGrade = rp_grade($kdunit, $row['grade'], 1); $total_tunker += $row['jml_tunker']; $total_pajak += $row['jml_pajak']; $total_terima += $row['jml_terima']; $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.'); $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'Kelas Jabatan ' . $row['grade']); if ($nilGrade * $row['jumlah'] != $row['jml_tunker']) { $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", ".") . ' (*)'); $xx = 1; } else { $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", ".")); } $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", ".")); $arrJmlTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'], "0", ",", ".")); $arrJmlPajak = $pdf->SplitToArray($w1[4], $ln, number_format($row['jml_pajak'], "0", ",", ".")); $arrJumlah = $pdf->SplitToArray($w1[5], $ln, number_format($row['jml_tunker'] + $row['jml_pajak'], "0", ",", "."));
?> "> <td align="center" valign="top"><?php echo $no . '.'; ?> </td> <td align="left" valign="top"><?php echo 'Kelas Jabatan ' . $col_1; ?> </td> <td align="center" valign="top"><?php echo $col_2 . ' ' . $col_10; ?> </td> <td align="right" valign="top"><?php echo number_format(rp_grade($col_4, $col_1, 1), "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($col_5, "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($col_6, "0", ",", "."); ?> </td> <td align="right" valign="top"><?php echo number_format($col_5 + $col_6, "0", ",", "."); ?> </td> <td align="right" valign="top"><?php
if ($row['jml_hari'] == 0) { $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']) . "\n" . reformat_tgl($row['tmtjabatan'])); } if ($row['jml_hari'] != 0) { $arrJabatan = $pdf->SplitToArray($w1[3], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan']) . "\n" . reformat_tgl($row['tmtjabatan']) . "\n" . ' (' . $row['jml_hari'] . ' hari dari ' . hari_bulan($th, $kdbl) . ' hari kerja)'); } $arrGrade = $pdf->SplitToArray($w1[4], $ln, $row['grade']); $arrTGrade = $pdf->SplitToArray($w1[5], $ln, number_format(rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']), "0", ",", ".")); $arrFPot = $pdf->SplitToArray($w1[5], $ln, number_format(rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']) - $row['tunker'], "0", ",", ".")); $arrTunker = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'], "0", ",", ".")); $arrPajak = $pdf->SplitToArray($w1[5], $ln, number_format($row['pajak_tunker'], "0", ",", ".")); $arrMinta = $pdf->SplitToArray($w1[5], $ln, number_format($row['tunker'] + $row['pajak_tunker'], "0", ",", ".")); $total_tunker += $row['tunker']; $total_pajak += $row['pajak_tunker']; $total_tgrade += rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']); $total_fpot += rp_grade($row['kdunitkerja'], $row['grade'], $row['kdpeg']) - $row['tunker']; if ($max < count($arrNama)) { $max = count($arrNama); } if ($max < count($arrJabatan)) { $max = count($arrJabatan); } for ($i = 0; $i < $max; $i++) { $pdf->SetX($margin); $pdf->Cell($w1[0], $ln, $arrNo[$i], 'LR', 0, 'C'); $pdf->SetX($margin + $w1[0]); $pdf->Cell($w1[1], $ln, $arrNama[$i], 'LR', 0, 'L'); $pdf->SetX($margin + $w1[0] + $w1[1]); $pdf->Cell($w1[2], $ln, $arrGol[$i], 'LR', 0, 'C'); $pdf->SetX($margin + $w1[0] + $w1[1] + $w1[2]); $pdf->Cell($w1[3], $ln, $arrJabatan[$i], 'LR', 0, 'L');
?> "> <td rowspan="3" align="center" valign="top"><?php echo $limit * ($pagess - 1) + ($k + 1); ?> </td> <td rowspan="3" align="left" valign="top"><?php echo 'Kelas Jabatan ' . $col[0][$k]; ?> </td> <td rowspan="3" align="center" valign="top"><?php echo $col[1][$k]; ?> </td> <td rowspan="3" align="right" valign="top"><?php echo rp_grade($col[3][$k], $col[0][$k], 1); ?> </td> <td align="right" valign="top"><?php echo $col[4][$k]; ?> </td> <td align="right" valign="top"><?php echo 0; ?> </td> </tr> <tr class="<?php echo $class; ?> ">
$nilpot_12 = $row['kdpot_12'] * persen_pot('12'); $nilpot_13 = $row['kdpot_13'] * persen_pot('13'); $nilpot_14 = $row['kdpot_14'] * persen_pot('14'); $nilpot_15 = $row['kdpot_15'] * persen_pot('15'); $nilpot_16 = $row['kdpot_16'] * persen_pot('16'); $nilpot_21 = $row['kdpot_21'] * persen_pot('21'); $nilpot_22 = $row['kdpot_22'] * persen_pot('22'); $nilpot_40 = $row['kdpot_40'] * persen_pot('40'); $nilpot_tk = $row['kdpot_tk'] * persen_pot('tk'); $nilpot_cm = $row['kdpot_cm'] * persen_pot('cm'); // $selisih_nilpot_tk = $row['kdpot_tk'] * 2; // $selisih_nilpot_cm = $row['kdpot_cm'] * 1; $totpot = $nilpot_10 + $nilpot_11 + $nilpot_12 + $nilpot_13 + $nilpot_14 + $nilpot_15 + $nilpot_16 + $nilpot_01 + $nilpot_02 + $nilpot_03 + $nilpot_04 + $nilpot_05 + $nilpot_06 + $nilpot_07 + $nilpot_08 + $nilpot_31 + $nilpot_32 + $nilpot_33 + $nilpot_34 + $nilpot_21 + $nilpot_22 + $nilpot_40 + $nilpot_tk + $nilpot_cm; // $nilpot_40 - // $selisih_nilpot_tk - selisih_nilpot_cm; $rp_grade = rp_grade($kdunit, $grade, $kdpeg); $rp_pot = $tunker * ($totpot / 100); if ($bulan != 13) { $nil_terima = $tunker - $rp_pot; } else { $nil_terima = $tunker; } // if ( $status == '0' ) // { // $_SESSION['errmsg'] = "Persetujuan dari KPPN belum diupdate ke sistem "; // exit(); ?> <meta http-equiv="refresh" content="0;URL=index.php?p=<?php echo $p_next; ?> "><?php
while ($row = mysql_fetch_array($oList)) { $max = 0; $no += 1; $nilGrade = rp_grade($kdunit, $row['grade'], 1); $total_tunker += $row['jml_tunker']; $total_pajak += $row['jml_pajak']; $total_tk += rp_grade($kdunit, $row['grade'], 1) * $row['jumlah']; $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.'); $arrGrade = $pdf->SplitToArray($w1[1], $ln, 'Kelas Jabatan ' . $row['grade']); $arrPenerima = $pdf->SplitToArray($w1[2], $ln, number_format($row['jumlah'], "0", ",", ".")); $arrUrut = $pdf->SplitToArray($w1[5], $ln, '1.' . "\n" . '2.' . "\n" . '3.'); $arrUrut1 = $pdf->SplitToArray($w1[5], $ln, '' . "\n" . '1.' . "\n" . '2.'); $arrTunker = $pdf->SplitToArray($w1[3], $ln, number_format($nilGrade, "0", ",", ".")); $arrJmlTunker = $pdf->SplitToArray($w1[4] - $w1[5], $ln, number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] + $row['jml_pajak'], "0", ",", ".")); // $arrJmlPajak = $pdf->SplitToArray($w1[4],$ln,number_format($row['jml_pajak'],"0",",",".")); $arrJumlah = $pdf->SplitToArray($w1[4], $ln, number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] - $row['jml_tunker'], "0", ",", ".") . "\n" . number_format($row['jml_pajak'], "0", ",", ".") . "\n" . number_format(rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] + $row['jml_pajak'] - $row['jml_pajak'] - (rp_grade($kdunit, $row['grade'], 1) * $row['jumlah'] - $row['jml_tunker']), "0", ",", ".")); if ($max < count($arrJmlTunker)) { $max = count($arrJmlTunker); } for ($i = 0; $i < $max; $i++) { $pdf->SetX($margin); if ($i == 1) { $pdf->Cell($w1[0], $ln, $arrNo[$i - 1], 'LR', 0, 'C'); } else { $pdf->Cell($w1[0], $ln, '', 'LR', 0, 'C'); } $pdf->SetX($margin + $w1[0]); if ($i == 1) { $pdf->Cell($w1[1], $ln, $arrGrade[$i - 1], 'LR', 0, 'L'); } else { $pdf->Cell($w1[1], $ln, '', 'LR', 0, 'L');