PHP MySQL Ecommerce Web Design Part 11

Postingan saya kali ini adalah membuat halaman clothing_konfirmasiP.php beserta file-file pendukungnya.

1.    Buat file .PHP dengan nama clothing_konfirmasiP.php di D:\TUTOR WEB\RIANKLIK\
Buka Notepad++, pilih File, klik Open, cari file clothing_konfirmasiP.php di D:\TUTOR WEB\RIANKLIK\. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<?php
session_start(); //start session first thing in script
// Connect to the mySQL database
include "phpScripts/connect_to_mysql.php";
if (isset($_SESSION['manager'])){
    $manager_name=($_SESSION['manager']);
    $custsql=mysql_query("SELECT*FROM customer
    WHERE customer_name='$manager_name' ")
    or die(mysql_error());
    while($row = mysql_fetch_array($custsql)){
        $c_id=$row['c_id'];
    }
} // closing if ...
include "captcha_global.php";
/////////// dropdown bank name//////////////////////////////
$bank_list = mysql_query("SELECT DISTINCT bank_name
FROM bankAccount ORDER BY bank_name ASC");
$bank_name = array();
while($row = mysql_fetch_row($bank_list)){
    $bank_name[] = $row[0];   
}
?>   
<?php
// Error Reporting
error_reporting(E_ALL);
ini_set('display_errors','1');
?>
<?php
if(isset($_POST['konfirmasiP'])){
    $order_number1=mysql_real_escape_string($_POST['order_number1']);
    $order_number2=mysql_real_escape_string($_POST['order_number2']);
    $order_number3=mysql_real_escape_string($_POST['order_number3']);
    $bank_to=mysql_real_escape_string($_POST['bank_to']);
    $bank_from=mysql_real_escape_string($_POST['bank_from']);
    $atas_nama=mysql_real_escape_string($_POST['atas_nama']);
    $nominalT=mysql_real_escape_string($_POST['nominalT']);
    $dateT=mysql_real_escape_string($_POST['dateT']);
   
    $status0="ORDER";
           
    $sqlCO=mysql_query("SELECT * FROM clothingOrders
    WHERE or_id='$order_number3' AND c_id='$c_id' LIMIT 1");
    $productMatch=mysql_num_rows($sqlCO); // Count the output amount
    if($productMatch > 0){
        while($row=mysql_fetch_array($sqlCO)){
            $order_d=$row["order_detail"];
                $_SESSION["order_d"]=unserialize($row["order_detail"]);
            $shipPrice=$row["shipPrice"];
            $date_added=strftime("%b %d, %y", strtotime($row["date_added"]));
            $status=$row["status"];
            include_once("admin/clothing_if_order_d_printout.php");
                       
            ////// dipakai hanya untuk kombinasi nomor pesanan ///////
            @$qtySum=$i_qty1+$i_qty2+$i_qty3+$i_qty4+$i_qty5;
            //////////////////////////////////////////////////////////
            @$cartTotal=$total_price1+$total_price2+$total_price3+$total_price4+
            $total_price5;
            $cartTotalF=number_format($cartTotal,0,',','.');
            $shipPriceF=number_format($shipPrice,0,',','.');
            @$totalBuy=$cartTotal+$shipPrice;
            $totalBuyF=number_format($totalBuy,0,',','.');         
        } // closing while loop
       
    //////////////////END  untuk mengetahui jumlah $totalBuy///////////////////       
        $sqlCheckP=mysql_query("SELECT kp_id FROM clothingKonfirmasiP
        WHERE order_number1='$order_number1' AND order_number2='$order_number2'
        AND order_number3='$order_number3' LIMIT 1");
       
        $konfirmasiMatch=mysql_num_rows($sqlCheckP);
        // Count the output amount
        if($konfirmasiMatch > 0){
            echo 'Maaf Nomor Pesanan yang anda masukkan sudah dikonfirmasi sebelumnya,
            <a href="clothing_konfirmasiP.php">click here</a>';
            exit();   
        }else{
            //jika $totalBuy == $nominalT sama atau lebih maka
            // masukkan data ke tabel konfirmasiP dan
            // update status di tabel orders dari ORDER ke PAID
            if ($order_number1==$cartTotal && $order_number2==$qtySum && $nominalT>=$totalBuy){
                // Add this into the database now
                $sqlkonfirmasi=mysql_query("INSERT INTO clothingKonfirmasiP
                (order_number1, order_number2, order_number3, bank_to, bank_from,
                atas_nama, nominalT, dateT, date_added)
                VALUES ('$order_number1', '$order_number2', '$order_number3',
                '$bank_to', '$bank_from', '$atas_nama','$nominalT','$dateT',now())")
                or die (mysql_error());
                if ($status0===$status){
                    $updateQuery = mysql_query ("UPDATE clothingOrders
                    SET status = 'PAID' WHERE or_id = '$order_number3'")
                    or die (mysql_error());
                }
            }else{
                echo 'Maaf Nomor Pesanan salah atau Nominal Transfer yang anda masukkan terlalu kecil/kurang,
                <a href="clothing_konfirmasiP.php">click here</a>';
                exit();   
            } //closing  if ...
        } // closing if ...
    }else{
        echo 'Maaf Nomor Pesanan yang anda masukkan salah/tidak ada,
        <a href="konfirmasiP.php">click here</a>';
        exit();   
    } // closing if($konfirmasiMatch > 0)
   
    header("location:index.php"); // Avoid re-adding item when refreshing the page
    exit();
} // closing if ...
?>
<!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=utf-8" />
<title>Konfirmasi Pembayaran Pakaian</title>
<!---------------------- LINK -------------------------->
    <?php include_once("template_links_head.php"); ?>
<!---------------------- END of LINK -------------------------->
<link href="js/smoothness/jquery-ui.min.css" rel="stylesheet" type="text/css" />

<!--- Validating customerRegForm --->
    <?php include_once("validasi_konfirmasiP.php"); ?>
<!--- END Validating billingForm --->
</head>
<body>
<div id="wrapper">
    <div id="content_k">
        <!------------------- CAPTCHA ------------------------->
        <?php
        if (isset ($_POST['valid'])){
            $error_count =0;
            $error_message = array();
            $validate = trim(strtolower($_POST['validate']));
           
            if ($validate != get_answer() ) {
                $error_count++;
                $error_message['validate'] = "Jawaban salah!";   
            }
            //echo $error_count;
            if ($error_count >0 ) {
            ?>
                <form
                id="validateRegForm" name="validateRegForm" method="post" 
                style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                <!--- jika jawaban salah --->
                <center><h2>Jawab dengan benar!</h2></center>
               
                <div align="center" style="background-color:#CF9;
                padding-top:10px; padding-bottom:10px;">
                    <span style="color:blue; font-size:24px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif">
                    <?php create_question ()?>
                    </span>
                    <br />
                    <?php if (isset ($error_message ['validate'])): ?>
                    <span style="color:red; font-size:12px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif">
                    <?php echo $error_message['validate'];?>
                   
                    <?php endif; ?>
                                   
                    <span
                    style="color:green; font-size:12px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif">
                    Jawab lagi pertanyaan
                    </span>
                             
                    <input
                    name="validate" type="text" id="validate" size="15" placeholder="Validate" 
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                                                          
                    <input
                    type="submit" name="valid" id="valid" value="Validate" style="font-size:15px;
                    font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                </div>
                </form>
                   
            <?php
            }else
                echo
                '<div style="background-color:#CF9;"><h3>'
                ."Jawaban anda benar!".
                '</h3></div>';
        }else{
        ?>
            <form id="validateRegForm" name="validateRegForm" method="post" 
            style="font-size:15px; font-family:'Trebuchet MS',
            Arial, Helvetica, sans-serif">
                  
            <center><h2>Validasi</h2></center>
            <div align="center" style="background-color:#CF9; padding-top:10px;
            padding-bottom:10px">
                <span style="color:blue; font-size:24px; font-family:'Trebuchet MS',
                Arial, Helvetica, sans-serif">
                <?php create_question ()?>
                </span>
                <br />
                <input name="validate" type="text" id="validate" size="15" placeholder="Validate" 
                style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                                     
                <input type="submit" name="valid" id="valid" value="Validate"
                style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
            </div>
            </form>
        <?php
        } // closing if ...   
        ?>
                      
        <!------------------------------ END CAPTCHA ------------------------------------>
        <?php
        // form registrasi tersembunyi, captcha terlihat
        // jika ada $_POST['valid'], tidak ada pesan error dan jawaban validasi benar maka:
        // tampilkan form registrasi   
        if (isset ($_POST['valid'])){      
            if (!isset ($error_message ['validate'])){        
                if ($validate = get_answer()){   
        ?>
                     <form id="konfirmasiPForm" name="konfirmasiPForm" method="post"
                    action="clothing_konfirmasiP.php" enctype="multipart/form-data"
                    style="font-size:15px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif">
                   
                    <h2>KONFIRMASI PEMBAYARAN PAKAIAN</h2>
                   
                    Nomor Pesanan:
                    <br />
                    <input name="order_number1" type="text" id="order_number" size="12"
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif"/>
                    -
                    <input name="order_number2" type="text" id="order_number" size="12"
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif"/>
                    -
                    <input name="order_number3" type="text" id="order_number" size="12"
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif"/>
                   
                    <br />
                    <br />
                   
                    Pesanan Atas Nama:
                    <br />
                    <input name="bill_name" type="text" id="bill_name" disabled="disabled" size="35"
                    value="<?php if (!empty($_SESSION["manager"])){
                      echo "$manager_name";
                    } else{
                      echo "";
                    } ?>"
                   
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                    <br />
                    <br />
                   
                    Bank Tujuan:
                    <br />
                    <?php  // dropdown bank from data base
                    if(count($bank_name) <= 0){
                       echo 'No results have been found.';
                    } else { 
                        echo '<select name="bank_to" id="bank_to" style="font-size:15px; width: 130px;
                        font-family:Trebuchet MS, Arial, Helvetica, sans-serif">';
                        foreach($bank_name as $bank_name)
                        echo "<option style='font-size:15px; font-family:Trebuchet MS,
                        Arial, Helvetica, sans-serif'>
                        $bank_name
                        </option>";
                        echo '</select>';
                    }
                    ?>
                    <br />
                    <br />
                     
                    Bank Anda:
                    <br />
                    <span style="font-size:13px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif; color:blue">
                    Jika setoran tunai, isi dengan nama Bank sesuai dengan form setoran tunai anda
                    </span>
                    <br />
                    <input name="bank_from" type="text" id="bank_from" size="35" placeholder="Bank Anda"
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                    <br />
                    <br />
                    Rekening/Setoran Atas Nama:
                    <br />
                    <span style="font-size:13px; font-family:'Trebuchet MS', Arial, Helvetica,
                    sans-serif; color:blue">
                    Jika setoran tunai, isi dengan atas nama yang ada di form setoran tunai anda
                    </span>
                    <br />
                    <input name="atas_nama" type="text" id="atas_nama" placeholder="Rekening/Setoran Atas Nama"
                    size="35" style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                    <br />
                    <br />
                    Nominal Transfer:
                    <br />
                    <span style="font-size:13px; font-family:'Trebuchet MS', Arial, Helvetica,
                    sans-serif; color:blue">
                    Jumlah nominal harus lebih dari atau sama dengan jumlah total pesanan
                    </span>
                    <br />
                    Rp. &nbsp;
                    <input name="nominalT" type="text" id="nominalT" placeholder="Nominal Transfer"
                    size="30" style="font-size:15px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif" />
                    <br />
                    <br />
                    Tanggal Transfer:
                    <br />
                    <input name="dateT" type="text" id="datepicker" size="25" style="font-size:15px;
                    font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" />
                    <br />
                    <br />
                    <input type="submit" name="konfirmasiP" id="button" value="Konfirmasi Pembayaran"
                    style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif"
                    onclick="javascript:return validatekonfirmasiPForm();" />
                     
                    </form>
        <?php
                } // closing if ...
            } // closing if ...
        } // closing if ...
        ?>   
    </div><!--- END content_k --->
</div><!--- END Wrapper --->
<?php include_once("template_js_body.php"); ?>
</body>
</html>
2.    Buat file .PHP dengan nama customer_clothingOrder_list.php di D:\TUTOR WEB\RIANKLIK\
Buka Notepad++, pilih File, klik Open, cari file customer_clothingOrder_list.php di D:\TUTOR WEB\RIANKLIK\. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<?php
session_start();
// Connect to the mySQL database
include "phpScripts/connect_to_mysql.php";
       
// Error Reporting
error_reporting(E_ALL);
ini_set('display_errors','1');
include_once("customer_COL_orderby.php");
?>   
<?php
// This block grabs the whole list for viewing
$order_list=""; 
$sql=mysql_query("SELECT clothingOrders.or_id, customer.customer_name,
clothingOrders.date_added, clothingOrders.status, clothingOrders.date_shipped
FROM clothingOrders INNER JOIN customer ON clothingOrders.c_id=customer.c_id
");
include_once("template_page.php");
if(isset($_GET['cid'])){
    $targetID=$_SESSION['c_id'];
    $sql2=mysql_query("SELECT clothingOrders.or_id, customer.customer_name,
    clothingOrders.date_added, clothingOrders.status, clothingOrders.date_shipped
    FROM clothingOrders INNER JOIN customer ON clothingOrders.c_id=customer.c_id
    AND customer.c_id = '$targetID'");
}else{
    $sql2=mysql_query("SELECT clothingOrders.or_id, customer.customer_name,
    clothingOrders.date_added, clothingOrders.status, clothingOrders.date_shipped
    FROM clothingOrders INNER JOIN customer ON clothingOrders.c_id=customer.c_id
    $orderby_query $limit");   
}
include_once("template_page2.php");
if (!empty($sql2)){    // tambahan untuk hilangkan error saat tabel products kosong
    $orderCount=mysql_num_rows($sql2); // count the output amount
    if($orderCount>0){
        while($row=mysql_fetch_array($sql2)){
            $or_id=$row["or_id"];
            $bill_name=$row["customer_name"];
            $date_added=strftime("%d-%m-%Y", strtotime($row["date_added"]));
            $status=$row["status"];
            $date_shipped=strftime("%d-%m-%Y", strtotime($row["date_shipped"]));
                   
            $order_list.='<div id="orderlist2">';
                         
            $order_list.='<div id="orderlist_A1">
                        '.$or_id.'
                        </div>';
            $order_list.='<div id="orderlist_B1">
                        '.$bill_name.'
                        </div>';
            $order_list.='<div id="orderlist_C1">
                        '.$date_added.'
                        </div>';
            $order_list.='<div id="orderlist_D1">
                        '.$status.'
                        </div>';
            $order_list.='<div id="orderlist_E1">
                        '.$date_shipped.'
                        </div>';
            $order_list.="<div id='orderlist_F1'>
                <a href='customer_clothingPrintout.php?pid=$or_id'><button>View</button></a>
                <a href='customer_konfirmasiA.php?pid=$or_id'><button>Accepted</button></a>
                        </div>";
                         
            $order_list.='</div>';   
               
        }   
    }else{
        $order_list="You have no customer order listed";   
    }
} else{//END tambahan untuk hilangkan error saat products table kosong
    $order_list="You have no customer order listed";   
} //END tambahan untuk hilangkan error saat products table kosong
// After done scripting close any mysql connection
mysql_close();
?>
<!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=utf-8" />
<title>Clothing Order List</title>
<!---------------------- LINK -------------------------->
       <?php include_once("template_links_head.php"); ?>
<!--------------- END of LINK -------------------------->
<!---------------- LINK FREE BEAVER SLIDER ------------------>
    <?php include_once("template_js_beaverSlider_slideshow.php"); ?>
<!--------------  END of LINK FREE BEAVER SLIDER ----------------->
</head>
<body>
<div id="wrapper">
    <div id="contentOrder" style="font-size:14px; font-family:'Trebuchet MS',
    Arial, Helvetica, sans-serif">
        <div id="pagNumTopOL" align="left" style="font-family:'Trebuchet MS',
        Arial, Helvetica, sans-serif; font-size:14px">
            &nbsp;&nbsp;
            <?php include_once("customer_COL_orderbyForm.php"); ?>
       
        &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
         &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
       
            <?php echo $paginationDisplay; ?>
        </div> <!--- END pagNum --->
        <br />
        <br />
   
        <center><h2>ORDER LIST PAKAIAN</h2></center>
   
        <a href="index.php" style="text-decoration:none"><input name="home" type="button"
        value="<- Home" style="font-size:15px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif" /></a>
        <br />
        <br />
       
        <div id="orderlist" style="font-size:13px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
            <div id="orderlist_A">
            ID
            </div>
          
            <div id="orderlist_B">
            Customer Name
            </div>
          
            <div id="orderlist_C">
            Date Added
            </div>
          
            <div id="orderlist_D">
            Status
            </div>
          
            <div id="orderlist_E">
            Date Shipped
            </div>
          
            <div id="orderlist_F">
            View/Shipped/Delete
            </div>
        </div>
       
        <?php echo $order_list; ?>
   
        <br />
        <br />
     
    </div><!--- END contentOrder --->

</div><!--- END Wrapper --->
</body>
</html>
3.    Buat file .PHP dengan nama customer_clothingPrintout.php di D:\TUTOR WEB\RIANKLIK\
Buka Notepad++, pilih File, klik Open, cari file customer_clothingPrintout.php di D:\TUTOR WEB\RIANKLIK\. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<?php
session_start();
// Connect to the mySQL database
include "phpScripts/connect_to_mysql.php";
       
// Error Reporting
error_reporting(E_ALL);
ini_set('display_errors','1');
?>
<?php
if(isset($_GET['pid'])){
    $targetID=$_GET['pid'];
 
    $sqlR=mysql_query("SELECT * FROM resi WHERE or_id='$targetID'");
    while($row=mysql_fetch_array($sqlR)){
        $nomorresi=$row["nomor_resi"];
    }

    $sql=mysql_query("SELECT clothingOrders.or_id, clothingOrders.order_detail,
    clothingOrders.ship_name, clothingOrders.ship_phone, clothingOrders.ship_address,
    clothingOrders.ship_city, clothingOrders.shipPrice, clothingOrders.date_added,
    clothingOrders.status,customer.customer_name, customer.phone, customer.address, customer.city
    FROM clothingOrders INNER JOIN customer ON clothingOrders.c_id=customer.c_id
    ");
  
    $orderCount=mysql_num_rows($sql); // count the output amount
    if($orderCount>0){
        while($row=mysql_fetch_array($sql)){
            $or_id=$row["or_id"];
       
            if ($or_id===$targetID){   
                $order_d=$row["order_detail"];
                    $_SESSION["order_d"]=unserialize($row["order_detail"]);
                $bill_name=$row["customer_name"];
                $bill_phone=$row["phone"];
                $bill_address=$row["address"];
                $bill_city=$row["city"];
                $ship_name=$row["ship_name"];
                $ship_phone=$row["ship_phone"];
                $ship_address=$row["ship_address"];
                $ship_city=$row["ship_city"];
                $shipPrice=$row["shipPrice"];
                $date_added=strftime("%b %d, %y", strtotime($row["date_added"]));
                $status=$row["status"];
            } // closing if
        } // closing while
    }else{
        $order_list="The order is not listed!";
    exit();   
    } // closing if($orderCount>0)
} // closing if ...
?>
<!---------- for VIEWING ---------------->
<?php
    include_once("admin//clothing_if_order_d_printout.php");
?>
<?php
////// dipakai hanya untuk kombinasi nomor pesanan ///////
@$qtySum=$i_qty1+$i_qty2+$i_qty3+$i_qty4+$i_qty5;
//////////////////////////////////////////////////////////
@$cartTotal=$total_price1+$total_price2+$total_price3+$total_price4+
$total_price5;
$cartTotalF=number_format($cartTotal,0,',','.');
$shipPriceF=number_format($shipPrice,0,',','.');
@$totalBuy=$cartTotal+$shipPrice;
$totalBuyF=number_format($totalBuy,0,',','.');      
?>
<!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=utf-8" />
<title>Clothing Printout</title>
<!---------------------- LINK -------------------------->
    <?php include_once("template_links_head.php"); ?>
<!---------------------- END of LINK -------------------------->
<script type="text/javascript" src="js/swipebox/jquery.swipebox.js"></script>
</head>
<body>
<div id="wrapper">
    <div id="contentPrintout">
        <div id="contentBill">
            <div id="headerP">
                <div id="logoP">
                    <?php include_once("template_logoP.php");?>
                </div><!--- END logo --->
            </div><!--- END headerP ---> 
            <div align="right" style="font-size:18px; margin-right:20px;
            font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
            Status:&nbsp;
                <?php
                    if (!empty($_SESSION["order_d"])){
                        echo $status;
                    }else{
                        echo "";
                    }
                ?> 
            </div>
            <br/>
            <?php
            // jika $status = SHIPPED maka:
            if ($status==="SHIPPED"){
            ?>
                <span style="font-size:18px; margin-left:35px;
                font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                Nomor Resi:</span>
                <?php echo $nomorresi; ?>
            <?php
            }else{ // jika tidak:
            ?>
                <span style="font-size:18px; margin-left:35px;
                font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                Nomor Pesanan:</span>
                    <?php echo $cartTotal; ?>
                    <?php echo "-"?>
                    <?php echo $qtySum; ?>
                    <?php echo "-"?>
                    <?php echo $or_id; ?>
                    <br /> 
            <?php
            }
            ?>
            <div id="bill_to" align="left">
                <div id="bill_to_left">
                    <span style="font-size:18px; margin-left:0px;
                    font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                    Pesanan Atas Nama: </span>
                    <br /> 
                    <div style="font-size:15px; margin-left:0px;
                    font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                        Name:
                        <font color='#0000FF' style='font-size:15px'>
                            <?php if (!empty($_SESSION["order_d"])){
                                    echo $bill_name;
                                } else{
                                    echo "";}
                            ?>
                        </font> 
                        <br />
                        Phone:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php if (!empty($_SESSION["order_d"])){
                            echo $bill_phone;
                        } else{
                            echo "";}
                        ?>
                        </font>
                        <br />
                        Address:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php if (!empty($_SESSION["order_d"])){
                            echo $bill_address;
                        } else{
                            echo "";}
                        ?>
                        </font>
                        <br />
                        City:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php if (!empty($_SESSION["order_d"])){
                            echo $bill_city;
                        } else{
                            echo "";}
                        ?>
                        </font>
                        <br />
                    </div>
                </div> <!--- END bill_to_left --->
               
                <div id="bill_to_right">
                    <span style="font-size:18px; margin-left:0px;
                    font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                    Pesanan Dikirim Ke:</span>
                    <br /> 
                    <div style="font-size:15px; margin-left:0px;
                    font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                        Name:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php
                        if (!empty($_SESSION["order_d"])){
                            echo $ship_name;
                        } else{
                            echo "";}
                        ?>
                        </font>
                        <br />
                        Phone:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php if (!empty($_SESSION["order_d"])){
                            echo $ship_phone;
                        } else{
                            echo "";}
                        ?>
                        </font>
                        <br />
                        Address:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php if (!empty($_SESSION["order_d"])){
                            echo $ship_address;
                        } else{
                            echo "";}
                        ?>
                        </font>
                        <br />
                        City:
                        <font color='#0000FF' style='font-size:15px'>
                        <?php if (!empty($_SESSION["order_d"])){
                        echo $ship_city;
                        } else{
                        echo "";}
                        ?>
                        </font>
                        <br />
                    </div>
                </div> <!--- END bill_to_right --->
            </div> <!--- END bill_to --->
           
            <div style="padding-left:35px">
                <a href="customer_clothingOrder_list.php" style="text-decoration:none">
                <input name="back" type="button" value="<< Back"
                style="font-size:15px; font-family:'Trebuchet MS',
                Arial, Helvetica, sans-serif" /></a>
            </div>
            <div id="bill_cart" style="font-weight:bold">
                <div id="bill_prod">Product</div>
                <div id="bill_desc">Description</div>
                <div id="bill_uprice">Unit Price</div>
                <div id="bill_qty">Qty</div>
                <div id="bill_price">Total Price</div>
            </div><!--END bill_cart -->
            <?php
            include_once("admin/clothing_viewOrder_printout.php");
            ?>   
            <!----------------------TOTAL ----------------------------------->
            <div id="bill_tot" style="font-size:15px;
            font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                <div id="bill_tot1">Sub Total Belanja &nbsp;:&nbsp;</div>
                <div id="bill_tot2">
                    <?php
                   if (!empty($_SESSION["order_d"])){
                  
                   echo 'Rp&nbsp'.$cartTotalF;
                   }else{
                   echo "";
                   }
                   ?>
                </div>
                             
                <div id="bill_tot3">Discount &nbsp;:&nbsp; </div>
                <div id="bill_tot4">  </div>
                <div id="bill_tot7">  </div>
                <div id="bill_tot8">
                    <?php
                    if (!empty($_SESSION["order_d"])){
                        echo 'Rp&nbsp'.$totalBuyF;
                    }else{
                       echo "";
                    }
                    ?>
                </div>
              
                <div id="bill_tot9">
                    <a href="customer_clothingOrder_list.php" style="text-decoration:none">
                    <input name="back" type="button" value="<< Back"
                    style="font-size:15px; font-family:'Trebuchet MS',
                    Arial, Helvetica, sans-serif" />
                    </a>
                </div>
                          
                <div id="bill_tot10" style="font-size:13px; color:blue;
                font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
               
                    <?php
                    // jika $status = PAID/SHIPPED maka:
                    //if(!empty ($stock_amount)|| $stock_amount !=0 || $stock_amount>0 ) {
                    if ($status==="PAID" || $status==="SHIPPED" ) {
                    ?>
                        <span style="font-size:18px; margin-left:35px;
                        font-family:'Trebuchet MS', Arial, Helvetica, sans-serif">
                        Slip :<br /></span>
                                               
                        <?php echo "<a href='konfirmasi_images/" . $targetID . ".jpg' title='slip'
                        class='swipebox' rel='img_gallery'>
                        <img src='konfirmasi_images/" . $targetID . ".jpg'
                        width='130' height='60' alt='x' class='one-edge-shadow'
                        style='border-color:blue; border-style:solid; border-width:0px' />
                        </a>
                        ";
                       
                        ?>
                       
                    <?php
                    }else{ // jika tidak:
                    ?>
                    <?php
                    }
                    ?>
               
                </div>
            </div>
        <!----------------------END of TOTAL ----------------------------->
        </div><!--- END contentBill --->
    </div><!--- END contentPrintout --->
</div><!--- END Wrapper --->
<?php include_once("template_js_body.php"); ?>
</body>
</html>

4.    Buat file .PHP dengan nama validasi_konfirmasiP.php di D:\TUTOR WEB\RIANKLIK\
Buka Notepad++, pilih File, klik Open, cari file validasi_konfirmasiP.php di D:\TUTOR WEB\RIANKLIK\. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<script type="text/javascript" language="javascript">
// By Adam Khoury @ www.developphp.com
function validatekonfirmasiPForm ( ) {
    var isValid = true;
    if ( document.konfirmasiPForm.order_number1.value == "" ) {
             alert ( "Do not leave it blank!" );
             isValid = false;
    } else if ( document.konfirmasiPForm.order_number2.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;
    } else if ( document.konfirmasiPForm.order_number3.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;   
    } else if ( document.konfirmasiPForm.bank_to.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;
    } else if ( document.konfirmasiPForm.bank_from.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;
    } else if ( document.konfirmasiPForm.atas_nama.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;
    } else if ( document.konfirmasiPForm.nominalT.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;
    } else if ( document.konfirmasiPForm.dateT.value == "" ) {
            alert ( "Do not leave it blank!" );
            isValid = false;
    }
    return isValid;
}
</script>
5.    Buat file .PHP dengan nama create_bankAccount_table.php di dalam folder phpScripts
Buka Notepad++, pilih File, klik Open, cari file create_bankAccount_table.php di dalam folder phpScripts. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<?php
// connect to your MySQL database here
require "connect_to_mysql.php";
// Create an sql command structure for creating a table
$sqlCommand = "CREATE TABLE bankAccount (
    b_id int(11) NOT NULL auto_increment,
    bank_name varchar(24) NOT NULL,
    address text(24) NOT NULL,
    rekening text(24) NOT NULL,
    atas_nama varchar(24) NOT NULL,
    date_added date NOT NULL,
    PRIMARY KEY (b_id)
    )ENGINE = InnoDB";
if (mysql_query($sqlCommand)){
    echo "Your bankAccount table has been created successfully!";
} else {
    echo "CRITICAL ERROR: bankAccount table has not been created.";
}
?>
6.    Buat file .PHP dengan nama insert_bankAccount_data.php di dalam folder phpScripts
Buka Notepad++, pilih File, klik Open, cari file insert_bankAccount_data.php di dalam folder phpScripts. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<?php
// connect to your MySQL database here
require "connect_to_mysql.php";
// Create an sql command structure for creating a table
$sqlCommand =
"INSERT INTO bankAccount
(b_id, bank_name, address, rekening, atas_nama, date_added)
VALUES
( '1', 'BCA', 'Bank BCA Cab Malang', '7770581529', 'Rian',now()),
( '2', 'BNI', 'Bank BNI Cab Malang', '7770581529', 'Rian',now()),
( '3', 'MANDIRI', 'Bank Mandiri Cab Malang', '7770581529', 'Rian',now()),
( '4', 'BRI', 'Bank BRI Cab Malang', '7770581529', 'Rian',now())
";
if (mysql_query($sqlCommand)){
    echo "Your bankAccount data has been inserted successfully!";
} else {
    echo "CRITICAL ERROR: bankAccount data has not been inserted.";
}
?>
7.    Buat file .PHP dengan nama create_clothingKonfirmasiP_table.php di dalam folder phpScripts
Buka Notepad++, pilih File, klik Open, cari file create_clothingKonfirmasiP_table.php di dalam folder phpScripts. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
<?php
// connect to your MySQL database here
require "connect_to_mysql.php";
// Create an sql command structure for creating a table
$sqlCommand = "CREATE TABLE clothingKonfirmasiP (
    kp_id int(11) NOT NULL auto_increment,
    order_number1 varchar(24) NOT NULL,
    order_number2 varchar(24) NOT NULL,
    order_number3 varchar(24) NOT NULL,
    bank_to varchar(50) NOT NULL,
    bank_from varchar(50) NOT NULL,
    atas_nama varchar(24) NOT NULL,
    nominalT decimal(16) NOT NULL,
    dateT text(24) NOT NULL,
    date_added date NOT NULL,
    PRIMARY KEY (kp_id)
   
    )ENGINE = InnoDB";
if (mysql_query($sqlCommand)){
    echo "Your clothingKonfirmasiP table has been created successfully!";
} else {
    echo "CRITICAL ERROR: clothingKonfirmasiP table has not been created.";
}
?>
8.    Buka Notepad++, pilih File, klik Open, cari file style.php di dalam folder styleCSS. Isikan sama seperti script warna biru di bawah lalu jangan lupa di-save :
/*--------------- konfirmasiP----------------- */
#content_k {
    -moz-border-radius: 8px 8px 8px 8px;  /* for Firefox */
    -webkit-border-radius: 8px 8px 8px 8px; /* for Webkit-Browsers */
    border-radius: 8px 8px 8px 8px; /* regular */
    opacity: 0.8;
    padding: 20px;
    width: 420px;
    margin-right: auto;
    margin-left: auto;
    font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
    overflow: hidden;
    position: relative;
    border: 1px solid #CCC;
    background-color: #FFFFFF;
}
9.  Buat folder dengan nama konfirmasi_images di D:\TUTOR WEB\RIANKLIK\
10.  Upload semua file dan folder ke web server
11.  Dengan menggunakan aplikasi winSCP rubah permission-nya folder konfirmasi_images menjadi Write
12.    Buka dengan browser 192.168.88.111/phpScripts/, klik file create_bankAccount_table.php, create_clothingKonfirmasiP_table.php, kemudian klik insert_bankAccount_data.php
13.    Buka dengan browser 192.168.88.111
Untuk melihat produk yang telah kita pesan :
Klik Login pada bagian atas (header), Name: jakablack, Password: 654321, lalu klik Log In
Dari halaman index.php, pilih Pria, pilih Pakaian, lalu dari halaman mensClothing.php, klik Pesanan, klik View
Gunakan Nomor Pesanan dan total harga untuk melakukan konfirmasi pembayaran

14.    Buka dengan browser 192.168.88.111
Untuk melakukan konfirmasi pembayaran atas produk yang telah kita beli :
Klik Login pada bagian atas (header), Name: jakablack, Password: 654321, lalu klik Log In
Dari halaman index.php, pilih Pria, pilih Pakaian, lalu dari halaman mensClothing.php, klik Konfirmasi, isikan pertanyaan captca dengan benar

Comments

Post a Comment

Popular posts from this blog

Sepuluh Langkah Membuat Warnet

Image
Tulisan ini saya tujukan untuk kalian yang benar-benar belum mengetahui dan ingin sekali mengetahuinya. Saya hanya memakai 3 unit komputer sebagai contoh, jika dengan 3 komputer kalian sudah bisa memahami, maka untuk 10 atau 20 unit komputer kemungkinan besar pasti bisa. Hardware tidak harus sama, sesuaikan dengan keadaan dan selera kalian. Konfigurasi jaringan yang saya buat sangat sederhana, … basic, … standard, atau apalah namanya, jika kalian ingin yang lebih rumit silakan kembangkan sendiri.
Baca Selanjutnya »