aksi-proses

<?php
include "../../config/koneksi.php";

$noFaktur   = $_POST['noFaktur'];

$subtotal   = mysql_fetch_array(mysql_query("select sum(subtotal) as total from tblsementara"));
$tot        = $subtotal['total'];

$simpan     = mysql_query("insert into penjualan(no_faktur,tanggal,tot_hrg) values ('$noFaktur',now(),'$tot')");

if($simpan){
    $query=mysql_query("select * from tblsementara");
    while($r=mysql_fetch_row($query)){
        mysql_query("insert into tbldetailjual(no_faktur,kd_brg,nm_brg,hrg_jual,hrg_terjual,potongan,qty,subtotal) values('','$r[0]','$r[1]','$r[2]','$r[3]','$r[4]','$r[5]','$r[6]','$r[7]')");
        mysql_query("update tblbarang set stok=stok-'$r[6]' where kd_brg='$r[1]'");
    }
    //hapus seluruh isi tabel sementara
    mysql_query("truncate table tblsementara");
    echo "<script type='text/javascript'>
            alert('Data Berhasil Disimpan...!!!');
        </script>";
        echo "<meta http-equiv='refresh' content='0; ../modul.php?page=tampilPenjualan'>";
}
else{
    echo "<script type='text/javascript'>
            alert('Data Gagal Disimpan...!!!');
        </script>";
        echo "<meta http-equiv='refresh' content='0; ../modul.php?page=tambahPenjualan'>";
}
?>