Cursor filter on Price set to Dynamic not getting dynamic max and min values

Hi,

On my end when trying to reproduce the issue, I had a problem with the step being too high, but in any case, I didn't had the issue with the range of the filter not being dynamic.
Could you activate the "debug mode" setting of the Joomla configuration and provide the queries on the table hikashop_product that you can find at the bottom of that page with that setting activated ?

Hi,

It's really strange. I see the MySQL query which loads the min/max dynamically for the price cursor filter, but in the javascript of you page, I see that it is the min/max from the configuration which is used.
It's as if the file "filter" of the view "product" had been changed to discard the dynamic min/max.
Can you edit it via the menu Display>Views and check that you have the line below in that file:

$html[$key]=$this->filterClass->displayFilter($filter, $this->params->get('main_div_name'), $this, $datas);

Hi,

That's indeed a key detail in order to understand the situation.
The "apply on" option uses the value "price" of the choice "Price".
For custom fields, the value used in the column name of the custom field.
So since you entered "price" in the column name of your custom field, the filter actually sees as if you had selected the "Price" choice and thus uses the normal prices of the products and not the data you have in your custom field Price2. That's probably why the filter min/max doesn't match with the available prices of the products on the listing.

I would recommend to change and use another column name for your custom field.

Hi,

I was able to find that this happens because of the way the values are entered in the custom field of some of the products.
I've added a patch to the MySQL query so that whatever way you enter the prices int he custom fields, the min/max will be calculated properly.
I've run some tests on your website and it's working fine now.

Hi,

Well, the problem this time comes from two things:
- you've set a step of 100
- the cursor system of jQuery-ui we're using for the cursor filter doesn't handle properly the max if the number is not equal to a step starting from the min.
Because of that, the cursor system, with a min of 1895 and a max of 3850 would pick 3795 as the max displayed instead of 3850.
An easy way to avoid that is to change the step to 1 in the filter.
We've added a patch to HikaShop so that it checks the modulo of the difference between the min/max and the step so that if it's not 0, it adds the remainder to the max.
That way, in your example, you now have a max of 3895.

We'll add that patch on our end as well as the previous one so you won't have any action to take when you update.

Hi,

Thanks for your feedback. Change the line:

if(!empty($selected) && !empty($selected[0])){

if(!empty($selected) && !empty($selected[0]) && $selected != ' '){