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";
}
}
