transaksi.php.
<?php
if (!isset($_SESSION['nama_user'])) {
header("location:login.php");
}
?>
<!-- Basic Form Start -->
<div class="basic-form-area mg-b-15">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<div class="sparkline12-list shadow-reset mg-t-30">
<div class="sparkline12-hd">
<div class="main-sparkline12-hd">
<h1>Form Transaksi Penjualan
<span class="pull-right"><?php echo date('d F Y'); ?></span></h1>
<!-- <div class="sparkline12-outline-icon">
<span class="sparkline12-collapse-link"><i class="fa fa-chevron-up"></i></span>
<span class="sparkline12-collapse-close"><i class="fa fa-times"></i></span>
</div> -->
</div>
</div>
<div class="sparkline12-graph">
<div class="basic-login-form-ad">
<div class="row">
<div class="col-lg-12">
<div class="all-form-element-inner">
<form id="insert-to-cart" method="post">
<input type="hidden" name="data[jumlah]" value='1'>
<input type="hidden" name="tabel[tabel]" value="cart">
<?php
$a = 0;
foreach ($db->data("barang") as $kd_brg) {
$a++;
?>
<input type="hidden" name="data[kd_barang<?php echo $a; ?>]" id="kd<?php echo $a; ?>" value="<?php echo $kd_brg['kd_barang']; ?>">
<?php
}
?>
<div class="form-group-inner col-lg-6">
<h4 class="pull-left">Data Barang</h4>
<table id="table" data-toggle="table" data-pagination="true" data-search="true">
<thead>
<tr>
<th>No</th>
<th>Nama Barang</th>
<th>Harga</th>
<th>Add</th>
</tr>
</thead>
<tbody id="brg">
<?php
if ($db->data("barang") != 0) {
$no = 0;
foreach ($db->data("barang") as $barang) {
$no++;
?>
<tr>
<td><?php echo $no; ?></td>
<td><?php echo $barang['nama_barang']; ?></td>
<td><?php echo 'Rp '.number_format($barang['hrg_jual'],0,',','.').',-'; ?></td>
<td><a name="insert_to_cart" id="insert_to_cart<?php echo $no; ?>" data-id="<?php echo $no ?>" class="btn btn-primary">ADD</a></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</form>
<form method="post" action="proses/proses.php?aksi=transaksi">
<div class="col-lg-6">
<h4 class="pull-left">Cart Penjualan</h4>
<div class="sparkline12-graph">
<div class="static-table-list">
<table class="table hover-table">
<thead>
<tr>
<th>No</th>
<th>Nama Barang</th>
<th>Harga</th>
<th>Jumlah</th>
<th>Subtotal</th>
<th></th>
</tr>
</thead>
<tbody id="show_cart">
</tbody>
</table>
</div>
</div>
</div>
<div class="form-group-inner col-lg-6">
<div class="row">
<div class="col-lg-3">
<label class="login2 pull-right pull-right-pro">ID Pembeli</label>
</div>
<div class="col-lg-9">
<select name="id_pembeli" class="form-control chosen-select">
<?php
if ($db->data("pembeli") != 0) {
foreach ($db->data("pembeli") as $id) {
?>
<option value="<?php echo $id['id_pembeli']; ?>"><?php echo $id['id_pembeli']." | ".$id['nama_pembeli']; ?></option>
<?php
}
}
?>
</select>
</div>
<a data-toggle="modal" data-target="#tambahpembeli" href="#">Belum jadi member?</a>
</div>
</div>
<div class="form-group-inner col-lg-6">
<div class="row">
<div class="col-lg-3">
<label class="login2 pull-right pull-right-pro">PIC</label>
</div>
<div class="col-lg-9">
<input type="text" class="form-control" name="pic" readonly="readonly" value="<?php echo $_SESSION['nama_user']; ?>" />
<input type="hidden" name="no_nota" value="<?php echo 'N'.date('dm').'OT'.date('yhi').'A'.date('s'); ?>">
<input type="hidden" name="tgl_transaksi" value="<?php echo date('d-m-Y'); ?>">
</div>
<div class="col-lg-12">
<div class="login-horizental cancel-wp">
<button class="btn btn-sm btn-success login-submit-c pull-right pull-right-pro" type="submit">PAYMENT!</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
if (!isset($_SESSION['nama_user'])) {
header("location:login.php");
}
?>
<!-- Basic Form Start -->
<div class="basic-form-area mg-b-15">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<div class="sparkline12-list shadow-reset mg-t-30">
<div class="sparkline12-hd">
<div class="main-sparkline12-hd">
<h1>Form Transaksi Penjualan
<span class="pull-right"><?php echo date('d F Y'); ?></span></h1>
<!-- <div class="sparkline12-outline-icon">
<span class="sparkline12-collapse-link"><i class="fa fa-chevron-up"></i></span>
<span class="sparkline12-collapse-close"><i class="fa fa-times"></i></span>
</div> -->
</div>
</div>
<div class="sparkline12-graph">
<div class="basic-login-form-ad">
<div class="row">
<div class="col-lg-12">
<div class="all-form-element-inner">
<form id="insert-to-cart" method="post">
<input type="hidden" name="data[jumlah]" value='1'>
<input type="hidden" name="tabel[tabel]" value="cart">
<?php
$a = 0;
foreach ($db->data("barang") as $kd_brg) {
$a++;
?>
<input type="hidden" name="data[kd_barang<?php echo $a; ?>]" id="kd<?php echo $a; ?>" value="<?php echo $kd_brg['kd_barang']; ?>">
<?php
}
?>
<div class="form-group-inner col-lg-6">
<h4 class="pull-left">Data Barang</h4>
<table id="table" data-toggle="table" data-pagination="true" data-search="true">
<thead>
<tr>
<th>No</th>
<th>Nama Barang</th>
<th>Harga</th>
<th>Add</th>
</tr>
</thead>
<tbody id="brg">
<?php
if ($db->data("barang") != 0) {
$no = 0;
foreach ($db->data("barang") as $barang) {
$no++;
?>
<tr>
<td><?php echo $no; ?></td>
<td><?php echo $barang['nama_barang']; ?></td>
<td><?php echo 'Rp '.number_format($barang['hrg_jual'],0,',','.').',-'; ?></td>
<td><a name="insert_to_cart" id="insert_to_cart<?php echo $no; ?>" data-id="<?php echo $no ?>" class="btn btn-primary">ADD</a></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</form>
<form method="post" action="proses/proses.php?aksi=transaksi">
<div class="col-lg-6">
<h4 class="pull-left">Cart Penjualan</h4>
<div class="sparkline12-graph">
<div class="static-table-list">
<table class="table hover-table">
<thead>
<tr>
<th>No</th>
<th>Nama Barang</th>
<th>Harga</th>
<th>Jumlah</th>
<th>Subtotal</th>
<th></th>
</tr>
</thead>
<tbody id="show_cart">
</tbody>
</table>
</div>
</div>
</div>
<div class="form-group-inner col-lg-6">
<div class="row">
<div class="col-lg-3">
<label class="login2 pull-right pull-right-pro">ID Pembeli</label>
</div>
<div class="col-lg-9">
<select name="id_pembeli" class="form-control chosen-select">
<?php
if ($db->data("pembeli") != 0) {
foreach ($db->data("pembeli") as $id) {
?>
<option value="<?php echo $id['id_pembeli']; ?>"><?php echo $id['id_pembeli']." | ".$id['nama_pembeli']; ?></option>
<?php
}
}
?>
</select>
</div>
<a data-toggle="modal" data-target="#tambahpembeli" href="#">Belum jadi member?</a>
</div>
</div>
<div class="form-group-inner col-lg-6">
<div class="row">
<div class="col-lg-3">
<label class="login2 pull-right pull-right-pro">PIC</label>
</div>
<div class="col-lg-9">
<input type="text" class="form-control" name="pic" readonly="readonly" value="<?php echo $_SESSION['nama_user']; ?>" />
<input type="hidden" name="no_nota" value="<?php echo 'N'.date('dm').'OT'.date('yhi').'A'.date('s'); ?>">
<input type="hidden" name="tgl_transaksi" value="<?php echo date('d-m-Y'); ?>">
</div>
<div class="col-lg-12">
<div class="login-horizental cancel-wp">
<button class="btn btn-sm btn-success login-submit-c pull-right pull-right-pro" type="submit">PAYMENT!</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
index.php.
<script type="text/javascript">
$(document).ready(function(){
//cart
var row = document.getElementById("brg").rows.length;
for(var i = 0; i <= row; i++){
count = 0;
$("#insert_to_cart"+i).click(function(){
var no = $(this).data("id");
count+=1;
var kd = $("#kd"+no).val();
var data = $('#insert-to-cart').serialize();
$.ajax({
type: 'POST',
url: 'proses/proses.php?aksi=cart&kd_barang='+kd,
data: data,
success: function(){
$('#show_cart').load('proses/cart.php');
}
});
});
}
})
</script>
$(document).ready(function(){
//cart
var row = document.getElementById("brg").rows.length;
for(var i = 0; i <= row; i++){
count = 0;
$("#insert_to_cart"+i).click(function(){
var no = $(this).data("id");
count+=1;
var kd = $("#kd"+no).val();
var data = $('#insert-to-cart').serialize();
$.ajax({
type: 'POST',
url: 'proses/proses.php?aksi=cart&kd_barang='+kd,
data: data,
success: function(){
$('#show_cart').load('proses/cart.php');
}
});
});
}
})
</script>
proses_trans.php.
<?php
spl_autoload_register(function($class){
include"../class/".$class.".php";
});
$db = new class_function();
$id_pembeli=$_POST['id_pembeli'];
$no_nota=$_POST['no_nota'];
$tgl_transaksi=$_POST['tgl_transaksi'];
$pic=$_POST['pic'];
$total = $_POST['total'];
$query=mysql_query("insert into transaksi values('$no_nota','$id_pembeli','$tgl_transaksi',$total,'$pic')");
foreach ($_POST['count'] as $key => $hitung) {
$kd_barang=$_POST['kd_barang'.$hitung];
$jumlah=$_POST['jumlah'.$hitung];
$subtotal=$_POST['subtotal'.$hitung];
mysql_query("INSERT INTO detail_transaksi(no_nota,kd_barang,jumlah,total_harga) VALUES ('$no_nota','$kd_barang',$jumlah,$subtotal)");
mysql_query("UPDATE barang SET jumlah=jumlah-$jumlah WHERE kd_barang='$kd_barang'");
mysql_query("TRUNCATE TABLE cart");
}
header("location:invoice.php");
?>
spl_autoload_register(function($class){
include"../class/".$class.".php";
});
$db = new class_function();
$id_pembeli=$_POST['id_pembeli'];
$no_nota=$_POST['no_nota'];
$tgl_transaksi=$_POST['tgl_transaksi'];
$pic=$_POST['pic'];
$total = $_POST['total'];
$query=mysql_query("insert into transaksi values('$no_nota','$id_pembeli','$tgl_transaksi',$total,'$pic')");
foreach ($_POST['count'] as $key => $hitung) {
$kd_barang=$_POST['kd_barang'.$hitung];
$jumlah=$_POST['jumlah'.$hitung];
$subtotal=$_POST['subtotal'.$hitung];
mysql_query("INSERT INTO detail_transaksi(no_nota,kd_barang,jumlah,total_harga) VALUES ('$no_nota','$kd_barang',$jumlah,$subtotal)");
mysql_query("UPDATE barang SET jumlah=jumlah-$jumlah WHERE kd_barang='$kd_barang'");
mysql_query("TRUNCATE TABLE cart");
}
header("location:invoice.php");
?>
cart.php.
<?php
session_start();
if (!isset($_SESSION['nama_user'])) {
<?php
spl_autoload_register(function($class){
include"../class/".$class.".php";
});
$db = new class_function();
session_start();
if ($db->data("cart") != 0) {
$no=0;
$total=0;
foreach ($db->data("cart") as $order) {
$no++;
?>
<tr>
<td><?php echo $no; ?></td>
<input type="hidden" name="count[]" value="<?php echo $no; ?>">
<?php
foreach ($db->datawhere("barang","kd_barang='".$order['kd_barang']."'") as $brg) {
?>
<td><?php echo $brg['nama_barang']; ?></td>
<input type="hidden" name="kd_barang<?php echo $no; ?>" value="<?php echo $brg['kd_barang']; ?>">
<td><?php echo 'Rp '.number_format($brg['hrg_jual'],0,',','.'); ?></td>
<td><?php echo $order['jumlah']; ?></td>
<td>
<?php
$subtotal = $order['jumlah']*$brg['hrg_jual'];
echo 'Rp '.number_format($subtotal,0,',','.');
$total +=$subtotal;
?>
</td>
<input type="hidden" name="jumlah<?php echo $no; ?>" value="<?php echo $order['jumlah']; ?>">
<input type="hidden" name="subtotal<?php echo $no; ?>" value="<?php echo $subtotal; ?>">
<input type="hidden" id="kode<?php echo $no; ?>" value="<?php echo $order['kd_barang']; ?>">
<td><a id="hapus<?php echo $no; ?>" data-id="<?php echo $no ?>" class="hapus" title="hapus"><i class="fa fa-times"></i></a></td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="4">TOTAL</td>
<td>
<?php
echo 'Rp '.number_format($total,0,',','.');
?>
</td>
<input type="hidden" name="total" value="<?php echo $total; ?>">
</tr>
<?php
}
?>
<!-- jquery
============================================ -->
<script src="../js/vendor/jquery-2.1.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
//cart
// $("#hapus").click(function() {
// var nilai = $("#kode").val();
// alert(nilai);
// });
//var row = document.getElementById("brg").rows.length;
for(var x = 0; x <= 100; x++){
counts = 0;
$("#hapus"+x).click(function(){
var noe = $(this).data("id");
counts+=1;
var hps = $("#kode"+noe).val();
console.log(hps);
$.ajax({
type: 'POST',
url: 'proses/proses.php?aksi=hapuscart&kd='+hps,
success: function(){
$('#show_cart').load('proses/cart.php');
}
});
});
}
})
</script>
session_start();
if (!isset($_SESSION['nama_user'])) {
<?php
spl_autoload_register(function($class){
include"../class/".$class.".php";
});
$db = new class_function();
session_start();
if ($db->data("cart") != 0) {
$no=0;
$total=0;
foreach ($db->data("cart") as $order) {
$no++;
?>
<tr>
<td><?php echo $no; ?></td>
<input type="hidden" name="count[]" value="<?php echo $no; ?>">
<?php
foreach ($db->datawhere("barang","kd_barang='".$order['kd_barang']."'") as $brg) {
?>
<td><?php echo $brg['nama_barang']; ?></td>
<input type="hidden" name="kd_barang<?php echo $no; ?>" value="<?php echo $brg['kd_barang']; ?>">
<td><?php echo 'Rp '.number_format($brg['hrg_jual'],0,',','.'); ?></td>
<td><?php echo $order['jumlah']; ?></td>
<td>
<?php
$subtotal = $order['jumlah']*$brg['hrg_jual'];
echo 'Rp '.number_format($subtotal,0,',','.');
$total +=$subtotal;
?>
</td>
<input type="hidden" name="jumlah<?php echo $no; ?>" value="<?php echo $order['jumlah']; ?>">
<input type="hidden" name="subtotal<?php echo $no; ?>" value="<?php echo $subtotal; ?>">
<input type="hidden" id="kode<?php echo $no; ?>" value="<?php echo $order['kd_barang']; ?>">
<td><a id="hapus<?php echo $no; ?>" data-id="<?php echo $no ?>" class="hapus" title="hapus"><i class="fa fa-times"></i></a></td>
</tr>
<?php
}
}
?>
<tr>
<td colspan="4">TOTAL</td>
<td>
<?php
echo 'Rp '.number_format($total,0,',','.');
?>
</td>
<input type="hidden" name="total" value="<?php echo $total; ?>">
</tr>
<?php
}
?>
<!-- jquery
============================================ -->
<script src="../js/vendor/jquery-2.1.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
//cart
// $("#hapus").click(function() {
// var nilai = $("#kode").val();
// alert(nilai);
// });
//var row = document.getElementById("brg").rows.length;
for(var x = 0; x <= 100; x++){
counts = 0;
$("#hapus"+x).click(function(){
var noe = $(this).data("id");
counts+=1;
var hps = $("#kode"+noe).val();
console.log(hps);
$.ajax({
type: 'POST',
url: 'proses/proses.php?aksi=hapuscart&kd='+hps,
success: function(){
$('#show_cart').load('proses/cart.php');
}
});
});
}
})
</script>
0 komentar:
Posting Komentar