fetch_assoc()) {
$jobcard_id = (int) $jobcards['record_id'];
$jc_no = (int) $jobcards['jc_no'];
$team_id = (int) $jobcards['team_assigned_id'];
/* ======================================================
SKIP COMPLETED JOBCARDS
====================================================== */
$complete_check = $db->query(
"jobcard_timeline",
"SELECT 1
FROM jobcard_timeline
WHERE jobcard_id = $jobcard_id
AND type = 'COMPLETE'
LIMIT 1"
);
if ($complete_check && $complete_check->num_rows > 0) {
continue;
}
/* ======================================================
TEAM
====================================================== */
$team_name = null;
$team_res = $db->query(
"teams",
"SELECT name
FROM teams
WHERE record_id = $team_id
AND status = 'ACTIVE'"
);
if ($team_res && $team_res->num_rows > 0) {
$team_name = $team_res->fetch_assoc()['name'];
}
/* ======================================================
LAST ACTION
====================================================== */
$last_action = null;
$last_action_res = $db->query(
"jobcard_timeline",
"SELECT type, date_time
FROM jobcard_timeline
WHERE jobcard_id = $jobcard_id
ORDER BY record_id DESC
LIMIT 1"
);
if ($last_action_res && $last_action_res->num_rows > 0) {
$last_action = $last_action_res->fetch_assoc();
}
/* ======================================================
STATE DETECTION
====================================================== */
$jobcard_state = 'normal';
$hours_since_last_action = null;
if ($last_action && !empty($last_action['date_time'])) {
$last_time = strtotime($last_action['date_time']);
$now = time();
$hours_since_last_action = ($now - $last_time) / 3600;
if ($hours_since_last_action >= $STALL_HOURS) {
$jobcard_state = 'stalled';
} elseif ($hours_since_last_action >= $WARNING_HOURS) {
$jobcard_state = 'warning';
}
}
?>