stevenlee87 6c19aefc71 feat(roles): sort user list by role rank and username ...

优化 GET /api/roles/users 用户列表的排序：
- 主排序：按角色等级 皇帝 → 公爵 → 骑士 → 平民（无角色用户排最后）
- 次排序：用户名长度（短者优先）
- 末排序：用户名字母序（大小写不敏感）
- 查询由 db.query.users.findMany（relational）改为显式 select + leftJoin，
  以支持基于角色名的 CASE 排序

Sort the user list returned by GET /api/roles/users:
- Primary: by role rank Emperor -> Duke -> Knight -> Civilian (users
  without a role sort last)
- Secondary: username length (shorter first)
- Tertiary: username alphabetical order (case-insensitive)
- Switch the query from db.query.users.findMany (relational) to an explicit
  select + leftJoin to enable CASE-based ordering on role name

2026-07-30 22:09:33 +08:00

..

init-emperor

feat: Enhance role management by adding role assignment functionality and checks for existing roles

2024-12-28 17:50:47 +08:00

promote

feat: Implement OpenAPI with API Key authentication and role-based access control

2025-02-10 11:25:25 +08:00

users

feat(roles): sort user list by role rank and username

2026-07-30 22:09:33 +08:00