[engine] Add affiliate earnings to affiliate settings page minds#3946

Ticket(s) / Related Merge Requests

• Issue card: minds#3946 (closed)
• Front MR: front!2266 (merged)

Summary of Changes

Some fixes to the query that gets metrics for a user - changes by @fausto.arci

Testing Considerations

Test earnings show.

Deployment Considerations

Standard deployment.

Regression Scope

Affiliate earnings calculation.

Platform Affected (web, mobile, etc)

Engine.

Developer Testing Completed

Manual.

Screenshots / Screen Recording

N/A

Does this impact

• Localization
• Dark/light mode
• Guest mode

Definition of Done Checklist

• The Acceptance Criteria has been met
• Code is tested: Testing includes unit/spec, E2E/automated and manual testing
• Merge requests description has been filled out