public function getByRole($Role)
{
$RoleID = $Role;
// Optimistic
if (is_string($Role)) {
$RoleModel = new RoleModel();
$Roles = $RoleModel->getArray();
$RolesByName = array_flip($Roles);
$RoleID = val($Role, $RolesByName, null);
// No such role
if (is_null($RoleID)) {
return new Gdn_DataSet();
}
}
return $this->SQL->select('u.*')->from('User u')->join('UserRole ur', 'u.UserID = ur.UserID')->where('ur.RoleID', $RoleID, true, false)->orderBy('DateInserted', 'desc')->get();
}