function getAll()
{
SecurityUser::requirePermission("VIEW");
$sql = "SELECT * from security_user";
$result = Database::query($sql);
$all = array();
while ($line = $result->next()) {
array_push($all, SecurityUser::build($line));
}
return $all;
}
function getMembers() {
SecurityGroup::requirePermission("VIEW");
$id = $this->id;
$sql = "SELECT security_user.*
FROM security_group_member, security_user
WHERE security_group_member.user_id = security_user.id
AND security_group_member.group_id = ".Database::sqlValue($id);
//print $sql;
$result = Database::query($sql);
$members = array();
while ($line = $result->next()) {
array_push($members, SecurityUser::build($line));
}
return $members;
}
function getNonMembers() {
SecurityGroup::requirePermission("VIEW");
$id = $this->id;
$query = "SELECT su.*
FROM security_user AS su
LEFT JOIN security_group_member AS sgm
ON sgm.user_id = su.id AND sgm.group_id = ".Database::sqlValue($id)."
WHERE sgm.user_id IS NULL";
if ($this->debug) print $query;
$result = Database::query($query);
$members = array();
while ($line = $result->next()) {
array_push($members, SecurityUser::build($line));
}
return $members;
}
