Gast Konto mit Geburtsdatum?

[Aworka]

Hallo,

ich habe folgendes Problem:
Wenn jemand als Gast bestellt kann ich bei den Bestellungen seine Daten einsehen.
Leider steht dort aber nicht das Geburtsdatum der Person.
Da ich einige Artikel aber ab 18 verkaufe muss ich dieses Datum einsehen können.
Gibt es eine Möglichkeit dies sichtbar zu machen?


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

[DokuMan]

Das ist eine sehr gute Anregung, allerdings so ohne weiteres nicht möglich, da in der Tabelle "orders" das Geburtsdatum des Kunden leider nicht gespeichert wird.

Das wäre aber bei Gastbestellungen notwendig.

[Aworka]

Und was mache ich dann nun? Gibt es ein Workaround?
Dem Kunden extra eine E-Mail schreiben möchte ich nicht. Das ist zum einen aufwendig und zum anderen dauert es zu lange

[franky_n]

Hallo Aworka,

Erstmal muss man in der Datenbank ein Feld in der Tabelle orders zufügen mit phpmyadmin und der SQL Zeile:

Code: SQL  [Auswählen]

ALTER TABLE orders ADD customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL AFTER customers_lastname;

Danach dann die Quelltext Änderungen.

"/includes/classes/order.php" in Z.165 nach:

Code: PHP  [Auswählen]

                              'name' => $order['customers_name'],
                              'firstname' => $order['customers_firstname'],
                              'lastname' => $order['customers_lastname'],

das einfügen:

Code: PHP  [Auswählen]

                              'dob' => $order['customers_dob'],

"checkout_process.php" in Z.126 das ersetzen:

Code: PHP  [Auswählen]

if ($_SESSION['credit_covers'] != '1') {
        $sql_data_array = array ('customers_id' => $_SESSION['customer_id'], 'customers_name' => $order->customer['firstname'].' '.$order->customer['lastname'], 'customers_firstname' => $order->customer['firstname'], 'customers_lastname' => $order->customer['lastname'], 'customers_cid' => $order->customer['csID'], 'customers_vat_id' => $_SESSION['customer_vat_id'], 'customers_company' => $order->customer['company'], 'customers_status' => $_SESSION['customers_status']['customers_status_id'], 'customers_status_name' => $_SESSION['customers_status']['customers_status_name'], 'customers_status_image' => $_SESSION['customers_status']['customers_status_image'], 'customers_status_discount' => $discount, 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'].' '.$order->delivery['lastname'], 'delivery_firstname' => $order->delivery['firstname'], 'delivery_lastname' => $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_country_iso_code_2' => $order->delivery['country']['iso_code_2'], 'delivery_address_format_id' => $order->delivery['format_id'], 'billing_name' => $order->billing['firstname'].' '.$order->billing['lastname'], 'billing_firstname' => $order->billing['firstname'], 'billing_lastname' => $order->billing['lastname'], 'billing_company' => $order->billing['company'], 'billing_street_address' => $order->billing['street_address'], 'billing_suburb' => $order->billing['suburb'], 'billing_city' => $order->billing['city'], 'billing_postcode' => $order->billing['postcode'], 'billing_state' => $order->billing['state'], 'billing_country' => $order->billing['country']['title'], 'billing_country_iso_code_2' => $order->billing['country']['iso_code_2'], 'billing_address_format_id' => $order->billing['format_id'], 'payment_method' => $order->info['payment_method'], 'payment_class' => $order->info['payment_class'], 'shipping_method' => $order->info['shipping_method'], 'shipping_class' => $order->info['shipping_class'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'cc_start' => $order->info['cc_start'], 'cc_cvv' => $order->info['cc_cvv'], 'cc_issue' => $order->info['cc_issue'], 'date_purchased' => 'now()', 'orders_status' => $tmp_status, 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value'], 'customers_ip' => $customers_ip, 'language' => $_SESSION['language'], 'comments' => $order->info['comments']);
} else {
        // free gift , no paymentaddress
        $sql_data_array = array ('customers_id' => $_SESSION['customer_id'], 'customers_name' => $order->customer['firstname'].' '.$order->customer['lastname'], 'customers_firstname' => $order->customer['firstname'], 'customers_lastname' => $order->customer['lastname'], 'customers_cid' => $order->customer['csID'], 'customers_vat_id' => $_SESSION['customer_vat_id'], 'customers_company' => $order->customer['company'], 'customers_status' => $_SESSION['customers_status']['customers_status_id'], 'customers_status_name' => $_SESSION['customers_status']['customers_status_name'], 'customers_status_image' => $_SESSION['customers_status']['customers_status_image'], 'customers_status_discount' => $discount, 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'].' '.$order->delivery['lastname'], 'delivery_firstname' => $order->delivery['firstname'], 'delivery_lastname' => $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_country_iso_code_2' => $order->delivery['country']['iso_code_2'], 'delivery_address_format_id' => $order->delivery['format_id'], 'payment_method' => $order->info['payment_method'], 'payment_class' => $order->info['payment_class'], 'shipping_method' => $order->info['shipping_method'], 'shipping_class' => $order->info['shipping_class'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => $tmp_status, 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value'], 'customers_ip' => $customers_ip, 'comments' => $order->info['comments']);
}

durch das:

Code: PHP  [Auswählen]

if ($_SESSION['credit_covers'] != '1') {
        $sql_data_array = array ('customers_id' => $_SESSION['customer_id'], 'customers_name' => $order->customer['firstname'].' '.$order->customer['lastname'], 'customers_firstname' => $order->customer['firstname'], 'customers_lastname' => $order->customer['lastname'], 'customers_dob' => $order->customer['dob'], 'customers_cid' => $order->customer['csID'], 'customers_vat_id' => $_SESSION['customer_vat_id'], 'customers_company' => $order->customer['company'], 'customers_status' => $_SESSION['customers_status']['customers_status_id'], 'customers_status_name' => $_SESSION['customers_status']['customers_status_name'], 'customers_status_image' => $_SESSION['customers_status']['customers_status_image'], 'customers_status_discount' => $discount, 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'].' '.$order->delivery['lastname'], 'delivery_firstname' => $order->delivery['firstname'], 'delivery_lastname' => $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_country_iso_code_2' => $order->delivery['country']['iso_code_2'], 'delivery_address_format_id' => $order->delivery['format_id'], 'billing_name' => $order->billing['firstname'].' '.$order->billing['lastname'], 'billing_firstname' => $order->billing['firstname'], 'billing_lastname' => $order->billing['lastname'], 'billing_company' => $order->billing['company'], 'billing_street_address' => $order->billing['street_address'], 'billing_suburb' => $order->billing['suburb'], 'billing_city' => $order->billing['city'], 'billing_postcode' => $order->billing['postcode'], 'billing_state' => $order->billing['state'], 'billing_country' => $order->billing['country']['title'], 'billing_country_iso_code_2' => $order->billing['country']['iso_code_2'], 'billing_address_format_id' => $order->billing['format_id'], 'payment_method' => $order->info['payment_method'], 'payment_class' => $order->info['payment_class'], 'shipping_method' => $order->info['shipping_method'], 'shipping_class' => $order->info['shipping_class'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'cc_start' => $order->info['cc_start'], 'cc_cvv' => $order->info['cc_cvv'], 'cc_issue' => $order->info['cc_issue'], 'date_purchased' => 'now()', 'orders_status' => $tmp_status, 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value'], 'customers_ip' => $customers_ip, 'language' => $_SESSION['language'], 'comments' => $order->info['comments']);
} else {
        // free gift , no paymentaddress
        $sql_data_array = array ('customers_id' => $_SESSION['customer_id'], 'customers_name' => $order->customer['firstname'].' '.$order->customer['lastname'], 'customers_firstname' => $order->customer['firstname'], 'customers_lastname' => $order->customer['lastname'], 'customers_dob' => $order->customer['dob'], 'customers_cid' => $order->customer['csID'], 'customers_vat_id' => $_SESSION['customer_vat_id'], 'customers_company' => $order->customer['company'], 'customers_status' => $_SESSION['customers_status']['customers_status_id'], 'customers_status_name' => $_SESSION['customers_status']['customers_status_name'], 'customers_status_image' => $_SESSION['customers_status']['customers_status_image'], 'customers_status_discount' => $discount, 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'].' '.$order->delivery['lastname'], 'delivery_firstname' => $order->delivery['firstname'], 'delivery_lastname' => $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_country_iso_code_2' => $order->delivery['country']['iso_code_2'], 'delivery_address_format_id' => $order->delivery['format_id'], 'payment_method' => $order->info['payment_method'], 'payment_class' => $order->info['payment_class'], 'shipping_method' => $order->info['shipping_method'], 'shipping_class' => $order->info['shipping_class'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => $tmp_status, 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value'], 'customers_ip' => $customers_ip, 'comments' => $order->info['comments']);
}

"send_order.php" nach Z.57:

Code: PHP  [Auswählen]

        $smarty->assign('PHONE',$order->customer['telephone']);

das einfügen:

Code: PHP  [Auswählen]

        $smarty->assign('BIRTH',$order->customer['bod']);

und nach Z.97:

Code: PHP  [Auswählen]

        $order_subject = str_replace('{$date}', strftime(DATE_FORMAT_LONG), $order_subject);
        $order_subject = str_replace('{$lastname}', $order->customer['lastname'], $order_subject);
        $order_subject = str_replace('{$firstname}', $order->customer['firstname'], $order_subject);

das einfügen:

Code: PHP  [Auswählen]

        $order_subject = str_replace('{$dob}', $order->customer['dob'], $order_subject);

Nun kann man dann in der /templates/xtc5/mail/german/order.html und order.txt an beliebiger Stelle ein:

Code: PHP  [Auswählen]

{$BIRTH}

einfügen oder in der Betreffzeile (im Adminbereich) der Mail ein:

Code: PHP  [Auswählen]

{$dob}

ACHTUNG: Ist ungetestet, also vorher Sicherheitskopie!

Viele Grüße

Franky

[Tomcraft]

Hallo Aworka,

noch nicht zum Testen gekommen?

Grüße

Torsten

[Aworka]

Ich habe leider noch keinen Test Shop noch die Zeit das zu testen. Ich muss also sichergehen, dass es funktioniert, da ich meinen Shop nicht mal eben offline nehmen kann.
Evtl. finde ich am Wochenende Zeit das zu testen.
Ich danke euch schon einmal und berichte dann.

[DokuMan]

Falls du dir einen Testshop "auf die Schnelle" lokal aufsetzen willst, kannst du auch unser XAMPP-Paket (siehe meine Signatur) benutzen und dort einfach deine Datenbank einspielen.

[Aworka]

Gerade mal probiert und kläglich gescheitert. Ich hab die Datenbank versucht zu importieren (sowohl mit phpMyAdmin und im Shop selbst).
Und beides hat einen Fehler verursacht.

[franky_n]

Hallo Aworka,

[...]
Und beides hat einen Fehler verursacht.

der da lautet?

Viele Grüße

Franky

[Aworka]

Dieser hier:

Code: SQL  [Auswählen]

INSERT INTO `products` (`products_id`, `products_ean`, `products_quantity`, `products_shippingtime`, `products_model`, `group_permission_0`, `group_permission_1`, `group_permission_2`, `group_permission_3`, `products_sort`, `products_image`, `products_price`, `products_discount_allowed`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `product_template`, `options_template`, `manufacturers_id`, `products_ordered`, `products_fsk18`, `products_vpe`, `products_vpe_status`, `products_vpe_value`, `products_startpage`, `products_startpage_sort`, `nc_ultra_shipping_costs`) VALUES ('1','','0','1','0001','0','0','0','0','0','1_0.jpg','1.1000','0.00','2010-09-29 16:24:46','2010-10-21 13:21:13',NULL,'0.10','0','0','product_info_x_accordion_v1.html','default','0','4','0','0','0','1.0000','0','1','0.0000'); -> mysql_error

[Aworka]

Ok also bei mir ist nun die "checkout_process.php" kaputt.

Code: PHP  [Auswählen]

Parse error: syntax error, unexpected T_STRING in F:\xampp\htdocs\modified eCommerce Shopsoftware-1.05\checkout_process.php on line 137

[franky_n]

Hallo Aworka,

sicher das Du nicht irgendwas falsch kopiert hast?
Also ich sehe hier bei dem Quellcode der "checkout.php" den ich gepostet habe derzeit keinen Schreibfehler:

Code: PHP  [Auswählen]

    if ($_SESSION['credit_covers'] != '1') {
      $sql_data_array = array ('customers_id' => $_SESSION['customer_id'],
                               'customers_name' => $order->customer['firstname'].' '.$order->customer['lastname'],
                               'customers_firstname' => $order->customer['firstname'],
                               'customers_lastname' => $order->customer['lastname'],
                               'customers_dob' => $order->customer['dob'],
                               'customers_cid' => $order->customer['csID'],
                               'customers_vat_id' => $_SESSION['customer_vat_id'],
                               'customers_company' => $order->customer['company'],
                               'customers_status' => $_SESSION['customers_status']['customers_status_id'],
                               'customers_status_name' => $_SESSION['customers_status']['customers_status_name'],
                               'customers_status_image' => $_SESSION['customers_status']['customers_status_image'],
                               'customers_status_discount' => $discount,
                               'customers_street_address' => $order->customer['street_address'],
                               'customers_suburb' => $order->customer['suburb'],
                               'customers_city' => $order->customer['city'],
                               'customers_postcode' => $order->customer['postcode'],
                               'customers_state' => $order->customer['state'],
                               'customers_country' => $order->customer['country']['title'],
                               'customers_telephone' => $order->customer['telephone'],
                               'customers_email_address' => $order->customer['email_address'],
                               'customers_address_format_id' => $order->customer['format_id'],
                               'delivery_name' => $order->delivery['firstname'].' '.$order->delivery['lastname'],
                               'delivery_firstname' => $order->delivery['firstname'],
                               'delivery_lastname' => $order->delivery['lastname'],
                               'delivery_company' => $order->delivery['company'],
                               'delivery_street_address' => $order->delivery['street_address'],
                               'delivery_suburb' => $order->delivery['suburb'],
                               'delivery_city' => $order->delivery['city'],
                               'delivery_postcode' => $order->delivery['postcode'],
                               'delivery_state' => $order->delivery['state'],
                               'delivery_country' => $order->delivery['country']['title'],
                               'delivery_country_iso_code_2' => $order->delivery['country']['iso_code_2'],
                               'delivery_address_format_id' => $order->delivery['format_id'],
                               'billing_name' => $order->billing['firstname'].' '.$order->billing['lastname'],
                               'billing_firstname' => $order->billing['firstname'],
                               'billing_lastname' => $order->billing['lastname'],
                               'billing_company' => $order->billing['company'],
                               'billing_street_address' => $order->billing['street_address'],
                               'billing_suburb' => $order->billing['suburb'],
                               'billing_city' => $order->billing['city'],
                               'billing_postcode' => $order->billing['postcode'],
                               'billing_state' => $order->billing['state'],
                               'billing_country' => $order->billing['country']['title'],
                               'billing_country_iso_code_2' => $order->billing['country']['iso_code_2'],
                               'billing_address_format_id' => $order->billing['format_id'],
                               'payment_method' => $order->info['payment_method'],
                               'payment_class' => $order->info['payment_class'],
                               'shipping_method' => $order->info['shipping_method'],
                               'shipping_class' => $order->info['shipping_class'],
                               'cc_type' => $order->info['cc_type'],
                               'cc_owner' => $order->info['cc_owner'],
                               'cc_number' => $order->info['cc_number'],
                               'cc_expires' => $order->info['cc_expires'],
                               'cc_start' => $order->info['cc_start'],
                               'cc_cvv' => $order->info['cc_cvv'],
                               'cc_issue' => $order->info['cc_issue'],
                               'date_purchased' => 'now()',
                               'orders_status' => $tmp_status,
                               'currency' => $order->info['currency'],
                               'currency_value' => $order->info['currency_value'],
                               'customers_ip' => $customers_ip,
                               'language' => $_SESSION['language'],
                               'comments' => $order->info['comments']
                               );
    } else {
      // free gift , no paymentaddress
      $sql_data_array = array ('customers_id' => $_SESSION['customer_id'],
                               'customers_name' => $order->customer['firstname'].' '.$order->customer['lastname'],
                               'customers_firstname' => $order->customer['firstname'],
                               'customers_lastname' => $order->customer['lastname'],
                               'customers_dob' => $order->customer['dob'],
                               'customers_cid' => $order->customer['csID'],
                               'customers_vat_id' => $_SESSION['customer_vat_id'],
                               'customers_company' => $order->customer['company'],
                               'customers_status' => $_SESSION['customers_status']['customers_status_id'],
                               'customers_status_name' => $_SESSION['customers_status']['customers_status_name'],
                               'customers_status_image' => $_SESSION['customers_status']['customers_status_image'],
                               'customers_status_discount' => $discount,
                               'customers_street_address' => $order->customer['street_address'],
                               'customers_suburb' => $order->customer['suburb'],
                               'customers_city' => $order->customer['city'],
                               'customers_postcode' => $order->customer['postcode'],
                               'customers_state' => $order->customer['state'],
                               'customers_country' => $order->customer['country']['title'],
                               'customers_telephone' => $order->customer['telephone'],
                               'customers_email_address' => $order->customer['email_address'],
                               'customers_address_format_id' => $order->customer['format_id'],
                               'delivery_name' => $order->delivery['firstname'].' '.$order->delivery['lastname'],
                               'delivery_firstname' => $order->delivery['firstname'],
                               'delivery_lastname' => $order->delivery['lastname'],
                               'delivery_company' => $order->delivery['company'],
                               'delivery_street_address' => $order->delivery['street_address'],
                               'delivery_suburb' => $order->delivery['suburb'],
                               'delivery_city' => $order->delivery['city'],
                               'delivery_postcode' => $order->delivery['postcode'],
                               'delivery_state' => $order->delivery['state'],
                               'delivery_country' => $order->delivery['country']['title'],
                               'delivery_country_iso_code_2' => $order->delivery['country']['iso_code_2'],
                               'delivery_address_format_id' => $order->delivery['format_id'],
                               'payment_method' => $order->info['payment_method'],
                               'payment_class' => $order->info['payment_class'],
                               'shipping_method' => $order->info['shipping_method'],
                               'shipping_class' => $order->info['shipping_class'],
                               'cc_type' => $order->info['cc_type'],
                               'cc_owner' => $order->info['cc_owner'],
                               'cc_number' => $order->info['cc_number'],
                               'cc_expires' => $order->info['cc_expires'],
                               'date_purchased' => 'now()',
                               'orders_status' => $tmp_status,
                               'currency' => $order->info['currency'],
                               'currency_value' => $order->info['currency_value'],
                               'customers_ip' => $customers_ip,
                               'comments' => $order->info['comments']
                               );
    }

Hab es nochmal leserlich formatiert...

Sieht mir eher danach aus das Du aus Versehen eine Klammer zu viel wegkopiert hast...
Probier nochmal mit der Original Datei aus!

Viele Grüße

Franky

[Aworka]

Jetzt geht es wieder. Nächstes Problem: Im Testshop kann ich jetzt das Geburtsdatum sehen, aber im richtigen Shop geht es nicht.
Ich bin die Anleitung jetzt mehrmals durchgegangen und sehe meinen Fehler nicht.
Muss ich nicht noch unter "/admin/orders.php" noch ändern?

[franky_n]

Hallo Aworka,

was soll ich Dir jetzt antworten? 
Ich sitze nicht vor Deinem Rechner!

Könnte höchstens sein das Du noch eine Sache vergessen hast oder aber sich die Shops untereinander unterscheiden...
Aber Du hast doch beide als Version 1.05 oder?

Viele Grüße

Franky

[Aworka]

Beide haben 1.05 es wurden im Online-Shop ein Paypal Modul ,sowie ein Bestellbestätigungs Modul eingebaut

Wie eben schon im "Edit": Muss ich nicht unter "/admin/orders.php" noch anpassen?