<?php session_start();
include "config.php";
$tgl_skg=date("Ymd");
$jam_sekarang=date("H:i:s",time()+60*60*5);
$id= $_GET['id'];
$cari_barang="select * from barangtbl where id_barang=$id";
$hasil_barang=mysql_query($cari_barang);
$data_barang = mysql_fetch_array($hasil_barang);
$ciri=$data_barang['id_barang'];
$nam=$data_barang['nama'];
$har=$data_barang['harga'];
if((isset($_SESSION['userlogin'])) ==''){
header("location:index.php");
}else{
$member = $_SESSION['userlogin'];
if($hasil_barang){
require("faktur.php");
$cari_transaksi="select * from transaksirincitbl where username='".$member."' AND id_barang = '".$id."' and notransaksi ='".$faktur."'";
$hasil_transaksi=mysql_query($cari_transaksi);
$temukan = mysql_num_rows($hasil_transaksi);
$data_transaksi = mysql_fetch_array($hasil_transaksi);
if($temukan==0){
$query = "insert into transaksirincitbl (notransaksi,username,id_barang,nama,harga,jumlah,subtotal,tanggal,jam)
Values ('$faktur','$member', '$ciri','$nam', '$har', '1', '$har', '$tgl_skg', '$jam_sekarang')";
$result = mysql_query($query);
header("location:keranjang_belanja.php");
}else{
$jmllama = $data_transaksi['jumlah'];
$jmltambah = $jmllama + 1;
$subtotaltambah = $jmltambah * $har;
$query = "update transaksirincitbl set jumlah = '".$jmltambah."',subtotal = '".$subtotaltambah."' where notransaksi ='".$faktur."' and id_barang ='".$id."'";
$result = mysql_query($query);
header("location:keranjang_belanja.php");
}
}else{
echo"Data gagal diInput..!";
}
}
?>

<?php session_start();
require("config.php");
require("faktur.php");
$member = $_SESSION['userlogin'];
if((isset($_SESSION['userlogin'])) ==''){
header("location:index.php");
}else{
$cari="select * from transaksitbl where notransaksi='" .$faktur. "' and username ='" .$member. "' and status ='0'";
$query=mysql_query($cari);
if(mysql_num_rows($query)==0){
echo"<font face=\"arial\" size=\"2\">Maaf, Anda belum melakukan pembelian <a ><b>Pembelian</b></a></font>";
}else{
$cari="select * from pelanggantbl where username ='" .$member. "'";
$query=mysql_query($cari);
$data = mysql_fetch_array($query);

$mail_to="iwan_neutron@yahoo.com";
$mail_subject="Pembelian Barang Online";

$mail_body = "Email------------: $data[email]\n\n";
$mail_body.= "Nama Lengkap-----: $data[nama]\n\n";
$mail_body.= "Alamat Lengkap---: $data[alamat]\n\n";
$mail_body.= "Telepon----------: $data[telepon]\n\n";
$mail_body.= "Daftar Pemesanan Barang\n";
$mail_body.="==========================================================================================================\n";
$mail_body.="----------Judul----------Quantity-----Harga-----Jumlah-----\n";
$mail_body.="==========================================================================================================\n";

$cari="select * from transaksirincitbl where notransaksi='" .$faktur. "'";
$query=mysql_query($cari);
while($row=mysql_fetch_array($query)){
$nama="$row[nama]";
$jumlah="$row[jumlah]";
$harga="$row[harga]";
$total="$row[subtotal]";
$mail_body.= "$nama / $jumlah / $harga / $total\n";
$mail_body.="----------------------------------------------------------------------------------------------------------\n";
}
$mail_body.="==========================================================================================================\n";

$cari2 = "select sum(subtotal) as total from transaksirincitbl inner join barangtbl on barangtbl.id_barang = transaksirincitbl.id_barang inner join transaksitbl on transaksitbl.notransaksi = transaksirincitbl.notransaksi WHERE transaksirincitbl.username='".$member."' AND transaksitbl.status ='0'";
$hasil = mysql_query($cari2);
$data_total = mysql_fetch_assoc($hasil);
$mail_body.="Total : $data_total[total]\n";
$mail_body.="----------------------------------------------------------------------------------------------------------\n";
$proses=explode(",",$mail_to);

reset($proses);
foreach ($proses as $tujuan) {
$kirim = mail($tujuan,$mail_subject,$mail_body, "From: $data[email]");
}
if ($kirim) {

$query = "UPDATE transaksitbl SET status = '1' WHERE username = '$member'";
mysql_query($query);
if($query){
header("location:transaksi_selesai.php");
}else{
echo"Check Out gagal";
}

}else{
echo "<font face=\"arial\" size=\"2\">E-mail Anda belum terkirim. Harap ulangi. <a ><b>Kembali</b></a></font>";
}
}
}
?>

`barangtbl` (
`id_barang` int(11) NOT NULL AUTO_INCREMENT,
`nama` varchar(35) NOT NULL,
`deskripsi` text NOT NULL,
`warna` varchar(25) NOT NULL,
`ukuran` varchar(15) NOT NULL,
`kategori` varchar(25) NOT NULL,
`harga` int(11) NOT NULL,
`stock` int(11) NOT NULL,
`gambar` varchar(50) NOT NULL,
PRIMARY KEY (`id_barang`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

transaksirincitbl` (
`notransaksi` varchar(25) NOT NULL,
`username` varchar(20) NOT NULL,
`id_barang` int(11) NOT NULL,
`nama` varchar(60) NOT NULL,
`harga` int(11) NOT NULL,
`jumlah` int(11) NOT NULL,
`subtotal` int(11) NOT NULL,
`tanggal` date NOT NULL,
`jam` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;