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
Faxnummer (customers_fax) in der Datenbank order einfügen
Hallo,
in der class_order.php die Fax-Nummer abfragen und in den Kunden-Array schreiben. z.b.
hier unter telephone eine fax eingeben
danch steht die fax-Nummer in
~/checkout/process.php
zur Verfüguing und kann in eingefügt werden
Beste Grüße
ralf
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]);
Code: Alles auswählen
'fax' => $order['customers_datenfeld_fuer_fax], ;
~/checkout/process.php
Code: Alles auswählen
$oOrder->customer['fax],
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);
ralf