query(
"jobcards",
"
SELECT *
FROM jobcards
WHERE status = 0
AND team_assigned_id = '" . $team_id . "'
ORDER BY jc_no DESC
"
);
if ($res->num_rows === 0) {
echo "No active jobcards";
exit;
}
/* ===== SHOW ALL ACTIVE JOBCARDS ===== */
while ($jc = $res->fetch_assoc()) {
/* Get latest timeline entry */
$timeline_res = $db->query(
"jobcard_timeline",
"
SELECT status
FROM jobcard_timeline
WHERE jobcard_id = {$jc['record_id']}
ORDER BY record_id DESC
LIMIT 1
"
);
$timeline = $timeline_res->fetch_assoc();
/* Skip completed jobcards */
if ($timeline && $timeline['status'] == 1) {
continue;
}
?>
Jobcard #
num_rows > 0 && !isset($jc)) {
echo "No active jobcards";
}