<?php
$empty = new DateTime('00:00:00');
$inside = clone $empty;
$outside = clone $empty;
$rows = [
['date' => '10.06.2015', 'time' => '10:12:42', 'enter-exit' => 1],
['date' => '10.06.2015', 'time' => '10:27:48', 'enter-exit' => 0],
['date' => '10.06.2015', 'time' => '10:30:28', 'enter-exit' => 1],
['date' => '10.06.2015', 'time' => '12:28:06', 'enter-exit' => 0],
['date' => '10.06.2015', 'time' => '12:30:17', 'enter-exit' => 1],
['date' => '10.06.2015', 'time' => '13:49:41', 'enter-exit' => 0],
['date' => '10.06.2015', 'time' => '14:04:56', 'enter-exit' => 1],
['date' => '10.06.2015', 'time' => '14:57:06', 'enter-exit' => 0],
['date' => '10.06.2015', 'time' => '15:11:13', 'enter-exit' => 1],
['date' => '10.06.2015', 'time' => '16:14:14', 'enter-exit' => 0],
['date' => '10.06.2015', 'time' => '19:10:21', 'enter-exit' => 1],
['date' => '10.06.2015', 'time' => '19:21:38', 'enter-exit' => 0],
];
foreach ($rows as $row) {
$datetime = $row['date'] . ' ' . $row['time'];
$datetime = DateTime::createFromFormat('d.m.Y H:i:s', $datetime);
if ($row['enter-exit']) {
$enter = $datetime;
if (isset($exit)) {
$interval = $enter->diff($exit);
$outside->add($interval);
}
} else {
$exit = $datetime;
if (isset($enter)) {
$interval = $exit->diff($enter);
$inside->add($interval);
}
}
}
echo 'В офисе: ' . $empty->diff($inside)->format('%h:%I:%S') . '<br>';
echo 'Вне офиса: ' . $empty->diff($outside)->format('%h:%I:%S');
- Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- В офисе: 5:38:36<br>Вне офиса: 3:30:20
- Output for 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29
- Parse error: syntax error, unexpected '[' in /in/Rorl2 on line 7
Process exited with code 255. - Output for 5.0.0 - 5.0.5
- Parse error: parse error, unexpected '[' in /in/Rorl2 on line 7
Process exited with code 255. - Output for 4.4.2 - 4.4.9
- Parse error: syntax error, unexpected T_VARIABLE in /in/Rorl2 on line 4
Process exited with code 255. - Output for 4.3.0 - 4.3.1, 4.3.5 - 4.3.11, 4.4.0 - 4.4.1
- Parse error: parse error, unexpected T_VARIABLE in /in/Rorl2 on line 4
Process exited with code 255. - Output for 4.3.2 - 4.3.4
- Parse error: parse error in /in/Rorl2 on line 4
Process exited with code 255.
preferences:
384.61 ms | 401 KiB | 455 Q