<?php
/**
* order_history sidebox - if enabled, shows customers' most recent orders
*
* @package templateSystem
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: order_history.php 4822 2006-10-23 11:11:36Z drbyte $
*/
if (isset($_SESSION['customer_id']) && (int
)$_SESSION['customer_id'] != 0) {
// retreive the last x products purchased
$orders_history_query = "select distinct op.products_id
from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS . " p
where o.customers_id = '" . (int)$_SESSION['customer_id'] . "'
and o.orders_id = op.orders_id
and op.products_id = p.products_id
and p.products_status = '1'
group by products_id
order by o.date_purchased desc
limit " . MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX;
$orders_history = $db->Execute($orders_history_query);
if ($orders_history->RecordCount() > 0) {
$product_ids = '';
while (!$orders_history->EOF) {
$product_ids .= (int)$orders_history->fields['products_id'] . ',';
$orders_history->MoveNext();
}
$product_ids = substr($product_ids, 0, -1);
$rows=0;
$customer_orders_string = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';
$products_history_query = "select products_id, products_name
from " . TABLE_PRODUCTS_DESCRIPTION . "
where products_id in (" . $product_ids . ")
and language_id = '" . (int)$_SESSION['languages_id'] . "'
order by products_name";
$products_history = $db->Execute($products_history_query);
while (!$products_history->EOF) {
$rows++;
$customer_orders[$rows]['id'] = $products_history->fields['products_id'];
$customer_orders[$rows]['name'] = $products_history->fields['products_name'];
$products_history->MoveNext();
}
$customer_orders_string .= '</table>';
require($template->get_template_dir('tpl_order_history.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_order_history.php');
$title = BOX_HEADING_CUSTOMER_ORDERS;
$title_link = false;
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
}
}
?>