<?php
$pb=1;
$wvu="";
if($o=="N"){$wvu="WHERE vu!=0";}
if($o=="O"){$wvu="WHERE vu=0";}
include ('admin_pagetop.php');
echo "Consultation des devis";
include ('admin_pagemid.php');
//On compte  le nombre d'messages
$req_res1=$mysqli->query("SELECT * FROM $table_devis $wvu");
$nb_results=nbre($req_res1);
include ('admin_pagination1.php');
if($nb_results>0){
//On va chercher la liste des messages
//Initialisation du tableau
echo "$table
<tr><th>Action</th>
<th>Id</th>
<th>Nom</th>
<th>$Telephone</th>
<th>Email</th>
<th>Langue</th>
<th>Service</th>
<th>Poids</th>
<th>Départ</th>
<th>Destination</th>
<th>Date</th>
</tr>";
$messages=$mysqli->query("SELECT * FROM $table_devis $wvu ORDER BY id DESC LIMIT $start, $nb_results_p_page"); 
while($row=$messages->fetcharray()){
$did=$row['id'];
$dtemps=$row['temps'];
$dlang=$row['lang'];
$ids=$row['ids'];
$nom=$row['nom'];
$email=$row['email'];
$poidsq=$row['poids'];
$telephoneq=$row['telephone'];
$depart=$row['depart'];
$destination=$row['destination'];
$vu=$row['vu'];
$nom=stripslashes($nom);
$dtemps=datefr($dtemps);
if($o=="N"){$nlect="Pas vu!"; $alect="Voir!";}else{ $nlect="Vu!"; $alect="ReVoir!";}
//On remplit le tableau
echo "<tr>
<td><a href=?p=devis_voir&id=$did title='$alect'>$img_voir</a> <!--a title='Supprimer' href=?p=devis_suppr&id=$did>$img_suppr</a--></td>
<td>$did</td>
<td>$nom</td>
<td>$telephoneq</td>
<td>$email</td>
<td>$langd[$dlang]</td>
<td>$servicett[$ids]</td>
<td>$poidsq</td>
<td>$Destination_tab[$depart]</td>
<td>$Destination_tab[$destination]</td>
<td>$dtemps</td>
</tr>";
}
//Fermeture du tableau
echo "</table>";
}
//################   Suite Multipages ########################
include ('admin_pagination.php');
//######################### Fin multipages ###########################
include ('admin_pagebas.php');	
?>