Twitch Restrict Categories by Customer or Group

[nishajh]

Thank you for the great add-on.

I have having an issue with the new product & featured page. I have set up as a single product linked to multiple categories. For example if an item 1TW is linked to 3 categories and if I set it item a featured then I see that on the featured page this item is displayed three times. The page works fine if the item is only set to one category.
After looking in to the codes( I am not a good programmer) found that includes/pages/featured/header_php.php has the code. How do I make change in the query to take only one one row instead of three rows from TABLE_PRODUCTS_TO_CATEGORIES?

$featured_products_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,
p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping,
p.products_qty_box_status, p.master_categories_id
FROM ("
. TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m
on (p.manufacturers_id = m.manufacturers_id),
"
. TABLE_PRODUCTS_DESCRIPTION . " pd
LEFT JOIN " . TABLE_FEATURED . " f
on pd.products_id = f.products_id,
"
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c
LEFT JOIN " . TABLE_CATEGORIES_CUSTOMERS . " ccu
on p2c.categories_id = ccu.categories_id

)
WHERE p.products_status = 1
and p.products_id = f.products_id
and f.status = 1
AND p.products_id = pd.products_id
and pd.language_id = :languagesID
AND p.products_id = p2c.products_id

AND (ccu.customers_cat_group = '" . (int)$_SESSION['customers_cat_group'] . "' OR ccu.customers_cat_group = '0' )

" . $order_by;

Thanks so much for any help!

[Elemi]

Just wondering if this module is being upgraded to 1.5.7? :-)

[jsarwar]

This is not working for 1.5.6. In admin/categories.php file codes are very different. Do you have updated version of this?

[HeleneWallis]

Here's another person who would really like this to work with 1.5.6 and up.

[twitchtoo]

This module is being included in the next release of Twitch Wholesale PRO Public/Commercial for ZC 1.56c as the Twitch Bridge Matrix now handles product and category level relationships with customer groups using the new wsPRO Manager in Admin.

Release is pending imminently for Zen Cart 1.56c and will be next on the list for development into ZC 1.57c when funding/donations afford it.

Thanks for your support!

[nishajh]

Thank you for the great mod.

I am having an issue with this module in the mobile version.
1)
The sidebox categories box displays all the categories if a customer is not logged in. I want to hide the sidebox category when the customer is not logged in on mobile. Works fine on the Desktop version.

2) In the mobile version It shows all the categories when a customer is logged in ( means it is not hiding some categories based on the category group of the customer). Does not show the products through but shows category names and this defeats the purpose of hiding categories

Did anyone solve this issue? I have picture attached to show this. The first two categories are only for a specific group.

Thanks