Dynamic Filter [Support Thread]

Printable View

Show 100 post(s) from this thread on one page

29 Jun 2015, 03:57 AM
Design75

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by WWWD

I am running 1.5.4

This line

PHP Code:

// bof dynamic filter 1 of 2 include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_DYNAMIC_FILTER)); // eof dynamic filter 1 of 2

Produces this error:
[27-Jun-2015 00:04:34 EST5EDT] [client 64.7.70.206 ] PHP Fatal error: Call to undefined function zen_get_module_directory() in /big/dom/xscholledresses/www/includes/classes/split_page_results.php on line 28

What is wrong?

what version of the module are you running?
4 Jul 2015, 07:33 PM
solo_400

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by solo_400

I'm using 1.1 version of this module and ZC 1.5.0. I have also the price range issue like 18-98, 98-178, 178-278. Can you give me some hint how to get ranges like 0-100, 100-200, 200-300 ?

thx!

Did someone solve this issue ?
12 Jul 2015, 03:24 AM
AllanMarcus

Re: 1.5.3 Support

Any chance of a 1.5.4 compatible version?
12 Jul 2015, 05:59 AM
AllanMarcus

Re: 1.5.3 Support

I apologize for being dense, but I cannot get past how to install the plugin. I've installed ZC 1.5.1 and got it working. The instruction for installing Dynamic Filter are to:

Code:

New Files Copy the includes folder from the 'new files' folder into your store's main directory. The files are already in the correct directory structure, so a single drag-and-drop of the folder into the root directory for the store will put the files in the correct locations. Please do not copy the files individually - doing so often results in files being missed out!

This makes no sense to me. If I drop the includes file into the root of the my catalog dir, it will overwrite the existing includes file. Wont that destroy my who catalog? Seems like I have to do exactly what the instructions say not to do; copy each file individually.

Please advise.
12 Jul 2015, 06:13 AM
AllanMarcus

Sorry, more install issues...

I decided to copy in the files manually. The instructions say to copy the following files:

Code:

includes/modules/pages/advanced_search_result/jscript_dynamic_filter.php includes/modules/pages/featured_products/jscript_dynamic_filter.php includes/modules/pages/index/jscript_dynamic_filter.php includes/modules/pages/products_all/jscript_dynamic_filter.php includes/modules/pages/products_new/jscript_dynamic_filter.php includes/modules/pages/specials/jscript_dynamic_filter.php

Bu these are not in the distribution. Are they no longer needed and the Docs just not updated?
12 Jul 2015, 03:08 PM
lat9

Re: 1.5.3 Support

Quote:

Originally Posted by AllanMarcus

I apologize for being dense, but I cannot get past how to install the plugin. I've installed ZC 1.5.1 and got it working. The instruction for installing Dynamic Filter are to:

Code:

New Files Copy the includes folder from the 'new files' folder into your store's main directory. The files are already in the correct directory structure, so a single drag-and-drop of the folder into the root directory for the store will put the files in the correct locations. Please do not copy the files individually - doing so often results in files being missed out!

This makes no sense to me. If I drop the includes file into the root of the my catalog dir, it will overwrite the existing includes file. Wont that destroy my who catalog? Seems like I have to do exactly what the instructions say not to do; copy each file individually.

Please advise.

When you drag&drop the includes folder from the plugin into your store, that copy operation adds files present in the plugin's includes folder into your existing includes folder. No existing files are deleted (although files of the same name will be replaced, usually with some overwrite verification).
12 Jul 2015, 11:59 PM
kwright

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by chief

here is a link to my amended "dynamic filter" which works with 1.5.4
http://www.tlsystems.co.uk/support/Z....2-amended.zip

I have added a folder 1.5.4 to main archive, just follow instructions for previous versions.
take a backup of any files your going to overwrite.
rename the admin folder to yours
rename the YOUR_TEMPLATE folders to your template name
upload files
import sql
and it should work.
mine does, one thing to do is add a admin menu feature to show filter including tax "yes/no".

Thanks chief,

Just saw your post! Much appreciated. Will install with new ZC154 and test. :D
15 Jul 2015, 05:44 PM
kwright

Re: Dynamic Filter [Support Thread]

Greetings,

Just installed chief's version for 1.5.4.

Question: I am only interested at this time in having the Dynamic Filter sidebox function on the product listing page (main_page=index). Do I still need to install the files in the includes\modules\pages? These seem to be for the search, featured, all, new and specials pages...

Thanks! :D
15 Jul 2015, 06:22 PM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by kwright

Greetings,

Just installed chief's version for 1.5.4.

Question: I am only interested at this time in having the Dynamic Filter sidebox function on the product listing page (main_page=index). Do I still need to install the files in the includes\modules\pages? These seem to be for the search, featured, all, new and specials pages...

Thanks! :D

No, you do not need them if you only want to use the filtering on the products listing.
16 Jul 2015, 12:32 AM
kwright

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by Design75

No, you do not need them if you only want to use the filtering on the products listing.

Thanks Design75,

I have installed, except for those files. Filter sidebox displays with the correct filters and seem to be working!
21 Jul 2015, 02:45 PM
simon1066

Re: Dynamic Filter - filter does not work on product listing

Quote:

Originally Posted by Design75

Sorry to tell you, but currently the one column feature is not yet supported by this module. It is on my (very long) to do list, but I really can't promise any time frame. I you are haing some spare time, feel free to help with this module, and I'll add your code to it.

I've managed to get this mod to play happily with some responsive templates (stirling grand and westminster new) by using javascript to toggle the dynamicfilterContent on smaller responsive displays (I'm using max-width:767px).

Is this something you've got planned for the next release? If not, and you think it's worth it, would it help if I package it up and send it you for including in the mod?
21 Jul 2015, 02:54 PM
kwright

Re: Dynamic Filter - filter does not work on product listing

Quote:

Originally Posted by simon1066

I've managed to get this mod to play happily with some responsive templates (stirling grand and westminster new) by using javascript to toggle the dynamicfilterContent on smaller responsive displays (I'm using max-width:767px).

Is this something you've got planned for the next release? If not, and you think it's worth it, would it help if I package it up and send it you for including in the mod?

Greetings simon1066,

I would be interested in your mods for the westminster new template!

BTW, would you know how to only show the dynamic filter sidebox if there are products with attributes in a given category? It seems to display regardless and when there are no filters to list in the sidebox, it breaks the template layout!

Thanks!:D
21 Jul 2015, 03:01 PM
simon1066

Re: Dynamic Filter - filter does not work on product listing

Quote:

Originally Posted by kwright

Greetings simon1066,

I would be interested in your mods for the westminster new template!

BTW, would you know how to only show the dynamic filter sidebox if there are products with attributes in a given category? It seems to display regardless and when there are no filters to list in the sidebox, it breaks the template layout!

Thanks!:D

Hi, what I can do is to deactivate the sidebox for a given category - is that what you are looking for?
I found it useful for document_general product category types - my template broke aswell!
21 Jul 2015, 03:45 PM
kwright

Re: Dynamic Filter - filter does not work on product listing

Quote:

Originally Posted by simon1066

Hi, what I can do is to deactivate the sidebox for a given category - is that what you are looking for?
I found it useful for document_general product category types - my template broke aswell!

Yes, but only for the categories that have products with no attributes! It seems that the default function of the dynamic filter sidebox is to always show in categories with products regardless if they have attributes or not (shows empty sidebox with heading text).

I guess one would need to test if a given category has products with attributes and show the filter sidebox if true. Just don't know where or how to do this? Any suggestions? I'm sure others would like this feature as well!
21 Jul 2015, 04:04 PM
simon1066

Re: Dynamic Filter - filter does not work on product listing

Yes, I see what you mean, it would need a test to see if attributes are present. No doubt there's one hidden in the Zencart code somewhere. If you find it (or if you actually know the category that has no attributes) you can use this code to show/hide the sidebox for an 'if' statement

Replace the contents of includes/modules/sideboxes/YOUR_TEMPLATE/dynamic_filter.php with:

PHP Code:

<?php /** * dynamic_filter.php * *Zen Cart dynamic filter module *Damian Taylor, March 2010 * */ if(FILTER_CATEGORY == 'Yes' && $current_page_base == 'index' && !$this_is_home_page && ($category_depth == 'products' || $category_depth == 'top') || FILTER_ALL == 'Yes' && $current_page_base == 'products_all' || FILTER_NEW == 'Yes' && $current_page_base == 'products_new' || FILTER_FEATURED == 'Yes' && $current_page_base == 'featured_products' || FILTER_SPECIALS == 'Yes' && $current_page_base == 'specials' || FILTER_SEARCH == 'Yes' && $current_page_base == 'advanced_search_result'){$show_dynamic_filter = true; } if ($cPath == '14'){ $show_dynamic_filter = false;} if ($cPath == '6'){ $show_dynamic_filter = false;} if ($show_dynamic_filter == true) { require($template->get_template_dir('tpl_dynamic_filter.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_dynamic_filter.php'); $title = BOX_HEADING_FILTER; $title_link = false; require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default); } ?>

You can either change the [if ($cPath == '??')] value to your category or replace that code with the magical attribute test we've yet to find.
21 Jul 2015, 04:19 PM
kwright

Re: Dynamic Filter - filter does not work on product listing

Quote:

Originally Posted by simon1066

Yes, I see what you mean, it would need a test to see if attributes are present. No doubt there's one hidden in the Zencart code somewhere. If you find it (or if you actually know the category that has no attributes) you can use this code to show/hide the sidebox for an 'if' statement

Replace the contents of includes/modules/sideboxes/YOUR_TEMPLATE/dynamic_filter.php with:

PHP Code:

<?php /** * dynamic_filter.php * *Zen Cart dynamic filter module *Damian Taylor, March 2010 * */ if(FILTER_CATEGORY == 'Yes' && $current_page_base == 'index' && !$this_is_home_page && ($category_depth == 'products' || $category_depth == 'top') || FILTER_ALL == 'Yes' && $current_page_base == 'products_all' || FILTER_NEW == 'Yes' && $current_page_base == 'products_new' || FILTER_FEATURED == 'Yes' && $current_page_base == 'featured_products' || FILTER_SPECIALS == 'Yes' && $current_page_base == 'specials' || FILTER_SEARCH == 'Yes' && $current_page_base == 'advanced_search_result'){$show_dynamic_filter = true; } if ($cPath == '14'){ $show_dynamic_filter = false;} if ($cPath == '6'){ $show_dynamic_filter = false;} if ($show_dynamic_filter == true) { require($template->get_template_dir('tpl_dynamic_filter.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_dynamic_filter.php'); $title = BOX_HEADING_FILTER; $title_link = false; require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default); } ?>

You can either change the [if ($cPath == '??')] value to your category or replace that code with the magical attribute test we've yet to find.

OK, I see now. Most likely would want to test since I have several categories that currently don't have any attributes, but may in the future. Also, by testing, would make the dynamic filter more universal for others. May be add an admin switch to not show sidebox when products with no attributes in a category exist.

I'll work on this to see what I can come up with. Also, still interested in your responsive mods if you have them available!

Thanks,
kwright
21 Jul 2015, 04:26 PM
simon1066

Re: Dynamic Filter - filter does not work on product listing

Sounds good, adding an admin switch might be a bit beyond me though.

I'll put together a quick and dirty post on the responsive layout. I have found that there might still be a bit of work to finalise it - mainly that the filter collapses once an attribute is selected and it needs to be opened again to select another, you'll see what I mean though. I'll do it now and post shortly.
21 Jul 2015, 05:02 PM
simon1066

1 Attachment(s)

Re: Dynamic Filter - filter does not work on product listing

Responsive template mods - this should put an expandable 'filter button' at the top of the product listing page on displays less than 767px width.

---------------------------------------
in includes/templates/YOUR_TEMPLATE/sideboxes/tpl_dynamic_filter.php

replace:

PHP Code:

// draw filter form $content = ''; $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">'; $content .= zen_draw_form('product_filter_form','', 'get');

with:

PHP Code:

// draw filter form $content = ''; $content .= '<div id="filterToggle"><a href="javascript:;" onclick="toggle_visibility(\'dynamicfilterContent\');">' . zen_image_button(BUTTON_IMAGE_TOGGLE_FILTER, BUTTON_TOGGLE_FILTER_ALT, 'class="listingBuyNowButton"') . '</a></div>'; $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">'; $content .= zen_draw_form('product_filter_form','', 'get');

----------------------------------------

in your responsive.css or responsive_default.css file (depending on the template used) add under the @media (max-width:767px) section add:

Code:

#dynamicfilter { display: block;visibility: visible;} #dynamicfilterContent{display:none;} #filterToggle {display: block;margin: 18px 0 0;} #dynamicfilterHeading {display: none;}

in stylesheet.css add:

Code:

#filterToggle {display:none;}

----------------------------------------

in includes/languages/english/YOUR_TEMPLATE/button_names.php add:

PHP Code:

define('BUTTON_IMAGE_TOGGLE_FILTER', 'buttonimage.gif'); define('BUTTON_TOGGLE_FILTER_ALT', 'Filter results');

BUTTON_TOGGLE_FILTER_ALT as well as being the image alt tag is also used for the css button text.
BUTTON_IMAGE_TOGGLE_FILTER is an image file of the button if using images, if using css buttons this is not required but should be left blank like:

Code:

define('BUTTON_IMAGE_TOGGLE_FILTER', '');

---------------------------------------

in /includes/modules/pages/index add the attached jscript_toggle.js

Attachment 15441

----------------------------------------

and that's it.

Quote:

Originally Posted by simon1066

... I have found that there might still be a bit of work to finalise it - mainly that the filter collapses once an attribute is selected and it needs to be opened again to select another, you'll see what I mean though.

Now I come to think about it might be acceptable or even desirable for the filter box to collapse on page refresh especially on small screens. It would be good to know what others think.
21 Jul 2015, 09:55 PM
kwright

Re: Dynamic Filter - filter does not work on product listing

Thanks simon1066 for your help and mods!:clap:
30 Jul 2015, 02:56 AM
kwright

Re: Dynamic Filter - Narrow Results By In Stock Products

Greetings,

Thinking it would be a good feature, I would like to add an additional "Narrow Results By Products In Stock" feature to the sidebox. Looking through the tpl_dynamic_filter.php file, I'm a bit confused as to where and how I would add this?

Code suggestions?

Thanks
30 Jul 2015, 02:57 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by kwright

Greetings,

Thinking it would be a good feature, I would like to add an additional "Narrow Results By Products In Stock" feature to the sidebox. Looking through the tpl_dynamic_filter.php file, I'm a bit confused as to where and how I would add this?

Code suggestions?

Thanks

I am not sure I understand what you need.
30 Jul 2015, 06:25 PM
kwright

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Design75

I am not sure I understand what you need.

Hi Design75,

In our store, when a product is out of stock, it will show an Out of Stock button.

Our customers are not always interested in what is out of stock, just what is in stock. So, in our advanced search form, I have added a checkbox (Only Show In Stock Products) to limit results based on products that are in stock.

I would like to replace this with a similar function within the Dynamic Filters sidebox.

Thanks and I hope that clarifies! :D
30 Jul 2015, 06:29 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by kwright

Hi Design75,

In our store, when a product is out of stock, it will show an Out of Stock button.

Our customers are not always interested in what is out of stock, just what is in stock. So, in our advanced search form, I have added a checkbox (Only Show In Stock Products) to limit results based on products that are in stock.

I would like to replace this with a similar function within the Dynamic Filters sidebox.

Thanks and I hope that clarifies! :D

Understood, I'll will give it a try, but I am not near my computer until Monday.
30 Jul 2015, 06:58 PM
kwright

Re: Dynamic Filter - Narrow Results By In Stock Products

Much appreciated Design75! If you do give it a go, I may not be available to test until the following Sunday, August 2nd.

Thanks again!
2 Aug 2015, 07:23 PM
JvRossem

Re: Dynamic Filter - Narrow Results By In Stock Products

Hello,

I just installed this module on my zencart 1.5.4. It don't work how it supposed to be yet.
De Filter itself shows ok on the left colum. Only when a filter get selected it wont apply the filter. All products just displays as before the filter.
The same goes for the Price filter.

Only when a filter has only 1 product the filters directs directly to this product (like it should be).

I dont have a clue how to cerrect this problem and hope someone can help me.

I got on my logs this error:

PHP Code:

[02-Aug-2015 20:14:40 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 473
3 Aug 2015, 01:46 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by JvRossem

Hello,

I just installed this module on my zencart 1.5.4. It don't work how it supposed to be yet.
De Filter itself shows ok on the left colum. Only when a filter get selected it wont apply the filter. All products just displays as before the filter.
The same goes for the Price filter.

Only when a filter has only 1 product the filters directs directly to this product (like it should be).

I dont have a clue how to cerrect this problem and hope someone can help me.

I got on my logs this error:

PHP Code:

[02-Aug-2015 20:14:40 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 438[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 439[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 453[02-Aug-2015 20:14:41 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 473

I do not know the answer, but when I go to your site I get a white page.
Did you copy/merge all the files?
3 Aug 2015, 03:33 PM
JvRossem

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Design75

I do not know the answer, but when I go to your site I get a white page.
Did you copy/merge all the files?

I did merge all the files. The white page was i litle mistake on my site:). The page should be up again now.

I think the problem is related to ultimate seo urls module. Because when a filter is applayed i see in the url only =Array, instead of the filter.

At the moment i have the filter only showing up in 3 categories. I dont need it on the other categorys since they dont have attributes, end this mod brakes the page when there are no attributes.

So it seems like the module is filtering the producte, but seo change the urls wrong. Any idea how to fix this?
3 Aug 2015, 03:44 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by JvRossem

I did merge all the files. The white page was i litle mistake on my site:). The page should be up again now.

I think the problem is related to ultimate seo urls module. Because when a filter is applayed i see in the url only =Array, instead of the filter.

At the moment i have the filter only showing up in 3 categories. I dont need it on the other categorys since they dont have attributes, end this mod brakes the page when there are no attributes.

So it seems like the module is filtering the producte, but seo change the urls wrong. Any idea how to fix this?

Not at the moment, I do not use ultimate seo urls.
3 Aug 2015, 04:24 PM
JvRossem

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Design75

Not at the moment, I do not use ultimate seo urls.

I just tested without seo urls, still same result. So i gues its not the problem.
If u look at the error code it seems he can't find the right parameter:

PHP Code:

[03-Aug-2015 17:18:16 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[03-Aug-2015 17:18:16 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 240[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 241[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 245[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 245[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 325

This is a fraction from the error code, the list and lines goes on.

This is the page with the filter: http://www.restyleparts.com/18-inch-c-10_5834_5836/
3 Aug 2015, 05:02 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by JvRossem

I just tested without seo urls, still same result. So i gues its not the problem.
If u look at the error code it seems he can't find the right parameter:

PHP Code:

[03-Aug-2015 17:18:16 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[03-Aug-2015 17:18:16 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/modules/edify/dynamic_filter.php on line 16[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 240[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: array_filter() expects parameter 1 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 241[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 245[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 245[03-Aug-2015 17:18:17 Europe/Amsterdam] PHP Warning: in_array() expects parameter 2 to be array, string given in /home/shopuu3331/domains/restyleparts.com/public_html/includes/templates/edify/sideboxes/tpl_dynamic_filter.php on line 325

This is a fraction from the error code, the list and lines goes on.

This is the page with the filter: http://www.restyleparts.com/18-inch-c-10_5834_5836/

Does it also happen when you use other filter styles? like checkbox?
This is very hard to debug without seeing the actual files.
If you are okay with it I could take a look at your files through ftp, if so send me a pm.
12 Aug 2015, 04:02 PM
kwright

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Design75

Understood, I'll will give it a try, but I am not near my computer until Monday.

Good day Design75,

I'm back in town. Just wondering if you had a chance to look at adding a filter by In Stock items feature?

Thanks :D
15 Aug 2015, 03:28 PM
raj_ics

Re: Dynamic Filter - Narrow Results By In Stock Products

I have tried installing this plugin on a Zen Cart version 1.5.4
Have followed all the instructions in the documentation when setting it up. I was using Ultimate SEO URL's, so disabled it.
Still cannot get this to work. Any suggestions?
http://dev.vincoshooters.com/index.p...&cPath=442_737

Thank You
27 Aug 2015, 05:05 PM
raj_ics

Re: Dynamic Filter - Narrow Results By In Stock Products

This the SQL query I ran to get the products filter to work.

Update `products` set `products_price_sorter` = `products_price` WHERE 1
9 Sep 2015, 09:38 PM
Mikey D

Re: Dynamic Filter - Narrow Results By In Stock Products

Heeeeyyyy!
So I got it installed and working with only a few hiccups. One being the SQL install code not taking into consideration extra columns in my database. I had to add "NULL" to the end of each insert to get it in there and add the "zen_" prefix to the table names. Then using the git hub version of the plugin, it installed correctly and it didn't do that thing where it messes up the CSS in categories with no attributes.
But now I'm running into a funny bug.
You can see it yourself on this page: http://www.firstcallautosupply.com/f...ead-cap-screws

Let's say you try sorting it by bolt width #6. It looks great!
But try sorting it by bolt width 1/4", and you get no results.:huh:
What's weird is that this seems to only be a problem with the standard bolts, which obviously isn't the bolts fault.
Playing around with it just now, I think it's having a problem with the quotation mark. That seems to be the only constant when it's not showing results.
Could someone help me with a fix for this?
9 Sep 2015, 11:41 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Mikey D

Heeeeyyyy!
So I got it installed and working with only a few hiccups. One being the SQL install code not taking into consideration extra columns in my database. I had to add "NULL" to the end of each insert to get it in there and add the "zen_" prefix to the table names. Then using the git hub version of the plugin, it installed correctly and it didn't do that thing where it messes up the CSS in categories with no attributes.
But now I'm running into a funny bug.
You can see it yourself on this page: http://www.firstcallautosupply.com/f...ead-cap-screws

Let's say you try sorting it by bolt width #6. It looks great!
But try sorting it by bolt width 1/4", and you get no results.:huh:
What's weird is that this seems to only be a problem with the standard bolts, which obviously isn't the bolts fault.
Playing around with it just now, I think it's having a problem with the quotation mark. That seems to be the only constant when it's not showing results.
Could someone help me with a fix for this?

Interesting :wacko: It indeed looks like it has something to do with the quotation marks. I will give it a try tomorrow on my test site.
10 Sep 2015, 11:26 AM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Design75

Interesting :wacko: It indeed looks like it has something to do with the quotation marks. I will give it a try tomorrow on my test site.

I tried on my test site this morning and all works as supposed.
I added an option value to one of the products wit a value of 4" , and when I filter on that value, 2 products(which i gave the attribute) show up.
After that I added a 1/4" attribute, and that where it get interesting, because all the attribute counts show up as 1, although the filtering still work as it should be. I will need to investigate this further.
12 Sep 2015, 03:47 PM
Justrimless

Re: Dynamic Filter - Narrow Results By In Stock Products

This is working great except for one peculiarity.

Since installing it I can filter fine on existing attributes, however if I add new ones, and try to filter, the option is visible and the product count is correct but selecting the option returns no results?

Any idea why this might be the case? I suppose I could install it again but would rather not in case i've tweaked any files since.
14 Sep 2015, 06:13 PM
Justrimless

Re: Dynamic Filter - Narrow Results By In Stock Products

And is there a way to prevent read only attributes from showing up?
14 Sep 2015, 06:51 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Justrimless

And is there a way to prevent read only attributes from showing up?

Yes there is. And a similar thing was already in a test version for "text" and "file" types

locate includes/modules/sideboxes/YOUR_TEMPLATE/dynamic_filter.php and find the lines

PHP Code:

    $attributes = $db->Execute("SELECT count(DISTINCT p2a.products_id) AS quantity, po.products_options_name, pov.products_options_values_name,                                 SUM(IF(p2a.products_id IN(" . implode(',', $filteredProducts) . "), 1, 0)) AS flag                                 FROM " . TABLE_PRODUCTS_ATTRIBUTES . " p2a                                 JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON p2a.options_id = po.products_options_id                                 AND po.language_id=" . (int)$_SESSION['languages_id'] . "                                 JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON p2a.options_values_id = pov.products_options_values_id                                 AND pov.language_id=" . (int)$_SESSION['languages_id'] .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as ON p2a.products_id = p2as.products_id                                   AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%')" : "") . "                                 WHERE p2a.products_id IN (" . implode(',', $unfilteredProducts) . ")" .                                 (FILTER_OPTIONS_INCLUDE != '' ? " AND p2a.options_id IN (" . FILTER_OPTIONS_INCLUDE . ")" : '') .                                 (FILTER_OPTIONS_EXCLUDE != '' ? " AND p2a.options_id NOT IN (" . FILTER_OPTIONS_EXCLUDE . ")" : '') .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   AND p2as.quantity > 0" : "") . "                                 GROUP BY po.products_options_name, pov.products_options_values_name                                 ORDER BY po.products_options_name, pov.products_options_values_sort_order");

and change them to

PHP Code:

    $attributes = $db->Execute("SELECT count(DISTINCT p2a.products_id) AS quantity, po.products_options_name, pov.products_options_values_name,                                 SUM(IF(p2a.products_id IN(" . implode(',', $filteredProducts) . "), 1, 0)) AS flag                                 FROM " . TABLE_PRODUCTS_ATTRIBUTES . " p2a                                 JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON p2a.options_id = po.products_options_id                                 AND po.language_id=" . (int)$_SESSION['languages_id'] . "                                 JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON p2a.options_values_id = pov.products_options_values_id                                 AND pov.language_id=" . (int)$_SESSION['languages_id'] .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as ON p2a.products_id = p2as.products_id                                   AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%')" : "") . "                                 WHERE p2a.products_id IN (" . implode(',', $unfilteredProducts) . ")" .                                 (FILTER_OPTIONS_INCLUDE != '' ? " AND p2a.options_id IN (" . FILTER_OPTIONS_INCLUDE . ")" : '') .                                 (FILTER_OPTIONS_EXCLUDE != '' ? " AND p2a.options_id NOT IN (" . FILTER_OPTIONS_EXCLUDE . ")" : '') .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   AND p2as.quantity > 0" : "") . "                                 AND po.products_options_type != '1'                                 AND po.products_options_type != '4'                                 GROUP BY po.products_options_name, pov.products_options_values_name                                 ORDER BY po.products_options_name, pov.products_options_values_sort_order");

this eliminates file and text.

If you want to add readonly to that list:

PHP Code:

    $attributes = $db->Execute("SELECT count(DISTINCT p2a.products_id) AS quantity, po.products_options_name, pov.products_options_values_name,                                 SUM(IF(p2a.products_id IN(" . implode(',', $filteredProducts) . "), 1, 0)) AS flag                                 FROM " . TABLE_PRODUCTS_ATTRIBUTES . " p2a                                 JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON p2a.options_id = po.products_options_id                                 AND po.language_id=" . (int)$_SESSION['languages_id'] . "                                 JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON p2a.options_values_id = pov.products_options_values_id                                 AND pov.language_id=" . (int)$_SESSION['languages_id'] .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as ON p2a.products_id = p2as.products_id                                   AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%')" : "") . "                                 WHERE p2a.products_id IN (" . implode(',', $unfilteredProducts) . ")" .                                 (FILTER_OPTIONS_INCLUDE != '' ? " AND p2a.options_id IN (" . FILTER_OPTIONS_INCLUDE . ")" : '') .                                 (FILTER_OPTIONS_EXCLUDE != '' ? " AND p2a.options_id NOT IN (" . FILTER_OPTIONS_EXCLUDE . ")" : '') .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   AND p2as.quantity > 0" : "") . "                                 AND po.products_options_type != '1'                                 AND po.products_options_type != '4'                                 AND po.products_options_type != '5'                                 GROUP BY po.products_options_name, pov.products_options_values_name                                 ORDER BY po.products_options_name, pov.products_options_values_sort_order");
15 Sep 2015, 09:25 AM
Justrimless

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Design75

Yes there is. And a similar thing was already in a test version for "text" and "file" types

locate includes/modules/sideboxes/YOUR_TEMPLATE/dynamic_filter.php and find the lines.......

Many thanks.
15 Sep 2015, 09:47 AM
Justrimless

Re: Dynamic Filter - Narrow Results By In Stock Products

Is it possible to sort the attribute options alphabetically?

Thanks in advance.
15 Sep 2015, 11:23 AM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by Justrimless

Is it possible to sort the attribute options alphabetically?

Thanks in advance.

Yes, use the same query, and find

PHP Code:

ORDER BY po.products_options_name, pov.products_options_values_sort_order";

replce this with

PHP Code:

ORDER BY po.products_options_name, pov.products_options_values_name";
23 Sep 2015, 12:47 PM
bluefusionweb

Re: Dynamic Filter - Narrow Results By In Stock Products

Hi Design75,
I just wondered if it was possible to change the default attributes on the actual product page based on the selected attributes in the dynamic filter? So if for example they filter by colour "red" but the product comes in multiple colours, red could somehow be the default option on the product page attribute dropdown (to save the customer having to then pick it or worse ordering the wrong colour by accident!) The site is using zc 1.39 and latest dynamic filter plugin.
Thanks.
23 Sep 2015, 01:58 PM
Design75

Re: Dynamic Filter - Narrow Results By In Stock Products

Quote:

Originally Posted by bluefusionweb

Hi Design75,
I just wondered if it was possible to change the default attributes on the actual product page based on the selected attributes in the dynamic filter? So if for example they filter by colour "red" but the product comes in multiple colours, red could somehow be the default option on the product page attribute dropdown (to save the customer having to then pick it or worse ordering the wrong colour by accident!) The site is using zc 1.39 and latest dynamic filter plugin.
Thanks.

No doubt it can be done, but it will take a lot of custom coding and time. A the moment I have to much (paid) projects going to make time for trying to make this.
3 Oct 2015, 06:32 PM
upshur57

Re: Dynamic Filter - Left Col Boxes Misaligned

Hello, I am using ZenCart 1.5.4 and installed the latest version of the Dynamic Filter Module Version 1.3. I have never used the module on this shopping cart so it is a clean install.

The Module works great but keep getting and error in my debugging log. When I click on the Manufacturer name or Price in "Narrow Your Results" I receive the following error: [03-Oct-2015 13:28:11 America/New_York] PHP Warning: trim() expects parameter 1 to be string, array given in /home21/webserver/public_html/shopfolder/includes/functions/functions_general.php on line 63].

I've looked through the functions_general.php and the files in the Dynamic Filters and cannot figure out what is wrong, especially since Dynamic Filters Version 1.3 eliminated the functions_general.php file.

Any help would be greatly appreciated!
3 Oct 2015, 07:28 PM
lat9

Re: Dynamic Filter - Left Col Boxes Misaligned

It's cases like this where the myDEBUG Backtrace (https://www.zen-cart.com/downloads.php?do=file&id=1879) plugin will help. Once installed, it will cause additional information to be included in the log file, indicating who called who ... so you'll know which line of which module called functions_general's line 63, and you'll have the actual source of the issue.
3 Oct 2015, 09:57 PM
upshur57

Re: Dynamic Filter - Left Col Boxes Misaligned

Thank you for showing me this module.

After looking through the error log, I was able to figure out if I comment out the following from the tpl_header_currencies.php around line 19, the Dynamic Filter will work without any errors.

I do not know if it is supposed to be like that or not but it works for me right now.
:

HTML Code:

$hidden_get_variables = ''; reset($_GET); while (list($key, $value) = each($_GET)) { if ( ($key != 'currency') && ($key != zen_session_name()) && ($key != 'x') && ($key != 'y') ) { // Comment this out -> $hidden_get_variables .= zen_draw_hidden_field($key, $value); } }

After going through the files I found I was able to comment
7 Oct 2015, 06:29 AM
Design75

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by upshur57

Thank you for showing me this module.

After looking through the error log, I was able to figure out if I comment out the following from the tpl_header_currencies.php around line 19, the Dynamic Filter will work without any errors.

I do not know if it is supposed to be like that or not but it works for me right now.
:

HTML Code:

$hidden_get_variables = ''; reset($_GET); while (list($key, $value) = each($_GET)) { if ( ($key != 'currency') && ($key != zen_session_name()) && ($key != 'x') && ($key != 'y') ) { // Comment this out -> $hidden_get_variables .= zen_draw_hidden_field($key, $value); } }

After going through the files I found I was able to comment

At the the moment I do not see what this has to do with the Dynamic filter module. The file "tpl_header_currencies.php" is not used by this mod. The line you mentioned should denfinitely not be commented. I is needed for the cart to function properly.
3 Jan 2016, 06:38 AM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

This sounds like a great mod. I'm trying to figure out if it would be appropriate for my needs.
I am working on a new site which will contain different categories of food products.
I'd like to allow the user to be able to see all the gluten-free products, and even better, to see all gluten-free products in a particular category. So I'm wondering if it makes sense to just create a new category called "Gluten-Free". But it seems to make more sense to use the idea of a filter, and for the user to be able to click on the "Gluten-Free" filter whenever they see a list of products, so it would only show them the products in that category, or from those search results, etc., that are gluten-free.

I have never used attributes, and I don't have any products with attribute variations. This would be more of a boolean. Either a product is gluten-free or it is not. I might come up with other filters, like nut-free.
So, does it make sense to use this mod to accomplish that? How would I do that? Would I create an attribute called "Gluten-Free", put it on all the products, and set it to "true" when a product is gluten-free? Does that make sense? Is that going to force the user to do anything special when they want to add a product to their shopping cart? i.e., will they have to choose a value for this attribute? Or will they see something additional show up because this attribute is there? I'd really like to just set this attribute to true or false for each product, and not have it show up in a confusing way when the user views the product, but I would like the user to be able to filter on all products that have this attribute set to true. Does that make any sense? Can attributes be used like that, and would this mod make that possible?

Thanks in advance for any help with this.
3 Jan 2016, 10:32 AM
Design75

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by earth-friendly

This sounds like a great mod. I'm trying to figure out if it would be appropriate for my needs.
I am working on a new site which will contain different categories of food products.
I'd like to allow the user to be able to see all the gluten-free products, and even better, to see all gluten-free products in a particular category. So I'm wondering if it makes sense to just create a new category called "Gluten-Free". But it seems to make more sense to use the idea of a filter, and for the user to be able to click on the "Gluten-Free" filter whenever they see a list of products, so it would only show them the products in that category, or from those search results, etc., that are gluten-free.

I have never used attributes, and I don't have any products with attribute variations. This would be more of a boolean. Either a product is gluten-free or it is not. I might come up with other filters, like nut-free.
So, does it make sense to use this mod to accomplish that? How would I do that? Would I create an attribute called "Gluten-Free", put it on all the products, and set it to "true" when a product is gluten-free? Does that make sense? Is that going to force the user to do anything special when they want to add a product to their shopping cart? i.e., will they have to choose a value for this attribute? Or will they see something additional show up because this attribute is there? I'd really like to just set this attribute to true or false for each product, and not have it show up in a confusing way when the user views the product, but I would like the user to be able to filter on all products that have this attribute set to true. Does that make any sense? Can attributes be used like that, and would this mod make that possible?

Thanks in advance for any help with this.

I think the easiest would be to set a read only attribute, because the entities are not real optional choices. First make attribute name like "allergies". Next add value like glutenfree and nut free.
Add these to the designated products.
In the front end the you will be presented a new choice in the filter box called allergies. Depending on the settings you can choose one or multiple attributes.
If you do not want to show the read only attribute in the product description, you can hide them using css
4 Jan 2016, 04:18 AM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

Thanks very much, Design75! This sounds like a great suggestion, and now I understand how attributes can be used here. I will try this.
12 Jan 2016, 01:07 PM
teaj

Re: Dynamic Filter [Support Thread]

Apologies if this is already covered here (tried searching for a while and not found anything)....but is there an easy way to have this filter display above the search results etc rather than in a side box? I have sideboxes disabled for the site I am working on! Cheers
12 Jan 2016, 02:04 PM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by fobes77

Apologies if this is already covered here (tried searching for a while and not found anything)....but is there an easy way to have this filter display above the search results etc rather than in a side box? I have sideboxes disabled for the site I am working on! Cheers

No, the current version of the module does not. I started work on a centered box some time ago, but due to a lack of time, caused by paying customers :smile:. I have not had the time to finish it.
12 Jan 2016, 02:13 PM
teaj

Re: Dynamic Filter [Support Thread]

Ahh thanks! ...good to hear you are getting paid.

I'm trying to format the Sideboxes position / layout now....hopefully that will be a nice work around. Cheers
19 Feb 2016, 06:18 PM
fakeDecoy

Re: Dynamic Filter [Support Thread]

I'm running zc 1.3.9 and I'm considering doing the big upgrade to 1.5 to be more compatible with mods like this.

Can I customize the attribute filters by category? For example, one category will have diameter, finish, and length, while another category will have grade and height.
19 Feb 2016, 07:03 PM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by fakeDecoy

I'm running zc 1.3.9 and I'm considering doing the big upgrade to 1.5 to be more compatible with mods like this.

Can I customize the attribute filters by category? For example, one category will have diameter, finish, and length, while another category will have grade and height.

The are filters determined by the products in a category.
19 Feb 2016, 07:16 PM
fakeDecoy

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by Design75

The are filters determined by the products in a category.

I'm not sure what you're trying to say... Does it grab all the attribute values of all products in a category and list those in the filters organized by option name? Does that go for dropdowns, checkboxes, everything else? Is there any way to exclude some?
27 Feb 2016, 12:10 AM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by fakeDecoy

I'm not sure what you're trying to say... Does it grab all the attribute values of all products in a category and list those in the filters organized by option name? Does that go for dropdowns, checkboxes, everything else? Is there any way to exclude some?

Sorry for the late reply.
Yes it grabs all the attribute for the products in a category, except for download, and text attributes. The representation of the filter can be controlled through the admin settings. This is also the place where you can enter the id's of the attributes you want to exclude.
12 May 2016, 08:43 AM
LadyoftheCave

Re: Dynamic Filter [Support Thread]

When I tried to install the SQL patch, I received the following error, do you happen to know what I can do to fix this?

HTML Code:

Succes 9 statements processed. Foutmelding ERROR: adding "configuration_key" "" wasn't possible because it already exists. Foutmelding ERROR: adding "configuration_key" "" wasn't possible because it already exists. Foutmelding ERROR: adding "configuration_key" "" wasn't possible because it already exists. Waarschuwing Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
5 Jun 2016, 11:43 AM
LadyoftheCave

Re: Dynamic Filter [Support Thread]

nobody? :blink:
5 Jun 2016, 11:54 AM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by LadyoftheCave

When I tried to install the SQL patch, I received the following error, do you happen to know what I can do to fix this?

HTML Code:

Succes 9 statements processed. Foutmelding ERROR: adding "configuration_key" "" wasn't possible because it already exists. Foutmelding ERROR: adding "configuration_key" "" wasn't possible because it already exists. Foutmelding ERROR: adding "configuration_key" "" wasn't possible because it already exists. Waarschuwing Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

This is telling you that some keys already existed, and skipped those. So you should be fine.
Does the mod work?
5 Jun 2016, 12:02 PM
LadyoftheCave

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by Design75

This is telling you that some keys already existed, and skipped those. So you should be fine.
Does the mod work?

Unfortunatelly it wasn't working. I will try again (had removed it from my computer because it wasn't working) and I will let you know what the errors are..

Thank you..
5 Jun 2016, 12:32 PM
LadyoftheCave

1 Attachment(s)

Re: Dynamic Filter [Support Thread]

Hi again Design75. I have installed the Dynamic filter again. I have switched it on at the layout boxes controller, but when I go to Admin -> Configuration -> Dynamic Filter. Then I only see an empty page (see picture)

Attachment 16400
6 Jun 2016, 12:25 PM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by LadyoftheCave

Hi again Design75. I have installed the Dynamic filter again. I have switched it on at the layout boxes controller, but when I go to Admin -> Configuration -> Dynamic Filter. Then I only see an empty page (see picture)

Attachment 16400

I suspect that the configuration id's in the database are different from the id set for dynamic filter. You probably should try a manual edit in phpmyadmin, and match the id's
Find in the table admin_pages what the number is that is set in gID=##. Then go to the table configuration and set this number in each configuration_group_id for the dynamic filter settings
7 Jun 2016, 09:43 AM
LadyoftheCave

Re: Dynamic Filter [Support Thread]

Thank you :) I am going to try this now..
7 Jun 2016, 10:04 AM
LadyoftheCave

Re: Dynamic Filter [Support Thread]

It is working now, thank you :)
7 Jun 2016, 11:37 AM
Design75

Re: Dynamic Filter [Support Thread]

Quote:

Originally Posted by LadyoftheCave

It is working now, thank you :)

Thanks for reporting back, and I am glad it is working now
7 Jun 2016, 03:24 PM
LadyoftheCave

Re: Dynamic Filter [Support Thread]

Hi again :smile:,

I thought that everything was working now, but when I click on by price, everything is working, but if I click on by colour, then I receive an error:

WARNING: An Error occurred, please refresh the page and try again.

Log file:

HTML Code:

[07-Jun-2016 11:09:38 Europe/Amsterdam] PHP Fatal error: 1267:Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (latin1_bin,NONE) for operation 'find_in_set' :: SELECT DISTINCT p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status FROM products p LEFT JOIN specials s on p.products_id = s.products_id LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id JOIN products_attributes p2a on p.products_id = p2a.products_id JOIN products_options po on p2a.options_id = po.products_options_id JOIN products_options_values pov on p2a.options_values_id = pov.products_options_values_id WHERE p.products_status = 1 and pd.language_id = '2' and p2c.categories_id = '457' and (p.products_price_sorter>=5.28 and p.products_price_sorter<=15) GROUP BY p.products_id HAVING ( FIND_IN_SET("Kleurbruin/naturel", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))) ==> (as called by) /var/www/vhosts/merlins-cave.nl/httpdocs/xdatabasesite/includes/modules/pages/ index/header_php.php on line 52 <== in /var/www/vhosts/merlins-cave.nl/httpdocs/xdatabasesite/includes/classes/db/mysql/query_factory.php on line 155
7 Jun 2016, 03:36 PM
Design75

Re: Dynamic Filter [Support Thread]

You have different collations in your database. This is causing the error. You should change them all to latin1_swedish_ci.
9 Jun 2016, 03:46 AM
brian70809

Re: Dynamic Filter [Support Thread]

I love what this filter can do, but I want it to behave exactly like the first post website http://www.snowrepublic.co.uk/.....

Is this even the same mod, the post is from 2012? I want to be able to check multiple boxes and it filters as they are checked and unchecked... So it's responding immediately to inputs instead of waiting to click the filter button. Is there is an option for it to do this?

I am sure I can modify the code to do this, but before I do, I just want to make sure I'm not doing something incorrectly.

So I want it to behave like checkbox-single but actually allow for multiple inputs.

Thanks!

Brian
13 Jul 2016, 03:07 PM
tmacarle

Re: Dynamic Filter [Support Thread]

Hi, I am wondering if anyone can help me. I do like the dynamic filter however, it causes my manufacturer/category & alpha sort filters (built in) to not work at all. I am using zencart 1.5.1 and have winchester black template by picaflor installed. The dynamic filter works perfectly (I installed the code around the modified files manually), but now the built in filters do not work at all. I am in need of having a "category" filter otherwise I must uninstall this mod as this is crucial for my particular site. Thanks.
14 Jul 2016, 04:22 AM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

Hi. You had given me a great suggestion a while ago about how to filter the products on my website by different food allergies: gluten free, nut free, etc. I have created an Option Name of Allergies (display-only), with Option Values of: Gluten Free, Tree Nut Free, Peanut Free, and Lactose Free. I have put the Allergies attribute on 2 products in the Snacks category.
1) Don't Go Nuts Blueberry Blast is: Gluten Free, Peanut Free, and Tree Nut Free.
2) Monk Pack Apple Quinoa is: Gluten Free and Lactose Free.
I'm using the multiple checkboxes style. People might have multiple allergies, so if I check both Gluten Free and Lactose Free, I would expect that only the Monk Pack Apple Quinoa product would be returned, since it is the only product that has both options set. However, it is returning both of the products. I think it must be returning all products that have either of these options set, but instead, I want it to return only the products that have both of these options set. Is there any way for me to get that to happen?

In case you want to see it in action, I have this running on my test site, test "dot" kosher4health "dot" com. You can go to the snacks category to see it work.

Thanks very much for any help with this! It's a great mod, and I know it will be a great addition to my site.
14 Jul 2016, 04:25 PM
Design75

Re: Dynamic Filter - Left Col Boxes Misaligned

:bigups:

Quote:

Originally Posted by earth-friendly

Hi. You had given me a great suggestion a while ago about how to filter the products on my website by different food allergies: gluten free, nut free, etc. I have created an Option Name of Allergies (display-only), with Option Values of: Gluten Free, Tree Nut Free, Peanut Free, and Lactose Free. I have put the Allergies attribute on 2 products in the Snacks category.
1) Don't Go Nuts Blueberry Blast is: Gluten Free, Peanut Free, and Tree Nut Free.
2) Monk Pack Apple Quinoa is: Gluten Free and Lactose Free.
I'm using the multiple checkboxes style. People might have multiple allergies, so if I check both Gluten Free and Lactose Free, I would expect that only the Monk Pack Apple Quinoa product would be returned, since it is the only product that has both options set. However, it is returning both of the products. I think it must be returning all products that have either of these options set, but instead, I want it to return only the products that have both of these options set. Is there any way for me to get that to happen?

In case you want to see it in action, I have this running on my test site, test "dot" kosher4health "dot" com. You can go to the snacks category to see it work.

Thanks very much for any help with this! It's a great mod, and I know it will be a great addition to my site.

I am on vacation right now, but as soon as I'm back (2 asks)I will take a look. Or else please remind me.
17 Jul 2016, 07:17 AM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by earth-friendly

Hi. You had given me a great suggestion a while ago about how to filter the products on my website by different food allergies: gluten free, nut free, etc. I have created an Option Name of Allergies (display-only), with Option Values of: Gluten Free, Tree Nut Free, Peanut Free, and Lactose Free. I have put the Allergies attribute on 2 products in the Snacks category.
1) Don't Go Nuts Blueberry Blast is: Gluten Free, Peanut Free, and Tree Nut Free.
2) Monk Pack Apple Quinoa is: Gluten Free and Lactose Free.
I'm using the multiple checkboxes style. People might have multiple allergies, so if I check both Gluten Free and Lactose Free, I would expect that only the Monk Pack Apple Quinoa product would be returned, since it is the only product that has both options set. However, it is returning both of the products. I think it must be returning all products that have either of these options set, but instead, I want it to return only the products that have both of these options set. Is there any way for me to get that to happen?

In case you want to see it in action, I have this running on my test site, test "dot" kosher4health "dot" com. You can go to the snacks category to see it work.

Thanks very much for any help with this! It's a great mod, and I know it will be a great addition to my site.

Design75, no need to look into this issue. I found a way to solve this problem.
I created each of these allergies as a separate Option Name, and each Option Name has a single Option Value.
So I have an Option Name: Gluten Free, and that Option has 1 Option Value, which I also call Gluten Free.
Then I have another Option Name: Peanut Free, and that Option has 1 Option Value, which I call Peanut Free, and so on.
Now, if you want to find products that are both Gluten Free and Peanut Free, you click on both checkboxes, and it does it correctly.
Previously, I just had one Option Name, Allergies, and a bunch of different Option Values for that option (Gluten Free, Peanut Free, etc.) When I clicked on 2 different option values, it found the products that were either Gluten Free or Peanut Free. I can understand that in some cases you might want this behavior. For example, if you have clothing that comes in different colors, you might want to find all clothes that are either red or purple. But in my case, I want to find products that are both Gluten Free and Peanut Free, so this solution seems to work well for that.
I fixed up the styling so that the option names don't display, and I tightened up the spacing.
I have implemented this on my live site, so you can see it working there if you'd like.
http://www.kosher4health.com .
Thanks again for a great mod! I think this will be very helpful for my customers. :smile:
17 Jul 2016, 09:12 AM
Design75

Re: Dynamic Filter - Left Col Boxes Misaligned

:thumbsup: glad you figured it out. I am sure it will help others.
18 Jul 2016, 06:25 AM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

I have discovered a problem.
If you go to my website, http://www.kosher4health.com, and go to the "Snacks" category, and then click on the checkbox for "Gluten Free", and then at the top right, instead of going to the next page, click "View All",
then I get: "There are no products to list in this category." even though there are products.
There is a debug file, and it has a bunch of stuff, but I think the main thing is that it is trying to divide by zero in split_page_results.php, on line 100. (I can give you the complete debug file if that will be helpful.)
This is line 100:

Code:

$this->number_of_pages = ceil($this->number_of_rows / $this->number_of_rows_per_page);

This means that

Code:

$this->number_of_rows_per_page

is zero.
Higher up in the file we have:

Code:

$this->number_of_rows_per_page = $max_rows;

and a little above that we have:

Code:

if ($page == 'all') { $this->page_all = true; $override = $db->Execute($query); $max_rows = $override->RecordCount(); }

So it looks like the query is not returning any results.

I'm not sure where I should go from here. I could work in my test site, and turn on debugging for sql statements. Or, does anyone have any ideas about what might be going wrong and how to fix it?
I am using zen-cart 1.5.5a, and the Winchester Responsive template.
I did my best to modify split_page_results.php for this mod, but there were some significant differences between this file and my version, probably because of both 1.5.5a and Winchester Responsive.
Thanks in advance for any help with this issue!
21 Jul 2016, 03:41 AM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by earth-friendly

I have discovered a problem.
If you go to my website, http://www.kosher4health.com, and go to the "Snacks" category, and then click on the checkbox for "Gluten Free", and then at the top right, instead of going to the next page, click "View All",
then I get: "There are no products to list in this category." even though there are products.
There is a debug file, and it has a bunch of stuff, but I think the main thing is that it is trying to divide by zero in split_page_results.php, on line 100. (I can give you the complete debug file if that will be helpful.)
This is line 100:

Code:

$this->number_of_pages = ceil($this->number_of_rows / $this->number_of_rows_per_page);

This means that

Code:

$this->number_of_rows_per_page

is zero.
Higher up in the file we have:

Code:

$this->number_of_rows_per_page = $max_rows;

and a little above that we have:

Code:

if ($page == 'all') { $this->page_all = true; $override = $db->Execute($query); $max_rows = $override->RecordCount(); }

So it looks like the query is not returning any results.

I'm not sure where I should go from here. I could work in my test site, and turn on debugging for sql statements. Or, does anyone have any ideas about what might be going wrong and how to fix it?
I am using zen-cart 1.5.5a, and the Winchester Responsive template.
I did my best to modify split_page_results.php for this mod, but there were some significant differences between this file and my version, probably because of both 1.5.5a and Winchester Responsive.
Thanks in advance for any help with this issue!

I have sort of figured this out, but not sure if my solution makes total sense.
The file I worked with is includes/modules/MYTEMPLATE/dynamic_filter.php
The issue seems to be in the HAVING part of the query:

Code:

$having .= ' FIND_IN_SET("' . $key . addslashes($value) . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))';

When I go to my website and click on the snacks category,
http://www.kosher4health.com/snacks-c-1.html
and then I click on "Gluten Free" to filter by that,
everything works fine. The value of $having at that point is:

Code:

HAVING ( FIND_IN_SET("GlutenFreeGluten Free", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))

However, if I then click on the "View All" link in the top right (instead of going to a particular page number), it says there are no products to list in this category. The query that is being run returns no records. And, the value of $having at that point is:

Code:

HAVING ( FIND_IN_SET("GlutenFreeGluten%20Free", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))

So in other words, the option value that it is searching for in the database, after clicking on "Gluten Free", is "Gluten Free".
But after clicking on "View All", the option value that it is searching for is "Gluten%20Free".

I also noticed that the urls are a bit strange:
After clicking on the checkbox for "Gluten Free", the url is:

Code:

http://www.mydomainname.com/snacks-c-1.html?main_page=index&cPath=1&fltGlutenFree%5B%5D=Gluten+Free

and after clicking on "View All", the url is:

Code:

http://www.mydomainname.com/snacks-c-1.html?fltGlutenFree%5B%5D=Gluten%2520Free&sort=20a&page=all

It looks like extra encoding happens during this process.

The solution I came up with in my test site is to remove both a space and "%20" in $value, and then in the db search, also remove spaces from the products_options_values_name, in the same way that spaces are being removed from the search on products_options_name.
So, I replaced :

Code:

$having .= ' FIND_IN_SET("' . $key . addslashes($value) . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))';

with

Code:

$having_value = str_replace(" ","",$value); $having_value = str_replace("%20","",$having_value); $having .= ' FIND_IN_SET("' . $key . addslashes($having_value) . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), REPLACE(pov.products_options_values_name, " ", ""))))'

And now, after clicking on the checkbox for Gluten Free, the value of $having is:

Code:

HAVING ( FIND_IN_SET("GlutenFreeGlutenFree", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), REPLACE(pov.products_options_values_name, " ", ""))))

and after clicking on "View All", the value of $having is:

Code:

HAVING ( FIND_IN_SET("GlutenFreeGlutenFree", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), REPLACE(pov.products_options_values_name, " ", ""))))

I haven't put this on my live site yet. I was hoping that perhaps Design75, you could please look it over to make sure it is a reasonable change.
Also, I wonder if anyone else has had this problem, or if it has to do with the template I am using.
Thanks in advance for your help with this!!
26 Jul 2016, 05:29 PM
earth-friendly

Re: Dynamic Filter - Left Col Boxes Misaligned

Just to let you know, the changes described above didn't completely solve the problem. I found that if I filtered by "Gluten Free", and then clicked to go to page 2, then to page 3, it would still double encode the space in "Gluten Free" in the url, and I would end up with finding no results.
The solution I came up with had the following changes:
1) In includes/modules/mytemplate/dynamic_filter.php
Replace

Code:

$having .= ' FIND_IN_SET("' . $key . addslashes($value) . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))';

with

Code:

// BOF LEFP fix to remove spaces before searching for attribute values $having_value = str_replace(" ","",$value); $having_value = str_replace("%20","",$having_value); $having .= ' FIND_IN_SET("' . $key . addslashes($having_value) . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), REPLACE(pov.products_options_values_name, " ", ""))))'; // EOF LEFP fix

2) In includes/templates/mytemplate/sideboxes/tpl_dynamic_filter.php
Right before:

Code:

if ($attributes->fields['products_options_values_name'] != $savValue)

add:

Code:

// BOF LEFP fix to remove spaces before searching for attribute values $value_without_spaces = str_replace(" ","",$attributes->fields['products_options_values_name']);

Then, everywhere within the "if" statement, replace

Code:

$attributes->fields['products_options_values_name']

with

Code:

$value_without_spaces

EXCEPT where we are actually printing it out, because we want "Gluten Free" to show up with the space on the page:

Code:

htmlspecialchars(html_entity_decode($attributes->fields['products_options_values_name'], ENT_QUOTES)) .' 

Also, replace

Code:

$savValue = $attributes->fields['products_options_values_name'];

with

Code:

$savValue = $value_without_spaces;

Note: I am using the single checkbox method, so I only made those changes in my file, so I'm not sure if the changes are identical for the other methods.
Anyway, those are the changes I made, and it seems to work ok. I have it on my live site now, http://www.kosher4health.com. I'd love to hear comments about whether or not this change is ideal. I hope this helps someone :smile:
I'm still not sure if this was a problem for everyone, or just for me because of the template I am using. Perhaps everyone else has single-word attribute values, and I am the first person to have an attribute value with a space?
5 Aug 2016, 12:26 PM
Psychophrenic

Re: Dynamic Filter - Left Col Boxes Misaligned

Good afternoon, and hello to all zen-guys! im new to zen-cart and one of my clients e-shop is on zen-cart 1.5.4. with the megashop template installed on it. I can see that the dynamic filter works on the special and feature page but it does not seem that it works on the categories and sub-category pages as requested. Can anyone help? the sites url is : http://eudatahost.com/heliland/catal...ain_page=index Thanxs in advance,
12 Aug 2016, 05:26 PM
soxophoneplayer

Re: Dynamic Filter - Left Col Boxes Misaligned

I'm playing with this mod on my WAMP test site, zc 1.5.5a with Responsive Sheffiled Blue and many mods.

On the install.sql - the big chunk at the beginning of this file installs via phpMyAdmin. But I get error on the last bit for zencart 1.5 mods.

Specifically, the values for main_page_parms and sort order.

Code:

DELETE FROM zen_admin_pages WHERE page_key='configDynamicFilter'; INSERT INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configDynamicFilter','BOX_CONFIGURATION_DYNAMIC_FILTER','FILENAME_CONFIGURATION',CONCAT('gID=',@cid), 'configuration', 'Y', @cid);

My zen_config_group installed from the first part of sql has config group id and sort order of 2828. I tried substituting those values in place of the @cid, to no avail.

There are no extra columns in my zen_admin_pages.

Initial error msg was those values (as in install.sql) can't be null. Attempt to insert the 2828 gives syntax error.
12 Aug 2016, 08:42 PM
soxophoneplayer

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by soxophoneplayer

I'm playing with this mod on my WAMP test site, zc 1.5.5a with Responsive Sheffiled Blue and many mods.

On the install.sql - the big chunk at the beginning of this file installs via phpMyAdmin. But I get error on the last bit for zencart 1.5 mods.

Specifically, the values for main_page_parms and sort order.

Code:

DELETE FROM zen_admin_pages WHERE page_key='configDynamicFilter'; INSERT INTO zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configDynamicFilter','BOX_CONFIGURATION_DYNAMIC_FILTER','FILENAME_CONFIGURATION',CONCAT('gID=',@cid), 'configuration', 'Y', @cid);

My zen_config_group installed from the first part of sql has config group id and sort order of 2828. I tried substituting those values in place of the @cid, to no avail.

There are no extra columns in my zen_admin_pages.

Initial error msg was those values (as in install.sql) can't be null. Attempt to insert the 2828 gives syntax error.

Got this more or less sorted...in the page_params I changed CONCAT('gID=',@cid) to gID=2828 instead of just 2828 and that worked.

So I got this mod fired up in zc 1.5.5a to the extent that everything shows up in the admin page but I'm not functional with it yet which I think is more related to how I've got my categories and attributes (lack of) set up - not directly related to this forum so I'll pursue that aspect elsewhere.
13 Aug 2016, 06:57 PM
soxophoneplayer

Re: Dynamic Filter - Left Col Boxes Misaligned

[QUOTE=soxophoneplayer;1317043]Got this more or less sorted.../QUOTE]

Just to confirm for anyone interested - I have this mod working with zc 1.5.5a and Responsive Sheffiled Blue. A bit of fiddling with the sql as noted above, and a couple of the file merges were semi-tricky as files were already modified by the template.

I'm using this mod with Stock By Attributes, the github fileset from June 2016.

I've tested right through to checkout (not payment) stage and am still only on my test WAMP site.
14 Sep 2016, 05:27 PM
Justrimless

Re: Dynamic Filter - Read only products

Quote:

Originally Posted by Design75

Yes there is. And a similar thing was already in a test version for "text" and "file" types

locate includes/modules/sideboxes/YOUR_TEMPLATE/dynamic_filter.php and find the lines

PHP Code:

    $attributes = $db->Execute("SELECT count(DISTINCT p2a.products_id) AS quantity, po.products_options_name, pov.products_options_values_name,                                 SUM(IF(p2a.products_id IN(" . implode(',', $filteredProducts) . "), 1, 0)) AS flag                                 FROM " . TABLE_PRODUCTS_ATTRIBUTES . " p2a                                 JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON p2a.options_id = po.products_options_id                                 AND po.language_id=" . (int)$_SESSION['languages_id'] . "                                 JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON p2a.options_values_id = pov.products_options_values_id                                 AND pov.language_id=" . (int)$_SESSION['languages_id'] .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as ON p2a.products_id = p2as.products_id                                   AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%')" : "") . "                                 WHERE p2a.products_id IN (" . implode(',', $unfilteredProducts) . ")" .                                 (FILTER_OPTIONS_INCLUDE != '' ? " AND p2a.options_id IN (" . FILTER_OPTIONS_INCLUDE . ")" : '') .                                 (FILTER_OPTIONS_EXCLUDE != '' ? " AND p2a.options_id NOT IN (" . FILTER_OPTIONS_EXCLUDE . ")" : '') .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   AND p2as.quantity > 0" : "") . "                                 GROUP BY po.products_options_name, pov.products_options_values_name                                 ORDER BY po.products_options_name, pov.products_options_values_sort_order");

and change them to

PHP Code:

    $attributes = $db->Execute("SELECT count(DISTINCT p2a.products_id) AS quantity, po.products_options_name, pov.products_options_values_name,                                 SUM(IF(p2a.products_id IN(" . implode(',', $filteredProducts) . "), 1, 0)) AS flag                                 FROM " . TABLE_PRODUCTS_ATTRIBUTES . " p2a                                 JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON p2a.options_id = po.products_options_id                                 AND po.language_id=" . (int)$_SESSION['languages_id'] . "                                 JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON p2a.options_values_id = pov.products_options_values_id                                 AND pov.language_id=" . (int)$_SESSION['languages_id'] .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as ON p2a.products_id = p2as.products_id                                   AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%')" : "") . "                                 WHERE p2a.products_id IN (" . implode(',', $unfilteredProducts) . ")" .                                 (FILTER_OPTIONS_INCLUDE != '' ? " AND p2a.options_id IN (" . FILTER_OPTIONS_INCLUDE . ")" : '') .                                 (FILTER_OPTIONS_EXCLUDE != '' ? " AND p2a.options_id NOT IN (" . FILTER_OPTIONS_EXCLUDE . ")" : '') .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   AND p2as.quantity > 0" : "") . "                                 AND po.products_options_type != '1'                                 AND po.products_options_type != '4'                                 GROUP BY po.products_options_name, pov.products_options_values_name                                 ORDER BY po.products_options_name, pov.products_options_values_sort_order");

this eliminates file and text.

If you want to add readonly to that list:

PHP Code:

    $attributes = $db->Execute("SELECT count(DISTINCT p2a.products_id) AS quantity, po.products_options_name, pov.products_options_values_name,                                 SUM(IF(p2a.products_id IN(" . implode(',', $filteredProducts) . "), 1, 0)) AS flag                                 FROM " . TABLE_PRODUCTS_ATTRIBUTES . " p2a                                 JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON p2a.options_id = po.products_options_id                                 AND po.language_id=" . (int)$_SESSION['languages_id'] . "                                 JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON p2a.options_values_id = pov.products_options_values_id                                 AND pov.language_id=" . (int)$_SESSION['languages_id'] .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as ON p2a.products_id = p2as.products_id                                   AND p2as.stock_attributes LIKE CONCAT('%', p2a.products_attributes_id, '%')" : "") . "                                 WHERE p2a.products_id IN (" . implode(',', $unfilteredProducts) . ")" .                                 (FILTER_OPTIONS_INCLUDE != '' ? " AND p2a.options_id IN (" . FILTER_OPTIONS_INCLUDE . ")" : '') .                                 (FILTER_OPTIONS_EXCLUDE != '' ? " AND p2a.options_id NOT IN (" . FILTER_OPTIONS_EXCLUDE . ")" : '') .                                 (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? "                                   AND p2as.quantity > 0" : "") . "                                 AND po.products_options_type != '1'                                 AND po.products_options_type != '4'                                 AND po.products_options_type != '5'                                 GROUP BY po.products_options_name, pov.products_options_values_name                                 ORDER BY po.products_options_name, pov.products_options_values_sort_order");

Hello, I asked whether it was possible to omit read only attributes from the results and you kindly provided the above solution, many thanks.
(A year to the day it seems!)

But I cannot find the lines you mention in order to change them?

Thanks in advance for any help.
23 Sep 2016, 06:29 PM
soxophoneplayer

Re: Dynamic Filter - Read only products

zc 1.5.5a, Responsive Sheffield Blue, Dynamic Filters and many mods.

Is there a way to change filtering within the values of an option name to AND from OR?

Example - I have an Option Name - Fibre, and Values Merino, Nylon, Cotton, etc. Using check boxes in DF, if I select both Merino and Nylon boxes I get a filtered list that has either Merino , OR Nylon - I'd prefer to get a result that includes only those with both Merino AND nylon. I can hack around this by creating another value called Merino-Nylon, but would prefer scenario I mention.
23 Sep 2016, 07:08 PM
Design75

Re: Dynamic Filter - Read only products

Quote:

Originally Posted by soxophoneplayer

zc 1.5.5a, Responsive Sheffield Blue, Dynamic Filters and many mods.

Is there a way to change filtering within the values of an option name to AND from OR?

Example - I have an Option Name - Fibre, and Values Merino, Nylon, Cotton, etc. Using check boxes in DF, if I select both Merino and Nylon boxes I get a filtered list that has either Merino , OR Nylon - I'd prefer to get a result that includes only those with both Merino AND nylon. I can hack around this by creating another value called Merino-Nylon, but would prefer scenario I mention.

I understand what you want, but I am not sure it is easy to achieve.
24 Sep 2016, 01:30 PM
soxophoneplayer

Re: Dynamic Filter - Read only products

Quote:

Originally Posted by Design75

I understand what you want, but I am not sure it is easy to achieve.

Thanks. I can work around it. But I had to ask - I'd have felt a real fool to find out after the fact that I could have changed OR to AND in one line of code ;o)
18 Oct 2016, 10:40 PM
icecold

Re: Dynamic Filter - Read only products

I'm using dynamic filters with ZC 1.5.3 and I'm migrating, rebuilding my store to ZC 1.5.5a with 1.5.3 I have several problems such as the price filtering not filtering within the assigned range, for instance I have a filter in place $1--$25 for some reason it leaks prices ABOVE it ... still couldn't find a way to solve it ...
4 Nov 2016, 11:04 AM
wrickspam

Re: Dynamic Filter - Read only products

Quote:

Originally Posted by icecold

I'm using dynamic filters with ZC 1.5.3 and I'm migrating, rebuilding my store to ZC 1.5.5a with 1.5.3 I have several problems such as the price filtering not filtering within the assigned range, for instance I have a filter in place $1--$25 for some reason it leaks prices ABOVE it ... still couldn't find a way to solve it ...

it uses the prices + tax, is that the leak you mean ?
22 Nov 2016, 04:22 AM
su35

Re: Dynamic Filter - Read only products

purpose: show all product list on main page
solution: in define_main_page.php add
require(DIR_WS_MODULES . zen_get_module_directory('pages/products_all/header_php.php'));
require($template->get_template_dir('/tpl_products_all_default.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_all_default.php');
result: all product list shown on main page
problem: the content of the filter is disappeared.
1 Dec 2016, 05:47 PM
icecold

Re: Dynamic Filter - Read only products

Quote:

Originally Posted by wrickspam

it uses the prices + tax, is that the leak you mean ?

Well no what I meant was prices(advertised prices), like let's say there was a tier between 10-20 well I see products that supposed to be filtered, like with $21 and even above prices ...
3 Dec 2016, 09:08 PM
chadlly2003

Re: Dynamic Filter - Read only products

Zencart 1.5.4
Zen-Cart_Dynamic_Attribute_filter-1.3

I was getting an error on my sql file. I used the code below found in the thread to make Dynamic filters SQL file work

// We show them all
$listing_sql = "SELECT DISTINCT " . $select_column_list . " p.products_id, p.products_type, p.master_categories_id,
p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1,
s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price,
p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping,
p.products_qty_box_status";

$listing_sql .= " FROM " . TABLE_PRODUCTS . " p" .
" LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id" .
" LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id" .
" LEFT JOIN " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id" .
" JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id" .
($filter_attr == true ? " JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " p2a on p.products_id = p2a.products_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS . " po on p2a.options_id = po.products_options_id" .
" JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov on p2a.options_values_id = pov.products_options_values_id" .
(defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK') ? " JOIN " . TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK . " p2as on p.products_id = p2as.products_id " : "") : '');

$listing_sql .= " WHERE p.products_status = 1
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p2c.categories_id = '" . (int)$current_category_id . "'" .
$filter .
" GROUP BY p.products_id " .
$having .
$alpha_sort;
}
}
// eof dynamic filter 2 of 2

Now I have an error when I do a search. I need assistance with solving this error below if someone could assist me...

[03-Dec-2016 14:51:00 America/New_York] PHP Fatal error: 1054:Unknown column 'in_name' in 'order clause' :: SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id FROM products p LEFT JOIN manufacturers m USING(manufacturers_id) LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id JOIN categories c on p2c.categories_id = c.categories_id LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1
AND pd.language_id = 1 AND ((pd.products_name LIKE '%aims%'
OR p.products_model
LIKE '%aims%'
OR m.manufacturers_name
LIKE '%aims%' OR (mtpd.metatags_keywords
LIKE '%aims%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%aims%'
AND mtpd.metatags_description !='') OR pd.products_description
LIKE '%aims%') and (pd.products_name LIKE '%power%'
OR p.products_model
LIKE '%power%'
OR m.manufacturers_name
LIKE '%power%' OR (mtpd.metatags_keywords
LIKE '%power%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%power%'
AND mtpd.metatags_description !='') OR pd.products_description
LIKE '%power%') )) GROUP BY p.products_id order by in_name DESC, p.products_sort_order, pd.products_name ==> (as called by) C:\xampp\htdocs\xxx.com\includes\templates\theme871\sideboxes\tpl_dynamic_filter .php on line 63 <== in C:\xampp\htdocs\xxx.com\includes\classes\db\mysql\query_factory.php on line 292
4 Dec 2016, 09:42 PM
chadlly2003

Re: Dynamic Filter - Read only products

Okay I solved my issue with 1054:Unknown column 'in_name' in 'order clause. I had a module called Search: Prioritize Matching Names
that needed to be disabled.

The issue that remains for some reason when I do a search. It shows the category filters and brand but not showing the pricing filter. How do I get the price filter to populate?

If someone could assist me or lead me in the right direction I would appreciate it.
6 Dec 2016, 08:31 PM
chadlly2003

Re: Dynamic Filter - Left Col Boxes Misaligned

Zencart 1.5.4
Issue (Dynamic Filter) ver 1.3

I have downloaded the dynamic filter plugin for Zen cart. I did see the post regarding this module but it seems not be active.
https://www.zen-cart.com/showthread....Support-Thread

I was wondering if someone can assist me. I currently installed the module and all seems good. The only issue I have is for some reason the price range is not displaying. Can someone assist me or lead me in the right direction in solving this issue. I am not sure if the pricing is based on the product price or attribute price.
21 Dec 2016, 06:40 PM
valnoren2

Re: Dynamic Filter - Left Col Boxes Misaligned

Is this plugin dead I am having issue with installing it and getting it to work with 1.5.5b. I had it working briefly with 1.5.5a but the sidebar stopped displaying after I updated then I tried to revert it and now still nothing works.
21 Dec 2016, 09:05 PM
soxophoneplayer

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by valnoren2

Is this plugin dead I am having issue with installing it and getting it to work with 1.5.5b. I had it working briefly with 1.5.5a but the sidebar stopped displaying after I updated then I tried to revert it and now still nothing works.

I have this mod working with zc 1.5.5b. The price filter was wonky so I turned it off. I read on this forum that price was always wonky. Also read this: https://www.zen-cart.com/showthread....en#post1260429 but I haven't pursued it further as price filter wasn't big issue of me as much as the other filters.

I did find that the mod didn't play nice with Stock by Attributes. I only had a few items using that mod so I uninstalled it and then, with price filter turned off, everything works fine for me.
16 Feb 2017, 03:47 AM
ttfan

Re: Dynamic Filter - Left Col Boxes Misaligned

I really love the looks of this module, and feel I need it for my site, but I don't think I have the software skills to get it working, juding by some of the issues discussed in this thread.
I'm running ZC 1.5.5d with a Responsive Sheffield Blue V 2.0 template. Can someone recommend an experience person that I can pay to get it installed & working?
16 Feb 2017, 09:45 AM
Design75

Re: Dynamic Filter - Left Col Boxes Misaligned

The module is working on Zen Cart 1.5.5d, as can be seen here on my dev site. I'll try to answer in this thread more often in the future, as the past year has been pretty busy.
I'll also try to release an updated version with some fixes for open issues.
16 Feb 2017, 04:10 PM
soxophoneplayer

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by Design75

The module is working on Zen Cart 1.5.5d, as can be seen here on my dev site. I'll try to answer in this thread more often in the future, as the past year has been pretty busy.
I'll also try to release an updated version with some fixes for open issues.

I love this mod and am also using it on zc 1.5.5d and Responsive Sheffield Blue

I am unable to filter by price without errors - a post on this forum suggests a solution involving settings by site host, which I 'intend' to follow up. Its not a pressing issue for my situation.

I use the filters on my desktop site. My template has mobile setting that I was able to fiddle to allow the filters to appear on mobile, but I turned it off as it opened 'full out' taking up all the the initial screen. An ask for future development would be ability to have a 'filters tab/menu' that was closed by default but could be clicked open - therefore not occupying full screen when site is loaded.

The mod doesn't play nice (for me) with Stock by Attributes mod. Wasn't a big issue for me as I only had a few products using that mod and I just split those products into separate product for each attribute.

This is a great mod that I think made a huge improvement to my site. Thanks for your work!
16 Feb 2017, 04:41 PM
Website Rob

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by Design75

The module is working on Zen Cart 1.5.5d, as can be seen here on my dev site.

A quick test on the "dev site" gave the following results.

Does not work using links for: All Products, New Products, Featured Products, Specials
-> gives a broken page with this msg: WARNING: An Error occurred, please refresh the page and try again.

Does work with Search results and most any other page I tried.

The "more" link at the bottom of certain options does slide down and shows more blank space.
16 Feb 2017, 06:52 PM
soxophoneplayer

Re: Dynamic Filter - Left Col Boxes Misaligned

Quote:

Originally Posted by Website Rob

A quick test on the "dev site" gave the following results.

Does not work using links for: All Products, New Products, Featured Products, Specials
-> gives a broken page with this msg: WARNING: An Error occurred, please refresh the page and try again.

Does work with Search results and most any other page I tried.

The "more" link at the bottom of certain options does slide down and shows more blank space.

I don't use 'all products' on my site, but the filters do work on new, featured, and specials. Maybe not coded in on the dev site?

Looking over my notes, I recall empty categories generated an error and would mangle the page style. Solution was simple - no empty categories.

Also noted from notes that using this mod with the Responsive Sheffield Blue 2.0 generated log errors that traced to the currencies mod that was part of the template. Didn't seem to affect function of the site, but to be safe I stripped out the currencies files and replaced with R Barbour currencies mod. No errors generated.

A bit of a tweak I did with the filters - the filtered attribute names of a product showed up on the 'add to cart' box on the product page. Some products had more or fewer attributes which affected the look/size of the page. Rather than just display:none them, I cut out the code that generated this feature and pasted it in one the the product description tabs resident in the template (that I previously had turned off as I wasn't using it). With a little css tweaking I think it came out as a nice lateral feature of the filters mod.

Show 100 post(s) from this thread on one page

All times are GMT +1. The time now is 03:08 PM.