echo 'NIP. ' . reformat_nipbaru(nip_peg($col[2][$k])); ?> </td> <td align="left" valign="top"> <?php if (substr($col[3][$k], 1, 3) == '000' and substr($col[4][$k], 0, 4) == '0011') { echo nm_jabatan_eselon1($col[3][$k]); } elseif (substr($col[3][$k], 1, 3) != '000' and substr($col[4][$k], 0, 3) == '001') { echo 'Kepala ' . nm_unitkerja($col[3][$k]); } else { echo nm_jabatan_ij($col[4][$k]); } ?> </td> <td align="center" valign="top"><?php echo nil_grade($col[4][$k]); ?> </td> <td align="left" valign="top"><?php echo nama_peg($col[10][$k]); ?> </td> <td align="left" valign="top"><?php echo $col[11][$k]; ?> </td> <td align="center" valign="top"> </td> <td width="5%" align="center" valign="top"> <a href="index.php?p=386&id_skp=<?php echo $col[0][$k];
$id = $q; foreach ($field as $k => $val) { $value[$k] = ${$val}; } if ($q == "") { //ADD NEW } else { $tahun = $value[1]; $bulan = $value[2]; $nip = $value[3]; $kdunitkerja = $value[4]; $kdjabatan = $value[5]; $tmtjabatan = $value[8]; $kdgol = $value[6]; $kdstatuspeg = $value[7]; $grade = nil_grade($kdjabatan, $kdunitkerja); $gol = substr($kdgol, 0, 1); $sql_grade = "SELECT rp_grade FROM kd_grade WHERE kd_grade = '{$grade}'"; $oGrade = mysql_query($sql_grade); $Grade = mysql_fetch_array($oGrade); if ($kdstatuspeg == '1') { $tukin = $Grade['rp_grade']; } else { $tukin = $Grade['rp_grade'] * 0.8; } if ($gol == 3) { $pajak_tukin = 0.05 * $tukin; } elseif ($gol == 4) { $pajak_tukin = 0.15 * $tukin; } else { $pajak_tukin = 0;
<td align="center" valign="top"><?php if ($col[3][$k] != $kdunitkerja) { ?> <font color="#0033FF"><strong><?php echo nil_grade($col[4][$k]); ?> </strong></font><?php } else { echo nil_grade($col[4][$k]); } ?> <?php if (kdeselon_peg($col[2][$k]) != '' and substr(kdjnsskfung_peg($col[2][$k]), 0, 1) == '0') { ?> <br /><font color="#0033FF"><strong><?php echo nil_grade(kdjabatan_peg($col[2][$k])); ?> </strong></font> <?php } ?> </td> <td align="center" valign="top"><?php if ($col[3][$k] != $kdunitkerja) { ?> <font color="#0033FF"><strong><?php echo skt_unitkerja(substr($col[3][$k], 0, 2)); ?> </strong></font><?php } else { echo skt_unitkerja(substr($col[3][$k], 0, 2));
} $qu = mysql_query($sql); while ($row = mysql_fetch_array($qu)) { $max = 0; $no += 1; $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.'); if ($row['kdunitkerja'] != $kdunitkerja) { $arrUnit = $pdf->SplitToArray($w1[1], $ln, trim(nm_unitkerja($row['kdunitkerja']))); } if ($row['kdunitkerja'] == $kdunitkerja) { $arrUnit = $pdf->SplitToArray($w1[1], $ln, ''); } $arrJabatan = $pdf->SplitToArray($w1[4], $ln, nm_jabatan_ij($row['kdjabatan'], $row['kdunitkerja']) . "\n" . '[' . reformat_tgl($row['tmtjabatan']) . ']'); $arrNama = $pdf->SplitToArray($w1[2], $ln, nama_peg($row['nip']) . "\n" . 'NIP. ' . reformat_nipbaru($row['nip'])); $arrGol = $pdf->SplitToArray($w1[3], $ln, nm_gol($row['kdgol']) . "\n" . nm_status_peg($row['kdstatuspeg'])); $arrGrade = $pdf->SplitToArray($w1[3], $ln, nil_grade($row['kdjabatan'], $row['kdunitkerja'])); if ($max < count($arrUnit)) { $max = count($arrUnit); } if ($max < count($arrJabatan)) { $max = count($arrJabatan); } if ($max < count($arrNama)) { $max = count($arrNama); } if ($row['kdunitkerja'] != $kdunitkerja) { $pdf->Line($margin, $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $pdf->GetY()); } if ($row['kdunitkerja'] == $kdunitkerja) { $pdf->Line($margin + $w1[0] + $w1[1], $pdf->GetY(), $margin + $w1[0] + $w1[1] + $w1[2] + $w1[3] + $w1[4] + $w1[5], $pdf->GetY()); }
} if ($row['kdunitkerja'] == $kdunitkerja and $row['kdjabatan'] != $kdjabatan) { $arrJabatan = $pdf->SplitToArray($w1[2], $ln, nm_info_jabatan($row['kdunitkerja'], $row['kdjabatan'])); } if ($row['kdunitkerja'] == $kdunitkerja and $row['kdjabatan'] == $kdjabatan) { $arrJabatan = $pdf->SplitToArray($w1[2], $ln, ''); } if ($row['kdjabatan'] != $kdjabatan) { $arrJumlah = $pdf->SplitToArray($w1[3], $ln, jml_info_jabatan($row['kdunitkerja'], $row['kdjabatan'])); } if ($row['kdjabatan'] == $kdjabatan) { $arrJumlah = $pdf->SplitToArray($w1[3], $ln, ''); } $arrNama = $pdf->SplitToArray($w1[5], $ln, nama_peg($row['nib']) . "\n" . 'NIP. ' . reformat_nipbaru(nip_peg($row['nib']))); $arrGol = $pdf->SplitToArray($w1[6], $ln, nm_gol($row['kdgol'])); $arrGrade = $pdf->SplitToArray($w1[10], $ln, nil_grade($row['kdjabatan'])); if ($row['kdjabatan'] != $kdjabatan) { $arrJ2 = $pdf->SplitToArray($w1[10], $ln, jml_j2($th, $row['kdunitkerja'], $row['kdjabatan'])); } if ($row['kdjabatan'] == $kdjabatan) { $arrJ2 = $pdf->SplitToArray($w1[10], $ln, ''); } $tanda = jml_j2($th, $row['kdunitkerja'], $row['kdjabatan']) - jml_info_jabatan($row['kdunitkerja'], $row['kdjabatan']); if ($tanda >= 1) { $xtanda = '+'; } if ($tanda <= 0) { $xtanda = ''; } if ($row['kdjabatan'] != $kdjabatan) { $arrSelisih = $pdf->SplitToArray($w1[10], $ln, $xtanda . $tanda);
?> </td> <td align="left" valign="top"><?php if ($col[1][$k] != $col[1][$k - 1]) { echo nm_unitkerja($col[1][$k]); } ?> </td> <td align="left" valign="top"><?php if ($col[2][$k] != $col[2][$k - 1]) { echo nm_info_jabatan($col[1][$k], $col[2][$k]); } ?> </td> <td align="center" valign="top"><?php echo nil_grade($col[2][$k]); ?> </td> <td align="center" valign="top"><?php if ($col[2][$k] != $col[2][$k - 1]) { echo jml_info_jabatan($col[1][$k], $col[2][$k]); } ?> </td> <td align="center" valign="top"><?php if ($col[2][$k] != $col[2][$k - 1]) { echo jml_j2($th, $col[1][$k], $col[2][$k]); } ?> </td> <td align="center" valign="top"><?php
?> <meta http-equiv="refresh" content="0;URL=index.php?p=<?php echo $p_next; ?> &pagess=<?php echo $pagess; ?> &kdunit=<?php echo $kdunit; ?> "><?php exit; } else { // UPDATE $value[4] = nil_grade($value[2]); $sql = sql_update($table, $field, $value); $rs = mysql_query($sql); if ($rs) { update_log($sql, $table, 1); $_SESSION['errmsg'] = "Ubah data berhasil!"; } else { update_log($sql, $table, 0); $_SESSION['errmsg'] = "Ubah data gagal!"; } ?> <meta http-equiv="refresh" content="0;URL=index.php?p=<?php echo $p_next; ?> &pagess=<?php
#hapus dulu datanya $xkdunit = substr($kdunit, 0, 5); if ($kdunit == '2320100') { $sql = "DELETE FROM mst_tk WHERE tahun = '{$tahun_proses}' and bulan = '{$bulan_proses}' and ( kdunitkerja LIKE '{$xkdunit}%'\r\n\t\t\t\t\t\tOR kdunitkerja = '2320000' )"; } else { $sql = "DELETE FROM mst_tk WHERE tahun = '{$tahun_proses}' and bulan = '{$bulan_proses}' and kdunitkerja LIKE '{$xkdunit}%'"; } mysql_query($sql); if ($kdunit == '2320100') { $sql = "SELECT * FROM m_idpegawai WHERE kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000'"; } else { $sql = "SELECT * FROM m_idpegawai WHERE kdunitkerja LIKE '{$xkdunit}%'"; } $qu = mysql_query($sql); while ($row = mysql_fetch_array($qu)) { $grade = nil_grade($row['kdjabatan'], $row['kdunitkerja']); $sql_grade = "SELECT rp_grade FROM kd_grade WHERE kd_grade = '{$grade}'"; $oGrade = mysql_query($sql_grade); $Grade = mysql_fetch_array($oGrade); $kdstatuspeg = $row['kdstatuspeg']; $gol = substr($row['kdgol'], 0, 1); if ($kdstatuspeg == '1') { $tukin = $Grade['rp_grade']; } else { $tukin = $Grade['rp_grade'] * 0.8; } if ($gol == 3) { $pajak_tukin = 0.05 * $tukin; } elseif ($gol == 4) { $pajak_tukin = 0.15 * $tukin; } else {
&pagess=<?php echo $pagess; ?> &cari=<?php echo $cari; ?> "><?php exit; } else { // UPDATE $value[1] = $th; $nib = $value[2]; $kdunitkerja = kdunitkerja_peg($nib); $kdjabatan = $value[4]; if ($value[13] != nil_grade($value[4])) { $grade = nil_grade($value[4]); } else { $grade = $value[13]; } $kdgol = $value[5]; $tanggal_mulai = $value[14]; /* $value[3] = kdunitkerja_peg($nib) ; $value[5] = kdgol_peg($nib) ; $value[12] = kdgol_peg($value[10]) ; $value[11] = jabstruk_peg($value[10]) ; $value[6] = '0' ; $value[8] = '0' ; if ( $value[13] == 0 ) $value[13] = nil_grade($value[4]) ; */ $sql = "UPDATE {$table} SET nib = '{$nib}' , kdunitkerja = '{$kdunitkerja}' , kdjabatan = '{$kdjabatan}' , grade = '{$grade}', kdgol = '{$kdgol}' , tanggal_mulai = '{$tanggal_mulai}' WHERE id = '{$q}' "; // $sql = sql_update($table,$field,$value); $rs = mysql_query($sql);
$oSKP_Lalu = mysql_query("SELECT * FROM mst_skp_mutasi WHERE tahun = '{$th}' AND nib = '{$nib}' "); $SKP_Lalu = mysql_fetch_array($oSKP_Lalu); ?> <td align="left" valign="top"><?php if (substr($SKP_Lalu['kdunitkerja'], 1, 3) == '000' and substr($SKP_Lalu['kdjabatan'], 0, 4) == '0011') { echo nm_jabatan_eselon1($SKP_Lalu['kdunitkerja']); } elseif (substr($SKP_Lalu['kdjabatan'], 1, 3) != '000' and substr($SKP_Lalu['kdjabatan'], 0, 3) == '001') { echo 'Kepala ' . nm_unitkerja($SKP_Lalu['kdunitkerja']); } else { echo nm_jabatan_ij($SKP_Lalu['kdjabatan']); } ?> </td> <td align="center" valign="top"><?php echo nil_grade($SKP_Lalu['kdjabatan']); ?> </td> <td align="center" valign="top"><?php echo reformat_tgl($SKP_Lalu['tanggal_mulai']); ?> <br />s/d<br /><?php echo reformat_tgl($SKP_Lalu['tanggal_selesai']); ?> </td> <td align="center" valign="top"> <a href="index.php?p=445&q=<?php echo $SKP_Lalu['id']; ?> &pagess=<?php echo $pagess;