| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/tonnelles-sud-ouest.fr/ |
Upload File : |
<?php
/*
Module : Front-Office - Accueil
Date : Juin 2015
Version Shop : V15.6
Auteur : Guillaume MADIOT - Computer 64
*/
//****************************************************************************************//
//************************************* Configuration ************************************//
//****************************************************************************************//
// Chargement fichiers de configuration.
require('libs/Smarty.class.php');
// Démarrage du moteur TPL.
$smarty = new Smarty;
// Chargement des Fonctions Globals.
require('fonctions.php');
//****************************************************************************************//
//*************************************** Top ventes *************************************//
//****************************************************************************************//
$sql = $GLOBALS['bdd']->query('SELECT pa.id_attribute, p.id, p.meta_keywords, p.seo, p.name, p.price, p.discount, pp.picture, p.hstock, p.h_achat_direct, p.stock, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
WHERE p.status = 1 AND pp.position = 1 AND (SELECT COUNT(*) FROM orders_products WHERE id_product = p.id) > 0
ORDER BY (SELECT COUNT(*) FROM orders_products WHERE id_product = p.id) DESC LIMIT 48');
$result = $sql->fetchAll();
$smarty->assign("products", $result);
//*************************************** Affichage **************************************//
$smarty->display('bestsellers.tpl');
?>