function get_team_members($tl_id) { if (!check_supervisor($tl_id)) { return FALSE; } else { $sql = "SELECT user_id,username,fname,lname FROM users WHERE user_id IN (SELECT user_id FROM teams WHERE tl_id=" . $tl_id . ")"; //echo $sql; $result = $_SESSION['dbconn']->query($sql); return $result; } }
function add_hours($user_id, $tl_id, $amount, $payperiod = NULL) { if (!check_supervisor()) { $_SESSION['notifications'][] = "You are not a TL"; } if ($user_id == $tl_id) { $_SESSION['notifications'][] = "You cannot input hours for yourself"; } else { if ($payperiod == NULL) { $payperiod = current_payperiod(); } $sql = "INSERT INTO additional_hours (user_id,tl_id,amount) VALUES (" . $user_id . "," . $tl_id . "," . $amount . ")"; $_SESSION['dbconn']->query($sql) or die("Error adding hours: " . $_SESSION['dbconn']->error); $_SESSION['notifications'][] = "Additional Hours added!"; } }
function unmake_super($user_id) { //Check to make sure the user's a supervisor if (!check_supervisor($user_id)) { $_SESSION['notifications'][] = "Error, user is not a supervisor!"; } else { empty_team($user_id); $sql = "DELETE FROM app_supervisor WHERE user_id=" . $user_id; $result = $_SESSION['dbconn']->query($sql) or die("Error removing supervisor: " . $_SESSION['dbconn']->error); $_SESSION['notifications'][] = "Removed user from supervisors"; } }