$smarty->assign('address_label_customer', olc_address_format($order->customer[$format_id], $order->customer, 1, EMPTY_STRING, HTML_BR));
$smarty->assign('address_label_shipping', olc_address_format($order->delivery[$format_id], $order->delivery, 1, EMPTY_STRING, HTML_BR));
$smarty->assign('address_label_payment', olc_address_format($order->billing[$format_id], $order->billing, 1, EMPTY_STRING, HTML_BR));
$smarty->assign('csID', $order->customer['csID']);
// get products data
$order_query = olc_db_query("SELECT\n \t\t\t\tproducts_id,\n \t\t\t\torders_products_id,\n \t\t\t\tproducts_model,\n \t\t\t\tproducts_name,\n \t\t\t\tfinal_price,\n \t\t\t\tproducts_quantity\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS . "\n \t\t\t\tWHERE orders_id='" . $oID . APOS);
$order_data = array();
while ($order_data_values = olc_db_fetch_array($order_query)) {
$attributes_query = olc_db_query("SELECT\n \t\t\t\tproducts_options,\n \t\t\t\tproducts_options_values,\n \t\t\t\tprice_prefix,\n \t\t\t\toptions_values_price\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "\n \t\t\t\tWHERE orders_products_id='" . $order_data_values['orders_products_id'] . APOS);
$attributes_data = EMPTY_STRING;
$attributes_model = EMPTY_STRING;
while ($attributes_data_values = olc_db_fetch_array($attributes_query)) {
$attributes_data .= HTML_BR . $attributes_data_values['products_options'] . ': ' . $attributes_data_values['products_options_values'];
$attributes_model .= HTML_BR . olc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values']);
}
$order_data[] = array('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_PRICE' => olc_format_price_order($order_data_values['final_price'], 1, $order->info['currency']), 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
}
// get order_total data
$oder_total_query = olc_db_query("SELECT\n title,\n text,\n class,\n value,\n sort_order\n FROM " . TABLE_ORDERS_TOTAL . "\n WHERE orders_id='" . $oID . "'\n ORDER BY sort_order ASC");
$order_total = array();
while ($oder_total_values = olc_db_fetch_array($oder_total_query)) {
$order_total[] = array('TITLE' => $oder_total_values['title'], 'CLASS' => $oder_total_values['class'], 'VALUE' => $oder_total_values['value'], 'TEXT' => $oder_total_values['text']);
if ($oder_total_values['class'] = 'ot_total') {
$total = $oder_total_values['value'];
}
}
$smarty->assign('oID', $oID);
if ($order->info['payment_method'] != EMPTY_STRING && $order->info['payment_method'] != 'no_payment') {
include DIR_FS_CATALOG . 'lang/' . SESSION_LANGUAGE . '/modules/payment/' . $order->info['payment_method'] . PHP;
$payment_method = constant(strtoupper('MODULE_PAYMENT_' . $order->info['payment_method'] . '_TEXT_TITLE'));
$smarty->assign('PAYMENT_METHOD', $payment_method);
$smarty->assign('FAX', $customer['customers_fax']);
//
// Kunden-Faxnummer
//
// get products data
$order_query = olc_db_query("SELECT\n \t\t\t\tproducts_id,\n \t\t\t\torders_products_id,\n \t\t\t\tproducts_model,\n \t\t\t\tproducts_name,\n \t\t\t\tproducts_price,\n \t\t\t\tfinal_price,\n \t\t\t\tproducts_quantity\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS . "\n \t\t\t\tWHERE orders_id='" . $oID . APOS);
$order_data = array();
while ($order_data_values = olc_db_fetch_array($order_query)) {
$attributes_query = olc_db_query("SELECT\n \t\t\t\tproducts_options,\n \t\t\t\tproducts_options_values,\n \t\t\t\tprice_prefix,\n \t\t\t\toptions_values_price\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "\n \t\t\t\tWHERE orders_products_id='" . $order_data_values['orders_products_id'] . APOS);
$attributes_data = EMPTY_STRING;
$attributes_model = EMPTY_STRING;
while ($attributes_data_values = olc_db_fetch_array($attributes_query)) {
$attributes_data .= HTML_BR . $attributes_data_values['products_options'] . ': ' . $attributes_data_values['products_options_values'];
$attributes_model .= HTML_BR . olc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values']);
}
$order_data[] = array('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_PRICE' => olc_format_price_order($order_data_values['final_price'], 1, $order->info['currency']), 'PRODUCTS_SINGLE_PRICE' => olc_format_price($order_data_values['products_price'], $price_special = 1, $calculate_currencies = 0, $show_currencies = 1), 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
}
// get order_total data
$oder_total_query = olc_db_query("SELECT\n \t\t\t\t\ttitle,\n \t\t\t\t\ttext,\n class,\n value,\n \t\t\t\t\tsort_order\n \t\t\t\t\tFROM " . TABLE_ORDERS_TOTAL . "\n \t\t\t\t\tWHERE orders_id='" . $oID . "'\n \t\t\t\t\tORDER BY sort_order ASC");
$order_total = array();
while ($oder_total_values = olc_db_fetch_array($oder_total_query)) {
$order_total[] = array('TITLE' => $oder_total_values['title'], 'CLASS' => $oder_total_values['class'], 'VALUE' => $oder_total_values['value'], 'TEXT' => $oder_total_values['text']);
if ($oder_total_values['class'] = 'ot_total') {
$total = $oder_total_values['value'];
}
}
// assign language to template for caching
$smarty->assign('oID', $oID);
if ($order->info['payment_method'] != EMPTY_STRING && $order->info['payment_method'] != 'no_payment') {
include DIR_WS_LANGUAGES . SESSION_LANGUAGE . '/modules/payment/' . $order->info['payment_method'] . PHP;
$payment_method = constant(strtoupper('MODULE_PAYMENT_' . $order->info['payment_method'] . '_TEXT_TITLE'));
