Changeset 2911702

Timestamp:

05/12/2023 04:22:15 PM (3 years ago)

Author:

simonefontana

Message:

Update plugin version 1.3

Location:

sf-autosuggest-product-search

Files:

• tags/1.3 (added)
• tags/1.3/README.txt (added)
• tags/1.3/assets (added)
• tags/1.3/assets/css (added)
• tags/1.3/assets/css/sf_pa.css (added)
• tags/1.3/assets/css/sf_pa_admin.css (added)
• tags/1.3/assets/fonts (added)
• tags/1.3/assets/fonts/Roboto (added)
• tags/1.3/assets/fonts/Roboto/LICENSE.txt (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Black.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-BlackItalic.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Bold.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-BoldItalic.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Italic.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Light.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-LightItalic.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Medium.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-MediumItalic.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Regular.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-Thin.ttf (added)
• tags/1.3/assets/fonts/Roboto/Roboto-ThinItalic.ttf (added)
• tags/1.3/assets/img (added)
• tags/1.3/assets/img/loading.gif (added)
• tags/1.3/assets/img/search-example.png (added)
• tags/1.3/assets/js (added)
• tags/1.3/assets/js/sf_pa.js (added)
• tags/1.3/assets/js/sf_pa_admin.js (added)
• tags/1.3/classes (added)
• tags/1.3/classes/AdminClass.php (added)
• tags/1.3/classes/SearchClass.php (added)
• tags/1.3/classes/ValidatorClass.php (added)
• tags/1.3/sf_products_autosuggest.php (added)
• trunk/README.txt (modified) (4 diffs)
• trunk/assets/css/sf_pa.css (modified) (1 diff)
• trunk/assets/img/loading.gif (added)
• trunk/assets/js/sf_pa.js (modified) (3 diffs)
• trunk/assets/js/sf_pa_admin.js (modified) (1 diff)
• trunk/classes/AdminClass.php (modified) (4 diffs)
• trunk/classes/SearchClass.php (modified) (1 diff)
• trunk/sf_products_autosuggest.php (modified) (2 diffs)

sf-autosuggest-product-search/trunk/README.txt

@@ -5 +5 @@
 Requires PHP: 7.0
 Tested up to: 6.2
-Stable tag:1.2
+Stable tag: 1.3
 License: GPLv3
 License URI: http://www.gnu.org/licenses/gpl-3.0.txt
@@ -13 +13 @@
 == Description ==
 
-SF Autosuggest Product Search is a plugin for add Woocommerce search Autosuggest to your ecommerce.
+SF Autosuggest Product Search is a plugin for add Woocommerce search Autosuggest to your ecommerce. 
+With this Woocomerce search plugin you can improve products search and give a better experience to your users.
 It's very simple to add Autosuggest Product into your ecommerce.
 Choose your preference from SF Autosuggest Products settings.
@@ -54 +55 @@
 
 == Changelog ==
-= 1.1 =
-* Added sf_pa_autosuggest_results filter to filter results.
-* Added wpml compatibility
-* Added ability to customize "Show all results" text
+
+= 1.3 =
+* Added loader in input search
+* Save search data in transients for better performance
 
 = 1.2 =
@@ -64 +65 @@
 * Fix bug incorrect permalink
 
+= 1.1 =
+* Added sf_pa_autosuggest_results filter to filter results.
+* Added wpml compatibility
+* Added ability to customize "Show all results" text
+
 == Upgrade Notice ==

sf-autosuggest-product-search/trunk/assets/css/sf_pa.css

@@ -53 +53 @@
     text-align: center;
 }
+
+img.sf_pa_loader {
+    display: none;
+    position: absolute;
+    top: 0px;
+    left: inherit;
+    right: 10px;
+    width: 30px;
+    top: 5px;
+}

sf-autosuggest-product-search/trunk/assets/js/sf_pa.js

@@ -3 +3 @@
     function(){
         jQuery('#sf_pa_search_input').on('input', function(){
+            var input_container = jQuery(this).closest('.sf_pa_search_input_container');
             if(jQuery(this).val().length > 2){
                 if (postcall){
                     postcall.abort();
                 }
+                showLoader();
                 jQuery('.sf_pa_autosuggest_response').remove();
                 jQuery('.sf_pa_autosuggest_container').remove();
@@ -16 +18 @@
 
                 postcall = jQuery.post(sf_pa_ajax_object.ajaxurl, data, function(response) {
-                    jQuery('.sf_pa_search_input_container').append('<div class="sf_pa_autosuggest_container"></div>');
+                    hideLoader();
+                    jQuery(input_container).append('<div class="sf_pa_autosuggest_container"></div>');
                     for (var i = 0; i < response.length; ++i) {
                         var to_append = '<div class="sf_pa_autosuggest_response"><div>';
@@ -59 +62 @@
     }
 );
+
+function showLoader(){
+    jQuery('.sf_pa_loader').show();
+}
+
+function hideLoader(){
+    jQuery('.sf_pa_loader').hide();
+}

sf-autosuggest-product-search/trunk/assets/js/sf_pa_admin.js

@@ -1 +1 @@
 jQuery(document).ready(function($){
     $('.sf_pa_color_picker').wpColorPicker();
+    $('#sf_remove_transient').on('click', function(){
+        /* TODO: fare ajax per cancellazione transients */
+        var data = {
+            'action': 'delete_sf_pa_transient'
+        };
+        jQuery.post(ajaxurl, data, function(response) {
+            location.reload();
+        });
+            
+    });
 });

sf-autosuggest-product-search/trunk/classes/AdminClass.php

@@ -5 +5 @@
         add_action( 'admin_init', [$this, 'register_settings'] );
         add_action( 'admin_menu', [$this, 'add_settings_page'] );
+        add_action( 'wp_ajax_delete_sf_pa_transient', [$this, 'delete_sf_pa_transient'] );
    }
 
@@ -23 +24 @@
                         <?php 
                         settings_fields( 'sf_pa_autosuggest_plugin_options' );
-                        do_settings_sections( 'sf_pa_autosuggest_plugin' ); ?>
+                        do_settings_sections( 'sf_pa_autosuggest_plugin' ); 
+                        ?>
+                        <h3><?php _e('Delete Transient', 'sf_products_autosuggest'); ?></h3>
+                        <p><?php echo $this->count_sf_pa_transient(); ?> <?php _e('Searches saved in transients.', 'sf_products_autosuggest'); ?></p>
+                        <p><?php _e('Delete all transients and remove cache data:', 'sf_products_autosuggest'); ?> <button type="button" id="sf_remove_transient"><?php _e('Remove Transient', 'sf_products_autosuggest'); ?></button>
+                        </p>
                         <input name="submit" class="button button-primary" type="submit" value="<?php esc_attr_e( 'Save', 'sf_products_autosuggest'); ?>" />
                     </form>
@@ -164 +170 @@
 
     public function taxonomies($params){
-        /*TODO: multple choice*/
         $options = get_option( 'sf_pa_autosuggest_plugin_options' );
         $value = '';
@@ -193 +198 @@
         $newinput['all_bg'] =  $validator->hexadecimal($input['all_bg'], '#000');
         $newinput['all_color'] =  $validator->hexadecimal($input['all_color'], '#fff');
-        $newinput['show_thumbnail'] = $validator->checkbox($input['show_thumbnail']);
-        $newinput['show_cat'] = $validator->checkbox($input['show_cat']);
+        if(isset($input['show_thumbnail']) && !empty($input['show_thumbnail'])){
+            $newinput['show_thumbnail'] = $validator->checkbox($input['show_thumbnail']);
+        }
+        if(isset($input['show_cat']) && !empty($input['show_cat'])){
+            $newinput['show_cat'] = $validator->checkbox($input['show_cat']);
+        }
         $newinput['exclude_cat'] = $validator->ids($input['exclude_cat']);
         $newinput['exclude_ids'] =  $validator->ids($input['exclude_ids']);
         $newinput['taxonomies_search'] = array();
-        foreach($input['taxonomies_search'] as $single_tax){
-            if( $single_tax != '')
-                $newinput['taxonomies_search'][] =  $validator->plaintext($single_tax);
-        }
-        
+        if(isset($input['taxonomies_search']) && !empty($input['taxonomies_search'])){
+            foreach($input['taxonomies_search'] as $single_tax){
+                if( $single_tax != '')
+                    $newinput['taxonomies_search'][] =  $validator->plaintext($single_tax);
+            }
+        }
     
         return $newinput;
+    }
+
+    private function count_sf_pa_transient(){
+        $transient_to_delete = get_transient('sf_pa_transient');
+        if($transient_to_delete){
+            return count($transient_to_delete);
+        }
+        return 0;
+    }
+
+    public function delete_sf_pa_transient(){
+        $transient_to_delete = get_transient('sf_pa_transient');
+        if($transient_to_delete){
+            foreach($transient_to_delete as $single_transient){
+                delete_transient('sf_pa_'.$single_transient);
+            }
+        }
+        delete_transient('sf_pa_transient');
+        return 1;
     }
 }

sf-autosuggest-product-search/trunk/classes/SearchClass.php

@@ -14 +14 @@
         global $wpdb;
 
-        $prepare =  array($this->options['show_cat'], $this->options['show_thumbnail'], '%' . $wpdb->esc_like($sf_pa_search) .'%');
-        $join = '';
-        $where = '';
+        $results = get_transient('sf_pa_'.$sf_pa_search);
+        /* IF NOT CACHED */
+        if(!$results){
 
-        //Check if site use wpml
-        if (class_exists('SitePress')) {
-            $lang = esc_sql(apply_filters( 'wpml_current_language', NULL ));
-            $join = " LEFT JOIN ".$wpdb->prefix."icl_translations ON ".$wpdb->prefix."icl_translations.element_id = ".$wpdb->prefix."posts.ID AND element_type = 'post_product'";
-            $where = " AND ".$wpdb->prefix."icl_translations.language_code = %s";
-            $prepare[] = $lang;
+            $prepare =  array($this->options['show_cat'], $this->options['show_thumbnail'], '%' . $wpdb->esc_like($sf_pa_search) .'%');
+            $join = '';
+            $where = '';
+
+            //Check if site use wpml
+            if (class_exists('SitePress')) {
+                $lang = esc_sql(apply_filters( 'wpml_current_language', NULL ));
+                $join = " LEFT JOIN ".$wpdb->prefix."icl_translations ON ".$wpdb->prefix."icl_translations.element_id = ".$wpdb->prefix."posts.ID AND element_type = 'post_product'";
+                $where = " AND ".$wpdb->prefix."icl_translations.language_code = %s";
+                $prepare[] = $lang;
+            }
+
+            $sql = "SELECT ".$wpdb->prefix."posts.ID, ".$wpdb->prefix."posts.post_title as title, img_postmeta.meta_value as img_url,  ".$wpdb->prefix."terms.name as cat_title, %s as show_cat, %s as show_thumbnail, 'product' AS type
+                    FROM ".$wpdb->prefix."posts
+                    LEFT JOIN ".$wpdb->prefix."postmeta ON ".$wpdb->prefix."postmeta.post_id =  ".$wpdb->prefix."posts.ID AND ".$wpdb->prefix."postmeta.meta_key = '_thumbnail_id'
+                    LEFT JOIN ".$wpdb->prefix."postmeta as img_postmeta ON img_postmeta.post_id =  ".$wpdb->prefix."postmeta.meta_value AND img_postmeta.meta_key = '_wp_attachment_metadata'
+                    LEFT JOIN ".$wpdb->prefix."term_relationships ON ".$wpdb->prefix."term_relationships.object_id = ".$wpdb->prefix."posts.ID
+                    LEFT JOIN ".$wpdb->prefix."terms ON ".$wpdb->prefix."terms.term_id = ".$wpdb->prefix."term_relationships.term_taxonomy_id
+                    LEFT JOIN ".$wpdb->prefix."term_taxonomy ON ".$wpdb->prefix."term_taxonomy.term_id = ".$wpdb->prefix."terms.term_id
+                    ".$join."
+                    WHERE ".$wpdb->prefix."posts.post_title LIKE %s AND ".$wpdb->prefix."posts.post_type = 'product' AND ".$wpdb->prefix."posts.post_status = 'publish'
+                    AND ".$wpdb->prefix."term_taxonomy.taxonomy = 'product_cat'". $where;
+                    
+
+            if(isset($this->options['exclude_ids']) && !empty($this->options['exclude_ids'])){
+                $sql .=  "AND ".$wpdb->prefix."posts.id NOT IN (%s)";
+                $prepare[] = $this->options['exclude_ids'];
+            }
+            if(isset($this->options['results_count']) && !empty($this->options['results_count'])){
+                $this->count = $this->options['results_count'];
+            }
+            $sql .= " GROUP BY ".$wpdb->prefix."posts.ID LIMIT %d";
+
+            $prepare[] = $this->count;
+            
+            $results_prod = $wpdb->get_results($wpdb->prepare($sql, $prepare));
+
+            $results_cat = array();
+            if(isset($this->options['taxonomies_search']) && !empty($this->options['taxonomies_search']) && is_array($this->options['taxonomies_search'])){
+                $results_cat = $this->get_taxonomies_search($sf_pa_search);
+            }
+            
+
+            foreach($results_prod as $single_prod){
+                $single_prod->img_url = $this->get_thumb_from_serialize($single_prod->img_url);
+                $single_prod->title = esc_html($single_prod->title);
+                $single_prod->cat_title = esc_html($single_prod->cat_title);
+                $single_prod->link = esc_url($this->build_link($single_prod->type, $single_prod->ID));
+                $this->results[] = $single_prod;
+            }
+
+            foreach($results_cat as $single_cat){
+                $single_cat->name = esc_html($single_cat->name);
+                $single_cat->link = esc_url($this->build_link($single_cat->type, false, $single_cat->taxonomy,$single_cat->slug ));
+                $this->results[] = $single_cat;
+            }
+
+            //LIMIT ARRAY TO MAX COUNT
+            if(is_int($this->count) && count($this->results) > $this->count){
+                $this->results = array_slice($this->results, 0, $this->count);
+            }
+
+            $this->results = apply_filters('sf_pa_autosuggest_results', $this->results);
+            //Save data in transient for 24h
+            
+            $transient_to_delete = get_transient('sf_pa_transient');
+            if($transient_to_delete){
+                $transient_to_delete[] = $sf_pa_search;
+                set_transient('sf_pa_transient', $transient_to_delete);
+            }
+            else{
+                $transient_to_delete = array($sf_pa_search);
+                set_transient('sf_pa_transient', $transient_to_delete);
+            }
+
+            set_transient('sf_pa_'.$sf_pa_search, $this->results, 86400);
+            
+            
         }
-
-        $sql = "SELECT ".$wpdb->prefix."posts.ID, ".$wpdb->prefix."posts.post_title as title, img_postmeta.meta_value as img_url,  ".$wpdb->prefix."terms.name as cat_title, %s as show_cat, %s as show_thumbnail, 'product' AS type
-                FROM ".$wpdb->prefix."posts
-                LEFT JOIN ".$wpdb->prefix."postmeta ON ".$wpdb->prefix."postmeta.post_id =  ".$wpdb->prefix."posts.ID AND ".$wpdb->prefix."postmeta.meta_key = '_thumbnail_id'
-                LEFT JOIN ".$wpdb->prefix."postmeta as img_postmeta ON img_postmeta.post_id =  ".$wpdb->prefix."postmeta.meta_value AND img_postmeta.meta_key = '_wp_attachment_metadata'
-                LEFT JOIN ".$wpdb->prefix."term_relationships ON ".$wpdb->prefix."term_relationships.object_id = ".$wpdb->prefix."posts.ID
-                LEFT JOIN ".$wpdb->prefix."terms ON ".$wpdb->prefix."terms.term_id = ".$wpdb->prefix."term_relationships.term_taxonomy_id
-                LEFT JOIN ".$wpdb->prefix."term_taxonomy ON ".$wpdb->prefix."term_taxonomy.term_id = ".$wpdb->prefix."terms.term_id
-                ".$join."
-                WHERE ".$wpdb->prefix."posts.post_title LIKE %s AND ".$wpdb->prefix."posts.post_type = 'product' AND ".$wpdb->prefix."posts.post_status = 'publish'
-                AND ".$wpdb->prefix."term_taxonomy.taxonomy = 'product_cat'". $where;
-                
-
-        if(isset($this->options['exclude_ids']) && !empty($this->options['exclude_ids'])){
-            $sql .=  "AND ".$wpdb->prefix."posts.id NOT IN (%s)";
-            $prepare[] = $this->options['exclude_ids'];
-        }
-        if(isset($this->options['results_count']) && !empty($this->options['results_count'])){
-            $this->count = $this->options['results_count'];
-        }
-        $sql .= " GROUP BY ".$wpdb->prefix."posts.ID LIMIT %d";
-
-        $prepare[] = $this->count;
-        
-        $results_prod = $wpdb->get_results($wpdb->prepare($sql, $prepare));
-
-        $results_cat = array();
-        if(isset($this->options['taxonomies_search']) && !empty($this->options['taxonomies_search']) && is_array($this->options['taxonomies_search'])){
-            $results_cat = $this->get_taxonomies_search($sf_pa_search);
+        else {
+            return $results;
         }
         
-
-        foreach($results_prod as $single_prod){
-            $single_prod->img_url = $this->get_thumb_from_serialize($single_prod->img_url);
-            $single_prod->title = esc_html($single_prod->title);
-            $single_prod->cat_title = esc_html($single_prod->cat_title);
-            $single_prod->link = esc_url($this->build_link($single_prod->type, $single_prod->ID));
-            $this->results[] = $single_prod;
-        }
-
-        foreach($results_cat as $single_cat){
-            $single_cat->name = esc_html($single_cat->name);
-            $single_cat->link = esc_url($this->build_link($single_cat->type, false, $single_cat->taxonomy,$single_cat->slug ));
-            $this->results[] = $single_cat;
-        }
-
-        $this->results = apply_filters('sf_pa_autosuggest_results', $this->results);
-
         
         return $this->results;

sf-autosuggest-product-search/trunk/sf_products_autosuggest.php

@@ -4 +4 @@
 * Plugin URI: https://www.your-site.com/
 * Description: Autosuggest Product Search for Woocommerce
-* Version: 1.2
+* Version: 1.3
 * Author: Simone Fontana
 * Author URI: https://www.simonefontana.net/
+* WC requires at least: 3.0.0
+* WC tested up to: 7.7.0
 **/
 
@@ -58 +60 @@
                 <form method="get" role="search" action="'.get_site_url().'">
                     <input type="search" id="sf_pa_search_input" class="search-field" placeholder="'.esc_attr($placeholder).'" value="" name="s">
+                    <img class="sf_pa_loader" src="'.plugins_url().'/sf_products_autosuggest/assets/img/loading.gif">
                     <input type="submit">
                 </form>