<?php
session_start();
include "../koneksi.php";
include "../fungsi.php";
$id_rp = getIDTabelRiwayatPangkat();
$sttspv = 1;
if ($_SESSION["simpeg_id_level"] == 12) {
$sttspv = 3;
}
$sql = "INSERT INTO tbl_riwayat_pangkat VALUES('" . $id_rp . "', '" . $_SESSION["simpeg_id_pegawai"] . "', '" . $_POST["id_pangkat"] . "', '" . $_POST["tmt"] . "', '" . $_POST["no_sk"] . "',\n '" . $_POST["tgl_sk"] . "', '" . $_POST["pejabat_penetapan"] . "', '" . $sttspv . "')";
mysql_query($sql);
update_pangkat_pegawai($_SESSION["simpeg_id_pegawai"]);
header("location:../../?mod=riwayat_pangkat");
// function get ID Tabel
function getIDTabelRiwayatPangkat()
{
$query = mysql_query("SELECT MAX(id_data) as 'Max' FROM tbl_riwayat_pangkat") or die(mysql_error());
$row = mysql_fetch_array($query);
$maks = $row['Max'];
$ID = "";
if ($maks > 0) {
$ID = $maks + 1;
} else {
$ID = 1;
}
return $ID;
}
<?php
include "../mysqli_connect.php";
include "../koneksi.php";
include "../fungsi.php";
$id_sk = $_GET['id_sk'];
$sql = "";
$qr = "SELECT * FROM tbl_sk_kenpang_detail WHERE id_sk = '" . $id_sk . "'";
$no_sk = get_field_in_table_sk_kenpang($id_sk, "no_sk");
$tgl_sk = get_field_in_table_sk_kenpang($id_sk, "tgl_sk");
$pejabat = get_field_in_table_sk_kenpang($id_sk, "nama_ttd_sk");
$ex = mysql_query($qr) or die(mysql_error());
$count = mysql_num_rows($ex);
$sql .= "UPDATE tbl_sk_kenpang SET status_supervisi = 3 WHERE id_data = '" . $id_sk . "';";
$index = getIDTabelRiwayatPangkat();
while ($row = mysql_fetch_array($ex)) {
$sql .= "UPDATE tbl_pegawai SET id_pangkat = '" . $row['id_pangkat_baru'] . "' WHERE id_pegawai = '" . $row['id_pegawai'] . "';";
$sql .= "INSERT INTO tbl_riwayat_pangkat VALUES('" . $index . "', '" . $row['id_pegawai'] . "', '" . $row['id_pangkat_baru'] . "', \n\t\t\t\t\tCURDATE(), '" . $no_sk . "', '" . $tgl_sk . "', '" . $pejabat . "','3');";
$index++;
}
$query = $con->multi_query($sql);
if ($query) {
echo "sukses";
} else {
echo "gagal";
}
function getIDTabelRiwayatPangkat()
{
$query = mysql_query("SELECT MAX(id_data) as 'Max' FROM tbl_riwayat_pangkat") or die(mysql_error());
$row = mysql_fetch_array($query);
$maks = $row['Max'];
