public static function rac_send_manual_mail() { global $wpdb, $woocommerce, $to, $user_lang; $table_name = $wpdb->prefix . 'rac_abandoncart'; // $emailtemplate_table_name = $wpdb->prefix . 'rac_templates_email'; $abandancart_table_name = $wpdb->prefix . 'rac_abandoncart'; $sender_option_post = stripslashes($_POST['rac_sender_option']); $from_name_post = stripslashes($_POST['rac_from_name']); $from_email_post = stripslashes($_POST['rac_from_email']); $message_post = stripslashes($_POST['rac_message']); $subject_post = stripslashes($_POST['rac_mail_subject']); $anchor_text_post = stripslashes($_POST['rac_anchor_text']); $mail_row_ids = stripslashes($_POST['rac_mail_row_ids']); $row_id_array = explode(',', $mail_row_ids); $mail_template_id_post = isset($_POST['template_id']) ? $_POST['template_id'] : ''; $table_name_email = $wpdb->prefix . 'rac_templates_email'; ?> <style type="text/css"> table { border-collapse: separate; border-spacing: 0; color: #4a4a4d; font: 14px/1.4 "Helvetica Neue", Helvetica, Arial, sans-serif; } th, td { padding: 10px 15px; vertical-align: middle; } thead { background: #395870; background: linear-gradient(#49708f, #293f50); color: #fff; font-size: 11px; text-transform: uppercase; } th:first-child { border-top-left-radius: 5px; text-align: left; } th:last-child { border-top-right-radius: 5px; } tbody tr:nth-child(even) { background: #f0f0f2; } td { border-bottom: 1px solid #cecfd5; border-right: 1px solid #cecfd5; } td:first-child { border-left: 1px solid #cecfd5; } .book-title { color: #395870; display: block; } .text-offset { color: #7c7c80; font-size: 12px; } .item-stock, .item-qty { text-align: center; } .item-price { text-align: right; } .item-multiple { display: block; } tfoot { text-align: right; } tfoot tr:last-child { background: #f0f0f2; color: #395870; font-weight: bold; } tfoot tr:last-child td:first-child { border-bottom-left-radius: 5px; } tfoot tr:last-child td:last-child { border-bottom-right-radius: 5px; } </style> <?php //$mail_temp_row = $wpdb->get_results("SELECT * FROM $table_name_email WHERE id=$template_id_post", OBJECT); $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=UTF-8\r\n"; if ($sender_option_post == 'local') { $headers .= FPRacCron::rac_formatted_from_address_local($from_name_post, $from_email_post); $headers .= "Reply-To: " . $from_name_post . " <" . $from_email_post . ">\r\n"; } else { $headers .= FPRacCron::rac_formatted_from_address_woocommerce(); $headers .= "Reply-To: " . get_option('woocommerce_email_from_name') . " <" . get_option('woocommerce_email_from_address') . ">\r\n"; } foreach ($row_id_array as $row_id) { $cart_row = $wpdb->get_results("SELECT * FROM {$table_name} WHERE id={$row_id}", OBJECT); //echo $cart_row[0]->user_id; //For Member $cart_array = maybe_unserialize($cart_row[0]->cart_details); $tablecheckproduct = "<table style='width:100%;border:1px solid #eee;'><thead><tr>"; if (get_option('rac_hide_product_name_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<th style='text-align:left;border:1px solid #eee;padding:12px' scope='col'>" . fp_get_wpml_text('rac_template_product_name', $cart_row[0]->wpml_lang, get_option('rac_product_info_product_name')) . "</th>"; } if (get_option('rac_hide_product_image_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<th style='text-align:left;border:1px solid #eee;padding:12px' scope='col'>" . fp_get_wpml_text('rac_template_product_image', $cart_row[0]->wpml_lang, get_option('rac_product_info_product_image')) . "</th>"; } if (get_option('rac_hide_product_price_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<th style='text-align:left;border:1px solid #eee;padding:12px' scope='col'>" . fp_get_wpml_text('rac_template_product_price', $cart_row[0]->wpml_lang, get_option('rac_product_info_product_price')) . "</th>"; } $tablecheckproduct .= "</tr></thead><tbody>"; if (is_array($cart_array)) { $i = 1; foreach ($cart_array as $cart) { if (is_array($cart)) { foreach ($cart as $inside) { if (is_array($inside)) { foreach ($inside as $product) { if ($cart_row[0]->user_id != '0' && $cart_row[0]->user_id != 'old_order') { if ((double) $woocommerce->version <= (double) '2.0.20') { $objectproduct = get_product($product['product_id']); $objectproductvariable = get_product($product['variation_id']); } else { $objectproduct = new WC_Product($product['product_id']); $objectproductvariable = new WC_Product_Variation($product['variation_id']); } $tablecheckproduct .= "<tr>"; if (get_option('rac_hide_product_name_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . get_the_title($product['product_id']) . "</td>"; } if (get_option('rac_hide_product_image_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . get_the_post_thumbnail($product['product_id'], array(90, 90)) . "</td>"; } if (get_option('rac_hide_product_price_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . FPRacCron::get_rac_formatprice($product['variation_id'] == '' ? $objectproduct->get_price() : $objectproductvariable->get_price()) . "</td>"; } $tablecheckproduct .= "</tr>"; } } } } } else { if ($i == '3') { $get_array_keys = array_keys($cart_array); $product_id = $cart_array[$get_array_keys[0]]['product_id']; $variation_id = $cart_array[$get_array_keys[0]]['variation_id']; if ((double) $woocommerce->version <= (double) '2.0.20') { $objectproduct = get_product($product_id); $objectproductvariable = get_product($variation_id); } else { $objectproduct = new WC_Product($product_id); $objectproductvariable = new WC_Product_Variation($variation_id); } $tablecheckproduct .= "<tr>"; if (get_option('rac_hide_product_name_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . get_the_title($product_id) . "</td>"; } if (get_option('rac_hide_product_image_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . get_the_post_thumbnail($product_id, array(90, 90)) . "</td>"; } if (get_option('rac_hide_product_price_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . FPRacCron::get_rac_formatprice($variation_id == '' ? $objectproduct->get_price() : $objectproductvariable->get_price()) . "</td>"; } $tablecheckproduct .= "</tr>"; } $i++; } } } elseif (is_object($cart_array)) { $order = new WC_Order($cart_array->id); // if ($order->user_id != '') { foreach ($order->get_items() as $products) { if ((double) $woocommerce->version <= (double) '2.0.20') { $objectproduct = get_product($products['product_id']); $objectproductvariable = get_product($products['variation_id']); } else { $objectproduct = new WC_Product($products['product_id']); $objectproductvariable = new WC_Product_Variation($products['variation_id']); } $tablecheckproduct .= "<tr>"; if (get_option('rac_hide_product_name_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . get_the_title($products['product_id']) . "</td>"; } if (get_option('rac_hide_product_image_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . get_the_post_thumbnail($products['product_id'], array(90, 90)) . "</td>"; } if (get_option('rac_hide_product_price_product_info_shortcode') != 'yes') { $tablecheckproduct .= "<td style='text-align:left;vertical-align:middle;border:1px solid #eee;word-wrap:break-word;padding:12px'>" . FPRacCron::get_rac_formatprice($products['line_total']) . "</td>"; } $tablecheckproduct .= "</tr>"; } //} } $tablecheckproduct .= "</table>"; if ($cart_row[0]->user_id != '0' && $cart_row[0]->user_id != 'old_order') { //echo 'member'; $sent_mail_templates = maybe_unserialize($cart_row[0]->mail_template_id); if (!is_array($sent_mail_templates)) { $sent_mail_templates = array(); // to avoid mail sent/not sent problem for serialization on store } $current_time = current_time('timestamp'); @($cart_url = WC_Cart::get_cart_url()); $url_to_click = esc_url_raw(add_query_arg(array('abandon_cart' => $cart_row[0]->id, 'email_template' => $mail_template_id_post), $cart_url)); if (get_option('rac_cart_link_options') == '1') { $url_to_click = '<a style="color:' . get_option("rac_email_link_color") . '" href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; } elseif (get_option('rac_cart_link_options') == '2') { $url_to_click = $url_to_click; } else { $cart_text = fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post); $url_to_click = self::rac_cart_link_button_mode($url_to_click, $cart_text); } //$url_to_click = '<a href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; $user = get_userdata($cart_row[0]->user_id); $to = $user->user_email; $user_lang = $cart_row[0]->wpml_lang; $firstname = $user->user_firstname; $lastname = $user->user_lastname; $subject = fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_subject', $cart_row[0]->wpml_lang, $subject_post); $subject = self::shortcode_in_subject($firstname, $lastname, $subject); $message = fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_message', $cart_row[0]->wpml_lang, $message_post); $message = str_replace('{rac.cartlink}', $url_to_click, $message); $message = str_replace('{rac.firstname}', $firstname, $message); $message = str_replace('{rac.lastname}', $lastname, $message); $message = str_replace('{rac.Productinfo}', $tablecheckproduct, $message); if (strpos($message, "{rac.coupon}")) { $coupon_code = FPRacCoupon::rac_create_coupon($user->user_email, $cart_row[0]->cart_abandon_time); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } add_filter('woocommerce_email_footer_text', array('RecoverAbandonCart', 'rac_footer_email_customization')); $message = do_shortcode($message); //shortcode feature if (get_option('rac_email_use_temp_plain') != 'yes') { ob_start(); if (function_exists('wc_get_template')) { wc_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; wc_get_template('emails/email-footer.php'); } else { woocommerce_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; woocommerce_get_template('emails/email-footer.php'); } $woo_temp_msg = ob_get_clean(); } else { $woo_temp_msg = $message; } if ('wp_mail' == get_option('rac_trouble_mail')) { if (FPRacCron::rac_send_wp_mail($to, $subject, $woo_temp_msg, $headers)) { //wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } else { if (FPRacCron::rac_send_mail($to, $subject, $woo_temp_msg, $headers)) { //wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } } //End Member //FOR Guest at place order if ($cart_row[0]->user_id === '0' && is_null($cart_row[0]->ip_address)) { // echo 'guest'; $sent_mail_templates = maybe_unserialize($cart_row[0]->mail_template_id); if (!is_array($sent_mail_templates)) { $sent_mail_templates = array(); // to avoid mail sent/not sent problem for serialization on store } $current_time = current_time('timestamp'); @($cart_url = WC_Cart::get_cart_url()); $url_to_click = esc_url_raw(add_query_arg(array('abandon_cart' => $cart_row[0]->id, 'email_template' => $mail_template_id_post, 'guest' => 'yes'), $cart_url)); //$url_to_click = '<a href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; if (get_option('rac_cart_link_options') == '1') { $url_to_click = '<a style="color:' . get_option("rac_email_link_color") . '" href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; } elseif (get_option('rac_cart_link_options') == '2') { $url_to_click = $url_to_click; } else { $cart_text = fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post); $url_to_click = self::rac_cart_link_button_mode($url_to_click, $cart_text); } // $user = get_userdata($each_cart->user_id); NOT APPLICABLE $order_object = maybe_unserialize($cart_row[0]->cart_details); $to = $order_object->billing_email; $user_lang = $cart_row[0]->wpml_lang; $firstname = $order_object->billing_first_name; $lastname = $order_object->billing_last_name; $subject = self::shortcode_in_subject($firstname, $lastname, $subject_post); $message = str_replace('{rac.cartlink}', $url_to_click, $message_post); $message = str_replace('{rac.firstname}', $firstname, $message); $message = str_replace('{rac.lastname}', $lastname, $message); $message = str_replace('{rac.Productinfo}', $tablecheckproduct, $message); if (strpos($message, "{rac.coupon}")) { $coupon_code = FPRacCoupon::rac_create_coupon($order_object->billing_email, $cart_row[0]->cart_abandon_time); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = do_shortcode($message); //shortcode feature add_filter('woocommerce_email_footer_text', array('RecoverAbandonCart', 'rac_footer_email_customization')); if (get_option('rac_email_use_temp_plain') != 'yes') { ob_start(); if (function_exists('wc_get_template')) { wc_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; wc_get_template('emails/email-footer.php'); } else { woocommerce_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; woocommerce_get_template('emails/email-footer.php'); } $woo_temp_msg = ob_get_clean(); } else { $woo_temp_msg = $message; } if ('wp_mail' == get_option('rac_trouble_mail')) { if (FPRacCron::rac_send_wp_mail($to, $subject, $woo_temp_msg, $headers)) { // wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } else { if (FPRacCron::rac_send_mail($to, $subject, $woo_temp_msg, $headers)) { // wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($store_template_id); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $each_cart->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $each_cart->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } } //END Guest //GUEST Checkout if ($cart_row[0]->user_id == '0' && !is_null($cart_row[0]->ip_address)) { // echo 'checkout'; $sent_mail_templates = maybe_unserialize($each_cart->mail_template_id); if (!is_array($sent_mail_templates)) { $sent_mail_templates = array(); // to avoid mail sent/not sent problem for serialization on store } $current_time = current_time('timestamp'); @($cart_url = WC_Cart::get_cart_url()); $url_to_click = esc_url_raw(add_query_arg(array('abandon_cart' => $cart_row[0]->id, 'email_template' => $mail_template_id_post, 'guest' => 'yes', 'checkout' => 'yes'), $cart_url)); if (get_option('rac_cart_link_options') == '1') { $url_to_click = '<a style="color:' . get_option("rac_email_link_color") . '" href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; } elseif (get_option('rac_cart_link_options') == '2') { $url_to_click = $url_to_click; } else { $cart_text = fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post); $url_to_click = self::rac_cart_link_button_mode($url_to_click, $cart_text); } // $user = get_userdata($each_cart->user_id); NOT APPLICABLE $order_object = maybe_unserialize($cart_row[0]->cart_details); $to = $order_object['visitor_mail']; $user_lang = $cart_row[0]->wpml_lang; $firstname = $order_object['first_name']; $lastname = $order_object['last_name']; $message = str_replace('{rac.cartlink}', $url_to_click, $message_post); $subject = self::shortcode_in_subject($firstname, $lastname, $subject_post); $message = str_replace('{rac.firstname}', $firstname, $message); $message = str_replace('{rac.lastname}', $lastname, $message); $message = str_replace('{rac.Productinfo}', $tablecheckproduct, $message); if (strpos($message, "{rac.coupon}")) { $coupon_code = FPRacCoupon::rac_create_coupon($order_object['visitor_mail'], $cart_row[0]->cart_abandon_time); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = do_shortcode($message); //shortcode feature if (get_option('rac_email_use_temp_plain') != 'yes') { ob_start(); if (function_exists('wc_get_template')) { wc_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; wc_get_template('emails/email-footer.php'); } else { woocommerce_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; woocommerce_get_template('emails/email-footer.php'); } $woo_temp_msg = ob_get_clean(); } else { $woo_temp_msg = $message; } if ('wp_mail' == get_option('rac_trouble_mail')) { if (FPRacCron::rac_send_wp_mail($to, $subject, $woo_temp_msg, $headers)) { // wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } else { if (FPRacCron::rac_send_mail($to, $subject, $woo_temp_msg, $headers)) { // wp_mail($to, $subject, $message); $sent_mail_templates[] = $emails->id; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } } //END Checkout //Order Updated if ($cart_row[0]->user_id == 'old_order' && is_null($cart_row[0]->ip_address)) { // echo 'order'; $sent_mail_templates = maybe_unserialize($each_cart->mail_template_id); $current_time = current_time('timestamp'); @($cart_url = WC_Cart::get_cart_url()); $url_to_click = esc_url_raw(add_query_arg(array('abandon_cart' => $cart_row[0]->id, 'email_template' => $mail_template_id_post, 'old_order' => 'yes'), $cart_url)); //$url_to_click = '<a href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; if (get_option('rac_cart_link_options') == '1') { $url_to_click = '<a style="color:' . get_option("rac_email_link_color") . '" href="' . $url_to_click . '">' . fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post) . '</a>'; } elseif (get_option('rac_cart_link_options') == '2') { $url_to_click = $url_to_click; } else { $cart_text = fp_get_wpml_text('rac_template_' . $mail_template_id_post . '_anchor_text', $cart_row[0]->wpml_lang, $anchor_text_post); $url_to_click = self::rac_cart_link_button_mode($url_to_click, $cart_text); } // $user = get_userdata($each_cart->user_id); NOT APPLICABLE $order_object = maybe_unserialize($cart_row[0]->cart_details); $to = $order_object->billing_email; $user_lang = $cart_row[0]->wpml_lang; $firstname = $order_object->billing_first_name; $lastname = $order_object->billing_last_name; $message = str_replace('{rac.cartlink}', $url_to_click, $message_post); $subject = self::shortcode_in_subject($firstname, $lastname, $subject_post); $message = str_replace('{rac.firstname}', $firstname, $message); $message = str_replace('{rac.lastname}', $lastname, $message); $message = str_replace('{rac.Productinfo}', $tablecheckproduct, $message); if (strpos($message, "{rac.coupon}")) { $coupon_code = FPRacCoupon::rac_create_coupon($order_object->billing_email, $cart_row[0]->cart_abandon_time); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = do_shortcode($message); //shortcode feature if (get_option('rac_email_use_temp_plain') != 'yes') { ob_start(); if (function_exists('wc_get_template')) { wc_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; wc_get_template('emails/email-footer.php'); } else { woocommerce_get_template('emails/email-header.php', array('email_heading' => $subject)); echo $message; woocommerce_get_template('emails/email-footer.php'); } $woo_temp_msg = ob_get_clean(); } else { $woo_temp_msg = $message; } if ('wp_mail' == get_option('rac_trouble_mail')) { if (FPRacCron::rac_send_wp_mail($to, $subject, $woo_temp_msg, $headers)) { // wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } else { if (FPRacCron::rac_send_mail($to, $subject, $woo_temp_msg, $headers)) { // wp_mail($to, $subject, $message); $sent_mail_templates[] = $mail_template_id_post; $store_template_id = maybe_serialize($sent_mail_templates); $wpdb->update($abandancart_table_name, array('mail_template_id' => $store_template_id), array('id' => $cart_row[0]->id)); //add to mail log $table_name_logs = $wpdb->prefix . 'rac_email_logs'; $template_used = $mail_template_id_post . '- Manual'; $wpdb->insert($table_name_logs, array("email_id" => $to, "date_time" => $current_time, "rac_cart_id" => $cart_row[0]->id, "template_used" => $template_used)); FPRacCounter::rac_do_mail_count(); } } } // var_dump($cart_row[0]->user_id); } exit; }