[Feature]: Dashboard Analytics API

[SudiptaPaul-31]

🔍 Problem Statement

Description
Generate dashboard statistics to provide clients and freelancers with insights into contract activity and financial performance.

Metrics

• Active contracts count
• Completed contracts count
• Total earnings (sum of released escrow amounts)
• Escrow volume (sum of funds currently held in escrow)

Endpoint

• GET /api/dashboard/stats → Returns aggregated statistics for the authenticated user

Tasks

• Define database queries for active/completed contracts
• Calculate total earnings from released escrow transactions
• Calculate escrow volume from ongoing contracts
• Build API response schema with metrics and metadata
• Add caching or optimization for performance
• Write unit tests for query logic and endpoint responses

Acceptance Criteria

• API returns accurate statistics for the authenticated user
• Endpoint documented for frontend integration
• Metrics update automatically with contract/escrow changes
• Graceful error handling for query failures
• Unit tests pass for all metrics and endpoint logic

📈 Expected Impact

High — Would significantly improve user experience

[Adesam007-pr3dator]

@Adesam007-pr3dator has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi, I would like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Adesam007-pr3dator to this issue.

[SimpleX-T]

@SimpleX-T has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Can I work on this?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @SimpleX-T to this issue.

[mrteeednut007-dotcom]

@mrteeednut007-dotcom has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

hy maintainer
am active and this is it what i love doing kindly assign this issue to me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @mrteeednut007-dotcom to this issue.

[coder45oj]

@coder45oj has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I would like to apply for this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @coder45oj to this issue.

[amosleoamadi]

@amosleoamadi has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I would love to work on this please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @amosleoamadi to this issue.

[drips-wave]

Congratulations, @mrteeednut007-dotcom! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @mrteeednut007-dotcom: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊