Last Modified Products on Home Page

[thomaska]

Hi,

 

I have a request to show on home page the last modified products. Even if the user shop owner change the price, or the quantity must be shown in home page. In order to do that i have made the following changes:

1. Copy the Product.php from classes in override/classes and inside the file i create a new function the following one in order to get the last modified products.

 

----------------------------------------------------------------------------------------------------------------------------------

/**

* Get last modified products

*

* @param integer $id_lang Language id

* @param integer $pageNumber Start from (optional)

* @param integer $nbProducts Number of products to return (optional)

* @return array Last modified products

*/

public static function getLastModifiedProducts($id_lang, $page_number = 0, $nb_products = 10,

$count = false, $order_by = null, $order_way = null, Context $context = null)

{

if (!$context)

$context = Context::getContext();

 

$front = true;

if (!in_array($context->controller->controller_type, array('front', 'modulefront')))

$front = false;

 

if ($page_number < 0) $page_number = 0;

if ($nb_products < 1) $nb_products = 10;

if (empty($order_by) || $order_by == 'position') $order_by = 'date_upd';

if (empty($order_way)) $order_way = 'DESC';

if ($order_by == 'id_product' || $order_by == 'price' || $order_by == 'date_add'  || $order_by == 'date_upd')

$order_by_prefix = 'p';

else if ($order_by == 'name')

$order_by_prefix = 'pl';

if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))

die(Tools::displayError());

 

$groups = FrontController::getCurrentCustomerGroups();

$sql_groups = (count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1');

if (strpos($order_by, '.') > 0)

{

$order_by = explode('.', $order_by);

$order_by_prefix = $order_by[0];

$order_by = $order_by[1];

}

if ($count)

{

$sql = 'SELECT COUNT(p.`id_product`) AS nb

FROM `'._DB_PREFIX_.'product` p

'.Shop::addSqlAssociation('product', 'p').'

WHERE product_shop.`active` = 1

AND product_shop.`date_upd` > "'.date('Y-m-d', strtotime('-'.(Configuration::get('PS_NB_DAYS_NEW_PRODUCT') ? (int)Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY')).'"

'.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').'

AND p.`id_product` IN (

SELECT cp.`id_product`

FROM `'._DB_PREFIX_.'category_group` cg

LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)

WHERE cg.`id_group` '.$sql_groups.'

)';

return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);

}

 

$sql = new DbQuery();

$sql->select(

'p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`,

pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name,

product_shop.`date_upd` > "'.date('Y-m-d', strtotime('-'.(Configuration::get('PS_NB_DAYS_NEW_PRODUCT') ? (int)Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY')).'" as new'

);

 

$sql->from('product', 'p');

$sql->join(Shop::addSqlAssociation('product', 'p'));

$sql->leftJoin('product_lang', 'pl', '

p.`id_product` = pl.`id_product`

AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl')

);

$sql->leftJoin('image', 'i', 'i.`id_product` = p.`id_product`');

$sql->join(Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1'));

$sql->leftJoin('image_lang', 'il', 'i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang);

$sql->leftJoin('manufacturer', 'm', 'm.`id_manufacturer` = p.`id_manufacturer`');

 

$sql->where('product_shop.`active` = 1');

if ($front)

$sql->where('product_shop.`visibility` IN ("both", "catalog")');

$sql->where('product_shop.`date_upd` > "'.date('Y-m-d', strtotime('-'.(Configuration::get('PS_NB_DAYS_NEW_PRODUCT') ? (int)Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY')).'"');

$sql->where('p.`id_product` IN (

SELECT cp.`id_product`

FROM `'._DB_PREFIX_.'category_group` cg

LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)

WHERE cg.`id_group` '.$sql_groups.'

)');

$sql->groupBy('product_shop.id_product');

 

$sql->orderBy((isset($order_by_prefix) ? pSQL($order_by_prefix).'.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way));

$sql->limit($nb_products, $page_number * $nb_products);

 

if (Combination::isFeatureActive())

{

$sql->select('MAX(product_attribute_shop.id_product_attribute) id_product_attribute');

$sql->leftOuterJoin('product_attribute', 'pa', 'p.`id_product` = pa.`id_product`');

$sql->join(Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.default_on = 1'));

}

$sql->join(Product::sqlStock('p', Combination::isFeatureActive() ? 'product_attribute_shop' : 0));

 

$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);

 

if ($order_by == 'price')

Tools::orderbyPrice($result, $order_way);

if (!$result)

return false;

 

$products_ids = array();

foreach ($result as $row)

$products_ids[] = $row['id_product'];

// Thus you can avoid one query per product, because there will be only one query for all the products of the cart

Product::cacheFrontFeatures($products_ids, $id_lang);

 

return Product::getProductsProperties((int)$id_lang, $result);

}

--------------------------------------------------------------------------------------------------------------------------------

 

2. Copy the NewProductController.php from the ../controllers/front to ../override/controllers/front and i change in the InitContent() function the following

 

$this->orderBy = 'date_add'; change it to $this->orderBy = 'date_upd';

 

3. I had create a new module from the NewProducts Module and instead of calling the getNewProducts() function i am calling my function in section 1 above.

 

Finally i delete the class_index.php from the ../cache folder in order to refresh the cache

 

The result it wasn't what i was expecting to. It does give me a few newer products, i don't know how it select them, but unfortunatelly it does not show the latest modified. Before navigating on the site i had update the price of a product and i was expecting to see  it in home page, but unfortunatelly it does not.

 

Any help please??

[Sergio Martins]

Have you solved this?

[rocky]

An easier solution would be to change line 131 (in PrestaShop v1.6.1.6) of modules/homefeatured/homefeatured.php from:

				HomeFeatured::$cache_products = $category->getProducts((int)Context::getContext()->language->id, 1, ($nb ? $nb : 8), 'position');

to:

				HomeFeatured::$cache_products = $category->getProducts((int)Context::getContext()->language->id, 1, ($nb ? $nb : 8), 'date_upd', 'desc');

[zgredek]

@rocky thanks, thats work very well !

[xbart]

How to do it in 1.7 ? 

Thanks

[PrestaServicePro]

Hello, try to apply the product configuration like the image: https://jmp.sh/CEkKFof