ÿØÿà JFIF ` ` ÿþxØ
| 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/cp-admin/ |
Upload File : |
<?php
include_once('includes/header.php');
$id_volet ="65";
include('includes/volet.php');
/****************************/
if (isset($_GET['online'])) {
$id = $_GET['online'];
$bdd->exec("UPDATE " . $GLOBALS['db_table']['avis'] . " SET status = 1 WHERE id = $id");
echo '<script>';
echo 'window.location = "./avis2_lecture.php"';
echo '</script>';
}
//////////////////////////////////////////////////////////// PAGINATION
require_once('pagination_fonction.php');
//////////////////////////////////////////////////////////// PAGINATION
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>Lecture complète des Avis</h1>
<div class="pull-right">
<a href="avis2.php" class="btn btn-primary"><i class="icon-arrow-left"></i> Lecture résumé</a>
</div>
<br />
Classement par les numéros de commande décroissants
<br />
</div>
</div>
</div>
<table class="table table-bordered table-striped">
<thead>
<tr>
<th class="span1 center" style="">N.Cde</th>
<th class="span2 center">Appréciation</th>
<th class="span3 center">commentaire</th>
<th class="span1 center">Actions</th>
</tr>
</thead>
<tbody>
<?php
$comptc = 0;
//////////////////////////////////////////////////////////// PAGINATION
$res = $GLOBALS['bdd']->query("SELECT count(id) AS nb_total FROM avis WHERE date_insere >'0000-00-00' AND id_parent ='0' ");
$columns = $res->fetch();
$nb_total = $columns['nb_total'];
//////////////////////////////////////////////////////////// PAGINATION
if (!isset($_GET['debut'])) $_GET['debut'] = 0;
$nb_affichage_par_page = $commeo;
//////////////////////////////////////////////////////////// PAGINATION
$requete = $bdd->query("SELECT * FROM avis WHERE date_insere >'0000-00-00' AND id_parent ='0'
ORDER BY orders DESC LIMIT ".$_GET['debut'].",".$nb_affichage_par_page." ");
if ($row = $requete->fetch()) {
do {
// Colore les cellules tableau
/****************************/
$comptc = $comptc + 1;
if ($comptc % 2 == 1)
{
$collo = "background:#ddd; border:1px solid #fff"; $collo2 = "background:#ddd; border:1px solid #fff;border:1px solid #fff; border-top:0;border-bottom:0";
}
elseif ($comptc % 2 == 0)
{
$collo = "background:#fff; border:1 solid #ddd"; $collo2 = "background:#fff; border:1px solid #ddd;border:1px solid #fff; border-left:1px solid #ddd;border-top:0;border-bottom:0";
}
// Trouve si eest parent et trouve la reponse
/***********************************************/
$par = $row['id_parent'];
$idd = $row['id'];
$sqlpma = $GLOBALS['bdd']->query('SELECT * FROM avis
WHERE id_parent= '.$idd.'');
$coma = $sqlpma->fetch();
$reponse= $coma['comment'];
?>
<tr>
<td class="center" style="<?php echo$collo2 ?>"><br /><br />
<b><?php echo stripcslashes($row['orders']) ?></b>
</td>
<td class="center" style="<?php echo$collo ?>">
<b>
<?php
setlocale (LC_TIME, 'fr_FR.utf8','fra');
echo utf8_encode(strftime("%A %d-%m-%Y", strtotime($row['date_insere'])));
?> </b>
<br />
<?php
$comment = stripcslashes($row['comment']);
?>
<?php if ($row['etoiles'] =='1') { ?><img src="../templates/shop/img/etoile_1.png" height="60"/><?php } ?>
<?php if ($row['etoiles'] =='2') { ?><img src="../templates/shop/img/etoile_2.png" height="60"/><?php } ?>
<?php if ($row['etoiles'] =='3') { ?><img src="../templates/shop/img/etoile_3.png" height="60"/><?php } ?>
<?php if ($row['etoiles'] =='4') { ?><img src="../templates/shop/img/etoile_4.png" height="60"/><?php } ?>
<?php if ($row['etoiles'] =='5') { ?><img src="../templates/shop/img/etoile_5.png" height="60"/><?php } ?>
<br />
</td>
<td class="center" style="<?php echo$collo ?>">
<b><?php echo stripcslashes($row['title']) ?></b><br />
<?php echo stripcslashes($row['comment']) ?>
<br /> <b><i><?php echo $row['auteur'] ?></i></b>
</td>
<td class="center" style="<?php echo$collo ?>">
<?php if (empty($reponse)){ ?>
<br />
<?php
if($row['status'] == 0) { ?>
<a href="./avis2_lecture.php?online=<?php echo$row['id'] ?>" onclick="return confirm('Attention le blocage est irréversible ! Voir votre aide (bulle) !')"> <img src="assets/img/online.png" title="Bloquer"></a>
<?php }
else {
echo '<a href="#"><img src="assets/img/offline.png" title="Avis bloqué"></a>'; }
?>
<a href="avis2_reponse.php?retour=avis2_lecture.php&id=<?php echo $row['id']; ?>" title="Répondre" >
<img src="assets/img/edit.png">
</a>
<?php } ?>
</td>
</tr>
<?php if (!empty($reponse)){ ?>
<tr>
<td class="center" style="<?php echo$collo2 ?>">
<div style="margin-left:20%;margin-top:-30px"><img src="assets/img/fleche_angle.png" alt="" /></div><br /><br />
</td>
<td class="center" style="background:#FFFFCC; border:1 solid #fff;color:#cc3300">
<b><?php echo stripcslashes($coma['title']) ?></b> du : <br /><b>
<?php
setlocale (LC_TIME, 'fr_FR.utf8','fra');
echo utf8_encode(strftime("%A %d-%m-%Y", strtotime($coma['date_insere'])));
?> </b>
</td>
<td class="center" style="background:#FFFFCC; border:1 solid #fff;color:#cc3300">
<?php echo stripcslashes($coma['comment']) ?>
<br /> <b><i><?php echo $coma['auteur'] ?></i></b>
</td>
<td class="center" style="background:#FFFFCC; border:1 solid #fff;color:#cc3300">
</td>
</tr>
<?php
}
?>
<?php
}while ($row = $requete->fetch());
} else {
echo 'Aucun Avis à afficher !!!';
}
?>
</tbody>
</table>
<div class="pagin">
<?php
//////////////////////////////////////////////////////////// PAGINATION
//mysql_free_result ($requete);
echo '<b>'.barre_navigation($nb_total, $nb_affichage_par_page, $_GET['debut'], 8).'</b>';
// on lib?e l'espace m?oire allou?pour cette requ?e
// mysql_free_result ($resultat);
//////////////////////////////////////////////////////////// PAGINATION
?>
<br /><br />
</div>
</div>
<?php
include_once('includes/footer.php');
?>