//Proposer au visteur de vider son panier :
echo '<tr><th colspan="4" id="titre_tableau">VOTRE PANIER</th><td colspan="1"><a href="?action=vider">Vider le panier</a></td></tr>';
echo "<tr><th>Photo</th><th>Article</th><th>Quantité</th><th>Prix TTC</th><th>Action</th></tr>";
//Condition : si le panier est vide :
if (empty($_SESSION['panier']['id_article'])) {
echo '<tr><td colspan="10" id="empty_cart">Votre panier est vide</td></tr>';
} else {
$i = 0;
for ($w = 0; $w < count($_SESSION['panier']['id_article']); $w++) {
$css_class = $i % 2 == 0 ? 'clair' : 'sombre';
echo '<tr class="' . $css_class . '">';
echo "<td><img class='img_articlePanier' src='" . $_SESSION['panier']['photo'][$w] . "' alt='" . $_SESSION['panier']['titre'][$w] . "' title='" . $_SESSION['panier']['titre'][$w] . "' ></td>";
echo "<td>" . $_SESSION['panier']['titre'][$w] . "</td>";
echo "<td>" . $_SESSION['panier']['quantite'][$w] . "</td>";
if ($_SESSION['panier']['id_promo'][$w] > 1) {
echo "<td>" . virgule($_SESSION['panier']['prix'][$w] - $_SESSION['panier']['prix'][$w] * ($_SESSION['panier']['reduction'][$w] / 100)) . " €</td>";
} else {
echo "<td>" . $_SESSION['panier']['prix'][$w] . " €</td>";
}
echo "<td><a href='?action=retirer&id_article=" . $_SESSION['panier']['id_article'][$w] . "'><img src='" . RACINE_SITE . "photo/suppr.png' alt='' title='Supprimer cet article'></a></td>";
echo "</tr>";
$i++;
}
echo "<tr class='border_stop'><td colspan='3'></td><th colspan='1' class='border_prix'>Sous total:</th><td colspan='1'>" . montantSousTotal() . " €</td></tr>";
}
echo "</table>";
if (utilisateurEstConnecte()) {
if (!empty($_SESSION['panier']['id_article'])) {
echo "<div><a id='return_btn' href='" . RACINE_SITE . "panier_adresse.php'>Passer à l'étape suivante</a></div>";
}
} else {
echo "<td style='width: 150px;'>" . virgule($details['prix']) . "</td>";
$j++;
}
echo '</tr>';
}
echo '</table>';
echo "</div>";
$nbcol = $resultat->field_count;
echo "<table style='border-color:red;' border=10> <tr>";
echo '<th>N° de commande</th>';
echo '<th>Montant</th>';
echo '<th>Nom Prénom du membre</th>';
echo '<th>Date</th>';
echo "<th>Supression</th>";
echo "</tr>";
$i = 0;
while ($ligne = $resultat->fetch_assoc()) {
$membre_id2 = executeRequete("SELECT nom, prenom FROM membre WHERE id_membre = '{$ligne['id_membre']}'");
$nom_membre2 = $membre_id2->fetch_assoc();
$css_class = $i % 2 == 0 ? 'clair' : 'sombre';
echo '<tr class="' . $css_class . '">';
echo "<td style='width: 150px;'><a href='" . RACINE_SITE . "admin/gestion_commande.php?action=0&id_commande={$ligne['id_commande']}'>" . $ligne['id_commande'] . "</a></td>";
echo "<td style='width: 150px;'>" . virgule($ligne['montant']) . "</td>";
echo "<td style='width: 150px;' data-tooltip='Membre n°{$ligne['id_membre']}'>" . $nom_membre2['nom'] . ' ' . $nom_membre2['prenom'] . "</td>";
echo "<td style='width: 150px;'>" . dateLongue($ligne['date'], 'no') . "</td>";
$i++;
echo '<td style="width: 150px;"><a href="?action=suppression&id_commande=' . $ligne['id_commande'] . '" OnClick="return(confirm(\'En êtes vous certain ?\'));"><img src="' . RACINE_SITE . 'photo/suppr.png" alt="" title="Supprimer cette commande"></a></td>';
echo '</tr>';
}
echo '</table>';
require_once '../inc/footer.inc.php';
function prixAvecPromo($idArticleEnProm)
{
$requeteProm = executeRequete("SELECT prix, reduction FROM article ar, promotion prom WHERE ar.id_promo = prom.id_promo AND ar.id_article = {$idArticleEnProm}");
$resultatProm = $requeteProm->fetch_assoc();
$prixPromotionFinal = $resultatProm['prix'] - $resultatProm['prix'] * ($resultatProm['reduction'] / 100);
return virgule(round($prixPromotionFinal, 2));
}
echo "<div class='imageArticle'>" . "<img src='{$resultat2['photo']}' height='120' alt='{$resultat2['titre']}' data-tooltip='Article n° {$resultat2['id_article']}''>" . "</div>";
echo "<p class='prixStats'>{$resultat2['prix']} €</p>";
echo "</div>";
}
echo '</div><br>';
$cinqMembresAchetentPlus = executeRequete("SELECT sexe, m.id_membre, montant FROM membre m, commande c WHERE c.id_membre = m.id_membre GROUP BY m.id_membre ORDER BY SUM(montant) DESC LIMIT 5");
echo '<div id="articleStats">';
echo '<h4>Top 5 des membres qui achètent le plus</h4>';
while ($resultat3 = $cinqMembresAchetentPlus->fetch_assoc()) {
$recupPseudoMembre = executeRequete("SELECT pseudo, ROUND(SUM(montant),2) AS total FROM membre m, commande c WHERE m.id_membre = c.id_membre AND c.id_membre='" . $resultat3['id_membre'] . "'");
if ($resultat3['sexe'] == 'f') {
while ($infos3 = $recupPseudoMembre->fetch_assoc()) {
echo "<div class='femme'>";
echo "<p class='pseudo_stats'>{$infos3['pseudo']}</p>";
echo "<p class='p_stats'>Somme totale dépensée :</p>";
echo "<p class='total_stats'>" . virgule($infos3['total']) . " €</p>";
echo "</div>";
}
}
if ($resultat3['sexe'] == 'm') {
while ($infos3 = $recupPseudoMembre->fetch_assoc()) {
echo "<div class='homme'>";
echo "<p class='pseudo_stats'>{$infos3['pseudo']}</p>";
echo "<p class='p_stats'>Somme totale dépensée :</p>";
echo "<p class='total_stats'>" . virgule($infos3['total']) . " €</p>";
echo "</div>";
}
}
}
echo '</div>';
require_once '../inc/footer.inc.php';
</div>
<div class="searchbar">
<form method="post" action="<?php
echo RACINE_SITE;
?>
recherche.php" >
<input type="search" name="requete" id="recherche" placeholder="Rechercher...">
</form>
</div>
<div id="panier">
<?php
compterArticles();
if (compterArticles() < 2) {
echo '<a href=" ' . RACINE_SITE . 'panier.php" class="nb_resa">' . compterArticles() . ' article <br/>' . virgule(montantSousTotal()) . ' €</a>';
} else {
echo '<a href=" ' . RACINE_SITE . 'panier.php" class="nb_resa">' . compterArticles() . ' articles <br/>' . virgule(montantSousTotal()) . ' €</a>';
}
?>
</div>
</div>
<div id="livraison_gratuite">
<div id="text_livraison">
<img src="<?php
echo RACINE_SITE;
?>
/photo/free_del.png" alt="" title="">
<p>Livraison gratuite à partir de 50€ d'achat ! C'est le moment d'en profiter !<p>
</div>
</div>
</header>
echo "<p class='subject_comm'>" . $threeLastComments['sujet'] . "</p>";
echo "<p class='comm_comm'>" . $threeLastComments['commentaire'] . "</p>";
echo "<a href='" . RACINE_SITE . "admin/gestion_avis.php?action=0#" . $threeLastComments['id_avis'] . "' class='link_comm'> >> Voir</a>";
echo "</div>";
echo '</div>';
}
echo '</div>';
echo '</div>';
echo '<div id="infos_droite">';
echo '<div id="chiffre_affaire">';
echo "<table>";
echo "<tr>";
echo '<th>Chiffre d\'affaires</th>';
echo "</tr>";
echo "<tr>";
echo "<td>" . virgule(round($ChiffreAffaires['somme'], 2)) . " €</td>";
echo "</tr>";
echo '</table>';
echo '</div>';
echo '<div id="current_promo">';
echo "<table>";
echo "<tr>";
echo '<th>Promotions en cours</th>';
echo "</tr>";
echo "<tr>";
echo "<td>" . $nbArticlesEnPromo . "</td>";
echo "</tr>";
echo '</table>';
echo '</div>';
echo '<div id="visites">';
echo "<table>";
while ($article = $donnees->fetch_assoc()) {
$recup_promo = informationSurUnePromotion($article['id_article']);
$promotion = $recup_promo->fetch_assoc();
$calcul_note = executeRequete("SELECT ROUND(AVG(note)*2)/2 AS moyenne FROM avis WHERE id_article = {$article['id_article']}");
$note_final = $calcul_note->fetch_assoc();
echo '<div class="article">';
echo '<div class="note">';
imageNotation($note_final['moyenne']);
echo '</div>';
if ($article['id_promo'] == 1) {
echo '<div class="fond_prix">';
echo "<p>{$article['prix']} €</p>";
echo '</div>';
} else {
echo '<div class="fond_prixPromo">';
echo "<p><span class='old_price'>{$article['prix']}€</span> " . virgule(prixAvecPromo($article['id_article'])) . "€</p>";
echo '</div>';
}
echo "<a href='fiche_article.php?id_article={$article['id_article']}&categorie={$article['categorie']}'><img src='{$article['photo']}' alt='{$article['titre']}' class='img_article'></a>";
echo "<h3>{$article['titre']}</h3>";
if (utilisateurEstConnecte()) {
echo "<form method='post' action='" . $url . "'>";
echo "<input type='hidden' name='id_article' value='{$article['id_article']}'>";
echo "<input type='hidden' name='quantite' value='1'>";
echo '<input type="submit" name="ajout_panier" value="" class="bouton btn_ajoutPanierFA btn_connect" data-tooltip="Ajouter au panier">';
echo '</form>';
echo "<a href='fiche_article.php?id_article={$article['id_article']}&categorie={$article['categorie']}' class='bouton btn_ficheDetails' data-tooltip='Voir la fiche du produit'></a>";
echo "<form method='post' action='wishlist.php'>";
echo "<input type='hidden' name='id_article' value='{$article['id_article']}'>";
echo '<input type="submit" name="ajout_wishlist" value="" class="bouton btn_wishlist" data-tooltip="Ajouter au favoris">';
echo '</form>';
