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 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109
| $query="SELECT login FROM gpoint_personne WHERE dept='$id1'";
$result=mysql_query($query);
$nb=mysql_numrows($result);
echo "<div align='center'>";
echo "<br />";
echo "<table cellspacing='1' width='100%'>";
echo "<tr>";
$query_departement="select descriptif_departement from gpoint_departement where lettre_departement='$id1'";
$result_departement=mysql_query($query_departement);
$nom_departement=mysql_result($result_departement,"descriptif_departement");
echo "<h6 style='color:red'>$nom_departement</h6>";
echo "</tr>";
echo "<tr bgcolor='#B0C4DE' ALIGN='center' valign='middle' >";
//l'id
echo "<td>";
echo "<h6>Technicien / Personnel</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Product</h6>";
echo "</td>";
echo "<td>";
echo "<h6>RTT Perso </h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>RTT Direct</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Congès légaux</h6>";
echo "</td>";
echo "<td>";
echo "<h6>Congès Evt Fam</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Congès Ss solde</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Format.</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Qualité</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Maladie</h6></a>";
echo "</td>";
echo "<td>";
echo "<h6>Accident de travail</h6>";
echo "</td>";
echo "<td>";
echo "<h6>Absence non justifiée</h6>";
echo "</td>";
echo "<td>";
echo "<h6>Délégué CE-DP</h6>";
echo "</td>";
echo "<td>";
echo "<h6>Divers N.Prod</h6>";
echo "</td>";
echo "<td>";
echo "<h6>Admin Général</h6>";
echo "</td>";
echo "<td>";
echo "<h6>Total</h6>";
echo "</td>";
echo "</tr>";
for($i=0;$i<$nb;$i++){
$nom=mysql_result($result,$i,"login");
// ici le test de couleur pour modifier la couleur de la ligne
if($couleur==1){
echo "<tr bgcolor='#DDDDDD' ALIGN='center'>";
$couleur=0;
}
else{
echo "<tr bgcolor='#FFEBCD' ALIGN='center'>";
$couleur=1;
}
echo "<td>";
echo "$nom ";
echo "</td>";
echo "<td>";
echo "test ";
echo "</td>";
echo "<td>";
$query_rtt="select temps_pointage from gpoint_pointage where login='$nom' and dossier_pointage='RTT-P'";
$result_rtt=mysql_query($query_rtt);
$nb_rtt=mysql_numrows($result_rtt);
for($i=0;$i<$nb_rtt;$i++)
{
$rtt_p=mysql_result($result_rtt,$i,"temps_pointage");
echo "$rtt_p";
echo "</td>";
} |