produits_achetes.php

Go to the documentation of this file.

<?php
// This file should be in UTF8 without BOM - Accents examples: éèê
// +----------------------------------------------------------------------+
// | Copyright (c) 2004-2015 Advisto SAS, service PEEL - contact@peel.fr  |
// +----------------------------------------------------------------------+
// | This file is part of PEEL Shopping 8.0.0, which is subject to an   |
// | opensource GPL license: you are allowed to customize the code           |
// | for your own needs, but must keep your changes under GPL                |
// | More information: https://www.peel.fr/lire/licence-gpl-70.html          |
// +----------------------------------------------------------------------+
// | Author: Advisto SAS, RCS 479 205 452, France, https://www.peel.fr/      |
// +----------------------------------------------------------------------+
// $Id: produits_achetes.php 46935 2015-09-18 08:49:48Z gboussin $
define('IN_PEEL_ADMIN', true);
include("../configuration.inc.php");
necessite_identification();
necessite_priv("admin_sales,admin_webmastering");


$GLOBALS['DOC_TITLE'] = $GLOBALS['STR_ADMIN_PRODUITS_ACHETES_TITLE'];
include($GLOBALS['repertoire_modele'] . "/admin_haut.php");

if (isset($_GET['id'])) {
     affiche_liste_clients_par_produit($_GET['id']);
} else {
     affiche_best_sell_products();
}

include($GLOBALS['repertoire_modele'] . "/admin_bas.php");

function affiche_best_sell_products($limit = 500)
{
     include("../lib/class/ProductsBought.php");
     $tpl = $GLOBALS['tplEngine']->createTemplate('admin_best_sell_products.tpl');
     $tpl_prods = array();
     $i = 0;
     foreach (ProductsBought::find_all() as $produit) {
          $req = query("SELECT COUNT(*) as nombre
               FROM peel_pensebete
               WHERE id_produit='" . intval($produit->produit_id) . "'");
          $pense_bete_nb = fetch_object($req);
          if (!isset($pense_bete_nb->nombre)) {
               $pense_bete_nb->nombre = 0;
          }
          $tpl_prods[] = array('tr_rollover' => tr_rollover($i, true),
               'lien' => $produit->lien,
               'nombre' => $pense_bete_nb->nombre,
               'quantite_totale' => $produit->quantite_totale,
               'prix' => fprix($produit->montant_total, true, $GLOBALS['site_parameters']['code'], false)
               );
          $i++;
     }
     $tpl->assign('prods', $tpl_prods);
     $tpl->assign('STR_ADMIN_PRODUITS_ACHETES_MOST_WANTED', $GLOBALS['STR_ADMIN_PRODUITS_ACHETES_MOST_WANTED']);
     $tpl->assign('STR_PRODUCT', $GLOBALS['STR_PRODUCT']);
     $tpl->assign('STR_ADMIN_PRODUITS_ACHETES_COUNT_IN_PREFERED', $GLOBALS['STR_ADMIN_PRODUITS_ACHETES_COUNT_IN_PREFERED']);
     $tpl->assign('STR_QUANTITY', $GLOBALS['STR_QUANTITY']);
     $tpl->assign('STR_AMOUNT', $GLOBALS['STR_AMOUNT']);
     echo $tpl->fetch();
}