function previous_order_rac() { var_dump(RecoverAbandonCart::fp_rac_check_cart_list_manual_recovery('183', '2')); }
public static function rac_send_manual_mail() { global $wpdb, $woocommerce, $to; $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']); $mail_template_post = stripslashes($_POST['rac_template_mail']); // mail plain or html $mail_logo_added = stripslashes($_POST['rac_logo_mail']); // mail logo uploaded $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'; $logo = '<table><tr><td align="center" valign="top"><p style="margin-top:0;"><img src="' . esc_url($mail_logo_added) . '" /></p></td></tr></table>'; // mail uploaded ?> <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 = fp_rac_extract_cart_details($cart_row[0]); 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; $firstname = $user->user_firstname; $lastname = $user->user_lastname; // $logo = '<p style="float:left; margin-top:0"><img src="' . esc_url( $mail_logo_added ) . '" /></p>'; // mail uploaded $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); update_option('abandon_time_of' . $cart_row[0]->id, $coupon_code); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = RecoverAbandonCart::rac_unsubscription_shortcode($to, $message); add_filter('woocommerce_email_footer_text', array('RecoverAbandonCart', 'rac_footer_email_customization')); $message = do_shortcode($message); //shortcode feature $logo = '<table><tr><td align="center" valign="top"><p style="margin-top:0;"><img src="' . esc_url($mail_logo_added) . '" /></p></td></tr></table>'; // mail uploaded // mail send plain or html $woo_temp_msg = self::email_woocommerce_html($mail_template_post, $subject, $message, $logo); // mail send plain or html 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; $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); update_option('abandon_time_of' . $cart_row[0]->id, $coupon_code); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = RecoverAbandonCart::rac_unsubscription_shortcode($to, $message); $message = do_shortcode($message); //shortcode feature add_filter('woocommerce_email_footer_text', array('RecoverAbandonCart', 'rac_footer_email_customization')); $logo = '<table><tr><td align="center" valign="top"><p style="margin-top:0;"><img src="' . esc_url($mail_logo_added) . '" /></p></td></tr></table>'; // mail uploaded // mail send plain or html $woo_temp_msg = self::email_woocommerce_html($mail_template_post, $subject, $message, $logo); // mail send plain or html 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' => $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 Guest //GUEST Checkout if ($cart_row[0]->user_id == '0' && !is_null($cart_row[0]->ip_address)) { // echo 'checkout'; $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', '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']; $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); update_option('abandon_time_of' . $cart_row[0]->id, $coupon_code); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = do_shortcode($message); //shortcode feature $logo = '<table><tr><td align="center" valign="top"><p style="margin-top:0;"><img src="' . esc_url($mail_logo_added) . '" /></p></td></tr></table>'; // mail uploaded // mail send plain or html $woo_temp_msg = self::email_woocommerce_html($mail_template_post, $subject, $message, $logo); // mail send plain or html 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 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; $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); update_option('abandon_time_of' . $cart_row[0]->id, $coupon_code); $message = str_replace('{rac.coupon}', $coupon_code, $message); //replacing shortcode with coupon code } $message = do_shortcode($message); //shortcode feature $logo = '<table><tr><td align="center" valign="top"><p style="margin-top:0;"><img src="' . esc_url($mail_logo_added) . '" /></p></td></tr></table>'; // mail uploaded // mail send plain or html $woo_temp_msg = self::email_woocommerce_html($mail_template_post, $subject, $message, $logo); // mail send plain or html 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; }
public static function rac_send_mail($to, $subject, $woo_temp_msg, $headers) { global $woocommerce; $getdesiredoption = get_option('custom_exclude'); if ($getdesiredoption == 'user_role') { $userrolenamemailget = get_option('custom_user_role'); $getuserby = get_user_by('email', $to); if ($getuserby) { $newto = $getuserby->roles[0]; } else { $newto = $to; } } elseif ($getdesiredoption == 'name') { $userrolenamemailget = get_option('custom_user_name_select'); $getuserby = get_user_by('email', $to); if ($getuserby) { $newto = $getuserby->ID; } else { $newto = $to; } } else { $userrolenamemailget = get_option('custom_mailid_edit'); $userrolenamemailget = explode("\r\n", $userrolenamemailget); $newto = $to; } $check_member_guest = RecoverAbandonCart::check_is_member_or_guest($to); $proceed = '1'; if ($check_member_guest) { // for member $userid = RecoverAbandonCart::rac_return_user_id($to); $status = get_user_meta($userid, 'fp_rac_mail_unsubscribed', true); if ($status != 'yes') { $proceed = '1'; } else { $proceed = '2'; } } else { // for guest $needle = $to; if (!in_array($needle, (array) get_option('fp_rac_mail_unsubscribed'))) { $proceed = '1'; } else { $proceed = '2'; } } if ($proceed == '1') { if ((double) $woocommerce->version <= (double) '2.2.0') { if (!in_array($newto, (array) $userrolenamemailget)) { if (get_option('rac_webmaster_mail') == 'webmaster1') { return mail($to, $subject, $woo_temp_msg, $headers, '-f ' . get_option('rac_textarea_mail')); } else { return mail($to, $subject, $woo_temp_msg, $headers); } } } else { if (!in_array($newto, (array) $userrolenamemailget)) { $mailer = WC()->mailer(); $mailer->send($to, $subject, $woo_temp_msg, $headers, ''); return "1"; } } } }
public static function fp_rac_cookies_for_cart_recover($order_id) { if (isset($_COOKIE['rac_cart_id'])) { $row_id = $_COOKIE['rac_cart_id']; global $wpdb; $abandon_cart_table = $wpdb->prefix . 'rac_abandoncart'; $wpdb->update($abandon_cart_table, array('placed_order' => $order_id), array('id' => $row_id)); update_post_meta($order_id, 'rac_order_placed', $row_id); //counter FPRacCounter::rac_do_recovered_count(); RecoverAbandonCart::fp_rac_mail_admin_cart_recovered($order_id); //mailing admin on order recover } else { $order_placed = '1'; self::fp_rac_check_cart_list_manual_recovery($order_id, $order_placed); } }