<?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"> </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"> </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;
<?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
?>
&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
} 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) {
?>
$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];
?>
}
?>
</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>
?>
">
<td align="center" valign="top"> </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
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
$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)) {
$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'];
<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> |
<?php
if ($rdata_status['status_verifikasi_nominatif'] == '1') {
?>
<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') {
?>
<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>
?>
<?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
} 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"> </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"> </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;
<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", ",", ".");
?>
<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"> </td>
</tr>
<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
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>";
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];
?>