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'];