}
$messageStack->add_session(SUCCESS_BILLING, 'success');
olc_redirect(olc_href_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('action')) . 'action=edit'));
break;
case 'update_payment':
$pID = olc_db_prepare_input($_GET['pID']);
$status = olc_db_prepare_input($_POST['status']);
$payment_updated = false;
$check_status_query = olc_db_query("select af.affiliate_email_address, ap.affiliate_lastname, ap.affiliate_firstname, ap.affiliate_payment_status, ap.affiliate_payment_date, ap.affiliate_payment_date from " . TABLE_AFFILIATE_PAYMENT . " ap, " . TABLE_AFFILIATE . " af where affiliate_payment_id = '" . olc_db_input($pID) . "' and af.affiliate_id = ap.affiliate_id ");
$check_status = olc_db_fetch_array($check_status_query);
if ($check_status['affiliate_payment_status'] != $status) {
olc_db_query(SQL_UPDATE . TABLE_AFFILIATE_PAYMENT . " set affiliate_payment_status = '" . olc_db_input($status) . "', affiliate_last_modified = now() where affiliate_payment_id = '" . olc_db_input($pID) . APOS);
$affiliate_notified = '0';
// Notify Affiliate
if ($_POST['notify'] == 'on') {
$email = STORE_NAME . NEW_LINE . EMAIL_SEPARATOR . NEW_LINE . EMAIL_TEXT_AFFILIATE_PAYMENT_NUMBER . BLANK . $pID . NEW_LINE . EMAIL_TEXT_INVOICE_URL . BLANK . olc_catalog_href_link(FILENAME_CATALOG_AFFILIATE_PAYMENT_INFO, 'payment_id=' . $pID, SSL) . NEW_LINE . EMAIL_TEXT_PAYMENT_BILLED . BLANK . olc_date_long($check_status['affiliate_payment_date']) . "\n\n" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $payments_status_array[$status]);
olc_mail($check_status['affiliate_firstname'] . BLANK . $check_status['affiliate_lastname'], $check_status['affiliate_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, AFFILIATE_EMAIL_ADDRESS);
$affiliate_notified = '1';
}
olc_db_query(INSERT_INTO . TABLE_AFFILIATE_PAYMENT_STATUS_HISTORY . " (affiliate_payment_id, affiliate_new_value, affiliate_old_value, affiliate_date_added, affiliate_notified) values ('" . olc_db_input($pID) . "', '" . olc_db_input($status) . "', '" . $check_status['affiliate_payment_status'] . "', now(), '" . $affiliate_notified . "')");
$order_updated = true;
}
if ($order_updated) {
$messageStack->add_session(SUCCESS_PAYMENT_UPDATED, 'success');
}
olc_redirect(olc_href_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('action')) . 'action=edit'));
break;
case 'deleteconfirm':
$pID = olc_db_prepare_input($_GET['pID']);
olc_db_query(DELETE_FROM . TABLE_AFFILIATE_PAYMENT . " where affiliate_payment_id = '" . olc_db_input($pID) . APOS);
olc_db_query(DELETE_FROM . TABLE_AFFILIATE_PAYMENT_STATUS_HISTORY . " where affiliate_payment_id = '" . olc_db_input($pID) . APOS);
*/
include DIR_WS_CLASSES . 'order.php';
$order = new order($HTTP_GET_VARS['oID']);
require_once PAYPAL_IPN_DIR . 'Admin/languages/' . $language . '/paypal.lng.php';
require_once PAYPAL_IPN_DIR . 'Classes/TransactionDetails/TransactionDetails.class.php';
$paypal = new PayPal_TransactionDetails(TABLE_PAYPAL, $order->info['payment_id']);
if ($HTTP_GET_VARS['digest'] != $paypal->digest()) {
$messageStack->add_session(ERROR_UNAUTHORIZED_REQUEST);
} elseif ($paypal->info['payment_status'] === 'Completed' && $order->info['orders_status'] === MODULE_PAYMENT_PAYPAL_ORDER_ONHOLD_STATUS_ID) {
include PAYPAL_IPN_DIR . 'Functions/addressbook.func.php';
include PAYPAL_IPN_DIR . 'Classes/osC/Order.class.php';
$PayPal_osC_Order = new PayPal_osC_Order();
$PayPal_osC_Order->setOrderID($HTTP_GET_VARS['oID']);
$PayPal_osC_Order->loadOrdersSessionInfo();
//$currency = $PayPal_osC_Order->currency;
$PayPal_osC_Order->setAccountHistoryInfoURL(olc_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $PayPal_osC_Order->orderID, 'SSL', false));
$PayPal_osC_Order->setCheckoutProcessLanguageFile(DIR_FS_CATALOG_LANGUAGES . $PayPal_osC_Order->language . '/' . 'checkout_process.php');
$PayPal_osC_Order->updateProducts($order, $currencies);
$PayPal_osC_Order->notifyCustomer($order);
$affiliate_ref = $PayPal_osC_Order->affiliate_id;
$affiliate_clickthroughs_id = $PayPal_osC_Order->affiliate_clickthroughs_id;
$affiliate_clientdate = $PayPal_osC_Order->affiliate_date;
$affiliate_clientbrowser = $PayPal_osC_Order->affiliate_browser;
$affiliate_clientip = $PayPal_osC_Order->affiliate_ipaddress;
if (olc_not_null($affiliate_ref) && $affiliate_ref != '0') {
define('MODULE_PAYMENT_PAYPAL_SHOPPING_IPN_AFFILIATE', TRUE_STRING_S);
$insert_id = $PayPal_osC_Order->orderID;
include DIR_FS_CATALOG_MODULES . '../affiliate_checkout_process.php';
}
$PayPal_osC_Order->updateOrderStatus(MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID);
$PayPal_osC_Order->removeOrdersSession();
echo ' <tr class="productListing-even">';
} else {
echo ' <tr class="productListing-odd">';
}
?>
<td class="dataTableContent"><?php
echo $affiliate_clickthroughs['affiliate_firstname'] . BLANK . $affiliate_clickthroughs['affiliate_lastname'];
?>
</td>
<td class="dataTableContent" align="center"><?php
echo olc_date_short($affiliate_clickthroughs['affiliate_clientdate']);
?>
</td>
<?php
if ($affiliate_clickthroughs['affiliate_products_id'] > 0) {
$link_to = HTML_A_START . olc_catalog_href_link(FILENAME_CATALOG_PRODUCT_INFO, 'products_id=' . $affiliate_clickthroughs['affiliate_products_id']) . '" target="_blank">' . $affiliate_clickthroughs['products_name'] . HTML_A_END;
} else {
$link_to = "Startpage";
}
?>
<td class="dataTableContent"><?php
echo $link_to;
?>
</td>
<td class="dataTableContent" align="center"><?php
echo $affiliate_clickthroughs['affiliate_clientbrowser'];
?>
</td>
</tr>
<tr>
<td class="dataTableContent"><?php
}
}
if ($update) {
olc_db_query("\n\t\t\tupdate " . TABLE_ORDERS . "\n\t\t\tset\n\t\t\torders_status = '" . olc_db_input($status) . "',\n\t\t\torders_trackcode = '" . $track_code . "',\n\t\t\tlast_modified = now()\n\t\t\twhere orders_id = '" . $oID . APOS);
$customer_notified = 0;
if ($_POST['notify'] == 'on') {
$notify_comments = EMPTY_STRING;
if ($_POST['notify_comments'] == 'on') {
if ($comment) {
$notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";
}
}
$customers_name = $order->customer['name'];
$smarty->assign('NAME', $customers_name);
$smarty->assign('ORDER_NR', $oID);
$smarty->assign('ORDER_LINK', olc_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, SSL));
$smarty->assign('ORDER_DATE', olc_date_long($order->info['date_purchased']));
$smarty->assign('NOTIFY_COMMENTS', $notify_comments);
$smarty->assign('ORDER_STATUS', $orders_status_array[$status]);
// W. Kaiser - Erlaube Sendungstracking
$smarty->assign('SHIP_DATE', date('l, j F Y H:i'));
$txt_mail = str_replace('admin/', EMPTY_STRING, olc_href_link(FILENAME_CUSTOMER_DEFAULT, EMPTY_STRING, NONSSL, false));
$smarty->assign('HOME_LINK', $txt_mail);
if ($status == 3) {
//Status "Versendet"
if ($track_code) {
//Assign smarty Variable for tracking URL
require_once DIR_FS_INC . 'olc_get_track_code.inc.php';
$TrackURL = olc_get_track_code($order, $track_code);
$smarty->assign('TRACK_URL', $TrackURL);
}
// csv export
echo date(DATE_FORMAT, $sr->showDate) . SR_SEPARATOR1 . date(DATE_FORMAT, $sr->showDateEnd) . SR_SEPARATOR1;
echo $info[0]['order'] . SR_SEPARATOR1;
echo $info[$last - 1]['totitem'] . SR_SEPARATOR1;
echo $currencies->format($info[$last - 1]['totsum']) . SR_SEPARATOR1;
echo $currencies->format($info[0]['shipping']) . SR_NEWLINE;
}
if ($srDetail) {
for ($i = 0; $i < $last; $i++) {
if ($srMax == 0 or $i < $srMax) {
if ($srExp < 2) {
?>
<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'">
<td class="dataTableContent"> </td>
<td class="dataTableContent" align="left"><?php
echo HTML_A_START . olc_catalog_href_link("product_info.php?products_id=" . $info[$i]['pid']);
?>
" target="_blank"><?php
echo $info[$i]['pname'];
?>
</a>
<?php
if (is_array($info[$i]['attr'])) {
$attr_info = $info[$i]['attr'];
foreach ($attr_info as $attr) {
echo '<div style="font-style:italic;"> ' . $attr['quant'] . 'x ';
// $attr['options'] . ': '
$flag = 0;
foreach ($attr['options_values'] as $value) {
if ($flag > 0) {
echo "," . $value;
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
DevosC, Developing open source Code
http://www.devosc.com
Copyright (c) 2003 osCommerce
Copyright (c) 2004 DevosC.com
Copyright (c) 2006 Dipl.-Ing.(TH) Winfried Kaiser (w.kaiser@fortune.de) -- Port to OL-Commerce
Released under the GNU General Public License
*/
require_once DIR_FS_INC . 'olc_draw_form.inc.php';
require_once DIR_FS_INC . 'olc_draw_hidden_field.inc.php';
olc_draw_form('ipn', olc_catalog_href_link(FILENAME_IPN), 'POST');
olc_draw_hidden_field('business', MODULE_PAYMENT_PAYPAL_BUSINESS_ID);
olc_draw_hidden_field('receiver_email', MODULE_PAYMENT_PAYPAL_ID);
olc_draw_hidden_field('verify_sign', 'PAYPAL_SHOPPING_CART_IPN-TEST_TRANSACTION-00000000000000');
olc_draw_hidden_field('payment_date', ate("H:i:s M d, Y T"));
olc_draw_hidden_field('digestKey', PayPal_IPN::digestKey());
?>
<table border="0" cellspacing="0" cellpadding="2" class="main">
<?php
if (MODULE_PAYMENT_PAYPAL_IPN_TEST_MODE == 'Off') {
?>
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" style="padding: 4px; border:1px solid #aaaaaa; background: #ffffcc;">
<tr>
<td><?php
