Scribd
Upload
98 views50 pages

Listing Program

The document contains PHP code for a web page that serves as a visitor's homepage for an e-commerce site called Hadad Sport. It includes session management, a product catalog with pagination, and dynamic content such as recent products and bestsellers. The page also integrates JavaScript for a slideshow feature and utilizes a MySQL database for product data retrieval.

Uploaded by

IntanFuji Arief
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
98 views50 pages

Listing Program

The document contains PHP code for a web page that serves as a visitor's homepage for an e-commerce site called Hadad Sport. It includes session management, a product catalog with pagination, and dynamic content such as recent products and bestsellers. The page also integrates JavaScript for a slideshow feature and utilizes a MySQL database for product data retrieval.

Uploaded by

IntanFuji Arief
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Halaman Pengunjung

Index.php
<?php
session_start();
if(isset($_SESSION['login_pelanggan'])==FALSE)
{
$_SESSION['login_pelanggan']=FALSE;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252" />
<link rel="shortcut icon" href="images/hadad.png" />
<title>Hadad Sport &reg;</title>
<?php include("lib_func.php"); ?>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script src="javascripts/jquery.js" type="text/javascript"></script>
<script src="slide/js/jquery.min.js"></script>
<script src="slide/js/jquery.easing.1.3.js"></script>
<script src="slide/js/slides.min.jquery.js"></script>
<script>
$(function(){
$('#slides').slides({
preload: true,
preloadImage: 'img/loading.gif',
play: 5000,
pause: 2500,
hoverPause: true
});
});
</script>
</head>
<body>
<?php
if(!isset($_REQUEST['judul']))
$judul='beranda';
else {
$judul=$_REQUEST['judul'];
$judul=str_replace('**',' ',$judul);
}
?>
<!----HEADER--->
<div id="header">
<?php ataslogoalamat(); ?>
</div>
<div id="header2"></div>
<!---ISI TENGAH---->
<div id="tengah">
<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div class="center_content_index">
<div id="main_content">
<?php menu_atas(); ?>
<div class="left_content">
<?php jam(); ?>
<?php keranjang(); ?>
<div class="title_box_subkategori">SubKategori</div>
<ul class="left_menu">
<?php list_subkategori(); ?>
</ul>
<?php hubungi(); ?>
<?php kirim(); ?>
</div>
<div class="center_content">
<div id="container_slide">
<div id="example">
<img src="slide/img/new-ribbon.png" width="112"
height="112" alt="New Ribbon" id="ribbon">
<div id="slides">
<div class="slides_container">
<a href="about.php" title="145.365 -
Happy Bokeh Thursday! | Flickr - Photo Sharing!" target="_blank"><img
src="slide/img/slide-1.jpg" width="570" height="270" alt="Slide
1"></a>
<a href="about.php" title="Taxi | Flickr -
Photo Sharing!" target="_blank"><img src="slide/img/slide-2.jpg"
width="570" height="270" alt="Slide 2"></a>
<a href="about.php" title="Happy Bokeh
raining Day | Flickr - Photo Sharing!" target="_blank"><img
src="slide/img/slide-3.jpg" width="570" height="270" alt="Slide
3"></a>
<a href="about.php" title="We Eat Light
| Flickr - Photo Sharing!" target="_blank"><img src="slide/img/slide-
4.jpg" width="570" height="270" alt="Slide 4"></a>
<a href="about.php" title="We Eat Light
| Flickr - Photo Sharing!" target="_blank"><img src="slide/img/slide-
5.jpg" width="570" height="270" alt="Slide 4"></a>
</div>
<a href="#" class="prev"><img
src="slide/img/arrow-prev.png" width="24" height="43" alt="Arrow
Prev"></a>
<a href="#" class="next"><img
src="slide/img/arrow-next.png" width="24" height="43" alt="Arrow
Next"></a>
</div>
<img src="slide/img/example-frame.png"
width="739" height="341" alt="Example Frame" id="frame">
</div>
</div>
<div class="center_title_bar">Katalog Produk</div>
<?php
include "inc.koneksi.php";
$sqlCount = "SELECT COUNT(id_produk) FROM tbl_produk";
$rsCount = mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 9;
$mulai_dari = $limit * ($page - 1);

$sql = mysql_query("SELECT * FROM tbl_produk ORDER BY


id_produk DESC LIMIT $mulai_dari,$limit");
$jumlahdata=mysql_num_rows($sql);
if($jumlahdata>0){
$i=0;
while ($row = mysql_fetch_array($sql)){
$i++;
?>
<div class="prod_box">
<div class="produk_tengah">
<div class="product_title"><a href="detail_produk.php?produk_id=<?
php echo $row['id_produk']; ?>" title="header=[<?php echo
$row['id_produk']; ?>] body=[Nama : <?php echo $row['nama_produk']; ?
><br>Harga : Rp. <?php echo number_format($row['harga'],0, ",","."); ?
>,-<br>Deskripsi : <?php echo $row['deskripsi']; ?>] fade=[on]"><?php
echo $row['nama_produk']; ?></a></div>
<div class="gambar_produk">
<a href="detail_produk.php?produk_id=<?php
echo $row['id_produk']; ?>"><img src="GambarProduk/<?php echo
$row['file_gambar']; ?>" style="cursor:pointer;"></a>
</div>
<div class="harga_display">Rp. <?php echo
number_format($row['harga'],0, ",","."); ?>,-</div>
</div>
<div class="bawah_produk">
<p align="center">
<a href="detail_produk.php?produk_id=<?php echo $row['id_produk']; ?
>" title="header=[Lihat Detail Produk] body=[&nbsp;] fade=[on]"><img
src="images/note.png" alt="" title="" border="0" class="left_bt" /></a>
<?php
if ($_SESSION['login_pelanggan']==TRUE)
{
?>
<a href="input_keranjang.php?produk_id=<?php echo
$row['id_produk']; ?>" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" class="left_bt" /></a>
<?php
} else
{
?>
<a href="login.php" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" class="left_bt" /></a>
<?php
}
?>
</p>
</div>
</div>
<?php
}
}
?>
<div class="center_title_bar_halaman">
<div class="pagination">
<?php
$banyakHalaman = ceil($banyakData / $limit);
echo '<a href="index.php?page=1"><<</a> ';

if($page > 1)
{
$previous=$page-1;
echo '<a href="index.php?page='.$previous.'"><</a> ';
}else{
echo "<span class='disabled'><</span> ";
}

for($i = 1; $i <= $banyakHalaman; $i++){


if($page != $i){
echo '<a href="index.php?page='.$i.'">'.$i.'</a> ';
}else{
echo "<span class='current'>$i</span> ";
}
}

if($page < $banyakHalaman)


{
$next=$page+1;
echo '<a href="index.php?page='.$next.'">></a> ';
}else{
echo "<span class='disabled'>></span> ";
}

if($page < $banyakHalaman)


{
$next=$page+1;
echo '<a href="index.php?page='.
$banyakHalaman.'">>></a> ';
}else{
echo "<span class='disabled'>>></span> ";
}
?>
</div>
</div>
</div>
<div class="right_content">
<?php cari(); ?>

<?php terbaru(); ?>


<?php bestseller(); ?>
<?php banyakdilihat(); ?>
</div>
</div>
</div>
</div>
<!----FOOTER--->
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>

inc.koneksi.php
<?php
$host = "localhost";
$username = "root";
$password = "";
$databasename = "dbecommerce";
$connection = mysql_connect($host, $username) or die("Koneksi
Bermasalah");
mysql_select_db($databasename, $connection) or die("Databasenya
Error");
?>

inc.librari.php
<?php
function idauto($tabel, $inisial){
$struktur = mysql_query("SELECT * FROM $tabel");
$field = mysql_field_name($struktur,0);
$panjang = mysql_field_len($struktur,0);

$qry = mysql_query("SELECT max(".$field.") FROM ".$tabel);


$row = mysql_fetch_array($qry);
if ($row[0]=="") {
$angka=0;}
else {$angka= substr($row[0], strlen($inisial));}
$angka++;
$angka =strval($angka);
$tmp ="";
for($i=1; $i<=($panjang-strlen($inisial)-strlen($angka)); $i++)
{$tmp=$tmp."0"; }return $inisial.$tmp.$angka;}
?>

lib_func.php
<?php
function header_bawah(){
?>
<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>
<?php
}
?>
<?php
function menu_atas_pelanggan(){
?>
<div id="menu_tab">
<ul class="menu">
<li><a href="logout.php" class="nav7">Logout</a></li>
<li class="divider"></li>
<li><a href="about.php" class="nav10">About</a></li>
<li class="divider"></li>
<li><a href="pesanbayar.php" class="nav5">Pesan dan Bayar</a></li>
<li class="divider"></li>
<li><a href="tentangkami.php" class="nav6">Tentang Kami</a></li>
<li class="divider"></li>
<li><a href="history_pesanan.php" class="nav9">History
Pemesanan</a></li>
<li class="divider"></li>
<li><a href="profil_user.php" class="nav8"><?php echo
ucfirst($_SESSION['username_pelanggan']); ?></a></li>
<li class="divider"></li>
<li><a href="index.php?judul=beranda"
class="nav2">Beranda</a></li>
</ul>
</div>
<?php
}
?>
<?php
function menu_atas_pengunjung(){
?>
<div id="menu_tab">
<ul class="menu">
<li><a href="login.php" class="nav1">Login</a></li>
<li class="divider"></li>
<li><a href="register.php" class="nav4">Daftar</a></li>
<li class="divider"></li>
<li><a href="about.php" class="nav10">About</a></li>
<li class="divider"></li>
<li><a href="pesanbayar.php" class="nav5">Pesan dan Bayar</a></li>
<li class="divider"></li>
<li><a href="tentangkami.php" class="nav6">Tentang Kami</a></li>
<li class="divider"></li>
<li><a href="index.php?judul=beranda"
class="nav2">Beranda</a></li>
</ul>
</div>
<?php
}
?>
<?php
function menu_atas(){
if ($_SESSION['login_pelanggan']==TRUE)
{
header_ateh();
menu_atas_pelanggan();
} else
{
header_ateh();
menu_atas_pengunjung();
}
}
?>
<?php
function terbaru(){
?>
<?php
include "inc.koneksi.php";
$sql = mysql_query("SELECT
id_produk,nama_produk,harga,file_gambar FROM tbl_produk ORDER BY
id_produk DESC LIMIT 1");
$row = mysql_fetch_array($sql);
$id_produk=$row['id_produk'];
$nama_produk=$row['nama_produk'];
$harga=$row['harga'];
$file_gambar=$row['file_gambar'];
?>
<div class="title_box_terbaru">Terbaru</div>
<div class="border_box">
<div class="product_title"><a href="detail_produk.php?produk_id=<?
php echo $row['id_produk']; ?>"><?php echo "$nama_produk"; ?
></a></div>
<div class="gambar_produk"><a href="detail_produk.php?
produk_id=<?php echo $row['id_produk']; ?>"><img
src="GambarProduk/<?php echo $row['file_gambar']; ?>"></a></div>
<div class="harga_display">Rp. <?php echo
number_format($row['harga'],0, ",","."); ?>,-</div>
<!--<div class="harga_display_kotak_yang_dipinggir">
<?php
/* if ($_SESSION['login_pelanggan']==TRUE)
{ */
?>
<a href="input_keranjang.php?produk_id=<?php /* echo
$row['id_produk']; */ ?>" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" /></a>
<?php
/* } else
{ */
?>
<a href="login.php" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" /></a>
<?php
/* } */
?>
<a href="detail_produk.php?produk_id=<?php /* echo $row['id_produk'];
*/ ?>" title="header=[Lihat Detail Produk] body=[&nbsp;]
fade=[on]"><img src="images/note.png" alt="" title="" border="0"
/></a>
</div> -->
</div>
<?php
}
?>
<?php
function banyakdilihat(){
?>
<?php
include "inc.koneksi.php";
$sql = mysql_query("SELECT
id_produk,nama_produk,harga,file_gambar FROM tbl_produk WHERE
counter=(SELECT MAX(counter) FROM tbl_produk) LIMIT 1");
$row = mysql_fetch_array($sql);
$id_produk=$row['id_produk'];
$nama_produk=$row['nama_produk'];
$harga=$row['harga'];
$file_gambar=$row['file_gambar'];
?>
<div class="title_box_terbanyak">Banyak Dilihat</div>
<div class="border_box">
<div class="product_title"><a href="detail_produk.php?produk_id=<?
php echo $row['id_produk']; ?>"><?php echo "$nama_produk"; ?
></a></div>
<div class="gambar_produk"><a href="detail_produk.php?
produk_id=<?php echo $row['id_produk']; ?>"><img
src="GambarProduk/<?php echo $row['file_gambar']; ?>"></a></div>
<div class="harga_display">Rp. <?php echo
number_format($row['harga'],0, ",","."); ?>,-</div>
<!--<div class="harga_display_kotak_yang_dipinggir">
<?php
/* if ($_SESSION['login_pelanggan']==TRUE)
{ */
?>
<a href="#" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" /></a>
<?php
/* } else
{ */
?>
<a href="login.php" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" /></a>
<?php
/* } */
?>
<a href="#" title="header=[Lihat Detail Produk] body=[&nbsp;]
fade=[on]"><img src="images/note.png" alt="" title="" border="0"
/></a>
</div> -->
</div>
<?php
}
?>
<?php
function cari(){
?>
<div class="title_box_cari">Pencarian</div>
<div class="border_box_cari">
<form action="hasil_pencarian.php" method="get">
<input type="text" name="keyword" input id="s" onfocus="if
(this.value == 'Pencarian..') {this.value = '';}" value="Pencarian.."
onblur="if (this.value == '') {this.value = 'Pencarian..';}" />
<!--<input name="carii" value="Cari" type="submit" class="cari">
-->
</form>
</div>
<?php
}
function keranjang(){
?>
<div class="shopping_cart">
<?php
include "inc.koneksi.php";
if ($_SESSION['login_pelanggan']==TRUE)
{
$id_pelanggan=$_SESSION['id_pelanggan'];
$sql = mysql_query("SELECT sum( qty ) as qty, sum( subtotal ) as
subtotal FROM tbl_keranjang WHERE id_pelanggan = '$id_pelanggan'");
$pesan = 0;
$pesan2 = 0;
$psn = mysql_fetch_row($sql);
$pesan = $pesan + $psn[0];
$pesan2 = $pesan2 + $psn[1];
?>
<div class="cart_title">Keranjang Belanja</div>
<div class="cart_details">
Jumlah : <b><?php echo $pesan; ?></b> item
<br />
<span class="border_cart"></span>
Total : <b>Rp. <?php echo number_format($pesan2,0, ",","."); ?>,-
</b>
</div>
<div class="cart_icon">
<a href="list_keranjang_belanja.php">
<img src="images/shoppingcart.png" alt="" title="" border="0" />
</a>
<?php
} else {
?>
<div class="cart_title">Keranjang Belanja</div>
<div class="cart_details">
Jumlah : <b>0</b> item
<br />
<span class="border_cart"></span>
Total : <b>Rp. 0,-</b>
</div>
<div class="cart_icon">
<a href="login.php">
<img src="images/shoppingcart.png" alt="" title="" border="0" />
</a>
<?php
}
?>
</div>
</div>
<?php
}
function bestseller(){
?>
<?php
include "inc.koneksi.php";
$sql = mysql_query("SELECT a.id_produk, a.nama_produk,
a.file_gambar, a.harga, SUM(b.qty)
FROM
tbl_produk a LEFT JOIN tbl_detail_pesanan b ON a.id_produk =
b.id_produk
GROUP BY
a.nama_produk, a.file_gambar, a.harga
ORDER BY
SUM(b.qty) DESC LIMIT 1");
$row = mysql_fetch_array($sql);
$id_produk=$row['id_produk'];
$nama_produk=$row['nama_produk'];
$harga=$row['harga'];
$file_gambar=$row['file_gambar'];
?>
<div class="title_box_terlaris">Terlaris</div>
<div class="border_box">
<div class="product_title"><a href="detail_produk.php?produk_id=<?
php echo $row['id_produk']; ?>"><?php echo "$nama_produk"; ?
></a></div>
<div class="gambar_produk"><a href="detail_produk.php?
produk_id=<?php echo $row['id_produk']; ?>"><img
src="GambarProduk/<?php echo $row['file_gambar']; ?>"></a></div>
<div class="harga_display">Rp. <?php echo
number_format($row['harga'],0, ",","."); ?>,-</div>
<!--<div class="harga_display_kotak_yang_dipinggir">
<?php
/* if ($_SESSION['login_pelanggan']==TRUE)
{ */
?>
<a href="#" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" /></a>
<?php
/* } else
{ */
?>
<a href="login.php" title="header=[Tambah ke Keranjang Belanja]
body=[&nbsp;] fade=[on]"><img src="images/cart.png" alt="" title=""
border="0" /></a>
<?php
/* } */
?>
<a href="#" title="header=[Lihat Detail Produk] body=[&nbsp;]
fade=[on]"><img src="images/note.png" alt="" title="" border="0"
/></a>
</div> -->
</div>
<?php
}
function hubungi(){
?>
<script>
function PopupCenter(pageURL, title,w,h) {
var left = (screen.width/2)-(w/2);
var top = (screen.height/2)-(h/2);
var targetWin = window.open (pageURL, title, 'toolbar=no,
location=no, directories=no, status=no, menubar=no, scrollbars=no,
resizable=no, copyhistory=no, width='+w+', height='+h+', top='+top+',
left='+left);
}
</script>
<div class="title_box_kontak">Hubungi Kami</div>
<div class="border_box">

<div class="border_box"><center><a href="javascript:void(0);"


onclick="PopupCenter('ym/ym_hadad_sport.php',
'myPop1',355,530);"><img src='images/cs.jpg' width='190' height='120'
/></a></center>
<center><font size='2' /><b>Jam kerja Online :<br/>Senin-Jumat
08.00-17.00 WIB<br>Sabtu 08.00-14.00 WIB</b></center>
</div></div>
<?php
}

?>
function footer(){
?>
<table width="100%" border="0" align="center">
<tr>
<td width="334"><img src="images/logo-bri.gif" height="35"
width='80'/><img src="images/bni46.jpg"height="35" width='80'
/><img src="images/bpd.jpg" height="35" width='80'/></td>
<td width="495">
<p>Alamat : Jalan Raya Payakumbuh - Lintau KM 7, Tarok Andaleh
<br /></p>
<p>Telp.(0752)7308571 Fax.(0752)7301071<br /></p>
<p>Email : [email protected]</p>
<p>&copy;copyright 2012 Hadad Sport&trade;<br /></p>
</td>
<td width="334"><img src="images/facebook.png"
border="0"/><img src="images/twiiter.png" border="0"/></td>
</tr>
</table>

<?php
}
?>
<?php
function info_tanggal()
{

$hari=array("Minggu","Senin","Selasa","Rabu","Kamis","Jum'at","Sabtu");

$bulan=array("","Januari","Februari","Maret","April","Mei","Juni","Juli",

"Agustus","September","Oktober","November","Desember");
$tgl=getdate();
echo $hari[$tgl['wday']].", $tgl[mday]-".$bulan[$tgl['mon']]."-
$tgl[year]";
}
?>
<?php
function ataslogoalamat(){
?>
<div id="namaperusahaan">
<marquee>Selamat datang di <img src='images/indonesia.jpg' />
TOKO HADAD SPORT, belanja mudah, aman dan terpercaya. .:: <?php
echo (date("d - M - Y")); ?> ::.</marquee>
</div>
<?php
}
?>
<?php
function header_ateh(){
?>
<center><img src="images/header.jpg"></img></center>
<div class="warna_tengah"></div>
<?php
}
?>
<?php
function list_subkategori(){
include "inc.koneksi.php";
$row=1;
$sql=mysql_query("SELECT * FROM tbl_subkategori ORDER BY
id_subkategori");
/* $qry=mysql_query($sql) or die ("Gagal Query"); */
if(mysql_num_rows($sql)>0){
while($data=mysql_fetch_array($sql)){
$sql_jum="SELECT COUNT(*) AS jum FROM tbl_produk WHERE
id_subkategori='".$data['id_subkategori']."'";
$qry_jum=mysql_query($sql_jum);
$hsl_jum=mysql_fetch_array($qry_jum);
$nama_subkategori=$data['nama_subkategori'];
$nama_subkategori=str_replace(' ','**',$nama_subkategori);
?>
<li class="odd">
<a href="tampil_pilih_subkategori.php?id_subkategori=<?php echo
$data['id_subkategori']; ?>&judul=<?php echo $nama_subkategori ?
>"><?php echo $data['nama_subkategori']."&nbsp;<b>(".
$hsl_jum['jum'].")</b>"; ?></a>
</li>
<?php
}
}
}
?>
<?php
function kirim(){
?>
<div class="title_box_kirim">Didukung Oleh</div>
<div class="border_box">
<img src="images/upi.png" width="200" height="120" />
</div>
<?php
}
function konversikedolar($uang){
include "inc.koneksi.php";
$res=mysql_query("select kurs from tbl_mata_uang where
kode='USD'");
if($res){
$data=mysql_fetch_row($res);
return $uang/$data[0];
}
else
return 0;
}
?>
<?php
function jam(){
?>
<div class="title_box">Jam Dinding</div>
<div class='border_box'>
<embed quality="high" allowscriptaccess="always" type="application/x-
shockwave-flash" height="170px" src="images/jam.swf" width="170px"
wmode="transparent" ></embed></div>
<?php
}
?>

list_keranjang_belanja.php
<?php
session_start();
if(isset($_SESSION['login_pelanggan'])==FALSE)
{
$_SESSION['login_pelanggan']=FALSE;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252" />
<link rel="shortcut icon" href="images/hadad.png" />
<title>Elvana Sport &reg;</title>
<?php include("lib_func.php"); ?>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script src="javascripts/jquery.js" type="text/javascript"></script>
<script src="ajax_combo.js" type="text/javascript"></script>
<script type="text/javascript" src="validasidaftar/jquery-
1.4.js"></script>
<!--script src="updatejumlah.js" type="text/javascript"></script-->
<script type="text/javascript">
function edit_data_keranjang(pengunjung,produk,i){
var qty=document.getElementById("qty"+i).value;
document.location="update_jumlah_proses.php?
edit_data_keranjang="+produk+"&pelanggan="+pengunjung+"&qty="+
qty;
}
function checkout(){
var count = document.getElementById("count").value;
var total_bayar =
document.getElementById("total_bayar").value;
var id, qty, harga, jumlah_berat_produk, jumlah_produk;
id = "";
qty = "";
harga = "";
jumlah_berat_produk =
document.getElementById("jumlah_berat_produk").value;
jumlah_produk =
document.getElementById("jumlah_produk").value;
for(var i = 1; i <= count; i++ ) {
id +=
document.getElementById("id_produk"+i).value;
id += ";";
qty += document.getElementById("qty"+i).value;
qty += ";";
harga +=
document.getElementById("harga"+i).value;
harga += ";";
}
document.location="proses_simpan_pesanan.php?
count="+count+"&id="+id+"&qty="+qty+"&harga="+harga+"&jumlah_
berat_produk="+jumlah_berat_produk+"&jumlah_produk="+jumlah_prod
uk+"&total_bayar="+total_bayar;
}
</script>
</head>
<body>
<?php
if(!isset($_REQUEST['judul']))
$judul='beranda';
else {
$judul=$_REQUEST['judul'];
$judul=str_replace('**',' ',$judul);
}
?>
<!----HEADER--->
<div id="header">
<?php ataslogoalamat(); ?>
</div>
<div id="header2"></div>
<!---ISI TENGAH---->
<div id="tengah">

<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div class="center_content_index">
<div id="main_content">
<?php menu_atas(); ?>
<div class="left_content">
<?php jam(); ?>
<?php keranjang(); ?>
<div class="title_box_subkategori">SubKategori</div>
<ul class="left_menu">
<?php list_subkategori(); ?>
</ul>
<?php hubungi(); ?>
<?php kirim(); ?>
</div>
<div class="center_content">
<div class="center_title_keranjang">Keranjang Belanja</div>
<div align="center">
<p><br />
<br />
</p>
<p>&nbsp;</p>
</div>
<?php
if (isset($_GET['eror'])){
?>
<div class="cariinfoo">Maaf Jumlah Yang Dibeli '<?php echo
$_GET['eror']; ?>' Melebihi Stok Yang Ada !</div>
<?php
}
?>
<div align="center">
&nbsp;
</div>
<?php

$id_pelanggan=$_SESSION['id_pelanggan'];

$sql=mysql_query("SELECT * FROM tbl_keranjang WHERE


id_pelanggan='$id_pelanggan'");
$jumlahdata=mysql_num_rows($sql);
$jumlah_produk=0;
$jumlah_berat_produk=0;
$total_bayar=0;
if($jumlahdata>0){
?>
<table width="586">
<tr>
<td width="171" class="tabelkeranjang"><span class="blue2">Nama
Produk</span></td>
<td width="131" class="tabelkeranjang"><span
class="blue2">Harga</span></td>
<td width="96" class="tabelkeranjang"><span
class="blue2">Jumlah</span></td>
<td width="88" class="tabelkeranjang"><span
class="blue2">SubTotal</span></td>
<td colspan="2" class="tabelkeranjang"><span
class="blue2">Keterangan</span></td>
</tr>
<?php
$i=0;
while ($row = mysql_fetch_array($sql)){
$i++;
$total_berat_produk=$row['total_berat']*$row['qty'];
$subtotal=$row['harga']*$row['qty'];
$total_bayar+=$subtotal;
$jumlah_berat_produk+=$total_berat_produk;
$jumlah_produk+=$row['qty'];
?>
<tr>
<td width="171" height="28" class="tabeltdkeranjang"><a
href="detail_produk.php?produk_id=<?php echo $row['id_produk']; ?
>"><?php echo $row['nama_produk']; ?></a></td>
<td width="131" class="tabeltdangka">Rp. <?php echo
number_format($row['harga'],0, ",","."); ?>,-</td>
<td width="96" class="tabeltdkeranjang"><input type="text" size="2"
maxlength="3" name="qty" value="<?php echo $row['qty']; ?>" id="<?
php echo 'qty'.$i; ?>" ></td>
<td width="88" class="tabeltdangka">Rp. <?php echo
number_format($subtotal,0,",","."); ?>,-</td>
<td width="33" class="tabeltdkeranjang"><a href="#"><img
src="images/refresh_page.png" onClick="edit_data_keranjang('<?php
echo $row['id_pelanggan']; ?>','<?php echo $row['id_produk']; ?>','<?
php echo $i; ?>');" /></a><!--<a href="#">--></td>
<td width="39" class="tabeltdkeranjang"><a
href="keranjang_konfirmasi_hapus.php?hapus_produk=<?php echo
$row['id_produk']; ?>"><img src="images/trash_can.png" /></a></td>
<input type="hidden" id="id_produk<?php echo $i; ?>" value="<?php
echo $row['id_produk']; ?>" />
<input type="hidden" id="qty<?php echo $i; ?>" value="<?php echo
$row['qty']; ?>" />
<input type="hidden" id="harga<?php echo $i; ?>" value="<?php echo
$subtotal; ?>" />
</tr>
<?php
}
?>
<input type="hidden" id="count" value="<?php echo $i; ?>" />
</table>
<?php
} else {
?>
<div class="cariinfoo">Data Keranjang Anda Kosong !</div>
<?php
}
?>
<div align="center">
&nbsp;
</div>
<table width="586" border="0">
<tr>
<td width="574" class="tabelkeranjangtotal">Total Pembayaran : Rp.
<?php echo number_format($total_bayar,0, ",","."); ?>,-</td>
<input type="hidden" id="total_bayar" value="<?php echo
$total_bayar; ?>" />
<input type="hidden" id="jumlah_berat_produk" value="<?php echo
$jumlah_berat_produk; ?>" />
<input type="hidden" id="jumlah_produk" name="jumlah_produk"
value="<?php echo $jumlah_produk; ?>" />
</tr>
</table>
<!--a href="proses_simpan_pesanan.php" class="selesai
icon"><span>Checkout</span></a-->
<a href="#" class="selesai icon"
onclick="checkout();"><span>Checkout</span></a>
<a href="index.php" class="tambahkeranjang icon"><span>Lanjut
Belanja</span></a>
</form>
</div>
</div>
<div class="right_content">
<?php cari(); ?>
<?php terbaru(); ?>
<?php bestseller(); ?>
<?php banyakdilihat(); ?>
</div>
</div>
</div>
</div>
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>

login.php
<?php
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252" />
<link rel="shortcut icon" href="images/hadad.png" />
<title>Hadad Sport &reg;</title>
<?php include("lib_func.php"); ?>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script src="javascripts/jquery.js" type="text/javascript"></script>
</head>
<body>
<?php
if(!isset($_REQUEST['judul']))
$judul='beranda';
else {
$judul=$_REQUEST['judul'];
$judul=str_replace('**',' ',$judul);
}
?>
<!----HEADER--->
<div id="header">
<?php ataslogoalamat(); ?>
</div>
<div id="header2"></div>
<!---ISI TENGAH---->
<div id="tengah">

<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div class="center_content_index">
<div id="main_content">
<?php menu_atas(); ?>
<div class="left_content">
<?php jam(); ?>
<?php keranjang(); ?>
<div class="title_box_subkategori">SubKategori</div>
<ul class="left_menu">
<?php list_subkategori(); ?>
</ul>
<?php hubungi(); ?>
</div>
<!--<div class="piclogin">
<img src="images/locklogin.png" border="0" />
<div class="bottomgambar">
JAMINAN PRIVASI
</div>
</div> -->
<div class="login_box">
<div class="headlogin">Login Pelanggan</div>
<div class="formlogin">
<form name="loginuser" method="post"
action="login_proses.php">
<table width="300">
<tr>
<td width="90" height="30" class="formlogin"><label
class="lbl"><span class="blue2">User Id</span></label></td>
<td width="198" class="formlogin"><input name="username"
type="text" size="25" maxlength="50" tabindex="1" onblur="regb(this)"
onfocus="regf(this)" /></td>
</tr>
<tr>
<td width="90" height="30" class="formlogin"><label
class="lbl"><span class="blue2">Password</span></label></td>
<td width="198" class="formlogin"><input name="password"
type="password" size="25" maxlength="50" tabindex="2"
onblur="regb(this)" onfocus="regf(this)" /></td>
</tr>
<tr>
<td width="90" class="formlogintombol"><span
class="blue2">&nbsp;</span></td>
<td width="198" class="formlogintombol"><br/>
<input name="klik" type="submit" value="Login"
class="formlogintombol" tabindex="3" />
<input name="clear" type="reset" value="Ulang"
class="formlogintombol" tabindex="4" />
<br/>
</td>
</tr>
</table>
</form>
</div>

</div>
</div>
<div class="kalimatdaftar">
Anda Belum Mempunyai Account, Ingin Melakukan Pemesanan Secara
Mudah dan Mempercepat Proses Belanja ?<br />
Segera Daftarkan Diri Anda. <br /><a href="register.php"
class="daftar icon"><span>Daftar Disini !</span></a>
</div>
<!--<div class="daftarhallogin">
Segera Daftar Sebagai Member.<br />
<a href="register.php" class="tombol">Daftar Menjadi Member !</a>
</div> -->

<div class="right_content">
<?php cari(); ?>
<?php terbaru(); ?>
<?php bestseller(); ?>
<?php banyakdilihat(); ?>
</div>
</div>
</div>
</div>
<!----FOOTER--->
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>

register.php
<?php
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252" />
<link rel="shortcut icon" href="images/hadad.png" />
<title>Hadad Sport &reg;</title>
<?php include("lib_func.php"); ?>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script src="javascripts/jquery.js" type="text/javascript"></script>
<script src="ajax_combo.js" type="text/javascript"></script>
<script type="text/javascript" src="validasidaftar/jquery-
1.4.js"></script>
<script type="text/javascript"
src="validasidaftar/jquery.validate.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#form1").validate({
rules: {
alamat_pelanggan: "required",
nama_lengkap: "required",
nama: "required",
kodepos: {
required: true,
number: true
},
phone: {
required: true,
number: true
},
pass: {
required: true,
minlength: 5
},
ulang_password:
{
required: true,
equalTo: "#password"
},
email: {
required: true,
email: true
},
provinsi: {
required: true,
},
kabkota: {
required:true,
}
},

messages: {
nama_lengkap: {
required: '*Nama harus di isi'
},
nama: {
required: '*Username harus di isi'
},
pass: {
required : '*Password harus di isi',
minlength: '*Password minimal 5 karakter'
},
ulang_password: {
required: '*Ulangi Password harus di isi',
equalTo : '*Isinya harus sama dengan
Password'
},
email: {
required: '*Email harus di isi',
email : '*Email harus valid'
},
alamat_pelanggan: {
required: '*Alamat harus di isi'
},
kodepos: {
required: '*Kodepos harus di isi',
number : '*Hanya boleh di isi Angka'
},
phone: {
required: '*No. Hp harus di isi',
number : '*Hanya boleh di isi Angka'
},
provinsi: {
required: '*Pilih Propinsi',
},
kabkota: {
required: '*Pilih Kabupaten/Kota',
}
},

success: function(label) {
label.text('OK!').addClass('valid');
}
});
});
</script>
</head>
<body>
<?php
if(!isset($_REQUEST['judul']))
$judul='beranda';
else {
$judul=$_REQUEST['judul'];
$judul=str_replace('**',' ',$judul);
}
?>
<!----HEADER--->
<div id="header">
<?php ataslogoalamat(); ?>
</div>
<div id="header2"></div>
<!---ISI TENGAH---->
<div id="tengah">

<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div class="center_content_index">
<div id="main_content">
<?php menu_atas(); ?>
<div class="left_content">
<?php jam(); ?>
<?php keranjang(); ?>
<div class="title_box_subkategori">SubKategori</div>
<ul class="left_menu">
<?php list_subkategori(); ?>
</ul>
<?php hubungi(); ?>
<?php kirim(); ?>
</div>
<form id="form1" method="post"
action="proses_proses_register.php">
<div class="center_content">
<div class="center_title_bar_daftar">Pendaftaran</div>
<div align="center">
&nbsp;
</div>
<?php
if(isset($_REQUEST['status_email'])) {
?>
<div class="cariinfoo" >Mohon maaf pendaftaran anda gagal
disimpan.<br />Email "<?php echo $_REQUEST['mail']; ?>" telah
terdaftar. <br />Silahkan isi kembali data untuk melakukan
pendaftaran.</div>
<?php
}
else if(isset($_REQUEST['usernmame'])) {
?>
<div class="cariinfoo" >Mohon maaf pendaftaran anda gagal
disimpan.<br />Username dengan nama "<?php echo
$_REQUEST['username']; ?>" telah terdaftar. <br />Silahkan isi kembali
data untuk melakukan pendaftaran.</div>
<?php
}
?>
<table width="585" class="tabeldaftar">
<tr class="form-divjudul">
<td colspan="2" class="form-row"><b>Isi Data
Pendaftaran</b></td>
</tr>
<tr class="form-div">
<td width="160" class="label"></td>
<td class="form-row">
<?php
include "inc.koneksi.php";

include "inc.librari.php";
?>
<input name="id" type="hidden" maxlength="4" value="<?php
echo idauto("tbl_pelanggan","M"); ?>" disabled size="20">
<input name="idh" type="hidden" value="<?php echo
idauto("tbl_pelanggan","M"); ?>" size="20"></td>
</tr>
<tr class="form-div2">
<td width="160" class="label">Nama Lengkap</td>
<td class="form-row">
<input name="nama_lengkap"
id="nama_lengkap" type="text" size="20" /></td>
</tr>
<tr class="form-div3">
<td class="label" width="160" >Username*</td>
<td class="form-row">
<input name="nama" id="username"
type="text" size="20" /></td>
</tr>
<tr class="form-div4">
<td class="label" width="160" >Email*</td>
<td class="form-row">
<input name="email" type="text" id="email"
size="40" /></td>
</tr>
<tr class="form-div5">
<td class="label" width="160" >Password*</td>
<td class="form-row">
<input type="password" name="pass" id="password"
size="30" />
<!--<input name="password" id="password"
size="30" type="password" /> --></td>
</tr>
<tr class="form-div6">
<td class="label" width="160" >Ulang
Password*</td>
<td class="form-row">
<input name="ulang_password"
id="ulang_password" size="30" type="password" /></td>
</tr>
<tr class="form-div7">
<td width="160">Alamat</td>
<td class="form-row">
<textarea name="alamat_pelanggan"
cols="45" rows="3"></textarea></td>
</tr>
<tr class="form-div4">
<td width="160" class="label">Propinsi</td>
<td class="form-row">
<select name="provinsi" onChange="javascript:rubah(this)">
<option value=""></option>
<?php
include "inc.koneksi.php";
$sql="select id_propinsi,nama from tbl_propinsi order
by id_propinsi";
$res=mysql_query($sql) or die(mysql_error());
while($data_prov=mysql_fetch_array($res)){
echo "<option
value=\"$data_prov[id_propinsi]\">$data_prov[nama]</option>";
}
?>
</select>
</td>
</tr>
<tr class="form-div4">
<td width="160" class="label">Kabupaten/Kota</td>
<td class="form-row">
<select id="kabkota" name="kabkota">
<option></option>
</select></td>
</tr>
<tr class="form-divk">
<td width="160" class="label">Kodepos</td>
<td class="form-row">
<input name="kodepos" type="text"
id="kodepos" size="20" maxlength="5" /></td>
</tr>
<tr class="form-div5">
<td width="160" class="label">No. Handphone</td>
<td class="form-row">
<input name="phone" type="text" size="20"
id="phone" /></td>
</tr>
<tr class="form-div5">
<td width="160" class="label">Kode Verifikasi</td>
<td class="form-row">
<img src="capcha.php?date=<?php echo date('YmdHis');?>"
alt="security image" /><br /><br />
<input type="text" name="pin" /></td>
</tr>
<tr class="form-divverifikasi">
<td colspan="2" class="form-row"><input type="checkbox"
checked="checked"/>Saya Setuju Dengan Syarat & Ketentuan.</td>
</tr>
<tr class="form-div8">
<td class="label"></td>
<td class="form-row">
<input name="submit" type="submit" id="submit" value="Daftar"
class="tomboll"/>
<input type="reset" value="Ulang" class="tomboll" /></td>
</tr>
</table>
</div>
</form>
<div class="right_content">
<?php cari(); ?>
<?php terbaru(); ?>
<?php bestseller(); ?>
<?php banyakdilihat(); ?>
</div>
</div>
</div>
</div>
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>

proses_proses_register.php
<?php
if($_POST['submit']){
$id = $_POST['idh'];
$nama_lengkap = $_POST['nama_lengkap'];
$nama = $_POST['nama'];
$email = $_POST['email'];
$pass = md5($_POST['pass']);
$ulang_password = md5($_POST['ulang_password']);
$passok = $_POST['pass'];
$alamat_pelanggan = $_POST['alamat_pelanggan'];
$id_prov = $_POST['provinsi'];
$kab_kota = $_POST['kabkota'];
$kodepos=$_POST['kodepos'];
$phone = $_POST['phone'];

include "inc.koneksi.php";
$cek=mysql_query("SELECT email \"mail\" FROM tbl_pelanggan
WHERE email='$email'");
if (mysql_num_rows($cek)==0){

$cek=mysql_query("SELECT username \"username\" FROM


tbl_pelanggan WHERE username='$nama'");
if (mysql_num_rows($cek)==0){
$sql="INSERT INTO tbl_pelanggan VALUE
('$id','$nama_lengkap','$nama','$email','$pass','$ulang_password','$pass
ok','$alamat_pelanggan','$id_prov','$kab_kota','$kodepos','$phone','Belu
m')";
$res=mysql_query($sql);

if($res){ // Jika berhasil


//$id_admin=mysql_insert_id($link);
$passnotenkrip = $_POST['pass'];
$email_admin="[email protected]";
$subject = 'Registrasi Pelanggan Elvana-Sport.com';

$header = 'From: '.$email_admin.''. "\r\n".


'X-Sender: [email protected]' . "\r\n".
'X-Mailer: PHP/' . phpversion();

$message ="Kepada Yth. Sdr/i. ".$_POST["nama_lengkap"].", \n


Terima Kasih Anda telah mendaftar sebagai member
di Elvana-Sport \n
Berikut ini adalah data login anda : \n
Username : $nama
Password : $passnotenkrip \n
Agar dapat login dan memanfaatkan berbagai
layanan yang kami tawarkan kepada Anda, Silahkan mengkonfirmasi
pendaftaran melalui alamat URL di bawah ini :\n
http://elvana-sport.com/aktifasi.php?
aktivasi=$email \n\n
Hormat Kami,
CV. Elvana
";
//mail($message,$header);
header("location:prosesregister.php?nama=$nama_lengkap");
}
}
else { // Jika gagal
$username=mysql_fetch_array($cek);
header("Location:register.php?username=gagal&username=".
$username['username']."");
$username=mysql_fetch_array($cek);
}
} else {
$mail=mysql_fetch_array($cek);
header("Location:register.php?status_email=gagal&mail=".
$mail['mail']."");
$mail=mysql_fetch_array($cek);

}
}
?>

proses_selesai_transaksi.php
<?php
session_start();
if(isset($_SESSION['login_pelanggan'])==FALSE)
{
$_SESSION['login_pelanggan']=FALSE;
}

include "inc.koneksi.php";
include "inc.librari.php";
$id_pembayaran=idauto("tbl_pembayaran","BUY");
$id_pelanggan=$_SESSION['id_pelanggan'];
$nama_lengkap=$_SESSION['nama_lengkap'];
$email=$_SESSION['email'];

//$sql = mysql_query("SELECT * FROM tbl_pesanan");


//$row=mysql_fetch_array($sql);

//$no_pesanan=$row['no_pesanan'];

$no_pesanan=$_POST['no_pesanan'];

$jenis_pengiriman=$_POST['jenis'];
$kabkota=$_POST['kabkota'];
$propinsi=$_POST['provinsi'];
$ongkos=mysql_fetch_row(mysql_query("SELECT id_ongkos,biaya FROM
tbl_ongkos WHERE id_jenis_pengiriman='$jenis_pengiriman' AND
id_kabkota=$kabkota"));
$alamat=mysql_fetch_row(mysql_query("SELECT nama ,nama_kabkota
FROM tbl_propinsi a LEFT JOIN tbl_kabkota b on a.id_propinsi =
b.id_propinsi WHERE a.id_propinsi = $propinsi AND
b.id_kabkota=$kabkota "));
$nama_penerima=$_POST['nama_penerima'];
$alamat_penerima=$_POST['alamat'].' '.$alamat[1].' '.$alamat[0].' '.
$_POST['kodepos'];
$no_telp_penerima=$_POST['mobile'];
$sql=mysql_query("UPDATE tbl_pesanan SET
id_ongkos='$ongkos[0]',
tarif_ongkos_kirim='$ongkos[1]',
nama_penerima='$nama_penerima',
alamat_penerima='$alamat_penerima',
no_telp_penerima='$no_telp_penerima'
WHERE no_pesanan='$no_pesanan'");

$jumlah_produk=$_POST['jumlah_produk'];
$total_berat=$_POST['total_berat'];
$tarif_kirim=$_POST['tarifkirim'];
$total_ongkos=$total_berat*$tarif_kirim;
$total_total_bayar=$_POST['total_bayar'];

$total_tbl_bayar=$total_total_bayar+$total_ongkos;
$sql=mysql_query("INSERT INTO tbl_pembayaran VALUES
('$id_pembayaran','$no_pesanan','0','0','0','0','0','Belum
Dibayar','$total_tbl_bayar','0','0')");

$sql=mysql_query("DELETE FROM tbl_keranjang WHERE


id_pelanggan='$id_pelanggan'");

$cek=mysql_query("SELECT ps.no_pesanan, dp.qty, dp.harga, dp.diskon,


pr.id_produk, pr.nama_produk
FROM tbl_detail_pesanan dp JOIN tbl_pesanan
ps
ON (dp.no_pesanan = ps.no_pesanan)
JOIN tbl_produk pr
ON (dp.id_produk = pr.id_produk)
WHERE ps.no_pesanan ='$no_pesanan'");
$jumlahdata=mysql_num_rows($cek);
if($jumlahdata>0){

if ($sql){
$email_admin="[email protected]";
$subject = 'Pemesanan Hadad-Sport.com';

$header= 'MIME-Version: 1.0' . "\r\n";


$header .= 'Content-type: text/html; charset=iso-8859-1' .
"\r\n";

$header .= 'From: '.$email_admin.''. "\r\n".


'X-Sender: [email protected]' . "\r\n".
'X-Mailer: PHP/' . phpversion();

$message ="Kepada Yth. Sdr/i. ".$_SESSION['nama_lengkap'].",<br> \n


Pelanggan Situs Hadad-Sport<br> \n
No. Pesanan Anda : <b>$no_pesanan</b><br><br> \n
Terima kasih atas kepercayaan anda berbelanja di situs kami.
Selanjutnya kami akan memproses pesanan anda dan akan segera kami
kirim ke alamat di bawah ini :<br><br> \n\n
<html>
<body>
<table width=400>
<tr>
<td bgcolor=#DDDDDD style=font-weight:bold; border:#ccc solid
1px;>Nama Penerima</td>
<td bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px;>$nama_penerima</td>
</tr>
<tr>
<td bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px;>Alamat Penerima</td>
<td bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px;>$alamat_penerima</td>
</tr>
<tr>
<td bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px;>Nomor Yang Bisa Dihubungi</td>
<td bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px;>$no_telp_penerima</td>
</tr>
</table><br> \n\n
";
$message .="Berikut ini kami lampirkan detail data pesanan anda :
<br><br> \n\n
<table width=70%>
<tbody>
<tr align=center>
<td width=89 bgcolor=#DDDDDD style=font-weight:bold; border:#ccc
solid 1px><b> Id Produk </b></td>
<td width=301 bgcolor=#DDDDDD style=font-weight:bold; border:#ccc
solid 1px><b> Nama Produk </b></td>
<td width=56 bgcolor=#DDDDDD style=font-weight:bold; border:#ccc
solid 1px><b> Quantity </b></td>
<td width=236 bgcolor=#DDDDDD style=font-weight:bold; border:#ccc
solid 1px><b> Harga </b></td>
</tr>";

$i=0;
while ($row = mysql_fetch_array($cek)){
$i++;
$harga=number_format($row[harga],0, ",",".");

$message .="<tbody>
<tr class= if($i%2==1) isitabelganjil; else isitabelgenap; align=center>
<td bgcolor=#DDDDDD style=font-weight:bold; border:#ccc solid
1px>$row[id_produk] </td>
<td bgcolor=#DDDDDD style=font-weight:bold; border:#ccc solid
1px>$row[nama_produk]</td>
<td bgcolor=#DDDDDD style=font-weight:bold; border:#ccc solid
1px>$row[qty]</td>
<td bgcolor=#DDDDDD style=font-weight:bold; border:#ccc solid
1px>Rp. $harga,-</td>
</tr>";
}
$message .="</tbody>
</table><br>";
$sql = mysql_query("SELECT * FROM tbl_pesanan NATURAL JOIN
tbl_pembayaran WHERE no_pesanan='$no_pesanan'");
$row = mysql_fetch_array($sql);
$tgl_dipesan = $row['tgl_dipesan'];
$tgl_expired = $row['tgl_expired'];
$total_berat_produk = $row['total_berat_produk'];
$tarif_ongkos_kirim = number_format($row['tarif_ongkos_kirim'],0,
",",".");
$total_pembayaran = number_format($row['total_pembayaran'],0,
",",".");
$total_tbl_pembayaran = number_format($row['total_tbl_pembayaran'],0,
",",".");

//$jumlah_yg_harus_dibayar = $total_pembayaran+$total_ongkos;
/* $nama_penerima = $row['nama_penerima'];
$alamat_penerima = $row['alamat_penerima'];
$no_telp_penerima = $row['no_tlpn_penerima'];
$total_pembayaran = $row['total_pembayaran'];
$ongkir = $row['tarif_ongkir'];
$totalongkos=$row['tarif_ongkir'] * $row['berat'];
$semua=$total_total_bayar+$totalongkos; */

$message .="<table width=430 border=0 bordercolorlight=#ccc>


<tr>
<td width=200 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Jumlah Pembayaran</td>
<td width=230 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Rp. $total_pembayaran,-</td>
</tr>
<tr>
<td width=200 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Total Berat</td>
<td width=230 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>$total_berat Kg</td>
</tr>
<tr>
<td width=200 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Biaya Ongkos Kirim/Kg</td>
<td width=230 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Rp. $tarif_ongkos_kirim,-</td>
</tr>
<tr>
<td width=200 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Jumlah Tarif Ongkos Kirim</td>
<td width=230 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>$total_berat Kg x Rp. $tarif_ongkos_kirim,- =
<b>Rp. $total_ongkos,-</b></td>
</tr>
<tr>
<td width=200 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Total Yang Harus Dibayar</td>
<td width=230 bgcolor=#DDDDDD style=font-weight:bold;
border:#ccc solid 1px>Rp. $total_tbl_pembayaran,-</td>
</tr>
</table><br>
Pengiriman produk akan dikirimkan jika anda sudah melakukan
pembayaran.<br><br>
<b>Cara Pembayaran :</b><br>
1. Pembayaran dilakukan terhitung sejak produk dipesan yaitu tanggal
$tgl_dipesan s/d tanggal $tgl_expired<br>
2. Pembayaran dapat dilakukan dengan dua cara, yaitu transfer antar
bank atau melalui PayPal<br>
3. Untuk pembayaran dengan cara transfer bisa melalui nomor rekening
di bawah ini :<br>
a. BNI No. Rekening 123456789<br>
b. BCA No. Rekening 123456789<br><br>
<b>Catatan :</b><br>
1. Jumlah uang yang ditransfer harus sesuai dengan total
pembayaran.<br>
2. Jika dalam jangka waktu yang telah ditentukan anda belum melakukan
pembayaran maka pesanan akan dibatalkan.<br><br>
</body>
</html>
Hormat Kami,<br>\n
CV. Hadad Sport
";

header("Location:selesai_transaksi.php?
no=$no_pesanan&jum=$jumlah_produk");
}else{
echo "Error";
}
}
?>

proses_simpan_pesanan.php
<?php
session_start();
if(isset($_SESSION['login_pelanggan'])==FALSE)
{
$_SESSION['login_pelanggan']=FALSE;
}
include "inc.koneksi.php";
include "inc.librari.php";
$no_pesanan=idauto("tbl_pesanan","OR-");
$id_pelanggan=$_SESSION['id_pelanggan'];

$count = $_REQUEST['count'];
$total_bayar = $_REQUEST['total_bayar'];
$listId = explode(";",$_REQUEST['id']);
$listQty = explode(";",$_REQUEST['qty']);
$listHarga = explode(";",$_REQUEST['harga']);
$jumlah_berat_produk = $_REQUEST['jumlah_berat_produk'];
$jumlah_produk = $_REQUEST['jumlah_produk'];
$stokOk = TRUE;

$_SESSION['nopesanan']=$no_pesanan;
for($j=0;$j<$count;$j++){
$data=mysql_fetch_row(mysql_query("SELECT stok,nama_produk
FROM tbl_produk WHERE id_produk='$listId[$j]'"));
if($data[0]<$listQty[$j]){
$stokOk = FALSE;
$errorid = $data[1];
break;
}
}

if($stokOk){
$sql=mysql_query("INSERT INTO tbl_pesanan VALUES
('$no_pesanan','$id_pelanggan',SYSDATE(),ADDDATE(SYSDATE(),3),NULL,
0,'','','','Belum Dikirim','Dipesan',$jumlah_berat_produk,$total_bayar,0)");

for($i=0;$i<$count;$i++){
$data=mysql_fetch_row(mysql_query("SELECT diskon,stok FROM
tbl_produk WHERE id_produk='$listId[$i]'"));
$sql=mysql_query("INSERT INTO tbl_detail_pesanan VALUES
('$no_pesanan','$listId[$i]',$listQty[$i],$listHarga[$i],$data[0])");
$stok_baru=$data[1]-$listQty[$i];
$sql=mysql_query("UPDATE tbl_produk SET stok=$stok_baru
WHERE id_produk='$listId[$i]'");
}
if ($sql){
header("Location:isidatatransaksi.php?
no=$no_pesanan&jum=$jumlah_produk");
}else{
echo "Error";
}
} else {
header("location:list_keranjang_belanja.php?eror=".$errorid);
}
?>

ADMIN
Index.php
<html><head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>Administrator Hadad Sport&trade; - Login</title>
<?php include("lib_func.php"); ?>
<link rel="shortcut icon" href="images/Letter-E-blue.ico">
<link rel="stylesheet" type="text/css" href="style.css">
<script type="text/javascript" src="js/boxOver.js"></script>
</head><body>
<div id="main_content">
<div class="title_box_login_atas"></div>

<div class="border_box_login">
<form action="login.php" method="post" name="login">
<div class="kolom3a">Informasi <br> Silahkan Masukan
Username dan Password</div>
<br/><br/><br/><br/><br/>
<div class="kolom1a"><p>Username</p></div>
<div class="kolom1b"><p><input name="username"
type="text" size="40" maxlength="30" tabindex="1"
class="input_text"></p></div>

<div class="kolom2a"><p>Password</p></div>
<div class="kolom2b"><p><input name="password"
type="password" size="40" maxlength="30" tabindex="2"
class="input_text"></p>
<div class="tombol">

</div><br/>
<div class="formlogintombol">
<input name="tbl_login" type="submit" value="Login"
class="formlogintombol">
<input name="tbl_reset" type="reset" value="Ulang"
class="formlogintombol">
</div>
</div>
</form>
</div>
</div>
<div class="footerindex1">
<?php footer(); ?>
</div>
<div style="position: absolute; visibility: hidden;
"><div></div></div></body>
</html>

Login.php
<?php
session_start();
/*include("lib_func.php");
$username=$_POST['username'];
$userpass=$_POST['password'];

$link=koneksi_db();
$sql="select * from tbl_admin where username='$username'
and password='$password'";
$res=mysql_query($sql,$link);
if(mysql_num_rows($res)==1){//Jika username dan password
benar
$data=mysql_fetch_array($res); //Ambildata user
daridatabase
$_SESSION['id_admin']=$data['id_admin'];
$_SESSION['nama_lengkap']=$data['nama_lengkap'];
$_SESSION['username']=$data['username'];//Isivariableusername
$_SESSION['email']=$data['email'];

$_SESSION['password']=$data['password'];//Isivariablenama

$_SESSION['level_admin']=$data['level_admin'];//Isivariablelevel

$_SESSION['sudahlogin']=true;//Variableststussudahlogin
header("Location:halamanmenu.php");
}
else {
header("Location:logingagal.php");//Pindah ke halaman
logingagal.php
} */
//session_start();

include "inc.koneksi.php";

/*if (!isset($username) || !isset($password)) {


?>
<script language='javascript'>alert('Anda Belum
Login');document.location='logingagal.php'</script>
<?php
}
else if (empty($username) || empty($password)){
?>
<script language="JavaScript">alert('Username atau password
Belum Diisi'); document.location='logingagal.php'</script>
<?php
}
else */if(isset($_POST['tbl_login'])){
$username=$_POST['username'];
$password=md5($_POST['password']);

$sql="SELECT * FROM tbl_admin WHERE


username='$username' AND password='$password'";
$result=mysql_query($sql);
if ($result){
if(mysql_num_rows($result)==1){
$data=mysql_fetch_array($result);
$_SESSION['id_admin']=$data['id_admin'];
$_SESSION['username']=$data['username'];
$_SESSION['password']=$data['password'];
$_SESSION['nama_lengkap']=$data['nama_lengkap'];
$_SESSION['level_admin']=$data['level_admin'];
header("Location:halaman_admin.php");
}
else{
header("Location:logingagal.php?");
}
}
}
/*$num = mysql_num_rows($result);
if($num>=1) {
$_SESSION['username']=$username;
$_SESSION['password']=$password;
$_SESSION['level']=$datauser['level'];
header("Location:halamanmenu.php");
}
else
{
header("Location:logingagal.php");
}
}*/
?>

halaman_admin.php
<?php
session_start();
//periksa apakah user telah login atau memiliki session
if(!isset($_SESSION['username']) || !
isset($_SESSION['password']) || !isset($_SESSION['nama_lengkap']))
{
header( 'Location:index.php');
}
else
{
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" />
<title>Administrator Hadad Sport&trade;</title>
<?php include("lib_func.php"); ?>
<link rel="shortcut icon" href="images/Letter-E-blue.ico" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="drop-down.js"></script>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<script>
var timerID = null;
var timerRunning = false;
var months=new Array(13);
months[1]="Jan";
months[2]="Feb";
months[3]="Mar";
months[4]="Apr";
months[5]="May";
months[6]="Jun";
months[7]="Jul";
months[8]="Aug";
months[9]="Sep";
months[10]="Oct";
months[11]="Nov";
months[12]="Dec";
function stopclock(){
if(timerRunning)
clearTimeout(timerID);
timerRunning=false;
}
function startclock() {
xnow = new Date('Apr 7, 2012 11:05:29');
stopclock();
showtime();
}
function showtime() {
xnow.setSeconds(xnow.getSeconds()+1);
var lmonth=(((xnow.getMonth()+1) < 10) ? "0" : "") +
(xnow.getMonth()+1);
var date=((xnow.getDate() < 10) ? "0" : "") + xnow.getDate();
var year=xnow.getYear();
if (year<2000) year=year+1900
var hour=((xnow.getHours() < 10) ? "0" : "") + xnow.getHours();
var min=((xnow.getMinutes() < 10) ? "0" : "") +
xnow.getMinutes();
var sec=((xnow.getSeconds() < 10) ? "0" : "") +
xnow.getSeconds();
DateTime.innerHTML = "" + date + "/" + lmonth + "/" + year + "
- " + hour + ":" + min + ":" + sec;
timerID = setTimeout("showtime()",900);
timerRunning = true;
}
var ms = 0;
function fncSetTimer() {
ms = 0;
then = new Date();
then.setTime(then.getTime() - ms);
}
function fncTimer() {
setTimeout("fncTimer();", 10000);
ynow = new Date();
ms = ynow.getTime() - then.getTime();
if (ms>=480000) {
fncSetTimer();
fncLogoff();
}
window.status=parseInt(ms/1000) + " seconds idle";
}
function fncLogoff() {
document.iBankForm.action = "sessionexpired.htm";
document.iBankForm.submit();
}
</script>
<body onload="startclock();fncSetTimer();fncTimer();">
<div id="header">
<div id="logo">
</div>
</div>
<div id="header2"></div>
<div id="main_container">

<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div id="main_content">
<?php menu_atas() ?>
</div>
</div>
<div class="center_content">
<div class="namamenucenter"><MARQUEE scrollAmount=4
scrollDelay=2>
<B><font size="4" color="#1303dd">.:: Selamat datang,
<blink><u><?php echo ucfirst($_SESSION['username']); ?
></u></blink> dihalaman administrator Hadad Sport, waktu
Login :</font> <font id="DateTime" face="verdana"
size="3"></font> ::.</B>
</MARQUEE></div>
<div class="product_img_big">
<p><img src="images/businessman_woman.gif"
border="0"></p>
<p>Welcome, <b><?php echo ucfirst($_SESSION['username']); ?
></p></b>
</div>
<div class="details_big_box">
<div class="prod_price_big1"><p align="justify">Halaman ini
digunakan oleh Admin untuk melakukan pengaturan dan kegiatan
pengelolaan barang. Halaman ini dilengkapi dengan fasilitas-
faslitas seperti:<br><br/>
1. Pengelolaan barang-barang seperti tambah barang, edit barang
dan hapus barang.<br>
2. Pengelolaan barang berdasarkan Kategori, Merk dan
Produk.<br>
3. Lihat seluruh data barang berdasarkan Kategori, Merk dan
Produk.<br>
4. Cetak laporan orderan dan produk masuk berdasarkan tanggal,
bulan dan tahun.<br>
5. Situs masih dalam tahap pengembangan untuk keperluan
Skripsi. <a
href='halaman_cover.php'><i>About</i></a></p></div>
</div>
</div>
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>
<?php } ?>

laporan_produk_pdf.php
<?php
session_start();
//periksa apakah user telah login atau memiliki session
if(!isset($_SESSION['username']) || !
isset($_SESSION['password'])) {

header( 'Location:index.php');
}
else
{

include "class.ezpdf.php";
include "inc.koneksi.php";
include "rupiah.php";

$pdf = new Cezpdf('A4','landscape');

// Set margin dan font


$pdf->ezSetCmMargins(3, 3, 3, 3);
$pdf->selectFont('fonts/Courier.afm');

$all = $pdf->openObject();

// Tampilkan logo
$pdf->setStrokeColor(0, 0, 0, 1);
$pdf->addJpegFromFile('images/logo.jpg',30,535,140);

// Teks di tengah atas untuk judul header


$pdf->addText(325, 570, 12,'<b>Laporan Persedian Produk</b>');
$pdf->addText(309, 553, 21,'<b>Toko Hadad Sport</b>');
$pdf->addText(338, 538, 12,'<b>http://hadadsport.com</b>');
// Garis atas untuk header
$pdf->line(10, 529, 832, 529);

// Garis bawah untuk footer


$pdf->line(10, 50, 832, 50);
// Teks kiri bawah
$pdf->addText(30,34,8,'Dicetak tgl:' . date( 'd-m-Y, H:i:s'));
$pdf-
>addText(30,26,8,'http://hadadsport.com/produk/cetak'.date('d/m/y
') );

$pdf->closeObject();

// Tampilkan object di semua halaman


$pdf->addObject($all, 'all');

// Baca input tanggal yang dikirimkan user


$mulai=$_POST[thn_mulai].'-'.$_POST[bln_mulai].'-'.
$_POST[tgl_mulai];
$selesai=$_POST[thn_selesai].'-'.$_POST[bln_selesai].'-'.
$_POST[tgl_selesai];
$pencetak = $_POST['pencetak'];

// Query untuk merelasikan kedua tabel di filter berdasarkan


tanggal
$sql = mysql_query("select
tbl_produk.nama_produk,tbl_produk.id_produk as faktur,
DATE_FORMAT(tgl_diinputkan, '%d-
%m-%Y') as tanggal,
tbl_kategori.nama_kategori,
tbl_subkategori.nama_subkategori,
tbl_produk.stok, tbl_produk.harga,
tbl_produk.deskripsi
FROM tbl_produk, tbl_kategori,
tbl_subkategori
WHERE
(tbl_kategori.id_kategori=tbl_produk.id_kategori)
AND
(tbl_subkategori.id_subkategori=tbl_produk.id_subkategori)
AND (tbl_produk.tgl_diinputkan
BETWEEN '$mulai' AND '$selesai')");
$jml = mysql_num_rows($sql);

if ($jml > 0){


$i = 1;
while($r = mysql_fetch_array($sql)){
$faktur=$r[faktur];
$hargarp=rp($r[harga]);
$stok_keseluruhan= $stok_keseluruhan + $r[stok];

$data[$i]=array('<b>No.</b>'=>$i,
'<b>Id Produk</b>'=>$faktur,
'<b>Tanggal</b>'=>$r[tanggal],

'<b>Nama
Produk</b>'=>$r[nama_produk],
'<b>Kategori</b>'=>$r[nama_kategori],
'<b>Subkategori</b>'=>$r[nama_subkategori],
'<b>Stok</b>'=>$r[stok],
'<b>Harga</b>'=>$hargarp,
'<b>Deskripsi</b>'=>$r[deskripsi]);
$i++;
}
$pdf->ezTable($data, '', '', '');

$pdf->ezText("\nJumlah Kategori Produk : <b>{$jml}</b>


kategori");
$pdf->ezText("Jumlah Persedian Stok Produk keseluruhan :
<b>{$stok_keseluruhan}</b> unit");
$pdf->ezText("\nDicetak oleh : {$pencetak}");

// Penomoran halaman
$pdf->ezStartPageNumbers(430, 15, 8);
$pdf->ezStream();
}
else{
$m=$_POST[tgl_mulai].'-'.$_POST[bln_mulai].'-'.
$_POST[thn_mulai];
$s=$_POST[tgl_selesai].'-'.$_POST[bln_selesai].'-'.
$_POST[thn_selesai];
$pencetak1 = $_POST['pencetak'];
echo"<link rel='stylesheet' type='text/css' href='style.css' />";
echo "<br/><br/><br/><br/><div class=cetak_kosong>Maaf
<u>{$pencetak1}</u>, Sistem tidak menemukan produk yang
masuk pada Tanggal <b>$m</b> s/d <b>$s</b></div>";
}}?>

laporan_semua_pesanan_pdf.php
<?php
session_start();
//periksa apakah user telah login atau memiliki session
if(!isset($_SESSION['username']) || !
isset($_SESSION['password'])) {

header( 'Location:index.php');
}
else
{

include "class.ezpdf.php";
include "inc.koneksi.php";
include "rupiah.php";

$pdf = new Cezpdf();

// Set margin dan font


$pdf->ezSetCmMargins(3, 3, 3, 3);
$pdf->selectFont('fonts/Courier.afm');

$all = $pdf->openObject();

// Tampilkan logo
$pdf->setStrokeColor(0, 0, 0, 1);
$pdf->addJpegFromFile('images/logo.jpg',15,786,130);

// Teks di tengah atas untuk judul header


$pdf->addText(220, 820, 16,'<b>Laporan Penjualan</b>');
$pdf->addText(200, 800, 21,'<b>Toko Hadad Sport</b>');
$pdf->addText(224, 788, 12,'<b>http://hadadsport.com</b>');
// Garis atas untuk header
$pdf->line(10, 785, 578, 785);

// Garis bawah untuk footer


$pdf->line(10, 50, 578, 50);
// Teks kiri bawah
$pdf->addText(30,34,8,'Dicetak tgl:' . date( 'd-m-Y, H:i:s'));
$pdf-
>addText(30,26,8,'http://hadadsport.com/produk/cetak'.date('d/m/y
') );

$pdf->closeObject();

// Tampilkan object di semua halaman


$pdf->addObject($all, 'all');

// Baca input tanggal yang dikirimkan user


$mulai=$_POST[thn_mulai].'-'.$_POST[bln_mulai].'-'.
$_POST[tgl_mulai];
$selesai=$_POST[thn_selesai].'-'.$_POST[bln_selesai].'-'.
$_POST[tgl_selesai];
$pencetak = $_POST['pencetak'];

// Query untuk merelasikan kedua tabel di filter berdasarkan


tanggal
$sql = mysql_query("SELECT tbl_pesanan.no_pesanan as faktur,
DATE_FORMAT(tgl_dipesan, '%d-%m-%y') as tanggal,
tbl_produk.nama_produk, tbl_detail_pesanan.qty,
tbl_detail_pesanan.harga, tbl_pembayaran.status_pembayaran
FROM tbl_pesanan, tbl_produk
,tbl_detail_pesanan,tbl_pembayaran
WHERE
(tbl_detail_pesanan.id_produk=tbl_produk.id_produk)
AND
(tbl_detail_pesanan.no_pesanan=tbl_pesanan.no_pesanan)
AND
(tbl_pembayaran.no_pesanan=tbl_pesanan.no_pesanan)
AND
(tbl_pembayaran.status_pembayaran='Lunas')
AND (tbl_pesanan.tgl_dipesan
BETWEEN '$mulai' AND '$selesai') ");
$jml = mysql_num_rows($sql);

if ($jml > 0){


$i = 1;
while($r = mysql_fetch_array($sql)){
$quantityharga=rp($r[qty]*$r[harga]);
$hargarp=rp($r[harga]);
$faktur=$r[faktur];

$data[$i]=array('<b>Faktur</b>'=>$i,
'<b>No Pesanan</b>'=>$faktur,
'<b>Tanggal</b>'=>$r[tanggal],
'<b>Nama Produk</b>'=>$r[nama_produk],
'<b>Qty</b>'=>$r[qty],
'<b>Harga</b>'=>$hargarp,
'<b>Sub Total</b>'=>$quantityharga);
$total = $total+($r[qty]*$r[harga]);
$totqu = $totqu + $r[qty];
$i++;
}

$pdf->ezTable($data, '', '', '');

$tot=rp($total);
$pdf->ezText("\n\nTotal keseluruhan : <b>Rp. {$tot}</b>");
$pdf->ezText("\nJumlah yang terjual : {$jml} unit");
$pdf->ezText("Jumlah keseluruhan yg terjual: {$totqu} unit");
$pdf->ezText("\nDicetak oleh : {$pencetak}");

// Penomoran halaman
$pdf->ezStartPageNumbers(320, 15, 8);
$pdf->ezStream();
}
else{
$m=$_POST[tgl_mulai].'-'.$_POST[bln_mulai].'-'.
$_POST[thn_mulai];
$s=$_POST[tgl_selesai].'-'.$_POST[bln_selesai].'-'.
$_POST[thn_selesai];
$pencetak1 = $_POST['pencetak'];
echo"<link rel='stylesheet' type='text/css' href='style.css' />";
echo "<br/><br/><br/><br/><div class=cetak_kosong>Maaf
<u>{$pencetak1}</u>, Sistem tidak menemukan transaksi
pesanan pada Tanggal <b>$m</b> s/d <b>$s</b></div>";
}
}
?>

pembayaran.php
<?php
session_start();
//periksa apakah user telah login atau memiliki session
if(!isset($_SESSION['username']) || !
isset($_SESSION['password'])) {
header( 'Location:index.php');
}
else
{
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" />
<title>Administrator Hadad Sport&trade;</title>
<?php include("lib_func.php"); ?>
<link rel="shortcut icon" href="images/Letter-E-blue.ico" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="drop-down.js"></script>
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="stylesheet" type="text/css" href="overlay-dialog.css">
</head>
<body>
<div id="header">
</div>
<div id="header2"></div>
<div id="main_container">

<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div id="main_content">
<?php menu_atas(); ?>
</div>
</div>

<div class="center_content">
<div class="namamenucenter">LIST DATA PEMBAYARAN</div>
<div class="specifications">
<?php
include "inc.koneksi.php";
$sqlCount = "SELECT * FROM tbl_pembayaran";
$rsCount =
mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 8;
$mulai_dari = $limit * ($page - 1);

$sql = mysql_query
("SELECT * FROM tbl_pembarayan;
$jumlahdata=mysql_num_rows($sql);
if($jumlahdata>0){
?>
<table width="760" border="0" align="center">
<tr class="tabel">
<td width="89" class="tabel">Id Pembayaran</td>
<td width="161" class="tabel">No Pesanan</td>
<td width="94" class="tabel">Atas Nama</td>
<td width="120" class="tabel">Status Pembayaran</td>
<td width="96" class="tabel">Total Pembayaran</td>
<td width="107" class="tabel">Keterangan</td>
</tr>
<td class="tabeltd"><?php echo $row['id_pembayaran']; ?
></td>
<td class="tabeltd"><?php echo $row['no_pesanan']; ?
></td>
<td class="tabeltd"><?php echo $row['atas_nama']; ?></td>
<td class="tabeltd"><?php echo
$row['status_pembayaran']; ?></td>
<td class="tabeltd"><?php echo
$row['total_tbl_pembayaran']; ?></td>
</table>
<?php
}
else {
?>
<div class="kosong">Tidak ditemukan Data Kategori !</div>
<?php
}
?>
</div>

<div class="pagination">
<?php
$banyakHalaman = ceil($banyakData / $limit);
echo '<a href="kategori_list.php?page=1"
title="header=[Halaman Awal Katalog] body=[&nbsp;]
fade=[on]"><<</a> ';

if($page > 1)
{
$previous=$page-1;
echo '<a href="kategori_list.php?page='.$previous.'"
title="header=[Mundur Satu Halaman] body=[&nbsp;]
fade=[on]"><</a> ';
}else{
echo "<span class='disabled'><</span> ";
}

for($i = 1; $i <= $banyakHalaman; $i++){


if($page != $i){
echo '<a href="kategori_list.php?page='.$i.'"
title="header=[Halaman '.$i.'] body=[&nbsp;] fade=[on]">'.
$i.'</a> ';
}else{
echo "<span class='current'>$i</span> ";
}
}

if($page < $banyakHalaman)


{
$next=$page+1;
echo '<a href="kategori_list.php?page='.$next.'"
title="header=[Maju Satu Halaman] body=[&nbsp;]
fade=[on]">></a> ';
}else{
echo "<span class='disabled'>></span> ";
}

if($page < $banyakHalaman)


{
$next=$page+1;
echo '<a href="kategori_list.php?page='.
$banyakHalaman.'" title="header=[Halaman Akhir Katalog]
body=[&nbsp;] fade=[on]">>></a> ';
}else{
echo "<span class='disabled'>>></span> ";
}
?>
</div>
</div>
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>
<?php
}
?>

pesanan_detail.php
<?php
session_start();
//periksa apakah user telah login atau memiliki session
if(!isset($_SESSION['username']) || !
isset($_SESSION['password'])) {
header( 'Location:index.php');
}
else
{
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" />
<title>Administrator Hadad Sport&trade;</title>
<?php include("lib_func.php"); ?>
<?php
setlocale(LC_ALL, 'id_ID.UTF8', 'id_ID.UTF-8', 'id_ID.8859-1', 'id_ID',
'IND.UTF8', 'IND.UTF-8', 'IND.8859-1', 'IND', 'Indonesian.UTF8',
'Indonesian.UTF-8', 'Indonesian.8859-1', 'Indonesian', 'Indonesia',
'id', 'ID', 'en_US.UTF8', 'en_US.UTF-8', 'en_US.8859-1', 'en_US',
'American', 'ENG', 'English');
?>
<link rel="shortcut icon" href="images/Letter-E-blue.ico" />
<script type="text/javascript" src="js/boxOver.js"></script>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="drop-down.js"></script>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript"
src="jsjumimage/jquery.tools.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("img[rel]").overlay();
});
</script>
</head>
<body>
<div id="header">
</div>
<div id="header2"></div>
<div id="main_container">

<div align="right">

<div id="container">
<div id="topnav" class="topnav"></div>
</div>
</div>
<div id="main_content">
<?php menu_atas(); ?>
</div>
</div>
<div class="center_content">
<?php
if(! $_GET['detail_pesanan']==""){
include "inc.librari.php";

include "inc.koneksi.php";

$sql = mysql_query("SELECT ps.no_pesanan, ps.tgl_dipesan,


ps.tgl_expired, ps.id_ongkos, ps.tarif_ongkos_kirim,
ps.nama_penerima, ps.alamat_penerima, ps.no_telp_penerima,
ps.status_pengiriman, ps.status_pesanan, ps.total_pembayaran,
ps.no_resi, pl.id_pelanggan, pl.nama_lengkap,
pm.status_pembayaran
FROM tbl_pesanan ps JOIN tbl_detail_pesanan dp
ON ( ps.no_pesanan = dp.no_pesanan )
JOIN tbl_pelanggan pl
ON ( ps.id_pelanggan = pl.id_pelanggan )
JOIN tbl_pembayaran pm
ON (ps.no_pesanan = pm.no_pesanan)
WHERE ps.no_pesanan ='".$_GET['detail_pesanan']."'");
$row = mysql_fetch_array($sql);

$no_pesanan=$row['no_pesanan'];
$id_pelanggan = $row['id_pelanggan'];
$nama_pelanggan=$row['nama_lengkap'];
$tgl_dipesan=$row['tgl_dipesan'];
$tgl_expired=$row['tgl_expired'];
$id_ongkos=$row['id_ongkos'];
$tarif_ongkos_kirim=$row['tarif_ongkos_kirim'];
$nama_penerima=$row['nama_penerima'];
$alamat_penerima=$row['alamat_penerima'];
$no_telp_penerima=$row['no_telp_penerima'];
$status_pengiriman=$row['status_pengiriman'];
$status_pesanan=$row['status_pesanan'];
$total_pembayaran=$row['total_pembayaran'];
$no_resi=$row['no_resi'];
$status_pembayaran=$row['status_pembayaran'];
$total_bayar = $total_pembayaran + $tarif_ongkos_kirim;
/* $id_produk=$row['id_produk'];
$qty=$row['qty'];
$harga=$row['harga'];
$diskon=$row['diskon']; */
}
?>
<a href="pesanan_list.php" class="kembalitombol
icon"><span>Kembali</span></a>
<div class="namamenucenter">DETAIL PESANAN NOMOR : <?php
echo "$no_pesanan"; ?></div>
<div class="nonlistdata">
<table width="619" align="center">
<tr class="tabel">
<td width="195" class="tabeltd1">Nama Pelanggan</td>
<td width="205" class="tabeltd1"><span class="blue2"><?php
echo "$nama_pelanggan"; ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd2">Tanggal Dipesan</td>
<td class="tabeltd2"><span class="blue2"><?php echo
strftime('%d-%B-%Y',strtotime($tgl_dipesan)); ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd1">Tanggal Expired Pesanan</td>
<td class="tabeltd1"><span class="blue2"><?php echo
strftime('%d-%B-%Y',strtotime($tgl_expired)); ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd2">Nama Penerima</td>
<td class="tabeltd2"><span class="blue2"><?php echo
"$nama_penerima"; ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd1">Alamat Penerima</td>
<td class="tabeltd1"><span class="blue2"><?php echo
"$alamat_penerima"; ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd2">Nomor Telepon Penerima</td>
<td class="tabeltd2"><span class="blue2"><?php echo
"$no_telp_penerima"; ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd1">Status Pembayaran</td>
<td class="tabeltd1"><span class="blue2"><?php echo
"$status_pembayaran"; ?></span></td>
</tr>
<tr class="tabel">
<td class="tabeltd2">Harga Produk</td>
<td class="tabeltd2"><span class="blue2">Rp. <?php echo
number_format($row['total_pembayaran'],0, ",","."); ?>,-
</span></td>
</tr>
<tr class="tabel">
<td class="tabeltd1">Biaya Ongkos Kirim</td>
<td class="tabeltd1"><span class="blue2">Rp. <?php echo
number_format($row['tarif_ongkos_kirim'],0, ",","."); ?>,-
</span></td>
</tr>
</table>
<div class="namamenucenter">DETAIL PRODUK PESANAN NOMOR
: <?php echo "$no_pesanan"; ?></div>
<?php
$sql = mysql_query("SELECT
ps.no_pesanan, dp.id_produk,
dp.qty, dp.harga, dp.diskon, pr.id_produk, pr.nama_produk

FROM tbl_detail_pesanan dp JOIN


tbl_pesanan ps
ON ( dp.no_pesanan =
ps.no_pesanan )
JOIN tbl_produk pr
ON (dp.id_produk = pr.id_produk)
WHERE ps.no_pesanan ='".
$_GET['detail_pesanan']."'");
$jumlahdata=mysql_num_rows($sql);
if($jumlahdata>0){
?>
<table width="700" border="0" align="center">
<tr class="tabel">
<td width="89" class="tabel">Id Produk</td>
<td width="301" class="tabel">Nama Produk</td>
<td width="56" class="tabel">Quantity</td>
<td width="236" class="tabel">Harga</td>
</tr>
<?php
$i=0;
while ($row = mysql_fetch_array($sql)){
$i++;
?>
<tr class="<?php if($i%2==1)echo "isitabelganjil"; else
echo"isitabelgenap";?>">
<td class="tabeltd" align="center"><?php echo
$row['id_produk']; ?></td>
<td class="tabeltd" align="center"><?php echo
$row['nama_produk']; ?></td>
<td class="tabeltd"><?php echo $row['qty']; ?></td>
<td class="tabeltd">Rp. <?php echo
number_format($row['harga'],0, ",","."); ?>,-</td>
</tr>
<?php
}
?>
</table>
<?php
}
else {
?>
<div class="kosong">Detail Pesanan Kosong !</div>
<?php
}
?>
</div>
</div>
<div class="footer">
<?php footer(); ?>
</div>
</body>
</html>
<?php
}
?>

You might also like