<?php
if(isset($_POST['button']))
{
$newDate = date("Y-m-d", strtotime($_POST['inputdate']));
$expDate = strtotime('+7 days', $newDate);
$q=mysql_query("Insert into barang_masuk (`tgl`,`kode_barang`,`jumlah`) values ('".$newDate."','".$_POST['kodebarang']."','".$_POST['qty']."')") or die(mysql_error());
$q2=mysql_query("Select * from data_persediaan where kode_barang='".$_POST['kodebarang']."'");
$rc=mysql_num_rows($q2);
if($rc==1)
{
$q3=mysql_query("Update data_persediaan SET masuk=masuk + ".$_POST['qty'].",stok_tersedia=stok_tersedia + ".$_POST['qty']." Where kode_barang='".$_POST['kodebarang']."'");
if($q3)
{
echo "Data sudah disimpan";
}
}else{
$q4=mysql_query("Insert into data_persediaan (`kode_barang`,`stok_awal`,`masuk`,`stok_tersedia`) values ('".$_POST['kodebarang']."','".$_POST['qty']."','".$_POST['qty']."','".$_POST['qty']."')");
if($q4)
{
echo "Data sudah disimpan";
}
}
}
?>
preferences:
46.56 ms | 402 KiB | 5 Q