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
|
$sql = mysqli_query($bdd,"SELECT * FROM Travail ORDER BY date ");
$nbreElements = 5; // tous les 5 éléments
$compteur = 0; // initialisation du compteur
$total = 0;
echo "<div class=\"compact\"><div class=\"contenu\"><div class=\"titre\">Semaine ss</div>";
echo "<table>";
echo "<tr>";
echo "<th>Date</th>";
echo "<th>Arrivée</th>";
echo "<th>pause</th>";
echo "<th>Départ</th>";
echo "<th>Total journée</th>";
echo "<th>Options</th>";
echo "</tr>";
$counter = 0;
while ($donnees = mysqli_fetch_assoc($sql)) {
$data[] = $donnees['total_journee'];
// $total = 0;
echo '<form method="post" id="semi" action="index.php?id='.$donnees['id'].'" enctype="multipart/form-data">';
echo '<input type="hidden" name="id" value="'.$donnees['id'].'">';
echo "<tr>";
echo "<td>".$donnees['Date']."</td>";
echo "<td>";
$counter = $counter + 1;
// ARRIVE
echo '<input id="moninput'.$counter.'" name="Matin" type="time" onKeyUp="afficher_span(event, this.value, '.$counter.');" value="'.$donnees['Matin'].'" style="display:none;"/>';
echo "<span id=\"monspan".$counter."\" onclick=\"afficher_input(this, '".$counter."')\">".$donnees['Matin']."</span></td>";
// PAUDE
echo "<td>";
echo '<input id="moninput1'.$counter.'" type="time" name="Midi" onKeyUp="afficher_span1(event, this.value, '.$counter.');" value="'.$donnees['Midi'].'" style="display:none;"/>';
echo "<span id=\"monspan1".$counter."\" onclick=\"afficher_input1(this, '".$counter."')\">".$donnees['Midi']."</span></td>";
// DEPART
echo "<td>";
echo '<input id="moninput2'.$counter.'" type="time" name="Soir" onKeyUp="afficher_span2(event, this.value, '.$counter.');" value="'.$donnees['Soir'].'" style="display:none;"/>';
echo "<span id=\"monspan2".$counter."\" onclick=\"afficher_input2(this, '".$counter."')\">".$donnees['Soir']."</span></td>";
// TOTAL
echo "<td>";
echo '<input type="text" id="moninput3'.$counter.'" name="total_journee" onKeyUp="afficher_span3(event, this.value, '.$counter.');" value="'.$donnees['total_journee'].'" style="display:none;"/>';
echo "<span id=\"monspan3".$counter."\" onclick=\"afficher_input3(this, '".$counter."')\">".$donnees['total_journee']."</span></td>";
echo '<td><input type="submit" id="submit" name="submit_modif" value="Enregistrer" /></td>';
echo "</tr>";
// $total_5 = $total_5 + $donnees['total_journee'];
$test = $donnees['total_journee'];
// echo $test."<br />";
$compteur++; // on incrémente le compteur
if($compteur % $nbreElements == 0){
echo "</table>";
foreach ($data as $time) {
list($heures, $minutes, $secondes) = explode(':', $time);
$total += $heures * 3600 + $minutes * 60 + $secondes;
}
echo floor($total / 3600) . ':' . ($total /60) % 60 . ':' . $total % 60;
$total++;
echo '</div></div>
<div class="compact"><div class="contenu"><div class="titre">Semaine</div>';
echo "<table>";
echo "<tr>";
echo "<th>Date</th>";
echo "<th>Arrivée</th>";
echo "<th>pause</th>";
echo "<th>Départ</th>";
echo "<th>Total journée</th>";
echo "<th>Options</th>";
echo "</tr>";
}
echo "</form>";
}
echo "</table>";
$total = 0;
foreach ($data as $time) {
list($heures, $minutes, $secondes) = explode(':', $time);
$total += $heures * 3600 + $minutes * 60 + $secondes;
}
echo floor($total / 3600) . ':' . ($total /60) % 60 . ':' . $total % 60;
echo "</div></div>"; |
Partager