hideCategories

[DivaVocals]

Found it...
/includes/templates/template_default/tpl_document_product_info_display.php

Thanks for the help!

You should NEVER edit any of the files inthe template_default folder.. You would instead create an OVERRIDE file..

I actually didn't need to edit that tpl_document_product_info_display.php file... if I COPY an existing product to the new hidden category, the formatting comes across just fine. What was different is I'd created a NEW product in the hidden category, entered the duplicate info, and THAT product page was jacked. If you instead copy a product into the hidden category, all is well.

Took me awhile to figure it out, but thanks for a great add-on!

Glad you figured this all out, but any further questions on product page layout should be posted in a more appropriate thread.. I know you don't think that your questions are unrelated to support for the hideCategories support thread, but they really are.. You confirmed the add-on worked as it should. ALL of your page product layout questions (the order in which items appear on the product page) are OFF TOPIC for this support thread.. Therefore the layout of the product pages is a separate topic that has nothing to do with support/troubleshooting this add-on and going forward should be posted in a more appropriate place on the forum....

[uncharted]

Hi,

Anyone have this working for 1.5.0?

Thx

[ideasgirl]

Hide Categories is just what we need to be able to manage the update of huge numbers of products from multiple vendors and hide new categories while they are being worked on. I see that several sideboxes have been fixed so that hide categories will work with them. I need to try to make it work with the CSS dropdown menu and the CSS flyout menu.

Would someone of you coding gurus give me the exact editing to make the hidden categories work with the dropdown menu?

[DivaVocals]

Discovered that the new products centerbox that appears on the main page of Zen Cart doesn't "hide" products in hidden categories... This is something that I never realized was happening because I always turn this showing new products on the main page.

I'll be submitting an update to hideCategories with the correction (don't ask when.. It's the holiday season and I'm crazy busy.. I'll post the update when I get some time..), but in the meantime it's an easy fix to make yourself if you like..

FIRST create an override. Copy includes/modules/new_products.php to includes/modules/YOUR_TEMPLATE

Starting around line 23 in the includes/modules/YOUR_TEMPLATE/new_products.php file find this:

  $new_products_query = "select distinct p.products_id, p.productsi_image, p.products_tax_class_id, pd.products_name,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and   p.products_status = 1 " . $display_limit;

Replace that entire block with this:

//  Begin hideCategories modifications - this hides hidden categories from the New Products centerbox on main page
  $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
                                p.products_date_added, p.products_price, p.products_type, p.master_categories_id
                           from (" . TABLE_HIDE_CATEGORIES . " h, " . TABLE_PRODUCTS . " p
                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
                           where p.products_id = pd.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                           and (p.master_categories_id = h.categories_id and h.visibility_status !=2) 
                           and p.products_status = 1 " . $display_limit;
//  End hideCategories modifications - this hides hidden categories from the New Products centerbox on main page

Done..

[DivaVocals]

Would someone of you coding gurus give me the exact editing to make the hidden categories work with the dropdown menu?

Missed your post.. Dunno the answer to this, but the code I posted above I figured out by looking at other hideCategories files.. I imagine that this should be similarly easy.. BUT if I recall I think someone posted the answer to your question in the dropdown menu support thread.. If I get a chance I'll see if I can find that post..

[ideasgirl]

Dunno the answer to this, but the code I posted above I figured out by looking at other hideCategories files..

Don't worry, I found it somewhere and fixed it.

Have fun and Merry Christmassssss!

[DivaVocals]

Don't worry, I found it somewhere and fixed it.

Have fun and Merry Christmassssss!

Cool.. Ahhh X-Mas in Puerto Rico.. **sigh** Gonna get back there one day.. I LOVE Puerto Rico..I need some Mofongo...

Perhaps I'll include the link to the post with the instructions for modifying the dropdown menu in the next update of this mod..

[ideasgirl]

Perhaps I'll include the link to the post with the instructions for modifying the dropdown menu in the next update of this mod..

Yes, you should, could be very useful (or maybe just the code):
Post #328 http://www.zen-cart.com/forum/showpo...&postcount=328

****************BOF OFF TOPIC****************

Cool.. Ahhh X-Mas in Puerto Rico.. **sigh** Gonna get back there one day.. I LOVE Puerto Rico..I need some Mofongo...

Yes, you have to!

Christmas in Puerto Rico! So pretty, so good, the Christmas in Puerto Rico. The song talks about our traditions, music, horses, mountains, cities, history and of course our great food. Anyone that comes to Puerto Rico falls in love with our country and our people.
http://www.youtube.com/watch?v=8SUx14pc5BM

****************EOF OFF TOPIC****************

[DivaVocals]

Need to do two things..

1. Post clearer instructions for anyone needing this code..
2. Post a link to this post in the menu support threads since adowty never did this (as I suggested -- **sigh**). It will make it easy for others using one of these menus with hideCategories to find the required instructions..

Modification posted below is required to use hideCategories with the following menu mods:
CSS Horizontal Drop Down Menu
CSS Horizontal Dropdown Menu With jquery
CSS Flyout Menu

If you are using "CSS Horizontal Drop Down Menu" or "CSS Horizontal Dropdown Menu With jquery":
Around line 43 in includes/classes/categories_ul_generator.php find this:

        $categories_query = "select c.categories_id, cd.categories_name, c.parent_id
                                        from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                                        where c.categories_id = cd.categories_id
                                        and c.categories_status=1 " .
                                        " and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
                                        " order by c.parent_id, c.sort_order, cd.categories_name";

If you are using "CSS Flyout Menu"
Around line 47 in includes/classes/categories_ul_generator.php find this:

  $categories_query = "select c.categories_id, cd.categories_name, c.parent_id
                      from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                       where c.categories_id = cd.categories_id
                       and c.categories_status=1 " .
//                             "and c.categories_id = ptc.category_id " .
//                             "and ptc.category_id = cd.categories_id " .
//                             "and ptc.product_type_id not in  " . $this->document_types_list . "
                       " and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                         order by c.parent_id, c.sort_order, cd.categories_name";

Regardless of which menu you use replace the code above with this:

        $categories_query = "select c.categories_id, cd.categories_name, c.parent_id
                                        from " . TABLE_CATEGORIES . " c LEFT JOIN "
                                        . TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
                                        . TABLE_CATEGORIES_DESCRIPTION . " cd
                                        where (h.visibility_status < 2 OR h.visibility_status IS NULL)
                                        and c.categories_id = cd.categories_id
                                        and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                        and c.categories_status != '0'
                                        order by c.parent_id, c.sort_order, cd.categories_name";

This should hide your hidden categories from the menu.

...so for anyone else who needs to do this.

I found the correct syntax in the site map file.

$categories_query = "select c.categories_id, cd.categories_name, c.parent_id
from " . TABLE_CATEGORIES . " c LEFT JOIN "
. TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
. TABLE_CATEGORIES_DESCRIPTION . " cd
where (h.visibility_status < 2 OR h.visibility_status IS NULL)
and c.categories_id = cd.categories_id
and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and c.categories_status != '0'
order by c.parent_id, c.sort_order, cd.categories_name";


Yee-Haw

You should also post this in the support threads for the mod you are modifying as this is code to modify two menu modules to work with hideCategories and as such, it will probably be more useful posted there..

[jkalland]

Also, if you want the menu bar to hide categories flagged as "hidden from main menus" instead of just "hidden", change the < 2 to < 1 as such:

$categories_query = "select c.categories_id, cd.categories_name, c.parent_id
from " . TABLE_CATEGORIES . " c LEFT JOIN "
. TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
. TABLE_CATEGORIES_DESCRIPTION . " cd
where (h.visibility_status < 1 OR h.visibility_status IS NULL)
and c.categories_id = cd.categories_id
and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and c.categories_status != '0'
order by c.parent_id, c.sort_order, cd.categories_name";