public function saveEmailLog($email_data, $email_type, $copy, $status)
{
if (Cart66Setting::getValue('enable_email_log') == 1) {
global $wpdb;
$date = date("Y-m-d H:i:s", Cart66Common::localTs());
if (is_array($email_data['msg'])) {
$email_data['msg'] = $email_data['msg']['text/plain'] . '\\n\\n' . $email_data['msg']['text/html'];
}
$data = array('send_date' => $date, 'from_email' => $email_data['from_email'], 'from_name' => $email_data['from_name'], 'to_email' => $email_data['to_email'], 'to_name' => $email_data['to_name'], 'headers' => $email_data['head']['headers'], 'subject' => $email_data['subject'], 'body' => $email_data['msg'], 'attachments' => $email_data['attachments'], 'order_id' => $email_data['order_id'], 'email_type' => $email_type, 'copy' => $copy, 'status' => $status);
$logTable = Cart66Common::getTableName('email_log');
$data = Cart66Common::deNullArrayValues($data);
$wpdb->insert($logTable, $data);
$emailLogId = $wpdb->insert_id;
Cart66Common::log("Saved email log ({$emailLogId}): " . $data['status'] . "\nSQL: " . $wpdb->last_query . ' ' . Cart66Common::localTs());
}
}
/**
* 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
}
}
/**
* Store order in database after successful transaction is processed
*/
public function saveOrder($total, $tax, $transId, $status, $accountId = 0)
{
$address = $this->getShipping();
$b = $this->getBilling();
$p = $this->getPayment();
$orderInfo['ship_first_name'] = $address['firstName'];
$orderInfo['ship_last_name'] = $address['lastName'];
$orderInfo['ship_address'] = $address['address'];
$orderInfo['ship_address2'] = $address['address2'];
$orderInfo['ship_city'] = $address['city'];
$orderInfo['ship_state'] = $address['state'];
$orderInfo['ship_zip'] = $address['zip'];
$orderInfo['ship_country'] = Cart66Common::getCountryName($address['country']);
$orderInfo['bill_first_name'] = $b['firstName'];
$orderInfo['bill_last_name'] = $b['lastName'];
$orderInfo['bill_address'] = $b['address'];
$orderInfo['bill_address2'] = $b['address2'];
$orderInfo['bill_city'] = $b['city'];
$orderInfo['bill_state'] = $b['state'];
$orderInfo['bill_zip'] = $b['zip'];
$orderInfo['bill_country'] = Cart66Common::getCountryName($b['country']);
$orderInfo['phone'] = preg_replace("/[^0-9]/", "", $p['phone']);
$orderInfo['email'] = $p['email'];
$orderInfo['custom_field'] = isset($p['custom-field']) ? $p['custom-field'] : '';
$orderInfo['coupon'] = Cart66Common::getPromoMessage();
$orderInfo['tax'] = $tax;
$orderInfo['shipping'] = Cart66Session::get('Cart66Cart')->getShippingCost();
$orderInfo['subtotal'] = Cart66Session::get('Cart66Cart')->getSubTotal();
$orderInfo['total'] = preg_replace("/[^0-9\\.]/", "", $total);
$orderInfo['trans_id'] = $transId;
$orderInfo['status'] = $status;
$orderInfo['ordered_on'] = date('Y-m-d H:i:s', Cart66Common::localTs());
$orderInfo['shipping_method'] = Cart66Session::get('Cart66Cart')->getShippingMethodName();
$orderInfo['account_id'] = $accountId;
$additional_fields = array();
$custom_payment_fields = apply_filters('cart66_after_payment_form', '');
if (is_array($custom_payment_fields)) {
foreach ($custom_payment_fields as $key => $payment_field) {
if (isset($p[$payment_field['slug']])) {
$additional_fields[$payment_field['section']][$payment_field['slug']] = array('label' => $payment_field['label'], 'value' => $p[$payment_field['slug']]);
}
}
}
$custom_billing_fields = apply_filters('cart66_after_billing_form', '');
if (is_array($custom_billing_fields)) {
foreach ($custom_billing_fields as $key => $billing_field) {
if (isset($b[$billing_field['slug']])) {
$additional_fields[$billing_field['section']][$billing_field['slug']] = array('label' => $billing_field['label'], 'value' => $b[$billing_field['slug']]);
}
}
}
$custom_shipping_fields = apply_filters('cart66_after_shipping_form', '');
if (is_array($custom_shipping_fields)) {
foreach ($custom_shipping_fields as $key => $shipping_field) {
if (isset($address[$shipping_field['slug']])) {
$additional_fields[$shipping_field['section']][$shipping_field['slug']] = array('label' => $shipping_field['label'], 'value' => $address[$shipping_field['slug']]);
}
}
}
Cart66Common::log('[' . basename(__FILE__) . ' - line ' . __LINE__ . "] additional fields: " . print_r($additional_fields, true));
if (!empty($additional_fields)) {
$orderInfo['additional_fields'] = serialize($additional_fields);
}
$orderInfo = Cart66Common::deNullArrayValues($orderInfo);
$orderId = Cart66Session::get('Cart66Cart')->storeOrder($orderInfo);
return $orderId;
}
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);
}
