<?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"; }