Viewing file:  orders.php (27.67 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<? include('includes/application_top.php'); ?>
<?
if ($HTTP_GET_VARS['action']) {
if ($HTTP_GET_VARS['action'] == 'update_order') {
$order_finish = ($HTTP_GET_VARS['status'] == 'Delivered') ? ', orders_date_finished = now()' : '';
tep_db_query("update orders set orders_status = '" . $HTTP_GET_VARS['status'] . "', last_modified = now()" . $order_finish . " where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
tep_db_query("update orders set comments = '" . $HTTP_GET_VARS['comments'] . "' where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
header('Location: ' . tep_href_link(FILENAME_ORDERS, 'orders_id=' . $HTTP_GET_VARS['orders_id'])); tep_exit();
} elseif ($HTTP_GET_VARS['action'] == 'delete_order') {
tep_db_query("delete from orders where orders_id = '" . $HTTP_GET_VARS['orders_id_delete'] . "'");
tep_db_query("delete from orders_products where orders_id = '" . $HTTP_GET_VARS['orders_id_delete'] . "'");
header('Location: ' . tep_href_link(FILENAME_ORDERS, '')); tep_exit();
}
}
// * check if orders exist, if not redirect back to orders page with error
// * this check is done at the top to avoid headers being sent for the redirect
if (@$HTTP_GET_VARS['orders_id']) {
$orders = tep_db_query("select orders_id from orders where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
if (!tep_db_num_rows($orders)) {
header('Location: ' . tep_href_link(FILENAME_ORDERS, 'error=' . $HTTP_GET_VARS['orders_id'], 'NONSSL')); tep_exit();
}
}
?>
<html>
<head>
<title><? echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<?
if (@$HTTP_GET_VARS['error']) {
?>
<script language="javascript"><!---
function alertBox() {
alert('<? echo JS_ORDER_DOES_NOT_EXIST; ?>');
return true;
}
//--></script>
<?
}
?>
<body <? if ($HTTP_GET_VARS['error']) echo 'onLoad="alertBox();"'; ?> marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<? $include_file = DIR_WS_INCLUDES . 'header.php'; include(DIR_WS_INCLUDES . 'include_once.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="5" cellpadding="5">
<tr>
<td width="<? echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<? echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<? $include_file = DIR_WS_INCLUDES . 'column_left.php'; include(DIR_WS_INCLUDES . 'include_once.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
</tr>
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="boxborder">
<tr>
<td bgcolor="<? echo TOP_BAR_BACKGROUND_COLOR; ?>" width="100%" nowrap><font face="<? echo TOP_BAR_FONT_FACE; ?>" size="<? echo TOP_BAR_FONT_SIZE; ?>" color="<? echo TOP_BAR_FONT_COLOR; ?>"> <? echo TOP_BAR_TITLE; ?> </font></td>
</tr>
</table></td>
</tr>
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td nowrap><font face="<? echo HEADING_FONT_FACE; ?>" size="<? echo HEADING_FONT_SIZE; ?>" color="<? echo HEADING_FONT_COLOR; ?>"> <? echo HEADING_TITLE; ?> </font></td>
<td align="right" nowrap><br><form name="orders" <? echo 'action="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(), 'NONSSL') . '"'; ?> method="get"><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo HEADING_TITLE_SEARCH; ?> <input type="text" name="orders_id" value="<? echo $HTTP_GET_VARS['orders_id']; ?>" size="5"> <? echo tep_image_submit(DIR_WS_IMAGES . 'button_search.gif', '66', '20', '0', IMAGE_SEARCH); ?> </font></form></td>
</tr>
</table></td>
</tr>
<?
if (@$HTTP_GET_VARS['orders_id']) {
$orders = tep_db_query("select customers_telephone, customers_email_address, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status from orders where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
$orders_values = tep_db_fetch_array($orders);
$sold_to = tep_db_query("select customers_name as name, customers_street_address as street_address, customers_suburb as suburb, customers_city as city, customers_postcode as postcode, customers_state as state, customers_country as country, customers_address_format_id as format_id from orders where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
$sold_to_values = tep_db_fetch_array($sold_to);
$ship_to = tep_db_query("select delivery_name as name, delivery_street_address as street_address, delivery_suburb as suburb, delivery_city as city, delivery_postcode as postcode, delivery_state as state, delivery_country as country, delivery_address_format_id as format_id from orders where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
$ship_to_values = tep_db_fetch_array($ship_to);
?>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td valign="top" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_CUSTOMERS_INFO; ?> </b></font></td>
<td valign="top" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_DELIVERY_INFO; ?> </b></font></td>
</tr>
<tr>
<td colspan="2"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td valign="top" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_CUSTOMER; ?> </font></td>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>">
<? echo tep_address_format($sold_to_values['format_id'], $sold_to_values, 1, ' ', '<br>'); ?>
</font></td>
</tr>
<tr>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_TELEPHONE; ?> </font></td>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo $orders_values['customers_telephone']; ?> </font></td>
</tr>
<tr>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_EMAIL_ADDRESS; ?> </font></td>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <a href="mailto:<? echo $orders_values['customers_email_address']; ?>"><u><? echo $orders_values['customers_email_address']; ?></u></a> </font></td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td valign="top" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_DELIVERY_TO; ?> </font></td>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>">
<? echo tep_address_format($ship_to_values['format_id'], $ship_to_values, 1, ' ', '<br>'); ?>
</font></td>
</tr>
</table></td>
</tr>
<tr>
<td nowrap colspan="2"><br><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_PAYMENT_INFORMATION; ?> </b></font></td>
</tr>
<tr>
<td nowrap colspan="2"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td colspan="2"><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_PAYMENT_METHOD; ?> </font></td>
<td nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo $orders_values['payment_method']; ?> </font></td>
</tr>
<?php
if ($orders_values['cc_type'] || $orders_values['cc_owner'] || $orders_values['cc_number']) {
print "<tr>\n";
print "<td colspan=\"2\"> </td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . htmlentities(ENTRY_CREDIT_CARD_TYPE) . " </font></td>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . htmlentities($orders_values['cc_type']) . " </font></td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . htmlentities(ENTRY_CREDIT_CARD_OWNER) . " </font></td>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . htmlentities($orders_values['cc_owner']) . " </font></td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . htmlentities(ENTRY_CREDIT_CARD_NUMBER) . " </font></td>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . $orders_values['cc_number'] . " </font></td>\n";
print "</tr>\n";
print "<tr>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . htmlentities(ENTRY_CREDIT_CARD_EXPIRES) . " </font></td>\n";
print "<td nowrap><font face=\"" . TEXT_FONT_FACE . "\" size=\"" . TEXT_FONT_SIZE . "\" color=\"" . TEXT_FONT_COLOR . "\"> " . $orders_values['cc_expires'] . " </font></td>\n";
print "</tr>\n";
}
?>
</table></td>
</tr>
<tr>
<td colspan="2"><br><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td align="center" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_QUANTITY; ?> </b></font></td>
<td nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_PRODUCTS; ?> </b></font></td>
<td align="center" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_TAX; ?> </b></font></td>
<td align="right" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_TOTAL; ?> </b></font></td>
</tr>
<tr>
<td colspan="4"><? echo tep_black_line(); ?></td>
</tr>
<?
$info = tep_db_query("select date_purchased, orders_status, last_modified, shipping_cost, shipping_method,comments from orders where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
$info_values = tep_db_fetch_array($info);
$shipping = $info_values['shipping_cost'];
$shipping_method = $info_values['shipping_method'];
$date_purchased = date('l, jS F, Y', mktime(0,0,0,substr($info_values['date_purchased'], 4, 2),substr($info_values['date_purchased'], 6, 2),substr($info_values['date_purchased'], 0, 4)));
if (@$info_values['last_modified'] != '0') {
$date_updated = date('l, jS F, Y', mktime(0,0,0,substr($info_values['last_modified'], 4, 2),substr($info_values['last_modified'], 6, 2),substr($info_values['last_modified'], 0, 4)));
} else $date_updated = '';
$products = tep_db_query("select orders_products_id, products_id, products_name, products_price, products_quantity, final_price, products_tax from orders_products where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "'");
$total_cost = 0;
$total_tax = 0;
while ($products_values = tep_db_fetch_array($products)) {
$final_price = $products_values['final_price'];
echo ' <tr>' . "\n";
echo ' <td align="center" nowrap><font face="' . TEXT_FONT_FACE . '" size="' . TEXT_FONT_SIZE . '" color="' . TEXT_FONT_COLOR . '"> ' . $products_values['products_quantity'] . ' </font></td>' . "\n";
echo ' <td nowrap><font face="' . TEXT_FONT_FACE . '" size="' . TEXT_FONT_SIZE . '" color="' . TEXT_FONT_COLOR . '"><b> ' . $products_values['products_name'] . ' </b>' . "\n";
//------display customer choosen option --------
$attributes_exist = '0';
$attributes_query = tep_db_query("select products_options, products_options_values from orders_products_attributes where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "' and orders_products_id = '" . $products_values['products_id'] . "'");
if (@tep_db_num_rows($attributes_query)) {
$attributes_exist = '1';
while ($attributes = tep_db_fetch_array($attributes_query)) {
echo '<br><small><i> - ' . $attributes['products_options'] . ' : ' . $attributes['products_options_values'] . '</i></small>';
}
}
//------display customer choosen option eof-----
echo '</font></td>' . "\n";
echo ' <td align="center" valign="top" nowrap><font face="' . TEXT_FONT_FACE . '" size="' . TEXT_FONT_SIZE . '" color="' . TEXT_FONT_COLOR . '"> ' . number_format($products_values['products_tax'], TAX_DECIMAL_PLACES) . '% </font></td>' . "\n";
echo ' <td align="right" valign="top" nowrap><font face="' . TEXT_FONT_FACE . '" size="' . TEXT_FONT_SIZE . '" color="' . TEXT_FONT_COLOR . '"> <b>' . tep_currency_format($products_values['products_quantity'] * $products_values['products_price']) . '</b> ';
//------display customer choosen option --------
if ($attributes_exist == '1') {
$attributes = tep_db_query("select options_values_price, price_prefix from orders_products_attributes where orders_id = '" . $HTTP_GET_VARS['orders_id'] . "' and orders_products_id = '" . $products_values['products_id'] . "'");
while ($attributes_values = tep_db_fetch_array($attributes)) {
if ($attributes_values['options_values_price'] != '0') {
echo '<br><small><i>' . $attributes_values['price_prefix'] . tep_currency_format($products_values['products_quantity'] * $attributes_values['options_values_price']) . '</i></small> ';
} else {
echo '<br> ';
}
}
}
//------display customer choosen option eof-----
echo '</font></td>' . "\n";
echo ' </tr>' . "\n";
$cost = ($products_values['products_quantity'] * $final_price);
$total_tax += ($cost * $products_values['products_tax']/100);
$total_cost += $cost;
}
?>
<tr>
<td colspan="4"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td align="right" colspan="4"><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_SUB_TOTAL; ?> </font></td>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo tep_currency_format($total_cost, 2); ?> </font></td>
</tr>
<tr>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo ENTRY_TAX; ?> </font></td>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo tep_currency_format($total_tax); ?> </font></td>
</tr>
<?
if ($shipping != 0) {
?>
<tr>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo $shipping_method . " " . ENTRY_SHIPPING; ?> </font></td>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> <? echo tep_currency_format($shipping); ?> </font></td>
</tr>
<?
}
?>
<tr>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo ENTRY_TOTAL; ?> </b></font></td>
<td align="right" nowrap><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo tep_currency_format($total_cost + $total_tax + $shipping); ?> </b></font></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td nowrap colspan="2"><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_COMMENTS; ?> </b></font></td>
</tr>
<tr>
<td colspan="2"><? echo tep_black_line(); ?></td>
</tr>
<form name="status" <? echo 'action="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '"'; ?> method="get">
<tr>
<td colspan="2"><? echo "<textarea name=comments rows=5 cols=60>" . $info_values['comments'] . "</textarea>" ?></td>
</tr>
<tr>
<td colspan="2"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td nowrap colspan="2"><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_STATUS; ?> </b></font></td>
</tr>
<tr>
<td colspan="2"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td nowrap colspan="2"><br><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo ENTRY_DATE_PURCHASED; ?></b> <? echo $date_purchased; ?> </font></td>
</tr>
<tr><input type="hidden" name="action" value="update_order"><input type="hidden" name="orders_id" value="<? echo $HTTP_GET_VARS['orders_id']; ?>">
<td nowrap colspan="2"><br><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo ENTRY_STATUS; ?></b> <select name="status"><option value="Processing"<? if ($info_values['orders_status'] == 'Processing') { echo ' SELECTED'; } ?>>Processing</option><option value="Delivered"<? if ($info_values['orders_status'] == 'Delivered') { echo ' SELECTED'; } ?>>Delivered</option><option value="Pending"<? if ($info_values['orders_status'] == 'Pending') { echo ' SELECTED'; } ?>>Pending</option></select> <? echo tep_image_submit(DIR_WS_IMAGES . 'button_update.gif', '66', '20', '0', IMAGE_UPDATE); ?> </font></td>
</tr></form>
<?
if ($date_updated != '') {
?>
<tr>
<td nowrap colspan="2"><br><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"><b> <? echo ENTRY_DATE_LAST_UPDATED; ?></b> <? echo $date_updated; ?> </font></td>
</tr>
<?
}
?>
<tr>
<td colspan="2"><br><? echo tep_black_line(); ?></td>
</tr>
<form action="<? echo tep_href_link(FILENAME_ORDERS, '', 'NONSSL'); ?>" method="get" onsubmit="return confirm('<? echo IMAGE_CONFIRM; ?>')">
<tr>
<td colspan="2" align="right" nowrap><input type="hidden" name="action" value="delete_order"><input type="hidden" name="orders_id_delete" value="<? echo $HTTP_GET_VARS['orders_id'] ?>"><? echo tep_image_submit(DIR_WS_IMAGES . 'button_delete.gif', '66', '20', '0', IMAGE_DELETE); ?> <a href="<? echo tep_href_link(FILENAME_ORDERS, '', 'NONSSL'); ?>"><? echo tep_image(DIR_WS_IMAGES . 'button_back.gif', '66', '20', '0', IMAGE_BACK); ?></a> </td>
</tr>
</form>
<tr>
<td colspan="2"><font face="<? echo TEXT_FONT_FACE; ?>" size="<? echo TEXT_FONT_SIZE; ?>" color="<? echo TEXT_FONT_COLOR; ?>"> </font></td>
</tr>
</table></td>
</tr>
<?
} else {
?>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td colspan="5"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_CUSTOMERS; ?> </b></font></td>
<td align="right" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_ORDER_TOTAL; ?> </b></font></td>
<td align="right" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_PAYMENT_METHOD; ?> </b></font></td>
<td align="right" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_DATE_PURCHASED; ?> </b></font></td>
<td align="right" nowrap><font face="<? echo TABLE_HEADING_FONT_FACE; ?>" size="<? echo TABLE_HEADING_FONT_SIZE; ?>" color="<? echo TABLE_HEADING_FONT_COLOR; ?>"><b> <? echo TABLE_HEADING_STATUS; ?> </b></font></td>
</tr>
<tr>
<td colspan="5"><? echo tep_black_line(); ?></td>
</tr>
<?
$orders_query_raw = "select orders_id, customers_name, payment_method, date_purchased, shipping_cost, orders_status from orders order by orders_id DESC";
$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);
$orders = tep_db_query($orders_query_raw);
$rows = 0;
while ($orders_values = tep_db_fetch_array($orders)) {
$rows++;
$total = 0;
$orders_products = tep_db_query("select products_price, final_price, products_quantity, products_tax from orders_products where orders_id = '" . $orders_values['orders_id'] . "'");
while ($orders_products_values = tep_db_fetch_array($orders_products)) {
$subtotal = ($orders_products_values['final_price'] * $orders_products_values['products_quantity']);
$tax = $subtotal * ($orders_products_values['products_tax']/100);
$total = $total + $subtotal + $tax;
}
$total = $total + $orders_values['shipping_cost'];
$date_formatted = substr($orders_values['date_purchased'], 6, 2) . '/' . substr($orders_values['date_purchased'], 4, 2) . '/' . substr($orders_values['date_purchased'], 0, 4);
?>
<tr bgcolor="#d8e1eb" onmouseover="this.style.background='#cc9999';this.style.cursor='hand'" onmouseout="this.style.background='#d8e1eb'" onclick="document.location.href='<? echo tep_href_link(FILENAME_ORDERS, 'orders_id=' . $orders_values['orders_id'], 'NONSSL'); ?>'">
<td nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo '<a href="' . tep_href_link(FILENAME_ORDERS, 'orders_id=' . $orders_values['orders_id'], 'NONSSL') . '" class="blacklink">'; ?><? echo $orders_values['customers_name']; ?></a> </font></td>
<td align="right" nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo tep_currency_format($total, 2); ?> </font></td>
<td align="right" nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo $orders_values['payment_method']; ?> </font></td>
<td align="right" nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo $date_formatted; ?> </font></td>
<td align="right" nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo $orders_values['orders_status']; ?> </font></td>
</tr>
<?
}
?>
<tr>
<td colspan="5"><? echo tep_black_line(); ?></td>
</tr>
<tr>
<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?> </font></td>
<td align="right" nowrap><font face="<? echo SMALL_TEXT_FONT_FACE; ?>" size="<? echo SMALL_TEXT_FONT_SIZE; ?>" color="<? echo SMALL_TEXT_FONT_COLOR; ?>"> <? echo TEXT_RESULT_PAGE; ?> <? echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?> </font></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<?
}
?>
</table></td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<? $include_file = DIR_WS_INCLUDES . 'footer.php'; include(DIR_WS_INCLUDES . 'include_once.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<? $include_file = DIR_WS_INCLUDES . 'application_bottom.php'; include(DIR_WS_INCLUDES . 'include_once.php'); ?>
|