| 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('service_ticket_timeline', '*', "service_ticket_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 | {$interval->format('%h:%i')} |
";
}
if ($timeline['status'] == 'completed') {
echo "| Total Work Hours | Hours: " . round($total_hours, 2) . " |
";
}
}
?>