osCommerce
Docs :: PHP Cross Reference For osCommerce 2.2 MS2
Provided By OSCdox.com
Provided By OSCdox.com
| [ Index ] | osCommerce
Docs :: PHP Cross Reference For osCommerce 2.2 MS2 Provided By OSCdox.com |
1 <?php 2 /* 3 $Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $ 4 5 osCommerce, Open Source E-Commerce Solutions 6 http://www.oscommerce.com 7 8 Copyright (c) 2003 osCommerce 9 10 Released under the GNU General Public License 11 */ 12 13 require ('includes/application_top.php'); 14 15 require (DIR_WS_CLASSES . 'currencies.php'); 16 $currencies = new currencies(); 17 18 $orders_statuses = array(); 19 $orders_status_array = array(); 20 $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'"); 21 while ($orders_status = tep_db_fetch_array($orders_status_query)) { 22 $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 23 'text' => $orders_status['orders_status_name']); 24 $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; 25 } 26 27 $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); 28 29 if (tep_not_null($action)) { 30 switch ($action) { 31 case 'update_order': 32 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); 33 $status = tep_db_prepare_input($HTTP_POST_VARS['status']); 34 $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']); 35 36 $order_updated = false; 37 $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); 38 $check_status = tep_db_fetch_array($check_status_query); 39 40 if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { 41 tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'"); 42 43 $customer_notified = '0'; 44 if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) { 45 $notify_comments = ''; 46 if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) { 47 $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n"; 48 } 49 50 $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_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); 51 52 tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); 53 54 $customer_notified = '1'; 55 } 56 57 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) . "')"); 58 59 $order_updated = true; 60 } 61 62 if ($order_updated == true) { 63 $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); 64 } else { 65 $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning'); 66 } 67 68 tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit')); 69 break; 70 case 'deleteconfirm': 71 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); 72 73 tep_remove_order($oID, $HTTP_POST_VARS['restock']); 74 75 tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')))); 76 break; 77 } 78 } 79 80 if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) { 81 $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); 82 83 $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); 84 $order_exists = true; 85 if (!tep_db_num_rows($orders_query)) { 86 $order_exists = false; 87 $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error'); 88 } 89 } 90 91 include (DIR_WS_CLASSES . 'order.php'); 92 ?> 93 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 94 <html <?php echo HTML_PARAMS; ?>> 95 <head> 96 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 97 <title><?php echo TITLE; ?></title> 98 <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> 99 <script language="javascript" src="includes/general.js"></script> 100 </head> 101 <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> 102 <!-- header //--> 103 <?php 104 require (DIR_WS_INCLUDES . 'header.php'); 105 ?> 106 <!-- header_eof //--> 107 108 <!-- body //--> 109 <table border="0" width="100%" cellspacing="2" cellpadding="2"> 110 <tr> 111 <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> 112 <!-- left_navigation //--> 113 <?php require (DIR_WS_INCLUDES . 'column_left.php'); ?> 114 <!-- left_navigation_eof //--> 115 </table></td> 116 <!-- body_text //--> 117 <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> 118 <?php 119 if (($action == 'edit') && ($order_exists == true)) { 120 $order = new order($oID); 121 ?> 122 <tr> 123 <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 124 <tr> 125 <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 126 <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td> 127 <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> 128 </tr> 129 </table></td> 130 </tr> 131 <tr> 132 <td><table width="100%" border="0" cellspacing="0" cellpadding="2"> 133 <tr> 134 <td colspan="3"><?php echo tep_draw_separator(); ?></td> 135 </tr> 136 <tr> 137 <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> 138 <tr> 139 <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td> 140 <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td> 141 </tr> 142 <tr> 143 <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> 144 </tr> 145 <tr> 146 <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td> 147 <td class="main"><?php echo $order->customer['telephone']; ?></td> 148 </tr> 149 <tr> 150 <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td> 151 <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td> 152 </tr> 153 </table></td> 154 <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> 155 <tr> 156 <td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td> 157 <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td> 158 </tr> 159 </table></td> 160 <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2"> 161 <tr> 162 <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td> 163 <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td> 164 </tr> 165 </table></td> 166 </tr> 167 </table></td> 168 </tr> 169 <tr> 170 <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 171 </tr> 172 <tr> 173 <td><table border="0" cellspacing="0" cellpadding="2"> 174 <tr> 175 <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> 176 <td class="main"><?php echo $order->info['payment_method']; ?></td> 177 </tr> 178 <?php 179 if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) { 180 ?> 181 <tr> 182 <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 183 </tr> 184 <tr> 185 <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td> 186 <td class="main"><?php echo $order->info['cc_type']; ?></td> 187 </tr> 188 <tr> 189 <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td> 190 <td class="main"><?php echo $order->info['cc_owner']; ?></td> 191 </tr> 192 <tr> 193 <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td> 194 <td class="main"><?php echo $order->info['cc_number']; ?></td> 195 </tr> 196 <tr> 197 <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td> 198 <td class="main"><?php echo $order->info['cc_expires']; ?></td> 199 </tr> 200 <?php 201 } 202 ?> 203 </table></td> 204 </tr> 205 <tr> 206 <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 207 </tr> 208 <tr> 209 <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> 210 <tr class="dataTableHeadingRow"> 211 <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td> 212 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> 213 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td> 214 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td> 215 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td> 216 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td> 217 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td> 218 </tr> 219 <?php 220 for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { 221 echo ' <tr class="dataTableRow">' . "\n" . 222 ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" . 223 ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; 224 225 if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) { 226 for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { 227 echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; 228 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']) . ')'; 229 echo '</i></small></nobr>'; 230 } 231 } 232 233 echo ' </td>' . "\n" . 234 ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" . 235 ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" . 236 ' <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" . 237 ' <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" . 238 ' <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" . 239 ' <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"; 240 echo ' </tr>' . "\n"; 241 } 242 ?> 243 <tr> 244 <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2"> 245 <?php 246 for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { 247 echo ' <tr>' . "\n" . 248 ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . 249 ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . 250 ' </tr>' . "\n"; 251 } 252 ?> 253 </table></td> 254 </tr> 255 </table></td> 256 </tr> 257 <tr> 258 <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 259 </tr> 260 <tr> 261 <td class="main"><table border="1" cellspacing="0" cellpadding="5"> 262 <tr> 263 <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td> 264 <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td> 265 <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td> 266 <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td> 267 </tr> 268 <?php 269 $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added"); 270 if (tep_db_num_rows($orders_history_query)) { 271 while ($orders_history = tep_db_fetch_array($orders_history_query)) { 272 echo ' <tr>' . "\n" . 273 ' <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" . 274 ' <td class="smallText" align="center">'; 275 if ($orders_history['customer_notified'] == '1') { 276 echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n"; 277 } else { 278 echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n"; 279 } 280 echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" . 281 ' <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" . 282 ' </tr>' . "\n"; 283 } 284 } else { 285 echo ' <tr>' . "\n" . 286 ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . 287 ' </tr>' . "\n"; 288 } 289 ?> 290 </table></td> 291 </tr> 292 <tr> 293 <td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td> 294 </tr> 295 <tr> 296 <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> 297 </tr> 298 <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order'); ?> 299 <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td> 300 </tr> 301 <tr> 302 <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 303 </tr> 304 <tr> 305 <td><table border="0" cellspacing="0" cellpadding="2"> 306 <tr> 307 <td><table border="0" cellspacing="0" cellpadding="2"> 308 <tr> 309 <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td> 310 </tr> 311 <tr> 312 <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td> 313 <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td> 314 </tr> 315 </table></td> 316 <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td> 317 </tr> 318 </table></td> 319 </form></tr> 320 <tr> 321 <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['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> 322 </tr> 323 <?php 324 } else { 325 ?> 326 <tr> 327 <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 328 <tr> 329 <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 330 <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td> 331 <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 332 <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?> 333 <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td> 334 </form></tr> 335 <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?> 336 <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> 337 </form></tr> 338 </table></td> 339 </tr> 340 </table></td> 341 </tr> 342 <tr> 343 <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> 344 <tr> 345 <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> 346 <tr class="dataTableHeadingRow"> 347 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td> 348 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td> 349 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td> 350 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td> 351 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> 352 </tr> 353 <?php 354 if (isset($HTTP_GET_VARS['cID'])) { 355 $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); 356 $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"; 357 } elseif (isset($HTTP_GET_VARS['status'])) { 358 $status = tep_db_prepare_input($HTTP_GET_VARS['status']); 359 $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"; 360 } else { 361 $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"; 362 } 363 $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows); 364 $orders_query = tep_db_query($orders_query_raw); 365 while ($orders = tep_db_fetch_array($orders_query)) { 366 if ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) { 367 $oInfo = new objectInfo($orders); 368 } 369 370 if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { 371 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"; 372 } else { 373 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"; 374 } 375 ?> 376 <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> ' . $orders['customers_name']; ?></td> 377 <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td> 378 <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td> 379 <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td> 380 <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>'; } ?> </td> 381 </tr> 382 <?php 383 } 384 ?> 385 <tr> 386 <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2"> 387 <tr> 388 <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> 389 <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> 390 </tr> 391 </table></td> 392 </tr> 393 </table></td> 394 <?php 395 $heading = array(); 396 $contents = array(); 397 398 switch ($action) { 399 case 'delete': 400 $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>'); 401 402 $contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm')); 403 $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br><br><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>'); 404 $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY); 405 $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>'); 406 break; 407 default: 408 if (isset($oInfo) && is_object($oInfo)) { 409 $heading[] = array('text' => '<b>[' . $oInfo->orders_id . '] ' . tep_datetime_short($oInfo->date_purchased) . '</b>'); 410 411 $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>'); 412 $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>'); 413 $contents[] = array('text' => '<br>' . TEXT_DATE_ORDER_CREATED . ' ' . tep_date_short($oInfo->date_purchased)); 414 if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . tep_date_short($oInfo->last_modified)); 415 $contents[] = array('text' => '<br>' . TEXT_INFO_PAYMENT_METHOD . ' ' . $oInfo->payment_method); 416 } 417 break; 418 } 419 420 if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { 421 echo ' <td width="25%" valign="top">' . "\n"; 422 423 $box = new box; 424 echo $box->infoBox($heading, $contents); 425 426 echo ' </td>' . "\n"; 427 } 428 ?> 429 </tr> 430 </table></td> 431 </tr> 432 <?php 433 } 434 ?> 435 </table></td> 436 <!-- body_text_eof //--> 437 </tr> 438 </table> 439 <!-- body_eof //--> 440 441 <!-- footer //--> 442 <?php require (DIR_WS_INCLUDES . 'footer.php'); ?> 443 <!-- footer_eof //--> 444 <br> 445 </body> 446 </html> 447 <?php require (DIR_WS_INCLUDES . 'application_bottom.php'); ?>
title
Description
Body
title
Description
Body
| Generated: Tue Nov 4 23:53:39 2003 | Hosted By :: AABox.com |
Cross-referenced by PHPXref 0.4 |