fetch_assoc()) {
$jc_no = (int) $jobcards['jc_no'];
$user_id = (int) $jobcards['user_id'];
$team_id = (int) $jobcards['team_assigned_id'];
/* 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_name = $team_res->fetch_assoc();
}
/* LAST ACTION */
$last_action = null;
$last_action_res = $db->query(
"jobcard_timeline",
"SELECT type, date_time FROM jobcard_timeline WHERE jobcard_id=$jc_no ORDER BY record_id DESC LIMIT 1"
);
if ($last_action_res) {
$last_action = $last_action_res->fetch_assoc();
}
?>