<?php
include "../php/koneksi.php";
include "../php/fungsi.php";
$id_data = mysql_real_escape_string($_GET['id_data']);
$nip = get_nip_riwayat_pendidikan($id_data);
$sql = "SELECT\n a.id_data_rp as 'id_data', a.nip, b.nama_pegawai, c.tingkat_pendidikan , a.tempat_pendidikan, \n a.k_a_tempat_pendidikan as 'kepala' ,a.nilai, a.no_ijazah, a.tgl_ijazah\n FROM\n \ttbl_riwayat_pendidikan a\n \tLEFT JOIN tbl_pegawai b ON a.nip = b.nip\n \tLEFT JOIN ref_tingkat_pendidikan c ON a.id_tingkat_pendidikan = c.id_tingkat_pendidikan\n WHERE\n \ta.nip = '" . $nip . "' \n ORDER BY\n \tc.id_tingkat_pendidikan ASC\n ";
$res = mysql_query($sql);
echo "<div class='judullist'>Daftar Riwayat Pendidikan " . detail_pegawai_by_nip($nip, "nama_pegawai") . " (NIP : " . $nip . ")</div><br/>";
echo "<table border='1' cellspacing='0' cellpadding='3'>";
echo "<tr>\n\t\t\t <td><center><b>No</center></b></td>\n\t\t\t <td><center><b>Tingkat Pendidikan</center></b></td>\t\n\t\t\t <td><center><b>Tempat Pendidikan</center></b></td>\n\t\t\t <td><center><b>Nama Kepala Tempat Pendidikan</center></b></td>\n\t\t\t <td><center><b>Nilai/Index</center></b></td>\n\t\t\t <td><center><b>No. Ijazah</center></b></td>\n\t\t\t <td width='100px;'><center><b>Tgl. Ijazah</center></b></td>\n\t\t </tr>\t\n\t";
$no = 1;
while ($row = mysql_fetch_array($res)) {
echo "<tr>\n\t\t\t <td><center>" . $no . "</center></td>\n\t\t\t <td><center>" . $row['tingkat_pendidikan'] . "</center></td>\t\n\t\t\t <td><center>" . $row['tempat_pendidikan'] . "</center></td>\n\t\t\t <td><center>" . ($row['kepala'] == "" ? "-" : $row['kepala']) . "</center></td>\n\t\t\t <td><center>" . $row['nilai'] . "</center></td>\n\t\t\t <td><center>" . $row['no_ijazah'] . "</center></td>\n\t\t\t <td><center>" . tglindonesia($row['tgl_ijazah']) . "</center></td>\n\t\t </tr>\t\n\t\t";
$no++;
}
echo "</table>";
<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
$id_usulan = $_POST["id_usulan"];
$id_pegawai = detail_pegawai_by_nip($_POST["nip"], "id_pegawai");
$nama_pegawai = detail_pegawai_by_nip($_POST["nip"], "nama_pegawai");
$sql = "INSERT INTO tbl_usulan_pg_detail(id_usulan, id_pegawai, status) VALUES('" . $id_usulan . "', '" . $id_pegawai . "', 1)";
$query = mysql_query($sql);
if ($query) {
$encode = base64_encode($nama_pegawai);
header("location:../../?mod=pg_daftar_usulan_diusulkan&id_usulan=" . $id_usulan . "&code=1&name=" . $encode);
} else {
header("location:../../?mod=pg_daftar_usulan_diusulkan&id_usulan=" . $id_usulan . "&code=2");
}
//echo("Data usulan telah disimpan");
<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
if ($_POST["nip"] != "") {
$id_pegawai = detail_pegawai_by_nip($_POST["nip"], "id_pegawai");
mysql_query("INSERT INTO tbl_usulan_cerai(id_pegawai) VALUES('" . $id_pegawai . "')");
}
header("location:../../?mod=cerai_daftar_usulan_tambah");
<?php
include "../koneksi.php";
include "../fungsi.php";
include "../mysqli_connect.php";
$id_sk = $_POST['id_sk'];
$id_detail = get_id_detail_sk_pmk();
$nip = $_POST['nip_2'];
$id_pegawai = detail_pegawai_by_nip($nip, "id_pegawai");
$tmt = $_POST['tmt2'];
$status = 1;
$sql = "INSERT INTO tbl_sk_pmk_detail VALUES(?,?,?,?,?)";
$stm = $con->prepare($sql);
$stm->bind_param('iiisi', $id_detail, $id_sk, $id_pegawai, $tmt, $status);
$query = $stm->execute();
if ($query) {
echo "\n\t\t\t<script>\n\t\t\t\talert('Tambah Data Pegawai Sukses !!');\n\t\t\t\tdocument.location.href='../../?mod=sk_pmk_tambah_pegawai&id_data=" . $id_sk . "';\n\t\t\t</script>\t\n\t\t";
} else {
echo "\n\t\t\t<script>\n\t\t\t\talert('Maaf, Tambah Data Gagal !!');\n\t\t\t\tdocument.location.href='../../?mod=sk_pmk_tambah_pegawai&id_data=" . $id_sk . "';\n\t\t\t</script>\t\n\t\t";
}
<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
if ($_POST["id_skp"] == 0) {
$sql = "INSERT INTO tbl_skp VALUES(null, '" . $_SESSION["simpeg_id_pegawai"] . "' , '" . detail_pegawai_by_nip($_POST["nip_pejabat_penilai"], "id_pegawai") . "',\n '" . detail_pegawai_by_nip($_POST["nip_atasan_pejabat_penilai"], "id_pegawai") . "',\n '" . $_POST["dari"] . "', '" . $_POST["sampai"] . "', 1)";
} else {
$sql = "UPDATE tbl_skp SET\n id_pegawai_penilai='" . detail_pegawai_by_nip($_POST["nip_pejabat_penilai"], "id_pegawai") . "',\n id_atasan_pegawai_penilai='" . detail_pegawai_by_nip($_POST["nip_atasan_pejabat_penilai"], "id_pegawai") . "',\n dari='" . $_POST["dari"] . "',\n sampai='" . $_POST["sampai"] . "',\n status_supervisi='1'\n WHERE id_skp='" . $_POST["id_skp"] . "'";
}
mysql_query($sql);
header("location:../../?mod=skp_target");
<?php
include "../koneksi.php";
include "../fungsi.php";
include "../mysqli_connect.php";
$id_sk = $_POST['id_sk'];
$id_detail = get_id_detail_sk_kenpang();
$nip = $_POST['nip'];
$id_pegawai = detail_pegawai_by_nip($nip, "id_pegawai");
$nama = detail_pegawai_by_nip($nip, "nama_pegawai");
$id_pangkat_baru = $_POST['id_pangkat_baru'];
$id_jabatan_baru = $_POST['id_jabatan_baru'];
$status = 1;
$encode = base64_encode($nama);
$sql = "INSERT INTO tbl_sk_kenpang_detail VALUES(?,?,?,?,?,?)";
$stm = $con->prepare($sql);
$stm->bind_param('iiiiii', $id_detail, $id_sk, $id_pegawai, $id_pangkat_baru, $id_jabatan_baru, $status);
$query = $stm->execute();
if ($query) {
echo "\n\t\t\t<script>\n\t\t\t\talert('Tambah Data Pegawai Sukses !!');\n\t\t\t\tdocument.location.href='../../?mod=sk_kenpang_tambah_pegawai&id_data=" . $id_sk . "';\n\t\t\t</script>\t\n\t\t";
} else {
echo "\n\t\t\t<script>\n\t\t\t\talert('Maaf, Tambah Data Gagal !!');\n\t\t\t\tdocument.location.href='../../?mod=sk_kenpang_tambah_pegawai&id_data=" . $id_sk . "';\n\t\t\t</script>\t\n\t\t";
}
