Kundennummer in AdminMail bei Änderung der Kundenadresse

[spacebon]

Hallo,

sobald ein Kunde seine Adresse im Adressbuch ändert erhalte ich (Admin) eine Infomail mit Name u.dergl. Hier hätte ich gerne die Kundennummer mit übermittelt damit wir den Kunden schneller zuordnen können.

Derzeit wird die ID übermittelt > wie folgt:

Code: PHP  [Auswählen]

$html_mail_changead = "<b>Aenderung der Kundenadresse (Standardadresse): ".$_SESSION['customer_id']."</b><br>".$comp_changead_html.$firstname."<br>".$lastname."<br>".$street_address."<br>".$postcode."<br>".$city."<br>".$fetch['countries_name']."<br>";

Es gibt die customer_cid (= Kundennummer). Eine Änderung von "customer_id" nach "customer_cid" bringt leider nicht den gewünschten Erfolg/Effekt.

Kann mir jemand behilflich sein??

Grüße

Spacebon

Der gesamte code der Datei:

Code: PHP  [Auswählen]

<?php


include ('includes/application_top.php');
// create smarty elements
$smarty = new Smarty;
// include boxes
require (DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/source/boxes.php');
// include needed functions
require_once (DIR_FS_INC.'xtc_count_customer_address_book_entries.inc.php');
require_once (DIR_FS_INC.'xtc_address_label.inc.php');
require_once (DIR_FS_INC.'xtc_get_country_name.inc.php');

if (!isset ($_SESSION['customer_id']))
        xtc_redirect(xtc_href_link(FILENAME_LOGIN, '', 'SSL'));

if (isset ($_GET['action']) && ($_GET['action'] == 'deleteconfirm') && isset ($_GET['delete']) && is_numeric($_GET['delete'])) {
        xtc_db_query("delete from ".TABLE_ADDRESS_BOOK." where address_book_id = '".(int) $_GET['delete']."' and customers_id = '".(int) $_SESSION['customer_id']."'");

        $messageStack->add_session('addressbook', SUCCESS_ADDRESS_BOOK_ENTRY_DELETED, 'success');

        xtc_redirect(xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
}

// error checking when updating or adding an entry
$process = false;
if (isset ($_POST['action']) && (($_POST['action'] == 'process') || ($_POST['action'] == 'update'))) {
        $process = true;
        $error = false;

        if (ACCOUNT_GENDER == 'true')
                $gender = xtc_db_prepare_input($_POST['gender']);
        if (ACCOUNT_COMPANY == 'true')
                $company = xtc_db_prepare_input($_POST['company']);
        $firstname = xtc_db_prepare_input($_POST['firstname']);
        $lastname = xtc_db_prepare_input($_POST['lastname']);
        $street_address = xtc_db_prepare_input($_POST['street_address']);
        if (ACCOUNT_SUBURB == 'true')
                $suburb = xtc_db_prepare_input($_POST['suburb']);
        $postcode = xtc_db_prepare_input($_POST['postcode']);
        $city = xtc_db_prepare_input($_POST['city']);
        $country = xtc_db_prepare_input($_POST['country']);
        if (ACCOUNT_STATE == 'true') {
                $zone_id = xtc_db_prepare_input($_POST['zone_id']);
                $state = xtc_db_prepare_input($_POST['state']);
        }

        if (ACCOUNT_GENDER == 'true') {
                if (($gender != 'm') && ($gender != 'f')) {
                        $error = true;

                        $messageStack->add('addressbook', ENTRY_GENDER_ERROR);
                }
        }

        if (strlen($firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
                $error = true;

                $messageStack->add('addressbook', ENTRY_FIRST_NAME_ERROR);
        }

        if (strlen($lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
                $error = true;

                $messageStack->add('addressbook', ENTRY_LAST_NAME_ERROR);
        }

        if (strlen($street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
                $error = true;

                $messageStack->add('addressbook', ENTRY_STREET_ADDRESS_ERROR);
        }

        if (strlen($postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
                $error = true;

                $messageStack->add('addressbook', ENTRY_POST_CODE_ERROR);
        }

        if (strlen($city) < ENTRY_CITY_MIN_LENGTH) {
                $error = true;

                $messageStack->add('addressbook', ENTRY_CITY_ERROR);
        }

        if (is_numeric($country) == false) {
                $error = true;

                $messageStack->add('addressbook', ENTRY_COUNTRY_ERROR);
        }

        if (ACCOUNT_STATE == 'true') {
                $zone_id = 0;
                $check_query = xtc_db_query("select count(*) as total from ".TABLE_ZONES." where zone_country_id = '".(int) $country."'");
                $check = xtc_db_fetch_array($check_query);
                $entry_state_has_zones = ($check['total'] > 0);
                if ($entry_state_has_zones == true) {
                        $zone_query = xtc_db_query("select distinct zone_id from ".TABLE_ZONES." where zone_country_id = '".(int) $country."' and (zone_name like '".xtc_db_input($state)."%' or zone_code like '%".xtc_db_input($state)."%')");
                        if (xtc_db_num_rows($zone_query) == 1) {
                                $zone = xtc_db_fetch_array($zone_query);
                                $zone_id = $zone['zone_id'];
                        } else {
                                $error = true;

                                $messageStack->add('addressbook', ENTRY_STATE_ERROR_SELECT);
                        }
                } else {
                        if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
                                $error = true;

                                $messageStack->add('addressbook', ENTRY_STATE_ERROR);
                        }
                }
        }

        if ($error == false) {
                $sql_data_array = array ('entry_firstname' => $firstname, 'entry_lastname' => $lastname, 'entry_street_address' => $street_address, 'entry_postcode' => $postcode, 'entry_city' => $city, 'entry_country_id' => (int) $country,'address_last_modified' => 'now()');

                if (ACCOUNT_GENDER == 'true')
                        $sql_data_array['entry_gender'] = $gender;
                if (ACCOUNT_COMPANY == 'true')
                        $sql_data_array['entry_company'] = $company;
                if (ACCOUNT_SUBURB == 'true')
                        $sql_data_array['entry_suburb'] = $suburb;
                if (ACCOUNT_STATE == 'true') {
                        if ($zone_id > 0) {
                                $sql_data_array['entry_zone_id'] = (int) $zone_id;
                                $sql_data_array['entry_state'] = '';
                        } else {
                                $sql_data_array['entry_zone_id'] = '0';
                                $sql_data_array['entry_state'] = $state;
                        }
                }

                if ($_POST['action'] == 'update') {
                        xtc_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', "address_book_id = '".(int) $_GET['edit']."' and customers_id ='".(int) $_SESSION['customer_id']."'");
                       
                       
                       

                        // reregister session variables
                        if ((isset ($_POST['primary']) && ($_POST['primary'] == 'on')) || ($_GET['edit'] == $_SESSION['customer_default_address_id'])) {
                                $_SESSION['customer_first_name'] = $firstname;
                                $_SESSION['customer_country_id'] = $country_id;
                                $_SESSION['customer_zone_id'] = (($zone_id > 0) ? (int) $zone_id : '0');
                                $_SESSION['customer_default_address_id'] = (int) $_GET['edit'];

                                $sql_data_array = array ('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_default_address_id' => (int) $_GET['edit'],'customers_last_modified' => 'now()');

                                if (ACCOUNT_GENDER == 'true')
                                        $sql_data_array['customers_gender'] = $gender;


/* send mail to admin */

                                        $fetch_country_query = xtc_db_query("select countries_name from ".TABLE_COUNTRIES." where countries_id = '".$country."'");
                                        $fetch = xtc_db_fetch_array($fetch_country_query);                             
                                       
                                        if (ACCOUNT_COMPANY == 'true')  { $comp_changead_html = $company."<br>"; $comp_changead_txt = $company."\n"; } else { $comp_changead_html = ""; $comp_changead_txt = ""; }

                                        $txt_mail_changead = "Aenderung der Kundenadresse (Standardadresse):\t".$_SESSION['customer_id']."\n".$comp_changead_txt.$firstname."\n".$lastname."\n".$street_address."\n".$postcode."\n".$city."\n".$country."\n";
                                        $html_mail_changead = "<b>Aenderung der Kundenadresse (Standardadresse): ".$_SESSION['customer_id']."</b><br>".$comp_changead_html.$firstname."<br>".$lastname."<br>".$street_address."<br>".$postcode."<br>".$city."<br>".$fetch['countries_name']."<br>";
                                        $subject_changead = 'Aenderung der Kundenadresse (Standardadresse) im Onlineshop';
                                       

                                        xtc_php_mail(EMAIL_SUPPORT_ADDRESS, EMAIL_SUPPORT_NAME, EMAIL_SUPPORT_ADDRESS, EMAIL_SUPPORT_NAME, EMAIL_SUPPORT_FORWARDING_STRING, EMAIL_SUPPORT_REPLY_ADDRESS, EMAIL_SUPPORT_REPLY_ADDRESS_NAME, '', '', $subject_changead, $html_mail_changead, $txt_mail_changead);

                                                /* send mail to admin */




                                xtc_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '".(int) $_SESSION['customer_id']."'");
                        }
                } else {
                        $sql_data_array['customers_id'] = (int) $_SESSION['customer_id'];
                        $sql_data_array['address_date_added'] = 'now()';
                        xtc_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

                        $new_address_book_id = xtc_db_insert_id();

                        // reregister session variables
                        if (isset ($_POST['primary']) && ($_POST['primary'] == 'on')) {
                                $_SESSION['customer_first_name'] = $firstname;
                                $_SESSION['customer_country_id'] = $country_id;
                                $_SESSION['customer_zone_id'] = (($zone_id > 0) ? (int) $zone_id : '0');
                                if (isset ($_POST['primary']) && ($_POST['primary'] == 'on'))
                                        $_SESSION['customer_default_address_id'] = $new_address_book_id;

                                $sql_data_array = array ('customers_firstname' => $firstname, 'customers_lastname' => $lastname,'customers_last_modified' => 'now()','customers_date_added' => 'now()');

                                if (ACCOUNT_GENDER == 'true')
                                        $sql_data_array['customers_gender'] = $gender;
                                if (isset ($_POST['primary']) && ($_POST['primary'] == 'on'))
                                        $sql_data_array['customers_default_address_id'] = $new_address_book_id;


                                xtc_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '".(int) $_SESSION['customer_id']."'");
                        }
                }

                $messageStack->add_session('addressbook', SUCCESS_ADDRESS_BOOK_ENTRY_UPDATED, 'success');

                xtc_redirect(xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
        }
}

if (isset ($_GET['edit']) && is_numeric($_GET['edit'])) {
        $entry_query = xtc_db_query("select entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_zone_id, entry_country_id from ".TABLE_ADDRESS_BOOK." where customers_id = '".(int) $_SESSION['customer_id']."' and address_book_id = '".(int) $_GET['edit']."'");

        if (xtc_db_num_rows($entry_query) == false) {
                $messageStack->add_session('addressbook', ERROR_NONEXISTING_ADDRESS_BOOK_ENTRY);

                xtc_redirect(xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
        }

        $entry = xtc_db_fetch_array($entry_query);
}
elseif (isset ($_GET['delete']) && is_numeric($_GET['delete'])) {
        if ($_GET['delete'] == $_SESSION['customer_default_address_id']) {
                $messageStack->add_session('addressbook', WARNING_PRIMARY_ADDRESS_DELETION, 'warning');

                xtc_redirect(xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
        } else {
                $check_query = xtc_db_query("select count(*) as total from ".TABLE_ADDRESS_BOOK." where address_book_id = '".(int) $_GET['delete']."' and customers_id = '".(int) $_SESSION['customer_id']."'");
                $check = xtc_db_fetch_array($check_query);

                if ($check['total'] < 1) {
                        $messageStack->add_session('addressbook', ERROR_NONEXISTING_ADDRESS_BOOK_ENTRY);

                        xtc_redirect(xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
                }
        }
} else {
        $entry = array ();
}

if (!isset ($_GET['delete']) && !isset ($_GET['edit'])) {
        if (xtc_count_customer_address_book_entries() >= MAX_ADDRESS_BOOK_ENTRIES) {
                $messageStack->add_session('addressbook', ERROR_ADDRESS_BOOK_FULL);

                xtc_redirect(xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));
        }
}

$breadcrumb->add(NAVBAR_TITLE_1_ADDRESS_BOOK_PROCESS, xtc_href_link(FILENAME_ACCOUNT, '', 'SSL'));
$breadcrumb->add(NAVBAR_TITLE_2_ADDRESS_BOOK_PROCESS, xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL'));

if (isset ($_GET['edit']) && is_numeric($_GET['edit'])) {
        $breadcrumb->add(NAVBAR_TITLE_MODIFY_ENTRY_ADDRESS_BOOK_PROCESS, xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'edit='.$_GET['edit'], 'SSL'));
}
elseif (isset ($_GET['delete']) && is_numeric($_GET['delete'])) {
        $breadcrumb->add(NAVBAR_TITLE_DELETE_ENTRY_ADDRESS_BOOK_PROCESS, xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'delete='.$_GET['delete'], 'SSL'));
} else {
        $breadcrumb->add(NAVBAR_TITLE_ADD_ENTRY_ADDRESS_BOOK_PROCESS, xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, '', 'SSL'));
}

require (DIR_WS_INCLUDES.'header.php');
if (isset ($_GET['delete']) == false)
        $action = xtc_draw_form('addressbook', xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, (isset ($_GET['edit']) ? 'edit='.$_GET['edit'] : ''), 'SSL'), 'post', 'onsubmit="return check_form(addressbook);"');

$smarty->assign('FORM_ACTION', $action);
if ($messageStack->size('addressbook') > 0) {
        $smarty->assign('error', $messageStack->output('addressbook'));

}

if (isset ($_GET['delete'])) {
        $smarty->assign('delete', '1');
        $smarty->assign('ADDRESS', xtc_address_label($_SESSION['customer_id'], $_GET['delete'], true, ' ', '<br />'));

        $smarty->assign('BUTTON_BACK', '<a href="'.xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL').'">'.xtc_image_button('button_back.gif', IMAGE_BUTTON_BACK).'</a>');
        $smarty->assign('BUTTON_DELETE', '<a href="'.xtc_href_link(FILENAME_ADDRESS_BOOK_PROCESS, 'delete='.$_GET['delete'].'&action=deleteconfirm', 'SSL').'">'.xtc_image_button('button_delete.gif', IMAGE_BUTTON_DELETE).'</a>');
} else {

        include (DIR_WS_MODULES.'address_book_details.php');

        if (isset ($_GET['edit']) && is_numeric($_GET['edit'])) {
                $smarty->assign('BUTTON_BACK', '<a href="'.xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL').'">'.xtc_image_button('button_back.gif', IMAGE_BUTTON_BACK).'</a>');
                $smarty->assign('BUTTON_UPDATE', xtc_draw_hidden_field('action', 'update').xtc_draw_hidden_field('edit', $_GET['edit']).xtc_image_submit('button_update.gif', IMAGE_BUTTON_UPDATE));

        } else {
                if (sizeof($_SESSION['navigation']->snapshot) > 0) {
                        $back_link = xtc_href_link($_SESSION['navigation']->snapshot['page'], xtc_array_to_string($_SESSION['navigation']->snapshot['get'], array (xtc_session_name())), $_SESSION['navigation']->snapshot['mode']);
                } else {
                        $back_link = xtc_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL');
                }
                $smarty->assign('BUTTON_BACK', '<a href="'.$back_link.'">'.xtc_image_button('button_back.gif', IMAGE_BUTTON_BACK).'</a>');
                $smarty->assign('BUTTON_UPDATE', xtc_draw_hidden_field('action', 'process').xtc_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE));

        }
        $smarty->assign('FORM_END', '</form>');

}

$smarty->assign('language', $_SESSION['language']);
$smarty->caching = 0;
$main_content = $smarty->fetch(CURRENT_TEMPLATE.'/module/address_book_process.html');

$smarty->assign('language', $_SESSION['language']);
$smarty->assign('main_content', $main_content);
$smarty->caching = 0;
if (!defined(RM))
        $smarty->load_filter('output', 'note');
$smarty->display(CURRENT_TEMPLATE.'/index.html');
include ('includes/application_bottom.php');
?>

Linkback: https://www.modified-shop.org/forum/index.php?topic=35383.0

[hpzeller]

Füge unmittelbar vor

Code: PHP  [Auswählen]

$txt_mail_changead = "Aenderung der Kundenadresse (Standardadresse):\t".$_SESSION['customer_id']."\n".$comp_changead_txt.$firstname."\n".$lastname."\n".$street_address."\n".$postcode."\n".$city."\n".$country."\n";
 

diesen Code ein

Code: PHP  [Auswählen]

$c_query = xtc_db_query("select customers_cid as cid from ".TABLE_CUSTOMERS." where customers_id = '".(int) $_SESSION['customer_id']."'");
$c = xtc_db_fetch_array($c_query);
 

jetzt kannst Du anstelle $_SESSION['customer_id'] mit $c['cid'] die Kundennummer hier übertragen, sofern der Kunde eine Kundennummer hat.

Code: PHP  [Auswählen]

$txt_mail_changead = "Aenderung der Kundenadresse (Standardadresse):\t".$c['cid']."\n".$comp_changead_txt.$firstname."\n".$lastname."\n".$street_address."\n".$postcode."\n".$city."\n".$country."\n";
$html_mail_changead = "<b>Aenderung der Kundenadresse (Standardadresse): ".$c['cid']."</b><br>".$comp_changead_html.$firstname."<br>".$lastname."<br>".$street_address."<br>".$postcode."<br>".$city."<br>".$fetch['countries_name']."<br>";
 

Gruss
Hanspeter

[spacebon]

Vieieielen Dank - das klappt!!!

Grüße

Spacebon