Input Transaksi No.Nota Tanggal Jumlah Tools ”; $query=mysql_query(“select * from penjualan”); while($r=mysql_fetch_array($query)){ echo “ $r[nonota] $r[tanggal] $r[total] Cetak Nota ”; } echo””; break; case “tambah”: $tgl=date(‘Y-m-d’); //untuk autonumber di nota $auto=mysql_query(“select * from penjualan order by nonota desc limit 1”); $no=mysql_fetch_array($auto); $angka=$no[‘nonota’]+1; echo “
No. Nota :
”; echo'Transaksi Penjualan
’; break; case “detail”: echo “Nota Penjualan”; $nota=$_GET[‘nota’]; $query=mysql_query(“select penjualan.nonota,detailpenjualan.kode,tblbarang.nama, detailpenjualan.harga,detailpenjualan.jumlah,detailpenjualan.subtotal from detailpenjualan,penjualan,tblbarang where penjualan.nonota=detailpenjualan.nonota and tblbarang.kode=detailpenjualan.kode and detailpenjualan.nonota=’$nota'”); $nomor=mysql_fetch_array(mysql_query(“select * from penjualan where nonota=’$nota'”)); echo “
Nota :
”; echo “”; while($r=mysql_fetch_row($query)){ echo “”; } echo “
Kode Barang Nama Harga Jumlah Subtotal
$r[1] $r[2] $r[3] $r[4] $r[5]

Total

$nomor[total]

”; break; } ?>