' . OVERVIEW_PREVIOUS_ORDERS . '
' . tep_image(DIR_WS_IMAGES . 'arrow_south_east.gif'); ?> |
query('select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, 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 = :customers_id and o.orders_id = ot.orders_id and ot.class = :class and o.orders_status = s.orders_status_id and s.language_id = :language_id order by orders_id desc limit 3');
$Qorders->bindTable(':table_orders', TABLE_ORDERS);
$Qorders->bindTable(':table_orders_total', TABLE_ORDERS_TOTAL);
$Qorders->bindTable(':table_orders_status', TABLE_ORDERS_STATUS);
$Qorders->bindInt(':customers_id', $osC_Customer->id);
$Qorders->bindValue(':class', 'ot_total');
$Qorders->bindInt(':language_id', $osC_Session->value('languages_id'));
$Qorders->execute();
while ($Qorders->next()) {
if (tep_not_null($Qorders->value('delivery_name'))) {
$order_name = $Qorders->value('delivery_name');
$order_country = $Qorders->value('delivery_country');
} else {
$order_name = $Qorders->value('billing_name');
$order_country = $Qorders->value('billing_country');
}
?>
| value('date_purchased')); ?> |
valueInt('orders_id'); ?> |
|
value('orders_status_name'); ?> |
value('order_total'); ?> |
valueInt('orders_id'), 'SSL') . '">' . tep_image_button('small_view.gif', SMALL_IMAGE_BUTTON_VIEW) . ''; ?> |
|
|
|