/**
* Gets all the usernames in the system
* @param PdoDatabase $database
* @param null|bool|string $filter If null, no filter. If true, active users only, otherwise provided status.
* @return string[]
*/
public static function getAllUsernames(PdoDatabase $database, $filter = null)
{
if ($filter === null) {
$userListQuery = "SELECT username FROM user;";
$userListResult = $database->query($userListQuery);
} elseif ($filter === true) {
$userListQuery = "SELECT username FROM user WHERE status IN ('User', 'Admin');";
$userListResult = $database->query($userListQuery);
} else {
$userListQuery = "SELECT username FROM user WHERE status = :status;";
$userListResult = $database->prepare($userListQuery);
$userListResult->execute(array(":status" => $filter));
}
return $userListResult->fetchAll(PDO::FETCH_COLUMN);
}
