Changeset 2906136

Timestamp:

04/29/2023 04:48:47 PM (3 years ago)

Author:

simonefontana

Message:

Update plugin version 1.2.

Location:

sf-autosuggest-product-search

Files:

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

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

@@ -5 +5 @@
 Requires PHP: 7.0
 Tested up to: 6.2
-Stable tag:1.1
+Stable tag:1.2
 License: GPLv3
 License URI: http://www.gnu.org/licenses/gpl-3.0.txt
@@ -43 +43 @@
 
 =Can I exclude some categories from search suggests?=
-Yes, you can exlude categoies by ID in settings page.
+Yes, you can exlude categories by ID in settings page.
+
+=Can I search for product taxonomies like "Product categories" or "Tags"?=
+Yes, you can search for product taxonomies.
 
 == Screenshots ==
@@ -56 +59 @@
 * Added ability to customize "Show all results" text
 
+= 1.2 =
+* Added search for taxonomies option.
+* Added ability to customize placeholder input
+* Fix bug incorrect permalink
+
 == Upgrade Notice ==

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

@@ -19 +19 @@
                     for (var i = 0; i < response.length; ++i) {
                         var to_append = '<div class="sf_pa_autosuggest_response"><div>';
-                        if(response[i].show_thumbnail == 'on'){
+                        
+                        //Product Image
+                        if(response[i].show_thumbnail == 'on' && response[i].type == 'product'){
                             to_append += '<div><img style="width:50px; height: auto;" src="'+response[i].img_url+'"></div>';
                         }
-                        to_append += '<div><div class="sf_pa_autosuggest_title"><a href="'+response[i].link+'">'+response[i].post_title+'</a>';
-                        if(response[i].show_cat == 'on'){
+                        //Title and Link
+                        to_append += '<div><div class="sf_pa_autosuggest_title"><a href="'+response[i].link+'">'+response[i].title+'</a>';
+                        //Category title
+                        if(response[i].show_cat == 'on' && response[i].type == 'product'){
                             to_append += '<p>'+response[i].cat_title+'</p>';
                         }

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

@@ -50 +50 @@
                             ),
                             array(
+                                'title' => __('Search placeholder', 'sf_products_autosuggest'),
+                                'section' => 'sf_pa_apparance',
+                                'key' => 'input_placeholder',
+                                'input' => 'text_input',
+                                'instruction' => __('Text of input placeholder', 'sf_products_autosuggest')
+                            ),
+                            array(
                                 'title' => __('Text "Show all results"', 'sf_products_autosuggest'),
                                 'section' => 'sf_pa_apparance',
@@ -98 +105 @@
                                 'instruction' => __('Exclude products from search. Insert comma separated id of products. For example "12,20"', 'sf_products_autosuggest')
                             ),
+                            array(
+                                'title' => __('Search for taxonomies', 'sf_products_autosuggest'),
+                                'section' => 'sf_pa_apparance',
+                                'key' => 'taxonomies_search',
+                                'input' => 'taxonomies',
+                                'instruction' => __('Select wich taxonomy want search.', 'sf_products_autosuggest')
+                            )
                         );
     
@@ -114 +128 @@
         if (isset($options[$params['key']]))
             $value = esc_attr( $options[$params['key']]);
+        
         echo "<input id='".$params['section']."_".$params['key']."' name='sf_pa_autosuggest_plugin_options[".$params['key']."]' type='text' value='" .$value. "' />";
+        
         if(isset($params['instruction']) && !empty($params['instruction'])){
             echo '<p class="sf_pa-instruction">'.$params['instruction'].'</p>';
@@ -125 +141 @@
         if (isset($options[$params['key']]))
             $value = esc_attr( $options[$params['key']]);
+        
         echo "<input id='".$params['section']."_".$params['key']."' class='sf_pa_color_picker' name='sf_pa_autosuggest_plugin_options[".$params['key']."]' type='text' value='" .$value. "' />";
+        
         if(isset($params['instruction']) && !empty($params['instruction'])){
             echo '<p class="sf_pa-instruction">'.$params['instruction'].'</p>';
@@ -136 +154 @@
         if (isset($options[$params['key']]) && $options[$params['key']] =='on')
             $value = 'checked';
+        
         echo "<input id='".$params['section']."_".$params['key']."' name='sf_pa_autosuggest_plugin_options[".$params['key']."]' type='checkbox' $value />";
         
@@ -142 +161 @@
         }
     
+    }
+
+    public function taxonomies($params){
+        /*TODO: multple choice*/
+        $options = get_option( 'sf_pa_autosuggest_plugin_options' );
+        $value = '';
+        $tax_to_not_use = array('product_type', 'product_visibility', 'product_shipping_class');
+
+        $taxonomies = get_object_taxonomies('product','objects');
+        $html = '<select name="sf_pa_autosuggest_plugin_options['.$params["key"].'][]" multiple="multiple">
+                    <option value="">-- None --</option>';
+        foreach($taxonomies as $taxonomy){
+            if(!in_array($taxonomy->name, $tax_to_not_use)){
+                $selected = '';
+                if(isset($options[$params['key']]) && in_array($taxonomy->name, $options[$params['key']])){
+                    $selected = 'selected';
+                }
+                $html .= '<option value="'.$taxonomy->name.'" '.$selected.'>'.$taxonomy->label.'</option>';
+            }
+        }
+
+        $html .= '</select>';
+        echo $html;
     }
     
@@ -147 +189 @@
         $validator = new SfWAValidator;
         $newinput['results_count'] = $validator->int($input['results_count'], 6);
+        $newinput['input_placeholder'] = $validator->plaintext($input['input_placeholder']);
         $newinput['all_text'] =  $validator->plaintext($input['all_text']);
         $newinput['all_bg'] =  $validator->hexadecimal($input['all_bg'], '#000');
@@ -154 +197 @@
         $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);
+        }
+        
     
         return $newinput;

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

@@ -8 +8 @@
         $this->count = 6;
         $this->content_url = $content_url['baseurl'];
-        $this->products = array();
+        $this->results = array();
     }
 
@@ -26 +26 @@
         }
 
-        $sql = "SELECT ".$wpdb->prefix."posts.post_title, ".$wpdb->prefix."posts.guid as link, img_postmeta.meta_value as img_url,  ".$wpdb->prefix."terms.name as cat_title, %s as show_cat, %s as show_thumbnail  FROM ".$wpdb->prefix."posts
+        $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'
@@ -49 +50 @@
         
         $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->post_title =  esc_html($single_prod->post_title);
+            $single_prod->title = esc_html($single_prod->title);
             $single_prod->cat_title = esc_html($single_prod->cat_title);
-            $single_prod->link = esc_url($single_prod->link);
-            $this->products[] = $single_prod;
+            $single_prod->link = esc_url($this->build_link($single_prod->type, $single_prod->ID));
+            $this->results[] = $single_prod;
         }
-        $this->products = apply_filters('sf_pa_autosuggest_results', $this->products);
-        return $this->products;
+
+        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;
     }
 
@@ -76 +93 @@
         return '';
     }
+
+    private function get_taxonomies_search($sf_pa_search){
+        global $wpdb;
+        $prepare = $this->options['taxonomies_search'];
+        $prepare[] = '%' . $wpdb->esc_like($sf_pa_search) .'%';
+        $sql = "SELECT ".$wpdb->prefix."terms.name as title, ".$wpdb->prefix."terms.slug, ".$wpdb->prefix."term_taxonomy.taxonomy, 'taxonomy' AS type FROM ".$wpdb->prefix."terms
+                INNER JOIN ".$wpdb->prefix."term_taxonomy ON ".$wpdb->prefix."terms.term_id =  ".$wpdb->prefix."term_taxonomy.term_id
+                WHERE ".$wpdb->prefix."term_taxonomy.taxonomy IN (".implode(', ', array_fill(0, count($this->options['taxonomies_search']), '%s')).") AND ".$wpdb->prefix."terms.name LIKE %s AND ".$wpdb->prefix."term_taxonomy.count > 0";
+        $results_cat = $wpdb->get_results($wpdb->prepare($sql, $prepare));
+        return $results_cat;
+    }
+
+    private function build_link($type, $id, $taxonomy = false, $slug = false){
+        if($type == 'product'){
+            return get_site_url().'?p='.$id;
+        }
+        elseif('taxonomy'){
+            return get_site_url().'?taxonomy='.$taxonomy.'&term='.$slug;
+        }
+    }
 }

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.1
+* Version: 1.2
 * Author: Simone Fontana
 * Author URI: https://www.simonefontana.net/
@@ -44 +44 @@
     $all_bg = '#000';
     $all_color = '#fff';
+    $placeholder = 'Search products..';
     if(isset($options['all_bg']) && !empty($options['all_bg'])){
         $all_bg = $options['all_bg'];
@@ -50 +51 @@
         $all_color = $options['all_color'];
     }
+    if(isset($options['input_placeholder']) && !empty($options['input_placeholder'])){
+        $placeholder = $options['input_placeholder'];
+    }
     
     $html = '<div class="sf_pa_search_input_container">
                 <form method="get" role="search" action="'.get_site_url().'">
-                    <input type="search" id="sf_pa_search_input" class="search-field" placeholder="Search products.." value="" name="s">
+                    <input type="search" id="sf_pa_search_input" class="search-field" placeholder="'.esc_attr($placeholder).'" value="" name="s">
                     <input type="submit">
                 </form>