mode303
21.12.2006, 09:20
Hi,
stell ich mich bloß so blöd an oder wie...
Ich habe als Zahlungsmethode Lastsschrift "banktransfer" gewählt und beim Zahlvorgang kann ich auch meine Bankverbindung angeben. Diese wird auch in der datenbank zu der Bestellung gespeichert, allerdings sehe ich diese daten nurgendswo in der order_mail.html
Was muß ich denn da eingeben und müßte das nicht eigentlich auch so funktionieren? Denn was bringt mir die bankverbindung, wenn ich sie erst aus der DB entnehmen muss.
Hatte schon folgenden Artikel versucht, aber ohne Erfolg:
Ecombase Beitrag (http://www.ecombase.de/forum/index.php?showtopic=1671&hl=bankverbindung)
Mit der test.php erhalte ich ebenfalls True als Ausgabe.
Jemand ne Idee...
Anbei hier mal die send_order.php
''>ZITAT</div><?php
/ -----------------------------------------------------------------------------------------
$Id: send_order.php 1029 2005-07-14 19:08:49Z mz $
XT-Commerce - community made shopping
http://www.xt-commerce.com (http://anonym.to/?http://www.xt-commerce.com)
Copyright © 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
© 2003 nextcommerce (send_order.php,v 1.1 2003/08/24); www.nextcommerce.org
Released under the GNU General Public License
--------------------------------------------------------------------------------------- /
require_once (DIR_FS_INC.'xtc_get_order_data.inc.php');
require_once (DIR_FS_INC.'xtc_get_attributes_model.inc.php');
// check if customer is allowed to send this order!
$order_query_check = xtc_db_query("SELECT
customers_id
FROM ".TABLE_ORDERS."
WHERE orders_id='".$insert_id."'");
$order_check = xtc_db_fetch_array($order_query_check);
if ($_SESSION['customer_id'] == $order_check['customers_id']) {
$order = new order($insert_id);
$smarty->assign('address_label_customer', xtc_address_format($order->customer['format_id'], $order->customer, 1, '', '
'));
$smarty->assign('address_label_shipping', xtc_address_format($order->delivery['format_id'], $order->delivery, 1, '', '
'));
if ($_SESSION['credit_covers'] != '1') {
$smarty->assign('address_label_payment', xtc_address_format($order->billing['format_id'], $order->billing, 1, '', '
'));
}
$smarty->assign('csID', $order->customer['csID']);
if(MODULE_PAYMENT_BANKTRANSFER_STATUS == 'True' and $order->info['payment_method'] == 'banktransfer'){
$smarty->assign('bank','1');
$smarty->assign('bank_owner',$banktransfer_owner);
$smarty->assign('bank_number',$banktransfer_number);
$smarty->assign('bank_bankname',$banktransfer_bankname);
$smarty->assign('bank_blz',$banktransfer_blz);
}
// get products data
$order_query = xtc_db_query("SELECT
products_id,
orders_products_id,
products_model,
products_name,
final_price,
products_quantity
FROM ".TABLE_ORDERS_PRODUCTS."
WHERE orders_id='".$insert_id."'");
$order_data = array ();
while ($order_data_values = xtc_db_fetch_array($order_query)) {
$attributes_query = xtc_db_query("SELECT
products_options,
products_options_values,
price_prefix,
options_values_price
FROM ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES."
WHERE orders_products_id='".$order_data_values['orders_products_id']."'");
$attributes_data = '';
$attributes_model = '';
while ($attributes_data_values = xtc_db_fetch_array($attributes_query)) {
$attributes_data .= $attributes_data_values['products_options'].':'.$attributes_data_values['products_options_values'].'
';
$attributes_model .= xtc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values']).'
';
}
$order_data[] = array ('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_PRICE' => $xtPrice->xtcFormat($order_data_values['final_price'], true),'PRODUCTS_SINGLE_PRICE' => $xtPrice->xtcFormat($order_data_values['final_price']/$order_data_values['products_quantity'], true), 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
}
// get order_total data
$oder_total_query = xtc_db_query("SELECT
title,
text,
sort_order
FROM ".TABLE_ORDERS_TOTAL. Anwalt Hamm"
WHERE orders_id='".$insert_id."'
ORDER BY sort_order ASC");
$order_total = array ();
while ($oder_total_values = xtc_db_fetch_array($oder_total_query)) {
$order_total[] = array ('TITLE' => $oder_total_values['title'], 'TEXT' => $oder_total_values['text']);
}
// assign language to template for caching
$smarty->assign('language', $_SESSION['language']);
$smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
$smarty->assign('logo_path', HTTP_SERVER.DIR_WS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/img/');
$smarty->assign('oID', $insert_id);
if ($order->info['payment_method'] != '' && $order->info['payment_method'] != 'no_payment') {
include (DIR_WS_LANGUAGES.$_SESSION['language'].'/modules/payment/'.$order->info['payment_method'].'.php');
$payment_method = constant(strtoupper('MODULE_PAYMENT_'.$order->info['payment_method'].'_TEXT_TITLE'));
}
$smarty->assign('PAYMENT_METHOD', $payment_method);
$smarty->assign('DATE', xtc_date_long($order->info['date_purchased']));
$smarty->assign('order_data', $order_data);
$smarty->assign('order_total', $order_total);
$smarty->assign('NAME', $order->customer['name']);
$smarty->assign('COMMENTS', $order->info['comments']);
$smarty->assign('EMAIL', $order->customer['email_address']);
$smarty->assign('PHONE',$order->customer['telephone']);
// PAYMENT MODUL TEXTS
// EU Bank Transfer
if ($order->info['payment_method'] == 'eustandardtransfer') {
$smarty->assign('PAYMENT_INFO_HTML', MODULE_PAYMENT_EUTRANSFER_TEXT_DESCRIPTION);
$smarty->assign('PAYMENT_INFO_TXT', str_replace("
", "\n", MODULE_PAYMENT_EUTRANSFER_TEXT_DESCRIPTION));
}
// MONEYORDER
if ($order->info['payment_method'] == 'moneyorder') {
$smarty->assign('PAYMENT_INFO_HTML', MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION);
$smarty->assign('PAYMENT_INFO_TXT', str_replace("
", "\n", MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION));
}
// dont allow cache
$smarty->caching = false;
$html_mail = $smarty->fetch(CURRENT_TEMPLATE.'/mail/'.$_SESSION['language'].'/order_mail.html');
$txt_mail = $smarty->fetch(CURRENT_TEMPLATE.'/mail/'.$_SESSION['language'].'/order_mail.txt');
// create subject
$order_subject = str_replace('{$nr}', $insert_id, EMAIL_BILLING_SUBJECT_ORDER);
$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);
// send mail to admin
xtc_php_mail($order->customer['email_address'], $order->customer['firstname'], EMAIL_BILLING_ADDRESS, STORE_NAME, EMAIL_BILLING_FORWARDING_STRING, $order->customer['email_address'], $order->customer['firstname'], '', '', $order_subject, $html_mail, $txt_mail);
// send mail to customer
xtc_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $order->customer['email_address'], $order->customer['firstname'].' '.$order->customer['lastname'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $order_subject, $html_mail, $txt_mail);
if (AFTERBUY_ACTIVATED == 'true') {
require_once (DIR_WS_CLASSES.'afterbuy.php');
$aBUY = new xtc_afterbuy_functions($insert_id);
if ($aBUY->order_send())
$aBUY->process_order();
}
} else {
$smarty->assign('ERROR', 'You are not allowed to view this order!');
$smarty->display(CURRENT_TEMPLATE.'/module/error_message.html');
}
?>[/b]
und hier die Order_mail.html
''>ZITAT</div>{config_load file="$language/lang_$language.conf" section="create_account"}
{php}echo nl2br(STORE_NAME_ADDRESS){/php}
{$address_label_customer}
{#text_tel#} {$PHONE} {if $customer_vat}
{#text_ustid#} {$customer_vat}{/if}
{if $PAYMENT_METHOD}Zahlungsmethode: {$PAYMENT_METHOD}
{/if} Bestellung Nr: {$oID}
Bestelldatum: {$DATE}
{if $csID}Kundennummer: {$csID}
{/if}
Lieferadresse
Rechnungsadresse
{$address_label_shipping}
{$address_label_payment}
Sehr geehrte® {$NAME},
Vielen Dank für Ihre Bestellung in unserem Online-Shop!
{if $PAYMENT_METHOD=='Vorkasse/Überweisung'} Bitte Überweisen Sie den Gesamtbetrag mit der Angabe Ihres Namens und Bestellnummer auf folgendes Konto:
{php} echo nl2br(MODULE_PAYMENT_MONEYORDER_PAYTO); {/php}
Umgehend nach Geldeingang, wird die Ware an die von Ihnen gewünschte Adresse versandt.{/if}
{if $COMMENTS}
Ihre Anmerkungen:
{$COMMENTS}
{/if}
{if $bank}
Bankverbindung
Kontoinhaber: {$bank_owner}
Kontonummer: {$bank_number}
Bank: {$bank_bankname}
BLZ: {$bank_blz}
{/if}
Ihre bestellten Produkte nochmals zur Kontrolle:
Stk.
Produkt
Artikel Nr.
Einzelpreis
Preis
{foreach name=aussen item=order_values from=$order_data}
{$order_values.PRODUCTS_QTY}
x
{$order_values.PRODUCTS_NAME}
{$order_values.PRODUCTS_ATTRIBUTES} {$order_values.NC_SLOGAN} {$order_values.NC_FONT} {$order_values.NC_COLOR} {$order_values.NC_INFO} {$order_values.NC_IMAGENAME} {$order_values.NC_IMAGETYPE} {$order_values.NC_IMAGEINFO}
{$order_values.PRODUCTS_MODEL}
{$order_values.PRODUCTS_ATTRIBUTES_MODEL}
{$order_values.PRODUCTS_SINGLE_PRICE}
{$order_values.PRODUCTS_PRICE}
{/foreach}
{foreach name=aussen item=order_total_values from=$order_total}
{$order_total_values.TITLE}{$order_total_values.TE XT}
{/foreach}
[/b]
Hi,
und im Adminmodus/Bestellungen wird mir die Bankverbindung auch rnichtig angezeigt.
Gruß
stell ich mich bloß so blöd an oder wie...
Ich habe als Zahlungsmethode Lastsschrift "banktransfer" gewählt und beim Zahlvorgang kann ich auch meine Bankverbindung angeben. Diese wird auch in der datenbank zu der Bestellung gespeichert, allerdings sehe ich diese daten nurgendswo in der order_mail.html
Was muß ich denn da eingeben und müßte das nicht eigentlich auch so funktionieren? Denn was bringt mir die bankverbindung, wenn ich sie erst aus der DB entnehmen muss.
Hatte schon folgenden Artikel versucht, aber ohne Erfolg:
Ecombase Beitrag (http://www.ecombase.de/forum/index.php?showtopic=1671&hl=bankverbindung)
Mit der test.php erhalte ich ebenfalls True als Ausgabe.
Jemand ne Idee...
Anbei hier mal die send_order.php
''>ZITAT</div><?php
/ -----------------------------------------------------------------------------------------
$Id: send_order.php 1029 2005-07-14 19:08:49Z mz $
XT-Commerce - community made shopping
http://www.xt-commerce.com (http://anonym.to/?http://www.xt-commerce.com)
Copyright © 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
© 2003 nextcommerce (send_order.php,v 1.1 2003/08/24); www.nextcommerce.org
Released under the GNU General Public License
--------------------------------------------------------------------------------------- /
require_once (DIR_FS_INC.'xtc_get_order_data.inc.php');
require_once (DIR_FS_INC.'xtc_get_attributes_model.inc.php');
// check if customer is allowed to send this order!
$order_query_check = xtc_db_query("SELECT
customers_id
FROM ".TABLE_ORDERS."
WHERE orders_id='".$insert_id."'");
$order_check = xtc_db_fetch_array($order_query_check);
if ($_SESSION['customer_id'] == $order_check['customers_id']) {
$order = new order($insert_id);
$smarty->assign('address_label_customer', xtc_address_format($order->customer['format_id'], $order->customer, 1, '', '
'));
$smarty->assign('address_label_shipping', xtc_address_format($order->delivery['format_id'], $order->delivery, 1, '', '
'));
if ($_SESSION['credit_covers'] != '1') {
$smarty->assign('address_label_payment', xtc_address_format($order->billing['format_id'], $order->billing, 1, '', '
'));
}
$smarty->assign('csID', $order->customer['csID']);
if(MODULE_PAYMENT_BANKTRANSFER_STATUS == 'True' and $order->info['payment_method'] == 'banktransfer'){
$smarty->assign('bank','1');
$smarty->assign('bank_owner',$banktransfer_owner);
$smarty->assign('bank_number',$banktransfer_number);
$smarty->assign('bank_bankname',$banktransfer_bankname);
$smarty->assign('bank_blz',$banktransfer_blz);
}
// get products data
$order_query = xtc_db_query("SELECT
products_id,
orders_products_id,
products_model,
products_name,
final_price,
products_quantity
FROM ".TABLE_ORDERS_PRODUCTS."
WHERE orders_id='".$insert_id."'");
$order_data = array ();
while ($order_data_values = xtc_db_fetch_array($order_query)) {
$attributes_query = xtc_db_query("SELECT
products_options,
products_options_values,
price_prefix,
options_values_price
FROM ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES."
WHERE orders_products_id='".$order_data_values['orders_products_id']."'");
$attributes_data = '';
$attributes_model = '';
while ($attributes_data_values = xtc_db_fetch_array($attributes_query)) {
$attributes_data .= $attributes_data_values['products_options'].':'.$attributes_data_values['products_options_values'].'
';
$attributes_model .= xtc_get_attributes_model($order_data_values['products_id'], $attributes_data_values['products_options_values']).'
';
}
$order_data[] = array ('PRODUCTS_MODEL' => $order_data_values['products_model'], 'PRODUCTS_NAME' => $order_data_values['products_name'], 'PRODUCTS_ATTRIBUTES' => $attributes_data, 'PRODUCTS_ATTRIBUTES_MODEL' => $attributes_model, 'PRODUCTS_PRICE' => $xtPrice->xtcFormat($order_data_values['final_price'], true),'PRODUCTS_SINGLE_PRICE' => $xtPrice->xtcFormat($order_data_values['final_price']/$order_data_values['products_quantity'], true), 'PRODUCTS_QTY' => $order_data_values['products_quantity']);
}
// get order_total data
$oder_total_query = xtc_db_query("SELECT
title,
text,
sort_order
FROM ".TABLE_ORDERS_TOTAL. Anwalt Hamm"
WHERE orders_id='".$insert_id."'
ORDER BY sort_order ASC");
$order_total = array ();
while ($oder_total_values = xtc_db_fetch_array($oder_total_query)) {
$order_total[] = array ('TITLE' => $oder_total_values['title'], 'TEXT' => $oder_total_values['text']);
}
// assign language to template for caching
$smarty->assign('language', $_SESSION['language']);
$smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
$smarty->assign('logo_path', HTTP_SERVER.DIR_WS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/img/');
$smarty->assign('oID', $insert_id);
if ($order->info['payment_method'] != '' && $order->info['payment_method'] != 'no_payment') {
include (DIR_WS_LANGUAGES.$_SESSION['language'].'/modules/payment/'.$order->info['payment_method'].'.php');
$payment_method = constant(strtoupper('MODULE_PAYMENT_'.$order->info['payment_method'].'_TEXT_TITLE'));
}
$smarty->assign('PAYMENT_METHOD', $payment_method);
$smarty->assign('DATE', xtc_date_long($order->info['date_purchased']));
$smarty->assign('order_data', $order_data);
$smarty->assign('order_total', $order_total);
$smarty->assign('NAME', $order->customer['name']);
$smarty->assign('COMMENTS', $order->info['comments']);
$smarty->assign('EMAIL', $order->customer['email_address']);
$smarty->assign('PHONE',$order->customer['telephone']);
// PAYMENT MODUL TEXTS
// EU Bank Transfer
if ($order->info['payment_method'] == 'eustandardtransfer') {
$smarty->assign('PAYMENT_INFO_HTML', MODULE_PAYMENT_EUTRANSFER_TEXT_DESCRIPTION);
$smarty->assign('PAYMENT_INFO_TXT', str_replace("
", "\n", MODULE_PAYMENT_EUTRANSFER_TEXT_DESCRIPTION));
}
// MONEYORDER
if ($order->info['payment_method'] == 'moneyorder') {
$smarty->assign('PAYMENT_INFO_HTML', MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION);
$smarty->assign('PAYMENT_INFO_TXT', str_replace("
", "\n", MODULE_PAYMENT_MONEYORDER_TEXT_DESCRIPTION));
}
// dont allow cache
$smarty->caching = false;
$html_mail = $smarty->fetch(CURRENT_TEMPLATE.'/mail/'.$_SESSION['language'].'/order_mail.html');
$txt_mail = $smarty->fetch(CURRENT_TEMPLATE.'/mail/'.$_SESSION['language'].'/order_mail.txt');
// create subject
$order_subject = str_replace('{$nr}', $insert_id, EMAIL_BILLING_SUBJECT_ORDER);
$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);
// send mail to admin
xtc_php_mail($order->customer['email_address'], $order->customer['firstname'], EMAIL_BILLING_ADDRESS, STORE_NAME, EMAIL_BILLING_FORWARDING_STRING, $order->customer['email_address'], $order->customer['firstname'], '', '', $order_subject, $html_mail, $txt_mail);
// send mail to customer
xtc_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $order->customer['email_address'], $order->customer['firstname'].' '.$order->customer['lastname'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', $order_subject, $html_mail, $txt_mail);
if (AFTERBUY_ACTIVATED == 'true') {
require_once (DIR_WS_CLASSES.'afterbuy.php');
$aBUY = new xtc_afterbuy_functions($insert_id);
if ($aBUY->order_send())
$aBUY->process_order();
}
} else {
$smarty->assign('ERROR', 'You are not allowed to view this order!');
$smarty->display(CURRENT_TEMPLATE.'/module/error_message.html');
}
?>[/b]
und hier die Order_mail.html
''>ZITAT</div>{config_load file="$language/lang_$language.conf" section="create_account"}
{php}echo nl2br(STORE_NAME_ADDRESS){/php}
{$address_label_customer}
{#text_tel#} {$PHONE} {if $customer_vat}
{#text_ustid#} {$customer_vat}{/if}
{if $PAYMENT_METHOD}Zahlungsmethode: {$PAYMENT_METHOD}
{/if} Bestellung Nr: {$oID}
Bestelldatum: {$DATE}
{if $csID}Kundennummer: {$csID}
{/if}
Lieferadresse
Rechnungsadresse
{$address_label_shipping}
{$address_label_payment}
Sehr geehrte® {$NAME},
Vielen Dank für Ihre Bestellung in unserem Online-Shop!
{if $PAYMENT_METHOD=='Vorkasse/Überweisung'} Bitte Überweisen Sie den Gesamtbetrag mit der Angabe Ihres Namens und Bestellnummer auf folgendes Konto:
{php} echo nl2br(MODULE_PAYMENT_MONEYORDER_PAYTO); {/php}
Umgehend nach Geldeingang, wird die Ware an die von Ihnen gewünschte Adresse versandt.{/if}
{if $COMMENTS}
Ihre Anmerkungen:
{$COMMENTS}
{/if}
{if $bank}
Bankverbindung
Kontoinhaber: {$bank_owner}
Kontonummer: {$bank_number}
Bank: {$bank_bankname}
BLZ: {$bank_blz}
{/if}
Ihre bestellten Produkte nochmals zur Kontrolle:
Stk.
Produkt
Artikel Nr.
Einzelpreis
Preis
{foreach name=aussen item=order_values from=$order_data}
{$order_values.PRODUCTS_QTY}
x
{$order_values.PRODUCTS_NAME}
{$order_values.PRODUCTS_ATTRIBUTES} {$order_values.NC_SLOGAN} {$order_values.NC_FONT} {$order_values.NC_COLOR} {$order_values.NC_INFO} {$order_values.NC_IMAGENAME} {$order_values.NC_IMAGETYPE} {$order_values.NC_IMAGEINFO}
{$order_values.PRODUCTS_MODEL}
{$order_values.PRODUCTS_ATTRIBUTES_MODEL}
{$order_values.PRODUCTS_SINGLE_PRICE}
{$order_values.PRODUCTS_PRICE}
{/foreach}
{foreach name=aussen item=order_total_values from=$order_total}
{$order_total_values.TITLE}{$order_total_values.TE XT}
{/foreach}
[/b]
Hi,
und im Adminmodus/Bestellungen wird mir die Bankverbindung auch rnichtig angezeigt.
Gruß