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
| //Affichage du tableau
echo "<table border='1'>
<caption><big>Solde de congés</big></caption>
<th>
<tr><td>Solde année précédente:</td></tr>
<tr><td>Solde année en cours:</td></tr>
<tr></tr>
<tr><th>Reste:</th></tr>
<tr><td>Vacances:</td></tr>
<tr><td>Recup:</td></tr>
<tr><td>RH:</td></tr>
<tr><td>RT:</td></tr>
<tr><td>Total:</td></tr>
<tr></tr>
<tr><td>Heures sup:</td></tr>
<tr><td>(en jours)</td></tr>
</th>";
while ($donnee=mysql_fetch_array($res))
{
$Nom=$donnee['Nom'];
$PreviousYear=$donnee['Solde_Vac_Previous_Year'];
$DuringYear=$donnee['Solde_vac_During_Year'];
$Recup=$donnee['Recup'];
$RT=$donnee['RT'];
$RH=$donnee['RH'];
$HeureSup=$donnee['Heures_Sup'];
$VacanceTot = $PreviousYear + $DuringYear;
$Total = $VacanceTot + $Recup + $RH + $RT;
$JourSup = $HeureSup / 24 ;
echo "<th>
<tr><th>$Nom</th><tr>
<td>$PreviousYear</td></tr>
<td>$DuringYear</td></tr>
<td></td></tr>
</tr>
<td>$VacanceTot</td></tr>
<td>$Recup</td></tr>
<td>$RH</td></tr>
<td>$RT</td></tr>
<td>$Total</td></tr>
</tr>
<td>$HeureSup</td></tr>
<td>$JourSup</td></tr>
</th>";
}
echo "</table>"; |