//ajout d'un avis
echo $avis_tpl_form;
break;
default:
case 'liste':
if ($log_ok && $allow_avis && $allow_avis_ajout) {
echo "<p align='right'><a href=\"avis.php?todo=add¬iceid={$noticeid}&login={$user_code}\">" . $msg[avis_lien_ajout] . "</a></p>";
}
//affichage de la liste des avis
//moyenne des notes
$sql = "select avg(note) as m from avis where valide=1 and num_notice='" . $noticeid . "' group by num_notice";
$r = pmb_mysql_query($sql, $dbh);
$loc = pmb_mysql_fetch_object($r);
$moyenne = number_format($loc->m, 1, ',', '');
$c_notice = new notice_affichage($noticeid, "");
$etoiles_moyenne = $c_notice->stars();
//liste des témoignages
$requete = "select note,sujet,commentaire,DATE_FORMAT(dateajout,'" . $msg['format_date'] . "') as ladate,empr_login,empr_nom, empr_prenom\n\t\t\t\tfrom avis\n\t\t\t\tleft join empr on id_empr=num_empr\n\t\t\t\twhere valide=1 and num_notice='" . $noticeid . "'\n\t\t\t\torder by dateajout desc";
$r = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($r)) {
echo "<div class='row'>\n\t\t\t\t\t<div class='left'><b>" . $msg['avis_titre_tous'] . ":</b> " . $msg['avis_note'] . ": {$moyenne}</div>\n\t\t\t\t\t<div class='right'>{$etoiles_moyenne}</div> \n\t\t\t\t\t</div>";
$cpt_star = 4;
while ($loc = pmb_mysql_fetch_object($r)) {
$etoiles = "";
for ($i = 1; $i <= $loc->note; $i++) {
$etoiles .= "<img border=0 src='" . get_url_icon('star.png') . "' align='absmiddle'>";
}
for ($j = round($loc->note); $j <= $cpt_star; $j++) {
$etoiles .= "<img border=0 src='" . get_url_icon('star_unlight.png') . "' align='absmiddle'>";
}
echo "<hr /><div class='row'>\n\t\t\t\t\t<div class='left'><b>{$loc->sujet}</b>, " . $loc->ladate;
