🏆 Implement Leaderboard Feature

[sensasi-delight]

Build a Leaderboard system that highlights top-performing authors and posts.
Rankings should refresh monthly and showcase engagement (likes, comments, followers).

---

✅ Tasks

• Database / Logic

  • Define ranking rules (e.g., likes + comments = score).
  • Create queries to calculate top authors and top posts.
  • Store monthly snapshots for historical leaderboard tracking.

• UI/UX

  • Design Leaderboard page with two tabs: Top Authors and Top Posts.
  • Show rank, avatar, name, and score for authors.
  • Show rank, post title/preview, and score for posts.
  • Add highlight/badge for Top 3 positions.

• Fullstack Implementation

  • Implement server logic for fetching leaderboard data.
  • Integrate monthly refresh/reset mechanism.
  • Ensure efficient queries to avoid performance issues.

• Testing & QA

  • Unit tests for score calculation.
  • Integration tests for leaderboard queries.
  • UI tests for leaderboard display and tab switching.

---

🏁 Acceptance Criteria

• Leaderboard page shows Top Authors and Top Posts.
• Rankings are based on engagement (likes + comments).
• Data refreshes monthly (old data archived for history).
• Clear and engaging UI with badges for Top 3.
• Performance remains smooth even with many users/posts.