public static function ordersPage()
{
if ($_SERVER['REQUEST_METHOD'] == 'GET' && Cart66Common::getVal('task') == 'view') {
$order = new Cart66Order($_GET['id']);
$view = Cart66Common::getView('admin/order-view.php', array('order' => $order));
} elseif ($_SERVER['REQUEST_METHOD'] == 'POST' && Cart66Common::postVal('task') == 'resend email receipt') {
if (CART66_PRO && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
$notify = new Cart66AdvancedNotifications($_POST['order_id']);
$notify->sendAdvancedEmailReceipts(false);
} else {
$notify = new Cart66Notifications($_POST['order_id']);
$notify->sendEmailReceipts();
}
$order = new Cart66Order($_POST['order_id']);
$view = Cart66Common::getView('admin/order-view.php', array('order' => $order, 'resend' => true));
} elseif ($_SERVER['REQUEST_METHOD'] == 'POST' && Cart66Common::postVal('task') == 'reset download amount') {
$product = new Cart66Product();
$product->resetDownloadsForDuid($_POST['duid'], $_POST['order_item_id']);
$order = new Cart66Order($_POST['order_id']);
$view = Cart66Common::getView('admin/order-view.php', array('order' => $order));
} elseif ($_SERVER['REQUEST_METHOD'] == 'GET' && Cart66Common::getVal('task') == 'delete') {
$order = new Cart66Order($_GET['id']);
$order->deleteMe();
$view = Cart66Common::getView('admin/orders.php');
} elseif ($_SERVER['REQUEST_METHOD'] == 'POST' && Cart66Common::postVal('remove') && Cart66Common::postVal('remove') != 'all') {
$order = new Cart66Order($_GET['id']);
Cart66AdvancedNotifications::removeTrackingNumber($order);
$order = new Cart66Order($_GET['id']);
$view = Cart66Common::getView('admin/order-view.php', array('order' => $order));
} elseif ($_SERVER['REQUEST_METHOD'] == 'POST' && Cart66Common::postVal('remove') == 'all') {
$order = new Cart66Order($_GET['id']);
$order->updateTracking(null);
$order = new Cart66Order($_GET['id']);
$view = Cart66Common::getView('admin/order-view.php', array('order' => $order));
} elseif ($_SERVER['REQUEST_METHOD'] == 'POST' && Cart66Common::postVal('task') == 'update order status') {
$order = new Cart66Order($_POST['order_id']);
//$order->updateStatus(Cart66Common::postVal('status'));
//$order->updateNotes($_POST['notes']);
$data = array('status' => Cart66Common::postVal('status'), 'notes' => Cart66Common::postVal('notes'));
$order->setData($data);
$order->save();
if (Cart66Common::postVal('send_email_status_update') && CART66_PRO) {
Cart66AdvancedNotifications::addTrackingNumbers($order);
$status = Cart66Common::postVal('status');
if (Cart66Setting::getValue('status_options') != null) {
$notify = new Cart66AdvancedNotifications($_POST['order_id']);
$notify->sendStatusUpdateEmail($status);
}
} elseif (CART66_PRO) {
Cart66AdvancedNotifications::addTrackingNumbers($order);
}
$view = Cart66Common::getView('admin/orders.php');
//$order = new Cart66Order($_POST['order_id']);
//$view = Cart66Common::getView('admin/order-view.php', array('order'=>$order));
} else {
$view = Cart66Common::getView('admin/orders.php');
}
echo $view;
}
public function checkFulfillmentSettings($orderId)
{
$order = new Cart66Order($orderId);
$data = array();
foreach ($order->getItems() as $item) {
$data[] = $item->product_id;
}
$orderFulfillment = new Cart66OrderFulfillment();
$orderF = $orderFulfillment->getModels();
$notify = new Cart66AdvancedNotifications($orderId);
foreach ($orderF as $of) {
$products = array_filter(explode(',', $of->products));
if (array_intersect($data, $products) || empty($products)) {
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] THEY INTERSECT!");
$notify->sendOrderFulfillmentEmails($of->id);
}
}
}
public static function sendTestEmail()
{
$to = $_POST['email'];
$status = $_POST['status'];
if (!Cart66Common::isValidEmail($to)) {
$result[0] = 'Cart66Modal alert-message alert-error';
$result[1] = '<strong>Error</strong><br/>' . __('Please enter a valid email address', 'cart66') . '<br>';
} else {
if (isset($_GET['type']) && $_GET['type'] == 'reminder') {
$sendEmail = Cart66MembershipReminders::sendTestReminderEmails($to, $_GET['id']);
} else {
$sendEmail = Cart66AdvancedNotifications::sendTestEmail($to, $status);
}
if ($sendEmail) {
$result[0] = 'Cart66Modal alert-message success';
$result[1] = '<strong>Success</strong><br/>' . __('Email successfully sent to', 'cart66') . ' <br /><strong>' . $to . '</strong><br>';
} else {
$result[0] = 'Cart66Modal alert-message alert-error';
$result[1] = '<strong>Error</strong><br/>' . __('Email not sent. There is an unknown error.', 'cart66') . '<br>';
}
}
echo json_encode($result);
die;
}
public function emailShortcodes($attrs)
{
$output = '';
if ($attrs['source'] == 'receipt' || $attrs['source'] == 'fulfillment' || $attrs['source'] == 'status' || $attrs['source'] == 'followup') {
$order = new Cart66Order($attrs['id']);
$data = array('bill_first_name', 'bill_last_name', 'bill_address', 'bill_address2', 'bill_city', 'bill_state', 'bill_country', 'bill_zip', 'ship_first_name', 'ship_last_name', 'ship_address', 'ship_address2', 'ship_city', 'ship_state', 'ship_country', 'ship_zip', 'phone', 'email', 'coupon', 'discount_amount', 'trans_id', 'shipping', 'subtotal', 'tax', 'total', 'non_subscription_total', 'custom_field', 'ordered_on', 'status', 'ip', 'products', 'fulfillment_products', 'receipt', 'receipt_link', 'ouid', 'shipping_method', 'account_id', 'tracking_number', 'feature_level', 'subscription_plan_name', 'active_until', 'billing_interval', 'username');
if (in_array($attrs['att'], $data)) {
switch ($attrs['att']) {
case 'bill_first_name':
// Intentional falling through
// Intentional falling through
case 'bill_last_name':
case 'ship_first_name':
case 'ship_last_name':
$output = ucfirst(strtolower($order->{$attrs}['att']));
break;
case 'bill_address':
if ($order->bill_address2 != '') {
$output = $order->{$attrs}['att'] . '<br />' . $order->bill_address2;
} else {
$output = $order->{$attrs}['att'];
}
break;
case 'ship_address':
if ($order->ship_address2 != '') {
$output = $order->{$attrs}['att'] . '<br />' . $order->ship_address2;
} else {
$output = $order->{$attrs}['att'];
}
break;
case 'products':
$output = Cart66Common::getView('/pro/views/emails/email-products.php', array('order' => $order, 'type' => $attrs['type'], 'code' => 'products'));
break;
case 'fulfillment_products':
$output = Cart66Common::getView('/pro/views/emails/email-products.php', array('order' => $order, 'type' => $attrs['type'], 'code' => 'fulfillment_products', 'variable' => $attrs['variable']));
break;
case 'receipt':
$output = Cart66Common::getView('/pro/views/emails/email-receipt.php', array('order' => $order, 'type' => $attrs['type']));
break;
case 'phone':
$output = Cart66Common::formatPhone($order->{$attrs}['att']);
break;
case 'total':
$output = Cart66Common::currency($order->{$attrs}['att'], false);
break;
case 'tax':
$output = Cart66Common::currency($order->{$attrs}['att'], false);
break;
case 'receipt_link':
$receiptPage = get_page_by_path('store/receipt');
$link = get_permalink($receiptPage->ID);
if (strstr($link, "?")) {
$link .= '&ouid=';
} else {
$link .= '?ouid=';
}
$output = $link . $order->ouid;
break;
case 'feature_level':
// Intentionally falling through
// Intentionally falling through
case 'active_until':
case 'subscription_plan_name':
case 'active_until':
case 'active_until':
case 'billing_interval':
if ($order->account_id) {
$sub = new Cart66AccountSubscription($order->account_id);
$output = $sub->{$attrs}['att'];
} else {
$output = "None";
}
break;
case 'username':
if ($order->account_id) {
$sub = new Cart66AccountSubscription($order->account_id);
$account = new Cart66Account();
$account->load($sub->account_id);
//Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] Loaded account: " . print_r($account, true) );
$output = $account->{$attrs}['att'];
} else {
$output = "None";
}
break;
default:
$output = $order->{$attrs}['att'];
}
} elseif (substr($attrs['att'], 0, 8) == 'tracking') {
$output = Cart66AdvancedNotifications::updateTracking($order, $attrs);
} elseif (substr($attrs['att'], 0, 5) == 'date:') {
$output = Cart66AdvancedNotifications::updateDate($attrs);
} elseif (substr($attrs['att'], 0, 12) == 'date_ordered') {
$output = Cart66AdvancedNotifications::updateDateOrdered($order, $attrs);
}
$shipping_options = array('ship_first_name', 'ship_last_name', 'ship_address', 'ship_address2', 'ship_city', 'ship_state', 'ship_country', 'ship_zip');
if (in_array($attrs['att'], $shipping_options) && $order->shipping_method == 'None') {
$output = '';
}
} elseif ($attrs['source'] == 'reminder') {
$sub = new Cart66AccountSubscription($attrs['id']);
$account = new Cart66Account();
$account->load($sub->account_id);
$data = array('billing_first_name', 'billing_last_name', 'feature_level', 'subscription_plan_name', 'active_until', 'billing_interval', 'username', 'opt_out_link');
if (in_array($attrs['att'], $data)) {
switch ($attrs['att']) {
case 'billing_first_name':
// Intentional falling through
// Intentional falling through
case 'billing_last_name':
$output = ucfirst(strtolower($sub->{$attrs}['att']));
break;
case 'active_until':
$output = date(get_option('date_format'), strtotime($sub->{$attrs}['att']));
break;
case 'username':
$output = $account->{$attrs}['att'];
break;
case 'opt_out_link':
$output = Cart66ProCommon::generateUnsubscribeLink($account->id);
break;
default:
$output = $sub->{$attrs}['att'];
}
}
}
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] output: {$output}");
return $output;
}
public function section_debug_settings()
{
$tab = 'debug-error_logging';
if (isset($_GET['cart66_curl_test']) && $_GET['cart66_curl_test'] == 'run' || isset($_POST['cart66-action']) && $_POST['cart66-action'] == 'clear log file') {
$tab = 'debug-debug_data';
} elseif (isset($_POST['cart66-action']) && $_POST['cart66-action'] == 'check subscription reminders') {
Cart66MembershipReminders::dailySubscriptionEmailReminderCheck();
$tab = 'debug-debug_data';
} elseif (isset($_POST['cart66-action']) && $_POST['cart66-action'] == 'check followup emails') {
Cart66AdvancedNotifications::dailyFollowupEmailCheck();
$tab = 'debug-debug_data';
} elseif (isset($_POST['cart66-action']) && $_POST['cart66-action'] == 'prune pending orders') {
$order = new Cart66Order();
$order->dailyPrunePendingPayPalOrders();
$tab = 'debug-debug_data';
} elseif (isset($_GET['sessions']) && $_GET['sessions'] == 'repair') {
$tab = 'debug-session_settings';
}
$data = array('tab' => $tab);
echo Cart66Common::getView('admin/settings/debug.php', $data, false);
}
<?php
if (CART66_PRO && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
?>
<?php
$tracking = explode(',', $order->tracking_number);
if (!empty($order->tracking_number)) {
?>
<tr>
<td colspan="3" class="receipt_tracking_numbers">
<?php
$i = 1;
foreach ($tracking as $key => $value) {
$number = substr(strstr($value, '_'), 1);
$carrier = mb_strstr($value, '_', true);
$carrierName = Cart66AdvancedNotifications::convertCarrierNames($carrier);
$link = Cart66AdvancedNotifications::getCarrierLink($carrier, $number);
?>
<div id="tracking_<?php
echo $i;
?>
_<?php
echo $carrierName;
?>
" class="tracking_number">
<span class="carrier_<?php
echo $carrierName;
?>
"><?php
echo $carrierName;
?>
</span><span class="tracking_text"> <?php
}
if ($mp = Cart66Session::get('Cart66Cart')->getMembershipProduct()) {
$account->attachMembershipProduct($mp, $account->firstName, $account->lastName);
$accountId = $account->id;
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] Attached membership to account id: {$accountId}");
}
// Save the order locally
$orderId = $gateway->saveOrder($total, $tax, $transactionId, $status, $accountId);
Cart66Session::drop('Cart66SubscriberToken');
Cart66Session::set('order_id', $orderId);
Cart66Session::drop('Cart66ProRateAmount');
$receiptLink = Cart66Common::getPageLink('store/receipt');
$newOrder = new Cart66Order($orderId);
// Send email receipts
if (CART66_PRO && CART66_EMAILS && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
$notify = new Cart66AdvancedNotifications($orderId);
$notify->sendAdvancedEmailReceipts();
} elseif (CART66_EMAILS) {
$notify = new Cart66Notifications($orderId);
$notify->sendEmailReceipts();
}
// Send buyer to receipt page
$receiptVars = strpos($receiptLink, '?') ? '&' : '?';
$receiptVars .= "ouid=" . $newOrder->ouid;
wp_redirect($receiptLink . $receiptVars);
exit;
} else {
// Attempt to discover reason for transaction failure
try {
throw new Cart66Exception(__('Your order could not be completed for the following reasons:', 'cart66'), 66500);
} catch (Cart66Exception $e) {
public function getReminderEmailMessage($sub, $mime_boundary, $type = null)
{
$notify = new Cart66AdvancedNotifications();
$subId = isset($sub->id) ? $sub->id : null;
if ($type == 'test') {
if ($this->reminder_plain_email) {
$plain_content = $this->reminder_plain_email;
} else {
$plain_content = $notify->getAdvancedEmailMessageContent('reminder', null, false, true, $this->id);
}
if ($this->reminder_html_email) {
$html_content = $this->reminder_html_email;
} else {
$html_content = $notify->getAdvancedEmailMessageContent('reminder', null, true, true, $this->id);
}
} else {
if ($this->reminder_plain_email) {
$plain_content = strip_tags(str_replace('<br />', "\n", $notify->parseReceiptShortcodes($this->reminder_plain_email, $subId, 'plain', 'reminder')));
} else {
$plain_content = $notify->getAdvancedEmailMessageContent('reminder', $subId, false, false, $this->id);
}
if ($this->reminder_html_email) {
$html_content = $notify->parseReceiptShortcodes($this->reminder_html_email, $subId, 'html', 'reminder');
} else {
$html_content = $notify->getAdvancedEmailMessageContent('reminder', $subId, true, false, $this->id);
}
}
if ($type == 'cc') {
$plain_content = "THIS IS A COPY OF THE EMAIL MESSAGE\n\n{$plain_content}";
$html_content = "THIS IS A COPY OF THE EMAIL MESSAGE<br /><br />{$html_content}";
}
$sendHtml = false;
if ($this->reminder_send_html_emails == 1) {
$sendHtml = true;
}
$body = $notify->buildEmailBody($plain_content, $html_content, $mime_boundary, $sendHtml);
if (CART66_WPMAIL) {
if ($sendHtml) {
$body = array('text/plain' => $plain_content, 'text/html' => $html_content);
} else {
$body = $plain_content;
}
}
return $body;
}
public static function sendTestEmail($sendTestTo, $status)
{
$isSent = false;
$notify = new Cart66AdvancedNotifications();
$from_email = Cart66Setting::getValue($status . '_from_address');
$from_name = Cart66Setting::getValue($status . '_from_name');
$head = $notify->buildEmailHeader($from_name, $from_email);
$email_data = array('from_email' => $from_email, 'from_name' => $from_name, 'to_email' => $sendTestTo, 'to_name' => '', 'copy_to' => '', 'head' => $head, 'subject' => __('TEST EMAIL', 'cart66') . ' --' . strtoupper($status) . '-- ' . Cart66Setting::getValue($status . '_subject'), 'msg' => $notify->getAdvancedEmailMessage(null, $head['mime'], 'test', Cart66Common::postVal('status')), 'msg_cc' => null, 'attachments' => null, 'order_id' => $notify->_order->id, 'email_type' => 'TEST', 'log' => 'test_emails', 'status' => 'test');
$isSent = $notify->sendEmail($email_data);
return $isSent;
}
/**
* Save a PayPal IPN order from a Website Payments Pro cart sale.
*
* @param array $pp Urldecoded array of IPN key value pairs
*/
public function saveOrder($pp)
{
global $wpdb;
// NEW Parse custom value
$referrer = false;
$ouid = $pp['custom'];
if (strpos($ouid, '|') !== false) {
list($ouid, $referrer, $gfData) = explode('|', $ouid);
}
$order = new Cart66Order();
$order->loadByOuid($ouid);
if ($order->id > 0 && $order->status == 'checkout_pending') {
$hasDigital = false;
// Calculate subtotal
$subtotal = 0;
$numCartItems = $pp['num_cart_items'] > 0 ? $pp['num_cart_items'] : 1;
for ($i = 1; $i <= $numCartItems; $i++) {
// PayPal in not consistent in the way it passes back the item amounts
$amt = 0;
if (isset($pp['mc_gross' . $i])) {
$amt = $pp['mc_gross' . $i];
} elseif (isset($pp['mc_gross_' . $i])) {
$amt = $pp['mc_gross_' . $i];
}
$subtotal += $amt;
}
$statusOptions = Cart66Common::getOrderStatusOptions();
$status = $statusOptions[0];
// Parse Gravity Forms ids
$gfIds = array();
if (!empty($gfData)) {
$forms = explode(',', $gfData);
foreach ($forms as $f) {
list($itemId, $formEntryId) = explode(':', $f);
$gfIds[$itemId] = $formEntryId;
}
}
// Look for discount amount
$discount = 0;
if (isset($pp['discount'])) {
$discount = $pp['discount'];
}
$data = array('bill_first_name' => $pp['first_name'], 'bill_last_name' => $pp['last_name'], 'bill_address' => $pp['address_street'], 'bill_city' => $pp['address_city'], 'bill_state' => $pp['address_state'], 'bill_zip' => $pp['address_zip'], 'bill_country' => $pp['address_country'], 'ship_first_name' => $pp['address_name'], 'ship_address' => $pp['address_street'], 'ship_city' => $pp['address_city'], 'ship_state' => $pp['address_state'], 'ship_zip' => $pp['address_zip'], 'ship_country' => $pp['address_country'], 'email' => $pp['payer_email'], 'phone' => $pp['contact_phone'], 'shipping' => $pp['mc_handling'], 'tax' => $pp['tax'], 'subtotal' => $subtotal, 'total' => $pp['mc_gross'], 'discount_amount' => $discount, 'trans_id' => $pp['txn_id'], 'ordered_on' => date('Y-m-d H:i:s', Cart66Common::localTs()), 'status' => $status);
foreach ($data as $key => $value) {
$data[$key] = is_null($value) ? '' : $value;
}
// Verify the first items in the IPN are for products managed by Cart66. It could be an IPN from some other type of transaction.
$productsTable = Cart66Common::getTableName('products');
$orderItemsTable = Cart66Common::getTableName('order_items');
$sql = "SELECT id from {$productsTable} where item_number = '" . $pp['item_number1'] . "'";
$productId = $wpdb->get_var($sql);
if (!$productId) {
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] about to throw an exception, this is not an IPN that should be managed by cart66 because the item number does not match up");
throw new Exception("This is not an IPN that should be managed by Cart66");
}
// Look for the 100% coupons shipping item and move it back to a shipping costs rather than a product
if ($data['shipping'] == 0) {
for ($i = 1; $i <= $numCartItems; $i++) {
$itemNumber = strtoupper($pp['item_number' . $i]);
if ($itemNumber == 'SHIPPING') {
$data['shipping'] = isset($pp['mc_gross_' . $i]) ? $pp['mc_gross_' . $i] : $pp['mc_gross' . $i];
}
}
}
$order->setData($data);
$order->save();
$orderId = $order->id;
// Handle email receipts
if (CART66_PRO && CART66_EMAILS && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
$notify = new Cart66AdvancedNotifications($orderId);
$notify->sendAdvancedEmailReceipts();
} elseif (CART66_EMAILS) {
$notify = new Cart66Notifications($orderId);
$notify->sendEmailReceipts();
}
// Process affiliate reward if necessary
if ($referrer && CART66_PRO) {
Cart66Common::awardCommission($order->id, $referrer);
// End processing affiliate information
if (isset($_COOKIE['ap_id']) && $_COOKIE['ap_id']) {
setcookie('ap_id', $referrer, time() - 3600, "/");
unset($_COOKIE['ap_id']);
}
Cart66Session::drop('app_id');
}
if (CART66_PRO) {
// Begin iDevAffiliate Tracking
if (CART66_PRO && ($url = Cart66Setting::getValue('idevaff_url'))) {
require_once CART66_PATH . "/pro/idevaffiliate-award.php";
}
// End iDevAffiliate Tracking
}
} else {
$orderTable = Cart66Common::getTableName('orders');
// Make sure the transaction id is not already in the database
$sql = "SELECT count(*) as c from {$orderTable} where trans_id=%s";
$sql = $wpdb->prepare($sql, $pp['txn_id']);
$count = $wpdb->get_var($sql);
if ($count < 1) {
$hasDigital = false;
// Calculate subtotal
$subtotal = 0;
$numCartItems = $pp['num_cart_items'] > 0 ? $pp['num_cart_items'] : 1;
for ($i = 1; $i <= $numCartItems; $i++) {
// PayPal in not consistent in the way it passes back the item amounts
$amt = 0;
if (isset($pp['mc_gross' . $i])) {
$amt = $pp['mc_gross' . $i];
} elseif (isset($pp['mc_gross_' . $i])) {
$amt = $pp['mc_gross_' . $i];
}
$subtotal += $amt;
}
$statusOptions = Cart66Common::getOrderStatusOptions();
$status = $statusOptions[0];
$ouid = md5($pp['txn_id'] . $pp['address_street']);
// Parse custom value
$referrer = false;
$deliveryMethod = $pp['custom'];
if (strpos($deliveryMethod, '|') !== false) {
list($deliveryMethod, $referrer, $gfData, $coupon) = explode('|', $deliveryMethod);
}
// Parse Gravity Forms ids
$gfIds = array();
if (!empty($gfData)) {
$forms = explode(',', $gfData);
foreach ($forms as $f) {
list($itemId, $formEntryId) = explode(':', $f);
$gfIds[$itemId] = $formEntryId;
}
}
// Look for discount amount
$discount = 0;
if (isset($pp['discount'])) {
$discount = $pp['discount'];
}
// Look for coupon code
$coupon_code = "none";
if (isset($coupon) && $coupon != "") {
$coupon_code = $coupon;
}
$data = array('bill_first_name' => $pp['first_name'], 'bill_last_name' => $pp['last_name'], 'bill_address' => $pp['address_street'], 'bill_city' => $pp['address_city'], 'bill_state' => $pp['address_state'], 'bill_zip' => $pp['address_zip'], 'bill_country' => $pp['address_country'], 'ship_first_name' => $pp['address_name'], 'ship_address' => $pp['address_street'], 'ship_city' => $pp['address_city'], 'ship_state' => $pp['address_state'], 'ship_zip' => $pp['address_zip'], 'ship_country' => $pp['address_country'], 'shipping_method' => $deliveryMethod, 'email' => $pp['payer_email'], 'phone' => $pp['contact_phone'], 'shipping' => $pp['mc_handling'], 'tax' => $pp['tax'], 'subtotal' => $subtotal, 'total' => $pp['mc_gross'], 'coupon' => $coupon_code, 'discount_amount' => $discount, 'trans_id' => $pp['txn_id'], 'ordered_on' => date('Y-m-d H:i:s', Cart66Common::localTs()), 'status' => $status, 'ouid' => $ouid);
$data = Cart66Common::deNullArrayValues($data);
// Verify the first items in the IPN are for products managed by Cart66. It could be an IPN from some other type of transaction.
$productsTable = Cart66Common::getTableName('products');
$orderItemsTable = Cart66Common::getTableName('order_items');
$sql = "SELECT id from {$productsTable} where item_number = '" . $pp['item_number1'] . "'";
$productId = $wpdb->get_var($sql);
if (!$productId) {
throw new Exception("This is not an IPN that should be managed by Cart66");
}
// Look for the 100% coupons shipping item and move it back to a shipping costs rather than a product
if ($data['shipping'] == 0) {
for ($i = 1; $i <= $numCartItems; $i++) {
$itemNumber = strtoupper($pp['item_number' . $i]);
if ($itemNumber == 'SHIPPING') {
$data['shipping'] = isset($pp['mc_gross_' . $i]) ? $pp['mc_gross_' . $i] : $pp['mc_gross' . $i];
}
}
}
$wpdb->insert($orderTable, $data);
$orderId = $wpdb->insert_id;
$product = new Cart66Product();
for ($i = 1; $i <= $numCartItems; $i++) {
$sql = "SELECT id from {$productsTable} where item_number = '" . $pp['item_number' . $i] . "'";
$productId = $wpdb->get_var($sql);
if ($productId > 0) {
$product->load($productId);
// Decrement inventory
$info = $pp['item_name' . $i];
if (strpos($info, '(') > 0) {
$info = strrchr($info, '(');
$start = strpos($info, '(');
$end = strpos($info, ')');
$length = $end - $start;
$variation = substr($info, $start + 1, $length - 1);
Cart66Common::log("PayPal Variation Information: {$variation}\n{$info}");
}
$qty = $pp['quantity' . $i];
Cart66Product::decrementInventory($productId, $variation, $qty);
if ($hasDigital == false) {
$hasDigital = $product->isDigital();
}
// PayPal is not consistent in the way it passes back the item amounts
$amt = 0;
if (isset($pp['mc_gross' . $i])) {
$amt = $pp['mc_gross' . $i];
} elseif (isset($pp['mc_gross_' . $i])) {
$amt = $pp['mc_gross_' . $i] / $pp['quantity' . $i];
}
// Look for Gravity Form Entry ID
$formEntryId = '';
if (is_array($gfIds) && !empty($gfIds) && isset($gfIds[$i])) {
$formEntryId = $gfIds[$i];
if (class_exists('RGFormsModel')) {
if ($lead = RGFormsModel::get_lead($formEntryId)) {
$lead['status'] = 'active';
RGFormsModel::update_lead($lead);
}
}
}
$duid = md5($pp['txn_id'] . '-' . $orderId . '-' . $productId);
$data = array('order_id' => $orderId, 'product_id' => $productId, 'item_number' => $pp['item_number' . $i], 'product_price' => $amt, 'description' => $pp['item_name' . $i], 'quantity' => $pp['quantity' . $i], 'duid' => $duid, 'form_entry_ids' => $formEntryId);
$wpdb->insert($orderItemsTable, $data);
}
}
// Handle email receipts
if (CART66_PRO && CART66_EMAILS && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
$notify = new Cart66AdvancedNotifications($orderId);
$notify->sendAdvancedEmailReceipts();
} elseif (CART66_EMAILS) {
$notify = new Cart66Notifications($orderId);
$notify->sendEmailReceipts();
}
$promotion = new Cart66Promotion();
$promotion->loadByCode($coupon_code);
if ($promotion) {
$promotion->updateRedemptions();
}
// Process affiliate reward if necessary
if ($referrer) {
Cart66Common::awardCommission($orderId, $referrer);
}
}
// end transaction id check
}
}
public function saveMijirehOrder($order_number)
{
global $wpdb;
// Make sure the order is not already in the database
$orders_table = Cart66Common::getTableName('orders');
$sql = "select id from {$orders_table} where trans_id = %s";
$sql = $wpdb->prepare($sql, $order_number);
$order_id = $wpdb->get_var($sql);
if (!$order_id) {
// Save the order
$order = new Cart66Order();
$cloud_order = $this->pullOrder($order_number);
$order_data = $this->buildOrderDataArray($cloud_order);
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] Order data: " . print_r($order_data, true));
$order_data = Cart66Common::deNullArrayValues($order_data);
$order_id = $order->rawSave($order_data);
// Save the order items
$order_items_table = Cart66Common::getTableName('order_items');
foreach ($cloud_order['items'] as $key => $item) {
$product = new Cart66Product();
$product->loadByItemNumber($item['sku']);
$data = array('order_id' => $order_id, 'product_id' => $product->id, 'product_price' => $item['price'], 'item_number' => $item['sku'], 'description' => $item['name'], 'quantity' => $item['quantity'], 'duid' => md5($order_id . $item['sku']));
// Look for gravity forms data
if (isset($cloud_order['meta_data'][$key]['gforms_' . $item['sku']])) {
$data['form_entry_ids'] = $cloud_order['meta_data'][$key]['gforms_' . $item['sku']];
}
$fIds = array();
if (isset($data['form_entry_ids'])) {
$fIds = explode(',', $data['form_entry_ids']);
if (is_array($fIds) && count($fIds)) {
foreach ($fIds as $entryId) {
if (class_exists('RGFormsModel')) {
if ($lead = RGFormsModel::get_lead($entryId)) {
$lead['status'] = 'active';
RGFormsModel::update_lead($lead);
}
}
}
}
}
$data = Cart66Common::deNullArrayValues($data);
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] Trying to save this order item:" . print_r($data, true));
$wpdb->insert($order_items_table, $data);
$order_item_id = $wpdb->insert_id;
// Decrement inventory after sale
if (Cart66Setting::getValue('track_inventory') == 1) {
$option_info = '';
if (isset($cloud_order['meta_data']['options_' . $item['sku']])) {
$option_info = $cloud_order['meta_data']['options_' . $item['sku']];
}
Cart66Product::decrementInventory($data['product_id'], $option_info, $data['quantity']);
}
// Look for membership product upgrades/extensions
if (isset($cloud_order['meta_data']['account_id']) && is_numeric($cloud_order['meta_data']['account_id'])) {
$order->load($order_id);
$account_id = $cloud_order['meta_data']['account_id'];
if ($mp = $order->getMembershipProduct()) {
$account = new Cart66Account();
$account->load($account_id);
$account->attachMembershipProduct($mp, $account->firstName, $account->lastName);
$order->account_id = $account->id;
$order->save();
}
}
}
//update the number of redemptions for the promotion code.
if (Cart66Session::get('Cart66Promotion')) {
Cart66Session::get('Cart66Promotion')->updateRedemptions();
}
// Send email receipts
if (CART66_PRO && CART66_EMAILS && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
$notify = new Cart66AdvancedNotifications($order_id);
$notify->sendAdvancedEmailReceipts();
} elseif (CART66_EMAILS) {
$notify = new Cart66Notifications($order_id);
$notify->sendEmailReceipts();
}
//Cart66Common::sendEmailReceipts($order_id);
}
// Redirect to receipt page
$this->goToReceipt($order_id);
}
public function saveTcoOrder()
{
global $wpdb;
// NEW Parse custom value
$referrer = false;
$ouid = $_POST['custom'];
if (strpos($ouid, '|') !== false) {
list($ouid, $referrer) = explode('|', $ouid);
}
$order = new Cart66Order();
$order->loadByOuid($ouid);
if ($order->id > 0 && $order->status == 'checkout_pending' && $_POST['total'] == $order->total) {
$statusOptions = Cart66Common::getOrderStatusOptions();
$status = $statusOptions[0];
$data = array('bill_first_name' => $_POST['first_name'], 'bill_last_name' => $_POST['last_name'], 'bill_address' => $_POST['street_address'], 'bill_address2' => $_POST['street_address2'], 'bill_city' => $_POST['city'], 'bill_state' => $_POST['state'], 'bill_zip' => $_POST['zip'], 'bill_country' => $_POST['country'], 'email' => $_POST['email'], 'trans_id' => $_POST['order_number'], 'ordered_on' => date('Y-m-d H:i:s', Cart66Common::localTs()), 'status' => $status);
// Verify the first items in the IPN are for products managed by Cart66. It could be an IPN from some other type of transaction.
$productsTable = Cart66Common::getTableName('products');
$orderItemsTable = Cart66Common::getTableName('order_items');
$sql = "SELECT id from {$productsTable} where item_number = '" . $_POST['li_0_product_id'] . "'";
$productId = $wpdb->get_var($sql);
if (!$productId) {
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] about to throw an exception, this is not an IPN that should be managed by cart66 because the item number does not match up");
throw new Exception("This is not an IPN that should be managed by Cart66");
}
$order->setData($data);
$order->save();
$orderId = $order->id;
// Handle email receipts
if (CART66_PRO && CART66_EMAILS && Cart66Setting::getValue('enable_advanced_notifications') == 1) {
$notify = new Cart66AdvancedNotifications($orderId);
$notify->sendAdvancedEmailReceipts();
} elseif (CART66_EMAILS) {
$notify = new Cart66Notifications($orderId);
$notify->sendEmailReceipts();
}
// Process affiliate reward if necessary
if ($referrer && CART66_PRO) {
Cart66Common::awardCommission($order->id, $referrer);
// End processing affiliate information
if (isset($_COOKIE['ap_id']) && $_COOKIE['ap_id']) {
setcookie('ap_id', $referrer, time() - 3600, "/");
unset($_COOKIE['ap_id']);
}
Cart66Session::drop('app_id');
}
if (CART66_PRO) {
// Begin iDevAffiliate Tracking
if (CART66_PRO && ($url = Cart66Setting::getValue('idevaff_url'))) {
require_once CART66_PATH . "/pro/idevaffiliate-award.php";
}
// End iDevAffiliate Tracking
}
wp_redirect(remove_query_arg('listener', Cart66Common::getCurrentPageUrl()));
exit;
}
}
