Dynamic Filter [Support Thread]

[Design75]

Same here.

I tried escaping the " and or '. No luck.

The only thing that does not produce an error, is the following format:


But try to tell a shop owner to look at the following and do your additions, deletions, edits and audits and etc.


How is that for head spin?

I am trying to figure out a way also.

Thanks.




ps. Spaces between & and # are left out, so it displays here.

Here's a quick solution,

find in includes/modules/YUOR_TEMPLATE/dynamic_filter.php

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

replace with:

          $value = preg_replace('/"/','\\"',$value);
          $value = preg_replace('/&acute/','\\&acute',$value);
          $having .= ' FIND_IN_SET("' . $key . $value . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))'; 

more values can be added if needed

[Kevin205]

I will test your solution in my environment.

And this is what I came up with. It seems to be working for all attributes.
before

          }
          $having .= ' FIND_IN_SET("' . $key . $value . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))';
          $filter_attr = true;
          $prvHaving = $key;
        }
      }
    }
  }
  if($filter != '') $filter .= ')'; 

After

          }
$var1 = addslashes($value);
          $having .= ' FIND_IN_SET("' . $key . $var1 . '", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name)))';
          $filter_attr = true;
          $prvHaving = $key;
        }
      }
    }
  }
  if($filter != '') $filter .= ')'; 

What do you think?

I don't know whether it will have issues later on!

[Design75]

Very nice !

but it can be written as:

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

[Kevin205]

Which one would you use, yours solution or mine?

I really appreciate your help on this.

[Design75]

Which one would you use, yours solution or mine?

I really appreciate your help on this.

Yours, with my improvement (see previous post)

[Kevin205]

Yours, with my improvement (see previous post)

Of course.

I tested yours also, and it works perfectly as well.

Thank you.

[ekles]

Over the last few days we have tried to get the Dynamic Filter to work on a vanilla 1.5.1 install to no avail.

First of all I have zipped up the Dynamic Filter files that need alteration (in fact all the Dynamic Filter Files) just so if someone has time they can see if we have screwed up somewhere. It is available here at http://www.hpgc.com.au/zen/dynamic_filter_problem.zip

I have also attached the same files to this post. A read me doc explains everything here again.

++++ Server/System Information ++++

ZenCart = Vanilla installation of 1.5.1 downloaded in the last 5 days
PHP = 5.3.17
MySQL = 5.1.68-cll
PHP Configure Command =
'./configure' '--disable-fileinfo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-pdo=shared' '--enable-safe-mode' '--enable-soap' '--enable-sockets' '--enable-wddx' '--enable-zip' '--prefix=/usr' '--with-bz2' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'


++++ The Problem Outlined ++++

In terms of appearance Dynamic Filter appears on the screen correctly. That is all the settings within Admin function and so does the sidebox at least most of the time but I'll get to that.

We use read only attributes to control product attribute settings for the filter. In admin we have enabled under Dynamic Filter the attribute ID's we wish to use and disabled all the other attributes. Dynamic Filter appears to read these attributes at first.

Example of things that happen.

1. Select "Specials" and all the specials appear. Select from Dynamic Filter options "Colour" a colour and you get a result of say 5 items. Just by hitting refresh you can get a different result of say 7 next time.

If you then select an option from "size" as well to further refine the results 1 of 5 things can happen
1. It reduces the available number as expected.
2. It will have a higher count so instead of 5 meeting the colour requirement we now have 7 meeting both colour and size requirements.
3. Blank screen
4. Correct or incorrect listing of a number of items that supposedly meet the criteria and now the Dynamic Filter box has disappeared entirely stopping any further requirement.
5. Several items supposedly matching the criteria but ALL side boxes, banners etc are gone and the CSS screws up in things like site background colour.

2. Select "All Products" and it does the same as for "Specials" but generally will only allow the first selection and then goes blank if you make a second criteria choice.

There are other things but this is enough to show the erratic behaviour/results.

All these things happen wether you are using multi or single select criteria methods.

We have tried checkboxes and links.

We have also made appointments at Ashley and Martin (The hair replacement specialists) over this.

Any ideas?

Thanks in advance.

[Design75]

Over the last few days we have tried to get the Dynamic Filter to work on a vanilla 1.5.1 install to no avail.

First of all I have zipped up the Dynamic Filter files that need alteration (in fact all the Dynamic Filter Files) just so if someone has time they can see if we have screwed up somewhere. It is available here at http://www.hpgc.com.au/zen/dynamic_filter_problem.zip

I have also attached the same files to this post. A read me doc explains everything here again.

++++ Server/System Information ++++

ZenCart = Vanilla installation of 1.5.1 downloaded in the last 5 days
PHP = 5.3.17
MySQL = 5.1.68-cll
PHP Configure Command =
'./configure' '--disable-fileinfo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-pdo=shared' '--enable-safe-mode' '--enable-soap' '--enable-sockets' '--enable-wddx' '--enable-zip' '--prefix=/usr' '--with-bz2' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libexpat-dir=/usr' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-sqlite=shared' '--with-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'


++++ The Problem Outlined ++++

In terms of appearance Dynamic Filter appears on the screen correctly. That is all the settings within Admin function and so does the sidebox at least most of the time but I'll get to that.

We use read only attributes to control product attribute settings for the filter. In admin we have enabled under Dynamic Filter the attribute ID's we wish to use and disabled all the other attributes. Dynamic Filter appears to read these attributes at first.

Example of things that happen.

1. Select "Specials" and all the specials appear. Select from Dynamic Filter options "Colour" a colour and you get a result of say 5 items. Just by hitting refresh you can get a different result of say 7 next time.

If you then select an option from "size" as well to further refine the results 1 of 5 things can happen
1. It reduces the available number as expected.
2. It will have a higher count so instead of 5 meeting the colour requirement we now have 7 meeting both colour and size requirements.
3. Blank screen
4. Correct or incorrect listing of a number of items that supposedly meet the criteria and now the Dynamic Filter box has disappeared entirely stopping any further requirement.
5. Several items supposedly matching the criteria but ALL side boxes, banners etc are gone and the CSS screws up in things like site background colour.

2. Select "All Products" and it does the same as for "Specials" but generally will only allow the first selection and then goes blank if you make a second criteria choice.

There are other things but this is enough to show the erratic behaviour/results.

All these things happen wether you are using multi or single select criteria methods.

We have tried checkboxes and links.

We have also made appointments at Ashley and Martin (The hair replacement specialists) over this.

Any ideas?

Thanks in advance.

Not sure what you are tryng to tell, but in your zip-file you have not merged the spilt_page _result.php, and the functions_general.php, so obiuosly the filter will not work.

[ekles]

Not sure what you are tryng to tell, but in your zip-file you have not merged the spilt_page _result.php, and the functions_general.php, so obiuosly the filter will not work.

Actually spilt_page _result.php has been merged, just the person who did it did not add the BOF and EOF tags in.
The functions_general.php has been merged as well using , I just forgot to say in the post that we used DrBytes change to the file rather than the original alteration with the add-in. Using DT's original does no better.

Having said that what am I trying to say?

Even If you get results they are not accurate and float in terms of the result.

[dharrison]

Hi Damian

This looks like a cool add-on and just what I'm looking for. Is the latest version of this plugin compatible with Version 1.5.1?