<?php 
include 'connect.php';
session_start();

$nobukti=$_SESSION['nobukti'];
$cabang=$_SESSION['cbg'];
$kdharga=$_SESSION['kdharga'];
$kdgudang=$_SESSION['gudang'];
$kdslm=$_SESSION['kdslm'];;
$custno=$_SESSION['custno'];


$kdbrg = $_GET['kdbrg'];
$qtyb = $_GET['qtyb'];
$qtym = $_GET['qtym'];
$qtyk = $_GET['qtyk'];
$saldo=$_GET['saldo'];

$disc11 = $_GET['disc1'];
$disc21 = $_GET['disc2'];
$disc31 = $_GET['disc3'];
if ($disc11==null) $disc11=0;
if ($disc21==null) $disc21=0;
if ($disc31==null) $disc31=0;
$disc1=$disc11;
$disc2=$disc21;
$disc3=$disc31;
$ndisc1=0;
$ndisc2=0;
$ndisc3=0;


$carisatuan=mysqli_query($con,"select isi1,isi2,isi3,kontrib,kdsupplier,namabrg1 from barang where kdbrg='$kdbrg';");
$hasilsatuan=mysqli_fetch_array($carisatuan);

$kdsupplier=$hasilsatuan['kdsupplier'];
$isi1=$hasilsatuan['isi1'];
$isi2=$hasilsatuan['isi2'];
$isi3=$hasilsatuan['isi3'];
$namabrg1=$hasilsatuan['namabrg1'];
$ppn=$hasilsatuan['kontrib'];
if ($ppn==10)  $dppn=1.1;
if  ($ppn==0) $dppn=1;




$tqtyb=$qtyb*$isi1*$isi2;
if ($tqtyb == null) $tqtyb=0;
$tqtym=$qtym*$isi2;
if ($tqtym == null) $tqtym=0;
$tqtyk=$qtyk;
if ($tqtyk == null) $tqtyk=0;
$qty=$tqtyb+$tqtym+$tqtyk;
if ($saldo == null) $saldo=0;
$stok=$saldo-$qty;
if ($stok==null) $stok=0;

$charga=mysqli_query($con,"select kdharga from customer_kh where custno='$custno' and kdsupplier='$kdsupplier';");
$hasilcharga=mysqli_fetch_array($charga);
$kdhargadetail=$hasilcharga['kdharga'];
if ($kdhargadetail== null) $kdhargadetail=$kdharga;

$cariharga=mysqli_query($con,"select hrgkecil from hargajual where kdbrg='$kdbrg' and kdharga='$kdhargadetail' order by tglberlaku desc limit 1;");
$hargajual=mysqli_fetch_array($cariharga);
$hs=($hargajual['hrgkecil']);
if ($hs==null) $hs=0;
$bruto=($qty*$hs);
if ($bruto==null) $bruto=0;

if ($disc1<>0) {
	$ndisc1=($bruto*($disc1/100));
	if ($ndisc1==null) $ndisc1=0;
	}
if ($disc2<>0) {
	$ndisc2=(($bruto-$ndisc1)*($disc2/100));
	if ($ndisc2==null) $ndisc2=0;
	}
if ($disc3<>0) {
	$ndisc3=(($bruto-$ndisc1-$ndisc2)*($disc3/100));
	if ($ndisc3==null) $ndisc3=0;
	}	
	
$total=($bruto-$ndisc1-$ndisc2-$ndisc3);
if ($total==null) $total=0;

$cekada="select kdbrg from stokkanvas where kdbrg='$kdbrg' and kdgudang='$kdgudang';";
$ada=mysqli_query($con,$cekada);


//echo $nobukti;
//echo $cabang ;
//echo $kdharga;
//echo $kdgudang ;
//echo $kdbrg;
//echo $kdslm ;
//echo $hs ;
//echo $qty ;
//echo $total;
//echo $ppn;
//echo $disc1;
//echo $disc2;
//echo $ndisc1;
//echo $ndisc2;

$simpan=mysqli_query($con,"insert into somobiledetail
(cabang,nobukti,kdbrg,qty,hs,total,kdgudang,kdslm,kdharga,ppn,disc1,disc2,disc3,ndisc1,ndisc2,ndisc3) values
('$cabang','$nobukti','$kdbrg','$qty','$hs','$total','$kdgudang','$kdslm','$kdhargadetail','$ppn','$disc1','$disc2','$disc3','$ndisc1','$ndisc2','$ndisc3');");

if ($ada>1) {
$stokkanvas=mysqli_query($con,"update stokkanvas set qty=qty+'$qty' where kdbrg='$kdbrg' and kdgudang='$kdgudang';");
} else {
	$stokkanvas=mysqli_query($con,"INSERT IGNORE INTO stokkanvas(kdbrg,kdgudang,qty,namabrg1,isi3) 
							VALUE ('$kdbrg','$kdgudang','$qty','$namabrg1','$isi3')");
}						

?>
 <meta http-equiv="refresh" content="0; url=salesreturkanvas.php?id=<?php echo $nobukti;?>" >
