die("database error!

LAMPIRAN

48

Index.php Sistem Informasi Penjualan

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Silahkan login untuk melakukan transaksi dan manajemen data.

Username : Password :

Koneksi.php
die("Kesalahan

@mysql_select_db($database,$connection)or die("Database error!"); ?> menu.php <script src="asset/js/menu.js" type="text/javascript">

Home

Barang

Pelanggan

Transaksi

Proses Transaksi

Cetak Nota

Laporan Penjualan

Admin

Log Out

menu_kasir.php <script src="asset/js/menu.js" type="text/javascript">

Home

Barang

pelanggan

Transaksi

Proses Transaksi

Cetak Nota

Log Out

index_admin.php Sistem Informasi Penjualan

Customer Service:
(024) 7470031, (0298) 592644" ?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } ?>

<strong>Barang
Berfungsi untuk mengelola data Barang (tambah, edit, hapus) yang tersimpan di dalam database

produk

<strong>pelanggan
Berfungsi untuk mengelola data produk pelanggan (tambah, edit, hapus) yang tersimpan di dalam database

<strong>Transaksi
Berfungsi untuk memproses penjualan yang terjadi dan mencetak nota penjualan

transaksi

<strong>Laporan Penjualan
Berfungsi untuk laporan penjualan dalam periode satu bulan atau satu tahun

mengetahui

<strong>Manajemen admin
Berfungsi untuk mengelola data admin (tambah, edit, hapus) yang tersimpan di dalam database

<strong>Log Out
Keluar dari sistem aplikasi

Java.php
function getbarang(){ $barang = new barang(); $barang->connect(); $query = "select * FROM barang order by k_brg"; $hasil = mysql_query($query); return $hasil; }

function cekKodebarang($k_brg) { $barang = new barang(); $barang->connect(); $query = "SELECT k_brg FROM barang WHERE k_brg='$k_brg'"; $hasil = mysql_query($query);

$x=0; while($data = mysql_fetch_array($hasil)) { $x = $x+1; } return $x; }

function getMaxKodebarang(){ $barang = new barang(); $barang->connect(); $query = "SELECT max(k_brg) AS last FROM barang"; $hasil = mysql_query($query); return $hasil; } function insertbarang($k_brg, $nama_brg, $jenis, $harga, $satuan) { $barang = new barang(); $barang->connect(); $query = "insert into barang(k_brg, nama_brg, jenis, harga, satuan) VALUES ('$k_brg','$nama_brg', '$jenis', '$harga','$satuan')"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } } function getbarangEdit($k_brg) { $barang = new barang(); $barang->connect(); $query = "select * FROM barang WHERE k_brg='$k_brg'"; $hasil = mysql_query($query); return $hasil; }

function updatebarang($k_brg, $nama_brg, $jenis, $harga, $satuan) { $barang = new barang(); $barang->connect(); $query = "update barang set nama_brg='$nama_brg', harga='$harga', satuan='$satuan' WHERE k_brg='$k_brg'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } }

function deletebarang($k_brg) { $barang =

new barang();

$barang->connect(); $query = "delete FROM barang WHERE k_brg='$k_brg'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } }

function getHargabarang($k_brg) { $barang = new barang(); $barang->connect(); $query = "select harga FROM barang WHERE k_brg='$k_brg'"; $hasil = mysql_query($query); return $hasil; } }

jenis='$jenis',

?> DetailTransaksi connect(); $query = "select no_faktur, k_brg, harga, jumlah FROM detailtransaksi, WHERE k_brg = k_brg AND no_faktur='$no_faktur'"; $hasil = mysql_query($query); return $hasil; } function insertDetailTransaksi($no_faktur, $k_brg, $jumlah, $subtotal) { $detail = new DetailTransaksi(); $detail->connect(); $query = "insert into detailtransaksi(no_faktur, k_brg, jumlah, subtotal) VALUES ('$no_faktur','$k_brg', '$jumlah', '$subtotal')"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } } function deleteDetailTransaksi($no_faktur, $k_brg) { $detail = new DetailTransaksi();

$detail->connect(); $query = "delete FROM detailtransaksi WHERE no_faktur='$no_faktur' AND k_brg='$k_brg'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; }

}

function deleteDetailTransaksiAll($no_faktur) { $detail = new DetailTransaksi(); $detail->connect(); $query = "delete FROM detailtransaksi WHERE no_faktur='$no_faktur'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; }

}}?>

User.php connect(); $query = "select * FROM admin order by username"; $hasil = mysql_query($query); return $hasil; } function getIdUser($username) { $user = new User(); $user->connect(); $query = "SELECT username FROM admin WHERE username='$username'"; $hasil = mysql_query($query); $x=0; while($data = mysql_fetch_array($hasil)) { $x = $x+1; } return $x;

} function insertUser($username, $password, $nama, $level) { $user = new User(); $user->connect(); $query = "insert into admin(username, password, nama, ('$username','$password', '$nama', '$level')"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } }

level)

VALUES

function getUserEdit($username) { $user = new User(); $user->connect(); $query = "select * FROM admin WHERE username='$username'"; $hasil = mysql_query($query); return $hasil; } function updateUser($username, $password, $nama, $level) { $user = new User(); $user->connect(); $query = "update admin set password='$password', level='$level' WHERE username='$username'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } }

nama='$nama',

function deleteUser($username) { $user = new User(); $user->connect(); $query = "delete FROM admin WHERE username='$username'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } } function cekLogin($username, $password) { $user = new User(); $user->connect(); $query = "SELECT username, password, nama, username='$username' AND password='$password'"; $hasil = mysql_query($query); $cek = mysql_num_rows($hasil); return $hasil; /*if($cek >= 1){ return $id; } else { return "gagal"; }*/ }

level

FROM

admin

/*function cekUserAktif($username, $password){ $user = new User(); $user->connect(); $query = "SELECT status FROM user WHERE id='$id' && sandi='$sandi'"; $hasil = mysql_query($query);

WHERE

$x=0; while($data = mysql_fetch_array($hasil)) { $res[$x] = $data["status"]; $x = $x+1; } $hsl = $res[0]; return $hsl; } */ } Transaksi.php connect(); $query = "SELECT max(no_faktur) AS last FROM transaksi WHERE no_faktur LIKE '$today%'"; $hasil = mysql_query($query); return $hasil; } function insertTransaksi($no_faktur, $tanggal, $grand_total, $bayar,$k_pel) { $transaksi = new Transaksi(); $transaksi->connect(); $query = "insert into transaksi(no_faktur, tanggal, grand_total, bayar, depo, k_pel) VALUES ('$no_faktur','$tanggal', '$grand_total', '$bayar','$k_pel')"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } } function getTransaksi(){ $transaksi = new Transaksi(); $transaksi->connect(); $query = "SELECT * FROM transaksi ORDER BY no_faktur DESC"; $hasil = mysql_query($query); return $hasil; } function getHistoryTransaksi($tanggal_awal, $tanggal_akhir){ $transaksi = new Transaksi(); $transaksi->connect(); $query = "SELECT * FROM transaksi WHERE tanggal BETWEEN '$tanggal_awal' AND '$tanggal_akhir' ORDER BY no_nota ASC"; $hasil = mysql_query($query); return $hasil; } function deleteTransaksi($no_faktur) { $transaksi = new Transaksi(); $transaksi->connect(); $query = "delete FROM transaksi WHERE no_faktur='$no_faktur'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } } } ?> Logout.php
{ if(ISSET($_SESSION['username'])) { UNSET($_SESSION ['username']); } } header("location: index.php"); session_destroy(); ?> cek_login.php
$user = new User(); //$status = $user->cekUserAktif($usernamex, $passwordx); $hasil = $user->cekLogin($usernamex, $passwordx); $datax = mysql_fetch_array($hasil); $cek = mysql_num_rows($hasil); $username = $datax["username"]; $level = $datax["level"]; $nama = $datax["nama"]; //echo $cek." - ".$username." - ".$level; if($cek>0){ session_start(); $_SESSION['username'] = $usernamex; $_SESSION['level'] = $level; $_SESSION['nama'] = $nama; header("location: index_admin.php"); } else { header("location: index.php"); } ?> master_java.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; }

<script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644"?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("java.php"); $barang = new barang(); ?>
getbarang(); while($row = mysql_fetch_array($result)) { ?>

Data produk java

No. Kode Barang Nama Barang Jenis Barang Harga Satuan (ml)
Tambah Barang

" class="cbbarang">
Edit barang
" onclick="return confirm('Hapus Data?');">
Hapus barang

"; ?>

tambah_java.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript"> <script type="text/javascript"> function cekInputan() { var harga = document.forms['myForm']['harga'].value; var satuan = document.forms['myForm']['satuan'].value; var numbers=/^[0-9]+$/; if((!harga.match(numbers)) || (!satuan.match(numbers))){ alert("Inputan Harus Angka !"); return false; } }

Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("java.php"); $barang = new barang(); $hasil = $barang->getMaxKodebarang(); $datax = mysql_fetch_array($hasil); $lastKodeSayur = $datax['last']; $lastNoUrut = substr($lastKodeSayur, 1, 3); $nextNoUrut = $lastNoUrut + 1; $nextKodeSayur = "S".sprintf('%03s', $nextNoUrut);

?>

Kode Barang:

Nama Barang:

Jenis:

Harga:

Satuan:

"; ?>

edit_java.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px;

} .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("java.php"); $barang = new barang(); $k_brg = $_GET["k_brg"]; $datax = $barang->getbarangEdit($k_brg); while ($row = mysql_fetch_array($datax)){ $nama_brg= $row["nama_brg"]; $jenis = $row["jenis"]; $harga = $row["harga"]; $satuan = $row["satuan"]; } ?>

Kode Barang:

Nama Barang:

Jenis:

Harga:

Satuan:

"; ?>

update_java.php <script language="JavaScript">alert('Isi Data dengan Lengkap!'); document.location='master_java.php'updatebarang($k_brg, $nama_brg, $jenis, $harga, $satuan); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Update Data'); document.location='master_java.php' <script language="JavaScript">alert('Data Gagal Diupdate!'); document.location='master_java.php' delete_java.php deletebarang($k_brg); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Hapus Data'); document.location='master_java.php?' <script language="JavaScript">alert('Data Gagal Dihapus!'); document.location='master_java.php'
} } ?> konek_pel.php connect(); $query = "select * FROM pelanggan order by k_pel"; $hasil = mysql_query($query); return $hasil; } function cekKodepelanggan($k_pel) { $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "SELECT k_pel FROM pelanggan WHERE k_pel='$k_pel'"; $hasil = mysql_query($query); $x=0; while($data = mysql_fetch_array($hasil)) { $x = $x+1; } return $x; } function getMaxKodepelanggan(){ $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "SELECT max(k_pel) AS last FROM pelanggan"; $hasil = mysql_query($query); return $hasil; } function insertpelanggan($k_pel, $nama_pel, $alamat, $no_telp) { $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "insert into pelanggan(k_pel, nama_pel, alamat, VALUES('$k_pel','$nama_pel', '$alamat', '$no_telp')"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } }

no_telp)

function getpelangganEdit($k_pel) { $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "select * FROM pelanggan WHERE k_pel='$k_pel'"; $hasil = mysql_query($query); return $hasil; } function updatepelanggan($k_pel, $nama_pel, $alamat, $no_telp) { $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "update pelanggan set nama_pel='$nama_pel', alamat='$alamat', no_telp='$no_telp' WHERE k_pel='$k_pel'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } }

function deletepelanggan($k_pel) { $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "delete FROM pelanggan WHERE k_pel='$k_pel'"; $hasil = mysql_query($query); if($hasil){ return "T"; } else { return "F"; } } function getHargapelanggan($k_pel) { $pelanggan = new pelanggan(); $pelanggan->connect(); $query = "select nama_pel FROM pelanggan WHERE k_pel='$k_pel'"; $hasil = mysql_query($query); return $hasil; } } ?> pelanggan.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644"?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("konek_pel.php"); $pelanggan = new pelanggan(); ?>

getpelanggan(); while($row = mysql_fetch_array($result)) { ?>

Data Pelanggan

No. Kode Pelanggan Nama Pelanggan alamat No. Telp
Tambah pelanggan

" class="cbbarang">
Edit pelanggan
Hapus pelanggan

"; ?>

tambah_pelanggan.php Sistem Informasi Penjualan <style> .editbox { display:none } td {

padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript"> <script type="text/javascript"> function cekInputan() { var harga = document.forms['myForm']['harga'].value; var satuan = document.forms['myForm']['satuan'].value; var numbers=/^[0-9]+$/; if((!harga.match(numbers)) || (!satuan.match(numbers))){ alert("Inputan Harus Angka !"); return false; } }

Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("konek_pel.php"); $pelanggan = new pelanggan(); $hasil = $pelanggan->getMaxKodepelanggan(); $datax = mysql_fetch_array($hasil); $lastKodeSayur = $datax['last']; $lastNoUrut = substr($lastKodeSayur, 4, 1); $nextNoUrut = $lastNoUrut + 1; $nextKodeSayur = "JV".sprintf('%03s', $nextNoUrut); ?>

Kode Pelanggan:

Nama Pelanggan:

alamat:

No Telp:

"; ?>

update_pelanggan.php <script language="JavaScript">alert('Isi Data dengan Lengkap!'); document.location='pelanggan.php'updatepelanggan($k_pel, $nama_pel, $alamat, $no_telp); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Update Data'); document.location='pelanggan.php' <script language="JavaScript">alert('Data Gagal Diupdate!'); document.location='pelanggan.php' edit_pelanggan.php Sistem Informasi Penjualan <style> .editbox { display:none }

td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("konek_pel.php"); $pelanggan = new pelanggan(); $k_pel = $_GET["k_pel"]; $datax = $pelanggan->getpelangganEdit($k_pel); while ($row = mysql_fetch_array($datax)){ $nama_pel= $row["nama_pel"]; $alamat = $row["alamat"]; $no_telp = $row["no_telp"]; } ?>

Kode pelanggan:

Nama pelanggan:

alamat:

no_telp:

"; ?>

delete_pelanggan.php deletepelanggan($k_pel); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Hapus Data'); document.location='pelanggan.php?' <script language="JavaScript">alert('Data Gagal Dihapus!'); document.location='pelanggan.php' Transaksi_penjualan.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; }

<script src="asset/js/menu.js" type="text/javascript"> <script type="text/javascript"> function cekInputan() { var bayar = document.forms['myForm']['bayar'].value; var numbers=/^[0-9]+$/; if(!bayar.match(numbers)){ alert("Inputan Harus Angka !"); return false; } }

Customer Service:
(024) 7470031, (0298) 592644"?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("java.php"); include("Transaksi.php"); include("DetailTransaksi.php"); include("konek_pel.php"); $pelanggan = new pelanggan(); $result1 = $pelanggan->getpelanggan();

$barang = new barang(); $transaksi = new Transaksi(); $detail = new DetailTransaksi(); $result = $barang->getbarang(); date_default_timezone_set("Asia/Jakarta"); $today = date("Ymd"); $hasil = $transaksi->getNoTransaksi($today); $datax = mysql_fetch_array($hasil); $lastNoTransaksi = $datax['last']; $lastNoUrut = substr($lastNoTransaksi, 11, 1); $nextNoUrut = $lastNoUrut + 1; $nextNoTransaksi = $today.sprintf('%04s', $nextNoUrut); $hasilDetailTransaksi = $detail->getDetailTransaksi($nextNoTransaksi); ?>

Proses Transaksi

No. Faktur

Tanggal " readonly="readonly">

Kode Pelanggan <select name="k_pel">
while($row = mysql_fetch_array($result1)) { ?>

Kode Barang <select name="k_brg"> Jumlah:

Kode Barang Nama Barang Harga Jumlah Sub Total Aksi

&k_brg=" onclick="return confirm('Hapus Data?');">
Hapus

Grand Total Rp.

Bayar Rp.

"; ?>

cetak_nota.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644" ?>

"; if($level=="admin"){ include("menu.php"); } else {

include("menu_kasir.php"); } include("Transaksi.php"); $transaksi = new Transaksi(); ?>
getTransaksi(); while($row = mysql_fetch_array($result)) { ?>

Data Transaksi

No. No. Faktur Tanggal Kode Pelanggan Grand Total Aksi

" class="cbbarang" target="_blank">
Buat Faktur
Hapus

"; ?>

delete_detail_transaksi.php deleteDetailTransaksi($no_faktur, $k_brg); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Hapus Data'); document.location='transaksi_penjualan.php?'
?> <script language="JavaScript">alert('Data Gagal Dihapus!'); document.location='transaksi_penjualan.php' nota.php Nota <style>

Customer Service:
(024) 7470031, (0298) 592644" ?>

"; include("DetailTransaksi.php"); include("Transaksi.php"); $detail = new DetailTransaksi(); $transaksi = new Transaksi(); $no_faktur = $_GET["no_faktur"]; $hsl = $transaksi->getTransaksi(); $datax = mysql_fetch_array($hsl); $tanggal = $datax["tanggal"]; $bayar = $datax["bayar"]; $kembali = $datax["kembali"]; $k_pel = $datax["k_pel"]; echo "No. Faktur: ".$no_faktur."
"; echo "Tanggal: ".$tanggal."
"; echo "Kode Pelanggan: ".$k_pel; $hasilDetailTransaksi = $detail->getDetailTransaksi($no_faktur); ?>

?>

Kode Barang Nama Barang Harga Jumlah Sub Total

Grand Total

Bayar

Kembali

Penerima Terima Kasih

(..........................) (..........................)

WriteHTML($html); $mpdf->WriteHTML(utf8_encode($html));

$mpdf->Output($nama_dokumen.".pdf" ,'I'); exit; ?> delete_transaksi.php deleteTransaksi($no_faktur); $hslDetail = $detail->deleteDetailTransaksiAll($no_faktur); if($hslTransaksi=="T" && $hslDetail=="T"){ ?> <script language="JavaScript">alert('Berhasil Hapus Data'); document.location='cetak_nota.php?' <script language="JavaScript">alert('Data Gagal Dihapus!'); document.location='cetak_nota.php' laporan.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript"> <script language="javascript" type="text/javascript" src="asset/js/datetimepicker_css.js">

Customer Service:
(024) 7470031, (0298) 592644" ?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php");

} include("java.php"); include("Transaksi.php"); include("DetailTransaksi.php"); $barang = new barang(); $transaksi = new Transaksi(); $detail = new DetailTransaksi(); $hasil = $transaksi->getTransaksi(); ?>

Laporan Penjualan

Tanggal Awal

Tanggal Akhir

"; ?>

lihat_laporan.php Nota <style> .editbox {

display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644" ?>

"; include("Transaksi.php"); $transaksi = new Transaksi(); $tanggal_awal = $_POST["tanggal_awal"]; $tanggal_akhir = $_POST["tanggal_akhir"]; $hsl = $transaksi->getHistoryTransaksi($tanggal_awal, $tanggal_akhir); echo "Pendapatan dari Tanggal ".$tanggal_awal." s/d Tanggal ".$tanggal_akhir; ?>

FROM ")or +=

?>
$i++; } ?>

No. No. Faktur Tanggal Kode Pelanggan Grand Total

Pendapatan:

master_user.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644" ?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("User.php"); $user = new User(); ?>

getUser(); while($row = mysql_fetch_array($result)) { ?>

Data User

No. Username Nama Sandi Level
Tambah User

" class="cbbarang">
Edit Data
" onclick="return confirm('Anda yakin?');">
Hapus Data

"; ?>

tambah_user.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox {

font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } ?>

Username:

Password:

Nama:

Level: <select name="level">

"; ?>

edit_user.php Sistem Informasi Penjualan <style> .editbox { display:none } td { padding:5px; } .editbox { font-size:14px; width:70px; background-color:#ffffcc; border:solid 1px #000; padding:4px; } .edit_tr:hover { cursor:pointer; } <script src="asset/js/menu.js" type="text/javascript">

Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

"; if($level=="admin"){ include("menu.php"); } else { include("menu_kasir.php"); } include("User.php"); $user = new User(); $username = $_GET["username"]; $datax = $user->getUserEdit($username); while ($row = mysql_fetch_array($datax)){ $nama = $row["nama"]; $password = $row["password"]; $level = $row["level"]; } ?>

Username:
value="" readonly>

Password:

Nama:

Level: <select name="level">

"; ?>

update_user.php <script language="JavaScript">alert('Isi Data dengan Lengkap!'); document.location='master_user.php'updateUser($username, $password, $nama, $level); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Update Data'); document.location='master_user.php' <script language="JavaScript">alert('Data Gagal Diupdate!'); document.location='master_user.php' delete_user.php

deleteUser($username); if($hsl=="T"){ ?> <script language="JavaScript">alert('Berhasil Hapus Data'); document.location='master_user.php?' <script language="JavaScript">alert('Data Gagal Dihapus!'); document.location='master_user.php'

Report "die("database error!"

Your name

Email

Reason

Description

Copyright © 2025 ADOC.PUB. All rights reserved.
About Us | Privacy Policy | Terms of Service | Copyright | Contact Us | Cookie Policy

Sign In

Email

Password

Remember me Forgot password?

Our partners will collect data and use cookies for ad personalization and measurement. Learn how we and our ad partner Google, collect and use data. Agree & close

die("database error!

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644"?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

Data produk java
No.	Kode Barang	Nama Barang	Jenis Barang	Harga	Satuan (ml)	Tambah Barang
						" class="cbbarang"> Edit barang	" onclick="return confirm('Hapus Data?');"> Hapus barang

Data Pelanggan
No.	Kode Pelanggan	Nama Pelanggan	alamat	No. Telp	Tambah pelanggan
					" class="cbbarang"> Edit pelanggan	" onclick="return confirm('Hapus Data?');"> Hapus pelanggan

Data Transaksi
No.	No. Faktur	Tanggal	Kode Pelanggan	Grand Total	Aksi
					" class="cbbarang" target="_blank"> Buat Faktur	" onclick="return confirm('Hapus Data?');"> Hapus


Penerima	Terima Kasih
(..........................)	(..........................)

Data User
No.	Username	Nama	Sandi	Level	Tambah User
					" class="cbbarang"> Edit Data	" onclick="return confirm('Anda yakin?');"> Hapus Data

Username:	value="" readonly>
Password:
Nama:
Level:	<select name="level">

die("database error!

Recommend Documents

Jl. Raya Muncul Km 7 No. 1 Banyubiru AmbarawaJl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Jl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Jl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644"?>

Jl. Setiabudi No. 211 Semarang 50263 Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Customer Service: (024) 7470031, (0298) 592644, (0298) 592656" ?>

Jl. Setiabudi No. 211 Semarang 50263 Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Customer Service: (024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Jl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644"?>

Jl. Setiabudi No. 211 Semarang 50263 Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Customer Service: (024) 7470031, (0298) 592644, (0298) 592656" ?>

Jl. Setiabudi No. 211 Semarang 50263 Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Customer Service: (024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru AmbarawaJl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru AmbarawaJl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru AmbarawaJl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Jl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru AmbarawaJl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru AmbarawaJl. Setiabudi No. 211 Semarang 50263 Customer Service: (024) 7470031, (0298) 592644" ?>

Jl. Setiabudi No. 211 Semarang 50263 Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Customer Service: (024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Setiabudi No. 211 Semarang 50263 Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa Customer Service: (024) 7470031, (0298) 592644, (0298) 592656" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644"?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644"?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644"?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Jl. Setiabudi No. 211 Semarang 50263
Customer Service:
(024) 7470031, (0298) 592644" ?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656"?>

Jl. Setiabudi No. 211 Semarang 50263
Jl. Raya Muncul Km 7 No. 1 Banyubiru Ambarawa
Customer Service:
(024) 7470031, (0298) 592644, (0298) 592656" ?>