add_styles_page();
$db = new db_safeguard();
/*
Teams ordered by ACTIVE jobcards DESC
*/
$teams_res = $db->query(
"teams",
"
SELECT
t.record_id,
t.name,
COUNT(j.record_id) AS active_jobs
FROM teams t
LEFT JOIN jobcards j
ON j.team_assigned_id = t.record_id
AND j.status = 0
AND NOT EXISTS (
SELECT 1
FROM jobcard_timeline jt
WHERE jt.jobcard_id = j.record_id
AND jt.status = 1
)
WHERE t.status = 'ACTIVE'
GROUP BY t.record_id, t.name
ORDER BY active_jobs DESC, t.name ASC
"
);
?>
ACTIVE JOBCARDS BY TEAM