$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'));