Enhanced "Interest" browsing

[ipapandinas]

Overview

Enhance the user experience by introducing a feature that allows users to browse trending categories over selected time frames. This feature is designed to help users discover new projects and challenges within their areas of interest efficiently.

This is done from a dedicated a new page at "/explore/categories". The page will include a toolbar with two dropdown filters for enhanced search functionality:

• Time Range Filter: Allows users to select between week, month, or year to view trending categories.
• Category Filter: Offers a comprehensive list of categories, mirroring the current selection options.

This addition aims to facilitate users in exploring the most active projects within a specified time frame and category, with a dynamic filtering slug format for easy navigation: "Most active projects this [TIME] in [CATEGORY]."

The display will feature a results table organized into three columns:

• Project: Project avatar including: organization logo/name and repository name.
• Categories: Other associated interest categories.
• Issues Created Count: Number of issues created within the selected timeframe and category.

How

• Develop a new page at "/explore/categories" for category-based exploration
• Design a three-column table to display projects, their categories, and the count of issues created
• Implement a toolbar equipped with time range and category filters for refined searches
• Enable dynamic slug creation that reflects the selected time range and category, following the pattern "most-active-projects-this-[TIME]-in-[CATEGORY]"
• Create a backend helper function to fetch and sort projects based on the number of issues in a given category and time range, ensuring the data can be sorted in ascending/descending order for user convenience