toString();
$tanggal = trim(mysqli_real_escape_string($con, $_POST['tanggal']));
$ket = trim(mysqli_real_escape_string($con, $_POST['ket']));
$ket = ucfirst($ket);
$id_doc = substr($uuid, 0, 6);
$extensi = explode(".", $_FILES['doc']['name']);
$document = $ket . "." . end($extensi);
$sumber = $_FILES['doc']['tmp_name'];
$upload = move_uploaded_file($sumber, "doc/" . $document);
mysqli_query($con, "INSERT INTO tb_doc (id_doc, tgl_doc, ket_doc, doc)
VALUES ('$id_doc', '$tanggal','$ket','$document')") or die(mysqli_error($con));
echo "";
} else if (isset($_POST['edit'])) {
$id = $_POST['id'];
$tanggal = trim(mysqli_real_escape_string($con, $_POST['tanggal']));
$nama_karyawan = trim(mysqli_real_escape_string($con, $_POST['nama_karyawan']));
$nama_brg = trim(mysqli_real_escape_string($con, $_POST['nama_brg']));
$dep = trim(mysqli_real_escape_string($con, $_POST['nama_karyawan']));
$ket = trim(mysqli_real_escape_string($con, $_POST['ket']));
if (isset($_POST['ubah_doc'])) {
$extensi = explode(".", $_FILES['doc']['name']);
$document = "doc-" . round(microtime(true)) . "." . end($extensi);
$sumber = $_FILES['doc']['tmp_name'];
$ukuran_file = $_FILES['doc']['size'];
$tipe_file = $_FILES['doc']['type'];
if ($ukuran_file <= 1000000) {
if ($tipe_file == "application/pdf") {
} else {
echo "";
}
} else {
echo "";
}
if (!$upload = move_uploaded_file($sumber, "doc/" . $document)) {
echo "";
} else {
$upload = move_uploaded_file($sumber, "doc/" . $document);
$sql_user = mysqli_query($con, "SELECT * FROM tb_pmb WHERE id_pmb = '$id'") or die(mysqli_error($con));
while ($data = mysqli_fetch_array($sql_user)) {
unlink("doc/" . $data['doc']);
}
mysqli_query($con, "UPDATE tb_pmb SET tgl_pmb = '$tanggal', nama_karyawan = '$nama_karyawan', nama_brg = '$nama_brg', dep = '$dep', ket_pmb = '$ket', doc = '$document' WHERE id_pmb = '$id'") or die(mysqli_error($con));
echo "";
}
}
if (isset($_POST['ubah_inv'])) {
$extensi = explode(".", $_FILES['inv']['name']);
$document = "inv-" . round(microtime(true)) . "." . end($extensi);
$sumber = $_FILES['inv']['tmp_name'];
$ukuran_file = $_FILES['inv']['size'];
$tipe_file = $_FILES['inv']['type'];
if ($ukuran_file <= 1000000) {
if ($tipe_file == "application/pdf") {
} else {
echo "";
}
} else {
echo "";
}
if (!$upload = move_uploaded_file($sumber, "inv/" . $document)) {
echo "";
} else {
$upload = move_uploaded_file($sumber, "inv/" . $document);
$sql_user = mysqli_query($con, "SELECT * FROM tb_pmb WHERE id_pmb = '$id'") or die(mysqli_error($con));
while ($data = mysqli_fetch_array($sql_user)) {
unlink("inv/" . $data['inv']);
}
mysqli_query($con, "UPDATE tb_pmb SET tgl_pmb = '$tanggal', nama_karyawan = '$nama_karyawan', nama_brg = '$nama_brg', dep = '$dep', ket_pmb = '$ket', inv = '$document' WHERE id_pmb = '$id'") or die(mysqli_error($con));
echo "";
}
} else {
mysqli_query($con, "UPDATE tb_pmb SET tgl_pmb = '$tanggal', nama_karyawan = '$nama_karyawan', nama_brg = '$nama_brg', dep = '$dep', ket_pmb = '$ket' WHERE id_pmb = '$id'") or die(mysqli_error($con));
echo "";
}
}