if($mutasi=='mutasi masuk'){
$jumlahbaru = $jumlah + $selisih;
alurstok($tgl,$mutasi,'-',$kode,$selisih);
$hasil = mysql_query( "UPDATE `pos_produk` SET `jumlah`='$jumlahbaru' WHERE `id`='$id'" );
}elseif ($mutasi=='mutasi keluar')
{
$jumlahbaru = $jumlah - $selisih;
alurstok($tgl,$mutasi,'-',$kode,$selisih);
$hasil = mysql_query( "UPDATE `pos_produk` SET `jumlah`='$jumlahbaru' WHERE `id`='$id'" );
}else{
$ceksaldoawal = ceksaldoawal($kode);
if($ceksaldoawal=='0' and $jumlah=='0'){
alurstok($tgl,$mutasi,'-',$kode,$selisih);
$hasil = mysql_query( "UPDATE `pos_produk` SET `jumlah`='$selisih' WHERE `id`='$id'");
}elseif($ceksaldoawal=='0' and $jumlah){
alurstok($tgl,$mutasi,'-',$kode,$jumlah);
}
else{
$hasil = mysql_query( "UPDATE `pos_alur_stok` SET `jumlah`='$jumlah' WHERE `id`='$id'" );
}
}
// $hasil = mysql_query( "UPDATE `pos_produk` SET `jumlah`='$jumlahbaru' WHERE `id`='$id'" );
if($hasil){
$admin .= '<div class="sukses"><b>Berhasil di Update.</b></div>';
// $style_include[] ='<meta http-equiv="refresh" content="1; url=admin.php?pilih=produk&mod=yes&aksi=stokopname" />';
}else{
$admin .= '<div class="error"><b>Gagal di Update.</b></div>';
}
}
}
if($carabayar=='Potong Piutang'){
potongpiutang($nofaktur,$total);
}
$hasil = mysql_query( "INSERT INTO `pos_penjualanretur` VALUES ('','$noretur','$nofaktur','$tgl','$kodecustomer','$carabayar','$total','$user')" );
$idpenjualan = mysql_insert_id();
foreach ($_SESSION["product_id"] as $cart_itm)
{
$kode = $cart_itm["kode"];
$jumlah = $cart_itm["jumlah"];
$harga = $cart_itm["harga"];
$subdiscount = $cart_itm["subdiscount"];
$subtotal = $cart_itm["subtotal"];
$hasil = mysql_query( "INSERT INTO `pos_penjualanreturdetail` VALUES ('','$noretur','$nofaktur','$kode','$jumlah','$harga','$subdiscount','$subtotal')" );
updatestokjualretur($kode,$jumlah);
alurstok($tgl,'Retur Penjualan',$noretur,$kode,$jumlah);
}
if($hasil){
$admin .= '<div class="sukses"><b>Berhasil Menambah Retur Penjualan.</b></div>';
penjualanreturrefresh();
penjualanreturcetak($noretur);
unset ($kodecustomer);
$style_include[] ='<meta http-equiv="refresh" content="1; url=admin.php?pilih=penjualanretur&mod=yes" />';
}else{
$admin .= '<div class="error"><b>Gagal Menambah Retur Penjualan.</b></div>';
}
}
}
if(isset($_POST['tambahcustomer'])){
$_SESSION['kodecustomer'] = $_POST['kodecustomer'];
}
else{
$hasil = mysql_query( "INSERT INTO `po_pembelian` VALUES ('','$noinvoice','$nopo','$tgl','$kodesupplier','$notasupplier','$carabayar','$total','$discount','$netto','$bayar','0','0','','$user')" );
}
$idpembelian = mysql_insert_id();
foreach ($_SESSION["product_id"] as $cart_itm)
{
$kode = $cart_itm["kode"];
$jenis = $cart_itm["jenis"];
$jumlah = $cart_itm["jumlah"];
$harga = $cart_itm["harga"];
$subdiscount = $cart_itm["subdiscount"];
$subtotal = $cart_itm["subtotal"];
$hasil = mysql_query( "INSERT INTO `po_pembeliandetail` VALUES ('','$noinvoice','$nopo','$kode','$jenis','$jumlah','$harga','$subdiscount','$subtotal')" );
updatestokbeli($kode,$jumlah);
alurstok($tgl,'Pembelian',$noinvoice,$kode,$jumlah);
}
if($hasil){
$admin .= '<div class="sukses"><b>Berhasil Menambah Pembelian.</b></div>';
pembeliancetak($noinvoice);
pembelianrefresh();
$notasupplier ='';
}else{
$admin .= '<div class="error"><b>Gagal Menambah Pembelian.</b></div>';
}
}
}
if(isset($_POST['tambahsupplier'])){
$kodesupplier = $_POST['kodesupplier'];
$hasil = $koneksi_db->sql_query( "SELECT * FROM pos_supplier WHERE kode='$kodesupplier'" );
} else {
$hasil = mysql_query("INSERT INTO `pos_penjualan` VALUES ('','{$nofaktur}','{$nopo}','{$tgl}','{$kodecustomer}','{$carabayar}','{$total}','{$discount}','{$netto}','{$bayar}','0','0','','{$user}')");
}
$idpenjualan = mysql_insert_id();
foreach ($_SESSION["product_id"] as $cart_itm) {
$kode = $cart_itm["kode"];
$jenis = $cart_itm["jenis"];
$jumlah = $cart_itm["jumlah"];
$harga = $cart_itm["harga"];
$hargabeli = $cart_itm["hargabeli"];
$subdiscount = $cart_itm["subdiscount"];
$subtotal = $cart_itm["subtotal"];
$hasil = mysql_query("INSERT INTO `pos_penjualandetail` VALUES ('','{$nofaktur}','{$nopo}','{$jenis}','{$kode}','{$jumlah}','{$harga}','{$hargabeli}','{$subdiscount}','{$subtotal}')");
updatestokjual($kode, $jumlah);
updatehargajual($kode, $harga);
alurstok($tgl, 'Penjualan', $nofaktur, $kode, $jumlah);
}
if ($hasil) {
$admin .= '<div class="sukses"><b>Berhasil Menambah Penjualan.</b></div>';
penjualancetak($nofaktur);
penjualanrefresh();
//$style_include[] ='<meta http-equiv="refresh" content="1; url=admin.php?pilih=penjualan&mod=yes" />';
} else {
$admin .= '<div class="error"><b>Gagal Menambah Penjualan.</b></div>';
}
}
}
if (isset($_POST['tambahcustomer'])) {
$_SESSION['kodecustomer'] = $_POST['kodecustomer'];
echo "<script type=\"text/javascript\">\n window.open('cetak_nofaktur.php', '_new')\n </script>";
}
}else{
if($carabayar=='Potong Hutang'){
potonghutang($noinvoice,$total);
}
$hasil = mysql_query( "INSERT INTO `pos_pembelianretur` VALUES ('','$noretur','$noinvoice','$tgl','$kodesupplier','$carabayar','$total','$user')" );
$idpembelian = mysql_insert_id();
foreach ($_SESSION["product_id"] as $cart_itm)
{
$kode = $cart_itm["kode"];
$jumlah = $cart_itm["jumlah"];
$harga = $cart_itm["harga"];
$subdiscount = $cart_itm["subdiscount"];
$subtotal = $cart_itm["subtotal"];
$hasil = mysql_query( "INSERT INTO `pos_pembelianreturdetail` VALUES ('','$noretur','$noinvoice','$kode','$jumlah','$harga','$subdiscount','$subtotal')" );
updatestokbeliretur($kode,$jumlah);
alurstok($tgl,'Retur Pembelian',$noretur,$kode,$jumlah);
}
if($hasil){
$admin .= '<div class="sukses"><b>Berhasil Menambah Retur Pembelian.</b></div>';
pembelianreturrefresh();
pembelianreturcetak($noretur);
unset ($kodesupplier);
}else{
$admin .= '<div class="error"><b>Gagal Menambah Retur Pembelian.</b></div>';
}
}
}
if(isset($_POST['tambahsupplier'])){
$_SESSION['kodesupplier'] = $_POST['kodesupplier'];
