69 lines
2.1 KiB
PHP
69 lines
2.1 KiB
PHP
<?php
|
|
|
|
class CrossSelling extends Module
|
|
{
|
|
function __construct()
|
|
{
|
|
$this->name = 'crossselling';
|
|
$this->tab = 'Products';
|
|
$this->version = 0.1;
|
|
|
|
parent::__construct();
|
|
|
|
$this->displayName = $this->l('Cross selling');
|
|
$this->description = $this->l('Customers who bought this product also bought...');
|
|
}
|
|
|
|
function install()
|
|
{
|
|
if (parent::install() == false OR !$this->registerHook('productFooter'))
|
|
return false;
|
|
return true;
|
|
}
|
|
|
|
/**
|
|
* Returns module content for left column
|
|
*/
|
|
function hookProductFooter($params)
|
|
{
|
|
global $smarty, $cookie, $link;
|
|
|
|
$orders = Db::getInstance()->ExecuteS('
|
|
SELECT o.id_order
|
|
FROM '._DB_PREFIX_.'orders o
|
|
LEFT JOIN '._DB_PREFIX_.'order_detail od ON (od.id_order = o.id_order)
|
|
WHERE o.valid = 1 AND od.product_id = '.intval($params['product']->id));
|
|
|
|
$list = '';
|
|
foreach ($orders AS $order)
|
|
$list .= intval($order['id_order']).',';
|
|
$list = rtrim($list, ',');
|
|
|
|
if ($list != '')
|
|
{
|
|
$orderProducts = Db::getInstance()->ExecuteS('
|
|
SELECT od.product_id, pl.name, pl.link_rewrite, p.reference, i.id_image
|
|
FROM '._DB_PREFIX_.'order_detail od
|
|
LEFT JOIN '._DB_PREFIX_.'product p ON (p.id_product = od.product_id)
|
|
LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (pl.id_product = od.product_id)
|
|
LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = od.product_id)
|
|
WHERE od.id_order IN ('.$list.') AND pl.id_lang = '.intval($cookie->id_lang).' AND od.product_id != '.intval($params['product']->id).' AND i.cover = 1
|
|
ORDER BY RAND()
|
|
LIMIT 10');
|
|
|
|
foreach ($orderProducts AS &$orderProduct)
|
|
{
|
|
$orderProduct['image'] = $link->getImageLink($orderProduct['link_rewrite'], intval($orderProduct['product_id']).'-'.intval($orderProduct['id_image']), 'medium');
|
|
$orderProduct['link'] = $link->getProductLink(intval($orderProduct['product_id']), $orderProduct['link_rewrite']);
|
|
}
|
|
|
|
$smarty->assign(array(
|
|
'orderProducts' => $orderProducts,
|
|
'middlePosition_crossselling' => round(sizeof($orderProducts) / 2, 0)
|
|
));
|
|
}
|
|
|
|
return $this->display(__FILE__, 'crossselling.tpl');
|
|
}
|
|
}
|