function xtc_address_label($customers_id, $address_id = 1, $html = false, $boln = '', $eoln = "\n")
{
$address_query = xtc_db_query("select entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . xtc_db_input((int) $customers_id) . "' and address_book_id = '" . xtc_db_input((int) $address_id) . "'");
$address = xtc_db_fetch_array($address_query);
$format_id = xtc_get_address_format_id($address['country_id']);
return xtc_address_format($format_id, $address, $html, $boln, $eoln);
}
/**
* Produktdaten einlesen
*
* @param array $selected_products uebergebene Auswahl
*/
function LoadData($oID)
{
global $xtPrice;
// --- bof -- changes -- h.koch@hen-vm68.com -- 05.2016 --
//$c_query ="SELECT
// customers_status
// FROM " . TABLE_ORDERS . "
// WHERE
// orders_id = '".$oID."'";
$c_query = "SELECT\r\n customers_status,\r\n currency\r\n FROM " . TABLE_ORDERS . "\r\n WHERE\r\n orders_id = '" . $oID . "'";
// --- eof -- changes -- h.koch@hen-vm68.com -- 05.2016 --
$c_query = xtDBquery($c_query);
$c_query = xtc_db_fetch_array($c_query);
$customers_status = $c_query['customers_status'];
$currency = $c_query['currency'];
// EUR, CHF
// --- changes -- h.koch@hen-vm68.com -- 05.2016 --
//$xtPrice = new xtcPrice( 'EUR', $customers_status );
$xtPrice = new xtcPrice($currency, $customers_status);
// --- changes -- h.koch@hen-vm68.com -- 05.2016 --
$order = new order_pdf($oID);
$this->data['address_label_customer'] = xtc_address_format($order->customer['format_id'], $order->customer, 0, '', "\n");
$this->data['address_label_shipping'] = xtc_address_format($order->delivery['format_id'], $order->delivery, 0, '', "\n");
$this->data['address_label_payment'] = xtc_address_format($order->billing['format_id'], $order->billing, 0, '', "\n");
$this->data['csID'] = $order->customer['csID'];
// get products data
$order_total = $order->getTotalData($oID);
$this->data['order_data'] = $order->getOrderData($oID);
$this->data['order_total'] = $order_total['data'];
// assign language to template for caching
$this->data['language'] = $_SESSION['language'];
$this->data['oID'] = $oID;
if ($order->info['payment_method'] != '' && $order->info['payment_method'] != 'no_payment') {
include DIR_FS_LANGUAGES . $_SESSION['language'] . '/modules/payment/' . $order->info['payment_method'] . '.php';
$payment_method = constant(strtoupper('MODULE_PAYMENT_' . $order->info['payment_method'] . '_TEXT_TITLE'));
}
$this->data['PAYMENT_METHOD'] = $payment_method;
$this->data['COMMENT'] = $order->info['comments'];
$this->data['order'] = $order;
$this->data['DATE'] = xtc_date_short($order->info['date_purchased']);
$this->data['DATE_INVOICE'] = xtc_date_short($order->info['ibn_billdate']);
$this->data['ibn_billdate'] = $order->info['ibn_billdate'];
$this->data['ibn_billnr'] = $order->info['ibn_billnr'];
//echo "data:<pre>"; print_r($this->data); echo "</pre>";
return;
}
$contents[] = array('text' => '<br/>');
$contents[] = array('text' => '<table style="font-size:11px; margin-left:20px;"><tr><td>' . xtc_address_format($format_id, $addresses, true, ' ', '<br />') . '</td></tr></table>');
$contents[] = array('text' => '<br/>');
$contents[] = array('align' => 'left', 'text' => '<a class="btn btn-default" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'delete')) . 'cID=' . $cInfo->customers_id) . '">' . BUTTON_CANCEL . '</a> <a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'delete')) . 'cID=' . $cInfo->customers_id . '&action=delete_confirm_adressbook&address_book_id=' . $addresses['address_book_id']) . '">' . BUTTON_DELETE . '</a>');
$contents[] = array('text' => '<br/>');
} else {
$contents[] = array('text' => '<br/>');
$contents[] = array('align' => 'left', 'text' => TEXT_INFO_DELETE_DEFAULT);
$contents[] = array('text' => '<br/>');
$contents[] = array('align' => 'left', 'text' => '<a class="btn btn-default" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'delete')) . 'cID=' . $cInfo->customers_id) . '">' . BUTTON_BACK . '</a>');
$contents[] = array('text' => '<br/>');
}
}
} else {
$contents[] = array('text' => '<br/>');
$contents[] = array('text' => '<table style="font-size:11px; margin-left:20px;"><tr><td>' . xtc_address_format($format_id, $addresses, true, ' ', '<br />') . '</td></tr></table>');
$contents[] = array('text' => '<br/>');
$contents[] = array('align' => 'left', 'text' => '<a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'edit')) . 'cID=' . $cInfo->customers_id . '&action=edit&edit=' . $addresses['address_book_id']) . '">' . BUTTON_EDIT . '</a> <a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'delete', 'edit')) . 'cID=' . $cInfo->customers_id . '&action=address_book&delete=' . $addresses['address_book_id']) . '">' . BUTTON_DELETE . '</a>' . ($cInfo->customers_default_address_id != $addresses['address_book_id'] ? ' <a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'delete', 'default')) . 'cID=' . $cInfo->customers_id . '&action=update_default_adressbook&default=' . $addresses['address_book_id']) . '">' . TEXT_SET_DEFAULT . '</a>' : ''));
$contents[] = array('text' => '<hr size="1"/>');
}
}
if (!isset($_GET['delete'])) {
$contents[] = array('align' => 'right', 'text' => xtc_count_customer_address_book_entries() < MAX_ADDRESS_BOOK_ENTRIES ? '<a class="btn btn-default" onclick="this.blur();" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'edit')) . 'cID=' . $cInfo->customers_id . '&action=edit&edit=0') . '">' . BUTTON_INSERT . '</a> <a class="btn btn-default" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'delete')) . 'cID=' . $cInfo->customers_id) . '">' . BUTTON_CANCEL . '</a>' : '<a class="btn btn-default" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action', 'delete')) . 'cID=' . $cInfo->customers_id) . '">' . BUTTON_CANCEL . '</a>');
$contents[] = array('text' => '<br/>');
}
break;
case 'editstatus':
if ($_GET['cID'] != 1) {
$customers_history_query = xtc_db_query("SELECT new_value, old_value, date_added, customer_notified FROM " . TABLE_CUSTOMERS_STATUS_HISTORY . " WHERE customers_id = '" . xtc_db_input($_GET['cID']) . "' order by customers_status_history_id desc");
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_STATUS_CUSTOMER . '</b>');
$contents = array('form' => xtc_draw_form('customers', FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=statusconfirm'));
require_once DIR_FS_INC . 'xtc_get_attributes_model.inc.php';
require_once DIR_FS_INC . 'xtc_not_null.inc.php';
require_once DIR_FS_INC . 'xtc_format_price_order.inc.php';
$smarty = new Smarty();
// BOF - DokuMan - 2011-12-08 - get store name for display in letter box of packing slip
$query_store_name = xtc_db_query("-- admin/print_packingslip.php\n SELECT configuration_value AS store_name\n FROM " . TABLE_CONFIGURATION . "\n WHERE configuration_key='STORE_NAME'\n LIMIT 1");
while ($row = xtc_db_fetch_array($query_store_name)) {
$smarty->assign('store_name', $row['store_name']);
}
// EOF - DokuMan - 2011-12-08 - get store name for display in letter box of packing slip
// get order data
include DIR_WS_CLASSES . 'order.php';
$order = new order((int) $_GET['oID']);
$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
include_once DIR_FS_CATALOG . DIR_WS_CLASSES . 'xtcPrice.php';
$xtPrice = new xtcPrice($order->info['currency'], $order->info['status']);
$order_total = $order->getTotalData($order->info['order_id']);
$order_data = $order->getOrderData($order->info['order_id']);
$smarty->assign('order_data', $order_data);
$smarty->assign('order_total', $order_total['data']);
// assign language to template for caching
$languages_query = xtc_db_query("select code, language_charset from " . TABLE_LANGUAGES . " WHERE directory ='" . $order->info['language'] . "'");
$langcode = xtc_db_fetch_array($languages_query);
$smarty->assign('langcode', $langcode['code']);
$smarty->assign('charset', $langcode['language_charset']);
$smarty->assign('language', $order->info['language']);
$smarty->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/');
$customer = xtc_db_fetch_array(xtc_db_query('SELECT * FROM billsafe_orders_user_2 WHERE bsorders_id ="' . xtc_db_input($billsafe_orders['id']) . '"'));
$country_query = xtc_db_query('SELECT countries_name FROM countries WHERE countries_iso_code_2 = "' . xtc_db_input($customer['country']) . '"');
$country = xtc_db_fetch_array($country_query);
echo $customer['company'] . '<br />' . $customer['firstname'] . ' ' . $customer['lastname'] . '<br />' . $customer['street'] . ' ' . $customer['housenumber'] . '<br />' . $customer['postcode'] . ' ' . $customer['city'] . '<br />' . $country['countries_name'] . '<br /><br />' . MODULE_PAYMENT_BILLSAFE_2_EMAIL . ': ' . $customer['email'] . '<br />';
?>
</td></tr></table>
</div>
<div class="col-xs-12 col-sm-4">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr>
<td class="main" valign="top"><strong><?php
echo MODULE_PAYMENT_BILLSAFE_2_SADDRESS;
?>
</strong></td>
</tr><tr>
<td class="main"><?php
echo xtc_address_format($order->billing['format_id'], $order->delivery, 1, '', '<br />');
?>
</td></tr></table>
</div>
<div class="col-xs-12 col-sm-4"><?php
$params = array('transactionId' => $billsafe_orders['transactionid']);
$response = $bs->callMethod('getPaymentInstruction', $params);
if ($response->ack == 'OK') {
$ins = $response->instruction;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr>
<td class="main" valign="top"><strong><?php
echo MODULE_PAYMENT_BILLSAFE_2_BANK_DETAILS;
?>
</strong></td>
<tr><td class="main" width="40%" valign="top"><table><tr>
<?php
}
?>
<div class="pp_transactions pp_box">
<div class="pp_boxheading"><?php
echo TEXT_PAYPAL_TRANSACTION;
?>
</div>
<dl class="pp_transaction">
<dt><?php
echo TEXT_PAYPAL_TRANSACTION_ADDRESS;
?>
</dt>
<dd><?php
echo xtc_address_format($order->customer['format_id'], $admin_info_array['address'], 1, '', '<br />');
?>
</dd>
</dl>
<dl class="pp_transaction">
<dt><?php
echo TEXT_PAYPAL_TRANSACTION_METHOD;
?>
</dt>
<dd><?php
echo $admin_info_array['payment_method'];
?>
</dd>
</dl>
<dl class="pp_transaction">
<dt><?php
// --- bof -- ipdfbill --------
require 'admin/includes/ipdfbill/pdfbill_lib.php';
// pdfbill
$pdffile = 'admin/' . PDFBILL_FOLDER . PDFBILL_PREFIX . ($_GET['order_id'] . '.pdf');
if (file_exists($pdffile)) {
$pdflink = xtc_href_link(FILENAME_PDFBILL_DISPLAY, 'oID=' . $_GET['order_id']);
$pdflink = sprintf('<a href="%s">' . PDFBILL_DOWNLOAD_INVOICE . '</a>', $pdflink);
$smarty->assign('IPDFBILL_INVOICE_DOWNLOAD', $pdflink);
}
// --- eof -- ipdfbill --------
// Stuff
$smarty->assign('ORDER_NUMBER', $order->info['order_id']);
//DokuMan - 2011-08-31 - fix order_id assignment
$smarty->assign('ORDER_DATE', xtc_date_long($order->info['date_purchased']));
$smarty->assign('ORDER_STATUS', $order->info['orders_status']);
$smarty->assign('BILLING_LABEL', xtc_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br />'));
$smarty->assign('PRODUCTS_EDIT', xtc_href_link(FILENAME_SHOPPING_CART, '', 'NONSSL'));
// web28 - 2011-04-14 - change SSL -> NONSSL
$smarty->assign('SHIPPING_ADDRESS_EDIT', xtc_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL'));
$smarty->assign('BILLING_ADDRESS_EDIT', xtc_href_link(FILENAME_CHECKOUT_PAYMENT_ADDRESS, '', 'SSL'));
$smarty->assign('BUTTON_PRINT', '<a style="cursor:pointer" onclick="javascript:window.open(\'' . xtc_href_link(FILENAME_PRINT_ORDER, 'oID=' . $order->info['order_id']) . '\', \'popup\', \'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no, width=640, height=600\')">' . xtc_image_button('button_print.gif', TEXT_PRINT) . '</a>');
$from_history = preg_match("/page=/i", xtc_get_all_get_params());
// referer from account_history yes/no
$back_to = $from_history ? FILENAME_ACCOUNT_HISTORY : FILENAME_ACCOUNT;
// if from account_history => return to account_history
$smarty->assign('BUTTON_BACK', '<a href="' . xtc_href_link($back_to, xtc_get_all_get_params(array('order_id')), 'SSL') . '">' . xtc_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>');
$smarty->assign('language', $_SESSION['language']);
$main_content = $smarty->fetch(CURRENT_TEMPLATE . '/module/account_history_info.html');
$smarty->assign('main_content', $main_content);
$smarty->caching = 0;
if (!defined('RM')) {
<td><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2"><?php
echo xtc_draw_separator();
?>
</td>
</tr>
<tr>
<td valign="top"><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main" valign="top"><b><?php
echo TEXT_AFFILIATE;
?>
</b></td>
<td class="main"><?php
echo xtc_address_format($payments['affiliate_address_format_id'], $affiliate_address, 1, ' ', '<br>');
?>
</td>
</tr>
<tr>
<td colspan="2"><?php
echo xtc_draw_separator('pixel_trans.gif', '1', '5');
?>
</td>
</tr>
<tr>
<td colspan="2"><?php
echo xtc_draw_separator('pixel_trans.gif', '1', '5');
?>
</td>
</tr>
$breadcrumb->add(NAVBAR_TITLE_2_ADDRESS_BOOK, xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
require DIR_WS_INCLUDES . 'header.php';
if ($messageStack->size('addressbook') > 0) {
$smarty->assign('error', $messageStack->output('addressbook'));
}
$smarty->assign('ADDRESS_DEFAULT', xtc_address_label($_SESSION['customer_id'], $_SESSION['customer_default_address_id'], true, ' ', '<br />'));
$addresses_data = array();
$addresses_query = xtc_db_query("select address_book_id,\n entry_firstname as firstname,\n entry_lastname as lastname,\n entry_company as company,\n entry_street_address as street_address,\n entry_suburb as suburb,\n entry_city as city,\n entry_postcode as postcode,\n entry_state as state,\n entry_zone_id as zone_id,\n entry_country_id as country_id \n from " . TABLE_ADDRESS_BOOK . " \n where customers_id = '" . (int) $_SESSION['customer_id'] . "'\n order by firstname, lastname");
while ($addresses = xtc_db_fetch_array($addresses_query)) {
$format_id = xtc_get_address_format_id($addresses['country_id']);
if ($addresses['address_book_id'] == $_SESSION['customer_default_address_id']) {
$primary = 1;
} else {
$primary = 0;
}
$addresses_data[] = array('NAME' => $addresses['firstname'] . ' ' . $addresses['lastname'], 'BUTTON_EDIT' => '<a href="' . xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'edit=' . $addresses['address_book_id'], 'SSL') . '">' . xtc_image_button('small_edit.gif', SMALL_IMAGE_BUTTON_EDIT) . '</a>', 'BUTTON_DELETE' => '<a href="' . xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'delete=' . $addresses['address_book_id'], 'SSL') . '">' . xtc_image_button('small_delete.gif', SMALL_IMAGE_BUTTON_DELETE) . '</a>', 'ADDRESS' => xtc_address_format($format_id, $addresses, true, ' ', '<br />'), 'PRIMARY' => $primary);
}
$smarty->assign('addresses_data', $addresses_data);
$smarty->assign('BUTTON_BACK', '<a href="' . xtc_href_link(FILENAME_ACCOUNT, '', 'SSL') . '">' . xtc_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>');
if (xtc_count_customer_address_book_entries() < MAX_ADDRESS_BOOK_ENTRIES) {
$smarty->assign('BUTTON_NEW', '<a href="' . xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, '', 'SSL') . '">' . xtc_image_button('button_add_address.gif', IMAGE_BUTTON_ADD_ADDRESS) . '</a>');
}
$smarty->assign('ADDRESS_COUNT', sprintf(TEXT_MAXIMUM_ENTRIES, MAX_ADDRESS_BOOK_ENTRIES));
$smarty->assign('language', $_SESSION['language']);
$smarty->caching = 0;
$main_content = $smarty->fetch(CURRENT_TEMPLATE . '/module/address_book.html');
$smarty->assign('language', $_SESSION['language']);
$smarty->assign('main_content', $main_content);
$smarty->caching = 0;
if (!defined('RM')) {
$smarty->load_filter('output', 'note');
function shopAdressFormat($address_format_id, $address, $html, $boln, $eoln)
{
return xtc_address_format($address_format_id, $address, $html, $boln, $eoln);
}
}
}
// add vat if exists
if (!empty($order->customer['vat_id'])) {
$customer_adress .= "\n" . $order->customer['vat_id'];
}
/*
* -> order info data
*/
if (gm_get_conf('GM_PDF_USE_INFO') == '1') {
if (!empty($order->delivery['name'])) {
$order_info['ADR_LABEL_SHIPPING'][0] = PDF_INFO_ADR_LABEL_SHIPPING;
$order_info['ADR_LABEL_SHIPPING'][1] = strip_tags(gm_pdf_adress_format(xtc_address_format($order->delivery['format_id'], $order->delivery, 0, '', "###")));
} else {
$order_info['ADR_LABEL_SHIPPING'][0] = PDF_INFO_ADR_LABEL_SHIPPING;
$order_info['ADR_LABEL_SHIPPING'][1] = strip_tags(gm_pdf_adress_format(xtc_address_format($order->customer['format_id'], $order->customer, 0, '', "###")));
}
if ($order->info['payment_method'] != '' && $order->info['payment_method'] != 'no_payment') {
$order_info['PAYMENT_METHOD'][0] = PDF_INFO_PAYMENT;
if (file_exists(DIR_FS_CATALOG . 'lang/' . $_SESSION['language'] . '/modules/payment/' . $order->info['payment_method'] . '.php')) {
include DIR_FS_CATALOG . 'lang/' . $_SESSION['language'] . '/modules/payment/' . $order->info['payment_method'] . '.php';
$order_info['PAYMENT_METHOD'][1] = trim(html_entity_decode(strip_tags(constant(strtoupper('MODULE_PAYMENT_' . $order->info['payment_method'] . '_TEXT_TITLE')))));
} else {
$order_info['PAYMENT_METHOD'][1] = $order->info['payment_method'];
}
}
if (!empty($order->info['shipping_class'])) {
$gm_shipping = $order->info['shipping_class'];
if (strstr($order->info['shipping_class'], '_')) {
$gm_shipping_class = explode('_', $order->info['shipping_class']);
$gm_shipping = $gm_shipping_class[0];
<?php
/* -----------------------------------------------------------------------------------------
$Id: checkout_address_layout.php 3783 2012-10-17 11:29:42Z web28 $
modified eCommerce Shopsoftware
http://www.modified-shop.org
Copyright (c) 2009 - 2013 [www.modified-shop.org]
-----------------------------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
if ($addresses_count > 1) {
$address_content = '<ol id="address_block">';
$radio_buttons = 0;
$addresses_query = xtc_db_query("SELECT address_book_id,\n entry_firstname as firstname,\n entry_lastname as lastname,\n entry_company as company,\n entry_street_address as street_address,\n entry_suburb as suburb,\n entry_city as city,\n entry_postcode as postcode,\n entry_state as state,\n entry_zone_id as zone_id,\n entry_country_id as country_id\n FROM " . TABLE_ADDRESS_BOOK . "\n WHERE customers_id = '" . (int) $_SESSION['customer_id'] . "'");
while ($addresses = xtc_db_fetch_array($addresses_query)) {
$format_id = xtc_get_address_format_id($addresses['country_id']);
$address_content .= sprintf('<li>%s<label for="field_addresses_%s"> %s %s</label><br /><span class="address">%s</span></li>', xtc_draw_radio_field('address', $addresses['address_book_id'], $addresses['address_book_id'] == $_SESSION['sendto'], 'id="field_addresses_' . $addresses['address_book_id'] . '"'), $addresses['address_book_id'], $addresses['firstname'], $addresses['lastname'], xtc_address_format($format_id, $addresses, true, ' ', ', '));
// Tomcraft - 2011-01-04 - make checkout process valid
$radio_buttons++;
}
$address_content .= '</ol>';
//EOF - Dokuman - 2009-08-21 - Better layout on multiple shipping/billing addresses
$smarty->assign('BLOCK_ADDRESS', $address_content);
}
