Dynamic Filter [Support Thread]

[perfumbg]

Hello, yes:

SELECT @cid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Dynamic Filter';
DELETE FROM configuration WHERE configuration_group_id = @cid;
DELETE FROM configuration_group WHERE configuration_group_id = @cid;
INSERT INTO configuration_group VALUES (NULL, 'Dynamic Filter', 'Dynamic Filter Settings', '1', '1');
SET @cid=last_insert_id();
UPDATE configuration_group SET sort_order = @cid WHERE configuration_group_id = @cid;

INSERT INTO configuration VALUES
  (NULL, 'Enable on Category Pages', 'FILTER_CATEGORY', 'Yes', 'Enable the filter on category pages?', @cid, '10', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,"),
  (NULL, 'Enable on All Products Page', 'FILTER_ALL', 'Yes', 'Enable the filter on all products page?', @cid, '20', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,"),
  (NULL, 'Enable on New Products Page', 'FILTER_NEW', 'Yes', 'Enable the filter on new products page?', @cid, '30', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,"),
  (NULL, 'Enable on Featured Products Page', 'FILTER_FEATURED', 'Yes', 'Enable the filter on featured products page?', @cid, '40', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,"),
  (NULL, 'Enable on Specials Page', 'FILTER_SPECIALS', 'Yes', 'Enable the filter on specials page?', @cid, '50', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,"),
  (NULL, 'Enable on Search Page', 'FILTER_SEARCH', 'Yes', 'Enable the filter on advanced search page?', @cid, '60', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,"),
  (NULL, 'Filter Style', 'FILTER_STYLE', 'Link', 'How are the filters to be applied?<br /><br /><strong>Link</strong> - Each option is a link; Only one filter can be applied at a time.<br /><strong>Dropdown (Single)</strong> - Each option is part of a drop down list; Only one filter can be applied at a time.<br /><strong>Dropdown (Multi)</strong> - Each option is part of a drop down list; Multiple filters can be applied at a time.<br /><strong>Checkbox (Single)</strong> - Each option is a checkbox; Only one filter can be applied at a time.<br /><strong>Checkbox (Multi)</strong> - Each option is a checkbox; Multiple filters can be applied at a time.', @cid, '70', now(), now(), NULL, "zen_cfg_select_option(array('Link', 'Dropdown - Single', 'Dropdown - Multi', 'Checkbox - Single', 'Checkbox - Multi'),NULL,"),
  (NULL, 'Disabled Options Method', 'FILTER_METHOD', 'Greyed', 'How are the unavailable filter options to be disabled?<br /><br /><strong>Greyed</strong> - Grey out the unavailable options.<br /><strong>Hidden</strong> - Hide the unavailable options.', @cid, '80', now(), now(), NULL, "zen_cfg_select_option(array('Greyed', 'Hidden'),NULL,"),
  (NULL, 'Options Box Style', 'FILTER_OPTIONS_STYLE', 'Scroll', 'Which style of box should be used when the maximum number of options has been reached?<br /><br /><strong>Scroll</strong> - Scroll box.<br /><strong>Expand</strong> - Expanding box with More/Less link.<br /><br /><strong>Note: This option is only applicatble with Link or Checkbox filter styles.</strong>', @cid, '90', now(), now(), NULL, "zen_cfg_select_option(array('Scroll', 'Expand'),NULL,"),
  (NULL, 'Maximum Number of Options', 'FILTER_MAX_OPTIONS', '9', 'What is the maximum number of options to be displayed before scroll bar/More link is visible?<br /><br /><strong>Note: This option is only applicatble with Link or Checkbox filter styles.</strong>', @cid, '100', now(), now(), NULL, NULL,NULL,),
  (NULL, 'Enable Price filter', 'SHOW_FILTER_BY_PRICE', 'Yes', 'Enable the price filter?', @cid, '105', now(), now(), NULL, "zen_cfg_select_option(array('Yes', 'No'),NULL,NULL,"),
  (NULL, 'Maximum Number of Price Ranges', 'FILTER_MAX_RANGES', '5', 'What is the maximum number of price range groups?<br /><br /><strong>Note: This can be overridden by the Maximum Price Range parameter</strong>', @cid, '110', now(), now(), NULL, NULL,NULL,),
  (NULL, 'Minimum Price Range', 'FILTER_MIN_PRICE', '10', 'What is the minimum gap in the price ranges?<br />Set as zero to deactivate.', @cid, '120', now(), now(), NULL, NULL,NULL,),
  (NULL, 'Maximum Price Range', 'FILTER_MAX_PRICE', '25', 'What is the minimum gap in the price ranges?<br />Set as zero to deactivate.', @cid, '130', now(), now(), NULL, NULL,NULL,),
  (NULL, 'Include Options', 'FILTER_OPTIONS_INCLUDE', '', 'Enter the list of option IDs to be included in the filter, separated by commas (i.e. 1,2,3)<br />Only the option numbers listed here will appear in the filter.<br />Leave blank to deactivate.', @cid, '140', now(), now(), NULL, NULL,NULL,),
  (NULL, 'Exclude Options', 'FILTER_OPTIONS_EXCLUDE', '', 'Enter the list of option IDs to be excluded from the filter, separated by commas (i.e. 1,2,3)<br />The option numbers listed here will <strong>not</strong> appear in the filter.<br />Leave blank to deactivate.', @cid, '150', now(), now(), NULL, NULL,NULL,),
  (NULL, 'Google Event Tracking', 'FILTER_GOOGLE_TRACKING', 'No', 'Use Google Event Tracking?<br /><br /><strong>No</strong> - Do not use Google Event Tracking<br /><strong>ga.js</strong> - Use traditional ga.js Google Event Tracking method<br /><strong>Asynchronous</strong> - Use new asynchronous Google Event Tracking method<br /><br /><strong>Note: Requires Google Analytics Code</strong>', @cid, '160', now(), now(), NULL, "zen_cfg_select_option(array('No', 'ga.js', 'Asynchronous'),NULL,");

Indeed there is missing col, i investigated a litle. My older version of zencart has 11 cols and the new 1.5.6 has 12 cols.

I made an attemp with phpMyadmin and in some ways it was sucsesfull. I just added one more :

NULL,

at the end and, after imported the whole table with phpMyadmin, now everything works but in a ugly way :)...

On front end Dynamic Filter sidebox is present but all the text is messed, I mean there is no logical conection betwen the text and Attributes or said other way the names of attributes are not displayed.

What should i do does anybody have any idea?
Thanks.

[lankeeyankee]

It sounds like perhaps your extra column wasn't entered in the right place to get the other columns to line up. You would need to look again to see where the missing column is instead of just adding one at the end. It is also possible it could be something else was installed incorrectly, can you show a screenshot of what is wrong?

[Design75]

That is what happens when you do not define the field names first. Maybe for a future update, it can be integrated into the query.

It sounds like perhaps your extra column wasn't entered in the right place to get the other columns to line up. You would need to look again to see where the missing column is instead of just adding one at the end. It is also possible it could be something else was installed incorrectly, can you show a screenshot of what is wrong?

[perfumbg]

That is what happens when you do not define the field names first. Maybe for a future update, it can be integrated into the query.

Its brand new zencart 1.5.6 with only Ceon URI mappings where again I had some problems but nothing that has to do with Dynamic Filter.
Everything works exept the attr. names.

Does anybody tried Dynamic Filter with zencart 1.5.6?

Kind regards.

[perfumbg]

Ok so where did I get with phpMyadmin:

Everything works exept for:

- Dynamic Filter link in admin>configuration is missing but accessible if you type the configuration_id=NUMBER so not a big deal.

- Filter by manufacturers is missing big deal

No errors and log files but still no manufacturer filter, any gueses?

[perfumbg]

I have found solution but not sure if its right to bypass it that way...

In Your Template/sideboxes/tpl_dynamic_filter.php

somewhere line 132

// Only display if standard zen cart category/manufacturer dropdown is disabled
  if (PRODUCT_LIST_FILTER == 0)

If you change it like this:

// Only display if standard zen cart category/manufacturer dropdown is disabled
  if (PRODUCT_LIST_FILTER == 1)

It works as it should work.

[Design75]

That should not be necessary, if you have the Standard zen cart manufacturers filter disabled.

I have found solution but not sure if its right to bypass it that way...

In Your Template/sideboxes/tpl_dynamic_filter.php

somewhere line 132

// Only display if standard zen cart category/manufacturer dropdown is disabled
  if (PRODUCT_LIST_FILTER == 0)

If you change it like this:

// Only display if standard zen cart category/manufacturer dropdown is disabled
  if (PRODUCT_LIST_FILTER == 1)

It works as it should work.

[perfumbg]

'Somewhere' I read that the filters would work with only a single stock by attribute used, but I was unable to accomplish this - the filters would behave in very strange ways and cause template to go whacky and adding a product with attributes to the cart would add 2 products instead. I ended up removing SbyA altogether as I didn't have many products using it anyway. Another thing I found with the filters - EVERY product had to have at least one read-only attribute assigned of the product listing page would go whacky.

To deal with the SbyA products I have I simply created new products - ie one product large, one product medium, one product small etc instead of a single product with the size attributes. But as I mentioned, I only have a few of such products so it wasn't a big deal. It would be a lot of work if many products.

I had to install the last ZC 1.5.6.a and also have the same issue, only one attribute, one price range, one manufacturer and no filtered result when hit filter.

I have this error:

[12-Feb-2019 12:30:17 Europe/Sofia] Request URI: /prahosmukachki, IP address: 94.190.193.162
#1  array_replace() called at [/home/magpybbe/test.magprom.net/includes/classes/db/mysql/query_factory.php:626]
#2  queryFactoryResult->MoveNext() called at [/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/sideboxes/tpl_dynamic_filter.php:96]
#3  require(/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/sideboxes/tpl_dynamic_filter.php) called at [/home/magpybbe/test.magprom.net/includes/modules/sideboxes/responsive_classic/dynamic_filter.php:12]
#4  require(/home/magpybbe/test.magprom.net/includes/modules/sideboxes/responsive_classic/dynamic_filter.php) called at [/home/magpybbe/test.magprom.net/includes/modules/column_right.php:29]
#5  require(/home/magpybbe/test.magprom.net/includes/modules/column_right.php) called at [/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/common/tpl_main_page.php:183]
#6  require(/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/common/tpl_main_page.php) called at [/home/magpybbe/test.magprom.net/index.php:97]
--> PHP Warning: array_replace(): Argument #2 is not an array in /home/magpybbe/test.magprom.net/includes/classes/db/mysql/query_factory.php on line 626.

any ideas?

[Design75]

I had to install the last ZC 1.5.6.a and also have the same issue, only one attribute, one price range, one manufacturer and no filtered result when hit filter.

I have this error:

[12-Feb-2019 12:30:17 Europe/Sofia] Request URI: /prahosmukachki, IP address: 94.190.193.162
#1  array_replace() called at [/home/magpybbe/test.magprom.net/includes/classes/db/mysql/query_factory.php:626]
#2  queryFactoryResult->MoveNext() called at [/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/sideboxes/tpl_dynamic_filter.php:96]
#3  require(/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/sideboxes/tpl_dynamic_filter.php) called at [/home/magpybbe/test.magprom.net/includes/modules/sideboxes/responsive_classic/dynamic_filter.php:12]
#4  require(/home/magpybbe/test.magprom.net/includes/modules/sideboxes/responsive_classic/dynamic_filter.php) called at [/home/magpybbe/test.magprom.net/includes/modules/column_right.php:29]
#5  require(/home/magpybbe/test.magprom.net/includes/modules/column_right.php) called at [/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/common/tpl_main_page.php:183]
#6  require(/home/magpybbe/test.magprom.net/includes/templates/responsive_classic/common/tpl_main_page.php) called at [/home/magpybbe/test.magprom.net/index.php:97]
--> PHP Warning: array_replace(): Argument #2 is not an array in /home/magpybbe/test.magprom.net/includes/classes/db/mysql/query_factory.php on line 626.

any ideas?

which version of the module are you using?

[perfumbg]

I had used Version 1.3 on zc1.5.6 and it worked but now i'm using it on 1.5.6.a and I have this issue.