} } // Order History $history_block = ''; //DokuMan - 2010-09-18 - set undefined variable $statuses_query = xtc_db_query("-- /account_history_info.php\n SELECT os.orders_status_name,\n osh.date_added,\n osh.comments,\n osh.comments_sent\n FROM " . TABLE_ORDERS_STATUS . " os,\n " . TABLE_ORDERS_STATUS_HISTORY . " osh\n WHERE osh.orders_id = '" . $order->info['order_id'] . "'\n AND osh.customer_notified = 1\n AND osh.orders_status_id = os.orders_status_id\n AND os.language_id = '" . (int) $_SESSION['languages_id'] . "'\n ORDER BY osh.date_added"); while ($statuses = xtc_db_fetch_array($statuses_query)) { $history_block .= xtc_date_short($statuses['date_added']) . ' <strong>' . $statuses['orders_status_name'] . '</strong> ' . (empty($statuses['comments']) || empty($statuses['comments_sent']) ? ' ' : nl2br(encode_htmlspecialchars($statuses['comments']))) . '<br />'; } $smarty->assign('HISTORY_BLOCK', $history_block); // Download-Products if (DOWNLOAD_ENABLED == 'true') { include DIR_WS_MODULES . 'downloads.php'; } require_once DIR_FS_INC . 'xtc_get_tracking_link.php'; $smarty->assign('TRACKING_LINKS', xtc_get_tracking_link($order->info['order_id'])); // --- bof -- ipdfbill -------- require 'admin/includes/ipdfbill/pdfbill_lib.php'; // pdfbill $pdffile = 'admin/' . PDFBILL_FOLDER . PDFBILL_PREFIX . ($_GET['order_id'] . '.pdf'); if (file_exists($pdffile)) { $pdflink = xtc_href_link(FILENAME_PDFBILL_DISPLAY, 'oID=' . $_GET['order_id']); $pdflink = sprintf('<a href="%s">' . PDFBILL_DOWNLOAD_INVOICE . '</a>', $pdflink); $smarty->assign('IPDFBILL_INVOICE_DOWNLOAD', $pdflink); } // --- eof -- ipdfbill -------- // Stuff $smarty->assign('ORDER_NUMBER', $order->info['order_id']); //DokuMan - 2011-08-31 - fix order_id assignment $smarty->assign('ORDER_DATE', xtc_date_long($order->info['date_purchased'])); $smarty->assign('ORDER_STATUS', $order->info['orders_status']);
$history_query_raw = "select o.orders_id, \n o.date_purchased,\n o.delivery_name,\n o.billing_name,\n ot.text as order_total,\n s.orders_status_name\n from " . TABLE_ORDERS . " o,\n " . TABLE_ORDERS_TOTAL . " ot,\n " . TABLE_ORDERS_STATUS . " s \n where o.customers_id = " . (int) $_SESSION['customer_id'] . "\n and o.orders_id = ot.orders_id\n and ot.class = 'ot_total'\n and o.orders_status = s.orders_status_id\n and s.language_id = " . (int) $_SESSION['languages_id'] . "\n order by orders_id DESC"; $history_split = new splitPageResults($history_query_raw, isset($_GET['page']) ? $_GET['page'] : 0, MAX_DISPLAY_ORDER_HISTORY); $history_query = xtc_db_query($history_split->sql_query); while ($history = xtc_db_fetch_array($history_query)) { $products_query = xtc_db_query("select count(*) as count from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . $history['orders_id'] . "'"); $products = xtc_db_fetch_array($products_query); if (xtc_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']; } $module_content[] = array('ORDER_ID' => $history['orders_id'], 'ORDER_STATUS' => $history['orders_status_name'], 'ORDER_DATE' => xtc_date_long($history['date_purchased']), 'ORDER_PRODUCTS' => $products['count'], 'ORDER_TOTAL' => strip_tags($history['order_total']), 'ORDER_BUTTON' => '<a href="' . xtc_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'page=' . (empty($_GET['page']) ? "1" : (int) $_GET['page']) . '&order_id=' . $history['orders_id'], 'SSL') . '">' . xtc_image_button('small_view.gif', SMALL_IMAGE_BUTTON_VIEW) . '</a>'); require_once DIR_FS_INC . 'xtc_get_tracking_link.php'; $module_content[count($module_content) - 1]['TRACKING_LINKS'] = xtc_get_tracking_link($history['orders_id']); } } if ($orders_total > 0) { $smarty->assign('SPLIT_BAR', ' <div class="smallText" style="clear:both;"><div style="float:left;">' . $history_split->display_count(TEXT_DISPLAY_NUMBER_OF_ORDERS) . '</div> <div align="right">' . TEXT_RESULT_PAGE . ' ' . $history_split->display_links(MAX_DISPLAY_PAGE_LINKS, xtc_get_all_get_params(array('page', 'info', 'x', 'y'))) . '</div> </div>'); } $smarty->assign('order_content', $module_content); $smarty->assign('language', $_SESSION['language']); $smarty->assign('BUTTON_BACK', '<a href="' . xtc_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . xtc_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'); $smarty->caching = 0; $main_content = $smarty->fetch(CURRENT_TEMPLATE . '/module/account_history.html'); $smarty->assign('language', $_SESSION['language']); $smarty->assign('main_content', $main_content);
$i++; } $order_content = ''; if (xtc_count_customer_orders() > 0) { $orders_query = xtc_db_query("select\n\t o.orders_id,\n\t o.date_purchased,\n\t o.delivery_name,\n\t o.delivery_country,\n\t o.billing_name,\n\t o.billing_country,\n\t ot.text as order_total,\n\t s.orders_status_name\n\t from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . "\n\t ot, " . TABLE_ORDERS_STATUS . " s\n\t where o.customers_id = '" . (int) $_SESSION['customer_id'] . "'\n\t and o.orders_id = ot.orders_id\n\t and ot.class = 'ot_total'\n\t and o.orders_status = s.orders_status_id\n\t and s.language_id = '" . (int) $_SESSION['languages_id'] . "'\n\t order by orders_id desc limit 3"); while ($orders = xtc_db_fetch_array($orders_query)) { if (xtc_not_null($orders['delivery_name'])) { $order_name = $orders['delivery_name']; $order_country = $orders['delivery_country']; } else { $order_name = $orders['billing_name']; $order_country = $orders['billing_country']; } $order_content[] = array('ORDER_ID' => $orders['orders_id'], 'ORDER_DATE' => xtc_date_short($orders['date_purchased']), 'ORDER_STATUS' => $orders['orders_status_name'], 'ORDER_TOTAL' => $orders['order_total'], 'ORDER_LINK' => xtc_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders['orders_id'], 'SSL'), 'ORDER_BUTTON' => '<a href="' . xtc_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders['orders_id'], 'SSL') . '">' . xtc_image_button('small_view.gif', SMALL_IMAGE_BUTTON_VIEW) . '</a>'); require_once DIR_FS_INC . 'xtc_get_tracking_link.php'; $order_content[count($order_content) - 1]['TRACKING_LINKS'] = xtc_get_tracking_link($orders['orders_id']); } } $smarty->assign('LINK_EDIT', xtc_href_link(FILENAME_ACCOUNT_EDIT, '', 'SSL')); $smarty->assign('LINK_ADDRESS', xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL')); $smarty->assign('LINK_PASSWORD', xtc_href_link(FILENAME_ACCOUNT_PASSWORD, '', 'SSL')); //BOF - Dokuman - 2009-08-21 - Added 'delete account' functionality for customers //Link_Delete button will not work for Admin (ID1) or not logged in users if (isset($_SESSION['customer_id']) && $_SESSION['customer_id'] != '1') { $smarty->assign('LINK_DELETE', xtc_href_link(FILENAME_ACCOUNT_DELETE, '', 'SSL')); } //EOF - Dokuman - 2009-08-21 - Added 'delete account' functionality for customers if (!isset($_SESSION['customer_id'])) { $smarty->assign('LINK_LOGIN', xtc_href_link(FILENAME_LOGIN, '', 'SSL')); } $smarty->assign('LINK_ORDERS', xtc_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));