1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
| (<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<?php include("menu.php");?>
<link rel="stylesheet" href="menu/dropdown_three.css" type="text/css">
<link rel="stylesheet" href="style.css" type="text/css">
<?php
include("include/db_inc_pdo.php");
?>
<table class="bicolor" border="1" align="center">
<tr>
<th>Date arrive</th>
<th>Date depart</th>
<th>Nb.</th>
<th>Nom</th>
<th>Prix location</th>
<th>Caution</th>
<th>1er paie.</th>
<th>Date.</th>
<th>2e paie.</th>
<th>Date</th>
<th>3e paie.</th>
<th>Date</th>
<th>Linge</th>
<th>Litbaby</th>
<th>Degats payes</th>
<th>Non paye</th>
<th>Remarques</th>
<th>Rest.</th>
<th>Date lettre</th>
<th>Appart</th>
<th>Tarifs</th>
<th>Desc.</th>
<th>Paragraphe sup.</th>
<th>Conf.</th>
<th>Enfants</th>
<th>Annulé</th>
</tr>
<?php
$reponse = $pdo->query('SELECT DATE_FORMAT( datearrive, "%d/%m/%Y" ) AS datea, DATE_FORMAT( datedepart, "%d/%m/%Y" ) AS dated, dateloca.nombre, dateloca.prixlocation, dateloca.caution, dateloca.1erpaiement AS apaiement, DATE_FORMAT( date1erpaiement, "%d/%m/%Y" ) AS dateunp, dateloca.2epaiement AS bpaiement, DATE_FORMAT( date2epaiement, "%d/%m/%Y" ) AS datedeuxp, dateloca.3epaiement AS cpaiement, DATE_FORMAT( date3epaiement, "%d/%m/%Y" ) AS datetroisp, dateloca.linge, dateloca.litbaby, dateloca.degatspayes, dateloca.nonpaye, dateloca.remarques, dateloca.restitution, DATE_FORMAT( datelettre, "%d/%m/%Y" ) AS datel, dateloca.appart, dateloca.envoitarifs, dateloca.envoidescriptif, dateloca.paragraphesup, dateloca.confirmation, dateloca.enfants, dateloca.annul, locataires.nom
FROM dateloca
INNER JOIN locataires ON dateloca.idnoms = locataires.idnoms
WHERE locataires.reserve = "oui"
ORDER BY datearrive desc');
while ($donnees = $reponse->fetch())
{
//On affiche les données dans le tableau
echo "<tr>";
echo "<td> $donnees[datea] </td>";
echo "<td> $donnees[dated] </td>";
echo "<td> $donnees[nombre] </td>";
echo "<td> $donnees[nom] </td>";
echo "<td> $donnees[prixlocation] </td>";
echo "<td> $donnees[caution] </td>";
echo "<td> $donnees[apaiement] </td>";
echo "<td> $donnees[dateunp] </td>";
echo "<td> $donnees[bpaiement] </td>";
echo "<td> $donnees[datedeuxp] </td>";
echo "<td> $donnees[cpaiement] </td>";
echo "<td> $donnees[datetroisp] </td>";
echo "<td> $donnees[linge] </td>";
echo "<td> $donnees[litbaby] </td>";
echo "<td> $donnees[degatspayes] </td>";
echo "<td> $donnees[nonpaye] </td>";
echo "<td> $donnees[remarques] </td>";
echo "<td> $donnees[restitution] </td>";
echo "<td> $donnees[datel] </td>";
echo "<td> $donnees[appart] </td>";
echo "<td> $donnees[envoitarifs] </td>";
echo "<td> $donnees[envoidescriptif] </td>";
echo "<td> $donnees[paragraphesup] </td>";
echo "<td> $donnees[confirmation] </td>";
echo "<td> $donnees[enfants] </td>";
echo "<td> $donnees[annul] </td>";
echo "</td>";
echo "</tr>";
// echo $donnees['datearrive'] .$donnees['datedepart'] .$donnees['nom'] .$donnees['prenom'] . $donnees['nombre'] .$donnees['prixlocation'] .'<br />';
}
$reponse->closeCursor();
?> |
