feat: 排行榜新增筛选功能

[ding113]

排行榜的用户排行，希望新增按用户标签或分组进行筛选的功能。

[github-actions]

Thank you for this feature suggestion.

Feasibility assessment:

This feature is feasible and aligns well with the existing architecture. The codebase already has the necessary infrastructure to support filtering by user tags.

Existing infrastructure:

1. User tags field - The users table already has a tags field (src/drizzle/schema.ts:44):

   tags: jsonb('tags').$type<string[]>().default([]),

2. Provider group field - Users also have a providerGroup field (src/drizzle/schema.ts:42) that could be used for group-based filtering.

3. Current leaderboard implementation - The user leaderboard query is in src/repository/leaderboard.ts:151-191 (findLeaderboardWithTimezone function). It currently groups by userId and userName without any tag/group filtering.

4. Frontend filter pattern - The leaderboard view (src/app/[locale]/dashboard/leaderboard/_components/leaderboard-view.tsx) already implements a similar filter pattern for provider type filtering (lines 93-98, 363-369), which can serve as a reference for implementing user tag/group filters.

5. API endpoint - The leaderboard API (src/app/api/leaderboard/route.ts) already supports query parameters for filtering (e.g., providerType), so adding userTag or providerGroup parameters would follow the same pattern.

Implementation considerations:

• Database query modification: The findLeaderboardWithTimezone function would need to accept optional tags or providerGroup parameters and add corresponding WHERE conditions
• API parameter handling: Add new query parameters (userTag, providerGroup) to the /api/leaderboard endpoint
• Frontend filter component: Create a filter component similar to ProviderTypeFilter for selecting user tags/groups
• i18n: New filter labels would need translations in all 5 supported languages

Dependencies:

• src/repository/leaderboard.ts - Query logic modification
• src/app/api/leaderboard/route.ts - API parameter handling
• src/app/[locale]/dashboard/leaderboard/_components/leaderboard-view.tsx - UI filter component
• src/lib/redis/leaderboard-cache.ts - Cache key updates to include filter parameters

---

Automated response from Claude AI