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.jc_no) AS active_jobs
FROM teams t
LEFT JOIN jobcards j
ON j.team_assigned_id = t.record_id
AND j.status = 0
WHERE t.status = 'ACTIVE'
GROUP BY t.record_id
ORDER BY active_jobs DESC, t.name ASC
"
);
?>
ACTIVE JOBCARDS BY TEAM