Active

'; echo ' '; echo '

'; } function fupesm_custom_metabox_callback($post) { ?>

Placeholder

ID, "event", true); $trigger = get_post_meta($post->ID, "trigger", true); $email = get_post_meta($post->ID, "email", true); $content = get_post_meta($post->ID, "content", true); $subject = get_post_meta($post->ID, "subject", true); if (empty($trigger)) { $trigger = '0-minutes'; } $values = explode("-", $trigger); $number = $values[0]; $select_opt = $values[1]; $dropdown_options = [ "New Order" => "new_order", "New User" => "new_user", "Processing Order" => "processing_order", ]; $dropdown_options = [ "New Order" => "new_order", "New User" => "new_user", "Processing Order" => "processing_order", "On-hold" => "on-hold", "Completed Order" => "completed_order", "Failed Order" => "failed_order", "Cancelled Order" => "cancelled_order", "Refunded Order" => "refunded_order", "Abandonment Order" => "abandonment_order", "CF Submission" => "contact_form", "WP Form Submission" => "wp_form_pro", "Gravity Form" => "gravity_form", "Ninja Form" => "ninja_form", "Formidable Form" => "formidable_form", // "Caldera Form" => "caldera_form", ]; $trigger_options = [ "minutes" => "minutes", "hours" => "hours", "days" => "days", ]; $content = get_post_meta($post->ID, "content", true); ?>

Event:

Trigger:

Subject:

'editor_content', 'textarea_rows' => 10, 'editor_class' => 'custom-editor-class', ); wp_editor(wp_kses_post($content), 'editor_content_editor', $args); ?>

ID) ? (int) $post->ID : 0; $statuscheck = $wpdb->get_var($wpdb->prepare("SELECT post_status FROM {$wpdb->prefix}posts WHERE ID=%d", $post_id)); if ($statuscheck == 'auto-draft') { $post_ids = ''; } else { $post_ids = $post_id; } ?>

Test Email:

prefix . 'gf_form_meta'; $fields = $wpdb->get_results($wpdb->prepare("SELECT display_meta FROM $gravity_form_table"), ARRAY_A); foreach ($fields as $fields_val) { $gf_fields = json_decode($fields_val['display_meta']); $field_data = $gf_fields->fields; $field_list = array(); foreach ($field_data as $fieldkey => $fieldval) { $field_list[] = '{' . $fieldval->label . '}'; } $data_placehold = $field_list; } break; case 'Formidable Form': $frm_fields_table = $wpdb->prefix . 'frm_fields'; $field_lists = $wpdb->get_results($wpdb->prepare("SELECT name FROM $frm_fields_table"), ARRAY_A); foreach ($field_lists as $fieldkey => $fieldval) { $field_list[] = '{' . $fieldval['name'] . '}'; } $data_placehold = $field_list; break; case 'WP Form Submission': $wpforms_fields_table = $wpdb->prefix . 'posts'; $field_lists = $wpdb->get_results($wpdb->prepare("SELECT post_content FROM $wpforms_fields_table where post_type='wpforms'"), ARRAY_A); foreach ($field_lists as $field_key => $field_value) { $fields_data = json_decode($field_value['post_content']); $fieldslists = $fields_data->fields; foreach ($fieldslists as $fields_key => $fields_val) { $field_list[] = '{' . $fields_val->label . '}'; } } $data_placehold = $field_list; break; case 'Ninja Form': $ninja_field_table = $wpdb->prefix . 'nf3_fields'; $ninja_field_list = array(); $ninja_fields = $wpdb->get_results($wpdb->prepare("SELECT id,`key`,label FROM $ninja_field_table"), ARRAY_A); foreach ($ninja_fields as $ninja_key => $ninja_val) { if ($ninja_val['label'] !== 'Submit') { $field_list[] = '{' . $ninja_val['label'] . '}'; } } $data_placehold = $field_list; break; } $result['data_placehold'] = $data_placehold; // $test = custom_metabox_callback('',$data_placehold); // echo json_encode($result); wp_send_json_success(['data_placehold' => $data_placehold]); // wp_die(); } add_action('wp_ajax_fupesm_get_selected_value', 'fupesm_get_selected_value'); add_action('wp_ajax_fupesm_send_test_mail', 'fupesm_send_test_mail'); function fupesm_send_test_mail() { check_ajax_referer('smack-follow-up-email', 'securekey'); $email = isset($_POST['email']) ? sanitize_email(wp_unslash($_POST['email'])) : ''; $template_id = isset($_POST['id']) ? intval($_POST['id']) : ''; global $wpdb; $content = get_post_meta($template_id, "content"); $message = wpautop($content[0]); $post_details = get_post($template_id); $subjects = get_post_meta($template_id, "subject"); $subject = $subjects[0]; $headers[] = "From: Wordpress"; add_filter("wp_mail_content_type", function ($content_type) { return "text/html"; }); $event = get_post_meta($template_id,'event',true); switch($event){ case 'New Order': global $wpdb; $order_status = 'wc-pending'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'Processing Order': global $wpdb; $order_status = 'wc-processing'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'On-hold': global $wpdb; $order_status = 'wc-on-hold'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'Completed Order': global $wpdb; $order_status = 'wc-completed'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'Failed Order': global $wpdb; $order_status = 'wc-failed'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'Cancelled Order': global $wpdb; $order_status = 'wc-cancelled'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'Refunded Order': global $wpdb; $order_status = 'wc-refunded'; $orders = wc_get_orders([ 'status' => $order_status, 'limit' => -1, // -1 for all orders ]); $order_ids = wp_list_pluck($orders, 'id'); if(!empty($order_ids)){ $order_id = end($order_ids); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'',$order_id,'','',$event); $message = $tables->fupesm_placeholder_function($message,'',$order_id,'','',$event); } break; case 'New User': global $wpdb; $user_id = get_current_user_id(); if(!empty($user_id)){ $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,$user_id,'','','',$event); $message = $tables->fupesm_placeholder_function($message,$user_id,'','','',$event); } break; case 'Gravity Form': global $wpdb; $gravity_form = $wpdb->get_results("SELECT form_id,entry_id FROM {$wpdb->prefix}gf_entry_meta",ARRAY_A); if(!empty($gravity_form)){ $gravity_data = end($gravity_form); $form_id = $gravity_data['form_id']; $entry_id = $gravity_data['entry_id']; $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'','',$form_id,$entry_id,$event); $message = $tables->fupesm_placeholder_function($message,'','',$form_id,$entry_id,$event); } break; case 'Formidable Form': global $wpdb; $form_id = $wpdb->get_var("SELECT form_id FROM {$wpdb->prefix}frm_items"); $entry_id = $wpdb->get_var("SELECT item_id FROM {$wpdb->prefix}frm_item_meta"); if(!empty($form_id)){ $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'','',$form_id,$entry_id,$event); $message = $tables->fupesm_placeholder_function($message,'','',$form_id,$entry_id,$event); } break; case 'WP Form Submission': global $wpdb; $wpforms_data = $wpdb->get_results("SELECT form_id,entry_id FROM {$wpdb->prefix}wpforms_entries"); if(!empty($wpforms_data)){ $wpforms = end($gravity_form); $form_id = $wpforms['form_id']; $entry_id = $wpforms['entry_id']; $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'','',$form_id,$entry_id,$event); $message = $tables->fupesm_placeholder_function($message,'','',$form_id,$entry_id,$event); } break; case 'Ninja Form': global $wpdb; $form_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM {$wpdb->prefix}posts WHERE post_type=%s",'nf_sub')); $entry_id = $wpdb->get_var($wpdb->prepare("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id=%d and meta_key=%s",$form_id,'_form_id')); if(!empty($form_id) && !empty($entry_id)){ $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,'','',$form_id,$entry_id,$event); $message = $tables->fupesm_placeholder_function($message,'','',$form_id,$entry_id,$event); } break; case 'Abandonment Order': global $wpdb; $cart_detail = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}usermeta WHERE meta_key like '%_woocommerce_persistent_cart_%'"); if(!empty($cart_detail)){ $cart_data = unserialize($cart_detail); $cartdata = $cart_data['cart']; foreach($cartdata as $cart_key => $cart_val){ $cart_id = $cart_val['key']; $product_id = $cart_val['product_id']; $user_id = get_current_user_id(); $tables =new FUPESM_Tables; $subject = $tables->fupesm_placeholder_function($subject,$cart_id,$product_id,$user_id,'',$event); $message = $tables->fupesm_placeholder_function($message,$cart_id,$product_id,$user_id,'',$event); } } break; } $date = new \DateTime('now'); $current_time=$date->format('Y-m-d H:i:s'); $mail_log_table = $wpdb->prefix . "smack_email_log"; if (!empty($email)) { $mail_id = explode(",", $email); foreach ($mail_id as $mailval) { $value = wp_mail($mailval, $subject, $message, $headers); if ($value == 1) { $wpdb->insert($mail_log_table, [ "event" => 'Test Mail', "user_email" => $mailval, "date" => $current_time, "status" => "Success", ]); $status = 1; } else { $wpdb->insert($mail_log_table, [ "event" => 'Test Mail', "user_email" => $mailval, "date" => $current_time, "status" => "Failed", ]); $status = 0; } } if ($status == 1) { wp_send_json_success(['message' => "Your test email was sent successfully."]); } else { $result = array(); $result['message'] = 'Failed'; wp_send_json(array('success' => false, 'data' => $result)); } } } function fupesm_post_autostatus() { check_ajax_referer('smack-follow-up-email', 'securekey'); $id = isset($_POST['post_id']) ? sanitize_text_field(wp_unslash($_POST['post_id'])) : ''; $status = isset($_POST['status']) ? sanitize_text_field(wp_unslash($_POST['status'])) : ''; update_post_meta($id, 'auto_status', $status); } add_action('wp_ajax_fupesm_post_autostatus', 'fupesm_post_autostatus');