if (Cart66Setting::getValue('display_item_number_cart')) {
?>
<span class="cart66-receipt-item-number"><?php
echo $item->item_number;
?>
</span>
<?php
}
?>
<b><?php
echo nl2br($item->description);
?>
</b>
<?php
$product->load($item->product_id);
if ($product->isDigital()) {
$receiptPage = get_page_by_path('store/receipt');
$receiptPageLink = get_permalink($receiptPage);
$receiptPageLink .= strstr($receiptPageLink, '?') ? '&duid=' . $item->duid : '?duid=' . $item->duid;
echo '<br/><a class="download-link" href="' . $receiptPageLink . '">' . __('Download', 'cart66') . '</a>';
}
?>
</td>
<td style='text-align: center;'><?php
echo $item->quantity;
?>
</td>
<td><?php
echo Cart66Common::currency($item->product_price);
?>
</tr>
</table>
<!-- End Main Table -->
</div>
</body>
</html>
<?php
} else {
$msg = __("ORDER NUMBER", "cart66") . ": " . $order->trans_id . "\n\n";
$msg .= __("Order Status", "cart66") . ": " . str_replace('_', ' ', strtoupper($status)) . "\n\n";
$hasDigital = false;
$product = new Cart66Product();
foreach ($order->getItems() as $item) {
$product->load($item->product_id);
if ($hasDigital == false) {
$hasDigital = $product->isDigital();
}
$price = $item->product_price * $item->quantity;
// $msg .= "Item: " . $item->item_number . ' ' . $item->description . "\n";
$msg .= __("Item", "cart66") . ": ";
if (Cart66Setting::getValue('display_item_number_receipt')) {
$msg .= $item->item_number . ' ';
}
$msg .= $item->description . "\n";
if ($item->quantity > 1) {
$msg .= __("Quantity", "cart66") . ": " . $item->quantity . "\n";
}
$msg .= __("Item Price", "cart66") . ": " . Cart66Common::currency($item->product_price, false) . "\n";
$msg .= __("Item Total", "cart66") . ": " . Cart66Common::currency($item->product_price * $item->quantity, false) . "\n\n";
if ($product->isGravityProduct()) {
$msg .= Cart66GravityReader::displayGravityForm($item->form_entry_ids, true);
public function isDigital()
{
$product = new Cart66Product($this->_productId);
return $product->isDigital();
}
/**
* 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
}
}
}
}
?>
<?php
if ($hasDigital) {
?>
<tr>
<td valign="top">
<br /><?php
_e('Downloads', 'cart66');
?>
:<br />
<?php
$product = new Cart66Product();
foreach ($order->getItems() as $downloadItem) {
if ($product->loadByDuid($downloadItem->duid) && $product->isDigital()) {
$order_item_id = $product->loadItemIdByDuid($downloadItem->duid);
$downloadTimes = $product->countDownloadsForDuid($downloadItem->duid, $order_item_id);
?>
<em><?php
echo $product->name;
?>
: <?php
echo $downloadTimes;
?>
<?php
_e('out of', 'cart66');
?>
<?php
echo $product->download_limit == 0 ? __('unlimited', 'cart66') : $product->download_limit;
?>
public function defaultPlainEmailMessage($order)
{
$msg = __("ORDER NUMBER", "cart66") . ": " . $order->trans_id . "\n\n";
$hasDigital = false;
$product = new Cart66Product();
foreach ($order->getItems() as $item) {
$product->load($item->product_id);
if ($hasDigital == false) {
$hasDigital = $product->isDigital();
}
$price = $item->product_price * $item->quantity;
// $msg .= "Item: " . $item->item_number . ' ' . $item->description . "\n";
$msg .= __("Item", "cart66") . ": " . $item->description . "\n";
if ($hasDigital) {
$receiptPage = get_page_by_path('store/receipt');
$receiptPageLink = get_permalink($receiptPage);
$receiptPageLink .= strstr($receiptPageLink, '?') ? '&duid=' . $item->duid : '?duid=' . $item->duid;
$msg .= "\n" . $receiptPageLink . "\n";
}
if ($item->quantity > 1) {
$msg .= __("Quantity", "cart66") . ": " . $item->quantity . "\n";
}
$msg .= __("Item Price", "cart66") . ": " . Cart66Common::currency($item->product_price, false) . "\n";
$msg .= __("Item Total", "cart66") . ": " . Cart66Common::currency($item->product_price * $item->quantity, false) . "\n\n";
if ($product->isGravityProduct()) {
$msg .= Cart66GravityReader::displayGravityForm($item->form_entry_ids, true);
}
}
if ($order->shipping_method != 'None' && $order->shipping_method != 'Download') {
$msg .= __("Shipping", "cart66") . ": " . Cart66Common::currency($order->shipping, false) . "\n";
}
if (!empty($order->coupon) && $order->coupon != 'none') {
$msg .= __("Coupon", "cart66") . ": " . $order->coupon . "\n";
}
if ($order->tax > 0) {
$msg .= __("Tax", "cart66") . ": " . Cart66Common::currency($order->tax, false) . "\n";
}
$msg .= "\n" . __("TOTAL", "cart66") . ": " . Cart66Common::currency($order->total, false) . "\n";
if ($order->shipping_method != 'None' && $order->shipping_method != 'Download') {
$msg .= "\n\n" . __("SHIPPING INFORMATION", "cart66") . "\n\n";
$msg .= $order->ship_first_name . ' ' . $order->ship_last_name . "\n";
$msg .= $order->ship_address . "\n";
if (!empty($order->ship_address2)) {
$msg .= $order->ship_address2 . "\n";
}
$msg .= $order->ship_city . ' ' . $order->ship_state . ' ' . $order->ship_zip . "\n" . $order->ship_country . "\n";
if (is_array($additional_fields = maybe_unserialize($order->additional_fields)) && isset($additional_fields['shipping'])) {
foreach ($additional_fields['shipping'] as $af) {
$msg .= html_entity_decode($af['label']) . ': ' . $af['value'] . "\n";
}
}
$msg .= "\n" . __("Delivery via", "cart66") . ": " . $order->shipping_method . "\n";
}
$msg .= "\n\n" . __("BILLING INFORMATION", "cart66") . "\n\n";
$msg .= $order->bill_first_name . ' ' . $order->bill_last_name . "\n";
$msg .= $order->bill_address . "\n";
if (!empty($order->bill_address2)) {
$msg .= $order->bill_address2 . "\n";
}
$msg .= $order->bill_city . ' ' . $order->bill_state;
$msg .= $order->bill_zip != null ? ', ' : ' ';
$msg .= $order->bill_zip . "\n" . $order->bill_country . "\n";
if (is_array($additional_fields = maybe_unserialize($order->additional_fields)) && isset($additional_fields['billing'])) {
foreach ($additional_fields['billing'] as $af) {
$msg .= html_entity_decode($af['label']) . ': ' . $af['value'] . "\n";
}
}
if (!empty($order->phone)) {
$phone = Cart66Common::formatPhone($order->phone);
$msg .= "\n" . __("Phone", "cart66") . ": {$phone}\n";
}
if (!empty($order->email)) {
$msg .= __("Email", "cart66") . ': ' . $order->email . "\n";
}
if (is_array($additional_fields = maybe_unserialize($order->additional_fields)) && isset($additional_fields['payment'])) {
foreach ($additional_fields['payment'] as $af) {
$msg .= html_entity_decode($af['label']) . ': ' . $af['value'] . "\n";
}
}
if (isset($order->custom_field) && $order->custom_field != '') {
if (Cart66Setting::getValue('checkout_custom_field_label')) {
$msg .= "\n" . Cart66Setting::getValue('checkout_custom_field_label');
} else {
$msg .= "\n" . __('Enter any special instructions you have for this order:', 'cart66');
}
$msg .= "\n" . $order->custom_field . "\n";
}
$receiptPage = get_page_by_path('store/receipt');
$link = get_permalink($receiptPage->ID);
if (strstr($link, "?")) {
$link .= '&ouid=' . $order->ouid;
} else {
$link .= '?ouid=' . $order->ouid;
}
if ($hasDigital) {
$msg .= "\n" . __('DOWNLOAD LINK', 'cart66') . "\n" . __('Click the link below to download your order.', 'cart66') . "\n{$link}";
} else {
$msg .= "\n" . __('VIEW RECEIPT ONLINE', 'cart66') . "\n" . __('Click the link below to view your receipt online.', 'cart66') . "\n{$link}";
}
$msgIntro = Cart66Setting::getValue('receipt_intro') && !Cart66Setting::getValue('enable_advanced_notifications') ? Cart66Setting::getValue('receipt_intro') : '';
$msgIntro .= Cart66Setting::getValue('receipt_message_intro') && Cart66Setting::getValue('enable_advanced_notifications') ? Cart66Setting::getValue('receipt_plain_email') : '';
$msg = $msgIntro . " \n----------------------------------\n\n" . $msg;
return $msg;
}
