//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>';