/**
* @param resource &$db reference to database handler
**/
public static function getAll(&$db, $whereClause = null, $column = null, $orderBy = null, $detailLevel = self::TLOBJ_O_GET_DETAIL_FULL)
{
$tables = tlObject::getDBTables('rights');
$sql = " SELECT id FROM {$tables['rights']} ";
if (!is_null($whereClause)) {
$sql .= ' ' . $whereClause;
}
$sql .= is_null($orderBy) ? " ORDER BY id ASC " : $orderBy;
return tlDBObject::createObjectsFromDBbySQL($db, $sql, 'id', __CLASS__, true, $detailLevel);
}
function getAllUsersRoles(&$db, $order_by = null)
{
$tables = tlObject::getDBTables(array('users', 'roles'));
$sql = "SELECT users.id FROM {$tables['users']} users " . " LEFT OUTER JOIN {$tables['roles']} roles ON users.role_id = roles.id ";
$sql .= is_null($order_by) ? " ORDER BY login " : $order_by;
$users = tlDBObject::createObjectsFromDBbySQL($db, $sql, "id", "tlUser", false, tlUser::TLOBJ_O_GET_DETAIL_MINIMUM);
$loop2do = count($users);
$specialK = array_flip((array) config_get('demoSpecialUsers'));
$demoModeEnabled = config_get('demoMode');
for ($idx = 0; $idx < $loop2do; $idx++) {
$users[$idx]->isDemoSpecial = $demoModeEnabled ? isset($specialK[$users[$idx]->login]) : false;
}
return $users;
}
public static function getAll(&$db, $whereClause = null, $column = null, $orderBy = null, $detailLevel = self::TLOBJ_O_GET_DETAIL_FULL)
{
$tables = tlObject::getDBTables("roles");
$sql = "SELECT id FROM {$tables['roles']} ";
if (!is_null($whereClause)) {
$sql .= ' ' . $whereClause;
}
$sql .= is_null($orderBy) ? " ORDER BY id ASC " : $orderBy;
$roles = tlDBObject::createObjectsFromDBbySQL($db, $sql, 'id', __CLASS__, true, $detailLevel);
$inheritedRole = new tlRole(TL_ROLES_INHERITED);
$inheritedRole->name = "<inherited>";
$roles[TL_ROLES_INHERITED] = $inheritedRole;
return $roles;
}
function getAllUsersRoles(&$db, $order_by = null)
{
$tables = tlObject::getDBTables(array('users', 'roles'));
$sql = "SELECT users.id FROM {$tables['users']} users " . " LEFT OUTER JOIN {$tables['roles']} roles ON users.role_id = roles.id ";
$sql .= is_null($order_by) ? " ORDER BY login " : $order_by;
$users = tlDBObject::createObjectsFromDBbySQL($db, $sql, "id", "tlUser", false, tlUser::TLOBJ_O_GET_DETAIL_MINIMUM);
return $users;
}
