/** * @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; }