require_once("../database.php");
require_once("adminfuncties.php");
$q1 = "select *, from_unixtime(OrderDate, '%b/%d/%Y') as MyDate from oneshop_bestellingen where OrderID = '$_GET[OrderID]' ";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);
?>
Bestelling nummer: =$a1[OrderID]?> (=$a1[MyDate]?>)
Item nummer |
Item prijs |
Aantal |
Item Totaal |
$q2 = "select * from oneshop_bestellingen_content where OrderID = '$a1[OrderID]' ";
$r2 = mysql_query($q2) or die(mysql_error());
$col = "white";
while($a2 = mysql_fetch_array($r2))
{
if($col == "white")
{
$col = "#dddddd";
}
else
{
$col = "white";
}
$ItemPrice = number_format($a2[ItemPrice], 2, ".", "");
$ItemTotal = number_format($a2[ItemPrice] * $a2[ItemQty], 2, ".", "");
echo "\n\t$a2[ItemName] | \n\t $ItemPrice | \n\t$a2[ItemQty] | \n\t $ItemTotal |
\n";
}
?>
|
Verzending: |
=number_format($a1[ShippingPrice], 2, ".", "");?> Euro |
if($a1[SalesTax] > '0')
{
?>
BTW: |
=$a1[SalesTax]?> Euro |
}
?>
TOTAAL: |
=number_format($a1[OrderTotal], 2, ".", "");?> Euro |
Verzend informatie / Verzenden naar: |
Voornaam: |
=$a1[ShipToFirstName]?> |
Naam: |
=$a1[ShipToLastName]?> |
Adres 1: |
=$a1[ShipToAddress1]?> |
Adres 2: |
=$a1[ShipToAddress2]?> |
Postcode: |
=$a1[ShipToZIP]?> |
Woonplaats: |
=$a1[ShipToCity]?> |
Provincie: |
=$a1[ShipToState]?> |
Land: |
=$a1[ShipToCountry]?> |
Telefoon: |
=$a1[ShipToPhone]?> |
|
Facturatie gegevens: |
Voornaam: |
=$a1[BillToFirstName]?> |
Naam: |
=$a1[BillToLastName]?> |
Adres 1: |
=$a1[BillToAddress1]?> |
Adres 2: |
=$a1[BillToAddress2]?> |
Postcode: |
=$a1[BillToZIP]?> |
Woonplaats: |
=$a1[BillToCity]?> |
Provincie: |
=$a1[BillToState]?> |
Land: |
=$a1[BillToCountry]?> |
Telefoonnummer: |
=$a1[BillToPhone]?> |
|
Klant e-mail: =$a1[ClientEmail]?>
|
|