if(isset($_POST['masuk'])){
$id_data_barang = $_POST['id_data_barang'];
$nama_barang = $_POST['nama_barang'];
$qty = $_POST['qty'];
$tanggal_masuk = $_POST['tanggal_masuk'];
$nama_toko_barang = $_POST['nama_toko_barang'];
$nama_pegawai = $_POST['nama_pegawai'];
$query = mysqli_query($con,"INSERT INTO barang_masuk (id_data_barang, nama_barang, qty, tanggal_masuk, nama_toko_barang, nama_pegawai) values ('$id_data_barang','$nama_barang','$qty','$tanggal_masuk','$nama_toko_barang','$nama_pegawai')");
$query2 = mysqli_query($con, "SELECT * FROM data_barang WHERE data_barang.id_data_barang = '$id_data_barang'");
$data = mysqli_fetch_array($query2);
$stok_awal = $data['stock'];
$stok_akhir1 = $stok_awal + $qty ;
$qty = $qty;
$query3 = mysqli_query($con, "UPDATE data_barang SET stock = '$stok_akhir1' WHERE data_barang.id_data_barang = '$id_data_barang' ");
if($query){
header('location:barang_masuk.php');
} else {
echo '
<script>alert("Gagal Menambahkan");
window.location.href=barang_masuk.php
</script>
';
}
} else if(isset($_POST['editbarangmasuk'])) {
// EDIT DATA PEMBELIAN
$id_masuk = $_POST['id_masuk'];
$id_data_barang = $_POST['id_data_barang'];
$qty = $_POST['qty'];
// TRIGGER EDIT STOK BARANG
$query2 = mysqli_query($con, "SELECT * FROM data_barang WHERE data_barang.id_data_barang = '$id_data_barang'");
$data = mysqli_fetch_array($query2);
$stok_awal = $data['stock'] ?? 0;
// $stok_akhir1 = $stok_awal + $jumlah_pembelian;
$query = "SELECT * FROM barang_masuk WHERE barang_masuk.id_masuk = '$id_masuk' ";
$sql_pm = mysqli_query($con, $query) or die (mysqli_error($con));
$data = mysqli_fetch_array($sql_pm);
$stok_awal = $data['qty'] ?? 0;
$stok = ($stok_awal - $data['qty']) + $qty;
$queryz = mysqli_query($con, "UPDATE barang_masuk SET qty='$qty' WHERE id_masuk ='$id_masuk'");
$query5 = mysqli_query($con, "UPDATE data_barang SET stock = '$stock' WHERE data_barang.id_data_barang = '$id_data_barang'");
// END TRIGGER EDIT STOK BARANG
if($queryz){
// BERPINDAH HALAMAN
header('location:barang_masuk.php');
} else {
echo '
<script>alert("Gagal Update");
window.location.href=barang_masuk.php
</script>
';
}
}