prefix . 'wc_admail'; $sql = "SELECT `value` FROM `$table_name` WHERE `option_name` = 'admail_settings' "; $value = unserialize($wpdb->get_col($sql)[0]); if (isset($value[$setting])) { return $value[$setting]; } return false; } function update_ambisn_setting($setting , $value){ global $wpdb; $table_name = $wpdb->prefix . 'wc_admail'; $sql = "SELECT `value` FROM `$table_name` WHERE `option_name` = 'admail_settings' "; $data = unserialize($wpdb->get_col($sql)[0]); $data[$setting] = $value; $data = array('value' => serialize($data), 'option_type' => 'setting'); $where = array('option_name' => 'admail_settings'); $wpdb->update( "$table_name", $data, $where ); } function get_ambisn_data($key, $date = 'all') { global $wpdb; $table_name = $wpdb->prefix . 'wc_admail'; if ($date == 'all') { $sql = "SELECT `value` FROM `$table_name` WHERE `option_name` = 'subscriptions'"; $data = $wpdb->get_col($sql); $values = array(); foreach ($data as $item) { $unserialized_item = unserialize($item); if (isset($unserialized_item[$key])) { $values[] = $unserialized_item[$key]; } } return $values; } else { $sql = "SELECT `value` FROM `$table_name` WHERE `option_name` = 'subscriptions' AND `date` = '$date'"; $result = $wpdb->get_col($sql); if (!empty($result)) { $data = unserialize($result[0]); if (isset($data[$key])) { return $data[$key]; } } return null; } } function update_ambisn_data($data, $value){ global $wpdb; $date = date('Y-m-d'); $table_name = $wpdb->prefix . 'wc_admail'; $sql = "SELECT `value` FROM `$table_name` WHERE `option_name` = 'subscriptions' AND `date` = '$date'"; $resultsCount = count($wpdb->get_results($sql)); if($resultsCount == 0){ $data_array = serialize(array($data => $value)); $wpdb->insert($table_name, array('date' => $date, 'option_name' => 'subscriptions', 'value' => $data_array, 'option_type' => 'data')); } else{ $data_array = unserialize($wpdb->get_col($sql)[0]); $data_array[$data] = $value; $data = array('value' => serialize($data_array), 'option_type' => 'data'); $where = array('option_name' => 'subscriptions', 'date' => $date); $wpdb->update( $table_name, $data, $where ); } } function ambisn_collected_emails($value , $date){ $emails = get_ambisn_data('emails', $date); if($date == 'all'){ $emails = implode(',' , array_filter($emails)); } $emailsArray = explode(',' , $emails); if(empty($emails)){ $emailsArray = Array(); } switch($value){ case 'count': $result = count($emailsArray); break; case 'emails': $result = $emailsArray; break; } return $result; } add_action('template_redirect','ambisn_do_init'); function ambisn_do_init(){ global $current_user; global $product; if(isset($_POST['ambisn-submit'])){ add_filter('body_class', 'ambisn_success_submission_class'); add_action('wp_head', 'ambisn_hide_wc_notice'); $email = sanitize_email($_POST['ambisn_email']); $product_id = absint($_POST['ambisn_product_id']); global $nmemailErr; if(ambisn_subscription_exists($email, $product_id)){ $nmemailErr = '

'.get_ambisn_setting('form_previously_subscribed_notice').'

'; } elseif(!filter_var($email, FILTER_VALIDATE_EMAIL) || !is_int( $product_id)) { $nmemailErr = '

* Invalid email format

'; } else{ $status = "enabled"; $usersData = get_post_meta($product_id, 'wc_admail_data', true); update_post_meta($product_id, 'wc_admail', true); ambisn_submit($product_id, $email, $status, $usersData); } } if(isset($_POST['ambisn-unsubscribe'])){ $product_id = absint($_POST['ambisn_product_id']); ambisn_unsubscribe_form($product_id, AMBISN_SESSION_ID); add_filter('body_class', 'ambisn_success_submission_class'); add_action('wp_head', 'ambisn_hide_wc_notice'); } } function ambisn_success_submission_class($classes){ $classes[] = 'nm-submitted'; return $classes; } function ambisn_hide_wc_notice(){ echo ''; } function ambisn_unsubscribe_form($product_id, $session_id){ global $current_user; $productSubscribers = get_post_meta($product_id, 'wc_admail_data', true); $regiEmail = $current_user->user_email; $date = date('Y-m-d'); if(is_array($productSubscribers) && isset($productSubscribers[$regiEmail])){ unset($productSubscribers[$regiEmail]); update_post_meta($product_id, 'wc_admail_data', $productSubscribers); $subscriptionCount = intval(get_post_meta($product_id, 'wc_admail_count', true)); $subscribersCount = intval(get_ambisn_data('subscribers_count', $date)); if (!is_int($subscribersCount)) { $subscribersCount = 0; } if (!is_int($subscriptionCount)) { $subscriptionCount = 0; } update_ambisn_data('subscribers_count', $subscribersCount - 1 ); update_post_meta($product_id, 'wc_admail_count', $subscriptionCount - 1); } else{ foreach(array_keys($productSubscribers) as $email){ if($productSubscribers[$email]['sessionID'] == AMBISN_SESSION_ID){ unset($productSubscribers[$email]); update_post_meta($product_id, 'wc_admail_data', $productSubscribers); $subscriptionCount = intval(get_post_meta($product_id, 'wc_admail_count', true)); $subscribersCount = intval(get_ambisn_data('subscribers_count', $date)); if (!is_int($subscribersCount)) { $subscribersCount = 0; } if (!is_int($subscriptionCount)) { $subscriptionCount = 0; } update_ambisn_data('subscribers_count', $subscribersCount - 1 ); update_post_meta($product_id, 'wc_admail_count', $subscriptionCount - 1); break; } } } } //Generate subscription form (simple and variable products) function ambisn_subscription_form($type){ global $product; $product_id = $product->get_id(); $variations_id = $product->get_children(); $popup_set = get_ambisn_setting('popup'); $popup_class = ''; if($popup_set == 1){ $popup_class = 'popup'; } if($type == "simple"){ if(!$product->is_in_stock()){ ?>
is_type('variable')){ $variations = $product->get_available_variations(); $at_least_one_in_stock = false; foreach ( $variations as $variation ) { $variation_obj = wc_get_product( $variation['variation_id'] ); if ( $variation_obj->is_in_stock() ) { $at_least_one_in_stock = true; break; } } $s_variation = get_ambisn_setting('s-variation'); if($at_least_one_in_stock && ($s_variation == 1)){ }else{ foreach($variations_id as $variation_id){ $variation = wc_get_product($variation_id); if(!$variation->is_in_stock()){ ?> get_id(); $popup_set = get_ambisn_setting('popup'); if(!$product->is_in_stock()){ if($popup_set == 1){ $popup_class= 'popup'; } ob_start(); ?>
is_in_stock()){ ?> get_id(), 'product_cat', array( 'fields' => 'slugs' ) ); $categories_match = array_intersect( $excluded_categories, $product_categories ); if(empty($categories_match)){ $guestsSet = get_ambisn_setting('guests'); $popup_set = get_ambisn_setting('popup'); $ajaxify_submission = get_ambisn_setting('ajaxify_submission'); $catVisibilty = get_option('woocommerce_hide_out_of_stock_items'); wp_enqueue_script( 'ambisn_scripts', AMBISN_URL. 'assets/js/scripts.js' , array('jquery'), date("h:i:s") ); if($guestsSet == '1' || is_user_logged_in()){ require_once(AMBISN_PATH.'includes/subscription_form.php'); if($ajaxify_submission == '1'){ wp_enqueue_script( 'ambisn_ajax_submission_script', AMBISN_URL. 'assets/js/ajax_submission_form.js' , array('jquery'), date("h:i:s") ); wp_localize_script( 'ambisn_ajax_submission_script', 'ambisn_script_vars', array('plugin_url' => AMBISN_URL)); } //Show form on simple products if($product->is_type('simple') && !$product->is_in_stock()){ add_action( 'woocommerce_simple_add_to_cart', 'ambisn_subscription_form_simple', 31); if($popup_set == 1){ add_action( 'woocommerce_simple_add_to_cart', 'ambisn_popup_button', 31); } } //Show form on variable products if($product->is_type('variable')){ $variations_id = $product->get_children(); $var_instock = 0; $var_ofs = 0; foreach ($variations_id as $variation_id){ $variation = wc_get_product($variation_id); if ($variation->is_in_stock()) { $var_instock++; }else{ $var_ofs++; } } if(($var_instock == 0) && $catVisibilty == 'yes'){ add_action( 'woocommerce_after_add_to_cart_form', 'ambisn_subscription_form_simple', 21); if($popup_set == 1){ add_action( 'woocommerce_after_add_to_cart_form', 'ambisn_popup_button', 31); } } else{ if(count($variations_id) == "0"){ add_action( 'woocommerce_after_variations_form', 'ambisn_subscription_form_simple', 20); if($popup_set == 1){ add_action( 'woocommerce_after_variations_form', 'ambisn_popup_button'); } } elseif($var_ofs > 0){ add_action( 'woocommerce_single_variation', 'ambisn_subscription_form_variable', 10 ); if($popup_set == 1){ add_action( 'woocommerce_after_add_to_cart_button', 'ambisn_popup_button'); } } } } //Show form on variable products if($product->is_type('grouped')){ add_filter('woocommerce_grouped_product_list_column_label', 'ambisn_susbscription_form_grouped', 10, 2); } } } } function is_ambisn_subscribed($email, $product_id){ $productSubscribers = get_post_meta($product_id, 'wc_admail_data', true); if(!is_array($productSubscribers)){ $productSubscribers = array(); } foreach(array_keys($productSubscribers) as $email){ if($productSubscribers[$email]['sessionID'] == AMBISN_SESSION_ID){ $sessionEmail = $email; break; }else{ $sessionEmail = ''; } } if(!isset($sessionEmail)){ $sessionEmail = ''; } if(is_user_logged_in()){ global $current_user; $regiEmail = $current_user->user_email; if((array_key_exists($regiEmail, $productSubscribers) && $productSubscribers[$regiEmail]['status'] == 'enabled') || (array_key_exists($sessionEmail, $productSubscribers) && $productSubscribers[$sessionEmail]['status'] == 'enabled')){ return true; } } else{ if(array_key_exists($sessionEmail, $productSubscribers) && ($productSubscribers[$sessionEmail]['status'] == 'enabled')){ return true; } } } function ambisn_subscription_exists($email, $product_id, $return = ''){ $productSubscribers = get_post_meta($product_id, 'wc_admail_data', true); if(!is_array($productSubscribers)){ $productSubscribers = array(); } if(array_key_exists($email, $productSubscribers) && $productSubscribers[$email]['status'] == 'enabled'){ if($return == 'response'){ return get_ambisn_setting('form_previously_subscribed_notice'); } else{ return true; } } else{ return false; } } //Submit subscription - Ajax function ajax_ambisn_subscribe(){ if(isset($_REQUEST)){ $email = sanitize_email($_REQUEST['email']); $product_id = absint($_REQUEST['productID']); $_SESSION['nmuseremail'] = sanitize_email($email); require_once (AMBISN_PATH.'includes/subscription_form.php'); if(ambisn_subscription_exists($email, $product_id)){ $notice = 'A previous subscription with this email found!'; echo ambisn_subscription_form_front($product_id, $notice); die(); } elseif(filter_var($email, FILTER_VALIDATE_EMAIL) && is_int($product_id)) { $product = wc_get_product($product_id); $parent_id = $product->get_parent_id(); if($parent_id !== '0'){ update_post_meta($parent_id, 'wc_admail', true); } $status = "enabled"; $usersData = get_post_meta($product_id, 'wc_admail_data', true); update_post_meta($product_id, 'wc_admail', true); ambisn_submit($product_id, $email, $status, $usersData); echo ambisn_subscription_form_front($product_id, ''); die(); } else{ echo $product_id; die(); } } } add_action('wp_ajax_ajax_ambisn_subscribe','ajax_ambisn_subscribe'); add_action('wp_ajax_nopriv_ajax_ambisn_subscribe','ajax_ambisn_subscribe'); //Unsubscribe - Ajax function ajax_ambisn_ajax_unsubscribe(){ if(isset($_REQUEST)){ $product_id = absint($_REQUEST['productID']); if(is_int($product_id)) { ambisn_unsubscribe_form($product_id, AMBISN_SESSION_ID); } require_once (AMBISN_PATH.'includes/subscription_form.php'); echo ambisn_subscription_form_front($product_id, ''); die(); } } add_action('wp_ajax_ajax_ambisn_unsubscribe','ajax_ambisn_ajax_unsubscribe'); add_action('wp_ajax_nopriv_ajax_ambisn_unsubscribe','ajax_ambisn_ajax_unsubscribe'); //function to update database function ambisn_submit($product_id, $email, $status, $usersData){ $date = date('Y-m-d'); //Update active subscriptions if (isset(get_post_meta($product_id, 'wc_admail_data')[0])){ $productSubscriptions = get_post_meta($product_id, 'wc_admail_data')[0]; }else{ $productSubscriptions = array(); } if(!is_ambisn_subscribed($email, $product_id)){ $newItem = array(); $newItem = array('status'=>'enabled','sessionID'=>AMBISN_SESSION_ID, 'date' => $date,); if(!is_array($productSubscriptions)){ $productSubscriptions = array(); } $productSubscriptions[$email] = $newItem; update_post_meta($product_id, 'wc_admail_data', $productSubscriptions); $subscriptionCount = intval(get_post_meta($product_id, 'wc_admail_count', true)); $subscribersCount = intval(get_ambisn_data('subscribers_count', $date)); if (!is_int($subscribersCount)) { $subscribersCount = 0; } if (!is_int($subscriptionCount)) { $subscriptionCount = 0; } update_ambisn_data('subscribers_count', $subscribersCount + 1 ); update_post_meta($product_id, 'wc_admail_count', $subscriptionCount + 1); } //Collect Emails By Product $subscribers = get_post_meta($product_id, 'wc_admail_subscribers', true); if(!is_array($subscribers)){ $subscribers = array(); } if (!in_array($email, array_keys($subscribers))){ $subscribers[$email] = AMBISN_SESSION_ID; update_post_meta($product_id, 'wc_admail_subscribers', $subscribers); } //Collect Emails By Date and update subscribers count $collectedEmails = ambisn_collected_emails('emails', 'all'); if(!in_array($email, $collectedEmails)){ $todaysEmails = ambisn_collected_emails('emails', $date); $todaysEmails[] = $email; $updatedEmails = implode(',',Array_filter($todaysEmails)); update_ambisn_data('emails', $updatedEmails); } } //Prepare ajax data for action function ambisn_ajax_subscription($action, $dataString){ $dataArray = explode(',', $dataString); foreach($dataArray as $item){ $itemData = Array($item); foreach($itemData as $itemSingle){ $itemArray = explode(':', $itemSingle); $product_id = $itemArray[0]; $email = $itemArray[1]; $action = $itemArray[2]; $productSubscribers = get_post_meta($product_id, 'wc_admail_data', true); if($action == "delete"){ unset($productSubscribers[$email]); update_post_meta( $product_id, 'wc_admail_data', $productSubscribers); if(empty(get_post_meta( $product_id, 'wc_admail_data', true ))){ delete_post_meta( $product_id, 'wc_admail'); } } elseif($action == "sent"){ ambisn_mail($email , $product_id); } else{ foreach ($productSubscribers as $key => $value){ if (isset($productSubscribers[$email]['status'])){ $productSubscribers[$email]['status'] = $action; } } update_post_meta($product_id, 'wc_admail_data', $productSubscribers); } } } } //Manage subscription - Ajax function ambisn_ajax_manage_subscription($action){ if(isset($_REQUEST)){ $dataString = sanitize_text_field($_REQUEST['dataString']); ambisn_ajax_subscription($action, $dataString); ambisn_tabsPage('instock'); die(); } } add_action('wp_ajax_ambisn_manage_subscription','ambisn_ajax_manage_subscription'); //Save Settings with Ajax function ambisn_save_settings($action){ if(isset($_REQUEST)){ $settings = json_decode(stripslashes(sanitize_text_field($_REQUEST['settingsData'])), true); foreach($settings as $attr=>$value){ if($attr == 'social_icons'){ if(!is_array($value)){ $value = array(); } $value = serialize($value); } update_ambisn_setting($attr , $value); } die(); } } add_action('wp_ajax_ajax_ambisn_settings','ambisn_save_settings'); //Send emails function ambisn_mail($email, $product_id){ global $post; $product = wc_get_product($product_id); if($product->is_in_stock()){ require_once (AMBISN_PATH.'includes/mail_templates/email_parent_template.php'); $domain_name = sanitize_text_field($_SERVER['SERVER_NAME']); $no_reply = get_ambisn_setting('no_reply'); $store_email = get_ambisn_setting("store_email"); if($no_reply == '1'){$from = 'no-reply';} elseif(empty($store_email)){$from = 'marketing';} else{$from = $store_email;} $subject = get_ambisn_setting("email_subject"); if(empty($subject)){$subject = 'The product you subscribed for is back in stock';} $message = ambisn_mail_template($product_id); $headers = 'From: ' . get_ambisn_setting("store_name") . ' <' . $from . '@' . $domain_name . '>' . "\r\n"; $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n"; $headers .= 'MIME-Version: 1.0' . "\r\n"; wp_mail($email, $subject, $message, $headers); $usersData = get_post_meta($product_id, 'wc_admail_data', true); $usersData[$email]['status'] = 'sent'; update_post_meta($product_id, 'wc_admail_data', $usersData); $notificationSent = get_ambisn_data('notification_sent', date('Y-m-d')) + 1; update_ambisn_data('notification_sent', $notificationSent); } } //Check if auto submission setting is enabled if(get_ambisn_setting('auto_submission') == "1"){ //Send Notices on product update add_action( 'woocommerce_update_product', 'ambisn_auto_send_notices', 10, 1 ); function ambisn_auto_send_notices($product_id) { $product = wc_get_product($product_id); $product_ids = array(); $product_ids[] = $product_id; if($product->is_type('variable')){ $variations_id = $product->get_children(); foreach($variations_id as $variation_id){ $product_ids[]= $variation_id; } } foreach($product_ids as $product_id){ $subscribers = get_post_meta($product_id, 'wc_admail_data', true); foreach($subscribers as $email=>$data){ if( $data['status']== 'enabled'){ ambisn_mail($email, $product_id); } } } } } //Create date range function ambisn_dateRange($nbDays){ $begin = new DateTime(); $begin->sub(new DateInterval('P'.$nbDays.'D')); $end = new DateTime('tomorrow'); $interval = new DateInterval('P1D'); $dateRange = new DatePeriod($begin, $interval, $end); $range = []; return $dateRange; foreach ($dateRange as $date) { $date = $date->format('Y-m-d'); } } function ambisn_get_products(){ $args = array( 'meta_key' => 'wc_admail', 'meta_value' => '1', //'order' => 'DESC', 'limit' => -1, ); $mwproducts = wc_get_products($args); $ambisn_products = array(); foreach($mwproducts as $product){ $product_id = $product->get_id(); $subscribersCount = get_post_meta($product_id, 'wc_admail_count', true); if($product->is_type('variable')){ $subscribersCountParent = get_post_meta($product_id, 'wc_admail_count', true); $ambisn_enabled = get_post_meta($product_id, 'wc_admail', true); if($subscribersCountParent > 0 ){ $ambisn_products[$product_id]= $subscribersCountParent; } if($ambisn_enabled == 1){ $variations_id = $product->get_children(); foreach($variations_id as $variation_id){ $subscribersCount = get_post_meta($variation_id, 'wc_admail_count', true); if($subscribersCount > 0 ){ $ambisn_products[$variation_id]= $subscribersCount; } } } } else{ if($subscribersCount > 0 ){ $ambisn_products[$product_id]= $subscribersCount; } } } arsort($ambisn_products); return $ambisn_products; } function ambisn_get_subscriptions($filter){ $ambisn_products = ambisn_get_products(); $ambisn_product_ids = array_keys($ambisn_products); $subscriptions_data = array(); foreach($ambisn_product_ids as $product_id){ $productSubscribers = get_post_meta($product_id, 'wc_admail_data'); $filtredData = array(); $product = wc_get_product($product_id); foreach($productSubscribers as $subscriber){ foreach($subscriber as $email=>$data){ if($data['status'] == 'enabled' && $product->is_in_stock() && $filter == 'instock'){ $filtredData[$email] = 'instock'; } elseif($data['status'] == 'enabled' && !$product->is_in_stock() && $filter == 'ofs'){ $filtredData[$email] = 'ofs'; } elseif($data['status'] == $filter){ $filtredData[$email] = $data['status']; } } } $subscriptions_data[$product_id] = $filtredData; } return $subscriptions_data; } function ambisn_get_products_by_email($email_input){ $ambisn_products = ambisn_get_products(); $ambisn_product_ids = array_keys($ambisn_products); $products_by_email = array(); foreach($ambisn_product_ids as $product_id){ $productSubscribers = get_post_meta($product_id, 'wc_admail_data'); foreach($productSubscribers as $subscriber){ foreach($subscriber as $email=>$data){ if($email == $email_input){ $products_by_email[] = $product_id; } } } } return $products_by_email; } function ambisn_search_product() { $inputName = isset($_REQUEST['inputName']) ? sanitize_text_field($_REQUEST['inputName']) : ''; $tab = isset($_REQUEST['tab']) ? sanitize_text_field($_REQUEST['tab']) : ''; $args = array( 'limit' => 100, 's' => $inputName, ); $wc_products = wc_get_products($args); if ($wc_products && is_array($wc_products)) { $product_ids = array(); foreach ($wc_products as $product) { $product_ids[] = $product->get_id(); } $subscritions_items = ambisn_get_subscriptions_by_product($tab, $product_ids); ambisn_table_rows($subscritions_items, 1000, 1, $tab); } else { //echo 'No product found matching your search input.'; } die(); } add_action('wp_ajax_ambisn_search_product', 'ambisn_search_product'); function admail_subscription_form(){ global $product; if($product && !$product->is_in_stock()){ $product_id = $product->get_id(); ?>