Faxnummer (customers_fax) in der Datenbank order einfügen

MyOOS hat einen Fehler, oder tut nicht das, was Ihr erwartet? Derartige "Unanehmlichkeiten" bitte hier.
Antworten
wolfschw
Beiträge: 396
Registriert: 01.03.2009, 21:23
Wohnort: Ilshofen
Kontaktdaten:

Faxnummer (customers_fax) in der Datenbank order einfügen

Beitrag von wolfschw »

Hallo

Wie kann ich die Faxnummer der Kunden mit in der Datenbank order einfügen?

Habe bereits in der Datenbank order die customers_fax angelegt.
Bekomme es aber nicht hin, das in dem Feld customers_fax die Faxnummer der Kunden mit eingetragen wird.

gruß

Wolfgang
r23
Beiträge: 2624
Registriert: 18.09.2008, 05:56
Wohnort: Hagen
Kontaktdaten:

Beitrag von r23 »

Hallo,

in der class_order.php die Fax-Nummer abfragen und in den Kunden-Array schreiben. z.b.

Code: Alles auswählen

      $this->customer = array('id' => $order['customers_id],
                              'name' => $order['customers_name],
                              'company' => $order['customers_company],
                              'street_address' => $order['customers_street_address],
                              'suburb' => $order['customers_suburb],
                              'city' => $order['customers_city],
                              'postcode' => $order['customers_postcode],
                              'state' => $order['customers_state],
                              'country' => $order['customers_country],
                              'format_id' => $order['customers_address_format_id],
                              'telephone' => $order['customers_telephone],
                              'email_address' => $order['customers_email_address]);
hier unter telephone eine fax eingeben

Code: Alles auswählen

  'fax' => $order['customers_datenfeld_fuer_fax], ;
danch steht die fax-Nummer in
~/checkout/process.php

Code: Alles auswählen

$oOrder->customer['fax],
zur Verfüguing und kann in eingefügt werden

Code: Alles auswählen

$sql_data_array = array('customers_id' => $_SESSION['customer_id],
                          'customers_name' => $oOrder->customer['firstname] . ' ' . $oOrder->customer['lastname],
                          'customers_company' => $oOrder->customer['company],
                          'customers_street_address' => $oOrder->customer['street_address],
                          'customers_suburb' => $oOrder->customer['suburb],
                          'customers_city' => $oOrder->customer['city],
                          'customers_postcode' => $oOrder->customer['postcode],
                          'customers_state' => $oOrder->customer['state],
                          'customers_country' => $oOrder->customer['country]['title],
                          'customers_telephone' => $oOrder->customer['telephone],
                          'customers_email_address' => $oOrder->customer['email_address],
                          'customers_address_format_id' => $oOrder->customer['format_id],
                          'delivery_name' => $oOrder->delivery['firstname] . ' ' . $oOrder->delivery['lastname],
                          'delivery_company' => $oOrder->delivery['company],
                          'delivery_street_address' => $oOrder->delivery['street_address],
                          'delivery_suburb' => $oOrder->delivery['suburb],
                          'delivery_city' => $oOrder->delivery['city],
                          'delivery_postcode' => $oOrder->delivery['postcode],
                          'delivery_state' => $oOrder->delivery['state],
                          'delivery_country' => $oOrder->delivery['country]['title],
                          'delivery_address_format_id' => $oOrder->delivery['format_id],
                          'billing_name' => $oOrder->billing['firstname] . ' ' . $oOrder->billing['lastname],
                          'billing_company' => $oOrder->billing['company],
                          'billing_street_address' => $oOrder->billing['street_address],
                          'billing_suburb' => $oOrder->billing['suburb],
                          'billing_city' => $oOrder->billing['city],
                          'billing_postcode' => $oOrder->billing['postcode],
                          'billing_state' => $oOrder->billing['state],
                          'billing_country' => $oOrder->billing['country]['title],
                          'billing_address_format_id' => $oOrder->billing['format_id],
                          'payment_method' => $oOrder->info['payment_method],
                          'cc_type' => $oOrder->info['cc_type],
                          'cc_owner' => $oOrder->info['cc_owner],
                          'cc_number' => $oOrder->info['cc_number],
                          'cc_expires' => $oOrder->info['cc_expires],
                          'date_purchased' => 'now()',
                          'last_modified' => 'now()',
                          'campaigns' => $_SESSION['campaigns_id],
                          'orders_status' => $oOrder->info['order_status],
                          'currency' => $oOrder->info['currency],
                          'currency_value' => $oOrder->info['currency_value],
                          'orders_language' => $_SESSION['language]);

  oos_db_perform($oostable['orders], $sql_data_array);
Beste Grüße

ralf
Antworten