/**
* Scan through the keys of $variables and apply the replacement if one is found
* @param array $variables
* @param array $email_data
* @param object $queue_item
* @param FUE_Email $email
* @return array
*/
protected function add_variable_replacements($variables, $email_data, $queue_item, $email)
{
global $wpdb;
$order = $queue_item->order_id != 0 ? WC_FUE_Compatibility::wc_get_order($queue_item->order_id) : false;
$email = new FUE_Email($queue_item->email_id);
$send_coupon = $email->send_coupon;
$email_coupon_id = $email->coupon_id;
if (!$email->exists() || !$send_coupon) {
return $variables;
}
if ($queue_item->order_id != 0) {
// order
$order = WC_FUE_Compatibility::wc_get_order($queue_item->order_id);
if (isset($order->user_id) && $order->user_id > 0) {
$wp_user = new WP_User($order->user_id);
$email_to = $wp_user->user_email;
} else {
$email_to = $order->billing_email;
}
} else {
$wp_user = new WP_User($queue_item->user_id);
$email_to = $wp_user->user_email;
}
$coupon_code = '';
$coupon = false;
if ($send_coupon == 1 && $email_coupon_id != 0) {
$coupon = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}followup_coupons WHERE `id` = %d", $email_coupon_id));
if (!$coupon) {
$variables['coupon_code'] = '';
$queue_item->add_note(sprintf('Warning: The email coupon (ID #%s) could not be found', $email_coupon_id));
return $variables;
}
$coupon_code = FUE_Coupons::add_prefix(self::generate_coupon_code(), $coupon, $order);
$coupon_array = array('post_title' => $coupon_code, 'post_author' => 1, 'post_date' => date("Y-m-d H:i:s"), 'post_status' => 'publish', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_name' => $coupon_code, 'post_parent' => 0, 'menu_order' => 0, 'post_type' => 'shop_coupon');
$coupon_id = wp_insert_post($coupon_array);
$wpdb->query("UPDATE {$wpdb->prefix}posts SET post_status = 'publish' WHERE ID = {$coupon_id}");
$expiry = '';
if ($coupon->expiry_value > 0 && !empty($coupon->expiry_type)) {
$exp = $coupon->expiry_value . ' ' . $coupon->expiry_type;
$now = current_time('mysql');
$ts = strtotime("{$now} +{$exp}");
if ($ts !== false) {
$expiry = date('Y-m-d', $ts);
}
}
update_post_meta($coupon_id, 'discount_type', $coupon->coupon_type);
update_post_meta($coupon_id, 'coupon_amount', $coupon->amount);
update_post_meta($coupon_id, 'individual_use', $coupon->individual == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'product_ids', $coupon->product_ids);
update_post_meta($coupon_id, 'exclude_product_ids', $coupon->exclude_product_ids);
update_post_meta($coupon_id, 'usage_limit', $coupon->usage_limit);
update_post_meta($coupon_id, 'usage_limit_per_user', $coupon->usage_limit_per_user);
update_post_meta($coupon_id, 'expiry_date', $expiry);
update_post_meta($coupon_id, 'apply_before_tax', $coupon->before_tax == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'free_shipping', $coupon->free_shipping == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'exclude_sale_items', $coupon->exclude_sale_items == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'product_categories', maybe_unserialize($coupon->product_categories));
update_post_meta($coupon_id, 'exclude_product_categories', maybe_unserialize($coupon->exclude_product_categories));
update_post_meta($coupon_id, 'minimum_amount', $coupon->minimum_amount);
update_post_meta($coupon_id, 'maximum_amount', $coupon->maximum_amount);
$product_categories = '';
$exclude_product_categories = '';
if (!empty($coupon->product_categories)) {
$product_categories = unserialize($coupon->product_categories);
}
update_post_meta($coupon_id, 'product_categories', $product_categories);
if (!empty($coupon->exclude_product_categories)) {
$exclude_product_categories = unserialize($coupon->exclude_product_categories);
}
update_post_meta($coupon_id, 'exclude_product_categories', $exclude_product_categories);
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}followup_coupons SET `usage_count` = `usage_count` + 1 WHERE `id` = %d", $coupon->id));
FUE_Coupons::coupon_log($coupon_id, $coupon->coupon_name, $email->name, $email_to, $coupon_code);
// record into the email_orders table
$wpdb->query($wpdb->prepare("UPDATE `{$wpdb->prefix}followup_email_order_coupons` SET `coupon_name` = %s, `coupon_code` = %s WHERE `email_order_id` = %d", $coupon->coupon_name, $coupon_code, $queue_item->id));
$variables['coupon_code'] = $coupon_code;
}
return $variables;
}
public function insert_coupon_code($message, $email_order)
{
global $wpdb;
$order = $email_order->order_id != 0 ? new WC_Order($email_order->order_id) : false;
$email = $wpdb->get_row($wpdb->prepare("SELECT * FROM `{$wpdb->prefix}followup_emails` WHERE `id` = %d", $email_order->email_id));
$email_coupon = $wpdb->get_row($wpdb->prepare("SELECT * FROM `{$wpdb->prefix}followup_email_coupons` WHERE email_id = %d", $email_order->email_id));
if (!$email || !$email_coupon) {
return $message;
}
if ($email_order->order_id != 0) {
// order
$order = new WC_Order($email_order->order_id);
if (isset($order->user_id) && $order->user_id > 0) {
$wp_user = new WP_User($order->user_id);
$email_to = $wp_user->user_email;
} else {
$email_to = $order->billing_email;
}
} else {
$wp_user = new WP_User($email_order->user_id);
$email_to = $wp_user->user_email;
}
$coupon_code = '';
$coupon = false;
if ($email_coupon->send_coupon == 1 && $email_coupon->coupon_id != 0) {
$coupon = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}followup_coupons WHERE `id` = %d", $email_coupon->coupon_id));
$coupon_code = FUE_Coupons::add_prefix(self::generateCouponCode(), $coupon, $order);
$coupon_array = array('post_title' => $coupon_code, 'post_author' => 1, 'post_date' => date("Y-m-d H:i:s"), 'post_status' => 'publish', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_name' => $coupon_code, 'post_parent' => 0, 'menu_order' => 0, 'post_type' => 'shop_coupon');
$coupon_id = wp_insert_post($coupon_array);
$wpdb->query("UPDATE {$wpdb->prefix}posts SET post_status = 'publish' WHERE ID = {$coupon_id}");
$expiry = '';
if ($coupon->expiry_value > 0 && !empty($coupon->expiry_type)) {
$exp = $coupon->expiry_value . ' ' . $coupon->expiry_type;
$now = current_time('mysql');
$ts = strtotime("{$now} +{$exp}");
if ($ts !== false) {
$expiry = date('Y-m-d', $ts);
}
}
update_post_meta($coupon_id, 'discount_type', $coupon->coupon_type);
update_post_meta($coupon_id, 'coupon_amount', $coupon->amount);
update_post_meta($coupon_id, 'individual_use', $coupon->individual == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'product_ids', $coupon->product_ids);
update_post_meta($coupon_id, 'exclude_product_ids', $coupon->exclude_product_ids);
update_post_meta($coupon_id, 'usage_limit', $coupon->usage_limit);
update_post_meta($coupon_id, 'expiry_date', $expiry);
update_post_meta($coupon_id, 'apply_before_tax', $coupon->before_tax == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'free_shipping', $coupon->free_shipping == 0 ? 'no' : 'yes');
update_post_meta($coupon_id, 'product_categories', maybe_unserialize($coupon->product_categories));
update_post_meta($coupon_id, 'exclude_product_categories', maybe_unserialize($coupon->exclude_product_categories));
update_post_meta($coupon_id, 'minimum_amount', $coupon->minimum_amount);
$product_categories = '';
$exclude_product_categories = '';
if (!empty($coupon->product_categories)) {
$product_categories = unserialize($coupon->product_categories);
}
update_post_meta($coupon_id, 'product_categories', $product_categories);
if (!empty($coupon->exclude_product_categories)) {
$exclude_product_categories = unserialize($coupon->exclude_product_categories);
}
update_post_meta($coupon_id, 'exclude_product_categories', $exclude_product_categories);
$wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}followup_coupons SET `usage_count` = `usage_count` + 1 WHERE `id` = %d", $coupon->id));
FUE_Coupons::coupon_log($coupon_id, $coupon->coupon_name, $email->name, $email_to, $coupon_code);
// record into the email_orders table
$wpdb->query($wpdb->prepare("UPDATE `{$wpdb->prefix}followup_email_order_coupons` SET `coupon_name` = %s, `coupon_code` = %s WHERE `email_order_id` = %d", $coupon->coupon_name, $coupon_code, $email_order->id));
$message = str_replace('{coupon_code}', $coupon_code, $message);
}
return $message;
}
