Advanced AJAX Product Filters - Version 1.5.4.4

Version Description

  • Fix - Price slider with older MySQL
Download this release

Release Info

Developer RazyRx
Plugin Icon wp plugin Advanced AJAX Product Filters
Version 1.5.4.4
Comparing to
See all releases

Code changes from version 1.5.4.3 to 1.5.4.4

Files changed (3) hide show
  1. includes/widget_functions.php +4 -4
  2. readme.txt +4 -1
  3. woocommerce-filters.php +2 -2
includes/widget_functions.php CHANGED
@@ -680,15 +680,15 @@ class BeRocket_AAPF_Widget_functions {
680
 
681
  if( br_woocommerce_version_check('3.6') ) {
682
  $query[ 'select' ] = "SELECT MIN(cast(FLOOR(wc_product_meta_lookup.min_price) as decimal)) as min_price,
683
- MIN(cast(wc_product_meta_lookup.min_price as float)) as min_float,
684
- MAX(cast(wc_product_meta_lookup.max_price as float)) as max_float,
685
  MAX(cast(CEIL(wc_product_meta_lookup.max_price) as decimal)) as max_price ";
686
  $query[ 'from' ] = "FROM {$wpdb->posts}";
687
  $query[ 'join' ] = " INNER JOIN {$wpdb->wc_product_meta_lookup} as wc_product_meta_lookup ON $wpdb->posts.ID = wc_product_meta_lookup.product_id ";
688
  } else {
689
  $query[ 'select' ] = "SELECT MIN(cast(FLOOR(wp_price_check.meta_value) as decimal)) as min_price,
690
- MIN(cast(wp_price_check.meta_value as float)) as min_float,
691
- MAX(cast(wp_price_check.meta_value as float)) as max_float,
692
  MAX(cast(CEIL(wp_price_check.meta_value) as decimal)) as max_price ";
693
  $query[ 'from' ] = "FROM {$wpdb->postmeta} as wp_price_check";
694
  $query[ 'join' ] = "INNER JOIN {$wpdb->posts} ON ({$wpdb->posts}.ID = wp_price_check.post_id)";
680
 
681
  if( br_woocommerce_version_check('3.6') ) {
682
  $query[ 'select' ] = "SELECT MIN(cast(FLOOR(wc_product_meta_lookup.min_price) as decimal)) as min_price,
683
+ MIN(wc_product_meta_lookup.min_price) as min_float,
684
+ MAX(wc_product_meta_lookup.max_price) as max_float,
685
  MAX(cast(CEIL(wc_product_meta_lookup.max_price) as decimal)) as max_price ";
686
  $query[ 'from' ] = "FROM {$wpdb->posts}";
687
  $query[ 'join' ] = " INNER JOIN {$wpdb->wc_product_meta_lookup} as wc_product_meta_lookup ON $wpdb->posts.ID = wc_product_meta_lookup.product_id ";
688
  } else {
689
  $query[ 'select' ] = "SELECT MIN(cast(FLOOR(wp_price_check.meta_value) as decimal)) as min_price,
690
+ MIN(cast(wp_price_check.meta_value as decimal(20,4))) as min_float,
691
+ MAX(cast(wp_price_check.meta_value as decimal(20,4))) as max_float,
692
  MAX(cast(CEIL(wp_price_check.meta_value) as decimal)) as max_price ";
693
  $query[ 'from' ] = "FROM {$wpdb->postmeta} as wp_price_check";
694
  $query[ 'join' ] = "INNER JOIN {$wpdb->posts} ON ({$wpdb->posts}.ID = wp_price_check.post_id)";
readme.txt CHANGED
@@ -5,7 +5,7 @@ Donate link: https://berocket.com/product/woocommerce-ajax-products-filter?utm_s
5
  Tags: filters, product filters, ajax product filters, ajax filter, ajax filter widget, color filter, size filter, product onsale filter, product preview, product category filter, product reset filter, product sort by filter, stock filter, product tag filter, price range filter, price box filter, advanced product filters, woocommerce filters, woocommerce product filters, woocommerce products filter, woocommerce ajax product filters, widget, plugin, woocommerce item filters, filters plugin, ajax filters plugin, filter woocommerce products, filter woocommerce products plugin, wc filters, wc filters products, wc products filters, wc ajax products filters, wc product filters, wc advanced product filters, woocommerce layered nav, woocommerce layered navigation, ajax filtered nav, ajax filtered navigation, price filter, ajax price filter, woocommerce product sorting, sidebar filter, sidebar ajax filter, taxonomy filter, category filter, attribute filter, attributes filter, woocommerce product sort, ajax products filter plugin for woocommerce, rocket, berocket, berocket woocommerce ajax products filter
6
  Requires at least: 5.0
7
  Tested up to: 5.7
8
- Stable tag: 1.5.4.3
9
  License: GPLv2 or later
10
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
 
@@ -185,6 +185,9 @@ You can try this plugin's admin side [here](https://berocket.com/product/woocomm
185
 
186
  == Changelog ==
187
 
 
 
 
188
  = 1.5.4.3 =
189
  * Enhancement - Compatibility version: WooCommerce 5.3
190
  * Fix - Price slider with decimal product price
5
  Tags: filters, product filters, ajax product filters, ajax filter, ajax filter widget, color filter, size filter, product onsale filter, product preview, product category filter, product reset filter, product sort by filter, stock filter, product tag filter, price range filter, price box filter, advanced product filters, woocommerce filters, woocommerce product filters, woocommerce products filter, woocommerce ajax product filters, widget, plugin, woocommerce item filters, filters plugin, ajax filters plugin, filter woocommerce products, filter woocommerce products plugin, wc filters, wc filters products, wc products filters, wc ajax products filters, wc product filters, wc advanced product filters, woocommerce layered nav, woocommerce layered navigation, ajax filtered nav, ajax filtered navigation, price filter, ajax price filter, woocommerce product sorting, sidebar filter, sidebar ajax filter, taxonomy filter, category filter, attribute filter, attributes filter, woocommerce product sort, ajax products filter plugin for woocommerce, rocket, berocket, berocket woocommerce ajax products filter
6
  Requires at least: 5.0
7
  Tested up to: 5.7
8
+ Stable tag: 1.5.4.4
9
  License: GPLv2 or later
10
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
 
185
 
186
  == Changelog ==
187
 
188
+ = 1.5.4.4 =
189
+ * Fix - Price slider with older MySQL
190
+
191
  = 1.5.4.3 =
192
  * Enhancement - Compatibility version: WooCommerce 5.3
193
  * Fix - Price slider with decimal product price
woocommerce-filters.php CHANGED
@@ -3,7 +3,7 @@
3
  * Plugin Name: Advanced AJAX Product Filters for WooCommerce
4
  * Plugin URI: https://wordpress.org/plugins/woocommerce-ajax-filters/?utm_source=free_plugin&utm_medium=plugins&utm_campaign=ajax_filters
5
  * Description: Unlimited AJAX products filters to make your shop perfect
6
- * Version: 1.5.4.3
7
  * Author: BeRocket
8
  * Requires at least: 5.0
9
  * Author URI: https://berocket.com?utm_source=free_plugin&utm_medium=plugins&utm_campaign=ajax_filters
@@ -11,6 +11,6 @@
11
  * Domain Path: /languages/
12
  * WC tested up to: 5.3
13
  */
14
- define( "BeRocket_AJAX_filters_version", '1.5.4.3' );
15
  define( "BeRocket_AJAX_filters_file", __FILE__ );
16
  include_once('main.php');
3
  * Plugin Name: Advanced AJAX Product Filters for WooCommerce
4
  * Plugin URI: https://wordpress.org/plugins/woocommerce-ajax-filters/?utm_source=free_plugin&utm_medium=plugins&utm_campaign=ajax_filters
5
  * Description: Unlimited AJAX products filters to make your shop perfect
6
+ * Version: 1.5.4.4
7
  * Author: BeRocket
8
  * Requires at least: 5.0
9
  * Author URI: https://berocket.com?utm_source=free_plugin&utm_medium=plugins&utm_campaign=ajax_filters
11
  * Domain Path: /languages/
12
  * WC tested up to: 5.3
13
  */
14
+ define( "BeRocket_AJAX_filters_version", '1.5.4.4' );
15
  define( "BeRocket_AJAX_filters_file", __FILE__ );
16
  include_once('main.php');