$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', '');
Beispiel #3
0
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'];