Beispiel #1
0
        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());
    }
Beispiel #5
0
 }
 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);
Beispiel #6
0
        ?>
</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 
Beispiel #7
0
            ?>
				
				<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 
Beispiel #8
0
 #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 {
Beispiel #9
0
&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);
Beispiel #10
0
        $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;