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
| <?php
function getTime($val) {
$nbHour = floor($val / 3600);
$nbMin = str_pad(round(($val - $nbHour * 3600) / 60),2,0, STR_PAD_LEFT);
return $nbHour.'h'.$nbMin.'min';
}
$voirdate = "SELECT *,"
. "TIME_FORMAT(CAST(TIMEDIFF(arrive,depart_dejeuner) + TIMEDIFF(retour_dejeuner,sortie) AS TIME), '%Hh%imin') AS diff, "
. "DATE_FORMAT(ADDTIME(TIMEDIFF(depart_dej_t,entree_t),TIMEDIFF(sortie_t,retour_dej_t)),'%Hh%imin') AS working_time "
. "FROM pointage "
. "WHERE jour='".$_POST['jour']."' AND nom = '".$_POST['nom']."' "
. "ORDER BY service ASC";
$res = $db->query("SELECT *,
TIMESTAMPDIFF(SECOND,entree_t, depart_dej_t)+TIMESTAMPDIFF(SECOND,retour_dej_t,sortie_t) AS working_time
FROM pointage;");
if(isset($_POST['submit'])&&($_POST['jour'])&&($_POST['nom'])){
$voirdate = $db->query($voirdate);
while($rows = $voirdate->fetch(PDO::FETCH_ASSOC)){
echo "<tr><td>".date("d/m/Y", strtotime($rows['jour']))."</td>".
"<td style=\"background-color:#FFF;color:BLUE;font-weight:bold;\">".date("H:i", strtotime($rows['entree_t']))."</td>".
"<td style=\"background-color:#FFF;color:#FF0000;font-weight:bold;\">".date("H:i", strtotime($rows['arrive']))."</td>".
"<td style=\"background-color:#FFF;color:BLUE;font-weight:bold;\">".date("H:i", strtotime($rows['depart_dej_t']))."</td>".
"<td style=\"background-color:#FFF;color:#FF0000;font-weight:bold;\">".date("H:i", strtotime($rows['depart_dejeuner']))."</td>".
"<td style=\"background-color:#FFF;color:BLUE;font-weight:bold;\">".date("H:i", strtotime($rows['retour_dej_t']))."</td>".
"<td style=\"background-color:#FFF;color:#FF0000;font-weight:bold;\">".date("H:i", strtotime($rows['retour_dejeuner']))."</td>".
"<td style=\"background-color:#FFF;color:BLUE;font-weight:bold;\">".date("H:i", strtotime($rows['sortie_t']))."</td>".
"<td style=\"background-color:#FFF;color:#FF0000;font-weight:bold;\">".date("H:i", strtotime($rows['sortie']))."</td>".
"<td>".$rows['id']."</td>".
"<td>".$rows['nom']."</td>".
"<td>".$rows['prenom']."</td>".
"<td>".$rows['service']."</td>".
"<td style=\"background-color:#FFF;color:BLUE;font-weight:bold;\">"
.foreach ($res as $row) {
echo getTime($row['working_time']).
} ."</td>".
"<td style=\"background-color:#FFF;color:#FF0000;font-weight:bold;\">".$rows['diff']."</td></tr>";
}
} |
Partager