This is your receipt. Please print this receipt for your records.

"; // ================================= Top Data if(isset($_GET['ONu'])){ $ONu=$_GET['ONu']; //$_SESSION['memberID']=$_GET['member']; } echo "

Order Number: ".$ONu."

"; $receiptsql="Select * from Receipts where OrderNumber='$ONu'"; $receiptresult=mysql_query($receiptsql); while($receiptpull=mysql_fetch_array($receiptresult)){ $receiptdate=$receiptpull['Date']; if(isset($_SESSION['memberID'])){ } else { $_SESSION['memberID']=$receiptpull['BuyerID']; } } echo "Order Date: ".$receiptdate; // Social Media echo "

Order For:	Ship To:
"; $sql="Select * FROM Members WHERE member_ID='".$_SESSION['memberID']."'"; //echo $sql; $result=mysql_query($sql); while($pull=mysql_fetch_array($result)){ //member_ID store_id firstname lastnaemail telephone facebook website twitter notes password value newsletter emailFormat status approved customer_group_id ip date_added Street_A Street_B City State Country Postal_Code Company payMethod cc_num cc_exp cvv Paynote echo $pull['firstname'].' '.$pull['lastname'].' '; if($pull['Company']){ echo $pull['Company'].' '; } echo $pull['Street_A'].' '; if($pull['Street_B']){ echo $pull['Street_B'].' '; } echo $pull['City'].', '.$pull['State'].' '.$pull['Postal_Code'].' '; echo $pull['email'].' '.$pull['telephone'].' '; $PayMethod=$pull['payMethod']; $CCType=$pull['cc_type']; $CCExpire=$pull['cc_expire']; $CCRight=$_SESSION['ccright']; } echo "	"; $shipsql="SELECT * FROM shipTo WHERE ONu='$ONu'"; //echo $shipsql; $shipresult=mysql_query($shipsql); $result=mysql("$DBName","SELECT * FROM shipTo WHERE ONu='$ONu'"); while ($row=mysql_fetch_row($shipresult)) { $shipFName=$row[0]; $shipLName=$row[1]; $shipCO=$row[2]; $shipA1=$row[3]; $shipA2=$row[4]; $shipCi=$row[5]; $shipSt=$row[6]; $shipZip=$row[7]; $shipCountry=$row[8]; $shipPhone=$row[9]; $shipEmail=$row[10]; } echo $shipFName.' '.$shipLName.' '; if ($shipCO){ echo $shipCO.' '; } echo $shipA1.' '; if ($shipA2 != "") { echo $shipA2.' '; } echo $shipCi.', '.$shipSt.' '.$shipZip.' '; //echo $shipCountry.' '; if ($shipEmail != "") { echo $shipEmail.' '; } if ($shipPhone != "") { echo $shipPhone.' '; } echo "

Order For:

Ship To:

"; $sql="Select * FROM Members WHERE member_ID='".$_SESSION['memberID']."'"; //echo $sql; $result=mysql_query($sql); while($pull=mysql_fetch_array($result)){ //member_ID store_id firstname lastnaemail telephone facebook website twitter notes password value newsletter emailFormat status approved customer_group_id ip date_added Street_A Street_B City State Country Postal_Code Company payMethod cc_num cc_exp cvv Paynote echo $pull['firstname'].' '.$pull['lastname'].'
'; if($pull['Company']){ echo $pull['Company'].'
'; } echo $pull['Street_A'].'
'; if($pull['Street_B']){ echo $pull['Street_B'].'
'; } echo $pull['City'].', '.$pull['State'].' '.$pull['Postal_Code'].'
'; echo $pull['email'].'
'.$pull['telephone'].'
'; $PayMethod=$pull['payMethod']; $CCType=$pull['cc_type']; $CCExpire=$pull['cc_expire']; $CCRight=$_SESSION['ccright']; } echo "

"; $shipsql="SELECT * FROM shipTo WHERE ONu='$ONu'"; //echo $shipsql; $shipresult=mysql_query($shipsql); $result=mysql("$DBName","SELECT * FROM shipTo WHERE ONu='$ONu'"); while ($row=mysql_fetch_row($shipresult)) { $shipFName=$row[0]; $shipLName=$row[1]; $shipCO=$row[2]; $shipA1=$row[3]; $shipA2=$row[4]; $shipCi=$row[5]; $shipSt=$row[6]; $shipZip=$row[7]; $shipCountry=$row[8]; $shipPhone=$row[9]; $shipEmail=$row[10]; } echo $shipFName.' '.$shipLName.'
'; if ($shipCO){ echo $shipCO.'
'; } echo $shipA1.'
'; if ($shipA2 != "") { echo $shipA2.'
'; } echo $shipCi.', '.$shipSt.' '.$shipZip.'
'; //echo $shipCountry.'
'; if ($shipEmail != "") { echo $shipEmail.'
'; } if ($shipPhone != "") { echo $shipPhone.'
'; } echo "

"; echo "You have ordered the following items..."; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $prodsql="SELECT * FROM Receipts WHERE BuyerID='".$_SESSION['memberID']."' AND OrderNumber='$ONu'"; //echo $prodsql; $prodresult=mysql_query($prodsql); $runningtotal='0'; while ($prodrow=mysql_fetch_array($prodresult)) { // ShippingCost ItemQuantity Tax TotalCost Shipped Paid $BuyerID=$prodrow['BuyerID']; $Buyeremail=$prodrow['UserID']; $ItemSKU=$prodrow['ItemSKU']; $ItemName=$prodrow['ItemName']; $ItemNote=$prodrow['ItemNote']; $ItemCost=$prodrow['ItemCost']; $ShipMethod=$prodrow['ShipMethod']; $ShippingCost=$prodrow['ShippingCost']; $ItemQuantity=$prodrow['ItemQuantity']; $Tax=$prodrow['Tax']; $TotalCost=$prodrow['TotalCost']; $TotalCost=sprintf("%'6.2f","$TotalCost"); echo ""; } $orderdisc=$TotalCost-$Tax-$ShippingCost-$runningtotal; $orderdisc=sprintf("%'6.2f","$orderdisc"); //echo "Discount".$TotalCost.' '.$Tax.' '.$ShippingCost.' '.$orderdisc.' '.$runningtotal; $subtotal=number_format($runningtotal,"2",".","thousands_sep"); //$runningtotal; $Tot=number_format($total,"2",".","thousands_sep"); echo ""; if($orderdisc>'1'){ echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; echo "

"; echo "Product Code"; echo "	"; echo "Product Name"; echo "	"; echo "Quantity"; echo "	"; echo "Cost"; echo "	"; echo "Total"; echo "
"; echo $ItemSKU; echo "	"; echo $ItemName; echo "	"; echo $ItemQuantity; echo "	"; $ItemCost=number_format($ItemCost,"2",".","thousands_sep"); echo "$$ItemCost"; echo "	"; $TotalItemCost=$ItemQuantity*$ItemCost; $TotalItemCost=number_format($TotalItemCost,"2",".","thousands_sep"); echo "$$TotalItemCost"; $runningtotal=$runningtotal+$TotalItemCost; //echo $runningtotal; echo "
		"; echo "SubTotal"; echo "		"; echo "$$subtotal"; echo "
		"; //echo "$shipZip"; echo $_SESSION['Discount']; echo "		"; echo "$$orderdisc"; echo "
		"; //echo "$shipZip"; echo "Shipping and Handling "; echo "		"; //$Shipping=number_format($Shipping,"2",".","thousands_sep"); echo " $$ShippingCost"; echo "
		"; echo "Sales Tax "; echo "		"; //$Shipping=number_format($Shipping,"2",".","thousands_sep"); echo " $$Tax"; echo "
"; echo "Total Cost: "; echo "		"; echo "$$TotalCost"; echo "

"; echo "You selected to pay by $PayMethod. "; switch($PayMethod) : case 'Check': echo "
We will ship the products you ordered upon receipt of your payment.
"; break; case 'Draft': break; case 'PayPal': break; case 'Current': break; case 'Visa': echo "We will ship upon credit card clearance"; break; case 'American Express': echo "We will ship upon credit card clearance"; break; case 'Discover': echo "We will ship upon credit card clearance"; break; case 'MasterCard': echo "We will ship upon credit card clearance"; break; default: echo "We will contact you for payment"; endswitch; echo "

"; echo "If you have questions about this order, please contact us at:
"; echo "$masteremail
"; echo "or
"; echo "$masterphone

Please refer to order number"; echo " $ONu"; unset($_SESSION['incart']); // echo "

If you need access to this document again, you can point your web browser to:
"; // $Relative=ereg_replace("^/","",$Relative); // fontSize("-1","Red","$MasterWeb/Cart/okanereceipt.php?BID=$BuyerID&ON=$ONu"; echo "

"; //echo ""; include("footer.php"); ?>