add_styles_page();
$db = new db_safeguard();
$jobcards_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE status = 0 ORDER BY record_id DESC LIMIT 10");
$jobcard_sort = $jobcards_res->fetch_assoc();
?>
JOBCARDS
query("users", "SELECT * FROM users WHERE record_id = {$_SESSION['user_id']}");
$current_user = $current_user_res->fetch_assoc();
// echo $current_user['team_id'];
$current_user_team = $db->query("teams", "SELECT * FROM teams WHERE `team_members` LIKE '%{$current_user['username']},%'");
$team_ids = [];
while($current_team_team = $current_user_team->fetch_assoc())
{
$team_ids[] = "{$current_team_team['record_id']}";
}
// echo $current_team_team['record_id'];
$team_ids = implode(",", $team_ids);
$active_jobcards_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE `team_assigned_id` IN ($team_ids) AND `status` = 0 ORDER BY record_id DESC");
if ($active_jobcards_res->num_rows > 0) {
$team_res = $db->query("users", "SELECT * FROM users WHERE record_id = {$_SESSION['user_id']}");
$teams = $team_res->fetch_assoc();
$all_teams = $db->query("teams", "SELECT * FROM teams WHERE name = '{$teams['team_id']}'");
$curr_team = $all_teams->fetch_assoc();
$all_team_members = $curr_team['team_members'];
$team_assigned_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE team_assigned_id = '{$teams['username']}'");
$team_assigned = $team_assigned_res->fetch_assoc();
$members = explode(",", $all_team_members);
$members = array_map('trim', $members);
$usernames_list = "'" . implode("','", $members) . "'";
$team_members_res = $db->query("users", "SELECT * FROM users WHERE username IN ($usernames_list) AND record_id = {$_SESSION['user_id']}");
$mem = $team_members_res->fetch_assoc();
$session_username_res = $db->query("users", "SELECT * FROM users WHERE record_id = {$_SESSION['user_id']}");
$session_username = $session_username_res->fetch_assoc();
if ($mem['username'] == $session_username['username']) {
$data_table = '';
while ($active_jobcards = $active_jobcards_res->fetch_assoc()) {
?>