[SOLVED] Get products with reduced price instead of home featured

[bloggus]

Would like to change the home featured to show only products with reduced price OR products on sale.

 

Is that possible to alter the fuction call of

 

$category->getProducts .......

 

in any way?

[Loc Nguyen]

yeah,

i have the same problem.

now i would like to add 1 more block like Featured Products, but get on sale products,

 

i think that i should make new module ( copy from feature product home page module) then change the code that load the list from on sale product instead of featured products?

 

or did we have any module like that?

 

sorry for my bad english.

thanks

[bloggus]

Ok, to answer myself on one of these ....

 

... for reduced price products I can use

 

Product::getPricesDrop((int)($params['cookie']->id_lang));

 

Yes, Loc, I to made a copy of homefeatured with some changes to get a block with reduced price items.

[Loc Nguyen]

thanks,

i mean that i just want to get the ON SALE products.

 

have u ever get ON SALE products like FEATURED PRODUCTS on HOme page.

thanks,

[Loc Nguyen]

ok,

now i got it, with some change of code and querry.

thanks

[bloggus]

No I don't list SALEs products, it is enough with the one that have price reduction.

 

So you had to change whole query? There was no function you could use?

 

Want to share it with us?

[Loc Nguyen]

sure!

first, now i have a Featured Product ( homefeature module ), and i want a Onsale Products with the same style on Home page.

 

and this is some stupid steps that i had done ^^ :

1/ i make a new function in Product.php

 

. static public function getNewProducts1 {} (copied from function getNewProducts )

. change the query in new function getnewproducts1

WHERE `active` = 1

AND p.`on_sale` = true

=> and now you have a function to get all of Onsave product

2/ i duplicate the module homefeature -> homeonsale

change name for install module : homeonsale

3/ change the function hook Home on homesale.php

function hookHome($params)

{

global $smarty;

$nbProducts = intval(Product::getNewProducts1(intval($cookie->id_lang), isset($p) ? intval($p) - 1 : NULL, isset($n) ? intval($n) : NULL, true));

 

$smarty->assign(array(

'products' => Product::getNewProducts1(intval($params['cookie']->id_lang), 0, 10, false, $orderBy, $orderWay),

'nbProducts' => intval($nbProducts)));

return $this->display(__FILE__, 'homeonsale.tpl');

}

 

please take a look and give me your opinion.

thanks

[bloggus]

Thanks. WIll keep in in mind, although I'm trying to make modules without changing the core files. But good job otherwise!

[Flaviotti]

On 11/24/2011 at 5:17 AM, Loc Nguyen said:

sure!

first, now i have a Featured Product ( homefeature module ), and i want a Onsale Products with the same style on Home page.

 

and this is some stupid steps that i had done ^^ :

1/ i make a new function in Product.php

 

I would like to try the same. Which product.php file are you referring to? In my installation there are a few, placed in different folders.

In class/product.php, the function getNewProducts contains several lines of code. If that is the right file, is not clear to me where to make the changes in the query you have written. 

 

Edited January 4, 2020 by Flaviotti (see edit history)