[[Shop mit PayPal-Anbindung (alte Release)]]
You are here: Willkommen im phpwcms-HowTo:wiki » Benutzerhandbuch (DE) » Module » Shop » Shop mit PayPal-Anbindung (alte Release)
Show pageOld revisions
Recent changesIndex

NAVIGATION

Imprint / Impressum

Please Donate!

With your donation you accelerate more enhancements of the wiki.

Differences

This shows you the differences between two versions of the page.

deutsch:module:shop:paypal [2011/10/15 20:51]
Robert created 		deutsch:module:shop:paypal [2018/06/03 18:09] (current)
Line 1: Line 1:
-Kurze Auflistung der Schritte die nötig sind um einen aktuellen Shop Paypal fähig zu machen.+====== Shop mit PayPal-Anbindung (alte Release) ======
-Es gibt dafür zwar eine alte Shopversion von nebenaube (http://forum.phpwcms.org/viewtopic.php?f=8&t=18505&start=15), möchte man allerdings eine modifizierte oder neuere Shopversion des phpwcms nutzen bringt dies nicht viel.+FIXME translate
-Vorgehensweise+Der phpwcms Shop ist rudimentär, reicht aber für kleine Projekte vollkommend aus. Ärgerlich ist lediglich die beschränkte Zahlungsmöglichkeiten. PayPal wurde zwar im Backend (und teilweise im Code) vorgesehen, funktioniert jedoch bislang nicht. Mittels den folgenden Schritten gelingt es dem Shop Paypal-fähig zu machen.
-#1: DB-Update+Anmerkrung: 
 +Es gibt dafür zwar eine alte Shopversion von nebenaube, möchte man allerdings eine modifizierte oder neuere Shopversion des phpwcms nutzen bringt dies nicht viel. 
 + 
 +---- 
 +Forum:         [[http://forum.phpwcms.org/viewtopic.php?f=8&t=18505&start=15]] \\ 
 +Spezifikation: [[https://www.paypalobjects.com/de_DE/html/IntegrationCenter/ic_home.html]] \\ 
 +Danke an:      nebenaube für PayPal Vorarbeit & OG für den Shop\\ 
 + \\ 
 +**Autor:**  Robert/ q23.media \\ 
 +**CMS version:** = < r421 \\  
 + 
 +Verzeichnis: /include/inc_module/mod_shop_paypal/\\ 
 + 
 + 
 +===== Beschreibung ===== 
 + 
 +==== #1: DB-Update ====
Es muß eine neuen Zwischenspeicher-Tabelle angelegt werden. Es muß eine neuen Zwischenspeicher-Tabelle angelegt werden.
 +
 +<code php|h SQL-Anweisung in phpmyadmin ausführen:|h>
CREATE TABLE  IF NOT EXISTS  `phpwcms_shop_transactions` ( CREATE TABLE  IF NOT EXISTS  `phpwcms_shop_transactions` (
  `transaction_id` int(10) unsigned NOT NULL auto_increment,   `transaction_id` int(10) unsigned NOT NULL auto_increment,
Line 37: Line 55:
  PRIMARY KEY  (`transaction_id`)   PRIMARY KEY  (`transaction_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 ; ) ENGINE=MyISAM AUTO_INCREMENT=14 ;
 +</code>
 +
 +==== #2: Einspielen der notwendige Dateien ====
 +- front_order_process.inc.php \\
 +- paypal.class.php \\
 +hier herunterladen
 +{{:deutsch:module:shop:phpwcms_paypal.zip|}}
 +und auf den Server/ in include/inc_module/mod_shop_paypal/inc kopieren.
 + \\
 +==== #3: Modifizieren des bestehenden Orderprocess ====
 +Wenn im nachfolgenden des öftern von ggf. geredet wird bedeutet das, dass die Änderung nur vorzunehmen ist sollte die Funktion/ Abfrage/ Zeile noch nicht existieren. Es wurde seitens des Autors darauf verzichtet zu prüfen ob und ab wann die (teilweise) Paypal-Integrierung bereits von OG ins System implementiert wurde. \\
 + \\
 +=== 1. Template File ===
 +Falls nicht bereits vorhanden in der default.html (bzw. diejenige Templatedatei die verwendet wird) folgende Einstellungen \\
 + \\
 +Den Abschnitt:
 +<code>
 + <--- Config_Start --->
 +label_payby_prepay = "Cash with order"
 +label_payby_pod = "Cash on delivery"
 +label_payby_onbill = "On account"
 +</code>
 +mit folgendem erweitern:
 +<code>
 +label_payby_paypal = "PayPal"
 +</code>
 + \\
 +Im Abschnitt:
 +<code>
 +<!--MAIL_CUSTOMER_START//-->
 +</code>
 + \\
 +Ausgabe der Zahlart in der eMail mit
 +<code>
 +[PAYBY_PAYPAL]You have paid via Paypal.[/PAYBY_PAYPAL]
 +</code>
 +erreichen.
 + \\
 +Nach
 +<code>
 +<!--MAIL_NEWORDER_END//-->
 +</code>
 +<code php|h und vor Order_Done_Start:|h>
 +<!--PAYPAL_ORDER_DONE_START//-->
 + <h2>Order {ORDER} successfully sent</h2>
 + <p>Hello <strong>{INV_FIRSTNAME} {INV_NAME}</strong>,<br />
 + Thanks for your order. You will receive a notification of your oder status at <strong>{EMAIL}</strong> once confirmation of your payment has been received...</p>
 + <p>Your order number is: <strong>{ORDER}</strong>. Please use this number in case you need to contact us by email.</p>
 +<!--PAYPAL_ORDER_DONE_END//-->
 +
 +<!--PAYPAL_ORDER_DEBUG_START//-->
 + <h2>Paypal class error message</h2>
 + <p><strong>{DEBUG_MSG1} </strong></p>
 + <p><strong>{DEBUG_MSG2} </strong></p>
 +<!--PAYPAL_ORDER_DEBUG_END//-->
 +
 +<!--PAYPAL_ORDER_CANCELED_START//-->
 +    <h3>{MESSAGE}</h3>
 +<!--PAYPAL_ORDER_CANCELED_END//-->
 +</code>
 +
 +=== 2: edit.preferences.inc ===
 +<code>
 +<?php echo $BLM['shopprod_payment_method'] ?>
 +</code>
 +suchen und ggf. danach (also wenn die neue tabelle aufgeht)
 +<code php|h das einfügen:|h>
 + <tr>
 + <td><input type="checkbox" name="pref_payment_paypal" id="pref_payment_paypal" value="1"<?php is_checked(1, $plugin['data']['shop_pref_payment']['paypal']) ?> onchange="enableSubmit();" /></td>
 + <td><label for="pref_payment_paypal">&nbsp;<?php echo $BLM['shopprod_payby_paypal'] ?>&nbsp;&nbsp;&nbsp;</label></td>
 + <td align="right" class="chatlist"><?php echo $BLM['shopprod_email_paypal'] ?>:&nbsp;</td>
 + <td><input name="pref_email_paypal" type="text" id="pref_email_paypal" class="v12 width175" value="<?php echo html_specialchars($plugin['data']['shop_pref_email_paypal']) ?>" size="30" maxlength="200" onchange="enableSubmit();" /></td>
 + </tr>
 +</code>
 +
 +=== 3.1: frontend.render.php ===
 +
 +<code php|h im Abschnitt 'if($_shop_load_order) {' hinter $_tmpl['mail_neworder'] das hinzufügen:|h>
 + $_tmpl['paypal_order_success'] = get_tmpl_section('PAYPAL_ORDER_DONE', $_tmpl['source']);
 + $_tmpl['paypal_order_debug'] = get_tmpl_section('PAYPAL_ORDER_DEBUG', $_tmpl['source']);
 + $_tmpl['paypal_order_canceled'] = get_tmpl_section('PAYPAL_ORDER_CANCELED', $_tmpl['source']);
 +</code>
 +
 +und im Abschnitt
 +<code>
 +// merge config settings like translations and so on
 + $_tmpl['config'] = array_merge( array(
 +</code>
 +<code php|h unter mail_neworder_subject das hinzufügen:|h>
 + 'label_payby_paypal' => "Paypal",
 +</code>
 +
 +Direkt darunter unter
 +<code>
 + // get preferences
 + $_shopPref = array();
 +</code>
 +<code php|h ggf. das dem foreach hinzufügen:|h>
 +'shop_pref_email_paypal',
 +</code>
 +
 +=== 3.2: frontend.render.php ===
 +Suche bei
 +<code>
 +elseif( isset($_POST['shop_order_submit']) && !isset($_SESSION['shopping_cart']['error']['step2']) )
 +</code>
 +<code php|h zusätzliche elseif abfrage danach, vor else:|h>
 +} elseif( isset($_GET['shop_order_process'])  ) {
 + //process order via paypal ipn
 + include($phpwcms['modules']['shop']['path'].'inc/front.order_process.inc.php');
 +</code>
 +
 +=== 5. in front.order_submit.inc.php ===
 +Unter der stelle
 +<code>
 + // receive order db ID
 + $order_data = _dbInsert('phpwcms_shop_orders', $order_data);
 +</code>
 +<code php|h ein switch einfügen:|h>
 + // success inserting db record of order
 + $_SESSION['shopping_cart']['order_number'] = $order_num;
 +
 + switch( $_SESSION['shopping_cart']['payby'] ){
 +
 + case 'paypal':
 + headerRedirect(PHPWCMS_URL.$_tmpl['config']['cart_url']."&shop_order_process");
 + break;
 +
 + default:
 +</code>
 +wobei sich ans default die
 +<code>
 +//send mail to customer anschließt.
 +</code>
 +
 +ACHTUNG: switch nach der
 +<code>
 +// NO success routine mit
 +</code>
 +mit
 +<code>
 +} //endswitch
 +</code>
 +wieder schließen. \\
 + \\
 +=== 6. shop.func.php ===
 +Suche die Funktion
 +<code>
 +get_payment_options()
 +</code>
 +suchen und
 +<code php|h $supported mit:|h>
 + $supported = array('paypal' => 0, 'prepay' => 0, 'pod' => 0, 'onbill' => 0);
 +</code>
 +überschreiben. \\
 +\\
 +Anschließend
 +<code php|h das ans ende vor dem schließenden PHP-Tag kopieren.:|h>
 +function validateReferrer(  $yoursite, //Your site url without 'http://' or subdomain
 + $domain_name //Type your domain with www. this time
 + )
 +{
 +
 + $referer = $_SERVER['HTTP_REFERER'];
 + //Check if browser sends referrer url or not
 + if ($referer == "") { //If not, set referrer as your domain
 + $domain = $yoursite;
 + } else {
 + $domain = parse_url($referer); //If yes, parse referrer
 + }
 +
 + if($domain['host'] == $yoursite || $domain['host'] == $domain_name) {
 +
 + //Run your dowloading code here normally
 +
 + } else {
 +
 + //The referrer is not your site, we bail and redirect to  home page
 + header("Location: http://".$domain_name."/index.php");
 +
 + exit(); //Stop running the script
 +
 + }
 +}
 +
 +
 +
 +function reinitialize_session(&$_tmpl){
 +
 + $_SESSION['shopping_cart']['order_number'] = ( isset($_POST['invoice']) ? clean_slweg($_POST['invoice']) : '' );
 + $_SESSION['shopping_cart']['step1'] = array(
 +
 + 'INV_FIRSTNAME' => isset($_POST['first_name']) ? clean_slweg($_POST['first_name']) : '',
 + 'INV_NAME' => isset($_POST['last_name']) ? clean_slweg($_POST['last_name']) : '',
 + 'INV_ADDRESS' => isset($_POST['address_street']) ? clean_slweg($_POST['address_street']) : '',
 + 'INV_ZIP' => isset($_POST['address_zip']) ? clean_slweg($_POST['address_zip']) : '',
 + 'INV_CITY' => isset($_POST['address_city']) ? clean_slweg($_POST['address_city']) : '',
 + 'INV_REGION' => isset($_POST['address_state']) ? clean_slweg($_POST['address_state']) : '',
 + 'INV_COUNTRY' => isset($_POST['address_country']) ? clean_slweg($_POST['address_country']) : '',
 + 'EMAIL' => isset($_POST['payer_email']) ? clean_slweg($_POST['payer_email']) : '',
 + 'PHONE' => isset($_POST['contact_phone']) ? clean_slweg($_POST['contact_phone']) : ''
 +
 + );
 +
 +
 +}
 +
 +function reinitialize_cart_products( $order_num ){
 +
 + $cart_data = Array();
 + $cart_data[0] = "uninitialized";
 +
 +
 + $q_result = _dbQuery("SELECT * FROM ".DB_PREPEND."phpwcms_shop_orders WHERE order_number=".$order_num." LIMIT 1");
 +
 + if(isset($q_result[0])){
 +
 + $cart_data  = unserialize($q_result[0]['order_data']);
 +
 + }
 +
 + return $cart_data;
 +
 +}
 +
 +function update_transactions_table(&$cart_data, &$P){
 + $temp = Array(  
 + "txn_id",
 + "reason_code",
 + "receiver_email",
 + "mc_gross",
 + "protection_eligibility",
 + "address_status",
 + "payer_id",
 + "tax",
 + "address_street",
 + "payment_date",
 + "payment_status",
 + "charset",
 + "address_zip",
 + "mc_shipping",
 + "mc_handling",
 + "first_name",
 + "mc_fee",
 + "address_country_code",
 + "address_name",
 + "notify_version",
 + "custom",
 + "invoice",
 + "num_cart_items",
 + "payer_status",
 + "business",
 + "address_country",
 + "address_city",
 + "payer_email",
 + "contact_phone",
 + "verify_sign",
 + "payment_type",
 + "last_name",
 + "address_state",
 + "payment_fee",
 + "pending_reason",
 + "receiver_id",
 + "txn_type",
 + "mc_currency",
 + "residence_country",
 + "receipt_id",
 + "test_ipn",
 + "transaction_subject",
 + "payment_gross",
 + "merchant_return_link",
 + "form_charset"
 + );
 +
 +
 + $trans = Array();
 + 
 + foreach( $temp  as $key ){
 +
 + $trans[$key] = ( isset( $_POST[$key]) ? clean_slweg($_POST[$key]) : '');
 +
 + }
 +
 + for( $i=0; $i < $trans['num_cart_items']; $i++ ){
 +
 +
 + $trans['item_number'.($i+1)] = ( isset( $_POST['item_number' . ($i+1)]) ? clean_slweg($_POST['item_number'. ($i+1)]) : '');
 + $trans['mc_gross_'.($i+1)] = ( isset( $_POST['mc_gross_'   . ($i+1)]) ? clean_slweg($_POST['mc_gross_'  . ($i+1)]) : '');
 + $trans['quantity'.($i+1)] = ( isset( $_POST['quantity'    . ($i+1)]) ? clean_slweg($_POST['quantity'   . ($i+1)]) : '');
 +
 +
 + }
 +
 + $validTransaction = true;
 +
 + // test the txn_id; if txn_id is used and it's not a chargeback then it's invalid
 + $txn_id_is_used = _dbCount("Select * from".DB_PREPEND."phpwcms_shop_transactions where txn_id=".$trans['txn_id']);
 +
 + if(  $txn_id_is_used && !isset($trans['reason_code']) && !( empty($trans['txn_type']) && ($trans['reason_code'] === "chargeback")) ){
 + $validTransaction = false;
 + $lastError  .= "Failed Anti-fraud test 1: txn_id is used: ".$txn_id_is_used."   txn_type: ".$trans['txn_type']."  trans_reason_code: ".$trans['reason_code']."\n";
 + }
 +
 + // test receiver_email
 + if( $validTransaction && !( $trans['receiver_email'] === _getConfig( 'shop_pref_email_paypal', '_shopPref' ) ) ){
 + $validTransaction = false;
 + $lastError  .= "Failed Anti-fraud test 2: unmatched email addresses for receiver_email: ".$trans['receiver_email']." vs "._getConfig( 'shop_pref_email_paypal', '_shopPref' )."\n";
 + }
 +
 + // validate number of items
 + if( $validTransaction && ( count($cart_data['cart']) != $trans['num_cart_items'])){
 + $validTransaction = false;
 + $lastError .= "Failed Anti-fraud test 3: number of items mismatch: items in cart: ".count($cart_data['cart'])." vs items in post: ".$trans['num_cart_items']."\n";
 + }
 +
 + // test to see that cart items match
 + if( $validTransaction ){
 +
 + for( $i=0; $i < $trans['num_cart_items']; $i++ ){
 +
 +
 + if( $cart_data['cart'][$i]['shopprod_id']       != $trans['item_number'.($i+1)] ||
 + $cart_data['cart'][$i]['shopprod_price']    != $trans['mc_gross_'.($i+1)] ||
 +    $cart_data['cart'][$i]['shopprod_quantity'] != $trans['quantity'.($i+1)] ){
 +
 + $validTransaction = false;
 +
 + $lastError  .= "\n\nFailed Anti-fraud test 3: product mismatch: \n";
 + $lastError  .= $cart_data['cart'][$i]['shopprod_id']." != ".$trans['item_number'.($i+1)].",\n";
 + $lastError  .= $cart_data['cart'][$i]['shopprod_price']." != ".$trans['mc_gross_'.($i+1)].",\n";
 + $lastError  .= $cart_data['cart'][$i]['shopprod_quantity']." != ".$trans['quantity'.($i+1)]."\n\n";
 +
 + }
 +
 + }
 +
 +
 + }
-#2: Einspielen der notwendige Dateien+  
 + if( $validTransaction ){  // No fraud detected 
 + $data = Array( 
 + 'receiver_email' => $trans['receiver_email'], 
 + 'order_number' => $trans['invoice'], 
 + 'payment_status' => $trans['payment_status'], 
 + 'pending_reason' => $trans['pending_reason'], 
 + 'payment_date' => $trans['payment_date'], 
 + 'mc_gross' => $trans['mc_gross'], 
 + 'mc_fee' => $trans['mc_fee'], 
 + 'tax' => $trans['tax'], 
 + 'mc_currency' => $trans['mc_currency'], 
 + 'txn_id' => $trans['txn_id'], 
 + 'txn_type' => $trans['txn_type'], 
 + 'first_name' => $trans['first_name'], 
 + 'last_name' => $trans['last_name'], 
 + 'address_street' => $trans['address_street'], 
 + 'address_city' => $trans['address_city'], 
 + 'address_state' => $trans['address_state'], 
 + 'address_zip' => $trans['address_zip'], 
 + 'address_country'   => $trans['address_country'], 
 + 'address_status'   => $trans['address_status'], 
 + 'payer_email'     => $trans['payer_email'], 
 + 'contact_phone'     => $trans['contact_phone'], 
 + 'payer_status'     => $trans['payer_status'], 
 + 'payment_type'     => $trans['payment_type'], 
 + 'notify_version'   => $trans['notify_version'], 
 + 'verify_sign'       => $trans['verify_sign'], 
 + 'referrer_id'     => $trans['referrer_id'] 
 + );  
 +  
 +  
 +  
 + _dbInsertOrUpdate( DB_PREPEND."phpwcms_shop_transactions", $data, "where `txn_id` = '".$trans['txn_id']."'", ''); 
 +  
 +  
 + }else{ 
 +  
 + $P->log_error($lastError ); 
 + }
-#3: Modifizieren des bestehenden Orderprocess+ return $validTransaction; 
 +  
 +}  
 +</code> 
 +  
 +=== 7. processing.preferences.inc.php === 
 +Ersetzungen wie folgt. Nach 
 +<code> 
 + $plugin['data']['shop_pref_email_from'] = clean_slweg($_POST['pref_email_from']); 
 +</code> 
 +ggf. das einfügen 
 +<code> 
 + $plugin['data']['shop_pref_email_paypal'] = clean_slweg($_POST['pref_email_paypal']); 
 +</code> 
 + \\ 
 +nach 
 +<code> 
 + if(! is_valid_email($plugin['data']['shop_pref_email_from']) ) $plugin['data']['shop_pref_email_from'] = ''; 
 +</code> 
 +ggf. das einfügen: 
 +<code> 
 + if(! is_valid_email($plugin['data']['shop_pref_email_paypal']) ) $plugin['data']['shop_pref_email_paypal'] = ''; 
 +</code> 
 + \\ 
 +vor 
 +<code> 
 + 'prepay' => empty($_POST['pref_payment_prepay']) ? 0 : 1, 
 +</code> 
 +ggf. das einfügen 
 +<code> 
 + 'paypal' => empty($_POST['pref_payment_paypal']) ? 0 : 1, 
 +</code> 
 + \\  
 +nach 
 +<code> 
 + _setConfig('shop_pref_email_from', $plugin['data']['shop_pref_email_from'], 'module_shop'); 
 +</code> 
 +ggf. das einfügen 
 +<code> 
 + _setConfig('shop_pref_email_paypal', $plugin['data']['shop_pref_email_paypal'], 'module_shop'); 
 +</code> 
 + \\ 
 +nach 
 +<code> 
 + 'shop_pref_email_from' => '', 
 +</code> 
 +ggf. das einfügen 
 +<code> 
 + 'shop_pref_email_paypal' => '', 
 +</code> 
 + \\ 
 +nach 
 +<code> 
 + 'prepay'=> 1,  
 +</code> 
 +ggf. das einfügen 
 +<code> 
 + 'paypal' => 1, 
 +</code> 
 + \\ 
 + \\  
 +=== 8. Language-Files === 
 +Ggf. die language files unter /include/inc_module/mod_shop/lang mit paypal anreichern. \\ 
 +Das sollte eigentlich bei phpwcms > 2007 bereits vorhanden sein. 
 + \\ 
 +Bspw. für deutsch nach 
 +<code> 
 +$BLM['shopprod_payment_method'] = 'Zahlungsmethoden'; 
 +</code> 
 +das einfügen 
 +<code> 
 +$BLM['shopprod_payby_paypal'] = 'PayPal'; 
 +$BLM['shopprod_email_paypal'] = 'PayPal E-Mail'; 
 +</code> 
 + \\ 
 + \\ 
 + \\ 
 +==== #4: Zusammenfassung ==== 
 +Jetzt müßte \\ 
 +  a. die Zahlart PayPal Auswahl im Shop verfügbar sein 
 +  b. eine Weiterleitung zu PayPal geschehen (derzeit ist noch die Sandbox Testumgebung aktiv) 
 +  c. der Shop innerhalb seiner normalen Parameter funktionieren. 
 + \\ 
 +Sollte eine der oben aufgeführten Punkte nicht zutreffen gibt es ein Problem. Kontrollier bitte noch einmal ganz genau die Punkt eins bis drei. Andernfalls: Happy PayPal'ing!!! 
 + \\ 
 + \\
-#4: Beheben des Steuerbug 
deutsch/module/shop/paypal.1318704671.txt.gz · Last modified: 2018/06/03 18:07 (external edit)
Show pageOld revisions
Back to top
www.planmatrix.de www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0