$smarty->assign('address_label_customer', xtc_address_format($order->customer['format_id'], $order->customer, 1, '', '<br />')); $smarty->assign('address_label_shipping', xtc_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br />')); $smarty->assign('address_label_payment', xtc_address_format($order->billing['format_id'], $order->billing, 1, '', '<br />')); $smarty->assign('csID', $order->customer['csID']); // get products data $order_query = xtc_db_query("SELECT\r\n\r\n \t\t\t\tproducts_id,\r\n\r\n \t\t\t\torders_products_id,\r\n\r\n \t\t\t\tproducts_model,\r\n\r\n \t\t\t\tproducts_name,\r\n\r\n \t\t\t\tfinal_price,\r\n\r\n \t\t\t\tproducts_quantity\r\n\r\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS . "\r\n\r\n \t\t\t\tWHERE orders_id='" . (int) $_GET['oID'] . "'"); $order_data = array(); while ($order_data_values = xtc_db_fetch_array($order_query)) { $attributes_query = xtc_db_query("SELECT\r\n\r\n \t\t\t\tproducts_options,\r\n\r\n \t\t\t\tproducts_options_values,\r\n\r\n \t\t\t\tprice_prefix,\r\n\r\n \t\t\t\toptions_values_price\r\n\r\n \t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "\r\n\r\n \t\t\t\tWHERE orders_products_id='" . $order_data_values['orders_products_id'] . "'"); $attributes_data = ''; $attributes_model = ''; while ($attributes_data_values = xtc_db_fetch_array($attributes_query)) { $attributes_data .= '<br />' . $attributes_data_values['products_options'] . ':' . $attributes_data_values['products_options_values']; $attributes_model .= '<br />' . xtc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values'], $attributes_data_values['products_options']); } $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' => xtc_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 = xtc_db_query("SELECT\r\n\r\n title,\r\n\r\n text,\r\n\r\n class,\r\n\r\n value,\r\n\r\n sort_order\r\n\r\n \t\t\t\t\tFROM " . TABLE_ORDERS_TOTAL . "\r\n\r\n \t\t\t\t\tWHERE orders_id='" . $_GET['oID'] . "'\r\n\r\n \t\t\t\t\tORDER BY sort_order ASC"); $order_total = array(); while ($oder_total_values = xtc_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('language', $_SESSION['language']); $smarty->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $smarty->assign('oID', $_GET['oID']); if ($order->info['payment_method'] != '' && $order->info['payment_method'] != 'no_payment') {
$smarty->assign('BillsafeText', $ins->legalNote); $smarty->assign('BillsafeText2', '<b>' . $ins->note . '</b>'); $smarty->assign('recipient', MODULE_PAYMENT_BILLSAFE_2_RECIPIENT . ':'); $smarty->assign('recipientValue', $ins->recipient); $smarty->assign('account', MODULE_PAYMENT_BILLSAFE_2_ACCOUNT_NUMBER . ':'); $smarty->assign('accountValue', $ins->accountNumber); $smarty->assign('bankcode', MODULE_PAYMENT_BILLSAFE_2_BANK_CODE . ':'); $smarty->assign('bankcodeValue', $ins->bankCode); $smarty->assign('bank', MODULE_PAYMENT_BILLSAFE_2_BANK_NAME . ':'); $smarty->assign('bankValue', $ins->bankName); $smarty->assign('bic', MODULE_PAYMENT_BILLSAFE_2_BIC . ':'); $smarty->assign('bicValue', $ins->bic); $smarty->assign('iban', MODULE_PAYMENT_BILLSAFE_2_IBAN . ':'); $smarty->assign('ibanValue', $ins->iban); $smarty->assign('amount', MODULE_PAYMENT_BILLSAFE_2_AMOUNT . ':'); $smarty->assign('amountValue', xtc_format_price_order($ins->amount, 1, $order->info['currency'])); $smarty->assign('reference', MODULE_PAYMENT_BILLSAFE_2_REFERENCE . ':'); $smarty->assign('referenceValue', $ins->reference); $smarty->assign('referenceUrl', MODULE_PAYMENT_BILLSAFE_2_REFERENCE . ':'); $smarty->assign('referenceUrlValue', $url); } else { $smarty->assign('BillsafeText', ''); $smarty->assign('BillsafeText2', ''); $smarty->assign('recipient', ''); $smarty->assign('recipientValue', ''); $smarty->assign('account', ''); $smarty->assign('accountValue', ''); $smarty->assign('bankcode', ''); $smarty->assign('bankcodeValue', ''); $smarty->assign('bank', ''); $smarty->assign('bankValue', '');
while ($order_data_values = xtc_db_fetch_array($order_query)) { $attributes_query = xtc_db_query("\n\t\t\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t\t\tproducts_options,\n\t\t\t\t\t\t\t\t\t\t\tproducts_options_values,\n\t\t\t\t\t\t\t\t\t\t\tprice_prefix,\n\t\t\t\t\t\t\t\t\t\t\toptions_values_price\n\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\torders_products_id='" . $order_data_values['orders_products_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\tAND orders_id='" . (int) $_GET['oID'] . "'\n\t\t\t\t\t\t\t\t\t"); $attributes_data = array(); $attributes_model = ''; while ($attributes_data_values = xtc_db_fetch_array($attributes_query)) { $attributes_data[] = array(xtc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values'], $attributes_data_values['products_options']), $attributes_data_values['products_options'] . ': ' . $attributes_data_values['products_options_values']); } // BOF GM_MOD GX-Customizer: require DIR_FS_CATALOG . 'gm/modules/gm_gprint_admin_gm_pdf_order.php'; # properties BOF $t_properties_query = xtc_db_query("SELECT\n\t\t\t\t\t\t\t\t\t\t\t\tproperties_name,\n\t\t\t\t\t\t\t\t\t\t\t\tvalues_name\n\t\t\t\t\t\t\t\t\t\t\tFROM orders_products_properties\n\t\t\t\t\t\t\t\t\t\t\tWHERE orders_products_id='" . $order_data_values['orders_products_id'] . "'"); while ($t_properties_array = xtc_db_fetch_array($t_properties_query)) { $attributes_data[] = array('', $t_properties_array['properties_name'] . ': ' . $t_properties_array['values_name']); } # properties EOF $order_data[] = array('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_QTY' => gm_prepare_number($order_data_values['products_quantity']), 'PRODUCTS_UNIT' => $order_data_values['unit_name'], 'PRODUCTS_TAX' => xtc_display_tax_value($order_data_values['products_tax']) . "%", 'PRODUCTS_PRICE_SINGLE' => xtc_format_price_order($order_data_values['final_price'] / $order_data_values['products_quantity'], 1, $order->info['currency']), 'PRODUCTS_PRICE' => xtc_format_price_order($order_data_values['final_price'], 1, $order->info['currency']), 'PRODUCTS_ATTRIBUTES' => $attributes_data); } // handling article no $gm_use_products_model = false; if (gm_get_conf('GM_PDF_USE_PRODUCTS_MODEL') == 1) { $gm_use_products_model = true; } $oder_total_query = xtc_db_query("\n\t\t\t\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\t\t\t\t title,\n\t\t\t\t\t\t\t\t\t\t text,\n\t\t\t\t\t\t\t\t\t\t class,\n\t\t\t\t\t\t\t\t\t\t value,\n\t\t\t\t\t\t\t\t\t\t sort_order\n\t\t\t\t\t\t\t\t\tFROM " . TABLE_ORDERS_TOTAL . "\n\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\torders_id='" . (int) $_GET['oID'] . "'\n\t\t\t\t\t\t\t\t\tORDER BY \n\t\t\t\t\t\t\t\t\t\tsort_order ASC\n\t\t\t\t\t\t\t\t\t"); /* * -> order total data */ $order_total = array(); while ($oder_total_values = xtc_db_fetch_array($oder_total_query)) { $order_total[] = array('TITLE' => html_entity_decode($oder_total_values['title']), 'TEXT' => $oder_total_values['text']); if ($oder_total_values['class'] == 'ot_total') { $total = $oder_total_values['value'];