| date_time |
status |
user |
table {
width: 100%;
font-size:1vw;
}
th {
background-color: #4CAF50;
color: white;
}
tr:nth-child(even) {
background-color: #f2f2f2;
}
";
$timeline_res = $db->select_query('work_order_timeline', '*', "work_order_id = {$_GET['record_id']} ORDER BY record_id ASC");
while ($timeline = $timeline_res->fetch_assoc()) {
echo "| {$timeline['date_time']} | {$timeline['status']} | " . get_username($timeline['user_id']) . " |
";
if ($timeline['status'] == 'start') {
$start_date_time = $timeline['date_time'];
}
if ($timeline['status'] == 'stop') {
$stop_date_time = $timeline['date_time'];
$start = new DateTime($start_date_time);
$stop = new DateTime($stop_date_time);
$interval = $start->diff($stop);
$hours_difference = $interval->format('%h') + ($interval->format('%i') / 60);
$total_hours = isset($total_hours) ? $total_hours + $hours_difference : $hours_difference;
echo "| Work Hours Difference | {$interval->format('%h:%i')} |
";
}
if ($timeline['status'] == 'complete') {
echo "| Total Work Hours | Hours: " . round($total_hours, 2) . " |
";
}
if ($timeline['status'] == 'review_start') {
$start_date_time = $timeline['date_time'];
}
if ($timeline['status'] == 'review_stop') {
$stop_date_time = $timeline['date_time'];
$review_start = new DateTime($start_date_time);
$review_stop = new DateTime($stop_date_time);
$review_interval = $review_start->diff($review_stop);
$review_hours_difference = $review_interval->format('%h') + ($review_interval->format('%i') / 60);
$total_review_hours = isset($total_review_hours) ? $total_review_hours + $review_hours_difference : $review_hours_difference;
echo "| Review Hours Difference | {$review_interval->format('%h:%i')} |
";
}
if ($timeline['status'] == 'complete') {
echo "| Total Review Hours | Hours: " . round($total_review_hours, 2) . " |
";
}
}
?>