Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
krugeros

manufacturers dropdown for all products in selected category and subcategory

Recommended Posts

Hi there,

 

I’m looking the solution to below problem concerning manufacturers dropdown in product listing after selecting category or subcategory.

 

 

Let’s say that category tree is like this:

 

Angels

----> Figures

---> small Figures

--> big Figures

----> Cards

 

Problem description:

 

If I select category “small Figures” manufacturer box appears above product list :

 

__________________________________________

 

Show: All manufacturers

 

Angels

--> Figures

-->
small Figures

--> big Figures

 

 

__________________________________________

 

 

and I can select all manufacturers from this category.

 

But when I move to higher category – Figures ( this category has no products – only subcategories ) I can not choose manufacturer because box manufacturers is not showing.

 

I use Show All Products in Category & Subcategories V1.0 link contribution – that means if I select Angels category I see all products from subcategries listed as in product listing. But unfortunately I’m not able to select manufacturers for all product from subcategories.

 

Just to summarise:

 

- I would like to be albe to select every manufacturer from dropdown that appears in every level of category tree for all products in that category and subcategories.

- make the box manufactuers apear in all categories ( this is in the code if (tep_db_num_rows($filterlist_query) > 1) presented above )

 

I’ve searched for contribution that is doing this but with no luck.

 

Anyone who knows how to solve it please help :rolleyes: I’m struggling with this for 2 days.

 

 

During my research I’ve found a code that’s responsible for showing this box in index.php:

 

// optional Product List Filter
   if (PRODUCT_LIST_FILTER > 0) {
     if (isset($HTTP_GET_VARS['manufacturers_id'])) {
       $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
     } else {
       $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";
     }
     $filterlist_query = tep_db_query($filterlist_sql);
     if (tep_db_num_rows($filterlist_query) > 1) {
       echo '            <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';
       if (isset($HTTP_GET_VARS['manufacturers_id'])) {
         echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
         $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));
       } else {
         echo tep_draw_hidden_field('cPath', $cPath);
         $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));
       }
       echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
       while ($filterlist = tep_db_fetch_array($filterlist_query)) {
         $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
       }
       echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
       echo tep_hide_session_id() . '</form></td>' . "\n";
     }
   }

Share this post


Link to post
Share on other sites
Guest

I too would be very interested in a solution to this old unanswered request. Can anyone tell me how to get this result as seen on this site?

 

Thanks.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×