echo smn_image(DIR_WS_IMAGES . 'table_background_history.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?> </td> </tr> </table></td> </tr> <tr> <td><?php echo smn_draw_separator('pixel_trans.gif', '100%', '10'); ?> </td> </tr> <tr> <td> <?php $orders_total = smn_count_customer_orders(); if ($orders_total > 0) { $history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int) $customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int) $languages_id . "' and s.public_flag = '1' and o.orders_status != '99999' order by orders_id DESC"; $history_split = new splitPageResults($history_query_raw, MAX_DISPLAY_ORDER_HISTORY); $history_query = smn_db_query($history_split->sql_query); while ($history = smn_db_fetch_array($history_query)) { $products_query = smn_db_query("select count(*) as count from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int) $history['orders_id'] . "'"); $products = smn_db_fetch_array($products_query); if (smn_not_null($history['delivery_name'])) { $order_type = TEXT_ORDER_SHIPPED_TO; $order_name = $history['delivery_name']; } else { $order_type = TEXT_ORDER_BILLED_TO; $order_name = $history['billing_name']; } ?>
?> <tr> <td><?php echo $messageStack->output('account'); ?> </td> </tr> <tr> <td><?php echo smn_draw_separator('pixel_trans.gif', '100%', '10'); ?> </td> </tr> <?php } if (smn_count_customer_orders() > 0) { ?> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo OVERVIEW_TITLE; ?> </b></td> <td class="main"><?php echo '<a href="' . smn_href_link(FILENAME_ACCOUNT_HISTORY, '', 'NONSSL') . '"><u>' . OVERVIEW_SHOW_ALL_ORDERS . '</u></a>'; ?> </td> </tr> </table></td> </tr>