snubbr.com

Verisign SSL? Secure XXXXXXX Lock? Easy 10 Points?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
Question I have... Verisign SSL? Secure XXXXXXX Lock? Easy 10 Points? Many thanks for any comment. 2nd question I got is.. Whenever I try to edit or delete an order it gives a redirect loop error, I am not a coder by any means (hey atleast I admit it -lol), but I have been very careful and doing a backup before editing anything, however I thought I backed this one up, but I did not...

Any help would be great!!!.

Here is my code:.

<?php.

/*.

$Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $.

OsCommerce, Open Source E-Commerce Solutions.

[url="http://www.oscommerce.com"]http://www.oscommerce.com[/url].

Copyright © 2003 osCommerce.

Released under the GNU General Public License.

*/.

Require('includes/application_top.php');.

/* ** GOOGLE CHECKOUT **/.

Define('GC_STATE_NEW', 100);.

Define('GC_STATE_PROCESSING', 101);.

Define('GC_STATE_SHIPPED', 102);.

Define('GC_STATE_REFUNDED', 103);.

Define('GC_STATE_SHIPPED_REFUNDED', 104);.

Define('GC_STATE_CANCELED', 105);.

Function google_checkout_state_change($check_status, $status, $oID,.

$cust_notify, $notify_comments) {.

Global $db,$messageStack, $orders_statuses;.

Define('API_CALLBACK_ERROR_LOG',.

DIR_FS_CATALOG. "/googlecheckout/logs/response_error.log");.

Define('API_CALLBACK_MESSAGE_LOG',.

DIR_FS_CATALOG"/googlecheckout/logs/response_message.log");.

Include_once(DIR_FS_CATALOG.'/includes/modules/payment/googlecheckout.php');.

Include_once(DIR_FS_CATALOG.'/googlecheckout/library/googlerequest.php');.

$googlepayment = new googlecheckout();.

$Grequest = new GoogleRequest($googlepayment->merchantid,.

$googlepayment->merchantkey,.

MODULE_PAYMENT_GOOGLECHECKOUT_MODE==.

'https://sandbox.google.com/checkout/'.

?"sandbox":"production",.

DEFAULT_CURRENCY);.

$Grequest->SetLogFiles(API_CALLBACK_ERROR_LOG, API_CALLBACK_MESSAGE_LOG);.

$google_answer = tep_db_fetch_array(tep_db_query("SELECT go.google_order_number, go.order_amount, o.customers_email_address, gc.buyer_id, o.customers_id.

FROM "$googlepayment->table_order" go.

Inner join "TABLE_ORDERS" o on go.orders_id = o.orders_id.

Inner join "$googlepayment->table_name" gc on gc.customers_id = o.customers_id.

WHERE go.orders_id = '"(int)$oID ."'.

Group by o.customers_id order by o.orders_id desc"));.

$google_order = $google_answer['google_order_number'];.

$amount = $google_answer['order_amount'];.

// If status update is from Google New -> Google Processing on the Admin UI.

// this invokes the processing-order and charge-order commands.

// 1->Google New, 2-> Google Processing.

If($check_status['orders_status'] == GC_STATE_NEW.

&& $status == GC_STATE_PROCESSING && $google_order != '') {.

List($curl_status,) = $Grequest->SendChargeOrder($google_order, $amount);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CHARGE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CHARGE_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendProcessOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_PROCESS_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_PROCESS_ORDER, 'success');.

}.

}.

// If status update is from Google Processing or Google Refunded -> Google Shipped on the Admin UI.

// this invokes the deliver-order and archive-order commands.

// 2->Google Processing or Google Refunded, 3-> Google Shipped (refunded).

Else if(($check_status['orders_status'] == GC_STATE_PROCESSING.

|| $check_status['orders_status'] == GC_STATE_REFUNDED).

&& ($status == GC_STATE_SHIPPED || $status == GC_STATE_SHIPPED_REFUNDED ).

&& $google_order != '') {.

$carrier = $tracking_no = "";.

// Add tracking Data.

If(isset($_POST['carrier_select']) && ($_POST['carrier_select'] != 'select').

&& isset($_POST['tracking_number']) && !empty($_POST['tracking_number'])) {.

$carrier = $_POST['carrier_select'];.

$tracking_no = $_POST['tracking_number'];.

$comments = GOOGLECHECKOUT_STATE_STRING_TRACKING ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_CARRIER$_POST['carrier_select'] ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_NUMBER$_POST['tracking_number']"";.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY".

(orders_id, orders_status_id, date_added, customer_notified, comments).

Values ('"(int)$oID"',.

'"tep_db_input(($check_status['orders_status']==GC_STATE_REFUNDED.

?GC_STATE_SHIPPED_REFUNDED:GC_STATE_SHIPPED))"',.

Now(),.

'"tep_db_input($cust_notify)"',.

'"tep_db_input($comments)"')");.

}.

List($curl_status,) = $Grequest->SendDeliverOrder($google_order, $carrier,.

$tracking_no, ($cust_notify==1)?"true":"false");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_DELIVER_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_DELIVER_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// If status update is to Google Canceled on the Admin UI.

// this invokes the cancel-order and archive-order commands.

Else if($check_status['orders_status'] != GC_STATE_CANCELED &&.

$status == GC_STATE_CANCELED && $google_order != '') {.

If($check_status['orders_status'] != GC_STATE_NEW){.

List($curl_status,) = $Grequest->SendRefundOrder($google_order, 0,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED.

);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_REFUND_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_REFUND_ORDER, 'success');.

}.

}.

Else {.

// Tell google witch is the OSC's internal order Number.

List($curl_status,) = $Grequest->SendMerchantOrderNumber($google_order, $oID);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MERCHANT_ORDER_NUMBER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MERCHANT_ORDER_NUMBER, 'success');.

}.

}.

// Is the order is not archive, I do it.

If($check_status['orders_status'] != GC_STATE_SHIPPED.

&& $check_status['orders_status'] != GC_STATE_SHIPPED_REFUNDED){.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// Cancel the order.

List($curl_status,) = $Grequest->SendCancelOrder($google_order,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED,.

$notify_comments);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CANCEL_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CANCEL_ORDER, 'success');.

}.

}.

Else if($google_order != ''.

&& $check_status['orders_status'] != $status){.

$statuses = array();.

Foreach($orders_statuses as $status_array){.

$statuses[$status_array['id']] = $status_array['text'];.

}.

$messageStack->add_session( sprintf(GOOGLECHECKOUT_ERR_INVALID_STATE_TRANSITION,.

$statuses[$check_status['orders_status']],.

$statuses[$status],.

$statuses[$check_status['orders_status']]),.

'error');.

}.

// Send Buyer's message.

If($cust_notify==1 && isset($notify_comments) && !empty($notify_comments)) {.

$cust_notify_ok = '0';.

If(!((strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH).

&& MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING=='True')){.

List($curl_status,) = $Grequest->sendBuyerMessage($google_order,.

$notify_comments, "true");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MESSAGE_ORDER, 'error');.

$cust_notify_ok = '0';.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MESSAGE_ORDER, 'success');.

$cust_notify_ok = '1';.

}.

If(strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH) {.

$messageStack->add_session(.

Sprintf(GOOGLECHECKOUT_WARNING_CHUNK_MESSAGE, GOOGLE_MESSAGE_LENGTH), 'warning');.

}.

}.

// Cust notified.

Return $cust_notify_ok;.

}.

// Cust notified.

Return '0';.

}.

// ** END GOOGLE CHECKOUT **.

//PayPal WPP Modification START //.

Include(DIR_FS_DOCUMENT_ROOTDIR_WS_INCLUDES'configure.php');.

Include(DIR_WS_CLASSES'order.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

Include(DIR_WS_INCLUDES'paypal_wpp/paypal_wpp_include.php');.

$paypal_wpp = new paypal_wpp_admin;.

//PayPal WPP Modification END //.

$orders_statuses = array();.

$orders_status_array = array();.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

While ($orders_status = tep_db_fetch_array($orders_status_query)) {.

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

'text' => $orders_status['orders_status_name']);.

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

}.

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');.

If (tep_not_null($action)) {.

Switch ($action) {.

Case 'update_order':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);.

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);.

//Package Tracking Plus BEGIN.

$usps_track_num = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num']);.

$usps_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num2']);.

$ups_track_num = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num']);.

$ups_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num2']);.

$fedex_track_num = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num']);.

$fedex_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num2']);.

$dhl_track_num = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num']);.

$dhl_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num2']);.

//Package Tracking Plus END.

$order_updated = false;.

//Package Tracking Plus BEGIN.

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, usps_track_num, usps_track_num2, ups_track_num, ups_track_num2, fedex_track_num, fedex_track_num2, dhl_track_num, dhl_track_num2, date_purchased from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

//Package Tracking Plus END.

If ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {.

Tep_db_query("update "TABLE_ORDERS" set orders_status = '"tep_db_input($status)"', last_modified = now() where orders_id = '"(int)$oID"'");.

// ** GOOGLE CHECKOUT **.

Chdir("./..");.

Require_once(DIR_WS_LANGUAGES$language'/modules/payment/googlecheckout.php');.

$payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE;.

$num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));.

If($num_rows != 0) {.

$customer_notified = google_checkout_state_change($check_status, $status, $oID,.

(@$_POST['notify']=='on'?1:0),.

(@$_POST['notify_comments']=='on'?$comments:''));.

}.

$customer_notified = isset($customer_notified)?$customer_notified:'0';.

// ** END GOOGLE CHECKOUT **.

If (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {.

$notify_comments = '';.

If (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) {.

$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE$comments"\n\n";.

}.

// ** GOOGLE CHECKOUT **.

$force_email = false;.

If($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) {.

$force_email = true;.

$messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');.

}.

If($num_rows == 0 || $force_email) {.

//send emails, not a google order or configured to use both messaging systems.

$email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

Tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_/img/avatar2.jpg, STORE_/img/avatar2.jpg_EMAIL_ADDRESS);.

$customer_notified = '1';.

//send extra emails.

}.

}.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)"')");.

$order_updated = true;.

}.

//Package Tracking Plus BEGIN.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num = '"tep_db_input($usps_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num2 = '"tep_db_input($usps_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num = '"tep_db_input($ups_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num2 = '"tep_db_input($ups_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num = '"tep_db_input($fedex_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num2 = '"tep_db_input($fedex_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num = '"tep_db_input($dhl_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num2 = '"tep_db_input($dhl_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

$order_updated = true;.

//Package Tracking Plus END.

$order_updated = true;.

}.

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

Tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

Break;.

}.

If (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$order_exists = true;.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

//PayPal WPP Modification START //.

//include(DIR_WS_CLASSES'order.php');.

//PayPal WPP Modification END //.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

<script language="javascript" src="includes/general.js"></script>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->add_javascript();.

//PayPal WPP Modification END //.

?>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! header //>.

<?php.

Require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

</table></td>.

<! body_text //>.

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

If (($action == 'edit') && ($order_exists == true)) {.

$order = new order($oID);.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE'<a href="'tep_href_link(FILENAME_CREATE_ORDER)'"> Create order </a>'; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

</table></td>.

</tr>.

<tr>.

<td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td colspan="3"><?php echo tep_draw_separator(); ?></td>.

</tr>.

<tr>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

</tr>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

<td class="main"><?php echo $order->customer['telephone']; ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

<td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

<td class="main"><?php echo $order->info['payment_method']; ?></td>.

</tr>.

<?php.

If (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_/img/avatar2.jpg']) || tep_not_null($order->info['cc_number'])) {.

?>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>.

<td class="main"><?php echo $order->info['cc_type']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_/img/avatar2.jpg; ?></td>.

<td class="main"><?php echo $order->info['cc_/img/avatar2.jpg']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>.

<td class="main"><?php echo $order->info['cc_number']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>.

<td class="main"><?php echo $order->info['cc_expires']; ?></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

</tr>.

<?php.

For ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

Echo ' <tr class="dataTableRow">'"\n" ..

' <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

If (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

For ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

Echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

If ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

Echo '</i></small></nobr>';.

}.

}.

Echo ' </td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

Echo ' </tr>'"\n";.

}.

?>.

<tr>.

<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

For ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->display_buttons($oID);.

//PayPal WPP Modification END //.

?>.

<tr>.

<td class="main"><table border="1" cellspacing="0" cellpadding="5">.

<tr>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

<?php //PayPal WPP Modification START // ?>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_TRANSACTION_INFO; ?></b></td>.

<?php //PayPal WPP Modification END // ?>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$orders_history_query = tep_db_query("select orders_status_history_id, orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

//PayPal WPP Modification END //.

If (tep_db_num_rows($orders_history_query)) {.

While ($orders_history = tep_db_fetch_array($orders_history_query)) {.

Echo ' <tr>'"\n" ..

' <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

' <td class="smallText" align="center">';.

If ($orders_history['customer_notified'] == '1') {.

Echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

} else {.

Echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

}.

Echo ' <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

' <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

//PayPal WPP Modification START //.

' <td class="smallText">'$paypal_wpp->get_transaction_info($orders_history['orders_status_history_id'])'</td>'"\n" ..

//PayPal WPP Modification END //.

' </tr>'"\n";.

}.

} else {.

Echo ' <tr>'"\n" ..

' <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

<td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<! Package Tracking Plus BEGIN >.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_USPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num', '40', '40', '', $order->info['usps_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num2', '40', '40', '', $order->info['usps_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num2']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_UPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num', '40', '40', '', $order->info['ups_track_num']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num2', '40', '40', '', $order->info['ups_track_num2']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num2']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_FEDEX_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num', '40', '40', '', $order->info['fedex_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num2', '40', '40', '', $order->info['fedex_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_DHL_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num', '40', '40', '', $order->info['dhl_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num2', '40', '40', '', $order->info['dhl_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

</table></td>.

</tr>.

<! Package Tracking Plus END >.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

<td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

</tr>.

</table></td>.

<td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

<! googlecheckout Tracking Number >.

<?php.

// orders_status == STATE_PROCESSING -> Processing before delivery.

If(strpos($order->info['payment_method'], 'Google')!= -1 && $order->info['orders_status'] == GC_STATE_PROCESSING){.

Echo '<td><table border="0" cellpadding="3" cellspacing="0" width="100%">.

<tbody>.

<tr>.

<td style="border-top: 2px solid rgb(255, 255, 255); border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap" colspan="2">.

<b>Shipping Information</b>.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Tracking:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255); border-bottom: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<input name="tracking_number" style="color: rgb(0, 0, 0);" id="trackingBox" size="20" type="text">.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Carrier:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<select name="carrier_select" style="color: rgb(0, 0, 0);" id="carrierSelect">.

<option value="select" selected="selected">.

Select ...

</option>.

<option value="USPS">.

USPS.

</option>.

<option value="DHL">.

DHL.

</option>.

<option value="UPS">.

UPS.

</option>.

<option value="Other">.

Other.

</option>.

<option value="FedEx">.

FedEx.

</option>.

</select>.

</td>.

</tr>.

</tbody>.

</table></td>';.

}.

?>.

<! end googlecheckout Tracking Number >.

</tr>.

</table></td>.

</form></tr>.

<tr>.

<td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

<?php.

} else {.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

</form></tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

</form></tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

<td class="dataTableHeadingContent" align="center">Order ID</td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

</tr>.

<?php.

If (isset($HTTP_GET_VARS['cID'])) {.

$cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

} elseif (isset($HTTP_GET_VARS['status'])) {.

$status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

} else {.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

}.

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

$orders_query = tep_db_query($orders_query_raw);.

While ($orders = tep_db_fetch_array($orders_query)) {.

If ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

$oInfo = new objectInfo($orders);.

}.

If (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

Echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

} else {.

Echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

}.

?>.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

<td class="dataTableContent" align="center"><?php echo $orders['orders_id']; ?></td>.

<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

<td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES'icon_arrow_right.gif', ''); } else { echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'">'tep_image(DIR_WS_IMAGES'icon_info.gif', IMAGE_ICON_INFO)'</a>'; } ?>&nbsp;</td>.

</tr>.

<?php.

}.

?>.

<tr>.

<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr>.

<td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>.

<td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

<?php.

$heading = array();.

$contents = array();.

Switch ($action) {.

Case 'delete':.

$heading[] = array('text' => '<b>'TEXT_INFO_HEADING_DELETE_ORDER'</b>');.

$contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=deleteconfirm'));.

$contents[] = array('text' => TEXT_INFO_DELETE_INTRO'<br><br><b>'$cInfo->customers_firstname' '$cInfo->customers_lastname'</b>');.

$contents[] = array('text' => '<br>'tep_draw_checkbox_field('restock')' 'TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);.

$contents[] = array('align' => 'center', 'text' => '<br>'tep_image_submit('button_delete.gif', IMAGE_DELETE)' <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id)'">'tep_image_button('button_cancel.gif', IMAGE_CANCEL)'</a>');.

Break;.

Default:.

If (isset($oInfo) && is_object($oInfo)) {.

$heading[] = array('text' => '<b>['$oInfo->orders_id']&nbsp;&nbsp;'tep_datetime_short($oInfo->date_purchased)'</b>');.

$contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=delete')'">'tep_image_button('button_delete.gif', IMAGE_DELETE)'</a>');.

$contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS_INVOICE, &#.

Comments (23)

I would like to know the answer too. Anyone here know what is the answer to your question. I'll do some research and get back to you if I got an useful answer. You should email the people at Verisign as they probably know..

Comment #1

Try changing this:.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

To.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

Case 'deleteconfirm':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

BACKUP FIRST!..

Comment #2

Thanks Jim,.

But now I get:.

Parse error: syntax error, unexpected T_CASE in on line 313.

Which on line 313 is:.

Case 'deleteconfirm':.

Really appreciate the help!..

Comment #3

This post:.

Click me.

It will tell you how to find your version of osC and places to download a complete fileset..

Then extract.

/admin/.

Orders.php.

And start over, or if you have a file compare program that may help..

If what I posted didn't work - I don't know, and it's virtually impossible to tell with the way you posted your code...

Comment #4

Are you sure you have the code as I posted?.

From the error I'd hazard a guess that maybe you left out the line with ".

Break;.

"....

The error doesn't make a lot of sense in this context to me..

Post the file contents again but in a CODEBOX or between CODE tags..

This preserves formatting and usually make it easier to debug...

Comment #5

Here you go, sorry for the confusion....

<?php.

/*.

$Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $.

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Require('includes/application_top.php');.

/* ** GOOGLE CHECKOUT **/.

Define('GC_STATE_NEW', 100);.

Define('GC_STATE_PROCESSING', 101);.

Define('GC_STATE_SHIPPED', 102);.

Define('GC_STATE_REFUNDED', 103);.

Define('GC_STATE_SHIPPED_REFUNDED', 104);.

Define('GC_STATE_CANCELED', 105);.

Function google_checkout_state_change($check_status, $status, $oID,.

$cust_notify, $notify_comments) {.

Global $db,$messageStack, $orders_statuses;.

Define('API_CALLBACK_ERROR_LOG',.

DIR_FS_CATALOG. "/googlecheckout/logs/response_error.log");.

Define('API_CALLBACK_MESSAGE_LOG',.

DIR_FS_CATALOG"/googlecheckout/logs/response_message.log");.

Include_once(DIR_FS_CATALOG.'/includes/modules/payment/googlecheckout.php');.

Include_once(DIR_FS_CATALOG.'/googlecheckout/library/googlerequest.php');.

$googlepayment = new googlecheckout();.

$Grequest = new GoogleRequest($googlepayment->merchantid,.

$googlepayment->merchantkey,.

MODULE_PAYMENT_GOOGLECHECKOUT_MODE==.

'https://sandbox.google.com/checkout/'.

?"sandbox":"production",.

DEFAULT_CURRENCY);.

$Grequest->SetLogFiles(API_CALLBACK_ERROR_LOG, API_CALLBACK_MESSAGE_LOG);.

$google_answer = tep_db_fetch_array(tep_db_query("SELECT go.google_order_number, go.order_amount, o.customers_email_address, gc.buyer_id, o.customers_id.

FROM "$googlepayment->table_order" go.

Inner join "TABLE_ORDERS" o on go.orders_id = o.orders_id.

Inner join "$googlepayment->table_name" gc on gc.customers_id = o.customers_id.

WHERE go.orders_id = '"(int)$oID ."'.

Group by o.customers_id order by o.orders_id desc"));.

$google_order = $google_answer['google_order_number'];.

$amount = $google_answer['order_amount'];.

// If status update is from Google New -> Google Processing on the Admin UI.

// this invokes the processing-order and charge-order commands.

// 1->Google New, 2-> Google Processing.

If($check_status['orders_status'] == GC_STATE_NEW.

&& $status == GC_STATE_PROCESSING && $google_order != '') {.

List($curl_status,) = $Grequest->SendChargeOrder($google_order, $amount);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CHARGE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CHARGE_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendProcessOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_PROCESS_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_PROCESS_ORDER, 'success');.

}.

}.

// If status update is from Google Processing or Google Refunded -> Google Shipped on the Admin UI.

// this invokes the deliver-order and archive-order commands.

// 2->Google Processing or Google Refunded, 3-> Google Shipped (refunded).

Else if(($check_status['orders_status'] == GC_STATE_PROCESSING.

|| $check_status['orders_status'] == GC_STATE_REFUNDED).

&& ($status == GC_STATE_SHIPPED || $status == GC_STATE_SHIPPED_REFUNDED ).

&& $google_order != '') {.

$carrier = $tracking_no = "";.

// Add tracking Data.

If(isset($_POST['carrier_select']) && ($_POST['carrier_select'] != 'select').

&& isset($_POST['tracking_number']) && !empty($_POST['tracking_number'])) {.

$carrier = $_POST['carrier_select'];.

$tracking_no = $_POST['tracking_number'];.

$comments = GOOGLECHECKOUT_STATE_STRING_TRACKING ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_CARRIER$_POST['carrier_select'] ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_NUMBER$_POST['tracking_number']"";.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY".

(orders_id, orders_status_id, date_added, customer_notified, comments).

Values ('"(int)$oID"',.

'"tep_db_input(($check_status['orders_status']==GC_STATE_REFUNDED.

?GC_STATE_SHIPPED_REFUNDED:GC_STATE_SHIPPED))"',.

Now(),.

'"tep_db_input($cust_notify)"',.

'"tep_db_input($comments)"')");.

}.

List($curl_status,) = $Grequest->SendDeliverOrder($google_order, $carrier,.

$tracking_no, ($cust_notify==1)?"true":"false");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_DELIVER_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_DELIVER_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// If status update is to Google Canceled on the Admin UI.

// this invokes the cancel-order and archive-order commands.

Else if($check_status['orders_status'] != GC_STATE_CANCELED &&.

$status == GC_STATE_CANCELED && $google_order != '') {.

If($check_status['orders_status'] != GC_STATE_NEW){.

List($curl_status,) = $Grequest->SendRefundOrder($google_order, 0,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED.

);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_REFUND_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_REFUND_ORDER, 'success');.

}.

}.

Else {.

// Tell google witch is the OSC's internal order Number.

List($curl_status,) = $Grequest->SendMerchantOrderNumber($google_order, $oID);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MERCHANT_ORDER_NUMBER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MERCHANT_ORDER_NUMBER, 'success');.

}.

}.

// Is the order is not archive, I do it.

If($check_status['orders_status'] != GC_STATE_SHIPPED.

&& $check_status['orders_status'] != GC_STATE_SHIPPED_REFUNDED){.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// Cancel the order.

List($curl_status,) = $Grequest->SendCancelOrder($google_order,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED,.

$notify_comments);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CANCEL_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CANCEL_ORDER, 'success');.

}.

}.

Else if($google_order != ''.

&& $check_status['orders_status'] != $status){.

$statuses = array();.

Foreach($orders_statuses as $status_array){.

$statuses[$status_array['id']] = $status_array['text'];.

}.

$messageStack->add_session( sprintf(GOOGLECHECKOUT_ERR_INVALID_STATE_TRANSITION,.

$statuses[$check_status['orders_status']],.

$statuses[$status],.

$statuses[$check_status['orders_status']]),.

'error');.

}.

// Send Buyer's message.

If($cust_notify==1 && isset($notify_comments) && !empty($notify_comments)) {.

$cust_notify_ok = '0';.

If(!((strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH).

&& MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING=='True')){.

List($curl_status,) = $Grequest->sendBuyerMessage($google_order,.

$notify_comments, "true");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MESSAGE_ORDER, 'error');.

$cust_notify_ok = '0';.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MESSAGE_ORDER, 'success');.

$cust_notify_ok = '1';.

}.

If(strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH) {.

$messageStack->add_session(.

Sprintf(GOOGLECHECKOUT_WARNING_CHUNK_MESSAGE, GOOGLE_MESSAGE_LENGTH), 'warning');.

}.

}.

// Cust notified.

Return $cust_notify_ok;.

}.

// Cust notified.

Return '0';.

}.

// ** END GOOGLE CHECKOUT **.

//PayPal WPP Modification START //.

Include(DIR_FS_DOCUMENT_ROOTDIR_WS_INCLUDES'configure.php');.

Include(DIR_WS_CLASSES'order.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

Include(DIR_WS_INCLUDES'paypal_wpp/paypal_wpp_include.php');.

$paypal_wpp = new paypal_wpp_admin;.

//PayPal WPP Modification END //.

$orders_statuses = array();.

$orders_status_array = array();.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

While ($orders_status = tep_db_fetch_array($orders_status_query)) {.

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

'text' => $orders_status['orders_status_name']);.

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

}.

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');.

If (tep_not_null($action)) {.

Switch ($action) {.

Case 'update_order':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);.

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);.

//Package Tracking Plus BEGIN.

$usps_track_num = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num']);.

$usps_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num2']);.

$ups_track_num = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num']);.

$ups_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num2']);.

$fedex_track_num = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num']);.

$fedex_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num2']);.

$dhl_track_num = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num']);.

$dhl_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num2']);.

//Package Tracking Plus END.

$order_updated = false;.

//Package Tracking Plus BEGIN.

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, usps_track_num, usps_track_num2, ups_track_num, ups_track_num2, fedex_track_num, fedex_track_num2, dhl_track_num, dhl_track_num2, date_purchased from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

//Package Tracking Plus END.

If ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {.

Tep_db_query("update "TABLE_ORDERS" set orders_status = '"tep_db_input($status)"', last_modified = now() where orders_id = '"(int)$oID"'");.

// ** GOOGLE CHECKOUT **.

Chdir("./..");.

Require_once(DIR_WS_LANGUAGES$language'/modules/payment/googlecheckout.php');.

$payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE;.

$num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));.

If($num_rows != 0) {.

$customer_notified = google_checkout_state_change($check_status, $status, $oID,.

(@$_POST['notify']=='on'?1:0),.

(@$_POST['notify_comments']=='on'?$comments:''));.

}.

$customer_notified = isset($customer_notified)?$customer_notified:'0';.

// ** END GOOGLE CHECKOUT **.

If (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {.

$notify_comments = '';.

If (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) {.

$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE$comments"\n\n";.

}.

// ** GOOGLE CHECKOUT **.

$force_email = false;.

If($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) {.

$force_email = true;.

$messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');.

}.

If($num_rows == 0 || $force_email) {.

//send emails, not a google order or configured to use both messaging systems.

$email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

Tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);.

$customer_notified = '1';.

//send extra emails.

}.

}.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)"')");.

$order_updated = true;.

}.

//Package Tracking Plus BEGIN.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num = '"tep_db_input($usps_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num2 = '"tep_db_input($usps_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num = '"tep_db_input($ups_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num2 = '"tep_db_input($ups_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num = '"tep_db_input($fedex_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num2 = '"tep_db_input($fedex_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num = '"tep_db_input($dhl_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num2 = '"tep_db_input($dhl_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

$order_updated = true;.

//Package Tracking Plus END.

$order_updated = true;.

}.

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

Case 'deleteconfirm':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

Tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

Break;.

}.

}.

If (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$order_exists = true;.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

//PayPal WPP Modification START //.

//include(DIR_WS_CLASSES'order.php');.

//PayPal WPP Modification END //.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

<script language="javascript" src="includes/general.js"></script>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->add_javascript();.

//PayPal WPP Modification END //.

?>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! header //>.

<?php.

Require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

</table></td>.

<! body_text //>.

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

If (($action == 'edit') && ($order_exists == true)) {.

$order = new order($oID);.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE'<a href="'tep_href_link(FILENAME_CREATE_ORDER)'"> Create order </a>'; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

</table></td>.

</tr>.

<tr>.

<td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td colspan="3"><?php echo tep_draw_separator(); ?></td>.

</tr>.

<tr>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

</tr>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

<td class="main"><?php echo $order->customer['telephone']; ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

<td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

<td class="main"><?php echo $order->info['payment_method']; ?></td>.

</tr>.

<?php.

If (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {.

?>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>.

<td class="main"><?php echo $order->info['cc_type']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>.

<td class="main"><?php echo $order->info['cc_owner']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>.

<td class="main"><?php echo $order->info['cc_number']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>.

<td class="main"><?php echo $order->info['cc_expires']; ?></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

</tr>.

<?php.

For ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

Echo ' <tr class="dataTableRow">'"\n" ..

' <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

If (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

For ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

Echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

If ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

Echo '</i></small></nobr>';.

}.

}.

Echo ' </td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

Echo ' </tr>'"\n";.

}.

?>.

<tr>.

<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

For ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->display_buttons($oID);.

//PayPal WPP Modification END //.

?>.

<tr>.

<td class="main"><table border="1" cellspacing="0" cellpadding="5">.

<tr>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

<?php //PayPal WPP Modification START // ?>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_TRANSACTION_INFO; ?></b></td>.

<?php //PayPal WPP Modification END // ?>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$orders_history_query = tep_db_query("select orders_status_history_id, orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

//PayPal WPP Modification END //.

If (tep_db_num_rows($orders_history_query)) {.

While ($orders_history = tep_db_fetch_array($orders_history_query)) {.

Echo ' <tr>'"\n" ..

' <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

' <td class="smallText" align="center">';.

If ($orders_history['customer_notified'] == '1') {.

Echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

} else {.

Echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

}.

Echo ' <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

' <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

//PayPal WPP Modification START //.

' <td class="smallText">'$paypal_wpp->get_transaction_info($orders_history['orders_status_history_id'])'</td>'"\n" ..

//PayPal WPP Modification END //.

' </tr>'"\n";.

}.

} else {.

Echo ' <tr>'"\n" ..

' <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

<td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<! Package Tracking Plus BEGIN >.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_USPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num', '40', '40', '', $order->info['usps_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num2', '40', '40', '', $order->info['usps_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num2']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_UPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num', '40', '40', '', $order->info['ups_track_num']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num2', '40', '40', '', $order->info['ups_track_num2']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num2']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_FEDEX_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num', '40', '40', '', $order->info['fedex_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num2', '40', '40', '', $order->info['fedex_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_DHL_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num', '40', '40', '', $order->info['dhl_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num2', '40', '40', '', $order->info['dhl_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

</table></td>.

</tr>.

<! Package Tracking Plus END >.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

<td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

</tr>.

</table></td>.

<td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

<! googlecheckout Tracking Number >.

<?php.

// orders_status == STATE_PROCESSING -> Processing before delivery.

If(strpos($order->info['payment_method'], 'Google')!= -1 && $order->info['orders_status'] == GC_STATE_PROCESSING){.

Echo '<td><table border="0" cellpadding="3" cellspacing="0" width="100%">.

<tbody>.

<tr>.

<td style="border-top: 2px solid rgb(255, 255, 255); border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap" colspan="2">.

<b>Shipping Information</b>.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Tracking:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255); border-bottom: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<input name="tracking_number" style="color: rgb(0, 0, 0);" id="trackingBox" size="20" type="text">.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Carrier:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<select name="carrier_select" style="color: rgb(0, 0, 0);" id="carrierSelect">.

<option value="select" selected="selected">.

Select ...

</option>.

<option value="USPS">.

USPS.

</option>.

<option value="DHL">.

DHL.

</option>.

<option value="UPS">.

UPS.

</option>.

<option value="Other">.

Other.

</option>.

<option value="FedEx">.

FedEx.

</option>.

</select>.

</td>.

</tr>.

</tbody>.

</table></td>';.

}.

?>.

<! end googlecheckout Tracking Number >.

</tr>.

</table></td>.

</form></tr>.

<tr>.

<td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

<?php.

} else {.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

</form></tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

</form></tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

<td class="dataTableHeadingContent" align="center">Order ID</td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

</tr>.

<?php.

If (isset($HTTP_GET_VARS['cID'])) {.

$cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

} elseif (isset($HTTP_GET_VARS['status'])) {.

$status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

} else {.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

}.

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

$orders_query = tep_db_query($orders_query_raw);.

While ($orders = tep_db_fetch_array($orders_query)) {.

If ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

$oInfo = new objectInfo($orders);.

}.

If (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

Echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

} else {.

Echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

}.

?>.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

<td class="dataTableContent" align="center"><?php echo $orders['orders_id']; ?></td>.

<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

<td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES'icon_arrow_right.gif', ''); } else { echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'">'tep_image(DIR_WS_IMAGES'icon_i.

Comment #6

In this code:.

//Package Tracking Plus BEGIN.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num = '"tep_db_input($usps_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num2 = '"tep_db_input($usps_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num = '"tep_db_input($ups_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num2 = '"tep_db_input($ups_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num = '"tep_db_input($fedex_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num2 = '"tep_db_input($fedex_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num = '"tep_db_input($dhl_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num2 = '"tep_db_input($dhl_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

$order_updated = true;.

//Package Tracking Plus END.

$order_updated = true;.

} [b]< change this to [color="#FF0000"]/* } */[/color][/b].

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}..

Comment #7

Your the man!.

Worked like a champ....

Thank you so much!..

Comment #8

You're welcome..

Now that it works, make a backup!..

Comment #9

Now I get the below error when I try to update an orders status, e.g. changing to processing order or shipped etc..

1146 - Table 'axiom_catalog.google_orders' doesn't exist.

Select google_order_number from google_orders where orders_id= 31248.

[TEP STOP].

It was fine before, so is there something we altered?.

Just in case, here is the code:.

<?php.

/*.

$Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $.

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Require('includes/application_top.php');.

/* ** GOOGLE CHECKOUT **/.

Define('GC_STATE_NEW', 100);.

Define('GC_STATE_PROCESSING', 101);.

Define('GC_STATE_SHIPPED', 102);.

Define('GC_STATE_REFUNDED', 103);.

Define('GC_STATE_SHIPPED_REFUNDED', 104);.

Define('GC_STATE_CANCELED', 105);.

Function google_checkout_state_change($check_status, $status, $oID,.

$cust_notify, $notify_comments) {.

Global $db,$messageStack, $orders_statuses;.

Define('API_CALLBACK_ERROR_LOG',.

DIR_FS_CATALOG. "/googlecheckout/logs/response_error.log");.

Define('API_CALLBACK_MESSAGE_LOG',.

DIR_FS_CATALOG"/googlecheckout/logs/response_message.log");.

Include_once(DIR_FS_CATALOG.'/includes/modules/payment/googlecheckout.php');.

Include_once(DIR_FS_CATALOG.'/googlecheckout/library/googlerequest.php');.

$googlepayment = new googlecheckout();.

$Grequest = new GoogleRequest($googlepayment->merchantid,.

$googlepayment->merchantkey,.

MODULE_PAYMENT_GOOGLECHECKOUT_MODE==.

'https://sandbox.google.com/checkout/'.

?"sandbox":"production",.

DEFAULT_CURRENCY);.

$Grequest->SetLogFiles(API_CALLBACK_ERROR_LOG, API_CALLBACK_MESSAGE_LOG);.

$google_answer = tep_db_fetch_array(tep_db_query("SELECT go.google_order_number, go.order_amount, o.customers_email_address, gc.buyer_id, o.customers_id.

FROM "$googlepayment->table_order" go.

Inner join "TABLE_ORDERS" o on go.orders_id = o.orders_id.

Inner join "$googlepayment->table_name" gc on gc.customers_id = o.customers_id.

WHERE go.orders_id = '"(int)$oID ."'.

Group by o.customers_id order by o.orders_id desc"));.

$google_order = $google_answer['google_order_number'];.

$amount = $google_answer['order_amount'];.

// If status update is from Google New -> Google Processing on the Admin UI.

// this invokes the processing-order and charge-order commands.

// 1->Google New, 2-> Google Processing.

If($check_status['orders_status'] == GC_STATE_NEW.

&& $status == GC_STATE_PROCESSING && $google_order != '') {.

List($curl_status,) = $Grequest->SendChargeOrder($google_order, $amount);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CHARGE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CHARGE_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendProcessOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_PROCESS_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_PROCESS_ORDER, 'success');.

}.

}.

// If status update is from Google Processing or Google Refunded -> Google Shipped on the Admin UI.

// this invokes the deliver-order and archive-order commands.

// 2->Google Processing or Google Refunded, 3-> Google Shipped (refunded).

Else if(($check_status['orders_status'] == GC_STATE_PROCESSING.

|| $check_status['orders_status'] == GC_STATE_REFUNDED).

&& ($status == GC_STATE_SHIPPED || $status == GC_STATE_SHIPPED_REFUNDED ).

&& $google_order != '') {.

$carrier = $tracking_no = "";.

// Add tracking Data.

If(isset($_POST['carrier_select']) && ($_POST['carrier_select'] != 'select').

&& isset($_POST['tracking_number']) && !empty($_POST['tracking_number'])) {.

$carrier = $_POST['carrier_select'];.

$tracking_no = $_POST['tracking_number'];.

$comments = GOOGLECHECKOUT_STATE_STRING_TRACKING ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_CARRIER$_POST['carrier_select'] ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_NUMBER$_POST['tracking_number']"";.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY".

(orders_id, orders_status_id, date_added, customer_notified, comments).

Values ('"(int)$oID"',.

'"tep_db_input(($check_status['orders_status']==GC_STATE_REFUNDED.

?GC_STATE_SHIPPED_REFUNDED:GC_STATE_SHIPPED))"',.

Now(),.

'"tep_db_input($cust_notify)"',.

'"tep_db_input($comments)"')");.

}.

List($curl_status,) = $Grequest->SendDeliverOrder($google_order, $carrier,.

$tracking_no, ($cust_notify==1)?"true":"false");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_DELIVER_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_DELIVER_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// If status update is to Google Canceled on the Admin UI.

// this invokes the cancel-order and archive-order commands.

Else if($check_status['orders_status'] != GC_STATE_CANCELED &&.

$status == GC_STATE_CANCELED && $google_order != '') {.

If($check_status['orders_status'] != GC_STATE_NEW){.

List($curl_status,) = $Grequest->SendRefundOrder($google_order, 0,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED.

);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_REFUND_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_REFUND_ORDER, 'success');.

}.

}.

Else {.

// Tell google witch is the OSC's internal order Number.

List($curl_status,) = $Grequest->SendMerchantOrderNumber($google_order, $oID);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MERCHANT_ORDER_NUMBER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MERCHANT_ORDER_NUMBER, 'success');.

}.

}.

// Is the order is not archive, I do it.

If($check_status['orders_status'] != GC_STATE_SHIPPED.

&& $check_status['orders_status'] != GC_STATE_SHIPPED_REFUNDED){.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// Cancel the order.

List($curl_status,) = $Grequest->SendCancelOrder($google_order,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED,.

$notify_comments);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CANCEL_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CANCEL_ORDER, 'success');.

}.

}.

Else if($google_order != ''.

&& $check_status['orders_status'] != $status){.

$statuses = array();.

Foreach($orders_statuses as $status_array){.

$statuses[$status_array['id']] = $status_array['text'];.

}.

$messageStack->add_session( sprintf(GOOGLECHECKOUT_ERR_INVALID_STATE_TRANSITION,.

$statuses[$check_status['orders_status']],.

$statuses[$status],.

$statuses[$check_status['orders_status']]),.

'error');.

} .

// Send Buyer's message.

If($cust_notify==1 && isset($notify_comments) && !empty($notify_comments)) {.

$cust_notify_ok = '0';.

If(!((strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH).

&& MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING=='True')){.

List($curl_status,) = $Grequest->sendBuyerMessage($google_order,.

$notify_comments, "true");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MESSAGE_ORDER, 'error');.

$cust_notify_ok = '0';.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MESSAGE_ORDER, 'success');.

$cust_notify_ok = '1';.

}.

If(strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH) {.

$messageStack->add_session(.

Sprintf(GOOGLECHECKOUT_WARNING_CHUNK_MESSAGE, GOOGLE_MESSAGE_LENGTH), 'warning');.

}.

}.

// Cust notified.

Return $cust_notify_ok;.

}.

// Cust notified.

Return '0';.

}.

// ** END GOOGLE CHECKOUT **.

//PayPal WPP Modification START //.

Include(DIR_FS_DOCUMENT_ROOTDIR_WS_INCLUDES'configure.php');.

Include(DIR_WS_CLASSES'order.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

Include(DIR_WS_INCLUDES'paypal_wpp/paypal_wpp_include.php');.

$paypal_wpp = new paypal_wpp_admin;.

//PayPal WPP Modification END //.

$orders_statuses = array();.

$orders_status_array = array();.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

While ($orders_status = tep_db_fetch_array($orders_status_query)) {.

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

'text' => $orders_status['orders_status_name']);.

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

}.

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');.

If (tep_not_null($action)) {.

Switch ($action) {.

Case 'update_order':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);.

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);.

//Package Tracking Plus BEGIN.

$usps_track_num = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num']);.

$usps_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num2']);.

$ups_track_num = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num']);.

$ups_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num2']);.

$fedex_track_num = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num']);.

$fedex_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num2']);.

$dhl_track_num = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num']);.

$dhl_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num2']);.

//Package Tracking Plus END.

$order_updated = false;.

//Package Tracking Plus BEGIN.

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, usps_track_num, usps_track_num2, ups_track_num, ups_track_num2, fedex_track_num, fedex_track_num2, dhl_track_num, dhl_track_num2, date_purchased from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

//Package Tracking Plus END.

If ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {.

Tep_db_query("update "TABLE_ORDERS" set orders_status = '"tep_db_input($status)"', last_modified = now() where orders_id = '"(int)$oID"'");.

// ** GOOGLE CHECKOUT **.

Chdir("./..");.

Require_once(DIR_WS_LANGUAGES$language'/modules/payment/googlecheckout.php');.

$payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE;.

$num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));.

If($num_rows != 0) {.

$customer_notified = google_checkout_state_change($check_status, $status, $oID,.

(@$_POST['notify']=='on'?1:0),.

(@$_POST['notify_comments']=='on'?$comments:''));.

}.

$customer_notified = isset($customer_notified)?$customer_notified:'0';.

// ** END GOOGLE CHECKOUT **.

If (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {.

$notify_comments = '';.

If (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) {.

$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE$comments"\n\n";.

}.

// ** GOOGLE CHECKOUT **.

$force_email = false;.

If($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) {.

$force_email = true;.

$messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');.

}.

If($num_rows == 0 || $force_email) {.

//send emails, not a google order or configured to use both messaging systems.

$email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

Tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);.

$customer_notified = '1';.

//send extra emails.

}.

}.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)"')");.

$order_updated = true;.

}.

//Package Tracking Plus BEGIN.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num = '"tep_db_input($usps_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num2 = '"tep_db_input($usps_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num = '"tep_db_input($ups_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num2 = '"tep_db_input($ups_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num = '"tep_db_input($fedex_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num2 = '"tep_db_input($fedex_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num = '"tep_db_input($dhl_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num2 = '"tep_db_input($dhl_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

$order_updated = true;.

//Package Tracking Plus END.

$order_updated = true;.

/* } */.

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

Case 'deleteconfirm':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

Tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

Break;.

}.

}.

If (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$order_exists = true;.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

//PayPal WPP Modification START //.

//include(DIR_WS_CLASSES'order.php');.

//PayPal WPP Modification END //.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

<script language="javascript" src="includes/general.js"></script>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->add_javascript();.

//PayPal WPP Modification END //.

?>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! header //>.

<?php.

Require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

</table></td>.

<! body_text //>.

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

If (($action == 'edit') && ($order_exists == true)) {.

$order = new order($oID);.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE'<a href="'tep_href_link(FILENAME_CREATE_ORDER)'"> Create order </a>'; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

</table></td>.

</tr>.

<tr>.

<td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td colspan="3"><?php echo tep_draw_separator(); ?></td>.

</tr>.

<tr>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

</tr>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

<td class="main"><?php echo $order->customer['telephone']; ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

<td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

<td class="main"><?php echo $order->info['payment_method']; ?></td>.

</tr>.

<?php.

If (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {.

?>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>.

<td class="main"><?php echo $order->info['cc_type']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>.

<td class="main"><?php echo $order->info['cc_owner']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>.

<td class="main"><?php echo $order->info['cc_number']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>.

<td class="main"><?php echo $order->info['cc_expires']; ?></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

</tr>.

<?php.

For ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

Echo ' <tr class="dataTableRow">'"\n" ..

' <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

If (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

For ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

Echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

If ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

Echo '</i></small></nobr>';.

}.

}.

Echo ' </td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

Echo ' </tr>'"\n";.

}.

?>.

<tr>.

<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

For ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->display_buttons($oID);.

//PayPal WPP Modification END //.

?>.

<tr>.

<td class="main"><table border="1" cellspacing="0" cellpadding="5">.

<tr>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

<?php //PayPal WPP Modification START // ?>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_TRANSACTION_INFO; ?></b></td>.

<?php //PayPal WPP Modification END // ?>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$orders_history_query = tep_db_query("select orders_status_history_id, orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

//PayPal WPP Modification END //.

If (tep_db_num_rows($orders_history_query)) {.

While ($orders_history = tep_db_fetch_array($orders_history_query)) {.

Echo ' <tr>'"\n" ..

' <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

' <td class="smallText" align="center">';.

If ($orders_history['customer_notified'] == '1') {.

Echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

} else {.

Echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

}.

Echo ' <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

' <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

//PayPal WPP Modification START //.

' <td class="smallText">'$paypal_wpp->get_transaction_info($orders_history['orders_status_history_id'])'</td>'"\n" ..

//PayPal WPP Modification END //.

' </tr>'"\n";.

}.

} else {.

Echo ' <tr>'"\n" ..

' <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

<td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<! Package Tracking Plus BEGIN >.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_USPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num', '40', '40', '', $order->info['usps_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num2', '40', '40', '', $order->info['usps_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num2']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_UPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num', '40', '40', '', $order->info['ups_track_num']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num2', '40', '40', '', $order->info['ups_track_num2']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num2']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_FEDEX_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num', '40', '40', '', $order->info['fedex_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num2', '40', '40', '', $order->info['fedex_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_DHL_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num', '40', '40', '', $order->info['dhl_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num2', '40', '40', '', $order->info['dhl_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

</table></td>.

</tr>.

<! Package Tracking Plus END >.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

<td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

</tr>.

</table></td>.

<td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

<! googlecheckout Tracking Number >.

<?php.

// orders_status == STATE_PROCESSING -> Processing before delivery.

If(strpos($order->info['payment_method'], 'Google')!= -1 && $order->info['orders_status'] == GC_STATE_PROCESSING){.

Echo '<td><table border="0" cellpadding="3" cellspacing="0" width="100%">.

<tbody>.

<tr>.

<td style="border-top: 2px solid rgb(255, 255, 255); border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap" colspan="2">.

<b>Shipping Information</b>.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Tracking:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255); border-bottom: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<input name="tracking_number" style="color: rgb(0, 0, 0);" id="trackingBox" size="20" type="text">.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Carrier:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<select name="carrier_select" style="color: rgb(0, 0, 0);" id="carrierSelect">.

<option value="select" selected="selected">.

Select ...

</option>.

<option value="USPS">.

USPS.

</option>.

<option value="DHL">.

DHL.

</option>.

<option value="UPS">.

UPS.

</option>.

<option value="Other">.

Other.

</option>.

<option value="FedEx">.

FedEx.

</option>.

</select>.

</td>.

</tr>.

</tbody>.

</table></td>';.

}.

?>.

<! end googlecheckout Tracking Number >.

</tr>.

</table></td>.

</tr>.

</table></td>.

</form></tr>.

<tr>.

<td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

<?php.

} else {.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

</form></tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

</form></tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

<td class="dataTableHeadingContent" align="center">Order ID</td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

</tr>.

<?php.

If (isset($HTTP_GET_VARS['cID'])) {.

$cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

} elseif (isset($HTTP_GET_VARS['status'])) {.

$status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

} else {.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

}.

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

$orders_query = tep_db_query($orders_query_raw);.

While ($orders = tep_db_fetch_array($orders_query)) {.

If ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

$oInfo = new objectInfo($orders);.

}.

If (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

Echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

} else {.

Echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

}.

?>.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

<td class="dataTableContent" align="center"><?php echo $orders['orders_id']; ?></td>.

<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

<td class="dataTableContent" align="right"><?php if (isset($oInfo).

Comment #10

Personally, I'm MYSQL illiterate..

I can\'t even spell MYSLQ....

I'll have to pass...

Comment #11

Redid the whole order.php page just to make sure, now when I click on orders I get:.

Parse error: syntax error, unexpected $end in /home/axiom/public_html/admin/orders.php on line 826.

Heres the new code:.

<?php.

/*.

$Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $.

OsCommerce, Open Source E-Commerce Solutions.

Http://www.oscommerce.com.

Copyright (c) 2003 osCommerce.

Released under the GNU General Public License.

*/.

Require('includes/application_top.php');.

/* ** GOOGLE CHECKOUT **/.

Define('GC_STATE_NEW', 100);.

Define('GC_STATE_PROCESSING', 101);.

Define('GC_STATE_SHIPPED', 102);.

Define('GC_STATE_REFUNDED', 103);.

Define('GC_STATE_SHIPPED_REFUNDED', 104);.

Define('GC_STATE_CANCELED', 105);.

Function google_checkout_state_change($check_status, $status, $oID,.

$cust_notify, $notify_comments) {.

Global $db,$messageStack, $orders_statuses;.

Define('API_CALLBACK_ERROR_LOG',.

DIR_FS_CATALOG. "/googlecheckout/logs/response_error.log");.

Define('API_CALLBACK_MESSAGE_LOG',.

DIR_FS_CATALOG"/googlecheckout/logs/response_message.log");.

Include_once(DIR_FS_CATALOG.'/includes/modules/payment/googlecheckout.php');.

Include_once(DIR_FS_CATALOG.'/googlecheckout/library/googlerequest.php');.

$googlepayment = new googlecheckout();.

$Grequest = new GoogleRequest($googlepayment->merchantid,.

$googlepayment->merchantkey,.

MODULE_PAYMENT_GOOGLECHECKOUT_MODE==.

'https://sandbox.google.com/checkout/'.

?"sandbox":"production",.

DEFAULT_CURRENCY);.

$Grequest->SetLogFiles(API_CALLBACK_ERROR_LOG, API_CALLBACK_MESSAGE_LOG);.

$google_answer = tep_db_fetch_array(tep_db_query("SELECT go.google_order_number, go.order_amount, o.customers_email_address, gc.buyer_id, o.customers_id.

FROM "$googlepayment->table_order" go.

Inner join "TABLE_ORDERS" o on go.orders_id = o.orders_id.

Inner join "$googlepayment->table_name" gc on gc.customers_id = o.customers_id.

WHERE go.orders_id = '"(int)$oID ."'.

Group by o.customers_id order by o.orders_id desc"));.

$google_order = $google_answer['google_order_number'];.

$amount = $google_answer['order_amount'];.

// If status update is from Google New -> Google Processing on the Admin UI.

// this invokes the processing-order and charge-order commands.

// 1->Google New, 2-> Google Processing.

If($check_status['orders_status'] == GC_STATE_NEW.

&& $status == GC_STATE_PROCESSING && $google_order != '') {.

List($curl_status,) = $Grequest->SendChargeOrder($google_order, $amount);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CHARGE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CHARGE_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendProcessOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_PROCESS_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_PROCESS_ORDER, 'success');.

}.

}.

// If status update is from Google Processing or Google Refunded -> Google Shipped on the Admin UI.

// this invokes the deliver-order and archive-order commands.

// 2->Google Processing or Google Refunded, 3-> Google Shipped (refunded).

Else if(($check_status['orders_status'] == GC_STATE_PROCESSING.

|| $check_status['orders_status'] == GC_STATE_REFUNDED).

&& ($status == GC_STATE_SHIPPED || $status == GC_STATE_SHIPPED_REFUNDED ).

&& $google_order != '') {.

$carrier = $tracking_no = "";.

// Add tracking Data.

If(isset($_POST['carrier_select']) && ($_POST['carrier_select'] != 'select').

&& isset($_POST['tracking_number']) && !empty($_POST['tracking_number'])) {.

$carrier = $_POST['carrier_select'];.

$tracking_no = $_POST['tracking_number'];.

$comments = GOOGLECHECKOUT_STATE_STRING_TRACKING ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_CARRIER$_POST['carrier_select'] ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_NUMBER$_POST['tracking_number']"";.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY".

(orders_id, orders_status_id, date_added, customer_notified, comments).

Values ('"(int)$oID"',.

'"tep_db_input(($check_status['orders_status']==GC_STATE_REFUNDED.

?GC_STATE_SHIPPED_REFUNDED:GC_STATE_SHIPPED))"',.

Now(),.

'"tep_db_input($cust_notify)"',.

'"tep_db_input($comments)"')");.

}.

List($curl_status,) = $Grequest->SendDeliverOrder($google_order, $carrier,.

$tracking_no, ($cust_notify==1)?"true":"false");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_DELIVER_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_DELIVER_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// If status update is to Google Canceled on the Admin UI.

// this invokes the cancel-order and archive-order commands.

Else if($check_status['orders_status'] != GC_STATE_CANCELED &&.

$status == GC_STATE_CANCELED && $google_order != '') {.

If($check_status['orders_status'] != GC_STATE_NEW){.

List($curl_status,) = $Grequest->SendRefundOrder($google_order, 0,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED.

);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_REFUND_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_REFUND_ORDER, 'success');.

}.

}.

Else {.

// Tell google witch is the OSC's internal order Number.

List($curl_status,) = $Grequest->SendMerchantOrderNumber($google_order, $oID);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MERCHANT_ORDER_NUMBER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MERCHANT_ORDER_NUMBER, 'success');.

}.

}.

// Is the order is not archive, I do it.

If($check_status['orders_status'] != GC_STATE_SHIPPED.

&& $check_status['orders_status'] != GC_STATE_SHIPPED_REFUNDED){.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// Cancel the order.

List($curl_status,) = $Grequest->SendCancelOrder($google_order,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED,.

$notify_comments);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CANCEL_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CANCEL_ORDER, 'success');.

}.

}.

Else if($google_order != ''.

&& $check_status['orders_status'] != $status){.

$statuses = array();.

Foreach($orders_statuses as $status_array){.

$statuses[$status_array['id']] = $status_array['text'];.

}.

$messageStack->add_session( sprintf(GOOGLECHECKOUT_ERR_INVALID_STATE_TRANSITION,.

$statuses[$check_status['orders_status']],.

$statuses[$status],.

$statuses[$check_status['orders_status']]),.

'error');.

}.

// Send Buyer's message.

If($cust_notify==1 && isset($notify_comments) && !empty($notify_comments)) {.

$cust_notify_ok = '0';.

If(!((strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH).

&& MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING=='True')){.

List($curl_status,) = $Grequest->sendBuyerMessage($google_order,.

$notify_comments, "true");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MESSAGE_ORDER, 'error');.

$cust_notify_ok = '0';.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MESSAGE_ORDER, 'success');.

$cust_notify_ok = '1';.

}.

If(strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH) {.

$messageStack->add_session(.

Sprintf(GOOGLECHECKOUT_WARNING_CHUNK_MESSAGE, GOOGLE_MESSAGE_LENGTH), 'warning');.

}.

}.

// Cust notified.

Return $cust_notify_ok;.

}.

// Cust notified.

Return '0';.

}.

// ** END GOOGLE CHECKOUT **.

//PayPal WPP Modification START //.

Include(DIR_FS_DOCUMENT_ROOTDIR_WS_INCLUDES'configure.php');.

Include(DIR_WS_CLASSES'order.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

Include(DIR_WS_INCLUDES'paypal_wpp/paypal_wpp_include.php');.

$paypal_wpp = new paypal_wpp_admin;.

//PayPal WPP Modification END //.

$orders_statuses = array();.

$orders_status_array = array();.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

While ($orders_status = tep_db_fetch_array($orders_status_query)) {.

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

'text' => $orders_status['orders_status_name']);.

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

}.

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');.

If (tep_not_null($action)) {.

Switch ($action) {.

Case 'update_order':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);.

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);.

//Package Tracking Plus BEGIN.

$usps_track_num = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num']);.

$usps_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num2']);.

$ups_track_num = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num']);.

$ups_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num2']);.

$fedex_track_num = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num']);.

$fedex_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num2']);.

$dhl_track_num = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num']);.

$dhl_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num2']);.

//Package Tracking Plus END.

$order_updated = false;.

//Package Tracking Plus BEGIN.

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, usps_track_num, usps_track_num2, ups_track_num, ups_track_num2, fedex_track_num, fedex_track_num2, dhl_track_num, dhl_track_num2, date_purchased from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

//Package Tracking Plus END.

If ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {.

Tep_db_query("update "TABLE_ORDERS" set orders_status = '"tep_db_input($status)"', last_modified = now() where orders_id = '"(int)$oID"'");.

// ** GOOGLE CHECKOUT **.

Chdir("./..");.

Require_once(DIR_WS_LANGUAGES$language'/modules/payment/googlecheckout.php');.

$payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE;.

$num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));.

If($num_rows != 0) {.

$customer_notified = google_checkout_state_change($check_status, $status, $oID,.

(@$_POST['notify']=='on'?1:0),.

(@$_POST['notify_comments']=='on'?$comments:''));.

}.

$customer_notified = isset($customer_notified)?$customer_notified:'0';.

// ** END GOOGLE CHECKOUT **.

If (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {.

$notify_comments = '';.

If (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) {.

$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE$comments"\n\n";.

}.

// ** GOOGLE CHECKOUT **.

$force_email = false;.

If($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) {.

$force_email = true;.

$messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');.

}.

If($num_rows == 0 || $force_email) {.

//send emails, not a google order or configured to use both messaging systems.

$email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

Tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);.

$customer_notified = '1';.

//send extra emails.

}.

}.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)"')");.

$order_updated = true;.

}.

//Package Tracking Plus BEGIN.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num = '"tep_db_input($usps_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num2 = '"tep_db_input($usps_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num = '"tep_db_input($ups_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num2 = '"tep_db_input($ups_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num = '"tep_db_input($fedex_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num2 = '"tep_db_input($fedex_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num = '"tep_db_input($dhl_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num2 = '"tep_db_input($dhl_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

$order_updated = true;.

//Package Tracking Plus END.

$order_updated = true;.

/* } */.

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

Case 'deleteconfirm':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

Tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

Break;.

}.

If (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$order_exists = true;.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

//PayPal WPP Modification START //.

//include(DIR_WS_CLASSES'order.php');.

//PayPal WPP Modification END //.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

<script language="javascript" src="includes/general.js"></script>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->add_javascript();.

//PayPal WPP Modification END //.

?>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! header //>.

<?php.

Require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

</table></td>.

<! body_text //>.

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

If (($action == 'edit') && ($order_exists == true)) {.

$order = new order($oID);.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE'<a href="'tep_href_link(FILENAME_CREATE_ORDER)'"> Create order </a>'; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

</table></td>.

</tr>.

<tr>.

<td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td colspan="3"><?php echo tep_draw_separator(); ?></td>.

</tr>.

<tr>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

</tr>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

<td class="main"><?php echo $order->customer['telephone']; ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

<td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

<td class="main"><?php echo $order->info['payment_method']; ?></td>.

</tr>.

<?php.

If (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {.

?>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>.

<td class="main"><?php echo $order->info['cc_type']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>.

<td class="main"><?php echo $order->info['cc_owner']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>.

<td class="main"><?php echo $order->info['cc_number']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>.

<td class="main"><?php echo $order->info['cc_expires']; ?></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

</tr>.

<?php.

For ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

Echo ' <tr class="dataTableRow">'"\n" ..

' <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

If (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

For ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

Echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

If ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

Echo '</i></small></nobr>';.

}.

}.

Echo ' </td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

Echo ' </tr>'"\n";.

}.

?>.

<tr>.

<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

For ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->display_buttons($oID);.

//PayPal WPP Modification END //.

?>.

<tr>.

<td class="main"><table border="1" cellspacing="0" cellpadding="5">.

<tr>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

<?php //PayPal WPP Modification START // ?>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_TRANSACTION_INFO; ?></b></td>.

<?php //PayPal WPP Modification END // ?>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$orders_history_query = tep_db_query("select orders_status_history_id, orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

//PayPal WPP Modification END //.

If (tep_db_num_rows($orders_history_query)) {.

While ($orders_history = tep_db_fetch_array($orders_history_query)) {.

Echo ' <tr>'"\n" ..

' <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

' <td class="smallText" align="center">';.

If ($orders_history['customer_notified'] == '1') {.

Echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

} else {.

Echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

}.

Echo ' <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

' <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

//PayPal WPP Modification START //.

' <td class="smallText">'$paypal_wpp->get_transaction_info($orders_history['orders_status_history_id'])'</td>'"\n" ..

//PayPal WPP Modification END //.

' </tr>'"\n";.

}.

} else {.

Echo ' <tr>'"\n" ..

' <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

<td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<! Package Tracking Plus BEGIN >.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_USPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num', '40', '40', '', $order->info['usps_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num2', '40', '40', '', $order->info['usps_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num2']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_UPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num', '40', '40', '', $order->info['ups_track_num']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num2', '40', '40', '', $order->info['ups_track_num2']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num2']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_FEDEX_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num', '40', '40', '', $order->info['fedex_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num2', '40', '40', '', $order->info['fedex_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_DHL_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num', '40', '40', '', $order->info['dhl_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num2', '40', '40', '', $order->info['dhl_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

</table></td>.

</tr>.

<! Package Tracking Plus END >.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

<td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

</tr>.

</table></td>.

<td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

<! googlecheckout Tracking Number >.

<?php.

// orders_status == STATE_PROCESSING -> Processing before delivery.

If(strpos($order->info['payment_method'], 'Google')!= -1 && $order->info['orders_status'] == GC_STATE_PROCESSING){.

Echo '<td><table border="0" cellpadding="3" cellspacing="0" width="100%">.

<tbody>.

<tr>.

<td style="border-top: 2px solid rgb(255, 255, 255); border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap" colspan="2">.

<b>Shipping Information</b>.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Tracking:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255); border-bottom: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<input name="tracking_number" style="color: rgb(0, 0, 0);" id="trackingBox" size="20" type="text">.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Carrier:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<select name="carrier_select" style="color: rgb(0, 0, 0);" id="carrierSelect">.

<option value="select" selected="selected">.

Select ...

</option>.

<option value="USPS">.

USPS.

</option>.

<option value="DHL">.

DHL.

</option>.

<option value="UPS">.

UPS.

</option>.

<option value="Other">.

Other.

</option>.

<option value="FedEx">.

FedEx.

</option>.

</select>.

</td>.

</tr>.

</tbody>.

</table></td>';.

}.

?>.

<! end googlecheckout Tracking Number >.

</tr>.

</table></td>.

</form></tr>.

<tr>.

<td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

<?php.

} else {.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

</form></tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

</form></tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

<td class="dataTableHeadingContent" align="center">Order ID</td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

</tr>.

<?php.

If (isset($HTTP_GET_VARS['cID'])) {.

$cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

} elseif (isset($HTTP_GET_VARS['status'])) {.

$status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

} else {.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

}.

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

$orders_query = tep_db_query($orders_query_raw);.

While ($orders = tep_db_fetch_array($orders_query)) {.

If ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

$oInfo = new objectInfo($orders);.

}.

If (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

Echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

} else {.

Echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

}.

?>.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

<td class="dataTableContent" align="center"><?php echo $orders['orders_id']; ?></td>.

<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

<td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES'icon_arrow_right.gif', ''); } else { echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_g.

Comment #12

Whenever I try to edit or delete an order it gives a redirect loop error, I am not a coder by any means (hey atleast I admit it -lol), but I have been very careful and doing a backup before editing anything, however I thought I backed this one up, but I did not...

Any help would be great!!!.

Here is my code:.

<?php.

/*.

$Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $.

OsCommerce, Open Source E-Commerce Solutions.

[url="http://www.oscommerce.com"]http://www.oscommerce.com[/url].

Copyright © 2003 osCommerce.

Released under the GNU General Public License.

*/.

Require('includes/application_top.php');.

/* ** GOOGLE CHECKOUT **/.

Define('GC_STATE_NEW', 100);.

Define('GC_STATE_PROCESSING', 101);.

Define('GC_STATE_SHIPPED', 102);.

Define('GC_STATE_REFUNDED', 103);.

Define('GC_STATE_SHIPPED_REFUNDED', 104);.

Define('GC_STATE_CANCELED', 105);.

Function google_checkout_state_change($check_status, $status, $oID,.

$cust_notify, $notify_comments) {.

Global $db,$messageStack, $orders_statuses;.

Define('API_CALLBACK_ERROR_LOG',.

DIR_FS_CATALOG. "/googlecheckout/logs/response_error.log");.

Define('API_CALLBACK_MESSAGE_LOG',.

DIR_FS_CATALOG"/googlecheckout/logs/response_message.log");.

Include_once(DIR_FS_CATALOG.'/includes/modules/payment/googlecheckout.php');.

Include_once(DIR_FS_CATALOG.'/googlecheckout/library/googlerequest.php');.

$googlepayment = new googlecheckout();.

$Grequest = new GoogleRequest($googlepayment->merchantid,.

$googlepayment->merchantkey,.

MODULE_PAYMENT_GOOGLECHECKOUT_MODE==.

'https://sandbox.google.com/checkout/'.

?"sandbox":"production",.

DEFAULT_CURRENCY);.

$Grequest->SetLogFiles(API_CALLBACK_ERROR_LOG, API_CALLBACK_MESSAGE_LOG);.

$google_answer = tep_db_fetch_array(tep_db_query("SELECT go.google_order_number, go.order_amount, o.customers_email_address, gc.buyer_id, o.customers_id.

FROM "$googlepayment->table_order" go.

Inner join "TABLE_ORDERS" o on go.orders_id = o.orders_id.

Inner join "$googlepayment->table_name" gc on gc.customers_id = o.customers_id.

WHERE go.orders_id = '"(int)$oID ."'.

Group by o.customers_id order by o.orders_id desc"));.

$google_order = $google_answer['google_order_number'];.

$amount = $google_answer['order_amount'];.

// If status update is from Google New -> Google Processing on the Admin UI.

// this invokes the processing-order and charge-order commands.

// 1->Google New, 2-> Google Processing.

If($check_status['orders_status'] == GC_STATE_NEW.

&& $status == GC_STATE_PROCESSING && $google_order != '') {.

List($curl_status,) = $Grequest->SendChargeOrder($google_order, $amount);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CHARGE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CHARGE_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendProcessOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_PROCESS_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_PROCESS_ORDER, 'success');.

}.

}.

// If status update is from Google Processing or Google Refunded -> Google Shipped on the Admin UI.

// this invokes the deliver-order and archive-order commands.

// 2->Google Processing or Google Refunded, 3-> Google Shipped (refunded).

Else if(($check_status['orders_status'] == GC_STATE_PROCESSING.

|| $check_status['orders_status'] == GC_STATE_REFUNDED).

&& ($status == GC_STATE_SHIPPED || $status == GC_STATE_SHIPPED_REFUNDED ).

&& $google_order != '') {.

$carrier = $tracking_no = "";.

// Add tracking Data.

If(isset($_POST['carrier_select']) && ($_POST['carrier_select'] != 'select').

&& isset($_POST['tracking_number']) && !empty($_POST['tracking_number'])) {.

$carrier = $_POST['carrier_select'];.

$tracking_no = $_POST['tracking_number'];.

$comments = GOOGLECHECKOUT_STATE_STRING_TRACKING ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_CARRIER$_POST['carrier_select'] ."\n" ..

GOOGLECHECKOUT_STATE_STRING_TRACKING_NUMBER$_POST['tracking_number']"";.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY".

(orders_id, orders_status_id, date_added, customer_notified, comments).

Values ('"(int)$oID"',.

'"tep_db_input(($check_status['orders_status']==GC_STATE_REFUNDED.

?GC_STATE_SHIPPED_REFUNDED:GC_STATE_SHIPPED))"',.

Now(),.

'"tep_db_input($cust_notify)"',.

'"tep_db_input($comments)"')");.

}.

List($curl_status,) = $Grequest->SendDeliverOrder($google_order, $carrier,.

$tracking_no, ($cust_notify==1)?"true":"false");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_DELIVER_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_DELIVER_ORDER, 'success');.

}.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// If status update is to Google Canceled on the Admin UI.

// this invokes the cancel-order and archive-order commands.

Else if($check_status['orders_status'] != GC_STATE_CANCELED &&.

$status == GC_STATE_CANCELED && $google_order != '') {.

If($check_status['orders_status'] != GC_STATE_NEW){.

List($curl_status,) = $Grequest->SendRefundOrder($google_order, 0,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED.

);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_REFUND_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_REFUND_ORDER, 'success');.

}.

}.

Else {.

// Tell google witch is the OSC's internal order Number.

List($curl_status,) = $Grequest->SendMerchantOrderNumber($google_order, $oID);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MERCHANT_ORDER_NUMBER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MERCHANT_ORDER_NUMBER, 'success');.

}.

}.

// Is the order is not archive, I do it.

If($check_status['orders_status'] != GC_STATE_SHIPPED.

&& $check_status['orders_status'] != GC_STATE_SHIPPED_REFUNDED){.

List($curl_status,) = $Grequest->SendArchiveOrder($google_order);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_ARCHIVE_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_ARCHIVE_ORDER, 'success');.

}.

}.

// Cancel the order.

List($curl_status,) = $Grequest->SendCancelOrder($google_order,.

GOOGLECHECKOUT_STATE_STRING_ORDER_CANCELED,.

$notify_comments);.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_CANCEL_ORDER, 'error');.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_CANCEL_ORDER, 'success');.

}.

}.

Else if($google_order != ''.

&& $check_status['orders_status'] != $status){.

$statuses = array();.

Foreach($orders_statuses as $status_array){.

$statuses[$status_array['id']] = $status_array['text'];.

}.

$messageStack->add_session( sprintf(GOOGLECHECKOUT_ERR_INVALID_STATE_TRANSITION,.

$statuses[$check_status['orders_status']],.

$statuses[$status],.

$statuses[$check_status['orders_status']]),.

'error');.

}.

// Send Buyer's message.

If($cust_notify==1 && isset($notify_comments) && !empty($notify_comments)) {.

$cust_notify_ok = '0';.

If(!((strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH).

&& MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING=='True')){.

List($curl_status,) = $Grequest->sendBuyerMessage($google_order,.

$notify_comments, "true");.

If($curl_status != 200) {.

$messageStack->add_session(GOOGLECHECKOUT_ERR_SEND_MESSAGE_ORDER, 'error');.

$cust_notify_ok = '0';.

}.

Else {.

$messageStack->add_session(GOOGLECHECKOUT_SUCCESS_SEND_MESSAGE_ORDER, 'success');.

$cust_notify_ok = '1';.

}.

If(strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH) {.

$messageStack->add_session(.

Sprintf(GOOGLECHECKOUT_WARNING_CHUNK_MESSAGE, GOOGLE_MESSAGE_LENGTH), 'warning');.

}.

}.

// Cust notified.

Return $cust_notify_ok;.

}.

// Cust notified.

Return '0';.

}.

// ** END GOOGLE CHECKOUT **.

//PayPal WPP Modification START //.

Include(DIR_FS_DOCUMENT_ROOTDIR_WS_INCLUDES'configure.php');.

Include(DIR_WS_CLASSES'order.php');.

Require(DIR_WS_CLASSES'currencies.php');.

$currencies = new currencies();.

Include(DIR_WS_INCLUDES'paypal_wpp/paypal_wpp_include.php');.

$paypal_wpp = new paypal_wpp_admin;.

//PayPal WPP Modification END //.

$orders_statuses = array();.

$orders_status_array = array();.

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

While ($orders_status = tep_db_fetch_array($orders_status_query)) {.

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

'text' => $orders_status['orders_status_name']);.

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

}.

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');.

If (tep_not_null($action)) {.

Switch ($action) {.

Case 'update_order':.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);.

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);.

//Package Tracking Plus BEGIN.

$usps_track_num = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num']);.

$usps_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['usps_track_num2']);.

$ups_track_num = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num']);.

$ups_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['ups_track_num2']);.

$fedex_track_num = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num']);.

$fedex_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['fedex_track_num2']);.

$dhl_track_num = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num']);.

$dhl_track_num2 = tep_db_prepare_input($HTTP_POST_VARS['dhl_track_num2']);.

//Package Tracking Plus END.

$order_updated = false;.

//Package Tracking Plus BEGIN.

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, usps_track_num, usps_track_num2, ups_track_num, ups_track_num2, fedex_track_num, fedex_track_num2, dhl_track_num, dhl_track_num2, date_purchased from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

//Package Tracking Plus END.

If ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {.

Tep_db_query("update "TABLE_ORDERS" set orders_status = '"tep_db_input($status)"', last_modified = now() where orders_id = '"(int)$oID"'");.

// ** GOOGLE CHECKOUT **.

Chdir("./..");.

Require_once(DIR_WS_LANGUAGES$language'/modules/payment/googlecheckout.php');.

$payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE;.

$num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));.

If($num_rows != 0) {.

$customer_notified = google_checkout_state_change($check_status, $status, $oID,.

(@$_POST['notify']=='on'?1:0),.

(@$_POST['notify_comments']=='on'?$comments:''));.

}.

$customer_notified = isset($customer_notified)?$customer_notified:'0';.

// ** END GOOGLE CHECKOUT **.

If (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {.

$notify_comments = '';.

If (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) {.

$notify_comments = EMAIL_TEXT_COMMENTS_UPDATE$comments"\n\n";.

}.

// ** GOOGLE CHECKOUT **.

$force_email = false;.

If($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) {.

$force_email = true;.

$messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');.

}.

If($num_rows == 0 || $force_email) {.

//send emails, not a google order or configured to use both messaging systems.

$email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

Tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);.

$customer_notified = '1';.

//send extra emails.

}.

}.

Tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)"')");.

$order_updated = true;.

}.

//Package Tracking Plus BEGIN.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num = '"tep_db_input($usps_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set usps_track_num2 = '"tep_db_input($usps_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num = '"tep_db_input($ups_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set ups_track_num2 = '"tep_db_input($ups_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num = '"tep_db_input($fedex_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set fedex_track_num2 = '"tep_db_input($fedex_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num = '"tep_db_input($dhl_track_num)"' where orders_id = '"tep_db_input($oID)"'");.

Tep_db_query("update "TABLE_ORDERS" set dhl_track_num2 = '"tep_db_input($dhl_track_num2)"' where orders_id = '"tep_db_input($oID)"'");.

$order_updated = true;.

//Package Tracking Plus END.

$order_updated = true;.

}.

If ($order_updated == true) {.

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

} else {.

$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

}.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

Break;.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

Tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

Tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

Break;.

}.

If (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

$orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$order_exists = true;.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

//PayPal WPP Modification START //.

//include(DIR_WS_CLASSES'order.php');.

//PayPal WPP Modification END //.

?>.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">.

<script language="javascript" src="includes/general.js"></script>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->add_javascript();.

//PayPal WPP Modification END //.

?>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! header //>.

<?php.

Require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

<tr>.

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

</table></td>.

<! body_text //>.

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

If (($action == 'edit') && ($order_exists == true)) {.

$order = new order($oID);.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE'<a href="'tep_href_link(FILENAME_CREATE_ORDER)'"> Create order </a>'; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

</table></td>.

</tr>.

<tr>.

<td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td colspan="3"><?php echo tep_draw_separator(); ?></td>.

</tr>.

<tr>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

</tr>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

<td class="main"><?php echo $order->customer['telephone']; ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

<td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

<td class="main"><?php echo $order->info['payment_method']; ?></td>.

</tr>.

<?php.

If (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {.

?>.

<tr>.

<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>.

<td class="main"><?php echo $order->info['cc_type']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>.

<td class="main"><?php echo $order->info['cc_owner']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>.

<td class="main"><?php echo $order->info['cc_number']; ?></td>.

</tr>.

<tr>.

<td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>.

<td class="main"><?php echo $order->info['cc_expires']; ?></td>.

</tr>.

<?php.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

</tr>.

<?php.

For ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

Echo ' <tr class="dataTableRow">'"\n" ..

' <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

If (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

For ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

Echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

If ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

Echo '</i></small></nobr>';.

}.

}.

Echo ' </td>'"\n" ..

' <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

' <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

Echo ' </tr>'"\n";.

}.

?>.

<tr>.

<td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

For ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

Echo ' <tr>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

' <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$paypal_wpp->display_buttons($oID);.

//PayPal WPP Modification END //.

?>.

<tr>.

<td class="main"><table border="1" cellspacing="0" cellpadding="5">.

<tr>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

<?php //PayPal WPP Modification START // ?>.

<td class="smallText" align="center"><b><?php echo TABLE_HEADING_TRANSACTION_INFO; ?></b></td>.

<?php //PayPal WPP Modification END // ?>.

</tr>.

<?php.

//PayPal WPP Modification START //.

$orders_history_query = tep_db_query("select orders_status_history_id, orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

//PayPal WPP Modification END //.

If (tep_db_num_rows($orders_history_query)) {.

While ($orders_history = tep_db_fetch_array($orders_history_query)) {.

Echo ' <tr>'"\n" ..

' <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

' <td class="smallText" align="center">';.

If ($orders_history['customer_notified'] == '1') {.

Echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

} else {.

Echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

}.

Echo ' <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

' <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

//PayPal WPP Modification START //.

' <td class="smallText">'$paypal_wpp->get_transaction_info($orders_history['orders_status_history_id'])'</td>'"\n" ..

//PayPal WPP Modification END //.

' </tr>'"\n";.

}.

} else {.

Echo ' <tr>'"\n" ..

' <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

' </tr>'"\n";.

}.

?>.

</table></td>.

</tr>.

<tr>.

<td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

</tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

<td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

</tr>.

<tr>.

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<! Package Tracking Plus BEGIN >.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_USPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num', '40', '40', '', $order->info['usps_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('usps_track_num2', '40', '40', '', $order->info['usps_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num2']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_UPS_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num', '40', '40', '', $order->info['ups_track_num']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('ups_track_num2', '40', '40', '', $order->info['ups_track_num2']); ?></td>.

<td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num2']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_FEDEX_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num', '40', '40', '', $order->info['fedex_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('fedex_track_num2', '40', '40', '', $order->info['fedex_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo TABLE_HEADING_DHL_TRACKING; ?></b></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num', '40', '40', '', $order->info['dhl_track_num']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

<td class="main"><?php echo tep_draw_textbox_field('dhl_track_num2', '40', '40', '', $order->info['dhl_track_num2']); ?></td>.

<td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td>.

</tr>.

<tr>.

<td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

</tr>.

</table></td>.

</tr>.

<! Package Tracking Plus END >.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td><table border="0" cellspacing="0" cellpadding="2">.

<tr>.

<td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

</tr>.

<tr>.

<td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

<td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

</tr>.

</table></td>.

<td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

<! googlecheckout Tracking Number >.

<?php.

// orders_status == STATE_PROCESSING -> Processing before delivery.

If(strpos($order->info['payment_method'], 'Google')!= -1 && $order->info['orders_status'] == GC_STATE_PROCESSING){.

Echo '<td><table border="0" cellpadding="3" cellspacing="0" width="100%">.

<tbody>.

<tr>.

<td style="border-top: 2px solid rgb(255, 255, 255); border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap" colspan="2">.

<b>Shipping Information</b>.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Tracking:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255); border-bottom: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<input name="tracking_number" style="color: rgb(0, 0, 0);" id="trackingBox" size="20" type="text">.

</td>.

</tr>.

<tr>.

<td nowrap="nowrap" valign="middle" width="1%">.

<font size="2">.

<b>Carrier:</b>.

</font>.

</td>.

<td style="border-right: 2px solid rgb(255, 255, 255);" nowrap="nowrap">.

<select name="carrier_select" style="color: rgb(0, 0, 0);" id="carrierSelect">.

<option value="select" selected="selected">.

Select ...

</option>.

<option value="USPS">.

USPS.

</option>.

<option value="DHL">.

DHL.

</option>.

<option value="UPS">.

UPS.

</option>.

<option value="Other">.

Other.

</option>.

<option value="FedEx">.

FedEx.

</option>.

</select>.

</td>.

</tr>.

</tbody>.

</table></td>';.

}.

?>.

<! end googlecheckout Tracking Number >.

</tr>.

</table></td>.

</form></tr>.

<tr>.

<td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_EDIT, 'oID='$_GET['oID'])'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$_GET['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a> '; ?></td>.

&nbsp;</tr>.

<?php.

} else {.

?>.

<tr>.

<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

<td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

</form></tr>.

<tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

</form></tr>.

</table></td>.

</tr>.

</table></td>.

</tr>.

<tr>.

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<tr>.

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr class="dataTableHeadingRow">.

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

<td class="dataTableHeadingContent" align="center">Order ID</td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

<td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

</tr>.

<?php.

If (isset($HTTP_GET_VARS['cID'])) {.

$cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

} elseif (isset($HTTP_GET_VARS['status'])) {.

$status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

} else {.

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

}.

$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

$orders_query = tep_db_query($orders_query_raw);.

While ($orders = tep_db_fetch_array($orders_query)) {.

If ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

$oInfo = new objectInfo($orders);.

}.

If (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

Echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

} else {.

Echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

}.

?>.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

<td class="dataTableContent" align="center"><?php echo $orders['orders_id']; ?></td>.

<td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

<td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

<td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES'icon_arrow_right.gif', ''); } else { echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'">'tep_image(DIR_WS_IMAGES'icon_info.gif', IMAGE_ICON_INFO)'</a>'; } ?>&nbsp;</td>.

</tr>.

<?php.

}.

?>.

<tr>.

<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<tr>.

<td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>.

<td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>.

</tr>.

</table></td>.

</tr>.

</table></td>.

<?php.

$heading = array();.

$contents = array();.

Switch ($action) {.

Case 'delete':.

$heading[] = array('text' => '<b>'TEXT_INFO_HEADING_DELETE_ORDER'</b>');.

$contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=deleteconfirm'));.

$contents[] = array('text' => TEXT_INFO_DELETE_INTRO'<br><br><b>'$cInfo->customers_firstname' '$cInfo->customers_lastname'</b>');.

$contents[] = array('text' => '<br>'tep_draw_checkbox_field('restock')' 'TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);.

$contents[] = array('align' => 'center', 'text' => '<br>'tep_image_submit('button_delete.gif', IMAGE_DELETE)' <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id)'">'tep_image_button('button_cancel.gif', IMAGE_CANCEL)'</a>');.

Break;.

Default:.

If (isset($oInfo) && is_object($oInfo)) {.

$heading[] = array('text' => '<b>['$oInfo->orders_id']&nbsp;&nbsp;'tep_datetime_short($oInfo->date_purchased)'</b>');.

$contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=delete')'">'tep_image_button('button_delete.gif', IMAGE_DELETE)'</a>');.

$contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS_INVOICE, &#.

Comment #13


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.