<?php 
        $sql = "select nospm,tgspm, sum(totnilmak) as real_spm from {$table_1} WHERE thang = '{$th}' and kdsatker = '{$kdsatker}' and kdoutput = '{$Output['kdoutput']}' group by nospm order by nospm ";
        $aSPM = mysql_query($sql);
        while ($SPM = mysql_fetch_array($aSPM)) {
            ?>
    <tr class="<?php 
            echo $class;
            ?>
"> 
      <td align="center"><font color="#3333FF">&nbsp;</font></td>
      <td width="15%" align="center"><font color="#3333FF">No : <?php 
            echo $SPM['nospm'];
            ?>
</font></td>
      <td width="16%" align="left"><font color="#3333FF">Tgl. <?php 
            echo reformat_tgl($SPM['tgspm']);
            ?>
</font></td>
      <td width="20%" align="right"><font color="#3333FF"><?php 
            echo number_format($SPM['real_spm'], "0", ",", ".");
            ?>
</font></td>
      <td align="right"><font color="#3333FF">&nbsp;</font></td>
    </tr>
    <?php 
            $sql = "select kdakun,nilmak from {$table_2} WHERE thang = '{$th}' and kdsatker = '{$kdsatker}' and nospm = '{$SPM['nospm']}' order by kdakun";
            $aAkun = mysql_query($sql);
            while ($Akun = mysql_fetch_array($aAkun)) {
                ?>
    <tr class="<?php 
                echo $class;
示例#2
0
					<?php 
        }
        ?>
					<br />
					<?php 
        if ($col[8][$k] != $row['tmtjabatan']) {
            ?>
					<font color="#CC3300"><?php 
            echo '[' . reformat_tgl($row['tmtjabatan']) . ']';
            ?>
</font>
					<?php 
        } else {
            ?>
					<?php 
            echo '[' . reformat_tgl($row['tmtjabatan']) . ']';
            ?>
					<?php 
        }
        ?>
					</td>
					
				    <td align="center" valign="top">
					<?php 
        if ($col[9][$k] != grade_jabatan_ij($row['kdjabatan'], $row['kdunitkerja'])) {
            ?>
					<font color="#CC3300"><?php 
            echo grade_jabatan_ij($row['kdjabatan'], $row['kdunitkerja']);
            ?>
</font>
					<?php 
示例#3
0
                ?>
&pagess=<?php 
                echo $pagess;
                ?>
&cari=<?php 
                echo $cari;
                ?>
" title="Edit Laporan Kemajuan SKP">
			  				<img src="css/images/edit_f2.png" border="0" width="16" height="16"><font size="1">Kemajuan SKP</font></a>
			  		<?php 
                break;
            case '1':
                echo "<font color='#009933'>Dikirim <br>" . reformat_tgl($col[15][$k]) . "</font>";
                break;
            case '2':
                echo "<font color='#0000FF'>Dinilai <br>" . reformat_tgl($col[15][$k]) . "<br>(" . number_format(total_nilai_capaian($col[10][$k], $col[0][$k], $col[1][$k]), "2", ",", ".") . ")</font>";
                break;
        }
        ?>
			  			  </td>
				  <td width="4%" align="center" valign="top">
				  <?php 
        if ($col[14][$k] == '0') {
            ?>
				  <a href="index.php?p=412&id_skp=<?php 
            echo $col[0][$k];
            ?>
&pagess=<?php 
            echo $pagess;
            ?>
&cari=<?php 
示例#4
0
        } else {
            #---   data pegawai dibawahnya -----
            ?>
					
					<?php 
            if ($col[6][$k] == '0') {
                ?>
					<font color="#FF0000"><?php 
                echo 'Draf';
                ?>
</font>
					<?php 
            } else {
                ?>
					<font color="#006633"><?php 
                echo status_approv_pegawai($col[6][$k]) . '<br>' . reformat_tgl($col[7][$k]);
                ?>
</font>
					<?php 
            }
            ?>
					
					<?php 
        }
        # ------ akhir status data yang tampil
        ?>
					</td>
                  <td width="5%" align="center" valign="top">
				  <?php 
        if ($xlevel == 0 or $xlevel == 1 or $xlevel == 2) {
            ?>
示例#5
0
    $sql = "SELECT * FROM m_idpegawai WHERE kdunitkerja LIKE '{$xkdunit}%' OR kdunitkerja = '2320000' ORDER BY kdunitkerja, kdeselon desc,kdjabatan desc,kdgol";
} else {
    $sql = "SELECT * FROM m_idpegawai WHERE kdunitkerja LIKE '{$xkdunit}%' ORDER BY kdunitkerja, kdeselon desc,kdjabatan desc,kdgol";
}
$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());
    }
?>

        

<table width="617" cellspacing="1" class="admintable">
	<tr>
		<td width="144" class="key">Id</td>
		<td width="464"><input type="text" size="5" readonly="readonly" value="<?php 
echo $value[0];
?>
" /></td>
	</tr>
	<tr>
		<td class="key">Tanggal</td>
		<td><input name="text" type="text" value="<?php 
echo reformat_tgl($value[2]);
?>
" size="30" readonly="readonly" /></td>
	</tr>
	<tr>
		<td class="key">Nama Aktivitas  </td>
		<td><textarea name="" cols="70" rows="2" readonly="readonly"><?php 
echo $value[4];
?>
</textarea></td>
	</tr>
	<tr>
	  <td class="key">Hasil</td>
	  <td><textarea name="" cols="70" rows="2" readonly="readonly"><?php 
echo $value[5];
?>
示例#7
0
        }
        ?>
</td>
					<td align="left" valign="top"><?php 
        echo nama_peg($col[2][$k]);
        ?>
<br /><?php 
        echo 'NIP. ' . reformat_nipbaru($col[2][$k]);
        ?>
</td>
					<td align="center" valign="top"><?php 
        echo nm_gol($col[5][$k]) . '<br>' . nm_status_peg($col[7][$k]);
        ?>
</td>
					<td align="left" valign="top"><?php 
        echo nm_jabatan_ij($col[4][$k], $col[3][$k]) . '<br>' . '[' . reformat_tgl($col[6][$k]) . ']';
        ?>
</td>
					<td align="center" valign="top"><?php 
        echo nil_grade($col[4][$k], $col[3][$k]);
        ?>
</td>
			    </tr>
				
				<?php 
    }
}
?>
	</tbody>
	<tfoot>
		<tr>
示例#8
0
        ?>
">
					  <td align="center" valign="top">&nbsp;</td>
					  <td align="right" valign="top"><?php 
        echo strtoupper(nama_bulan($kdbl));
        ?>
</td>
					  <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 
示例#9
0
        echo nm_jabatan_ij($col[4][$k]);
        ?>
</td>
					<td width="15%" align="center" valign="top">
					<?php 
        if ($col[8][$k] == 0) {
            ?>
					<font color="#FF0000"><?php 
            echo status_approv_pegawai($col[6][$k]) . '<br>' . reformat_tgl($col[7][$k]);
            ?>
</font>
					<?php 
        } else {
            ?>
					<font color="#006633"><?php 
            echo status_approv_atasan($col[8][$k]) . '<br>' . reformat_tgl($col[9][$k]);
            ?>
</font>
					<?php 
        }
        ?>
					</td>
					<td width="10%" align="center" valign="top">
					<?php 
        if ($col[8][$k] == 0 and $xusername != $col[2][$k]) {
            ?>
					<a href="index.php?p=267&id_skp=<?php 
            echo $col[0][$k];
            ?>
&sw=1" title="Approved Atasan"><img src="css/images/edit_f2.png" border="0" width="16" height="16">
					<font color="#0033FF"><?php 
示例#10
0
$w1 = array(10, 50, 12, 40, 10, 30);
$pdf->SetFont($font, '', $size - 1);
$no = 0;
$sql = "SELECT * FROM mst_tk WHERE kdsatker = '{$kdsatker}' and tahun = '{$th}' and bulan = '{$kdbulan}' ORDER BY grade desc, kdgol desc, kdjabatan";
$qu = mysql_query($sql);
while ($row = mysql_fetch_array($qu)) {
    $max = 0;
    $no += 1;
    $arrNo = $pdf->SplitToArray($w1[0], $ln, $no . '.');
    $arrNama = $pdf->SplitToArray($w1[1], $ln, nama_peg($row['nib']) . "\n" . 'NIP. ' . reformat_nipbaru(nip_peg($row['nib'])));
    $arrGol = $pdf->SplitToArray($w1[2], $ln, nm_gol(substr($row['kdgol'], 0, 1) . hurufkeangka(substr($row['kdgol'], 1, 1))) . "\n" . status_peg($row['kdpeg']));
    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)) {
示例#11
0
$pdf->Cell($w2[5], $ln, 'PEJABAT', $noborder, 0, 'C');
$pdf->SetXY($margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4], $y + 8);
$pdf->Cell($w2[5], $ln, 'PENILAI', $noborder, 0, 'C');
$pdf->SetXY($margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4], $y);
$pdf->Cell($w2[5], $ln * 3, '', $border, 1, 'C');
$pdf->SetFont($font, '', $size - 1);
$oList = mysql_query("SELECT * FROM dtl_aktivitas WHERE id_skp = '{$id_skp}' and tgl >= '{$tgl1}' and tgl <= '{$tgl2}' ORDER BY tgl");
$totalAK = 0.0;
$totalMenit = 0;
$no = 0;
while ($List = mysql_fetch_array($oList)) {
    $no += 1;
    $max = 0;
    $arrNo = $pdf->SplitToArray($w2[0], $ln, $no . '.');
    if ($tanggal != $List['tgl']) {
        $arrTgl = $pdf->SplitToArray($w2[1], $ln, reformat_tgl($List['tgl']));
    } else {
        $arrTgl = $pdf->SplitToArray($w2[1], $ln, '');
    }
    $arrUraian = $pdf->SplitToArray($w2[2], $ln, trim($List['aktivitas']));
    $arrSetuju_P = $pdf->SplitToArray($w2[4], $ln, nm_commit($List['commit']));
    $arrSetuju_A = $pdf->SplitToArray($w2[5], $ln, nm_commit($List['approv']));
    if ($max < count($arrUraian)) {
        $max = count($arrUraian);
    }
    if ($tanggal != $List['tgl']) {
        $pdf->Line($margin, $pdf->GetY(), $margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4] + $w2[5], $pdf->GetY());
    } else {
        $pdf->Line($margin + $w2[0] + $w2[1], $pdf->GetY(), $margin + $w2[0] + $w2[1] + $w2[2] + $w2[3] + $w2[4] + $w2[5], $pdf->GetY());
    }
    $tanggal = $List['tgl'];
示例#12
0
			  
<a href="source/tunjangan/rekap_nominatif_xls.php?kdunit=<?php 
echo $kdunit;
?>
&kdbulan=<?php 
echo $kdbulan;
?>
&th=<?php 
echo $th;
?>
" title="Export Rekap Daftar Nominatif" target="_blank"><font size="1">Excel</font></a>&nbsp;&nbsp;|&nbsp;
<?php 
if ($rdata_status['status_verifikasi_nominatif'] == '1') {
    ?>
		&nbsp;&nbsp;<font color="#006600">[ Status Verifikasi : <?php 
    echo status_nama($rdata_status['status_verifikasi_nominatif']) . ' tanggal ' . reformat_tgl($rdata_status['tanggal_verifikasi_nominatif']);
    ?>
 ]</font>
<?php 
} elseif ($rdata_status['status_verifikasi_nominatif'] == '0') {
    ?>
		&nbsp;&nbsp;<font color="#006600">[ Status Verifikasi : <?php 
    echo status_nama($rdata_status['status_verifikasi_nominatif']);
    ?>
 ]</font>
<?php 
}
?>
<table width="93%" cellpadding="1" class="adminlist">
	<thead>
		<tr>
示例#13
0
            ?>
								<?php 
        }
        ?>
					</td>
                    <td align="center" valign="top">
					<?php 
        switch ($col[14][$k]) {
            case '0':
                echo "<font color='#FF0000'>Draf</font>";
                break;
            case '1':
                echo "<font color='#009933'>Dikirim <br>" . reformat_tgl($col[15][$k]) . "</font>";
                break;
            case '2':
                echo "<font color='#0000FF'>Dinilai <br>" . reformat_tgl($col[15][$k]) . "</font>";
                break;
        }
        ?>
					</td>
                  <td width="16%" align="center" valign="top">
				  <?php 
        if ($xlevel == '2') {
            ?>
			  <a href="index.php?p=270&id_skp=<?php 
            echo $col[0][$k];
            ?>
&pagess=<?php 
            echo $pagess;
            ?>
&cari=<?php 
示例#14
0
        } 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;
        ?>
&cari=<?php 
        echo $cari;
        ?>
" title="Edit Penutupan SKP">
			       <img src="css/images/edit_f2.png" border="0" width="24" height="15"><font size="1">Data Sebelumnya</font></a>					</td>
                  <td width="5%" align="center" valign="top"><?php 
"> 
      <td align="center"><font color="#3333FF">&nbsp;</font></td>
      <td width="15%" align="center"><font color="#3333FF">SPM : <?php 
        echo $SPM['NOSPM'];
        ?>
</font></td>
      <td width="16%" align="center"><font color="#3333FF"><?php 
        echo reformat_tgl($SPM['TGSPM']);
        ?>
</font></td>
      <td width="15%" align="center"><font color="#3333FF">SP2D : <?php 
        echo $SPM['NOSP2D'];
        ?>
</font></td>
      <td width="16%" align="center"><font color="#3333FF"><?php 
        echo reformat_tgl($SPM['TGSP2D']);
        ?>
</font></td>
      <td width="20%" align="right"><font color="#3333FF"><?php 
        echo number_format($SPM['real_spm'], "0", ",", ".");
        ?>
</font></td>
      <td align="right"><font color="#3333FF">&nbsp;</font></td>
    </tr>
    <?php 
        $sql = "select KDAKUN,NILMAK from m_spmmak WHERE THANG='{$th}' and KDSATKER='{$kdsatker}' and NOSPM='{$SPM['NOSPM']}' and NOSP2D='{$SPM['NOSP2D']}' GROUP BY KDAKUN order by KDAKUN";
        $aAkun = mysql_query($sql);
        while ($Akun = mysql_fetch_array($aAkun)) {
            ?>
    <tr class="<?php 
            echo $class;
示例#16
0
					<td align="center" valign="top"><?php 
        echo $limit * ($pagess - 1) + ($k + 1);
        ?>
</td>
					<td align="left" valign="top"><?php 
        echo nama_peg($col[3][$k]);
        ?>
<br /><?php 
        echo 'NIP. ' . reformat_nipbaru($col[3][$k]) . '<br>' . nm_gol($col[6][$k]) . ' / ' . nm_status_peg($col[7][$k]);
        ?>
</td>
					<td align="left" valign="top"><?php 
        echo nm_jabatan_ij($col[5][$k], $col[4][$k]);
        ?>
					<br /><?php 
        echo '[' . reformat_tgl($col[8][$k]) . ']';
        ?>
<br /><?php 
        echo 'Grade ' . $col[9][$k];
        ?>
</td>
					<td align="right" valign="top"><?php 
        echo number_format($col[10][$k], "0", ",", ".");
        ?>
</td>
			        <td align="right" valign="top"><?php 
        echo number_format($col[11][$k], "0", ",", ".");
        ?>
</td>
				    <td align="right" valign="top"><?php 
        echo number_format($col[10][$k] + $col[11][$k], "0", ",", ".");
示例#17
0
            ?>
<blink><?php 
        }
        echo reformat_tgl($col[47][$k]) . '<strong>  s/d  </strong>' . reformat_tgl($col[48][$k]);
        ?>
</td>
				  <td align="left"><?php 
        if ($col[49][$k] != '0000-00-00') {
            if ($col[49][$k] > $col[48][$k]) {
                ?>
<font color="#FF0000" ><?php 
            } else {
                ?>
<font color="#00954A" ><?php 
            }
            echo reformat_tgl($col[49][$k]) . '<br><strong>  No Doc.  </strong>' . trim($col[50][$k]);
            ?>
</font><?php 
        }
        ?>
</td>
	  </tr>
				<?php 
    }
}
?>
	</tbody>
	<tfoot>
		<tr>
			<td colspan="7">&nbsp;</td>
		</tr>
示例#18
0
					<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[6][$k]);
        ?>
</td>
					<td width="5%" align="center">
						<a href="<?php 
        echo $ed[$k];
        ?>
" title="Edit">
							<img src="css/images/edit_f2.png" border="0" width="16" height="16"></a></td>
					<td width="5%" align="center">
						<a href="<?php 
        echo $del[$k];
        ?>
" title="Delete">
							<img src="css/images/stop_f2.png" border="0" width="16" height="16"></a></td>
				</tr><?php 
示例#19
0
        if ($k % 2 == 1) {
            $class = "row0";
        } else {
            $class = "row1";
        }
        ?>
				<tr class="<?php 
        echo $class;
        ?>
">
				  <td height="37" align="center" valign="top"><?php 
        echo $k + 1;
        ?>
</td>
					<td align="center" valign="top"><?php 
        echo reformat_tgl($col[2][$k]);
        ?>
</td>
					<td align="left" valign="top"><?php 
        echo $col[4][$k];
        ?>
</td>
					<td align="left" valign="top"><?php 
        echo $col[5][$k];
        ?>
</td>
					<td align="center" valign="top">
					<?php 
        switch ($col[7][$k]) {
            case '1':
                echo "<font color='#0000FF'>Setuju</font>";
示例#20
0
            echo $column[0][$k];
            ?>
</td>
					<td align="left"><?php 
            echo $column[1][$k];
            ?>
</td>
					<td align="center"><?php 
            echo $column[2][$k];
            ?>
</td>
					<td align="center"><?php 
            echo $column[4][$k];
            ?>
<br /><?php 
            echo reformat_tgl($column[3][$k]);
            ?>
</td>
					<td align="center"><?php 
            echo $column[6][$k];
            ?>
<br /><?php 
            echo $column[5][$k];
            ?>
</td>
					<td align="center"><?php 
            echo $column[7][$k];
            ?>
<br /><?php 
            echo $column[8][$k];
            ?>