checkout_thankyou.ihtml

php做的网上商店系统。简单易懂

<?php
if (!$print) {
?>
<H2>Thank You for Your Order</H2>
  
<?php
}
?> <BASEFONT <?php echo $base_font?>> 
<TABLE WIDTH=100% ALIGN=CENTER BORDER=0 CELLSPACING=0 CELLPADDING=10>
<TR VALIGN=TOP>
<TD ALIGN=LEFT WIDTH=90%><?php 
echo $vendor_name . "<BR>";
echo $vendor_address . "<BR>";
echo $vendor_city . ", ";
echo $vendor_state . " ";
echo $vendor_zip;
?>
</TD>
<TD WIDTH=10% ALIGN=RIGHT>
<?php echo $vendor_image;?></TD>
</TR>
<TR BGCOLOR=<?php echo $leftbar_title_bgcolor?>>
   <TD COLSPAN=2><H3>Purchase Order</H3></TD>
</TR>
</TABLE>

<?php 
   // Order_id is returned by checkoutComplete function
   $order_id = $vars["order_id"];
   $q  = "SELECT * from orders WHERE order_id='$order_id' ";
   $q .= "AND user_id='" . $auth["user_id"] . "' ";
   $db->query($q);
   $db->next_record(); 
?>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH=100%>
<!-- Begin Customer Information -->
<TR BGCOLOR=<?php echo $cart_header_color?>>
   <TD COLSPAN=2><B>Order Information</B></TD>
</TR>
<TR><TD>Order Number:</TD>
    <TD><?php printf("%08d", $db->f("order_id")); ?></TD>
</TR>
<TR><TD>Order Date:</TD>
    <TD><?php echo date("d-M-Y H:i", $db->f("cdate")); ?></TD>
</TR>
<TR><TD>Order Status:</TD>
    <TD><?php echo $order_status[$db->f("order_status")]["label"]; ?></TD>
</TR>
<!-- End Customer Information -->
<!-- Begin 2 column bill-ship to -->
<TR BGCOLOR=<?php echo $cart_header_color?>>
     <TD COLSPAN=2><B>Customer Information</B></TD>
</TR>
<TR VALIGN=top>
<TD WIDTH=50%>
  <!-- Begin BillTo -->
  <?php
    // Get ship_to information
    $dbbt = new ps_DB;
    $q  = "SELECT * FROM auth_user_md5, user_info WHERE ";
    $q .= "auth_user_md5.user_id='" . $auth["user_id"] . "' ";
    $q .= "AND auth_user_md5.user_id=user_info.user_id ";
    $q .= "AND user_info.address_type='BT'"; 
    $dbbt->query($q);
    $dbbt->next_record(); 
  ?>
  <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=2 BORDER=0>
  <TR>
     <TD COLSPAN=2><B>Bill To</B></TD>
  </TR>
  <TR><TD>Company:</TD>
    <TD><?php $dbbt->p("company"); ?></TD>
  </TR>
  <TR><TD>Full Name:</TD>
    <TD><?php 
         $dbbt->p("first_name"); 
         echo " ";
         $dbbt->p("middle_name"); 
         echo " ";
         $dbbt->p("last_name"); 
         ?></TD>
  </TR>
  <TR VALIGN=TOP><TD>Address:</TD>
    <TD><?php 
          $dbbt->p("address_1"); 
          echo "<BR>";
          $dbbt->p("address_2");    
         ?></TD></TR>
  <TR><TD>City:</TD>
    <TD><?php $dbbt->p("city"); ?></TD></TR>
  <TR><TD>Zip Code:</TD>
    <TD><?php $dbbt->p("zip"); ?></TD></TR>
  <TR><TD>Country:</TD>
    <TD><?php $dbbt->p("country"); ?></TD></TR>
  <TR><TD>Phone:</TD>
    <TD><?php $dbbt->p("phone_1"); ?></TD></TR>
  <TR><TD>Fax:</TD>
    <TD><?php $dbbt->p("fax"); ?></TD></TR>
  <TR><TD>Email:</TD>
    <TD><?php $dbbt->p("user_email"); ?></TD></TR>
  </TABLE>
<!-- End BillTo -->
</TD>
<TD WIDTH=50%>
  <!-- Begin ShipTo -->
  <?php
    // Get bill_to and ship_to information
    $dbst = new ps_DB;
    $q  = "SELECT * FROM user_info WHERE ";
    $q .= "user_info_id='" . $db->f("user_info_id") . "'";
    $dbst->query($q);
    $dbst->next_record(); 
  ?>
  <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=2 BORDER=0>
  <TR>
     <TD COLSPAN=2><B>Ship To</B></TD>
  </TR>
  <TR><TD>Company:</TD>
    <TD><?php $dbst->p("company"); ?></TD>
  </TR>
  <TR><TD>Full Name:</TD>
    <TD><?php 
         $dbst->p("first_name"); 
         echo " ";
         $dbst->p("middle_name"); 
         echo " ";
         $dbst->p("last_name"); 
         ?></TD>
  </TR>
  <TR VALIGN=TOP><TD>Address:</TD>
    <TD><?php 
          $dbst->p("address_1"); 
          echo "<BR>";
          $dbst->p("address_2");    
         ?></TD></TR>
  <TR><TD>City:</TD>
    <TD><?php $dbst->p("city"); ?></TD></TR>
  <TR><TD>Zip Code:</TD>
    <TD><?php $dbst->p("zip"); ?></TD></TR>
  <TR><TD>Country:</TD>
    <TD><?php $dbst->p("country"); ?></TD></TR>
  <TR><TD>Phone:</TD>
    <TD><?php $dbst->p("phone_1"); ?></TD></TR>
  <TR><TD>Fax:</TD>
    <TD><?php $dbst->p("fax"); ?></TD></TR>
  </TABLE>
<!-- End ShipTo -->
<!-- End Customer Information -->
</TD>
</TR>
<!-- Begin Order Items Information -->
<TR BGCOLOR=<?php echo $cart_header_color?>>
     <TD COLSPAN=2><B>Order Items</B></TD>
</TR>
<TR>
  <TD COLSPAN=2>
      <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=0 BORDER=0>
      <TR ALIGN=LEFT>
        <TH>Qty</TH>
        <TH>Name</TH>
        <TH>SKU</TH>
        <TH>Price</TH>
        <TH>Total</TH>
      </TR>
<?php 
  $dbcart = new ps_DB;
  $q  = "SELECT * FROM orders, order_item, product ";
  $q .= "WHERE orders.order_id='$order_id' ";
  $q .= "AND orders.order_id=order_item.order_id ";
  $q .= "AND product.product_id=order_item.product_id";
  $dbcart->query($q); 
  $subtotal = 0;
  while ($dbcart->next_record()) {
?>
      <TR ALIGN=LEFT>
      <TD><?php $dbcart->p("product_quantity"); ?></TD>
      <TD><?php $dbcart->p("product_name"); ?></TD>
      <TD><?php $dbcart->p("product_sku"); ?></TD>
      <TD><?php $price = get_price($dbcart->f("product_id"));
                $item_price = $price["product_price"]; 
               printf("$%.2f", $item_price);
           ?></TD>
      <TD><?php $total = $dbcart->f("product_quantity") * $item_price; 
                $subtotal += $total;
                printf("$%.2f", $total);
           ?></TD>
      </TR><TR><TD colspan="5">&nbsp;</TD></TR>
<?php
 }
?>    
      <TR>
          <TD COLSPAN=4 ALIGN=RIGHT><b>Sub Total:</b></TD>
      <TD><?php printf("$%.2f", $subtotal) ?></TD></TR>
<!-- End Order Items Information -->
<!-- Beging Order Shipping Information -->
<TR BGCOLOR=<?php echo $cart_header_color?>>
     <TD COLSPAN=5><B>Shipping</B></TD>
</TR>
  <TR ALIGN=LEFT>
        <TH colspan="2">Ship Method</TH>
        <TH>Ship Date</TH>
        <TH>Delivery Date</TH>
          <TH>Charges</TH>
      </TR>
<?php 
  $dbship = new ps_DB;
  $q  = "SELECT * FROM ISshipping ";
  $q .= "WHERE vendor_id='$ps_vendor_id' ";
  $q .= "AND ship_method_id='$ship_method_id'";
  $dbship->query($q); 
  while ($dbship->next_record()) {
?>
      <TR ALIGN=LEFT>
      <TD><?php $dbship->p("ship_carrier_name"); ?></TD>
      <TD><?php $dbship->p("ship_method_name"); ?></TD>
      <TD><?php echo date("m/d/Y", $IS_quote[$ship_method_id]["sdate"]); ?></TD>
      <TD><?php echo date("m/d/Y", $IS_quote[$ship_method_id]["ddate"]); ?></TD>
      <TD><?php printf("$%.2f", $IS_quote[$ship_method_id]["rate"]); ?></TD>
      </TR><TR><TD colspan="5">&nbsp;</TD></TR>
<?php
  $subtotal=$subtotal+$IS_quote[$ship_method_id]["rate"];
 }
?>    
      <TR><TD COLSPAN=4 ALIGN=RIGHT><B>Total:</B></TD>
      <TD><?php printf("$%.2f", $subtotal) ?></TD></TR>
      </TABLE>
</TD>
</TR>
<!-- End Shipping Information -->
<!-- Begin Payment Information -->
<TR BGCOLOR=<?php echo $cart_header_color?>>
     <TD COLSPAN=2><B>Payment Information</B></TD>
</TR>
<?php
  $dbpm = new ps_DB;
  $q  = "SELECT * from payment_method WHERE order_id='$order_id'";
  $dbpm->query($q);
  $dbpm->next_record();
?>
<TR><TD>Payment Method:</TD>
<TD><?php $dbpm->p("payment_method_type"); ?>
</TD></TR>
<TR><TD>Account Name:</TD>
<TD><?php $dbpm->p("payment_method_name"); ?>
</TD></TR>
<TR><TD>Account Number:</TD>
<TD><?php echo $ps_order_process->asterisk_pad($dbpm->f("payment_method_number"),4); ?>
</TD></TR>
<TR><TD>Expire Date:</TD>
<TD><?php echo date("M-Y", $dbpm->f("payment_method_expire")); ?>
</TD></TR>
<!-- End Payment Information -->
</TABLE>
<!-- Body ends here --> <?php 
if (!$print) {
?> 
<DIV ALIGN="CENTER"><BR>
  A confirmation email has been sent to: <BR>
  <?php $dbbt->p("user_email"); ?>.<BR>
</DIV>
<CENTER>
  <BR>
  <BR>
  <BR>
<A HREF="<?php $sess->purl(SECUREURL . "?page=$modulename/thankyou&order_id=$order_id&print=1"); ?>">Print View</A>
<BR><BR></CENTER>

<?php
}
?>