if (isset($_POST['tgl_sk']) && $_POST['tgl_sk'] != '') {
$sql_data = "SELECT\n\t\t\t\t\t\ta.*, b.pangkat, b.gol_ruang\n\t\t\t\t\tFROM\n\t\t\t\t\t\ttbl_sk_kenpang a\n\t\t\t\t\t\tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd_sk = b.id_pangkat\n\t\t\t\t\tWHERE \n\t\t\t\t\t\ta.tgl_sk LIKE '%" . $_POST['tgl_sk'] . "%'\n\t\t\t\t\tORDER BY\n\t\t\t\t\t\ta.tgl_sk ASC";
} else {
$sql_data = "SELECT\n\t\t\t\t\t\ta.*, b.pangkat, b.gol_ruang\n\t\t\t\t\tFROM\n\t\t\t\t\t\ttbl_sk_kenpang a\n\t\t\t\t\t\tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd_sk = b.id_pangkat\n\t\t\t\t\tORDER BY\n\t\t\t\t\t\ta.tgl_sk ASC LIMIT 5";
}
}
$res_data = mysql_query($sql_data);
while ($ds_data = mysql_fetch_array($res_data)) {
$row_data["id_sk"] = $ds_data["id_data"];
$row_data["no_sk"] = $ds_data["no_sk"];
$row_data["tgl_sk"] = $ds_data["tgl_sk"];
$row_data["jabatan_ttd_sk"] = $ds_data["jabatan_ttd_sk"];
$row_data["nama_ttd_sk"] = $ds_data["nama_ttd_sk"];
$row_data["nip_ttd_sk"] = $ds_data["nip_ttd_sk"];
$row_data["status"] = $ds_data["status_supervisi"];
$row_data["stats"] = status_supervisi($ds_data["status_supervisi"]);
$row_data["no_usul"] = $ds_data["no_usulan_naik_pangkat"];
$row_data["pangkat"] = $ds_data["pangkat"];
$row_data["gol_ruang"] = $ds_data["gol_ruang"];
array_push($data, $row_data);
}
echo "var data = " . json_encode($data) . ";\n";
?>
</script>
<!-- END OF CONTROLLER -->
<!-- JAVASCRIPT PAGE -->
<script type="text/javascript">
function list_peg(id_sk){
$("#dialog_cadis").dialog("open");
$.ajax({
$status_supervisi = 0;
if ($ds["spv_kreat"] == 1 || $ds["tugtam_kreat"] == 1) {
$status_supervisi = 1;
} else {
if ($ds["spv_kreat"] == 2 || $ds["tugtam_kreat"] == 2) {
$status_supervisi = 2;
} else {
if ($ds["spv_kreat"] == 3 || $ds["tugtam_kreat"] == 3) {
$status_supervisi = 3;
}
}
}
?>
<tr>
<td align='center'><?php
echo status_supervisi($status_supervisi);
?>
</td>
<td align='center'><?php
echo $no;
?>
</td>
<td><?php
echo $ds["nama_pegawai"];
?>
</td>
<td align='center'><?php
echo $ds["nip"];
?>
</td>
<td align='center'><?php
<th>Periode</th>
<th width='450px'>Pejabat Penilai</th>
<th width='450px'>Atasan Pejabat Penilai</th>
<th width='20px'> </th>
<th width='20px'> </th>
<th width='20px'> </th>
</tr>
</thead>
<tbody>
<?php
$res = mysql_query("SELECT\n \ta.*, b.nama_pegawai AS nama_pegawai_penilai, b.nip AS nip_penilai, \n\t c.nama_pegawai AS nama_pegawai_atasan_penilai, c.nip AS nip_atasan_penilai\n FROM\n \ttbl_skp a\n \tLEFT JOIN tbl_pegawai b ON a.id_pegawai_penilai = b.id_pegawai\n \tLEFT JOIN tbl_pegawai c ON a.id_atasan_pegawai_penilai = c.id_pegawai\n WHERE\n \ta.id_pegawai = '" . $_SESSION["simpeg_id_pegawai"] . "'\n ORDER BY\n \ta.dari ASC\n ");
$no = 0;
while ($ds = mysql_fetch_array($res)) {
$no++;
echo "<tr>";
echo "<td align='center'>" . status_supervisi($ds["status_supervisi"]) . "</td>";
echo "<td align='center'>" . $no . "</td>";
//echo("<td align='center'>" . $ds["dari"] . "<br/>S/D<br/>" . $ds["dari"] . "</td>");
echo "<td align='center'>" . tglindonesia($ds["dari"]) . " S/D " . tglindonesia($ds["sampai"]) . "</td>";
echo "<td align='center'>" . $ds["nama_pegawai_penilai"] . " (NIP : " . $ds["nip_penilai"] . ")</td>";
echo "<td align='center'>" . $ds["nama_pegawai_atasan_penilai"] . " (NIP : " . $ds["nip_atasan_penilai"] . ")</td>";
echo "<td>\n <img src='image/Edit-32.png' width='18px' class='linkimage' title='Edit Data Periode' onclick='edit(" . $ds["id_skp"] . ")' />\n </td>";
echo "<td>\n <img src='image/icon-disposisi.png' width='18px' class='linkimage' title='Lihat catatan supervisi' onclick='catatan(" . $ds["id_skp"] . ")' />\n </td>";
echo "<td>\n <img src='image/Text-Signature-32.png' width='18px' class='linkimage' title='Lanjut Untuk Mengisikan Uraian Kegiatan' onclick='lanjut(" . $ds["id_skp"] . ")' />\n </td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<th width='50px'> </th>
<th width='50px'> </th>
<th width='50px'> </th>
<th width='50px'> </th>
<th width='50px'> </th>
<th width='50px'> </th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM tbl_usulan_pmk ORDER BY id_usulan ASC";
$query = mysql_query($sql) or die(mysql_error());
$no = 1;
while ($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td style='text-align: center;'><center>" . status_supervisi($row['status_supervisi']) . "</center></td>";
echo "<td style='text-align: center;'><center>" . $no . "</center></td>";
echo "<td style='text-align: center;'><center>" . $row['no_usulan'] . "</center></td>";
echo "<td style='text-align: center;'><center>" . $row['tgl_usulan'] . "</center></td>";
echo "<td style='text-align: center;'><center>" . $row['pejabat_pengusul'] . "</center></td>";
echo "<td style='text-align: center;'><center>" . $row['nip_pejabat_pengusul'] . "</center></td>";
echo "<td style='text-align: center;'><center>" . $row['jabatan_penandatangan'] . "</center></td>";
if ($row['status_supervisi'] == 1) {
echo "<td style='text-align: center;'><button type='button' title='Edit Data' class='btn btn-sm btn-success' style='width: 100%;' onclick='edit(" . $row['id_usulan'] . ");'><span class='glyphicon glyphicon-edit'></span></button></td>";
echo "<td style='text-align: center;'><button type='button' title='Hapus Data' class='btn btn-sm btn-success' style='width: 100%;' onclick='hapus(" . $row['id_usulan'] . ");'><span class='glyphicon glyphicon-trash'></span></button></td>";
echo "<td style='text-align: center;'><button type='button' title='Tambah Pegawai yang diusulkan' class='btn btn-sm btn-success' style='width: 100%;' onclick='tambah(" . $row['id_usulan'] . ");'><span class=' glyphicon glyphicon-plus'></span></button></td>";
echo "<td style='text-align: center;'><button type='button' title='Data Pegawai Yang Diusulkan' class='btn btn-sm btn-success' style='width: 100%;' id='btn_view" . $row['id_usulan'] . "'><span class='glyphicon glyphicon-bookmark'></span></button></td>";
echo "<td style='text-align: center;'><button type='button' title='Proses Ke BKD' class='btn btn-sm btn-success' style='width: 100%;' onclick='proses_ke_bkd(" . $row['id_usulan'] . ");'><span class='glyphicon glyphicon-cog'></span></button></td>";
if (empty($row['catatan'])) {
echo "<td style='text-align: center;'> </td>";
} else {
<?php
$data = array();
$sql_data = "SELECT\n \ta.*, b.pangkat, b.gol_ruang\n FROM\n \ttbl_usulan_pangkat a\n \tLEFT JOIN ref_pangkat b ON a.id_pangkat_ttd = b.id_pangkat\n ORDER BY\n \ta.id_usulan DESC";
$res_data = mysql_query($sql_data);
while ($ds_data = mysql_fetch_array($res_data)) {
$row_data["id_usulan"] = $ds_data["id_usulan"];
$row_data["no_usulan"] = $ds_data["no_usulan"];
$row_data["tgl_usulan"] = tglindonesia($ds_data["tgl_usulan"]);
$row_data["pejabat_ttd"] = $ds_data["nama_pejabat_ttd"];
$row_data["nip_pejabat_ttd"] = $ds_data["nip_pejabat_ttd"];
$row_data["jabatan_ttd"] = $ds_data["jabatan_ttd"];
$row_data["pangkat"] = $ds_data["pangkat"];
$row_data["gol_ruang"] = $ds_data["gol_ruang"];
$row_data["status"] = $ds_data["status_proses"];
$row_data["catatan"] = $ds_data["catatan"];
$row_data["sp"] = status_supervisi($ds_data["status_proses"]);
array_push($data, $row_data);
}
echo "var data = " . json_encode($data) . ";\n";
?>
</script>
<!-- END OF CONTROLLER -->
<!-- JAVASCRIPT PAGE -->
<script type="text/javascript">
function list_peg(id_usulan){
$("#dialog_cadis").dialog("open");
$.ajax({
type: "GET",
url: "ajax/pangkat_daftar_diusulkan.php",
data: "id_usulan=" + id_usulan,
while ($ds = mysql_fetch_array($res)) {
$status_supervisi = 0;
if ($ds["spv_kreat"] == 1 || $ds["spv_tugtam"] == 1) {
$status_supervisi = 1;
} else {
if ($ds["spv_kreat"] == 2 || $ds["spv_tugtam"] == 2) {
$status_supervisi = 2;
} else {
if ($ds["spv_kreat"] == 3 || $ds["spv_tugtam"] == 3) {
$status_supervisi = 3;
}
}
}
$no++;
echo "<tr>";
echo "<td align='center'>" . status_supervisi($status_supervisi) . "</td>";
echo "<td align='center'>" . $no . "</td>";
//echo("<td align='center'>" . $ds["dari"] . "<br/>S/D<br/>" . $ds["dari"] . "</td>");
echo "<td align='center'>" . tglindonesia($ds["dari"]) . " S/D " . tglindonesia($ds["sampai"]) . "</td>";
echo "<td align='center'>" . $ds["nama_pegawai_penilai"] . " (NIP : " . $ds["nip_penilai"] . ")</td>";
echo "<td align='center'>" . $ds["nama_pegawai_atasan_penilai"] . " (NIP : " . $ds["nip_atasan_penilai"] . ")</td>";
echo "<td>\n\t\t\t\t\t\t\t\t\t\t\t<img src='image/Text-Signature-32.png' width='18px' class='linkimage' title='Lanjut Untuk Mengisikan Data Hasil Penilaian Perilaku' onclick='lanjut(" . $ds["id_skp"] . ", " . $ds["id_pegawai"] . ")' />\n\t\t\t\t\t\t\t\t\t\t </td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</td>
