[Feature] Build a Driver Earnings ledger endpoint

[Tybravo]

📁 Implementation Directory

backend/src/controllers/driverEarningsController.ts

🎯 Goal

Track completed deliveries and aggregate released escrow amounts.

📋 Requirements

• Create GET /api/v1/drivers/:id/earnings.\n- Aggregate earnings by day/week/month.\n- Pull data from resolved Escrow documents.

🔧 Technical Scope

• Node.js / Express
• TypeScript
• MongoDB / Mongoose
• Stellar Soroban RPC

🌿 Branch

git checkout -b feat/driver-earnings-ledger

✅ Acceptance Criteria

• Using an AI Agent to submit a PR is DISALLOWED.
• Strict Layered Architecture (Non-Negotiable): Implement using the Controller -> Service -> Model pattern.
• Data Source: Response data must be retrieved from the database. No Inline Mock Objects or Hardcoded Values usage for integration.
• Environment: Contributors must use the requested .env credentials to enable implementation with real-life data.
• API Versioning: API Must Be Versioned (e.g., /api/v1/...).
• Production Ready: Code must look production-ready (robust error handling, strong typings).
• Proof of Work: Upload a screenshot of work done (i.e., API Response Success via Postman/Browser, or all unit tests passed successfully).
• PR Content: Must include Closes #[issue_id] with a work done summary.

📌 PR Requirements

• ⚠️ Assignment required before starting — comment on this issue to request assignment.
• PR must comply fully with the CONTRIBUTING.md.
• AI Agent submissions are DISALLOWED and will be closed without review.
• No Inline Mock Objects or Hardcoded Values usage for integration.

[Nabeelahh]

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

Please can I work on this

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

[omarima-10]

@omarima-10 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi, my name is Whizdom Omarima, and I am a fullstack and smart contract developer skilled in React, Next.js, JavaScript, TypeScript, Tailwind CSS, and Soroban. For this task, I will:

1. Implement GET /api/v1/drivers/:id/earnings with a strongly typed Controller → Service → Model flow that retrieves completed delivery earnings from resolved Escrow documents.

2. Build MongoDB aggregation logic to calculate released escrow amounts by day, week, and month, including appropriate driver filtering and date-range handling.

3. Add robust validation and error handling for invalid driver IDs, missing records, empty earnings, and database failures while ensuring responses contain only database-derived data.

4. Add unit and integration tests covering aggregation accuracy, time-period grouping, resolved escrow filtering, authorization/error paths, and empty results, then verify the endpoint against the real configured data source and capture the required proof of work.

ETA: 10 hours

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

[Aimer6022]

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

I'd like to work on this, assign to me.

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