how display products by Category & Type of discount?

[ysdoar]

Hello everyone

Is there a way to display products by 1. Category 2. Type of discount?

Maybe there is a code that i can add in a category view, or product details page, or a module that already exists and I do not know?

[ysdoar]

I'm trying to write some code I'd love some help ..

Perhaps the best idea is: add code to "category view", so I want to set to display only the products that have a valid discount.

so in : category/view.html.php    i added it:

Code Select Expand

// Load the products in the given category

$product .= ' vmpp.product_discount_id IS NOT NULL '

    $products = $productModel->getProductsInCategory($categoryId);
    $productModel->addImages($products,1);
    $this->assignRef('products', $products);