<?php 
include 'connect.php';
session_start();

$nobukti=$_GET['nobukti'];
$cabang=$_GET['cbg'];
$kdharga=$_GET['kdharga'];
$kdgudang=$_GET['gudang'];
$kdslm=$_GET['kdslm'];
$custno=$_GET['custno'];
$tglso=date('Y-m-d');

$kdbrg = $_GET['kdbrg'];
$qtyb = $_GET['qtyb'];
$qtym = $_GET['qtym'];
$qtyk = $_GET['qtyk'];


$carisatuan=mysqli_query($con,"select isi1,isi2,isi3,kontrib,kdsupplier from barang where kdbrg='$kdbrg';");
$hasilsatuan=mysqli_fetch_array($carisatuan);

$kdsupplier=$hasilsatuan['kdsupplier'];
$isi1=$hasilsatuan['isi1'];
$isi2=$hasilsatuan['isi2'];
$isi3=$hasilsatuan['isi3'];
$ppn=$hasilsatuan['kontrib'];
if ($ppn==10)  $dppn=1.1;
if  ($ppn==0) $dppn=1;
if($qtyb == null) {$qtyb=0;}
if($qtym == null) {$qtym=0;}
if($qtyk == null) {$qtyk=0;}
if($isi1 == null) {$isi1=1;}
if($isi2 == null) {$isi2=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;
$kdhargadetail=$kdharga;

$charga=mysqli_query($con,"select kdharga from customer_kh where custno='$custno' and kdsupplier='$kdsupplier';");
$hasilcharga=mysqli_fetch_array($charga);
$satu=mysqli_num_rows($charga);
if($satu>0) {
    $kdhargadetail=$hasilcharga['kdharga'];
    }


$cariharga=mysqli_query($con,"select hrgkecil,hrgbesar from hargajual where kdbrg='$kdbrg' and kdharga='$kdhargadetail' and tglberlaku<=curdate() order by tglberlaku desc limit 1;");
$hargajual=mysqli_fetch_array($cariharga);
$hs=($hargajual['hrgkecil']);
$hs1=($hargajual['hrgbesar']);
if ($hs==null) $hs=0;
if ($hs1==null) $hs1=0;
$total=($qty*$hs);

$simpan=mysqli_query($con,"insert into somobiledetail(cabang,nobukti,kdbrg,qty,hs,hs1,isi3,total,kdgudang,kdslm,kdharga,ppn,tgl) values ('$cabang','$nobukti','$kdbrg','$qty','$hs','$hs1','$isi3','$total','$kdgudang','$kdslm','$kdhargadetail','$ppn','$tglso');");
?>
 <meta http-equiv="refresh" content="0; url=salesorder.php?id=<?php echo $nobukti;?>" >
