Exemple #1
0
<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>';
		}		
}	
}