<td>Stok Awal</td> <td>Stok Akhir</td> </tr>'; $no =1; /****************************/ $st2 = mysql_query ("SELECT * FROM pos_alur_stok where transaksi like'Stok Awal'"); while($datast2 = mysql_fetch_array($st2)){ $idsa = $datast2['id']; $tglsa = $datast2['tgl']; $transaksi = $datast2['transaksi']; $kodebarangsa = $datast2['kodebarang']; $jumlahsa = $datast2['jumlah']; $getnamabarangsa = getnamabarang($kodebarangsa); $getjenisbarang = getjenisbarang($kodebarangsa); $getidjenisbarang=getidjenisbarang($kodebarangsa); $getstokbarang=getstokbarang($kodebarangsa); if($kodejenis!=''){ if($getidjenisbarang==$kodejenis){ echo ' <tr class="border"> <td class="text-center">'.$no.'</td> <td>'.tanggalindo($datast2['tgl']).'</td> <td>'.$datast2['transaksi'].'</td> <td>'.$datast2['kode'].'</td> <td>'.$kodebarangsa.'</td> <td>'.$getnamabarangsa.'</td> <td>'.$datast2['jumlah'].'</td> <td>'.$getstokbarang.'</td> </tr>'; }}else{
$carabayar ='Pemesanan'; $tgltermin = tgltermin($tgl,$termin); $hasil = mysql_query( "INSERT INTO `pos_penjualan` VALUES ('','$nofaktur','$nopo','$tgl','$kodecustomer','$carabayar','$total','$discount','$netto','0','$netto','$termin','$tgltermin','$user')" ); }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"]; $jumlah = $cart_itm["jumlah"]; $harga = $cart_itm["harga"]; $hargabeli = $cart_itm["hargabeli"]; $subdiscount = $cart_itm["subdiscount"]; $subtotal = $cart_itm["subtotal"]; $jenis=getidjenisbarang($cart_itm["kode"]); $hasil = mysql_query( "INSERT INTO `pos_penjualandetail` VALUES ('','$nofaktur','$nopo','$jenis','$kode','$jumlah','$harga','$hargabeli','$subdiscount','$subtotal')" ); updatestokjual($kode,$jumlah); 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>'; } } }