I am creating a table for calculating employee hours, but I am not able to calculate to see if the correct amount of hours worked has been worked on the day.
The database looks like this:
Thesitewilllooklikethis:
In the last column, under "Working Hours", you need to enter the calculation result for Input 1 (Start of day), Output 1 (Lunch), Input 2 (Return from Lunch) and Output 2 (end of day) p>
I used this select to get all the data in the table:
SELECT p.id_ponto, p.tb_user_id_user, p.tb_ponto_mes_id_ponto_mes, p.dia_ponto, p.dt_entrada1, p.dt_saida1, p.dt_entrada2, p.dt_saida2, u.id_user, u.nm_user
FROM tb_ponto p
INNER JOIN tb_user u on u.id_user = p.tb_user_id_user
I'm displaying values like this:
echo '<tr><td>' . $item["nm_user"] . '</td>' .
'<td>' . $item["dia_ponto"] . '/' . $item["tb_ponto_mes_id_ponto_mes"] . '/2017' . '</td>' .
'<td>' . $item["dt_entrada1"] . '</td>' .
'<td>' . $item["dt_saida1"] . '</td>' .
'<td>' . $item["dt_entrada2"] . '</td>' .
'<td>' . $item["dt_saida2"] . '</td>' .
'<td>8 Horas</td></tr>';
How can I calculate this?