| |
|
|
|
|
|
";
$moyenne = mysql_query("SELECT AVG(NOTE) FROM com_notes where ID_PROD='$ART' AND VALIDE='OUI' ORDER BY DATE DESC limit 10");
$moyenne = mysql_result($moyenne,0);
$moyenne= number_format($moyenne, 0, '.', ' ');
$sqlOPTC = "SELECT * FROM com_notes where ID_PROD='$ART' AND VALIDE='OUI' ORDER BY DATE DESC limit 10";
$sqlOPTC = mysql_query($sqlOPTC, $link);
$COPTC = mysql_num_rows($sqlOPTC);
if ($COPTC > "1") { $COMP="$COPTC Commentaires"; } else { $COMP="$COPTC Commentaire"; }
$nbouny=$moyenne/2;
if ($nbouny >= "0" AND $nbouny <= "0.49"){ $STARIMG=" "; }
if ($nbouny >= "0.50" AND $nbouny <= "0.99"){ $STARIMG=" "; }
if ($nbouny >= "1" AND $nbouny <= "1.49"){ $STARIMG=" "; }
if ($nbouny >= "1.5" AND $nbouny <= "1.99"){ $STARIMG=""; }
if ($nbouny >= "2" AND $nbouny <= "2.49"){ $STARIMG=""; }
if ($nbouny >= "2.5" AND $nbouny <= "2.99"){ $STARIMG=""; }
if ($nbouny >= "3" AND $nbouny <= "3.49"){ $STARIMG=""; }
if ($nbouny >= "3.5" AND $nbouny <= "3.99"){ $STARIMG=""; }
if ($nbouny >= "4" AND $nbouny <= "4.49"){ $STARIMG=""; }
if ($nbouny >= "4.5" AND $nbouny <= "4.99"){ $STARIMG=""; }
if ($nbouny == "5"){ $STARIMG=""; }
if ($AVIS=="OUI") { echo "$STARIMG"; }
if ($AVIS=="OUI") {
echo "
|
 |
"; }
if ($AVIS=="NON") {
echo "
|
"; }
echo "
| "; if ($AVIS=="OUI") { echo "$COMP"; } echo " |
";
if ($CID=="") {
echo "
 |
Ajouter à mes favoris |
";
} else {
$sqlCCOMF = "SELECT * FROM com_favoris where PROD_FAV='$ART' AND CLIENT='$CID'";
$sqlCCOMF = mysql_query($sqlCCOMF, $link);
$CCOMF = mysql_num_rows($sqlCCOMF);
if ($CCOMF=="0") {
echo "
|
Ajouter à mes favoris |
";
} else {
echo "
|
Retirer ce produit de mes favoris |
"; }}
if ($CID=="") { } else {
if ($DOWNLOAD=="") { } else {
$requete_LOAD = "SELECT * FROM com_com_detail WHERE DET_REF='$ART'";
$resultat_LOAD = mysql_query($requete_LOAD);
while($ligne_LOAD=mysql_fetch_array($resultat_LOAD)) {
$DET_ID = "{$ligne_LOAD['DET_ID']}";
$requete_LOAD2 = "SELECT * FROM com_commandes WHERE COM_ID='$DET_ID' AND COM_CLIENT='$CID' AND COM_STATUT='VALIDE'";
$resultat_LOAD2 = mysql_query($requete_LOAD2);
while($ligne_LOAD2=mysql_fetch_array($resultat_LOAD2)) {
$COM_ID = "{$ligne_LOAD2['COM_ID']}";
$OKURL="OK"; }}
if ($OKURL=="OK") {
echo "
|
|
 |
Télécharger le fichier |
"; }}}
echo "
|
|
| |
";
if ($IMG_2=="") { } else { echo " "; }
if ($IMG_3=="") { } else { echo " "; }
if ($IMG_4=="") { } else { echo " "; }
if ($IMG_5=="") { } else { echo " "; }
echo "
|
|
|
";
if ($FICHE=="") {
if ($CONTENU=="") {
echo "
|
|
";
} else {
echo "
|
|
";
}} else {
if ($CONTENU=="") {
echo "
|
|
";
} else {
echo "
|
|
"; }}
echo "
|
";
if ($FI=="AVIS" OR $FI=="COM") { } else {
if ($FI=="DESC" OR $FI=="") {
echo "
| |
Description :
$DETAIL
|
"; }
if ($FI=="FICHE") {
if ($FICHE=="") { } else {
echo "
| |
Fiche technique de l'article :
$FICHE
|
"; }}
if ($FI=="CONTENU") {
if ($CONTENU=="") { } else {
echo "
| |
Contenu de l'article :
$CONTENU
|
"; }}}
if ($AVIS=="OUI") {
if ($FI=="COM") {
$requete = "SELECT * FROM com_notes where ID_PROD='$ART' AND VALIDE='OUI' order by DATE DESC LIMIT $NBS_AVIS";
$resultat = mysql_query($requete);
$i=1;
while($ligne=mysql_fetch_array($resultat)) {
$CLIENT = "{$ligne['CLIENT']}";
$DATE = "{$ligne['DATE']}";
$NOTE = "{$ligne['NOTE']}";
$PSEUDO = "{$ligne['PSEUDO']}";
$COMMENTAIRE = "{$ligne['COMMENTAIRE']}";
$DATEFR=substr($DATE,8,2)."/".substr($DATE,5,2)."/".substr($DATE,0,4);
$HEUREFR=substr($DATE,11,2)."h".substr($DATE,14,2);
$COMMENTAIRESTR = str_replace("\r\n", "
", "$COMMENTAIRE");
if ($CID=="$CLIENT") { $MPLO="Supprimer votre commentaire !"; } else { $MPLO="Le $DATEFR à $HEUREFR"; }
$nbouny2=$NOTE/2;
if ($nbouny2 >= "0" AND $nbouny2 <= "0.49"){ $STARIMG2=""; }
if ($nbouny2 >= "0.50" AND $nbouny2 <= "0.99"){ $STARIMG2=""; }
if ($nbouny2 >= "1" AND $nbouny2 <= "1.49"){ $STARIMG2=""; }
if ($nbouny2 >= "1.5" AND $nbouny2 <= "1.99"){ $STARIMG2=""; }
if ($nbouny2 >= "2" AND $nbouny2 <= "2.49"){ $STARIMG2=""; }
if ($nbouny2 >= "2.5" AND $nbouny2 <= "2.99"){ $STARIMG2=""; }
if ($nbouny2 >= "3" AND $nbouny2 <= "3.49"){ $STARIMG2=""; }
if ($nbouny2 >= "3.5" AND $nbouny2 <= "3.99"){ $STARIMG2=""; }
if ($nbouny2 >= "4" AND $nbouny2 <= "4.49"){ $STARIMG2=""; }
if ($nbouny2 >= "4.5" AND $nbouny2 <= "4.99"){ $STARIMG2=""; }
if ($nbouny2 == "5"){ $STARIMG2=""; }
echo "
| |
|
| |
| |
$STARIMG2
|
$NOTE/10 |
| |
$COMMENTAIRESTR |
|
| |
|
| |
|
"; }}}
if ($FI=="COM") {
$sqlCCOM = "SELECT * FROM com_notes where ID_PROD='$ART' AND VALIDE='OUI'";
$sqlCCOM = mysql_query($sqlCCOM, $link);
$CCOM = mysql_num_rows($sqlCCOM);
if ($CCOM=="0") {
echo "
| |
Aucun commentaire n'a été donné pour ce produit !
|
"; }}
if ($ACTION=="START") {
if ($COMPSEUDO=="") { $COLORPSEUDO="#FF0000"; } else { $COLORPSEUDO="#808080"; }
if ($COMCOM=="") { $COLORCOM="#FF0000"; } else { $COLORCOM="#808080"; }
} else {
$COLORPSEUDO="#808080";
$COLORCOM="#808080"; }
if ($FI=="ADDCOM") {
if ($CID=="") {
print "";
} else {
if ($ACTION=="START") { if ($COMPSEUDO=="") { } else { if ($COMCOM=="") { } else {
$sql_avis = "SELECT * FROM com_notes where ID_PROD='$ART' AND CLIENT='$CID'";
$sql_avis = mysql_query($sql_avis, $link);
$compt_avis = mysql_num_rows($sql_avis);
if ($compt_avis=="0"){
$DATETIME=date("Y-m-d H:i:s");
$DATEFR=substr($DATETIME,8,2)."/".substr($DATETIME,5,2)."/".substr($DATETIME,0,4);
$HEUREFR=substr($DATETIME,11,2)."h".substr($DATETIME,14,2);
if ($MAIL_AVIS=="OUI") {
$sql = "SELECT * FROM com_produits where ID='$ART'";
$sql = mysql_query($sql, $link);
$ligne=mysql_fetch_array($sql);
$TITRE=$ligne['TITRE'];
$MAIL_COM="
Inscription
| |
Commentaire de $COMPSEUDO le $DATEFR à $HEUREFR |
|
| |
Vous avez reçu un nouveau commentaire sur $TITRE |
|
";
$sujetcom="Nouveau commentaire sur $BOUTIQUE";
mail($CONTACT,"$sujetcom",$MAIL_COM,"From: $BOUTIQUE<$CONTACT>\r\nContent-Type: text/html; charset=\"iso-8859-1\"\r\n"); }
$sql = "INSERT INTO com_notes VALUES('$ART','$CID','$DATETIME','$COMNOTE','$COMPSEUDO','$COMCOM','$VALID_AVIS')";
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error());
if ($VALID_AVIS=="OUI") { print ""; }
if ($VALID_AVIS=="NON") { print ""; }
} else {
print "";
}}}}
if ($AVIS=="OUI") {
$sql_avis = "SELECT * FROM com_notes where ID_PROD='$ART' AND CLIENT='$CID'";
$sql_avis = mysql_query($sql_avis, $link);
$compt_avis = mysql_num_rows($sql_avis);
if ($compt_avis=="0"){
echo "
|
|
";
if ($FI=="DELCOM") {
$sql = "DELETE FROM com_notes where ID_PROD='$ART' AND CLIENT='$CID'";
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error());
print ""; }
if ($ADD=="FAVORIS") {
if ($CID=="") { print "";
} else {
$sql_pro = "SELECT * FROM com_produits where ID='$ART'";
$sql_pro = mysql_query($sql_pro, $link);
$compt_pro = mysql_num_rows($sql_pro);
if ($compt_pro=="0"){
print "";
} else {
$sql_avis = "SELECT * FROM com_favoris where PROD_FAV='$ART' AND CLIENT='$CID'";
$sql_avis = mysql_query($sql_avis, $link);
$compt_avis = mysql_num_rows($sql_avis);
if ($compt_avis=="0"){
$DATETIME=date("Y-m-d H:i:s");
$sqlFAV = "INSERT INTO com_favoris VALUES('$ART','$CID','$DATETIME')";
mysql_query($sqlFAV) or die('Erreur SQL !'.$sqlFAV.'
'.mysql_error());
print "";
} else {
print "";
}}}}
if ($DEL=="FAVORIS") {
$sql = "DELETE FROM com_favoris where PROD_FAV='$ART' AND CLIENT='$CID'";
mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error());
print "";
}
require("footer.php");
?> | |
