| 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/litsolide.com/ |
Upload File : |
<?php
//****************************************************************************************//
//************************************* Configuration ************************************//
//****************************************************************************************//
// Chargement fichiers de configuration.
require('libs/Smarty.class.php');
// Démarrage du moteur TPL.
$smarty = new Smarty;
// Chargement des Fonctions Globals.
require_once('fonctions.php');
//****************************************************************************************//
//***************************** Fonction tri des categories ******************************//
//****************************************************************************************//
///////////////////////////////////////////////////////////// SEO CATEGORIES TRI
// Trouve la cat pour faire la selection du nombre de produit dispo dans la categorie et la marque
$seo_marq= $_GET['seo_marq'];
if ($seo_marq==''){ $seo_marq= $_POST['seo_marq']; }
$marq= $seo_marq;
if ($seo_marq==''){
$seo_marq= $_GET['seo'];
if ($seo_marq==''){ $seo_marq= $_POST['seo'];
}
$tableau_marq= explode ("-", $seo_marq);
$marq= $tableau_marq[0];
}
if ($right2 >0) {
// Chargement Fonction
require_once('marques_fonction_categories.php');
}
//****************************************************************************************//
//*************************************** Catégorie **************************************//
//****************************************************************************************//
$sql = $GLOBALS['bdd']->prepare('SELECT id, titre, text, name, caption, parent_id, picture, slideshow FROM marques
WHERE seo = :seo AND status = 1
ORDER BY position');
$sql->execute(array('seo' => $_GET['seo']));
$result = $sql->fetchAll();
$cat = $result[0]['id'];
$catSlide = $result[0]['slideshow'];
$parent = $result[0]['parent_id'];
$smarty->assign("category", $result[0]);
if ($parent > 0) {
$sql = $GLOBALS['bdd']->prepare('SELECT name, parent_id, seo FROM marques
WHERE id = :parent');
$sql->execute(array('parent' => $parent));
$result = $sql->fetchAll();
$name_parent = $result[0]['name'];
$smarty->assign("name_parent", $name_parent);
$name_seo = $result[0]['seo'];
$smarty->assign("name_seo", $name_seo);
}
//****************************************************************************************//
//********************************** Slideshow catégorie *********************************//
//****************************************************************************************//
$sql = $GLOBALS['bdd']->prepare('SELECT sp.name, sp.picture, sp.url, sp.target FROM slideshow_pictures sp
INNER JOIN slideshows s
ON sp.slideshow = s.id
WHERE s.status = 1 AND sp.status = 1 AND s.id = :catSlide
ORDER BY position');
$sql->execute(array('catSlide' => $catSlide));
$result = $sql->fetchAll();
$smarty->assign("pictures", $result);
//****************************************************************************************//
//******************************** Produits de la catégorie ******************************//
//****************************************************************************************//
// TRI PAR PRIX
if (isset($_POST['px_par_page'])) {
$qid = $bdd->prepare("UPDATE session SET px_par_page = :px_par_page WHERE session = :session");
$qid->execute(array('session' => $session, 'px_par_page' => $_POST['px_par_page']));
}
$sql = $GLOBALS['bdd']->prepare('SELECT px_par_page FROM session WHERE session = :session');
$sql->execute(array('session' => $session));
$result = $sql->fetchAll();
$px_par_page = $result[0]['px_par_page'] ;
if ($px_par_page =='') { $px_par_page = '1'; }
$px_par_page = $px_par_page ;
$smarty->assign('px_par_page',$px_par_page);
// NBRE D AFFICHAGE
if (isset($_POST['nb_affichage'])) {
$qid = $bdd->prepare("UPDATE session SET nb_affichage = :nb_affichage WHERE session = :session");
$qid->execute(array('session' => $session, 'nb_affichage' => $_POST['nb_affichage']));
}
$sql = $GLOBALS['bdd']->prepare('SELECT nb_affichage FROM session WHERE session = :session');
$sql->execute(array('session' => $session));
$result = $sql->fetchAll();
$nb_affichage = $result[0]['nb_affichage'] ;
if ($nb_affichage =='') { $nb_affichage = $cateo; }
$nb_affichage_par_page = $nb_affichage ;
$smarty->assign('nb_affichage_par_page',$nb_affichage_par_page);
//////////////////////////////////////////////////////////// PAGINATION
require_once('pagination_category.php');
//////////////////////////////////////////////////////////// PAGINATION
//****************************************************************************************//
//************************************** categories **************************************//
//****************************************************************************************//
// Compte les produits pour determiner le nombre de page...
// Lance bdd session list pour verifier si existe
$sql = $GLOBALS['bdd']->prepare('SELECT id FROM session_list2 WHERE session = :session');
$sql->execute(array('session' => $session));
$result = $sql->fetchAll();
if ($result[0]['id'] >0) { $ses_marq = "1"; }else { $ses_marq = "0"; }
$nb_total = 0;
if ($ses_marq > 0) {
$smarty->assign("inverser_ssmarque", "1");
$cpt = 0;
$res = $GLOBALS['bdd']->prepare('SELECT DISTINCT p.id FROM products p
INNER JOIN products_marques pm
ON pm.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
INNER JOIN session_list2 ss
ON ss.cha_var1 = pc.id_category
WHERE status = 1 AND pm.id_marque = :marq AND ss.session = :session
ORDER BY p.position');
$res->execute(array('marq' => $marq, 'session' => $session));
$columns = $res->fetchAll();
foreach ($columns as $col) {
$cpt = $cpt + 1 ;
}
$nb_total = $cpt;
$smarty->assign('nb_total',$nb_total);
} else {
$smarty->assign("inverser_ssmarque", "0");
$cpt = 0;
$res= $GLOBALS['bdd']->prepare('SELECT DISTINCT p.id FROM products p
INNER JOIN products_categories pc
ON pc.id_product = p.id
INNER JOIN products_marques pm
ON pm.id_product = p.id
INNER JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND pm.id_marque = :marq
GROUP BY p.id ORDER BY p.position ASC');
$res->execute(array('marq' => $marq));
$columns = $res->fetchAll();
foreach ($columns as $col) {
$cpt = $cpt + 1 ;
}
$nb_total = $cpt;
$smarty->assign('nb_total',$nb_total);
}
//////////////////////////////////////////////////////////// PAGINATION
if (!isset($_GET['debut'])) $_GET['debut'] = 0;
require('marques_affichage.php');
//////////////////////////////////////////////////////////// PAGINATION
// mysql_free_result ($sqlr);
//$barre_nav = barre_navigation($nb_total, $nb_affichage_par_page, $_GET['debut'], 8);
$barre_nav = barre_navigation($nb_total, $nb_affichage_par_page, $px_par_page, $_GET['debut'], 8);
$smarty->assign('barre_nav',$barre_nav);
//////////////////////////////////////////////////////////// PAGINATION
//****************************************************************************************//
//*********************** Categories enfants de la catégorie mere ***********************//
//****************************************************************************************//
$sql = $GLOBALS['bdd']->prepare('SELECT * FROM marques WHERE status = 1 AND parent_id = :cat ORDER BY position');
$sql->execute(array('cat' => $cat));
$result = $sql->fetchAll();
//echo '<pre>';
//var_dump($result);
//echo '</pre>';
$smarty->assign("marquess", $result);
// Efface la bdd session_list2 pour les categories...
$sql = $GLOBALS['bdd']->prepare('DELETE FROM session_list2 WHERE session = :session');
$sql->execute(array('session' => $session));
//*************************************** Affichage **************************************//
$smarty->display('marques.tpl');
?>