Selasa, 23 Juli 2013

PHP Indonesia - Facebook: agan master skalian ane newbie ne , mau tanya donk...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
agan master skalian ane newbie ne , mau tanya donk...
Jul 23rd 2013, 18:00, by Bayu Prasetyo Raharjo

Bayu Prasetyo Raharjo 6:00pm Jul 23
agan master skalian ane newbie ne , mau tanya donk, gimana ya cara supaya nota jualnya jadi ber urut ketika di buka bersamaan dengan id yang sama,
misalkan di laptop yang sudah kita lan , yang server buka bagian kasir, yang client juga kasir dengan id status yang sama, tapi begitu tampil yang di server tampil "J008" dan bgtu yang di client di buka langsung respon urut senjutnya "J009"

contoh Script:
--------------------------------------------------------------------------------------------------
<?php
session_start();
include "config/inc.koneksidb.php";
include "config/functions.php";
include "config/cek_session.php";

// mendeklarasikan variabel
$total_jual = $_POST['totalnya'];
$noNota = $_POST['noNota'];
$id = $_POST['id'];
$nm_pelanggan = $_POST['nm_pelanggan'];
$tglJual = $_POST['tglJual'];
$tglJual1 = $_POST['tglJual'];
$jml_uang = $_POST['jml_uang'];

$id_pelanggan_simpan = $_POST['id_pelanggan_simpan'];
$alamat_simpan = $_POST['alamat_simpan'];
$nm_pelanggan_simpan = $_POST['nm_pelanggan_simpan'];

//mengubah format tanggal ke YYYY-MM-DD
$tglJual=substr($tglJual,6,4).'-'.substr($tglJual,3,2).'-'.substr($tglJual,0,2);

$pesan = mysql_query("INSERT INTO tbl_jual (no_nota,tgl_jual, total_jual, id_pelanggan, alamat_kirim)
VALUES ('$noNota','$tglJual','$total_jual','$id_pelanggan_simpan','$alamat_simpan')");

if (isset($_SESSION['items'])) {
foreach ($_SESSION['items'] as $key => $val){
$det_pesan = mysql_query("INSERT INTO tbl_jual_detail (no_nota,kd_barang,jml_jual) VALUES ('$noNota','$key','$val')");
$update_stock = mysql_query("UPDATE tbl_barang set stok=stok-'$val' where kd_barang='$key'");
}
}

if($pesan == FALSE || $det_pesan == FALSE){
echo "INSERT INTO tbl_jual (no_nota,tgl_jual, total_jual, id_pelanggan, alamat_kirim) VALUES ('$noNota','$tglJual','$total_jual','$id_pelanggan_simpan','$alamat_simpan')";
} else {
if (isset($_SESSION['items'])) {
foreach ($_SESSION['items'] as $key => $val) {
unset($_SESSION['items'][$key]);
}
unset($_SESSION['items']);
}
?>
-------------------------------------------------------------------------------------------------
makasih banyak sebelumnya, mphon dengan sangat bantuannya hehe :D

David Joan Hard 6:18pm Jul 23
no nota sbaiknya jangan ditampung di input, tp langsung ke query saat simpan.

Bayu Prasetyo Raharjo 6:20pm Jul 23
mksdnya no nota nanti tampilnya cuma pada saaat di nota gt gan, maklum newbie, butuh bimbingan

David Joan Hard 6:22pm Jul 23
iya, no nota tampil stelah di simpan atau cetak,,

Bayu Prasetyo Raharjo 6:23pm Jul 23
oowww gt ya gan,,, makasih gan,, biar ane coba dl gan

הידראולי קריר 6:29pm Jul 23
klo d lan kykx jd DE..

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar