Dynamic Filter [Support Thread]

[Design75]

Ok I have now got it to display But I really need it to display on the home page as well as all the others.

Can someone please advise how to display the dynamic filter on the home page?

That is not possible with the current module

[Congerman]

Dam OK I will have to have a re think on this then as my customer is insisting he wants that sort of filter on the home page.

Thanks for your speedy reply

[beep]

Hello. This mod looked like just what I needed but I just can't seem to get it working. I intstalled this mod around two weeks ago on v1.3.9h, at first it seemed fine but as I have dug deeper during setting up my attributes it is now evident that something is wrong. Quite wrong.

I would like to filter by the following attributes which I already have set up for all products; Colour, Motif/Print and Era. I wish to excude all the rest of my attributes which are for product options only (e.g. size, available colours, etc). I also wish to at present disable the filter by manufacturer option for now. These problems seem to be occuring;

- My attributes Colour, Motif/Print and Era are not displaying in the filter column. These attributes are read-only but it makes no difference if I change then to dropdown or checkbox, they still don't display in the filter column. If I remove them from 'include options' in configuration then all attributes appear (size, available colours, etc) as expected.

- The filter only works when set to Filter Style > Link. On every other setting when you click the filter button the page refreshes to the homepage. I wish to use the Checkbox - Multi filter style.

Website: http://www.ragandmagpie.co.uk/index....e=products_all (once working I plan to use the filter on all category pages. For now I'm baffled.

Note: 'Colours' is for filtering and 'Available colours' is for customer to select preferred colour to purchase.
Note: I have flexible attributes installed and the Colour, Motif/Print and Era attributes are hidden from the product info pages.

Help muchly appreciated. I'd be interested to know if anyone else has had a similar problem.

[TBSM]

Hi there,

I have an installed and working version of the Dynamic Filter module installed on my Zen Cart v1.5.1 install and is working properly at present. What I am looking to do is modify the Zen Cart advanced search SQL query so that I can order the search results by relevance (something which should be a core part of ZC IMO).
I have done this in the past in v1.5.1 and can do so with the filter turned off by using a MATCH(pd.products_name) AGAINST('$defined_keywords') AS rank then using the alias rank to order the results in descending order.
When the Dynamic Filter module is activated for search pages it seems to overwrite the ZC search SELECT sql meaning that my alias is not created and causing the search to result in a 1054 error.
Does anyone know if/where the filter module rewrites the search SQL? I have tried adding the code below into tpl_dynamic_filter.php however it does not seem to execute my MATCH AGAINST command.

if ($current_page_base != 'advanced_search_result') {
    $unfiltered_sql = str_replace(array($filter, $having), array("",""), "SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id" . substr($listing_sql, $pos_from, ($pos_where - $pos_from)) . substr($listing_sql, $pos_where, ($pos_group - $pos_where)));
    $unfiltered = $db->Execute($unfiltered_sql);
    }
    else {
        $unfiltered_sql = str_replace(array($filter, $having), array("",""), "SELECT p.products_id, p.products_price_sorter, p.master_categories_id, p.manufacturers_id, MATCH(pd.products_name) AGAINST('$keywords') AS rank1, MATCH(pd.products_description) AGAINST('$keywords') AS rank2 " . substr($listing_sql, $pos_from, ($pos_where - $pos_from)) . substr($listing_sql, $pos_where, ($pos_group - $pos_where)));
    $unfiltered = $db->Execute($unfiltered_sql);
    } 

I have tried adding an x to MATCH in the second section which breaks the query and shows that the keyword values are populated however when I remove the x it is like it is not there at all...


Any help would be great.
Thank you!

[TBSM]

Never mind! Managed to work this one out and now have a search which sorts results by relevance woo!

[xav2]

hello, i want to add "By Quantity:" (the values from products_quantity in table zen_products) to this mod,
is there anyone could help?

[xav2]

another question, what do i make the url more beautiful?

[xav2]

the price, manufacturers, attributes filter display in the sidebox, but my categories filter doesn't display, is there anything i missed?

[dharrison]

Hi

I did post in the other support thread, so apologies for sounding like a stuck record, but is there a way that the coding can be tweaked to include the individual unit price as well as the total product price?

The unit price is listed on the shopping cart page, and I would like the dynamic price updater to display the unit price on the product page along with the total cost (which includes Quantity).

I am good with basic PHP so long as I can be shown what needs to be added to where. All I seek is good guidance. Please could anyone help?

Thanks in Advance

[xav2]

hello, the file default_filter.php conflicts with my existing addon, could you help me modifying the code?

Dynamic Filter default_filter.php

<?php
  if (!isset($select_column_list)) $select_column_list = "";
   // show the products of a specified manufacturer
  if (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] != '' ) {
 
// bof dynamic filter 2 of 2
    if (isset($_GET['filter_id']) && zen_not_null($_GET['filter_id']) || isset($_GET[DYNAMIC_FILTER_PREFIX . $categoryGroup])) {
// We are asked to show only a specific category
      $listing_sql = "SELECT DISTINCT " . $select_column_list . " p.products_id, p.products_type, p.master_categories_id,
       p.manufacturers_id, m.manufacturers_name, 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 m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'" .
         " AND pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
         $filter .
         " GROUP BY p.products_id " .
         $having .
         $alpha_sort;
    } else {
// 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" .
       ($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 m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'" .
       $filter .
     " GROUP BY p.products_id " .
     $having .
     $alpha_sort;
    }
  } else {
// show the products in a given category
    if (isset($_GET['filter_id']) && zen_not_null($_GET['filter_id']) || isset($_GET[DYNAMIC_FILTER_PREFIX . $manufacturerGroup])) {
// We are asked to show only specific category
      $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;
    } else {
// 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" .
     " 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
?>

Existing addon default_filter.php

<?php
  if (!isset($select_column_list)) $select_column_list = "";
   // show the products of a specified manufacturer
  if (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] != '' ) {
    if (isset($_GET['filter_id']) && zen_not_null($_GET['filter_id'])) {
// We are asked to show only a specific category
      $listing_sql = "select " . $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
       from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id , " .
       TABLE_PRODUCTS_DESCRIPTION . " pd, " .
       TABLE_MANUFACTURERS . " m, " .
       TABLE_PRODUCTS_TO_CATEGORIES . " p2c
       where p.products_status = 1
         and p.manufacturers_id = m.manufacturers_id
         and m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'
         and p.products_id = p2c.products_id
         and pd.products_id = p2c.products_id
         and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

         ";/*BOF CUSTOM MODULE 1 of 4*/
         if(!empty($sub_cats)) 
             $listing_sql .=  "and p2c.categories_id IN($sub_cats)" .
         $alpha_sort;
         else 
         /*EOF CUSTOM MODULE 1 of 4*/ $listing_sql .=  "

         and p2c.categories_id = '" . (int)$_GET['filter_id'] . "'" .
         $alpha_sort;
    } else {
// We show them all
      $listing_sql = "select " . $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
      from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " .
      TABLE_PRODUCTS_DESCRIPTION . " pd, " .
      TABLE_MANUFACTURERS . " m
      where p.products_status = 1
        and pd.products_id = p.products_id
        and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

         ";/*BOF CUSTOM MODULE 2 of 4*/
         if(!empty($sub_cats)) 
             $listing_sql .=  "and p2c.categories_id IN($sub_cats)" .
         $alpha_sort;
         else 
         /*EOF CUSTOM MODULE 2 of 4*/ $listing_sql .=  "

        and p.manufacturers_id = m.manufacturers_id
        and m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'" .
        $alpha_sort;
    }
  } else {
// show the products in a given category
    if (isset($_GET['filter_id']) && zen_not_null($_GET['filter_id'])) {
// We are asked to show only specific category
      $listing_sql = "select " . $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
      from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " .
      TABLE_PRODUCTS_DESCRIPTION . " pd, " .
      TABLE_MANUFACTURERS . " m, " .
      TABLE_PRODUCTS_TO_CATEGORIES . " p2c
      where p.products_status = 1
        and p.manufacturers_id = m.manufacturers_id
        and m.manufacturers_id = '" . (int)$_GET['filter_id'] . "'
        and p.products_id = p2c.products_id
        and pd.products_id = p2c.products_id
        and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

         ";/*BOF CUSTOM MODULE 3 of 4*/
         if(!empty($sub_cats)) 
             $listing_sql .=  "and p2c.categories_id IN($sub_cats)" .
         $alpha_sort;
         else 
         /*BOF CUSTOM MODULE 3 of 4*/ $listing_sql .=  "

        and p2c.categories_id = '" . (int)$current_category_id . "'" .
        $alpha_sort;
    } else {
// We show them all
      $listing_sql = "select " . $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
       from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
       TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " .
       TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id
       where p.products_status = 1
         and p.products_id = p2c.products_id
         and pd.products_id = p2c.products_id
         and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

         ";/*BOF CUSTOM MODULE 4 of 4*/
         if(!empty($sub_cats)) 
             $listing_sql .=  "and p2c.categories_id IN($sub_cats)" .
         $alpha_sort;
         else 
         /*BOF CUSTOM MODULE 4 of 4*/ $listing_sql .=  "

         and p2c.categories_id = '" . (int)$current_category_id . "'" .
         $alpha_sort;
    }
  }
?>