toString();
$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']));
$id_pmb = substr($uuid, 0, 6);
$extensi = explode(".", $_FILES['doc']['name']);
$document = "doc-" . $id_pmb . "." . end($extensi);
$sumber = $_FILES['doc']['tmp_name'];
$ukuran_file = $_FILES['doc']['size'];
$tipe_file = $_FILES['doc']['type'];
$inv_extensi = explode(".", $_FILES['inv']['name']);
$inv_document = "inv-" . $id_pmb . "." . end($extensi);
$inv_sumber = $_FILES['inv']['tmp_name'];
$inv_ukuran_file = $_FILES['inv']['size'];
$inv_tipe_file = $_FILES['inv']['type'];
$inv_ukuran_file = $ukuran_file;
$inv_tipe_file = $tipe_file;
if ($ukuran_file <= 1000000) {
if ($tipe_file == "application/pdf") {
$upload = move_uploaded_file($sumber, "doc/" . $document);
$upload = move_uploaded_file($inv_sumber, "inv/" . $inv_document);
mysqli_query($con, "INSERT INTO tb_pmb (id_pmb, tgl_pmb, nama_karyawan, nama_brg, dep, ket_pmb, doc, inv)
VALUES ('$id_pmb', '$tanggal','$nama_karyawan', '$nama_brg', '$dep','$ket','$document','$inv_document')") or die(mysqli_error($con));
echo "";
} else {
echo "";
}
} else {
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 "";
}
}