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