[WEB-5871] chore: added intake count for projects

[sangeethailango]

Description

This PR will show the intake count for projects

Below is the number of queries the project list endpoint hits with the added logic to fetch the intake count. Tested with more than hundreds of intake issues and no N+1 queries.

Type of Change

• [x] Improvement (change that would cause existing functionality to not work as expected)

Summary by CodeRabbit

• New Features

  • Projects now include an intake issue count in API responses and project data.
  • Sidebar navigation shows a right-aligned intake badge when a project has pending intake issues.
  • Intake counts update automatically as inbox issues are created, deleted, or their status changes, keeping badges and counts in sync.

• Chores

  • Project types updated to include an optional intake_count field.

_{✏️ Tip: You can customize this high-level summary in your review settings.}