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]?>
|
|