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);
}
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_CUSTOMER . '</b>');
$contents = array('form' => xtc_draw_form('customers', FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO . '<br /><br /><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
if ($cInfo->number_of_reviews > 0) {
$contents[] = array('text' => '<br />' . xtc_draw_checkbox_field('delete_reviews', 'on', true) . ' ' . sprintf(TEXT_DELETE_REVIEWS, $cInfo->number_of_reviews));
}
$contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="btn btn-default" value="' . BUTTON_DELETE . '"><a class="btn btn-default" href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id) . '">' . BUTTON_CANCEL . '</a>');
break;
case 'address_book':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_ADRESS_BOOK . '</b>');
$contents = array();
require_once DIR_FS_INC . 'xtc_get_address_format_id.inc.php';
require_once DIR_FS_INC . 'xtc_count_customer_address_book_entries.inc.php';
$addresses_query = xtc_db_query("-- admin/customers.php\n 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) $cInfo->customers_id . "'\n ORDER BY address_book_id\n ");
while ($addresses = xtc_db_fetch_array($addresses_query)) {
$format_id = xtc_get_address_format_id($addresses['country_id']);
if (isset($_GET['delete']) && $_GET['delete'] != '') {
if ($addresses['address_book_id'] == $_GET['delete']) {
if ($_GET['delete'] != $cInfo->customers_default_address_id) {
$contents[] = array('text' => '<br/>');
$contents[] = array('align' => 'left', 'text' => TEXT_INFO_DELETE);
$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>');
require_once DIR_FS_INC . 'xtc_oe_get_options_values_name.inc.php';
require_once DIR_FS_INC . 'xtc_oe_customer_infos.inc.php';
require_once DIR_FS_INC . 'xtc_get_countries.inc.php';
require_once DIR_FS_INC . 'xtc_get_address_format_id.inc.php';
// Benötigte Funktionen und Klassen Ende
$action = isset($_GET['action']) ? $_GET['action'] : '';
// Adressbearbeitung Anfang
if ($action == 'address_edit') {
$customers_country = xtc_get_countriesList(xtc_db_prepare_input($_POST['customers_country_id']));
$delivery_country = xtc_get_countriesList(xtc_db_prepare_input($_POST['delivery_country_id']), true);
$billing_country = xtc_get_countriesList(xtc_db_prepare_input($_POST['billing_country_id']), true);
$lang_query = xtc_db_query("select languages_id from " . TABLE_LANGUAGES . " where directory = '" . $order->info['language'] . "'");
$lang = xtc_db_fetch_array($lang_query);
$status_query = xtc_db_query("select customers_status_name from " . TABLE_CUSTOMERS_STATUS . " where customers_status_id = '" . (int) $_POST['customers_status'] . "' and language_id = '" . (int) $lang['languages_id'] . "' ");
$status = xtc_db_fetch_array($status_query);
$sql_data_array = array('customers_vat_id' => xtc_db_prepare_input($_POST['customers_vat_id']), 'customers_status' => xtc_db_prepare_input($_POST['customers_status']), 'customers_status_name' => xtc_db_prepare_input($status['customers_status_name']), 'customers_company' => xtc_db_prepare_input($_POST['customers_company']), 'customers_firstname' => xtc_db_prepare_input($_POST['customers_firstname']), 'customers_lastname' => xtc_db_prepare_input($_POST['customers_lastname']), 'customers_name' => xtc_db_prepare_input($_POST['customers_firstname']) . ' ' . xtc_db_prepare_input($_POST['customers_lastname']), 'customers_street_address' => xtc_db_prepare_input($_POST['customers_street_address']), 'customers_suburb' => xtc_db_prepare_input($_POST['customers_suburb']), 'customers_city' => xtc_db_prepare_input($_POST['customers_city']), 'customers_postcode' => xtc_db_prepare_input($_POST['customers_postcode']), 'customers_country' => $customers_country['countries_name'], 'customers_telephone' => xtc_db_prepare_input($_POST['customers_telephone']), 'customers_email_address' => xtc_db_prepare_input($_POST['customers_email_address']), 'customers_address_format_id' => xtc_get_address_format_id($_POST['customers_country_id']), 'customers_cid' => xtc_db_prepare_input($_POST['customers_cid']), 'delivery_company' => xtc_db_prepare_input($_POST['delivery_company']), 'delivery_firstname' => xtc_db_prepare_input($_POST['delivery_firstname']), 'delivery_lastname' => xtc_db_prepare_input($_POST['delivery_lastname']), 'delivery_name' => xtc_db_prepare_input($_POST['delivery_firstname']) . ' ' . xtc_db_prepare_input($_POST['delivery_lastname']), 'delivery_street_address' => xtc_db_prepare_input($_POST['delivery_street_address']), 'delivery_suburb' => xtc_db_prepare_input($_POST['delivery_suburb']), 'delivery_city' => xtc_db_prepare_input($_POST['delivery_city']), 'delivery_postcode' => xtc_db_prepare_input($_POST['delivery_postcode']), 'delivery_country' => $delivery_country['countries_name'], 'delivery_country_iso_code_2' => $delivery_country['countries_iso_code_2'], 'delivery_address_format_id' => xtc_get_address_format_id($_POST['delivery_country_id']), 'billing_company' => xtc_db_prepare_input($_POST['billing_company']), 'billing_firstname' => xtc_db_prepare_input($_POST['billing_firstname']), 'billing_lastname' => xtc_db_prepare_input($_POST['billing_lastname']), 'billing_name' => xtc_db_prepare_input($_POST['billing_firstname']) . ' ' . xtc_db_prepare_input($_POST['billing_lastname']), 'billing_street_address' => xtc_db_prepare_input($_POST['billing_street_address']), 'billing_suburb' => xtc_db_prepare_input($_POST['billing_suburb']), 'billing_city' => xtc_db_prepare_input($_POST['billing_city']), 'billing_postcode' => xtc_db_prepare_input($_POST['billing_postcode']), 'billing_country' => $billing_country['countries_name'], 'billing_country_iso_code_2' => $billing_country['countries_iso_code_2'], 'billing_address_format_id' => xtc_get_address_format_id($_POST['billing_country_id']), 'last_modified' => 'now()');
xtc_db_perform(TABLE_ORDERS, $sql_data_array, 'update', 'orders_id = \'' . (int) $_POST['oID'] . '\'');
xtc_redirect(xtc_href_link(FILENAME_ORDERS_EDIT, 'edit_action=address&oID=' . (int) $_POST['oID']));
}
// Adressbearbeitung Ende
// Artikeldaten einfügen / bearbeiten Anfang:
// Artikel bearbeiten Anfang:
if ($action == 'product_edit') {
$lang_query = xtc_db_query("select languages_id from " . TABLE_LANGUAGES . " where directory = '" . $order->info['language'] . "'");
$lang = xtc_db_fetch_array($lang_query);
$status = get_customers_taxprice_status();
$product_query = xtc_db_query("select op.allow_tax,\n op.products_tax,\n p.products_tax_class_id,\n pd.products_name,\n pd.products_short_description,\n pd.products_order_description\n from " . TABLE_ORDERS_PRODUCTS . " op\n left join " . TABLE_PRODUCTS . " p ON op.products_id = p.products_id\n left join " . TABLE_PRODUCTS_DESCRIPTION . " pd ON op.products_id = pd.products_id AND pd.language_id = '" . (int) $lang['languages_id'] . "'\n WHERE op.products_id = " . (int) $_POST['products_id'] . "\n AND op.orders_products_id = " . (int) $_POST['opID']);
$product = xtc_db_fetch_array($product_query);
if (isset($_POST['products_tax'])) {
$product['products_tax'] = $_POST['products_tax'];
}
